| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PACKAGE_ID | Package | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PK_ELEMENT_ID | Package Element ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | ADMV_ID | Admissible Values for a Package Element (ID) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | SEQUENCE_ID | Access Sequence | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | PSTYV | IS-M: Item Category for Sales Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | BOOKING_UNIT | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | CONT_COMP_LEV1 | IS-M: Level 1 content component in the hierarchy | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BUS_CONT_COMP | IS-M: Business Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | TECH_COMP_LEV1 | IS-M: Level 1 content component in the hierarchy | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | TECH_CONT_COMP | IS-M: Technical Content Component (Positioning View) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | SPEC_CONT_COMP | IS-M: Special Publication Content Component | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | AD_DESIGN_TYPE | IS-M: Design Ad Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | AD_FIXED_FORMAT | IS-M/AM: Fixed Format Proposal /Ad Dimensions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | AD_COLOR_SCHEME | IS-M: Color Scheme Ad Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | AD_SHAPE | IS-M: Shape Ad Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | POS_INSTRUCTION | IS-M/AM: Positioning Instruction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | POS_AD_TYPE | IS-M: Ad Type with Regard to General Positioning | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | AD_SPEC_HANDLING | IS-M: Ad Type - Special Handling Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | DATE_SPEC | IS-M/AM: Specify Dates for Date Combinations | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | DATE_CATEGORY | IS-M/AM: Date Category Copy Number/Publication Date | char | 1 | 0 | | | | Allow NULL? |
| 22 | PUBL_FREQUENCY | IS-M: Frequency for Ad Publication | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | WEB_PUBLICATION | IS-M/AM: Indicator - Booking Unit for Internet Publication | char | 1 | 0 | | | | Allow NULL? |
| 24 | MONDAY | IS-M: Date Field Indicator - Monday | char | 1 | 0 | | | | Allow NULL? |
| 25 | TUESDAY | IS-M: Date Field Indicator - Tuesday | char | 1 | 0 | | | | Allow NULL? |
| 26 | WEDNESDAY | IS-M: Date Field Indicator - Wednesday | char | 1 | 0 | | | | Allow NULL? |
| 27 | THURSDAY | IS-M: Date Field Indicator - Thursday | char | 1 | 0 | | | | Allow NULL? |
| 28 | FRIDAY | IS-M: Date Field Indicator - Friday | char | 1 | 0 | | | | Allow NULL? |
| 29 | SATURDAY | IS-M: Date Field Indicator - Saturday | char | 1 | 0 | | | | Allow NULL? |
| 30 | SUNDAY | IS-M: Date Field Indicator - Sunday | char | 1 | 0 | | | | Allow NULL? |
| 31 | PLAN_HEIGHT | IS-M: Planned Height of the Ad Spec | decimal | 7 | 3 | | | | |
| 32 | HEIGHT_UOM | IS-M: Unit of Measure for Height | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | PLAN_WIDTH | IS-M: Planned Ad Spec Width | decimal | 7 | 3 | | | | |
| 34 | WIDTH_UOM | IS-M/AM: Unit of Measure for Width | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | NUM_OF_PUBL | IS-M: Number of Placements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | PLAN_HEIGHT_MIN | IS-M: Minimum Planned Ad Spec Height | decimal | 7 | 3 | | | | |
| 37 | PLAN_HEIGHT_MAX | IS-M: Maximum Planned Ad Spec Height | decimal | 7 | 3 | | | | |
| 38 | PLAN_WIDTH_MIN | IS-M: Minimum Planned Ad Spec Width | decimal | 7 | 3 | | | | |
| 39 | PLAN_WIDTH_MAX | IS-M: Maximum Planned Ad Spec Width | decimal | 7 | 3 | | | | |
| 40 | AD_SIZE_MIN | IS-M: Minimum Ad Size | decimal | 13 | 3 | | | | |
| 41 | AD_SIZE_MAX | IS-M: Maximum Ad Size | decimal | 13 | 3 | | | | |
| 42 | NUM_OF_PUBL_MIN | IS-M: Minimum Number of Placements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | NUM_OF_PUBL_MAX | IS-M: Maximum Number of Placements | nvarchar | 3 | 0 | | | | Allow NULL? |
| 44 | NUM_OF_SL_MIN | IS-M: Minimum Number of Schedule Lines | nvarchar | 6 | 0 | | | | Allow NULL? |
| 45 | NUM_OF_SL_MAX | IS-M: Maximum Number of Schedule Lines | nvarchar | 6 | 0 | | | | Allow NULL? |
| 46 | SERV_DATE_MIN | IS-M: Earliest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 47 | SERV_DATE_MAX | IS-M: Latest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 48 | SERV_DATE_TO_MIN | IS-M: Earliest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | SERV_DATE_TO_MAX | IS-M: Latest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 50 | NUM_OF_SL | IS-M: Number of Schedule Lines | nvarchar | 6 | 0 | | | | Allow NULL? |
| 51 | SERV_DATE | IS-M: Date Services were Created for Settlement Purposes | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | SERV_DATE_TO | IS-M: End Date for Service Creation in Terms of Settlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | AD_SIZE | Quantity | decimal | 13 | 3 | | | | |
| 54 | AD_SIZE_UOM | IS-M: Unit of Measurement for Calculating Ad Spec Dimensions | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | BASIC_BOOK_UNIT | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | | | Allow NULL? |
