| 49: Transportation Management |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
|---|
| 1 | 812 | F4215T | XT | 18 | 2 | Shipment Header Tag File | Transaction Files | 49: Transportation Management | No |
| 2 | 812 | F47500WF | SZ | 9 | 1 | Inbound Transaction Processor Workfile | Files | 49: Transportation Management | |
| 3 | 812 | F49002 | TX | 35 | 1 | Transportation Constants | Constants Files | 49: Transportation Management | No |
| 4 | 812 | F49003 | LT | 28 | 1 | Load Type Constants | Constants Files | 49: Transportation Management | No |
| 5 | 812 | F49004 | CT | 23 | 1 | Mode of Transport Constants | Constants Files | 49: Transportation Management | No |
| 6 | 812 | F49005 | TG | 15 | 1 | Generate Tracking Number | Constants Files | 49: Transportation Management | No |
| 7 | 812 | F490051 | XG | 23 | 1 | Generate Tracking Number Segment | Constants Files | 49: Transportation Management | No |
| 8 | 812 | F490052 | YG | 18 | 1 | Generate Tracking Segment Next Number | Constants Files | 49: Transportation Management | No |
| 9 | 812 | F490053 | ZG | 16 | 4 | Generate Tracking Number Separator | Constants Files | 49: Transportation Management | No |
| 10 | 812 | F49010 | VM | 45 | 1 | Vehicle Master (Conversion from World File) | Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 11 | 812 | F49012 | VO | 13 | 1 | Vehicle Compartments (Conversion from World File) | Secondary Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 12 | 812 | F49015 | ST | 9 | 2 | Vehicle Status | Secondary Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 13 | 812 | F4902 | TV | 17 | 1 | Vehicle Current Load | Balance Files | 49: Transportation Management | AS400 Coexistence Tables |
| 14 | 812 | F49020 | VL | 21 | 2 | Vehicle/Staff License Information | Secondary Master Files | 49: Transportation Management | No |
| 15 | 812 | F49025 | CV | 18 | 1 | Connected Vehicles (Conversion from World File) | Secondary Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 16 | 812 | F49030 | VE | 10 | 1 | Vehicle Equipment (Conversion from World File) | Secondary Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 17 | 812 | F49040 | VS | 12 | 1 | Vehicle Staff (Conversion from World File) | Secondary Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 18 | 812 | F49041 | VS | 12 | 1 | Depot/Vehicle Staff | Master Files | 49: Transportation Management | No |
| 19 | 812 | F4906 | CM | 17 | 1 | Carrier Master | Master Files | 49: Transportation Management | No |
| 20 | 812 | F49075 | PM | 8 | 3 | Product Mix | Extra Features Files | 49: Transportation Management | No |
| 21 | 812 | F4908 | II | 24 | 1 | Item Shipping Information | Secondary Master Files | 49: Transportation Management | No |
| 22 | 812 | F49110 | BW | 83 | 4 | Transportation Bill of Lading Workfile | Work Files | 49: Transportation Management | No |
| 23 | 812 | F49111 | CD | 17 | 1 | Carton Detail Shipment Workfile | Files | 49: Transportation Management | Business Data |
| 24 | 812 | F49130 | BW | 44 | 1 | Shipment Document Workfile | Work Files | 49: Transportation Management | No |
| 25 | 812 | F49140 | BW | 49 | 1 | SSCC Print Label Workfile | Work Files | 49: Transportation Management | No |
| 26 | 812 | F49141 | PW | 39 | 1 | Packing List Workfile | Work Files | 49: Transportation Management | No |
| 27 | 812 | F49160 | NN | 16 | 1 | Document Next Number | Extra Features Files | 49: Transportation Management | AS400 Coexistence Tables |
| 28 | 812 | F49170 | NN | 3 | 1 | Load Next Numbers | Constants Files | 49: Transportation Management | AS400 Coexistence Tables |
| 29 | 812 | F4918 | LT | 18 | 2 | Load Tender History | Transaction Files | 49: Transportation Management | No |
| 30 | 812 | F49191 | DS | 24 | 1 | Document Definition | Master Files | 49: Transportation Management | No |
| 31 | 812 | F49195 | DU | 7 | 1 | Document Set - Keys Doc Code - Doc Set (Conversion from World) | Extra Features Files | 49: Transportation Management | AS400 Coexistence Tables |
| 32 | 812 | F49196 | DU | 7 | 2 | Document Set | Secondary Master Files | 49: Transportation Management | No |
| 33 | 812 | F49197 | OQ | 18 | 1 | Depot Document Print Set Up (Conversion from World File) | Secondary Master Files | 49: Transportation Management | AS400 Coexistence Tables |
| 34 | 812 | F49198 | OQ | 25 | 1 | Depot Document Print Setup | Secondary Master Files | 49: Transportation Management | No |
| 35 | 812 | F4930 | VM | 33 | 2 | Vehicle Master | Master Files | 49: Transportation Management | No |
| 36 | 812 | F49301 | VO | 17 | 1 | Vehicle Compartments | Master Files | 49: Transportation Management | No |
| 37 | 812 | F49302 | VE | 16 | 2 | Vehicle Equipment | Master Files | 49: Transportation Management | No |
| 38 | 812 | F4931 | VG | 45 | 1 | Vehicle Type | Master Files | 49: Transportation Management | No |
| 39 | 812 | F4935 | VH | 22 | 1 | Connected Vehicle Header | Master Files | 49: Transportation Management | No |
| 40 | 812 | F4936 | CW | 17 | 2 | Connected Vehicle Detail | Master Files | 49: Transportation Management | No |
| 41 | 812 | F49380 | SU | 18 | 4 | Seal Numbers | Transaction Files | 49: Transportation Management | No |
| 42 | 812 | F4941 | RS | 91 | 6 | Shipment Routing Steps | Transaction Files | 49: Transportation Management | No |
| 43 | 812 | F4942 | IS | 34 | 4 | Shipment Detail | Transaction Files | 49: Transportation Management | No |
| 44 | 812 | F4943 | SP | 28 | 6 | Shipment Pieces | Transaction Files | 49: Transportation Management | No |
| 45 | 812 | F4944 | OE | 21 | 1 | Shipment/Load Options and Equipment | Transaction Files | 49: Transportation Management | No |
| 46 | 812 | F4945 | SC | 45 | 8 | Shipment Charges | Transaction Files | 49: Transportation Management | No |
| 47 | 812 | F4947 | ST | 20 | 2 | Shipment Status Codes | Transaction Files | 49: Transportation Management | No |
| 48 | 812 | F49490 | TQ | 27 | 5 | Document Selection | Batch Input Files | 49: Transportation Management | No |
| 49 | 812 | F4950 | RT | 53 | 11 | Routing Entries | Master Files | 49: Transportation Management | No |
| 50 | 812 | F49501 | RD | 35 | 1 | Intermodal Detail Routing Entries | Master Files | 49: Transportation Management | No |
| 51 | 812 | F4951 | ZN | 18 | 1 | Carrier Zone Definitions | Master Files | 49: Transportation Management | No |
| 52 | 812 | F4952 | RE | 29 | 1 | Routing Restrictions | Master Files | 49: Transportation Management | No |
| 53 | 812 | F4953 | RG | 7 | 1 | Routing Hierarchy | Constants Files | 49: Transportation Management | No |
| 54 | 812 | F4956 | IX | 18 | 1 | Option and Equipment Inclusions/Exclusions | Master Files | 49: Transportation Management | No |
| 55 | 812 | F4957 | BC | 25 | 2 | Transportation Confirmed Batch Shipment | Constants Files | 49: Transportation Management | No |
| 56 | 812 | F49590 | DB | 15 | 1 | Document Print Batch Header | Batch Input Files | 49: Transportation Management | No |
| 57 | 812 | F49591 | DB | 25 | 3 | Document Print - Batch Selection | Work Files | 49: Transportation Management | No |
| 58 | 812 | F49592 | DH | 37 | 2 | Document Print Batch Document Header | Work Files | 49: Transportation Management | No |
| 59 | 812 | F49594 | DI | 40 | 2 | Document Print - Document Detail | Work Files | 49: Transportation Management | No |
| 60 | 812 | F49595 | DK | 35 | 3 | Document Print - Document Summary | Transaction Files | 49: Transportation Management | No |
| 61 | 812 | F4960 | TM | 79 | 4 | Load Header | Transaction Files | 49: Transportation Management | No |
| 62 | 812 | F4961 | LL | 33 | 1 | Load Legs | Transaction Files | 49: Transportation Management | No |
| 63 | 812 | F49611 | LD | 22 | 1 | Load Stop Sequence | Transaction Files | 49: Transportation Management | No |
| 64 | 812 | F49612 | TD | 18 | 2 | Load Vehicles | Transaction Files | 49: Transportation Management | No |
| 65 | 812 | F49614 | TS | 14 | 1 | Load Staff | Transaction Files | 49: Transportation Management | No |
| 66 | 812 | F4962 | TE | 31 | 2 | Load Compartments | Transaction Files | 49: Transportation Management | No |
| 67 | 812 | F49621 | TD | 46 | 2 | Load Compartment Detail | Transaction Files | 49: Transportation Management | No |
| 68 | 812 | F4963 | TI | 36 | 1 | Load In-transit | Transaction Files | 49: Transportation Management | No |
| 69 | 812 | F49631 | TO | 86 | 2 | Load In-transit Ledger | Transaction Files | 49: Transportation Management | No |
| 70 | 812 | F49632 | LB | 40 | 3 | Load In-transit Left on Board | Transaction Files | 49: Transportation Management | No |
| 71 | 812 | F49633 | IQ | 38 | 1 | Load In-Transit Confirmed Quantities | Files | 49: Transportation Management | |
| 72 | 812 | F49634 | QD | 29 | 1 | Load In-Transit Confirmed Quantities Detail | Files | 49: Transportation Management | |
| 73 | 812 | F49695 | DR | 35 | 1 | Document Register | Work Files | 49: Transportation Management | No |
| 74 | 812 | F49696 | DJ | 27 | 2 | Document Register Detail | Work Files | 49: Transportation Management | No |
| 75 | 812 | F49697 | DN | 24 | 3 | Document Register Summary | Extra Features Files | 49: Transportation Management | No |
| 76 | 812 | F4970 | FT | 10 | 1 | Freight Rate Schedule | Master Files | 49: Transportation Management | No |
| 77 | 812 | F4971 | RD | 49 | 1 | Freight Rate Definition | Master Files | 49: Transportation Management | No |
| 78 | 812 | F49711 | RV | 20 | 1 | Freight Rate Definition - Tag File | Master Files | 49: Transportation Management | No |
| 79 | 812 | F4972 | RX | 29 | 10 | Rate Detail | Master Files | 49: Transportation Management | No |
| 80 | 812 | F49721 | QS | 18 | 1 | Spot Quote Detail | Master Files | 49: Transportation Management | No |
| 81 | 812 | F4973 | TL | 14 | 4 | Rate Structure Definition | Master Files | 49: Transportation Management | No |
| 82 | 812 | F4977 | MR | 30 | 2 | Rate Parameters | Master Files | 49: Transportation Management | No |
| 83 | 812 | F4978 | CG | 16 | 1 | Charge Code Definitions | Master Files | 49: Transportation Management | No |
| 84 | 812 | F4981 | FH | 94 | 11 | Freight Audit History | History Files | 49: Transportation Management | Business Data |
| 85 | 812 | F49T00 | IC | | | Integration Constants | Files | 49: Transportation Management | |
| 86 | 812 | F49T01 | CR | | | Cross Reference | Files | 49: Transportation Management | |
| 87 | 812 | F49T05 | OR | | | OTM Record Reservation | Files | 49: Transportation Management | |
| 88 | 812 | F49T10 | OR | | | Sales Order Release Staging Table | Files | 49: Transportation Management | |
| 89 | 812 | F49T100 | OB | | | Procurement Freight Request staging table | Files | 49: Transportation Management | |
| 90 | 812 | F49T11 | IT | | | Item Staging Table | Files | 49: Transportation Management | |
| 91 | 812 | F49T20 | SS | | | Shipment Staging Table | Files | 49: Transportation Management | |
| 92 | 812 | F49T211 | TP | | | Sales Order Detail File - Secondary Tag Table | Files | 49: Transportation Management | |
| 93 | 812 | F49T30 | SO | | | Sales Confirm Staging Table | Files | 49: Transportation Management | |
| 94 | 812 | F49T311 | TP | | | Purchase Order Detail - OTM | Files | 49: Transportation Management | |
| 95 | 812 | F49T380 | SO | | | Seal Numbers | Files | 49: Transportation Management | |
| 96 | 812 | F49T40 | TC | | | Shipment Freight Cost Staging Table | Files | 49: Transportation Management | |
| 97 | 812 | F49T50 | LO | | | Order Release Location Staging | Files | 49: Transportation Management | |
| 98 | 812 | F49T60 | IV | | | Voucher Cross Reference | Files | 49: Transportation Management | |
| 99 | 812 | F49T70 | CS | | | Corporations Staging Table | Files | 49: Transportation Management | |
| 100 | 812 | F49T70W | CW | | | Corporations Staging Work Table | Files | 49: Transportation Management | |
| 101 | 812 | F49T80 | LC | | | Locations Staging Table | Files | 49: Transportation Management | |
| 102 | 812 | F49T80W | LW | | | Locations Staging Work Table | Files | 49: Transportation Management | |
| 103 | 812 | F49T90 | IT | | | Inbound Transmissions | Files | 49: Transportation Management | |
