| 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 | BOOKING_TYPE_OL | IS-M/AM: Booking Type for Online Advertising | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | POSITION_INSTR | IS-M: Online Positioning Instruction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | FORMAT_OL | IS-M/AM: Format Proposal (Online) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | TARGET_GROUP | IS-M: Target Group to Whom Advertising is Directed | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | TIMESLICE | Online Time Slice | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | DUR_OF_PUBL | Publication Duration in Days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | PLAN_GR_IMPR | IS-M/AM: Target Gross Impressions for Online Advertising | decimal | 14 | 0 | | | | |
| 19 | PLAN_GR_IMPR_UOM | IS-M/AM: Unit of Measure for Online Advertising | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | DUR_OF_PUBL_MIN | Minimum Publication Duration in Days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | DUR_OF_PUBL_MAX | Maximum Publication Duration in Days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | PLAN_GR_IMPR_MIN | IS-M: Min.Target Gross Impressions for Online Advertising | decimal | 14 | 0 | | | | |
| 23 | PLAN_GR_IMPR_MAX | IS-M: Max.Target Gross Impressions for Online Advertising | decimal | 14 | 0 | | | | |
| 24 | SERV_DATE_MIN | IS-M: Earliest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | SERV_DATE_MAX | IS-M: Latest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | SERV_DATE_TO_MIN | IS-M: Earliest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | SERV_DATE_TO_MAX | IS-M: Latest Service Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | SERV_DATE | IS-M: Date Services were Created for Settlement Purposes | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | SERV_DATE_TO | IS-M: End Date for Service Creation in Terms of Settlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | BASIC_BOOK_UNIT | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | | | Allow NULL? |