License Item

This table stores information about individual license item which needs to be imported/exported in order to meet the requirements/obligation.

Attributes

licenseItemId: Primary key for the table.

licenseId: Foreign key of License table. This field stores the information of the license where item being added.

itemType: Type of item.

Type

1. Export
2. Import

itemCode: Item Code of the license item.

itemHSNCode: HSN code of the license item.

itemSubCode: Sub code of the license item.

itemName: Name 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 price.

itemQuantity: Total quantity to be exported/imported.

itemQuantityRatio: Item quantity ratio with respect to other license item.

exchangeRateUSD: Item currency to USD exchange rate.

exchangeRateINR: Item currency to INR exchange rate.

itemImpQtyUtilization: Import quantity utilization percentage.

itemExpQtyUtilization: Export quantity utilization percentage.

itemImpPriceUtilization: Import item price utilization percentage.

itemExpPriceUtilization: Export item price utilization percentage.

itemUnit: UOM of the license item. For example, Kg. MT etc.

otherData: