| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTSTRPRO | IS-M/SD: Street File (Post) | 39 | RECORDTYPECODE | Record Type in ZIP+4 File | nvarchar | 1 | 0 | | |
2 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 41 | RECORDTYPECODE | Record Type in ZIP+4 File | nvarchar | 1 | 0 | | |
3 | JST_STR_CONS | IS-M: Table for Street Consolidation | 43 | RECORDTYPECODE | Record Type in ZIP+4 File | nvarchar | 1 | 0 | | |
TOPSAP Media |
4 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 46 | RECORDTYPECODE | Record Type in ZIP+4 File | nvarchar | 1 | 0 | | |
5 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 51 | RECORDTYPECODE | Record Type in ZIP+4 File | nvarchar | 1 | 0 | | |