Sales Order¶
Attributes¶
salesOrderId: Primary key of the table.
soUid: Unique UUID generated by system.
buyerId: Foreign key of the VendorAndSupplier table. This field stores the information of the buyer details.
orgId: Foreign key of the Organisation table. This field stores the information of the organisation who created the sales order.
consigneeId: Foreign key of the VendorAndSupplier table. This field stores the information of the consignee details.
notifyPartyId: Foreign key of the VendorAndSupplier table. This field stores the information of the notify party 1 details.
notifyPartyId2: Foreign key of the VendorAndSupplier table. This field stores the information of the notify party 2 details.
soHeading: Heading of the sales order document.
soTotalAmount: Total amount of the sales order.
amountInWords: Amount in words.
soTotalQuantity:
currency: Currency of the sales order.
soDeliveryDate: Delivery Date of the sales order.
soDispatchDate: Dispatch date of the sales order.
deliveryInstructions: Delivery instructions of the sales order.
deliveryAddress: Delivery Address.
destinationPort: Destination Port.
destinationCountry: Destination country.
originPort: Origin Port.
originCountry: Origin Country.
documents: Terms & Conditions.
incoTerms: Inco terms.
incoTermsPlace: Inco terms place.
paymentTerms: Payment terms of the sales order.
orgOrderDate: Order Date.
orgOrderNo: Order No.
buyerPONo: Buyer Order No.
vendorCode: Vendor Code.
createdBy:
status: Status of the order.
importedDocUrl: URL of the S3 bucket where ocr file is uploaded.
ocrS3FolderUrl: URL of the S3 bucket folder where ocr result is stored.
numPages: Number of pages in the OCR document.
ocrStatus:
templateName: Name of the selected template.
otherData: JSON object to stores information about other data and customs fields associated to sales order.
contactPerson: JSON object to stores information about contact person.
bankDetailsInfo: JSON object to stores information about bank details where payment should be received.
portOfLoading: Port of loading information.
noOfPackagesDes: Number of packages description on sales order items table.
quantityDescription: Total Quantity description on sales order items table.
quantityPerPackDes: Quantity per package description on sales order items table.
unitPriceDes: Unit price description on sales order items table.
deliveryLabel: Delivery instructions label on sales order.
isNoOfPackagesVisible: Boolean value indicating whether Number of package is visible on template.
isQtyPerPackageVisible: Boolean value indicating whether Quantity per package is visible on template.
advanceAmount: Advance amount of the sales order.
advanceAmountDate: Date when advance amount was received against sales order.