Invoice Payment¶

Invoice Payment table stores information about payment received from buyer or payment made to seller in vendor bill.

invoicePaymentId: Primary key of the table.

invId: Foreign key of the Invoice table. This field stores the information of the invoice in which payment is recorded.

orgId: Foreign key of the Organisation table. This field stores the information of the Organisation in which payment is recorded.

paymentMadeBy: Foreign key of the User table. This field stores the information of the user who recorded payment.

dateOfPayment: This field stores information about date when payment was made.

currency: Currency in which payment was made.

amount: Payment amount that has been transferred in invoice currency.

remarks: Remark given by User for internal purpose.

bankCharges: Bank charges applied on transaction.

conversionRate: Conversion rate from invoice currency to local currency.

localCurAmount: Payment amount in local currency.

attachmentURL: URL Of the S3 bucket where the attachment is stored.

Invoice payment must always belongs any one Invoice.

Invoice payment must always belongs any one organisation.