Invoice¶
Attributes¶
invId: Primary key of the table.
invUid: Unique UUID generated by system.
orgId: Foreign key of the Organisation table. This field stores the information of the organisation who created the invoice.
buyerId: Foreign key of the VendorAndSupplier table. This field stores the information of the buyer details.
consigneeId: Foreign key of the VendorAndSupplier table. This field stores the information of the consignee details for commercial invoice.
customsConsigneeId: Foreign key of the VendorAndSupplier table. This field stores the information of the consignee details for customs invoice.
notifyPartyId1: Foreign key of the VendorAndSupplier table. This field stores the information of the notify party 1 details for commercial invoice.
notifyPartyId2: Foreign key of the VendorAndSupplier table. This field stores the information of the notify party 2 details for commercial invoice.
customsNotifyPartyId1: Foreign key of the VendorAndSupplier table. This field stores the information of the notify party 1 details for customs invoice.
customsNotifyPartyId2: Foreign key of the VendorAndSupplier table. This field stores the information of the notify party 1 details for customs invoice.
invNo: Invoice Number.
invName:
invoiceType: Type of the document.
Note
- Invoice
- Vendor Bill
invoiceStatus: Status of the invoice.
dateOfInv: Date of invoice.
dueDate: Due date of the invoice.
expDeliveryDate: Expected delivery date of the invoice.
subtotalAmount: subtotal of the commercial invoice.
totalAmount: Grand total amount of the commercial invoice.
balanceAmount: Balance amount of the commercial invoice.
advanceAmount: Advance amount already received for the invoice.
advanceAmountLabel: Advance amount label.
advanceAmountDate: Date when advance Amount was received.
customsSubtotalAmount: Customs invoice subtotal amount.
customsTotalAmount: Customs invoice total amount.
amountInWords: Amount in words for invoice currency.
orderDate: Order Date.
orderNo: Order number.
currency: Currency of invoice.
discountValue: Discount amount on commercial invoice.
customsDiscountValue: Discount amount on customs invoice.
blNo: Bill of lading number.
blDate: Bill of lading date.
shippingBillNumber: Shipping bill number for commercial invoice.
shippingBillDate: Shipping Bill date for commercial invoice.
beNumber: Bill of entry number.
billOfEntryDate: Bill of entry date.
insuranceValue: Insurance value for invoice.
fobValue: FOB value.
freight: Frieght amount.
freightUnitPrice: Unit price for freight.
freightTotalQty: Freight total quantity.
cifValue: CIF value.
totalGrossWeight: Total gross weight for commercial invoice.
totalNetWeight: Total net weight for commercial invoice.
customsTotalGrossWeight: Total gross weight for customs invoice.
customsTotalNetWeight: Total net weight for customs invoice.
vesselNo: Vessel No.
containerNo: Container Number.
flightNo: Flight Number.
vesselName: Vessel Name.
paymentTerms: Payment terms of the invoice.
incoTerms: Inco terms.
incoTermsPlace: Inco terms place.
modeOfShipment: Mode of shipment.
seaContainerType: container type, applicable only mode of shipment is sea.
finalDestination: Final destination.
creditPeriod:
assignmentClause:
rexNumber: REX number only for commercial invoice.
rexClause: REX clause only for commercial invoice.
specialTerms:
meisClause:
originCountry: Origin Country.
portOfLoading: Port of loading.
destinationPort: Destination Port.
destinationCountry: Destination country.
voyageNo: Voyage number.
comment:
customsDeliveyInstruction: Delivery instructions for customs invoice.
customsPLDeliveyInstruction: Delivery instructions for customs packing list.
comPLDeliveyInstruction: Delivery instructions for commercial packing list.
comDelLabel: Commercial invoice delivery instructions label.
customsDelLabel: Customs invoice delivery instructions label.
customsPLDelLabel: Customs packing list delivery instructions label.
comPLDelLabel: Commercial packing list delivery instructions label.
paymentInfo: JSON object to stores information about bank details where payment should be received for commercial invoice.
customsPaymentInfo: JSON object to stores information about bank details where payment should be received for customs invoice.
qrCode: QR Code.
sealNo: SEAL number.
otherData: JSON object to stores information about other data and customs fields associated to sales 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.
customInvHeading: Customs invoice heading.
customInvSubHeading: Customs invoice subheading.
customInvPLHeading: Customs packing list heading.
customInvPLSubHeading: Customs packing list subheading.
lutNo: LUT number.
lutDate: LUT Date.
exchangeRate: Exchange rate from Invoice currency to INR.
exchangeRateUSD: Exchange rate from Invoice currency to USD.
amountInWordsINR: Amount in words for inr amount.
noOfPackagesDes: Number of packages description on invoice items table.
quantityDescription: Total Quantity description on commercial invoice items table.
quantityPerPackDes: Quantity per package description on commercial invoice items table.
customsQntyDes: Total Quantity description on customs invoice items table.
customsTotalQntyDes: Total Quantity description on customs invoice items table.
customsUnitPriceDes: Unit price description on customs invoice items table.
customsPLNetWeightDes: Net weight description on customs packing list items table.
customsPLGrossWeightDes: Gross weight description on customs packing list items table.
customsNoOfPackagesDes: Number of packages description on customs invoice items table.
packingListHeading: Commercial packing list heading.
packingListSubHeading: Commercial packing list subheading.
comInvSubHeading: Commercial invoice subheading.
comPLNetWeightDes: Net weight description on commercial packing list items table.
comPLGrossWeightDes: Gross weight description on commercial packing list items table.
unitPriceDes: Unit price description on commercial invoice items table.
isOrderNoVisible: Boolean value indicating whether linked order number is visible on template.
isNoOfPackagesVisible: Boolean value indicating whether Number of package is visible on template.
isQtyPerPackageVisible: Boolean value indicating whether Quantity per package is visible on commercial invoice template.
isQtyPerPackComPlVisible: Boolean value indicating whether Quantity per package is visible on commercial packing list template.
isQtyPerPackCusPlVisible: Boolean value indicating whether Quantity per package is visible on customs packing list template.
isQtyComPlVisible: Boolean value indicating whether total quantity is visible on commercial packing list template.
isQtyCusPlVisible: Boolean value indicating whether total quantity is visible on customs packing list template.
isGSTValueVisible: Boolean value indicating whether GST is visible on customs invoice template.
isTotalINRVisible: Boolean value indicating whether amount in INR is visible on customs invoice template.
isAmountINRVisible: Boolean value indicating whether amount in INR is visible on customs invoice template.
isItemCodeVisible: Boolean value indicating whether item code is visible on template.