| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 3 | FKART | IS-M/AM: Billing/Settlement Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJH05 | FKART_PAM | Allow NULL? |
| 4 | STD_PROSL | IS-M: Standard Commission Key | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJH23 | JSTDPROSL | Allow NULL? |
| 5 | BEZKP | Condition Reference For Sales Vol.Dependent Commission Det. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | BEZKONDP | Allow NULL? |
| 6 | BO1SL | IS-M/AM: Bonus 1: Commission Key for Media Sales Agent | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJH23 | JJBONSCHL1 | Allow NULL? |
| 7 | BEZKB1 | Condition Reference for Determining Sales Agent Bonus 1 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | BEZKONDB1 | Allow NULL? |
| 8 | BO2SL | IS-M: Bonus 2: Commission Key for Media Sales Agent | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJH23 | JJBONSCHL2 | Allow NULL? |
| 9 | BEZKB2 | Condition Reference for Determining Sales Agent Bonus 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | BEZKONDB2 | Allow NULL? |
| 10 | KNPRS | Pricing type | char | 1 | 0 | CHAR | (N' ') | Yes | | KNPRS | Allow NULL? |
| 11 | TATYP | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | TATYP | Allow NULL? |
| 12 | TACLGP | Tax Classification for Media Sales Agent Business Partner | char | 1 | 0 | CHAR | (N' ') | Yes | TJJ35 | JTACLGPMV | Allow NULL? |
| 13 | XPAYMREL | IS-M: Payment of Commission Basis Billing Document is Rel. | char | 1 | 0 | CHAR | (N' ') | No | | JH_XPAYMREL | Allow NULL? |
| 14 | BBUNPAID | IS-M: Settlement Block if Preceding Order Billing Doc.Unpaid | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVFS | JH_BBUNPAID | Allow NULL? |
| 15 | FKDAT_BASIS | IS-M/AM: Base Date for Planned Settlement Date (Sales Agent) | char | 1 | 0 | CHAR | (N' ') | No | | JHAGVX_FKDAT_BASIS | Allow NULL? |
