Purchase Order¶
Attributes¶
purchaseOrderId: Primary key of the table.
poUid: Unique UUID generated by system.
sellerId: Foreign key of the VendorAndSupplier table. This field stores the information of the seller details.
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.
orgId: Foreign key of the Organisation table. This field stores the information of the organisation who created the purchase order.
poHeading: Heading of the purchase order document.
poTotalAmount: Total amount of the purchase order.
poTotalQuantity:
currency: Currency of the purchase order.
poDeliveryDate: Delivery Date of the purchase order.
vendorCode: Vendor Code.
poDispatchDate: Dispatch date of the purchase order.
deliveryInstructions: Delivery instructions of the purchase order.
amountInWords: Amount in words.
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 purchase order.
orgOrderDate: Order Date.
orgOrderNo: Order No.
sellerSONo: Seller Order No.
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: OCR status.
templateName: Name of the selected template.
otherData: JSON object to stores information about other data and customs fields associated to purchase order.
contactPerson: JSON object to stores information about contact person.
bankDetailsInfo: JSON object to stores information about bank details where payment should be made.
portOfLoading: Port of loading information.
noOfPackagesDes: Number of packages description on purchase order items table.
quantityDescription: Total Quantity description on purchase order items table.
quantityPerPackDes: Quantity per package description on purchase order items table.
unitPriceDes: Unit price description on purchase order items table.
deliveryLabel: Delivery instructions label on purchase 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 purchase order.
advanceAmountDate: Date when advance amount was received against purchase order.