| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
2 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
3 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
4 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
5 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
6 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
7 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
8 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
9 | JST_KGS_STATE | Status of DMK Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
10 | JST_ORT_CONS | IS-M: Table for City Consolidation | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
11 | JST_ORT_STATE | Status of City Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
12 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
13 | JST_OTL_STATE | Status of CDT Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
14 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
15 | JST_PLZ_STATE | Status of Postal Code Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
16 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
17 | JST_POF_STATE | Status of PO Box Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
18 | JST_STR_CONS | IS-M: Table for Street Consolidation | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
19 | JST_STR_STATE | Status of Street Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
20 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
21 | JST_PLO_CONS | IS-M: Table for Consolidating Postal Code-City | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
22 | JST_PLO_STATE | Status of Postal Code Checks | 2 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
TOPSAP Media |
23 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 9 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |
24 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 7 | LAND1_ALT | Country Key | nvarchar | 3 | 0 | | |