| 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 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | JHAK | AVM_NR | Allow NULL? |
| 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAP | POS_NR | Allow NULL? |
| 4 | GRUPPABRNR | IS-M/AM: Billing Dataset | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAGA | GRUPPABRNR | Allow NULL? |
| 5 | VNR | IS-M: Media Sales Agent Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | JJTVV | JVMVVNR | Allow NULL? |
| 6 | BEDNR | IS-M: Number of Media Sales Agent Contract Requirement | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JJTVB | VM_BEDNR | Allow NULL? |
| 7 | PROVTYP | IS-M/AM: Commission Category | char | 1 | 0 | CHAR | (N' ') | No | JHAGVZ | PROVTYP | Allow NULL? |
| 8 | VZUONR | IS-M/AM: Sales Agent Assignment Number (Corrections) | nvarchar | 2 | 0 | NUMC | (N'00') | No | JHAGVZ | JH_VZUONR | Allow NULL? |
| 9 | FKBEL | IS-M/AM: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | JHTFK | JJBELNR | Allow NULL? |
| 10 | FKPOS | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JHTFP | JJPOSNR | Allow NULL? |
| 11 | SETTLESTAT | IS-M/AM: Settlement Status | char | 1 | 0 | CHAR | (N' ') | Yes | | JHSETLSTAT | Allow NULL? |
| 12 | FKDAT | IS-M: Planned Billing/Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JHFKTER | Allow NULL? |
| 13 | FAKSP | IS-M: Billing Block | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PAM_FAKSP | Allow NULL? |
| 14 | REF_VBELN | IS-M/AM: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHTFK | JJBELNR | Allow NULL? |
| 15 | REF_POSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTFP | JJPOSNR | Allow NULL? |
