Order Invoice mapping

Order Invoice mapping table stores information about linking between Invoice & Export Order and Vendor bill & Import Order.

Attributes

ordInvMapId: primary key of the mapping table.

invId: Foreign key of Invoice table. This field stores the information of the invoice to whom order is linked.

orgId: Foreign key of Organisation table. This field stores the information of the organisation in which linking happens.

salesOrderId: Foreign key of Sales Order table. This field stores the information of the order which is linked to invoice. This will be null if vendor bill is linked with purchase order.

purchaseOrderId: Foreign key of Purchase Order table. This field stores the information of the order which is linked to vendor bill. This will be null if invoice is linked with sales order.

---

Associations

Organisation

Order and invoice linking must always belongs any one organisation.

PurchaseOrder

Order and invoice linking must always belongs any one Import/Purchase Order.

SalesOrder

Order and invoice linking must always belongs any one Export/Sales Order.

Invoice

Order and invoice linking must always belongs any one Invoice.