| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTKGSPRO | IS-M/SD: District Municipality File | 7 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
2 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 11 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
3 | JSTORTPRO | IS-M/SD: City File (Post) | 13 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
4 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 16 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
5 | JSTOTLPRO | IS-M: City District File | 8 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
6 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 12 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
7 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 10 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
8 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 5 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
9 | JSTPLZPRO | IS-M: Postal Codes | 11 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
10 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 15 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
11 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 6 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
12 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 12 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
13 | JSTSTRPRO | IS-M/SD: Street File (Post) | 22 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
14 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 24 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
15 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 12 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
16 | JST_ORT_CONS | IS-M: Table for City Consolidation | 18 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
17 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 16 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
18 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 16 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
19 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 15 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
20 | JST_STR_CONS | IS-M: Table for Street Consolidation | 26 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
TOPSAP Media |
21 | J_1SBOTPRO | IS-M/SD CH/S: CH Carrier Data | 18 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
22 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 29 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
23 | J_1SSTRPRO | IS-M/SD CH/S: CH Street Data | 11 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |
24 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 34 | X_FEHLER | IS-M: Incorrect data record | nvarchar | 1 | 0 | | |