| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHAMEZ | IS-M/AM: Order Item Schedule Line Data (Manual) Assignment | 5 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
2 | JHAPA | IS-M/AM: Order-Publishing-Media Ad Item | 30 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
3 | JHAPS | IS-M/AM: OPM Ad Insert Item | 35 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
4 | JHAPV | IS-M/AM: OPM Distribution Item | 26 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
5 | JHATRZ | IS-M/AM: Order Item Date Assignment | 4 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
6 | JHATRZW | IS-M/AM: Order Item Date Assignment (Commercial) | 4 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
7 | JHWWWTEMP_ET | IS-M/AM: Temporary Table for Additional Publication Dates | 3 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
8 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 9 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |
9 | JJTBEDWSIN | IS-M/AM: Booking Unit Content for Commercial (Date-Specific) | 3 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | |