| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ENAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | UNAME | Allow NULL? |
| 3 | VAR | Variant Name | nvarchar | 14 | 0 | CHAR | (N' ') | No | | RALDB_VARI | Allow NULL? |
| 4 | NR | | nvarchar | 10 | 0 | | (N'0000000000') | Yes | | | Allow NULL? |
| 5 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | MANDT | Allow NULL? |
| 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CACSIMPYEAR | Allow NULL? |
| 7 | CASE_ID | ID of Commission Case | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CACSCASEID | Allow NULL? |
| 8 | CASE_VERS | Commission Case Version | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | CACSCASEVERS | Allow NULL? |
| 9 | LIN_POS | Item of Different Commissions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSLINEPOS | Allow NULL? |
| 10 | FLG_CANCEL_OBJ | Indicator: Object is Invalid | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCANCOBJ | Allow NULL? |
| 11 | FLG_CANCEL_VERS | Indicator: Version is Invalid | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCANCVERS | Allow NULL? |
| 12 | STATUS_VERSION | Object Version Status | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT1 | CACSSTATUSVERS | Allow NULL? |
| 13 | STATUS_WORK | Object Processing Status (Replica) | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT1 | CACSSTATUSWORKP | Allow NULL? |
| 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | CACSTRIOBJ | Allow NULL? |
| 15 | TRI_OBJ_ID_EXT | External Identification of Triggering Subobject | nvarchar | 36 | 0 | CHAR | (N' ') | Yes | | CACSTRIOBJIDEXT | Allow NULL? |
| 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACSTRIOBJID | Allow NULL? |
| 17 | ADDON_TYPE | Enhancement/Change to a Subobject | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSITEMADD | Allow NULL? |
| 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID | Allow NULL? |
| 19 | ROLE | Participant Role | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TCACS_ROLE | CACSROLE | Allow NULL? |
| 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACSREM | Allow NULL? |
| 21 | REM_CONAMNT | Special Remuneration Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSREMULINAMNT | |
| 22 | DREM_CONAMNT | Difference Amount for Special Remuneration | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSREMUDLINAMNT | |
| 23 | REM_CURR | Currency Key Special Commission | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CACSLINCURR | Allow NULL? |
| 24 | REM_QUAN | Remuneration Entitlement as Quantity | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSREMUQUAN | |
| 25 | DREM_QUAN | Remuneration Difference Quantity | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSREMUDQUAN | |
| 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CACSREMUUNIT | Allow NULL? |
| 27 | REM_RATE | Remuneration Record (For Example, Percentage) | decimal | 8 | 3 | DEC | ((0)) | Yes | | CACSREMRATE | |
| 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSINVPOSLIN | Allow NULL? |
| 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSPARTIDLIN | Allow NULL? |
| 30 | CLAIM_OBJTYPE | Entitlement Object Type | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCLAIMOBJTYPE | Allow NULL? |
| 31 | CLAIM_OBJID | ID of Entitlement Object Acc. to Entitlement Object Type | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CACSCLAIMOBJID | Allow NULL? |
| 32 | FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGREV | Allow NULL? |
| 33 | CORRTO_DOC_ID | ID of Corrected Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CACSCORRTODOCID | Allow NULL? |
| 34 | CORRTO_PST_YEAR | Assignment Year Document That Corrected This Row | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CACSCORRTOPSTYEAR | Allow NULL? |
