| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BEDNR | IS-M/AM: Key for a Requirement in the Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | POSNR | IS-M: Requirement Element Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | AVMPOS_AR1 | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | AVMPOS_AR2 | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | AVMPOS_AR3 | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | AVMPOS_AR4 | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | AVMPOS_AR5 | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | AVMPOS_AR6 | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | PSTYV | IS-M: Item Category for Sales Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | AZART_AREA | IS-M/AM: Fixed Format Proposal /Ad Dimensions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | AZART_FORM | IS-M: Shape Ad Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | AZART_FARB | IS-M: Color Scheme Ad Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | AZART_GEST | IS-M: Design Ad Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | AZART_RECH | IS-M: Calculation Ad Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | INHK_KFM | IS-M: Business Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | INHK_SOVER | IS-M: Special Publication Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | BELEINH1 | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | KONDA | Price group (customer) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | SINSBEARB | IS-M: Ad Insert Processing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | SI_TYP | IS-M: Ad Insert Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | XRESTHSHLT | IS-M: Total Market Coverage Indicator | char | 1 | 0 | | | | Allow NULL? |
| 23 | XTEILBELEG | IS-M: Selective/Full Booking Indicator | char | 1 | 0 | | | | Allow NULL? |
| 24 | MIN_BELEG | IS-M: Minimum Booking in Percent | decimal | 4 | 2 | | | | |
| 25 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | WS_ART | IS-M: Commercial Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | PRODH | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | | | Allow NULL? |
| 28 | KAMPAGNE | IS-M: Campaign (customer) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | SI_TYP_V | IS-M: Ad Insert Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | JVTBEPMART | IS-M/AM: Distribution Planned Quantity Types | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | XVTEILBELEG | IS-M: Selective/Full Booking Indicator | char | 1 | 0 | | | | Allow NULL? |
| 32 | BOOK_OL | IS-M/AM: Booking Type for Online Advertising | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | FORMAT_ONL | IS-M/AM: Format Proposal (Online) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | VAVTYP | Issue Variant Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | PK_RELEVANCE | Package Relevance | char | 1 | 0 | | | | Allow NULL? |
| 36 | PACKAGE_TYPE | Package Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | PACKAGE_CATEGORY | Package Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 38 | PACKAGE_ID | Package | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | BUPGR | IS-M: BU Grouping for Pricing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | PLAZIERANW | IS-M/AM: Positioning Instruction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | QUAL_FR_DISCOUNT | IS-M: Assignment Qualifies for Discount | char | 1 | 0 | | | | Allow NULL? |
| 43 | CNTS_TD_DISCOUNT | IS-M: Assignment Counts Towards Discount Fulfillment | char | 1 | 0 | | | | Allow NULL? |
| 44 | UOM_SIZE | UOM for Ad Size | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | MIN_SIZE | Minimum Size | decimal | 13 | 3 | | | | |
| 46 | AD_SIZEW | Absolute Ad Size for Fulfillment of Contract | decimal | 13 | 3 | | | | |
| 47 | UOM_WF | UOM for Absolute Ad Size for Fulfillment of Contract | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | PERC_WF | Weighting Factor as a Percentage | decimal | 6 | 3 | | | | |
| 49 | MAX_SIZE | Maximum Size | decimal | 13 | 3 | | | | |
| 50 | AD_SIZEW_AI | Absolute Ad Qnty for Fulfillment of Contract for Ad Ins | decimal | 13 | 3 | | | | |
| 51 | UOM_WF_AI | UOM for Absolute Ad Qnty for Contrct Fulfill. for Ad Ins | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | PERC_WF_AI | Weighted Factor as a Percentage for Ad Inserts | decimal | 6 | 3 | | | | |
