| 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 | CUSTOMS | Customs Fee | | N |
| 6 | DRAYAGE | Drayage Charges | | N |
| 7 | EXDOC | Export Document Fee | | N |
| 8 | FAX | FAX Proof of Delivery | | N |
| 9 | HOL | Holiday Pickup/Delivery | | N |
| 10 | HOSE3 | 3" Hose with Connector | | N |
| 11 | HOSE4 | 4" Hose with Connector | | N |
| 12 | LIFTGATE | Liftgate Pickup/Delivery | | N |
| 13 | PICKUP | Pickup | | N |
| 14 | PICKUPR | Residential Pickup | | N |
| 15 | PUMP7.5 | 7.5 Horsepower Pump | | N |
| 16 | SAT | Saturday Pickup/Delivery | | N |
| 17 | SHPNTFY | Shipment Notification | | N |
| 18 | SIG | Signature Required | | N |
| 19 | SUN | Sunday Pickup/Delivery | | N |
