| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 43 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
2 | JSTLAUF | IS-M/SD: Round Sequence | 19 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
3 | JSTPLZPRO | IS-M: Postal Codes | 27 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
4 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 31 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
5 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 19 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
6 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 25 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
7 | JSTSTRPRO | IS-M/SD: Street File (Post) | 44 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
8 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 46 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
9 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 32 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
10 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 28 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
11 | JST_STR_CONS | IS-M: Table for Street Consolidation | 48 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
TOPSAP Media |
12 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 51 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |
13 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 56 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | |