Integration via ODBC
Includes Worldship, FedEx and any other ODBC connections
This is one of many methods. This one uses the Pick Ticket and Pack Boxes data to return individual box information.
Order Number is used as the primary key to retrieve data.
Pick Ticket and Pack Boxes module is in use.
ORDERS.ORN (Order Number, Primary Key)
ORDERS.OSHIP_NAME
ORDERS.OSHIP_ADR1
ORDERS.OSHIP_ADR2
ORDERS.OSHIP_CITY
ORDERS.OSHIP_STATE
ORDERS.OSHIP_ZIP
ORDERS.OSHIP_COUNTRY
ORDERS.O_SHIP_RESIDENT (1=Residential checkbox)
ORDERS.O_USE_UPS_NUM (1= Use alternate Shipping Number)
ORDERS.O_UPS_NUM (alternate shipping number, account number)
ORDERS.OSHIP_xxx (other fields are self-explanatory)
ORDERS.O_SHIPVIA_CODE
can find
SHIPVIA.SV_CODE (Shipping Methods)
SHIPVIA.SV_DESC
SHIPVIA.SV_SERVICE
ORDERS.O_FP_CODE
can find
FREIGHT_PMT.FP_CODE, (Freight Payment Methods)
FREIGHT_PMT.FP_DESC
ORDERS.ORN
can find
ASN_ITEMS.AI_ORDER_NUM (Boxes – Order Number)
ASN_ITEMS.AI_BOXNUM (box number, for that order)
ASN_ITEMS.AI_CASE_WEIGHT (box weight)
ASN_ITEMS.AI_DECLARED_VALUE (implemented in the next release, 7.090630)
—
Additional field names can be retrieved from PROG > Data File Browser