| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMedia Product |
| 1 | JPTIDCODE | List of ID Codes Used | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 2 | JPTIDCODES | Not used IS-MPD: List of Available ID Codes | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 3 | TJPIDCAREA | ID Code Area | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 4 | TJPIDCAREAT | ID Code Area Text Table | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 5 | TJPIDCNUMAR | ID Code Number Range | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 6 | TJPIDCNUMART | ID Code Number Range | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 7 | TJPIDCTYP | Identification Code Types | 2 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
| 8 | TJPIDCTYPT | Texts for Identification Code Types | 3 | ISMIDCODETYPE | Type of Identification Code | nvarchar | 4 | 0 | | |
