Understanding Cross-Reference Data

Cross-referencing static data between JD Edwards EnterpriseOne and Oracle Transportation Management minimizes manual data configuration in both systems and is required for successful outbound data extraction and inbound data import. When JD Edwards EnterpriseOne extracts data to send to Oracle Transportation Management, the export UBE Sales Freight Request Export (R49T10), Procurement Freight Request export (R49T100), Sales Confirmation Export (R49T30), Corporation Extraction UBE (R49T70) and Locations Extraction UBE (R49T80) programs validate against the cross-referenced values. Similarly, when the Oracle Transportation Management transmits shipment information to JD Edwards EnterpriseOne, the import UBE Sales Transportation Arranged Import (R49T20), Sales Transportation Confirmation Import (R49T40) and Inbound Transmission Master Router/Parser (R49T90) programs validate the cross-referenced values. You use the X-Ref Application (P49T01) program to enter cross-reference data. The cross-referenced static data types include:

• Country codes.

• Currency codes.

• Units of measure.

• Freight UDC.

• Mode of transport UDC.

• NMFC Class.

• Commodity.

• User defined commodity.

• Hazardous class.

• Packaging group.

• Temperature type.

• Hazard label.

• Freight handling code.

• Special handling code.