| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAP | IS-M/AM: Order-Publishing-Media Item | 114 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
| 2 | JHAPA | IS-M/AM: Order-Publishing-Media Ad Item | 25 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
| 3 | JHAPS | IS-M/AM: OPM Ad Insert Item | 30 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
| 4 | JHAPV | IS-M/AM: OPM Distribution Item | 21 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
| 5 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 82 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
| 6 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 79 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
| 7 | JHA_ORDER_INDEX | Selection Index for Orders | 4 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | |
