| 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 | RUN_ID | Regulatory reporting run identification number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | FERC_R0 | FE_RUN_ID | Allow NULL? |
| 3 | STDCOSTADJ | Standard cost adjustment procedure activation indicator | char | 1 | 0 | NUMC | (N'0') | Yes | | FE_STD_ACT | Allow NULL? |
| 4 | VARIANCE | Flag: Variance allocation active? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_VAR_ACT | Allow NULL? |
| 5 | EXT_SETT | Flag: Process only objects with external settlements? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_EXTSETT | Allow NULL? |
| 6 | NEG_FLOW | Treatment of negative flow | char | 1 | 0 | NUMC | (N'0') | Yes | | FE_NEGFLOW | Allow NULL? |
| 7 | CC_ASS | Flag: Company code specific regulatory account assignments? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_CC_ASS | Allow NULL? |
| 8 | KTOKS | Regulatory account group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T077S | FE_KTOKS | Allow NULL? |
| 9 | KOSAR | Clearing cost center types | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FE_KOSAR | Allow NULL? |
| 10 | CPCE_BENE | Clearing cost element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKA | FE_CLR_CE | Allow NULL? |
| 11 | CPCE_DEFAU | Clearing cost element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKA | FE_CLR_CE | Allow NULL? |
| 12 | CPCE_PAYRT | Clearing cost element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKA | FE_CLR_CE | Allow NULL? |
| 13 | CLRG_NEG | Maximal negative percentage per clearing category | smallint | 5 | 0 | INT2 | ((0)) | Yes | | FE_CLRG_NEG | |
| 14 | ACC_ABS | Absolute accuracy in controlling area currency | decimal | 6 | 2 | CURR | ((0)) | Yes | | FE_ACC_ABS | |
| 15 | ACC_REL | Relative accuracy in % | decimal | 5 | 3 | DEC | ((0)) | Yes | | FE_ACC_REL | |
| 16 | DTYP_BS | Document type used for direct postings | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | FE_DTYP_BS | Allow NULL? |
| 17 | DTYP_PL | Document type used for traced costs postings | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | FE_DTYP_PL | Allow NULL? |
| 18 | DTYP_SC | Document type used for standard cost adjustments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | FE_DTYP_SC | Allow NULL? |
| 19 | CO_VERSION | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKA09 | VERSN | Allow NULL? |
| 20 | FI_VERSION | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T894 | RVERS | Allow NULL? |
| 21 | ACTUAL | Flag: Read actual data of the natural accounts? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_ACTUAL | Allow NULL? |
| 22 | SUMM_PRC | Percentage threshold for small amount summarization warning | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | FE_SUMM_PRC | |
| 23 | SUMM_AMT | Amount threshold for small amount summarization warning | decimal | 15 | 2 | CURR | ((0)) | Yes | | FE_SUMM_AMT | |
| 24 | SUMM_OTYPE | Flag: Summarize objects of different object type? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_SUMM_OTYPE | Allow NULL? |
| 25 | ADJ_FLOW | Flag: Adjust interclearing group flows? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_ADJ_FLOW | Allow NULL? |
| 26 | NRG_CLRG | Flag: Treat all clrg costs in non-reg. CCs as miscellaneous? | char | 1 | 0 | CHAR | (N' ') | Yes | | FE_NRGCLRG | Allow NULL? |
