| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | INHK_TECH1 | IS-M: Technical Content Component (Positioning View) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | INHK_TLEV1 | IS-M: Level 1 content component in the hierarchy | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | INHK_TECH2 | IS-M: Special Publication Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | INHK_KFM | IS-M: Business Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | INHK_KLEV1 | IS-M: Level 1 content component in the hierarchy | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | MVA_INHALT | IS-M: Media Publication Content Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | PLAZIERUNG | IS-M/AM: Positioning Instruction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | AZART_PLAZ | IS-M: Ad Type with Regard to General Positioning | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | TEC_AVM_NR | IS-M: Order number in technical system | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | XPLANUNG | IS-M: Relevant for planning indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | XBLATTBEST | IS-M: Page-Defining Indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | TBEL | IS-M: Selective Booking (Advertisement Item Type) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | XTEXT_INT | IS-M: Internal positioning comment indicator | char | 1 | 0 | | | | Allow NULL? |
| 17 | XTEXT_EXT | IS-M: External positioning comment exists indicator | char | 1 | 0 | | | | Allow NULL? |
| 18 | XFESTPLATZ | IS-M: Positioning Ad Type is a Fixed Positioning Indicator | char | 1 | 0 | | | | Allow NULL? |
| 19 | XROHTKNZ | IS-M: Raw Text Available for the Item Indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | XGESTREUT | IS-M: Ad Spec Should Be Scattered Indicator | char | 1 | 0 | | | | Allow NULL? |
| 21 | TERM_TYP | IS-M/AM: Date Category Copy Number/Publication Date | char | 1 | 0 | | | | Allow NULL? |
| 22 | ANFANG_PER | IS-M: Start of Copy/Publication Date Period | nvarchar | 14 | 0 | | | | Allow NULL? |
| 23 | ENDE_PER | IS-M: End of Period - Issue/Publication Date | nvarchar | 14 | 0 | | | | Allow NULL? |
| 24 | SELDAT_VON | IS-M: Start Date for Item | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | BIS_PLUS | IS-M: Indicates a Period ("-") or 2 Dates ("+") | char | 1 | 0 | | | | Allow NULL? |
| 27 | ANZ_SCHALT | IS-M: Number of Placements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | TERM_ZYKL | IS-M: Frequency for Ad Publication | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | TERMINART | IS-M/AM: Type of Publication Date | char | 1 | 0 | | | | Allow NULL? |
| 30 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | WUNSCH_T | IS-M/AM: Date Required | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | X_MONTAG | IS-M: Date Field Indicator - Monday | char | 1 | 0 | | | | Allow NULL? |
| 33 | X_DIENSTAG | IS-M: Date Field Indicator - Tuesday | char | 1 | 0 | | | | Allow NULL? |
| 34 | X_MITTWOCH | IS-M: Date Field Indicator - Wednesday | char | 1 | 0 | | | | Allow NULL? |
| 35 | X_DONNERST | IS-M: Date Field Indicator - Thursday | char | 1 | 0 | | | | Allow NULL? |
| 36 | X_FREITAG | IS-M: Date Field Indicator - Friday | char | 1 | 0 | | | | Allow NULL? |
| 37 | X_SAMSTAG | IS-M: Date Field Indicator - Saturday | char | 1 | 0 | | | | Allow NULL? |
| 38 | X_SONNTAG | IS-M: Date Field Indicator - Sunday | char | 1 | 0 | | | | Allow NULL? |
| 39 | CHIFFRE_NR | IS-M/AM: Box Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | CHIFFRE_KZ | IS-M: Box Number Indicator | char | 1 | 0 | | | | Allow NULL? |
| 41 | CHIFFRE_OR | IS-M: Box Number Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | XUVMOT | IS-M: "Ad spec data incomplete" indicator | char | 1 | 0 | | | | Allow NULL? |
| 43 | XUVTECH | IS-M: Incomplete Regarding Technical System (Gen.) | char | 1 | 0 | | | | Allow NULL? |
| 44 | XNOCHG_TEC | IS-M: Cannot be changed for technical reasons indicator | char | 1 | 0 | | | | Allow NULL? |
| 45 | XTECH_MIN1 | IS-M: Tech.process.started (for at least 1 schedule line) | char | 1 | 0 | | | | Allow NULL? |
| 46 | XTECH_EE | IS-M: Tech.Complete (All Schedule Lines Fully Processed) | char | 1 | 0 | | | | Allow NULL? |
| 47 | XSPERR_TEC | IS-M: Blocked in technical system indicator | char | 1 | 0 | | | | Allow NULL? |
| 48 | AENVERS_NR | IS-M: Last Change Version for Technical System | nvarchar | 4 | 0 | | | | Allow NULL? |
| 49 | MERKMAL0 | IS-M: Characteristic 0 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 50 | MERKMAL1 | IS-M: Characteristic 1 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 51 | MERKMAL2 | IS-M: Characteristic 2 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 52 | MERKMAL3 | IS-M: Characteristic 3 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 53 | MERKMAL4 | IS-M: Characteristic 4 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 54 | MERKMAL5 | IS-M: Characteristic 5 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 55 | MERKMAL6 | IS-M: Characteristic 6 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 56 | MERKMAL7 | IS-M: Characteristic 7 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 57 | MERKMAL8 | IS-M: Characteristic 8 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 58 | MERKMAL9 | IS-M: Characteristic 9 for Individual Use (Ad Item) | char | 1 | 0 | | | | Allow NULL? |
| 59 | KONKAUS | IS-M: Competitor exclusion | nvarchar | 2 | 0 | | | | Allow NULL? |
| 60 | KONKAUSKOM | IS-M: Comment on competitor exclusion | nvarchar | 35 | 0 | | | | Allow NULL? |
| 61 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | | | Allow NULL? |
| 62 | SORTWORT | IS-M: Sort Word | nvarchar | 10 | 0 | | | | Allow NULL? |
