| 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 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | CHAR | (N' ') | No | DFKKZK | KEYZ1_KK | Allow NULL? |
| 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | NUMC | (N'000000') | No | DFKKZP | POSZA_KK | Allow NULL? |
| 4 | SELT1 | 1. Selection Category | char | 1 | 0 | CHAR | (N' ') | Yes | TFK004 | SELT1_KK | Allow NULL? |
| 5 | SELW1 | First Field Value to be Selected | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SELW1_KK | Allow NULL? |
| 6 | SELT2 | 2. Selection Category | char | 1 | 0 | CHAR | (N' ') | Yes | TFK004 | SELT2_KK | Allow NULL? |
| 7 | SELW2 | Second Field Value to be Selected | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SELW2_KK | Allow NULL? |
| 8 | SELT3 | 3. Selection Category | char | 1 | 0 | CHAR | (N' ') | Yes | TFK004 | SELT3_KK | Allow NULL? |
| 9 | SELW3 | Third Field Value to be Selected | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SELW3_KK | Allow NULL? |
| 10 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 11 | BETRZ | Payment amount in transaction currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRZ_KK | |
| 12 | BVRKO | Bank clearing account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | BVRKO_KK | Allow NULL? |
| 13 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 14 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 15 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 16 | TXTVW | Note to Payee in Payment | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TXTVW_KK | Allow NULL? |
| 17 | STATE | CFC: Status of an application table entry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CFC_ITEM_STATE | CFC_STATE | Allow NULL? |
| 18 | LOCK_USER | Name of the person to last change the status of the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CFC_UNAME | Allow NULL? |
| 19 | LOCK_LIMIT | CFC: Lock period of a lock entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFC_LOCK_LIMIT | Allow NULL? |
| 20 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CFC_IT_WORKSTATE | CFC_WORKSTATE | Allow NULL? |
| 21 | RESUBMIT_DATE | Date on which Resubmission Occurs | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFC_RESUBMIT_DATE | Allow NULL? |
| 22 | WF_COUNT | Number of active workflows with this clarification case | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CFC_WORKFLOW_COUNTER | |
