| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTCOUNTY | IS-M: Counties or Administrative Districts from USPS (USA) | 3 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
2 | JSTORTPRO | IS-M/SD: City File (Post) | 34 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
3 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 37 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
4 | JSTPLZPRO | IS-M: Postal Codes | 32 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
5 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 36 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
6 | JSTSTRPRO | IS-M/SD: Street File (Post) | 51 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
7 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 53 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
8 | JST_ORT_CONS | IS-M: Table for City Consolidation | 39 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
9 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 37 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
10 | JST_STR_CONS | IS-M: Table for Street Consolidation | 55 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
TOPSAP Media |
11 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 58 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |
12 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 63 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | |