| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 245 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 2 | JHAP | IS-M/AM: Order-Publishing-Media Item | 128 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 3 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 101 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 4 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 98 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 5 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 75 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 6 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 72 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 7 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 93 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
| 8 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 57 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | | |
