| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICFSRV4ADMIN_LOG | ICF Services, which only have to be used for administration | 3 | VERSION_NR | | int | 10 | 0 | | |
2 | ICFSRV4ADM_LOLOG | Local Log table for ICFSRV4ADMIN_LOG | 3 | VERSION_NR | | int | 10 | 0 | | |
3 | UCON_CHANGE_DOC | Change Documents for Unified Connectivity Entities | 3 | VERSION_NR | Natural Number | int | 10 | 0 | | |
TOPMaster Data |
4 | JSTALIAS | IS-M: Alias Table for Streets | 44 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
5 | JSTCOUNTY | IS-M: Counties or Administrative Districts from USPS (USA) | 10 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
6 | JSTKGSPRO | IS-M/SD: District Municipality File | 17 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
7 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 21 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
8 | JSTORTPRO | IS-M/SD: City File (Post) | 23 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
9 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 26 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
10 | JSTOTLPRO | IS-M: City District File | 18 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
11 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 22 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
12 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 20 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
13 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 15 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
14 | JSTPLZPRO | IS-M: Postal Codes | 21 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
15 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 25 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
16 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 16 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
17 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 22 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
18 | JSTSTRDAVERW | Reference Table for Street Records from DBP | 17 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
19 | JSTSTRPRO | IS-M/SD: Street File (Post) | 32 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
20 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 34 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
21 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 22 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
22 | JST_ORT_CONS | IS-M: Table for City Consolidation | 28 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
23 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 26 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
24 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 26 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
25 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 25 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
26 | JST_STR_CONS | IS-M: Table for Street Consolidation | 36 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
27 | TJS00 | IS-M/SD: Version Update for Postal Data | 4 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
28 | TJS40 | Version Administration for Postal Data - Country-Dependent | 5 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
TOPPeriodical Sales and Distribution |
29 | JST_PLO_CONS | IS-M: Table for Consolidating Postal Code-City | 20 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
TOPSAP Media |
30 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 39 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
31 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 44 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | |
TOPTravel Expenses |
32 | PTRV_CCC | Error Receipts for Credit Card Clearing | 28 | VERSION_NR | Number of Credit Card Accounting Run | nvarchar | 10 | 0 | | |