| Name | Description | Type | Additional information |
|---|---|---|---|
| SerialKey | integer |
None. |
|
| STATUSdesc | string |
None. |
|
| WHSEID | string |
None. |
|
| typedescr | string |
None. |
|
| OrderKey | string |
None. |
|
| StorerKey | string |
None. |
|
| ExternOrderKey | string |
None. |
|
| OrderDate | string |
None. |
|
| Priority | string |
None. |
|
| ConsigneeKey | string |
None. |
|
| C_Contact1 | string |
None. |
|
| C_Contact2 | string |
None. |
|
| C_Company | string |
None. |
|
| C_Address1 | string |
None. |
|
| C_Address2 | string |
None. |
|
| C_Address3 | string |
None. |
|
| C_Address4 | string |
None. |
|
| C_Address5 | string |
None. |
|
| C_Address6 | string |
None. |
|
| C_City | string |
None. |
|
| C_State | string |
None. |
|
| C_Zip | string |
None. |
|
| C_Country | string |
None. |
|
| C_ISOCntryCode | string |
None. |
|
| C_PHONE1 | string |
None. |
|
| C_PHONE2 | string |
None. |
|
| C_FAX1 | string |
None. |
|
| C_FAX2 | string |
None. |
|
| C_VAT | string |
None. |
|
| BuyerPO | string |
None. |
|
| ScheduledShipDate | string |
None. |
|
| B_Contact1 | string |
None. |
|
| B_Contact2 | string |
None. |
|
| B_Company | string |
None. |
|
| B_Address1 | string |
None. |
|
| B_Address2 | string |
None. |
|
| B_Address3 | string |
None. |
|
| B_Address4 | string |
None. |
|
| B_City | string |
None. |
|
| B_State | string |
None. |
|
| B_Zip | string |
None. |
|
| B_Country | string |
None. |
|
| B_ISOCntryCode | string |
None. |
|
| B_Phone1 | string |
None. |
|
| B_Phone2 | string |
None. |
|
| B_Fax1 | string |
None. |
|
| B_Fax2 | string |
None. |
|
| B_Vat | string |
None. |
|
| IncoTerm | string |
None. |
|
| PmtTerm | string |
None. |
|
| SortationLocation | string |
None. |
|
| BatchFlag | string |
None. |
|
| BULKCARTONGROUP | string |
None. |
|
| Route | string |
None. |
|
| Stop | integer |
None. |
|
| OpenQty | decimal number |
None. |
|
| Status | string |
None. |
|
| DischargePlace | string |
None. |
|
| DeliveryPlace | string |
None. |
|
| IntermodalVehicle | string |
None. |
|
| CountryOfOrigin | string |
None. |
|
| CountryDestination | string |
None. |
|
| UPDATESOURCE | string |
None. |
|
| TYPE | string |
None. |
|
| ORDERGROUP | string |
None. |
|
| EFFECTIVEDATE | date |
None. |
|
| STAGE | string |
None. |
|
| DC_ID | string |
None. |
|
| WHSE_ID | string |
None. |
|
| SPLIT_ORDERS | string |
None. |
|
| APPT_STATUS | string |
None. |
|
| CHEPPALLETINDICATOR | string |
None. |
|
| CONTAINERTYPE | string |
None. |
|
| CONTAINERQTY | decimal number |
None. |
|
| BILLEDCONTAINERQTY | decimal number |
None. |
|
| TRANSPORTATIONMODE | string |
None. |
|
| TransportationService | string |
None. |
|
| ExternalOrderKey2 | string |
None. |
|
| C_EMAIL1 | string |
None. |
|
| C_EMAIL2 | string |
None. |
|
| SUsr1 | string |
None. |
|
| SUsr2 | string |
None. |
|
| SUsr3 | string |
None. |
|
| SUsr4 | string |
None. |
|
| SUsr5 | string |
None. |
|
| NOTES2 | string |
None. |
|
| ITEM_NUMBER | decimal number |
None. |
|
| FORTE_FLAG | string |
None. |
|
| LOADID | string |
None. |
|
| SHIPTOGETHER | string |
None. |
|
| ORDERVALUE | decimal number |
None. |
|
| OHTYPE | string |
None. |
|
| ExternalLoadId | string |
None. |
|
| DESTINATIONNESTID | integer |
None. |
|
| REFERENCENUM | string |
None. |
|
| INTRANSITKEY | string |
None. |
|
| RECEIPTKEY | string |
None. |
|
| CaseLabelType | string |
None. |
|
| LABELNAME | string |
None. |
|
| STDSSCCLABELNAME | string |
None. |
|
| STDGTINLABELNAME | string |
None. |
|
| RFIDSSCCLABELNAME | string |
None. |
|
| RFIDGTINLABELNAME | string |
None. |
|
| RFIDFLAG | string |
None. |
|
| CarrierCode | string |
None. |
|
| CarrierName | string |
None. |
|
| CarrierAddress1 | string |
None. |
|
| CarrierAddress2 | string |
None. |
|
| CarrierCity | string |
None. |
|
| CarrierState | string |
None. |
|
| CarrierZip | string |
None. |
|
| CarrierCountry | string |
None. |
|
| CarrierPhone | string |
None. |
|
| DriverName | string |
None. |
|
| TrailerNumber | string |
None. |
|
| TrailerOwner | string |
None. |
|
| TrailerType | string |
None. |
|
| ORDERBREAK | string |
None. |
|
| ALLOCATEDONERP | string |
None. |
|
| TRADINGPARTNER | string |
None. |
|
| ProNumber | string |
None. |
|
| ENABLEPACKING | string |
None. |
|
| PACKINGLOCATION | string |
None. |
|
| ORDERSID | string |
None. |
|
| SUSPENDEDINDICATOR | string |
None. |
|
| PICKLISTREPORTID | string |
None. |
|
| PACKINGLISTREPORTID | string |
None. |
|
| SOURCEVERSION | string |
None. |
|
| REFERENCETYPE | string |
None. |
|
| REFERENCEDOCUMENT | string |
None. |
|
| REFERENCELOCATION | string |
None. |
|
| REFERENCEVERSION | string |
None. |
|
| FREIGHTCHARGEAMOUNT | decimal number |
None. |
|
| FREIGHTCOSTAMOUNT | decimal number |
None. |
|
| APPOINTMENTKEY | string |
None. |
|
| AllowOverPick | integer |
None. |
|
| TOTALQTY | decimal number |
None. |
|
| TOTALGROSSWGT | decimal number |
None. |
|
| TOTALCUBE | decimal number |
None. |
|
| TOTALORDERLINES | integer |
None. |
|
| ReferenceAccountingEntity | string |
None. |
|
| POKEY | string |
None. |
|
| APPORTION | string |
None. |
|
| CONTAINERID | string |
None. |
|
| CARRIERROUTEDOCUMENT | string |
None. |
|
| CARRIERROUTEACCOUNTINGENTITY | string |
None. |
|
| CARRIERROUTELOCATION | string |
None. |
|
| CARRIERROUTEVERSION | string |
None. |
|
| TMHOUSEAIRWAYBILLNUMBER | string |
None. |
|
| TMMASTERAIRWAYBILLNUMBER | string |
None. |
|
| TMBOOKINGNUMBER | string |
None. |
|
| TMHOUSEOCEANBOLNUMBER | string |
None. |
|
| TMMASTEROCEANBOLNUMBER | string |
None. |
|
| TMEQUIPMENTNUMBER | string |
None. |
|
| TMSEALNUMBER | string |
None. |
|
| TMLICENSEPLATENUMBER | string |
None. |
|
| TMEQUIPMENTTYPE | string |
None. |
|
| TMEQUIPMENTLENGTH | string |
None. |
|
| TMEQUIPMENTATTRIBUTE | string |
None. |
|
| TMAIRSERVICELEVEL | string |
None. |
|
| TMOCEANSERVICELEVEL | string |
None. |
|
| TMOCEANTARIFFSERVICE | string |
None. |
|
| TMPORTOFLOADING | string |
None. |
|
| TMPORTOFDISCHARGE | string |
None. |
|
| TMROUTEDVIA | string |
None. |
|
| TMSERVICEATTRIBUTE | string |
None. |
|
| TMFREIGHTCOSTCURRENCY | string |
None. |
|
| TMFREIGHTCHARGECURRENCY | string |
None. |
|
| C_ADDRESS5 | string |
None. |
|
| C_ADDRESS6 | string |
None. |
|
| B_ADDRESS5 | string |
None. |
|
| B_ADDRESS6 | string |
None. |
|
| RETURNTOPARTY | string |
None. |
|
| TRAILERKEY | string |
None. |
|
| CARRIERROUTESTATUS | string |
None. |
|
| SPLITSHIPMENTINDICATOR | string |
None. |
|
| SPLITSHIPMENTORIGINALORDERKEY | string |
None. |
|
| SPLITSHIPMENTFINALSHIPMENT | string |
None. |
|
| BODAPPLICATIONAREA | string |
None. |
|
| FREIGHTCOSTBASEAMOUNT | decimal number |
None. |
|
| FREIGHTCHARGEBASEAMOUNT | decimal number |
None. |
|
| PACKINGVALTEMPLATE | string |
None. |
|
| PACKNOTES | string |
None. |
|
| TrailerKey | string |
None. |
|
| ActualShipDate | string |
None. |
|
| TOTALROUTES | decimal number |
None. |
|
| AUTODOORASSIGNED | string |
None. |
|
| AUTOSTAGEASSIGNED | string |
None. |
|
| AUTOPACKASSIGNED | string |
None. |
|
| AUTODOCKASSIGNEDHOW | string |
None. |
|
| AUTODOCKASSIGNEDSET | string |
None. |
|
| AUTODOCKASSIGNEDSTEP | integer |
None. |
|
| TOTALPALLETESTIMATE | integer |
None. |
|
| REQUIREORDERCLOSE | string |
None. |
|
| NOTES | string |
None. |
|
| SPSAPISTRATEGYKEY | string |
None. |
|
| BOLNUMBER | string |
None. |
|
| BOLPRINTED | string |
None. |
|
| SHIPTOGROUP | string |
None. |
|
| ADDDATE | date |
None. |
|
| ADDWHO | string |
None. |
|
| EDITDATE | date |
None. |
|
| EDITWHO | string |
None. |