Purchase Order items

This table stores information about individual items inside Import/Purchase Order with item level information.

Attributes

purchaseOrderItemId: 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

purchaseOrderId: Foreign key of Purchase Order table. This field stores the information of the order which is linked to order items.

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.

itemPrice: Unit price of the item.

itemCurrency: Currency of the item price.

itemQuantity: Total quantity of the item.

remainingQuantity: Remaining item quantity.

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

otherData: JSON object to stores information about other items related info which does not require any computation. All the custom fields also go here.

quantityUpdates: JSON object to stores information about quantity updates related information.

itemQuantityPerPack: Number of quantity per package.

noOfPackages: Total number of the package.

---

Associations

PurchaseOrder

Order items must always belongs any one Import/Purchase Order.