Order Items

PropertyTypeDescription
OrderItemIdbigintPrimary Key
TermsstringPayment Terms
OrderIdbigintPrimary Key
ItemIdbigintPrimary Key
ItemSKUstringItem SKU
PackSizeDecimalsize of Pack
PackCountDecimalNo of Packs
ItemNamestringName of The Item
UnitIdintPrimary Key
UnitNamestringUnit of Measurement
UnitPriceDecimalUnit price of Item
ListPriceDecimalList Price of Item
PriceListIdbigintPrice List Id
ExciseAmountDecimalExcise Amount
DescriptionstringSmall Description about the placed Order
OrderItemStatusIdbigintStatus of Order Item
QuantityDecimalQuantity of Item
HideOnInvoiceBooleanHiding of the Order Item on Invoice(Yes/No)
ExchangeDCBoolean
PacksintNo of Packs
PiecesintNo of Pieces
TaxAmountDecimalAmount of Tax
DeliveredPacksDecimalNo of Packs Delivered
TariffNoStringHSN Code
DiscountPercentDecimalOffered Discount Percentage
DiscountValueDecimalOffered Discount value
DiscountAmountDecimalAmount to be discounted
RefNostringReference Number
TaxGroupIdbigintTax Group Identifier
TaxGroupNamestringTax Group Name
TaxTotalDecimalTotal Tax
RowTotalDecimalRow wise Total
IsEstConfirmedBooleanYes/No
IsAfterTaxBooleanYes/No
InvoicedQtyDecimaltotal Quantity of Invoice
DcQtyDecimaltotal Quantity of DC
InvoicedPacksDecimalNo of packes Invoiced
AvailableQtyDecimalNo of Items Available
AvailablePacksDecimalNo of Packes Available
ExpectedPriceDecimalExpected Price
DeliveryDaysintNo of Days for Delivery
OrderDateDateTimeDate of Order
OrderNostringOrder Number
DiscountGroupIdBigintDiscount Group Identifier
OrganizationNamestringName of the Organization
DiscountGroupNamestringName of the DiscountGroup
OrderItemPendingQtyDecimal
OptOutAmountDecimal
RowOptOutDecimal
ReturnedQtyDecimal
OrderTypeIdintOrder type Identifier
IsFocBooleanFree of Cost (Yes/No)
IsBoMItemBooleanBill Of Material (Yes/No)
MrpIdbigintMRP Identifier
InventoryTypeIdbigintInventoryType Identifier
StockJournalTypeintStockJournalType Identifier
PortalCodestring
LedgerIdBigintLedger Identifier
LedgerNamestringName of Ledger
RowDiscountDecimalRow wise discount