License Export Items¶
This table stores information about individual license items which is being exported and linked to the invoice.
Attributes¶
licenseExportItemId: primary key of the table.
licenseId: Foreign key of License table. This field stores the information of the license where item being added.
licenseItemId: Foreign key of License item table. This field stores the information of the License item which is used to export the items in invoice document.
licenseImportItemId: Foreign key of License import item table. This field stores the information of the imported license item which is used to produce export item.
invId: Foreign key of invoice table. This field stores the information of the invoice where license is linked.
invoiceItemId: Foreign key of invoice item table. This field stores the information of the invoice item where payment schedule being added.
itemCode: Item Code of the license item.
itemDescription: Item description of the license item.
itemPrice: Unit price of the license item.
itemPriceUSD: Unit price of the license item in USD.
itemPriceINR: Unit price of the license item in INR.
itemCurrency: Currency of the item.
itemQuantity: Quantity exported in particular linked invoice.
itemRemainingQuantity: Remaining quantity of the license item that needs to be exported to meet 100% obligation.
itemUnit: UOM of the license item. For example, Kg. MT etc.
otherData: