| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | MKAL | Production Versions of Material | 24 | ALORT | Receiving storage location for repetitive manufacturing | nvarchar | 4 | 0 | | |
TOPMaster Data |
2 | JSTALIAS | IS-M: Alias Table for Streets | 30 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
3 | JSTORTPRO | IS-M/SD: City File (Post) | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
4 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 5 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
5 | JSTOTLPRO | IS-M: City District File | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
6 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 6 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
7 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 9 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
8 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 4 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
9 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
10 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 8 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
11 | JSTSTRDAVERW | Reference Table for Street Records from DBP | 1 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
12 | JSTSTRPRO | IS-M/SD: Street File (Post) | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
13 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 6 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
14 | JST_ORT_CONS | IS-M: Table for City Consolidation | 5 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
15 | JST_ORT_STATE | Status of City Checks | 5 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
16 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 7 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
17 | JST_OTL_STATE | Status of CDT Checks | 7 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
18 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 8 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
19 | JST_POF_STATE | Status of PO Box Checks | 8 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
20 | JST_STR_CONS | IS-M: Table for Street Consolidation | 6 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
21 | JST_STR_STATE | Status of Street Checks | 6 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
22 | SAFK | Run Schedule Master Data | 39 | ALORT | Receiving storage location for repetitive manufacturing | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
23 | JST_PLO_CONS | IS-M: Table for Consolidating Postal Code-City | 9 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
24 | JST_PLO_STATE | Status of Postal Code Checks | 9 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
TOPRepetitive Manufacturing |
25 | RMIO | Input Structure of Repetitive Manufacturing Confirmation | 5 | ALORT | Receiving storage location for repetitive manufacturing | nvarchar | 4 | 0 | | |
26 | RMUSER | User Settings for REM Backflush Transactions | 5 | ALORT | Receiving storage location for repetitive manufacturing | nvarchar | 4 | 0 | | |
TOPSAP Media |
27 | J_1SBOTPRO | IS-M/SD CH/S: CH Carrier Data | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
28 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 14 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
29 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
30 | J_1SSTRPRO | IS-M/SD CH/S: CH Street Data | 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
31 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 16 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |