| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40332 | Preference Profile - Customer Freight | 17 | CF | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
2 | F4215 | Shipment Header | 48 | XH | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
TOP49: Transportation Management |
3 | F4941 | Shipment Routing Steps | 10 | RS | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
4 | F4950 | Routing Entries | 20 | RT | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
5 | F49501 | Intermodal Detail Routing Entries | 7 | RD | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
6 | F4960 | Load Header | 35 | TM | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
7 | F4970 | Freight Rate Schedule | 1 | FT | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
8 | F4981 | Freight Audit History | 24 | FH | FRSC | Freight Rate Schedule | String | UDC | 8 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 49 / BK (Freight Rate Schedule) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | CZAR | CZAR | | N |
3 | DELIV | Accessorial Delivery Charges | | N |
4 | EURORAIL | Euro Rail | | N |
5 | EX2ND | Express Second Day | | N |
6 | EXOVN | Express Overnight | | N |
7 | EXSD | Express Same Day | | N |
8 | INBOUND | Inbound LTL | | N |
9 | INROUTE | Rate Information in Route | | N |
10 | INSUR | Insurance Charges | | N |
11 | INTLFF | International Freight Forward | | N |
12 | INTLOF | International Ocean Freight | | N |
13 | LMPORT | Le Mans TL Port Rates | | N |
14 | LMUNIT | Le Mans Unit Rates | | N |
15 | LMZONES | Le Mans Zone Rates | | N |
16 | LTL | Less than Load | | N |
17 | LTLCLIP | Less than Load - Clipped | | N |
18 | MILKRUN | Unscheduled Deliveries | | N |
19 | NWRAIL | NW Rail | | N |
20 | PFDIST | Private Fleet Distance | | N |
21 | PFROUTE | Private Fleet Route | | N |
22 | PFZONE | Private Fleet Zone | | N |
23 | TL | Truckload | | N |
24 | USRAIL | US Rail Rates | | N |
25 | WP2ND | Western Second Day | | N |
26 | WPGND | Western Ground | | N |
27 | WPINTL | Western Parcel International | | N |