| Name | Description | Type | Additional information |
|---|---|---|---|
| PKID |
PKID |
integer |
None. |
| CustID |
Customer ID |
string |
None. |
| OrderNo |
Order Number |
string |
None. |
| OrderType |
Order Type |
integer |
None. |
| OrdEntryType |
Order Entry Type |
integer |
None. |
| Warehouse |
Warehouse |
string |
None. |
| OrdCurr |
Order Currency |
string |
None. |
| Reference |
Reference |
string |
None. |
| PONumber |
PO Number |
string |
None. |
| HoldCode |
Hold Code |
string |
None. |
| ShipVia |
Shipping Method |
string |
None. |
| ShipPayment |
Order Shipping Payment Method |
integer |
None. |
| TPartyAcct |
Shipping Third Party Account |
string |
None. |
| Source |
Order Source |
string |
None. |
| OrdDate |
Order Date |
date |
None. |
| ReqdDate |
Order Required Date |
date |
None. |
| BillToLoc |
Order BillTo Location |
string |
None. |
| BillToCostCenter |
Order BillTo Cost Center |
string |
None. |
| BillToAddrID |
BillTo Addr ID |
integer |
None. |
| ShipToAddrID |
ShipTo Addr ID |
integer |
None. |
| ActiveFlag |
Order is Active Flag |
boolean |
None. |
| CancelledFlag |
Order is Cancelled Flag |
boolean |
None. |
| OrdPayment |
Order Payment Method |
integer |
None. |
| MerchTotal |
Order Merchandise Amount |
decimal number |
None. |
| ChargesTotal |
Order Additional Charges Amount |
decimal number |
None. |
| FreightTotal |
Order Freight Amount |
decimal number |
None. |
| PackTotal |
Order Packaging Charged Amount |
decimal number |
None. |
| Tax1 |
Order Tax1 Amount |
decimal number |
None. |
| Tax2 |
Order Tax2 Amoung |
decimal number |
None. |
| Tax3 |
Order Tax3 Amount |
decimal number |
None. |
| OrdTotal |
Order Total Amount |
decimal number |
None. |
| MiscInfo1 |
Order MiscInfo 1 |
string |
None. |
| MiscInfo2 |
Order MiscInfo 2 |
string |
None. |
| MiscInfo3 |
Order MiscInfo 3 |
string |
None. |
| MiscInfo4 |
Order MiscInfo 4 |
string |
None. |
| RelDate |
Release Date |
date |
None. |
| OrdStatus |
Order Status |
string |
None. |
| InvoicedFlag |
Order Invoiced Flag |
boolean |
None. |
| InvoiceNum |
Order Invoice Number |
string |
None. |
| InvoiceType |
Order Invoice Type |
string |
None. |
| WebCreated |
Order Web Created |
boolean |
None. |
| ImpBatch |
Order Import Batch |
string |
None. |
| LastShipNo |
Shipment Count |
integer |
None. |
| Tax1Label |
Order Tax1 Label |
string |
None. |
| Tax2Label |
Order Tax2 Label |
string |
None. |
| Tax3Label |
Order Tax3 Label |
string |
None. |
| CancelledDate |
Order Cancelled Date |
date |
None. |
| CancelledBy |
Order Cancelled By |
string |
None. |
| DateCreated |
Order Date Created |
date |
None. |
| LastUpdate |
Order Last Updated |
date |
None. |
| CODValue |
Order COD Value |
decimal number |
None. |
| CourierInst |
Order Courier Instructions |
string |
None. |
| EDIOrder |
Order EDI Flag |
boolean |
None. |
| ShipStartDate |
Shipping Start Date |
date |
None. |
| ShipEndDate |
Shipping End Date |
date |
None. |
| Comments |
Order Comments |
string |
None. |
| ShipToId |
Order ShipTo ID |
string |
None. |
| LangCode |
Order Language Code |
string |
None. |
| GiftPack |
Order Gift Pack Flag |
boolean |
None. |
| GiftPackCode |
Order Gift Pack Code |
string |
None. |
| HasGiftMsg |
Order Has Gift Message Flag |
boolean |
None. |
| GiftMessage |
Order Gift Message |
string |
None. |
| AllowBO |
Order Allow BO Flag |
boolean |
None. |
| FillAndKill |
Order Fill And Kill Flag |
boolean |
None. |
| DiscountTotal |
Order Discount Amount |
decimal number |
None. |
| MiscTotal |
Order Misc Charges Amount |
decimal number |
None. |
| IsBO |
Order BackOrder Flag |
boolean |
None. |
| DelStartDate |
Delivery Start Date |
date |
None. |
| DelEndDate |
Delivery End Date |
date |
None. |
| StoreOrder |
Store Order Flag |
boolean |
None. |
| StoreNo |
Order Store Number |
string |
None. |