| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JGTSADR | IS-M: Extended Address Management | 40 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
2 | JSTALIAS | IS-M: Alias Table for Streets | 26 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
3 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 41 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
4 | JSTLAUF | IS-M/SD: Round Sequence | 17 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
5 | JSTPLZPRO | IS-M: Postal Codes | 25 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
6 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 29 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
7 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 17 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
8 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 23 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
9 | JSTSTRPRO | IS-M/SD: Street File (Post) | 42 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
10 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 44 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
11 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 30 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
12 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 26 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
13 | JST_STR_CONS | IS-M: Table for Street Consolidation | 46 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
14 | TJS43 | IS-M: Abbreviations for Secondary Address Texts | 2 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
15 | TJS44 | IS-M: Text for Abbreviations for Secondary Address Texts | 2 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
16 | JKWWWTEMP_BP | IS-M/SD: WWW, Temporary Table for BP Data from Internet | 26 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
17 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 44 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
18 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 44 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
19 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 25 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
TOPSAP Media |
20 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 49 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |
21 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 54 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | |