| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | GRUPPABRNR | IS-M/AM: Billing Dataset | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | VNR | IS-M: Media Sales Agent Contract Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | BEDNR | IS-M: Number of Media Sales Agent Contract Requirement | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | PROVTYP | IS-M/AM: Commission Category | char | 1 | 0 | | | | Allow NULL? |
| 8 | VZUONR | IS-M/AM: Sales Agent Assignment Number (Corrections) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | VERM | IS-M: Sales Agent with ID Code for Screen | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | XAUTO | IS-M: Assigned automatically Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | XFOUND | Suitable Sales Agent Contract Requirement Found Indicator | char | 1 | 0 | | | | Allow NULL? |
| 12 | XMANU | IS-M: Sales Agent Assigned Manually Indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | XKOPF_ZUO | IS-M: "Sales Agent Copied from Order Header" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | XPOS_ZUO | IS-M: Sales Agent Copied from Order Item | char | 1 | 0 | | | | Allow NULL? |
| 15 | PR_BASIS | IS-M: Sales Agent Share of Calculation Base (in %) | decimal | 7 | 3 | | | | |
| 16 | PR_BETRAG | IS-M: Sales Agent Share of Commission (in %) | decimal | 7 | 3 | | | | |
| 17 | PRA_XMANU | IS-M: Sales Agent Share was Changed Manually Indicator | char | 1 | 0 | | | | Allow NULL? |
| 18 | PROSL | IS-M/AM: Commission Key for Media Sales Agent | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | PROV_SATZ | IS-M: Commission Rate (Percent) | decimal | 7 | 3 | | | | |
| 20 | PROVM_SATZ | IS-M: Commission Amount for mm Commission | decimal | 15 | 2 | | | | |
| 21 | PROVM_WAER | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | PROV_PEIN | IS-M: Price Unit (Surcharge Discount, Basic Price) | decimal | 5 | 0 | | | | |
| 23 | PROV_MEIN | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | BEZKOND | IS-M: Condition Reference | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | VZMANUAEND | IS-M: Sales Agent Assignment was Changed Indicator | char | 1 | 0 | | | | Allow NULL? |
| 26 | BEDGR | IS-M: Media Sales Agent Requirement Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | JVERMART | IS-M: Media Sales Agent Type: General/City/Special Agent | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | VANR | IS-M: Extra commission/exclusion | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | REF_VZUONR | IS-M/AM: Reference Number of the Preceding Agent Assignmt | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | SUC_VZUONR | IS-M: Reference No.of Successor Sales Agent Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | CORRCAUSE | IS-M/AM: Reason for Correction to Sales Agent Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | CANCELCC | IS-M: Reversal Correction Reason for Sales Agent Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | STATUSK | IS-M: Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | XPROV_EE | IS-M: Settlement Performed (Sales Agent Payment) Indicator | char | 1 | 0 | | | | Allow NULL? |
| 35 | XUVVZ | IS-M: Sales Agent Assignment is Incomplete | char | 1 | 0 | | | | Allow NULL? |
| 36 | XZUOINACT | IS-M: Indicator Sales Agent Assignment is Inactive | char | 1 | 0 | | | | Allow NULL? |
| 37 | XDELETED | IS-M: Sales Agent Assignment Deleted Manually Indicator | char | 1 | 0 | | | | Allow NULL? |
| 38 | MERKMAL0 | IS-M: Characteristic 0 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 39 | MERKMAL1 | IS-M: Characteristic 1 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 40 | MERKMAL2 | IS-M: Characteristic 2 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 41 | MERKMAL3 | IS-M: Characteristic 3 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 42 | MERKMAL4 | IS-M: Characteristic 4 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 43 | MERKMAL5 | IS-M: Characteristic 5 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 44 | MERKMAL6 | IS-M: Characteristic 6 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 45 | MERKMAL7 | IS-M: Characteristic 7 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 46 | MERKMAL8 | IS-M: Characteristic 8 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
| 47 | MERKMAL9 | CIS-M: Characteristic 9 for Ind.Use (Sales Agent Assignment) | char | 1 | 0 | | | | Allow NULL? |
