| Name | Description | Type | Additional information |
|---|---|---|---|
| OrderID | integer |
None. |
|
| OrderGuid | Collection of byte |
None. |
|
| OrderIdentifier | globally unique identifier |
None. |
|
| BackToBack | integer |
None. |
|
| B2bGuid | Collection of byte |
None. |
|
| B2bIdentifier | globally unique identifier |
None. |
|
| Status | OrderStatus |
None. |
|
| Created | date |
None. |
|
| CreatedLocal | date |
None. |
|
| CreatedByUser | string |
String length: inclusive between 0 and 191 |
|
| StoreID | integer |
None. |
|
| TransferGuid | Collection of byte |
None. |
|
| TransferIdentifier | globally unique identifier |
None. |
|
| TransferInvoiceIdentifier | Collection of byte |
None. |
|
| TransferInvoiceGuid | globally unique identifier |
None. |
|
| AttachedToInvoice | integer |
None. |
|
| TransferType | TransferType |
None. |
|
| SupplierIdentifier | Collection of byte |
None. |
|
| SupplierIdentifierGuid | globally unique identifier |
None. |
|
| Description | string |
None. |
|
| Rows | integer |
None. |
|
| Cartons | integer |
None. |
|
| Units | integer |
None. |
|
| SentCount | integer |
None. |
|
| Sent | date |
None. |
|
| SentLocal | date |
None. |
|
| SentByUser | string |
String length: inclusive between 0 and 191 |
|
| LastSentStatus | integer |
None. |
|
| Cancelled | date |
None. |
|
| CancelledLocal | date |
None. |
|
| CancelledByUser | string |
String length: inclusive between 0 and 191 |
|
| Shipped | date |
None. |
|
| ShippedLocal | date |
None. |
|
| ShippedByUser | string |
String length: inclusive between 0 and 191 |
|
| StockReceived | date |
None. |
|
| StockReceivedLocal | date |
None. |
|
| StockReceivedByUser | string |
String length: inclusive between 0 and 191 |
|
| Received | date |
None. |
|
| ReceivedLocal | date |
None. |
|
| Completed | date |
None. |
|
| CompletedLocal | date |
None. |
|
| Updated | date |
None. |
|
| UpdatedLocal | date |
None. |
|
| DueDate | date |
None. |
|
| WarehouseNote | string |
None. |
|
| WarehouseRef | string |
None. |
|
| PdeSerialNumber | string |
None. |
|
| TradingPartner | OrderTradingPartner |
None. |
|
| OrderType | string |
String length: inclusive between 0 and 20 |
|
| OrderTypeDescription | string |
String length: inclusive between 0 and 255 |
|
| StateCode |
The state code of the store ordering for metcash |
string |
Deprecated. Prefer the HostStoreSetting.MetcashStateCode instead. String length: inclusive between 0 and 20 |
| MailCarbonCopy |
When Placing an order via email, send a Blind Carbon Copy to the current User |
boolean |
None. |
| MailTo | string |
None. |
|
| MailBcc | string |
None. |
|
| MailReplyTo | string |
None. |
|
| Liquor | boolean |
None. |
|
| Summary | string |
Data type: MultilineText |
|
| Notes | string |
Data type: MultilineText |
|
| SupplierNotes | string |
Data type: MultilineText |
|
| ReceiptEmailSent | boolean |
None. |
|
| ReceiptEmailSentId | string |
String length: inclusive between 0 and 100 |
|
| ReceiptEmailSentStatus | string |
String length: inclusive between 0 and 20 |
|
| TransportCompanyGuid | Collection of byte |
None. |
|
| TransportCompanyIdentifier | globally unique identifier |
None. |
|
| AutoOrder | integer |
None. |
|
| HostIdentifier | Collection of byte |
None. |
|
| HostIdentifierGuid | globally unique identifier |
None. |
|
| DefaultOrderDocumentId | integer |
None. |
|
| DefaultStockReceiveDocumentId | integer |
None. |
|
| Temperature |
Temperature recorded of order on receive. Null indicates no temperature recorded |
decimal number |
None. |
| TemperatureScale |
Temperature scale that temperature is recorded in |
TemperatureScale |
None. |
| Rating |
Quality rating of the order |
integer |
None. |
| LastOrderEmailSentId | string |
None. |
|
| LastOrderEmailSentStatus | string |
None. |
|
| Deleted | date |
None. |
|
| DeletedByUser | string |
None. |
|
| AutoOrderGuid | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| AutoOrderIdentifier | globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
|
| AutoOrderHeader | AutoOrderHeader |
Relation. This field may not always be loaded or used for updates. |
|
| SupplierName | string |
Relation. This field may not always be loaded or used for updates. |
|
| SupplierStoreID | integer |
Relation. This field may not always be loaded or used for updates. |
|
| SupplierCartonsOnly | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| SupplierEnforceMinimumQuantity | boolean |
Relation. This field may not always be loaded or used for updates. |
|
| SupplierMinimumOrderValue | integer |
Relation. This field may not always be loaded or used for updates. |
|
| StoreName | string |
Relation. This field may not always be loaded or used for updates. |
|
| OrderCode | OrderCode |
Relation. This field may not always be loaded or used for updates. |
|
| Store | Store |
Relation. This field may not always be loaded or used for updates. |
|
| Supplier | Supplier |
Relation. This field may not always be loaded or used for updates. |
|
| TotalCostInc |
Summarised total cost inc tax, based on system costs |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| TotalPickedCostInc |
Summarised total picked cost inc tax, based on system costs, for store transfer orders |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| TotalReceivedCostInc |
Summarised total received cost in tax, based on system costs |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| Total |
Totals aggregates |
OrderSubTotal |
Relation. This field may not always be loaded or used for updates. |
| Details | Collection of OrderDetail |
Relation. This field may not always be loaded or used for updates. |
|
| UnknownScans | Collection of OrderUnknownScan |
Relation. This field may not always be loaded or used for updates. |
|
| TransportCompany | TransportCompany |
Relation. This field may not always be loaded or used for updates. |
|
| TimeZoneInfo |
For sending orders |
TimeZoneInfo |
Relation. This field may not always be loaded or used for updates. |