| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40331 | Preference Profile - Options and Equipment | 14 | OE | OPEQ | Options/Equipment | String | UDC | 10 | 0 |
TOP49: Transportation Management |
2 | F49302 | Vehicle Equipment | 3 | VE | OPEQ | Options/Equipment | String | UDC | 10 | 0 |
3 | F4944 | Shipment/Load Options and Equipment | 9 | OE | OPEQ | Options/Equipment | String | UDC | 10 | 0 |
4 | F4956 | Option and Equipment Inclusions/Exclusions | 4 | IX | OPEQ | Options/Equipment | String | UDC | 10 | 0 |
5 | F4971 | Freight Rate Definition | 24 | RD | OPEQ | Options/Equipment | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 49 / BG (Option/Equipment) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | AFTHRS | After Hour Pickup/Delivery | | N |
3 | CFM | Confirmation | | N |
4 | CFMVBL | Confirmation - Verbal | | N |
5 | COD | Collect on Delivery | | N |
6 | CUSTOMS | Customs Fee | | N |
7 | DRAYAGE | Drayage Charges | | N |
8 | EXDOC | Export Document Fee | | N |
9 | FAX | FAX Proof of Delivery | | N |
10 | HOL | Holiday Pickup/Delivery | | N |
11 | HOSE3 | 3 Hose with Connector | | N |
12 | HOSE4 | 4 Hose with Connector | | N |
13 | INS | Inside Delivery/Pickup Service | | N |
14 | LGS | Liftgate Service | | N |
15 | LIFTGATE | Liftgate Pickup/Delivery | | N |
16 | NPD | Notification Prior to Delivery | | N |
17 | ORD | Order Notify | | N |
18 | PICKUP | Pickup | | N |
19 | PICKUPR | Residential Pickup | | N |
20 | PRF | Protect From Freezing | | N |
21 | PUMP7.5 | 7.5 Horsepower Pump | | N |
22 | RES | Residential Delivery/Pickup | | N |
23 | SAT | Saturday Pickup/Delivery | | N |
24 | SHPNTFY | Shipment Notification | | N |
25 | SIG | Signature Required | | N |
26 | SUN | Sunday Pickup/Delivery | | N |