| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTBEZBEZ | IS-M/SD: Assgmt Table for Carrier Route-Carrier Route Assgmt | 10 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
2 | JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units | 10 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
3 | JSTGEOHIE | IS-M/SD: Geographical Hierarchy | 11 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
4 | JSTGEOORG | IS-M/SD: Assignment of Geographical to Organizational Units | 10 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
5 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 20 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
6 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 32 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
7 | JSTORGHIE | IS-M/SD: Organizational Plan Hierarchy | 10 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
8 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 49 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
9 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 33 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
10 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 30 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
11 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 45 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
12 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 37 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
13 | JSTROUPVA | IS-M/SD: Truck Route-Publication/Edition Assignment | 12 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
14 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 74 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
15 | JRTABLDBAR | IS-M/SD: Unloading Viability Set | 9 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
16 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 21 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
17 | JRTROUBEA | IS-M/SD: Truck Route Unloading Point Sequence | 10 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
18 | JRTROUHIE | IS-M/SD: Truck Route Hierarchy | 11 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
19 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 39 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |
20 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 21 | AENDNRBISD | Date of Change Number Used to Change To-Date | nvarchar | 1 | 0 | | |