Skip to content

Payment Schedule

This table stores information about individual payment which is scheduled to be received by/sent to vendor company.

Attributes

paymentScheduleId: Primary key of the table.

invId: Foreign key of Invoice table. This field stores the information of the invoice where schedule is being added.

orgId: Foreign key of Organisation table. This field stores the information of the organisation where payment schedule being added.

expAmount: Amount to be paid by vendor.

percentOfInvoice: Percentage of the invoice amount which will be paid by vendor.

expDateOfPayment: Expected date of payment to be received by vendor in case of invoice & payment to send to vendor in case of vendor bill.

currency: Currency of the invoice amount in which payment should be received by/sent to vendor.

Associations

Invoice

Payment always belongs any one Invoice.

Organisation

Payment schedule should always belongs to any one organisation.