| Name | Description | Type | Additional information |
|---|---|---|---|
| ID | integer |
None. |
|
| OrderGuid | Collection of byte |
None. |
|
| OrderIdentifier | globally unique identifier |
None. |
|
| PLUG_UID | Collection of byte |
None. |
|
| PluGuid | globally unique identifier |
None. |
|
| Created | date |
None. |
|
| APN | string |
None. |
|
| ItemNumber | string |
None. |
|
| DirectNumber |
The supplier's order code |
string |
None. |
| DirectIndicator |
The supplier's warehouse direct indicator |
string |
None. |
| SalesMode | integer |
None. |
|
| OrderByWeight | boolean |
None. |
|
| SellPrice | integer |
None. |
|
| InventoryFixed | boolean |
None. |
|
| HasInventory | boolean |
None. |
|
| InventoryAccuracy | integer |
None. |
|
| OnOrder | integer |
None. |
|
| OnOrderPacks | integer |
None. |
|
| OnHand | integer |
None. |
|
| OnHandPacks | integer |
None. |
|
| DoNotRange | boolean |
None. |
|
| DoNotOrder | boolean |
None. |
|
| Cost |
Carton cost |
integer |
None. |
| CostDecimals |
Carton cost decimal places |
integer |
None. |
| PickedCost |
Carton cost at time of picking. |
integer |
None. |
| PickedCostDecimals |
Picked carton cost decimal places. |
integer |
None. |
| AveragePackSize | decimal number |
None. |
|
| CartonQuantity |
Units per Cartonv |
integer |
None. |
| Cartons |
Ordered Cartons |
integer |
None. |
| Units |
Ordered Units |
integer |
None. |
| Weight |
Ordered Weight |
integer |
None. |
| PickedCartons |
Picked Cartons |
integer |
None. |
| PickedUnits |
Picked Units |
integer |
None. |
| PickedWeight |
Picked Weight |
integer |
None. |
| ShippedCartons |
Shipped (in-transit) Cartons |
integer |
None. |
| ShippedUnits |
Shipped (in-transit) units |
integer |
None. |
| ShippedWeight |
Shipped (in-transit) weight |
integer |
None. |
| ReceivedCartons |
Received Cartons |
integer |
None. |
| ReceivedCartonQuantity |
Received Units per Carton - may be different from ordered Units per Carton if different TUNs delivered |
integer |
None. |
| ReceivedTun |
The TUN scanned when receiving the order. |
string |
None. |
| ReceivedUnits |
Received units |
integer |
None. |
| ReceivedWeight |
Received weight |
integer |
None. |
| Received |
Flag for whether the order detail stock has been received |
integer |
None. |
| Status | OrderDetailStatus |
None. |
|
| SubstituteG_UID | Collection of byte |
None. |
|
| SubstituteGuid | globally unique identifier |
None. |
|
| WarehousePLUG_UID | Collection of byte |
None. |
|
| WarehousePluGuid |
Refers to the source Store's product guid |
globally unique identifier |
None. |
| Updated | date |
None. |
|
| Increment | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| Description | string |
Relation. This field may not always be loaded or used for updates. |
|
| Product | Product |
Relation. This field may not always be loaded or used for updates. |
|
| UnknownScan | OrderUnknownScan |
Relation. This field may not always be loaded or used for updates. |
|
| UnknownScanItem | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| Substitute | Product |
Relation. This field may not always be loaded or used for updates. |
|
| WarehouseProduct |
Product from the Store we are transferring from |
Product |
Relation. This field may not always be loaded or used for updates. |
| Lookup | OrderDetailLookup |
Relation. This field may not always be loaded or used for updates. |
|
| ProductOrderingDetail | ProductOrderingDetail |
Relation. This field may not always be loaded or used for updates. |
|
| DealCost | DealCost |
Relation. This field may not always be loaded or used for updates. |
|
| NextCost | DealCost |
Relation. This field may not always be loaded or used for updates. |
|
| LastChance |
If true, the deal cost is ending between now and the end of the week |
boolean |
Relation. This field may not always be loaded or used for updates. |
| HoldOff |
Indicates if a new deal cost is starting soon |
OrderHoldOff |
Relation. This field may not always be loaded or used for updates. |
| HoldOffDate |
Date that a hold off deal cost is begining |
date |
Relation. This field may not always be loaded or used for updates. |
| OrderHeader | OrderHeader |
Relation. This field may not always be loaded or used for updates. |
|
| InvoiceDetail | InvoiceDetail |
Relation. This field may not always be loaded or used for updates. |
|
| AutoOrderDetail | AutoOrderDetail |
Relation. This field may not always be loaded or used for updates. |
|
| CostGSTPercent | integer |
Relation. This field may not always be loaded or used for updates. |
|
| OrderDetailReceive |
Credit note populated. True if images are attached to order detail |
boolean |
Relation. This field may not always be loaded or used for updates. |
| IsBackedUp | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| BackupWarehouseIndicator | string |
Relation. This field may not always be loaded or used for updates. |
|
| BackupOrderCode | string |
Relation. This field may not always be loaded or used for updates. |