Invoice Items¶
Invoice Items table stores information about Detailed information about Items linked to invoice along with pricing, quantity, Code & product information.
Attributes¶
invoiceItemId: Primary key of the table.
itemMasterId: Foreign key of the Item master table. This field stores the information of the Item master table through which item is created.
salesOrderItemId: Foreign key of the Sales Order Item table. This field stores the information of the SO Item which is linked to invoice item
salesOrderId: Foreign key of Sales Order table. This field stores the information of the order through which invoice is linked.
purchaseOrderItemId: Foreign key of the Purchase Order Item table. This field stores the information of the PO Item which is linked to invoice item.
purchaseOrderId: Foreign key of Purchase Order table. This field stores the information of the order through which invoice is linked.
invId: Foreign key of Invoice table. This field stores the information of the invoice which is linked to item.
itemCode: Code of the item.
itemHSNCode: HSN Code of the item.
itemSubCode: Sub Code of the item.
itemName: Name of the item.
itemDescription: Description of the item for commercial invoice.
itemCustomsDescription: Description of the item for customs invoice.
itemPackingListDescription: Description of the item for commercial packing list.
itemCustPLDescription: Description of the item for customs packing list.
itemPrice: Unit price of the item for commercial invoice.
customsItemPrice: Unit price of the item for customs invoice.
itemCurrency: Currency of the item price.
itemUnit: Unit of the item for commercial invoice. For example, Kg. MT etc.
customsItemUnit: Unit of the item for customs invoice. For example, Kg. MT etc.
itemQuantity: Total number of the item quantity inside all packages in commercial invoice.
itemQuantityPerPack: Total number of the item quantity inside per pack in commercial invoice.
itemCustQuantityPerPack: Total number of the item quantity inside per pack in customs invoice.
itemCustTotalQuantity: Total number of the item quantity inside all packages in customs invoice.
itemPriceINR: Unit price of the item in INR for customs invoice.
itemPriceUSD: Unit price of the item in USD for customs invoice.
otherData: JSON object to stores information about other items related info which does not require any computation. All the custom fields also go here.
noOfPackages: Total number of the package.
gst: GST percentage of the item for customs invoice.
perUnitWeight: JSON object to stores information about per unit weight for both invoice item.
netWeight: Total netWeight of the item for commercial invoice.
grossWeight: Total gross weight of the item for commercial invoice.
custNetWeight: Total netWeight of the item for customs invoice.
custGrossWeight: Total gross weight of the item for customs invoice.
advanceLicenseDetails: JSON object to stores information about licenses linked to invoice item.