License Import Items¶
This table stores information about individual license item which is imported and linked to vendor bill.
Attributes¶
licenseImportItemId: 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 vendor bill document.
invId: Foreign key of vendor bill table. This field stores the information of the vendor bill where license is linked.
invoiceItemId: Foreign key of invoice item table. This field stores the information of the vendor bill 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 vendor bill.
itemUnit: UOM of the license item. For example, Kg. MT etc.
otherData: