Skip to content

Sales Order items

This table stores information about individual items inside Export/Sales Order with item level information.

Attributes

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

salesOrderId: Foreign key of Sales Order table. This field stores the information of the order 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.

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

SalesOrder

Order items must always belongs any one Export/Sales Order.