| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTKGSPRO | IS-M/SD: District Municipality File | 2 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
2 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 6 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
3 | JSTORTPRO | IS-M/SD: City File (Post) | 9 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
4 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 12 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
5 | JSTOTLPRO | IS-M: City District File | 4 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
6 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 8 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
7 | JSTSTRDAVERW | Reference Table for Street Records from DBP | 27 | KREISG_SCH | IS-M: Postal district municipality key for transfer | nvarchar | 8 | 0 | | |
8 | JSTSTRPRO | IS-M/SD: Street File (Post) | 12 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
9 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 14 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
10 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 6 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
11 | JST_KGS_STATE | Status of DMK Checks | 6 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
12 | JST_ORT_CONS | IS-M: Table for City Consolidation | 14 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
13 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 12 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
14 | JST_STR_CONS | IS-M: Table for Street Consolidation | 16 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
15 | TJS17 | IS-M/SD: Assignment of Region to District Municipality Key | 3 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
TOPPeriodical Sales and Distribution |
16 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 44 | KREISG_SCH | IS-M: District municipality key of ship-to party | nvarchar | 15 | 0 | | |
17 | JKAPRV | IS-M/SD: Sales Order - Retroactive Shipping Data | 18 | KREISG_SCH | IS-M: District municipality key of ship-to party | nvarchar | 15 | 0 | | |
18 | JKPA | Sales Order: Partner | 25 | KREISG_SCH | IS-M: District municipality key of ship-to party | nvarchar | 15 | 0 | | |
TOPSAP Media |
19 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 19 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |
20 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 24 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | |