| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JGTSADR | IS-M: Extended Address Management | 39 | POSTDIRECTIONAL | Directional for Street Name | nvarchar | 10 | 0 | | |
2 | JSTALIAS | IS-M: Alias Table for Streets | 25 | POSTDIRECTIONAL | Directional for Street Name | nvarchar | 10 | 0 | | |
3 | JSTSTRPRO | IS-M/SD: Street File (Post) | 38 | POSTDIRECTIONAL | Postdirectional | nvarchar | 10 | 0 | | |
4 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 40 | POSTDIRECTIONAL | Postdirectional | nvarchar | 10 | 0 | | |
5 | JST_STR_CONS | IS-M: Table for Street Consolidation | 42 | POSTDIRECTIONAL | Postdirectional | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
6 | JKWWWTEMP_BP | IS-M/SD: WWW, Temporary Table for BP Data from Internet | 20 | POSTDIRECTIONAL | Directional for Street Name | nvarchar | 10 | 0 | | |
7 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 38 | POSTDIRECTIONAL | Directional for Street Name | nvarchar | 10 | 0 | | |
8 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 38 | POSTDIRECTIONAL | Directional for Street Name | nvarchar | 10 | 0 | | |
9 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 19 | POSTDIRECTIONAL | Directional for Street Name | nvarchar | 10 | 0 | | |
TOPSAP Media |
10 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 45 | POSTDIRECTIONAL | Postdirectional | nvarchar | 10 | 0 | | |
11 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 50 | POSTDIRECTIONAL | Postdirectional | nvarchar | 10 | 0 | | |