Shipment Document

Shipment document stores information about Individual documents linked to shipment like Shipping bill, Export Order or invoice etc.

Note

Shipment can be linked to n number of import/export orders but always linked to single invoice, shipment document like shipping bill, bill of lading & bill of entry.

Attributes

shipmentDocumentId: primary key of the table.

orgId: Foreign key of Organisation table. This field stores the information of the organisation whose shipment is being linked with other document.

shipmentId: Foreign key of Shipment table. This field stores the information of the shipment with whom document is linked.

docUrl: URL of the document if uploaded to S3 bucket.

docType: Field that specifies which kind of document is being linked.

Possible values

1. INVOICE
2. VENDOR_BILL
3. SHIPPING_BILL
4. BILL_OF_LADING
5. BILL_OF_ENTRY
6. SALES_ORDER
7. PURCHASE_ORDER
8. OTHER (if folder is linked)

docOrigin: Type of the origin of the document like IMPORT or EXPORT.

purchaseOrderId: Foreign key of Import/Purchase order table. This field stores the information of the Import/Purchase order with whom shipment is linked.

salesOrderId: Foreign key of Export/Sales Order table. This field stores the information of the Export/Sales Order with whom shipment is linked.

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

shippingBillId: Foreign key of Shipping bill table. This field stores the information of the Shipping bill with whom shipment is linked.

billOfLadingId: Foreign key of Bill of lading table. This field stores the information of the Bill of lading with whom shipment is linked.

billOfEntryId: Foreign key of Bill of Entry table. This field stores the information of the Bill of Entry with whom shipment is linked.

folderId: Foreign key of folder table. This field stores the information of the folder with whom shipment is linked.

createdBy: Email id of the user who created the document linking.

createdByName: Name of the user who created the document linking.

docMeta: JSON object to stores information about other metaData like file name in case of file uploading.

---

Associations

Shipment

Shipment document always belongs any one Shipment.

Organisation

Shipment document always belongs any one Organisation.

PurchaseOrder

Shipment document always belongs any one Purchase Order.

SalesOrder

Shipment document always belongs any one Sales Order.

Invoice

Shipment document always belongs any one Invoice.

ShippingBill

Shipment document always belongs any one Shipping Bill.

BillOfLading

Shipment document always belongs any one Bill Of Lading.

BillOfEntry

Shipment document always belongs any one Bill Of Entry.