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