Field mapping
This table shows the mapping of the WM database fields to API
fields for SHIP API request:
| Infor SPS API Field | WM Database Field | Validations/Comments |
|---|---|---|
| Bill To Fields | ||
| ALTP_CUSTOMER_CODE | ORDERS.BILLTOKEY | |
| ALTP_ADD1 | ORDERS.B_ADDRESS1 | |
| ALTP_ADD2 | ORDERS.B_ADDRESS2 | |
| ALTP_ADD3 | ORDERS.B_ADDRESS3 | |
| ALTP_ATTENTION | ORDERS.B_CONTACT1 | |
| ALTP_CITY | ORDERS.B_CITY | |
| ALTP_COMP_NAME | ORDERS.B_COMPANY | |
| ALTP_COUNTRYNAME | ORDERS.B_COUNTRY | |
| ALTP_COUNTRYID | ORDERS.B_ISOCOUNTRYCODE | |
| ALTP_PHONE | ORDERS.B_PHONE1 | |
| S2CUSTNUM | STORER.SPSACCOUNTNUM | Where storer.type = 4 |
| S3CUSTNUM | STORER.SPSACCOUNTNUM | Where storer.type = 4 |
| ALTP_STATE | ORDERS.B_STATE | |
| ALTP_PCODE | ORDERS.B_ZIPCODE | |
| ALTP_FAX | ORDERS.B_FAX1 | |
| ALTP_EMAIL | ORDERS.B_EMAIL1 | |
| Carrier Information Fields | ||
| CARRIER | SPSCARRIER.SCAC_CODE | |
| SERVICE | SPSCARRIER.SPSTYPE | For LTL, this is GEN |
| Order Information Fields | ||
| REFERENCE2 | ORDERS.ORDERKEY | |
| REFNO | ORDERS.EXTERNORDERKEY | |
| ORDER_NUMBER | ORDERS.EXTERNORDERKEY | |
| TERMS | ORDERS.PMTTERM | Prepaid = s, Collect = f, ThirdParty = 3 |
| SHIPDATE | ORDERS.REQUESTEDSHIPDATE | |
| REFERENCE3 | ORDERS.BUYERPO | |
| Package information | ||
| HEIGHT | CARTONIZATION.HEIGHT | |
| WEIGHT | Calculated | Weight of carton type plus weight of the contents or the actual weight as entered by the user |
| LENGTH | CARTONIZATION.LENGTH | |
| WIDTH | CARTONIZATION.WIDTH | |
| PKG_DIM_UOM | STORER.SPSUOMDIMENSION | |
| PKG_UOM | STORER.SPSUOMWEIGHT | |
| NMFC_NUM | Calculated (Only for LTL) | NMFC Class matching the highest freight class |
| COMMODITY_CLASS | Calculated (Only for LTL) | Highest freight class of all items in the package |
| Printer Information | ||
| PRINTFLAG | 'N' | Compliant labels are printed by WM |
| PRINTER_IP | LABELPRINTER.PRINTERIP | |
| Ship From information | From Storer table where type = 1 Or From Facility table | |
| SFADD1 | STORER.ADDRESS1 | |
| SFADDRESS1 | STORER.ADDRESS1 | |
| UI_SFADD1 | STORER.ADDRESS1 | |
| SFADD2 | STORER.ADDRESS2 | |
| UI_SFADD2 | STORER.ADDRESS2 | |
| SFADD3 | STORER.ADDRESS3 | |
| UI_SFADD3 | STORER.ADDRESS3 | |
| SFATTN | STORER.CONTACT1 | |
| UI_SFATTN | STORER.CONTACT1 | |
| SFCITY | STORER.CITY | |
| UI_SFCITY | STORER.CITY | |
| SFCOMPANY | STORER.COMPANY | |
| SFCOUNTRY | STORER.COUNTRY | |
| UI_SFCOUNTRY | STORER.COUNTRY | |
| SFCOUNTRYID | STORER.ISOCOUNTRYCODE | |
| COUNTRY_ORIGIN | STORER.ISOCOUNTRYCODE | |
| UI_SFCOUNTRYID | STORER.ISOCOUNTRYCODE | |
| SFPHONE | STORER.PHONE1 | |
| UI_SFPHONE | STORER.PHONE1 | |
| SFSTATE | STORER.STATE | |
| UI_SFSTATE | STORER.STATE | |
| SFCUSTNUM | STORER.SPSACCOUNTNUM | |
| UI_SFCUSTNUM | STORER.SPSACCOUNTNUM | |
| SFPCODE | STORER.ZIP | |
| UI_SFZIP | STORER.ZIP | |
| SFFAXNO | STORER.FAX1 | |
| SFEMAIL | STORER.ZIP | |
| UI_SFEMAIL | STORER.ZIP | |
| COST_CENTER | STORER.SPSCOSTCENTER | |
| Ship TO information | ||
| S2ADD1 | ORDERS.C_ADDRESS1 | |
| S2ADD2 | ORDERS.C_ADDRESS2 | |
| S2ADD3 | ORDERS.C_ADDRESS3 | |
| TO_ATTENTION | ORDERS.C_CONTACT1 | |
| S2CITY | ORDERS.C_CITY | |
| S2NAME | ORDERS.C_COMPANY | |
| S2COUNTRY_NAME | ORDERS.C_COUNTRY | |
| S2COUNTRYID | ORDERS.C_ISOCNTRYCODE | |
| S2PHONE | ORDERS.C_PHONE1 | |
| S2CUSTCODE | ORDERS.CONSIGNEEKEY | |
| S2STATE | ORDERS.C_STATE | |
| S2PCODE | ORDERS.C_ZIP | |
| S2FAX | ORDERS.C_FAX1 | |
| TO_EMAIL | ORDERS.C_EMAIL1 | |
| Special Services | ||
| CODPAYTYPE | 's' | If 'COD' special service configured |
| COD_OPTION | 1 | If 'COD' special service configured |
| SPCDLVYFLAG | 'S' | If 'Saturday Delivery' is configured |
| DLVY_CONF_TYPE | 'g' for UPS 'D' for FDX | |
| RET_SVC_CODE | 'p' | If 'Return Service Code' is configured. |
The following table provides the mapping of WM database fields to API
fields for SHIP API response.
| Infor SPS API Field | WM Database Field | Validations/Comments |
|---|---|---|
| TRACKNUM | SPS CASE.TRACKNUMBER | For LTL, this is also updated ORDERS.PRONUMBER |
| CALCFREIGHT | SPS CASE. | |
| LABELDATA | Label to be printed | |
| ERRCODE | Denotes whether the API request had an error or not | |
| ERRMSG | SPS CASE.ERROR | |
| TOTAL_FREIGHT | SPS CASE.RATE | For LTL, the total freight cost of Order/Load is updated ORDERS.FREIGHTCHARGEAMOUNT, ORDERS.FREIGHTCOSTAMOUNT |