| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VNR | IS-M: Media Sales Agent Contract Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | BEDNR | IS-M: Number of Media Sales Agent Contract Requirement | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | GUELTIGBIS | IS-M: "Valid To" Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BEDART | IS-M/AM: Requirement Type in Media Sales Agent Contract | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | BEDGR | IS-M: Media Sales Agent Requirement Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | XSTDBED | IS-M: Standard Requirement | char | 1 | 0 | | | | Allow NULL? |
| 9 | PROSL | IS-M/AM: Commission Key for Media Sales Agent | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | XPROV | IS-M: Qualifies for Commission Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | XBONUS | IS-M: Indicator: Qualifies for Bonus 1 | char | 1 | 0 | | | | Allow NULL? |
| 12 | XBONUS2 | IS-M: Indicates: Qualifies for Bonus 2 | char | 1 | 0 | | | | Allow NULL? |
| 13 | XSTEIG | IS-M: Can be Incremented Indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | XBERICHT | IS-M/AM: Report Required, Reference to Partner (Role) | char | 1 | 0 | | | | Allow NULL? |
| 15 | XVORAUS | IS-M: Payment Granted in Advance | char | 1 | 0 | | | | Allow NULL? |
| 16 | JVERMART | IS-M: Media Sales Agent Type: General/City/Special Agent | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | | | | Allow NULL? |
| 18 | XLOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | | | | Allow NULL? |
| 19 | VOR_VNR | IS-M: Sales Agnt Contract: Contract No.of Preliminary Req. | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | VOR_BEDNR | Sales Agent Contract: Number of the Preliminary Requirement | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | XNOGVZ | IS-M: Do Not Create Sales Agent Assignment Indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | KURZTEXT | IS-M: Short Text | nvarchar | 15 | 0 | | | | Allow NULL? |
| 23 | LANGTEXT | IS-M: Long Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 24 | ERFUSER | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | ERFDATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ERFTIME | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | AENUSER | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | LAST_BESNR | IS-M: Element Number in Media Agent Contract | nvarchar | 6 | 0 | | | | Allow NULL? |
