| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHASIZ | IS-M/AM: OPM Ad Insert Assignment | 6 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
2 | JDTVAUSGB | IS-M/SD: Issues | 69 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
3 | JVTMCI_ITEM | IS-M: TMCI Household Addresses for AI Schedule Lines | 8 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
4 | JVTSIANZUO | IS-M: Assignment of Insert Mix to AI Orders | 8 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
5 | JVTSIBLMNG | IS-M: Worklist for Quantity Correction to AI Insertion | 2 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
6 | JVTSIBLZUO | IS-M: Assignment of Insert Mix to AI Orders | 8 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
7 | JVTSIRHMNG | IS-M: Worklist for Quantity Correction to Ad Insert TMC | 2 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |
8 | JVTSIVTMNG | IS-M: Worklist for Quantity Correction to AI Distribution | 2 | SI_NUMMER | IS-M: Ad Insert Number | nvarchar | 10 | 0 | | |