| 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 | 231 | REF_POSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | | |
2 | JHAGVX | IS-M/AM: Order Sales Agent Assignment Settlement Index | 15 | REF_POSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | | |
3 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 98 | REF_POSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | | |
4 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 95 | REF_POSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | | |
TOPCustomer Bill of Services |
5 | /SAPBOQ/HD_SES | QTO header table | 19 | REF_POSNR | Item number of the SD document | nvarchar | 6 | 0 | | |
TOPMedia Product Sales and Distribution |
6 | JKSDCREDITMEMO | IS-M/SD Worklist of Mass Credit Memos | 17 | REF_POSNR | Sales Document Item | nvarchar | 6 | 0 | | |
7 | JKSDUNSOLDITEM | IS-M: Item Data on Unsold Copies/Credit Memos | 20 | REF_POSNR | Sales Document Item | nvarchar | 6 | 0 | | |