| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAPD | IS-M/AM: OPM Service Item | 8 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 2 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 57 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 3 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 54 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 4 | JHTTBED | IS-M/AM: OPM - Rate Requirements | 30 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 5 | JHTVBPO | IS-M/AM: Contract Requirement Element | 25 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 6 | JJTBB | IS-M/AM: Requirement Element of Media Sales Agent Contract | 19 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 7 | JJTDIEN | IS-M/AM: Service | 3 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 8 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 29 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 9 | TJH71 | IS-M/AM: Service Type | 2 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
| 10 | TJH72 | IS-M/AM: Service Type Texts | 3 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | |
