| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | WERBEART | Sales Source | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | WERBEAKT | Sales Promotion | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | GUELTIGBIS | End of Validity of Campaign Framework | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | MINDBEZUG | Minimum Length of Subscription | decimal | 2 | 0 | | | | |
| 10 | MINDBEZEIN | Time Unit for Minimum Length of Subscription | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | LIEFUNTMAX | Maximum Delivery Suspension | decimal | 2 | 0 | | | | |
| 12 | LIEFUMXEIN | Time unit for maximum delivery suspension | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | HAFTDAUER | Liability Period for Commission Clawback in Months | decimal | 2 | 0 | | | | |
| 14 | HAFTDEINH | Time Unit for Liability Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | VPFLZEITRV | Commitment period for sales agent (subscriber) | decimal | 2 | 0 | | | | |
| 16 | VPFLZEINHV | Time unit for commitment period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | XWERBTRAEG | Indicator: Advertising medium required for order | char | 1 | 0 | | | | Allow NULL? |
| 18 | WERBAUFW | Advertising costs (amount) per subscription obtained | decimal | 13 | 2 | | | | |
| 19 | WERBWAERS | Currency of Advertising Expenses per Subscription | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | XFREIABO | Indicator: Free subscription allowed | char | 1 | 0 | | | | Allow NULL? |
| 21 | ERFUSER | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | ERFDATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | ERFTIME | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | AENUSER | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
