| 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 | * | MANDT | Allow NULL? |
| 2 | POST_YEAR | Assignment Year of Commission Case/Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CACSPSTYEAR | Allow NULL? |
| 3 | DOC_ID | Document Identification | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CACSDOCID | Allow NULL? |
| 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CACSPARTID | Allow NULL? |
| 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CACSINVPOS | Allow NULL? |
| 6 | CTRTBU_ID_GRP | Group Contract of Partnership | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID_GRP | Allow NULL? |
| 7 | FLG_GROUP_RESP | Responsible Party in Partnership | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGGROUPRESP | Allow NULL? |
| 8 | FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGREV | Allow NULL? |
| 9 | STATUS_POS | Status of Object/Subobject | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT2 | CACSSTATUSPOS | Allow NULL? |
| 10 | STATUS_WORK | Object Processing Status (Replica) | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSSTATUSWORKP | Allow NULL? |
| 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID | Allow NULL? |
| 12 | ROLE | Participant Role | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | CACSROLE | Allow NULL? |
| 13 | ROLE_COMMSHAR | Share of Direct Remuneration (in Percent) | decimal | 10 | 5 | DEC | ((0)) | Yes | | CACSCOMMSHARE | |
| 14 | ROLE_PRODSHAR | Share of Indirect Remuneration (in Percent) | decimal | 10 | 5 | DEC | ((0)) | Yes | | CACSPRODSHARE | |
| 15 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSUPDTSTMP | Allow NULL? |
