| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 8 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
2 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 3 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
3 | JSTPLZPRO | IS-M: Postal Codes | 3 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
4 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 7 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
5 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 7 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
6 | JST_PLZ_STATE | Status of Postal Code Checks | 7 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
7 | JST_PLO_CONS | IS-M: Table for Consolidating Postal Code-City | 8 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |
8 | JST_PLO_STATE | Status of Postal Code Checks | 8 | PLZLFDNR | IS-M/SD: Sequence number for postal code (for history) | nvarchar | 3 | 0 | | |