| 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 | JVTBEPMART | IS-M/AM: Distribution Planned Quantity Types | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | VRTMENGE_V | IS-M/AM: Planned Quantity for Distribution Full Booking | decimal | 9 | 0 | | | | |
| 6 | VRTMENGE | IS-M/AM: Actual Quantity for Distribution | decimal | 9 | 0 | | | | |
| 7 | BERMENGE | IS-M: Calculation Quantity (Ad Insert) | decimal | 9 | 0 | | | | |
| 8 | XBERMENGE_FIX | IS-M/AM: Calculation Quantity is Fixed indicator | char | 1 | 0 | | | | Allow NULL? |
| 9 | BLGMENGE | IS-M/AM: Delivery quantity for distribution | decimal | 9 | 0 | | | | |
| 10 | XTBEL_VT | IS-M: Selective Booking For Distribution BU Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | SI_TYP | IS-M: Ad Insert Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | SI_GEWICHT | IS-M: Ad Insert Weight | decimal | 9 | 3 | | | | |
| 13 | MEINHGEWBL | IS-M: Unit of Weight for Ad Insert | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | SI_ENTSPFL | IS-M: Waste Disposal Required Indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | SI_VERBWER | IS-M: Tie-In Ads Indicator | char | 1 | 0 | | | | Allow NULL? |
| 16 | ANZSEITEN | Number of Pages in Issue | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | TERM_TYP | IS-M/AM: Date Category Copy Number/Publication Date | char | 1 | 0 | | | | Allow NULL? |
| 18 | ANFANG_PER | IS-M: Start of Copy/Publication Date Period | nvarchar | 14 | 0 | | | | Allow NULL? |
| 19 | ENDE_PER | IS-M: End of Period - Issue/Publication Date | nvarchar | 14 | 0 | | | | Allow NULL? |
| 20 | SELDAT_VON | IS-M: Start Date for Item | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | SELDAT_BIS | IS-M: End Date for Items | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | BIS_PLUS | IS-M: Indicates a Period ("-") or 2 Dates ("+") | char | 1 | 0 | | | | Allow NULL? |
| 23 | ANZ_SCHALT | IS-M: Number of Placements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | TERM_ZYKL | IS-M: Frequency for Ad Publication | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | TERMINART | IS-M/AM: Type of Publication Date | char | 1 | 0 | | | | Allow NULL? |
| 26 | ERSCH_T | IS-M: Publication Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | WUNSCH_T | IS-M/AM: Date Required | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | X_MONTAG | IS-M: Date Field Indicator - Monday | char | 1 | 0 | | | | Allow NULL? |
| 29 | X_DIENSTAG | IS-M: Date Field Indicator - Tuesday | char | 1 | 0 | | | | Allow NULL? |
| 30 | X_MITTWOCH | IS-M: Date Field Indicator - Wednesday | char | 1 | 0 | | | | Allow NULL? |
| 31 | X_DONNERST | IS-M: Date Field Indicator - Thursday | char | 1 | 0 | | | | Allow NULL? |
| 32 | X_FREITAG | IS-M: Date Field Indicator - Friday | char | 1 | 0 | | | | Allow NULL? |
| 33 | X_SAMSTAG | IS-M: Date Field Indicator - Saturday | char | 1 | 0 | | | | Allow NULL? |
| 34 | X_SONNTAG | IS-M: Date Field Indicator - Sunday | char | 1 | 0 | | | | Allow NULL? |
| 35 | XUVSI | IS-M: Ad Insert Data Incomplete Indicator | char | 1 | 0 | | | | Allow NULL? |
| 36 | XVT_PLAZ | IS-M: Indicator distribution "positioned" | char | 1 | 0 | | | | Allow NULL? |
| 37 | XMUSTER_OK | IS-M: Sample Received and Checked Indicator | char | 1 | 0 | | | | Allow NULL? |
| 38 | XSI_VORH | IS-M: AI Copies Exist | char | 1 | 0 | | | | Allow NULL? |
| 39 | XUVTECH | IS-M: Incomplete Regarding Technical System (Gen.) | char | 1 | 0 | | | | Allow NULL? |
| 40 | XTECH_MIN1 | IS-M: Tech.process.started (for at least 1 schedule line) | char | 1 | 0 | | | | Allow NULL? |
| 41 | XTECH_EE | IS-M: Tech.Complete (All Schedule Lines Fully Processed) | char | 1 | 0 | | | | Allow NULL? |
| 42 | MERKMAL0 | IS-M: Characteristic 0 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 43 | MERKMAL1 | IS-M: Characteristic 1 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 44 | MERKMAL2 | IS-M: Characteristic 2 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 45 | MERKMAL3 | IS-M: Characteristic 3 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 46 | MERKMAL4 | IS-M: Characteristic 4 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 47 | MERKMAL5 | IS-M: Characteristic 5 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 48 | MERKMAL6 | IS-M: Characteristic 6 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 49 | MERKMAL7 | IS-M: Characteristic 7 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 50 | MERKMAL8 | IS-M: Characteristic 8 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 51 | MERKMAL9 | IS-M: Characteristic 9 for Individual Use (Distributn Item) | char | 1 | 0 | | | | Allow NULL? |
| 52 | KONKAUS | IS-M: Competitor exclusion | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | KONKAUSKOM | IS-M: Comment on competitor exclusion | nvarchar | 35 | 0 | | | | Allow NULL? |
| 54 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | | | Allow NULL? |
| 55 | SORTWORT | IS-M: Sort Word | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | STICHW | IS-M: Keyword | nvarchar | 40 | 0 | | | | Allow NULL? |
| 57 | INHK_KFM | IS-M: Business Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
