| 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 | COMP | Accrual Engine Application Component | nvarchar | 4 | 0 | CHAR | (N' ') | No | TACECOMP | ACE_COMP | Allow NULL? |
| 3 | INC_SEL_REFKEY | Include Name for Component-Specific RefKey Select Options | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_INCL_SEL_SCREEN_REFKEY | Allow NULL? |
| 4 | INC_SEL_RKEY_LDB | Include Name for Comp.-Spec. RefKey Select Options for LDB | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_INCL_SEL_SCREEN_REFKEY_LDB | Allow NULL? |
| 5 | INC_SEL_REFSUBKY | Include Name for Component-Specif. Ref_SubKey Select Options | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_INCL_SEL_SCREEN_REF_SUBKEY | Allow NULL? |
| 6 | INC_SEL_RSKY_LD | Include Name for Comp.-Spec. RefKey Select Options for LDB | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_INCL_SEL_SCRN_REFSUBKY_LDB | Allow NULL? |
| 7 | INC_SEL_SIMULATE | Include Name for Component Specific Simulation Parameters | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_INCL_SEL_SCREEN_SIMU_PARAM | Allow NULL? |
| 8 | INC_SEL_COMP | Include with Constant for Component | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_INCL_SEL_COMP | Allow NULL? |
| 9 | REP_PERIODIC_ACT | Report Name for Periodic Posting | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_PERIODIC_POST_REPORT | Allow NULL? |
| 10 | REP_PERIODIC_SIM | Report Name for Simulation of Periodic Accruals | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_PERIODIC_SIMULATION_REPORT | Allow NULL? |
| 11 | REP_PERIODIC_REV | Report Name for Reversing Periodic Accrual Runs | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_PERIODIC_REVERSAL_REPORT | Allow NULL? |
| 12 | REP_2ACC_TRANSFR | Report Name for Transferral of Postings to Accounting | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_POST_2_ACC_TRANSFER_REPORT | Allow NULL? |
| 13 | REP_ACEFI_RECONC | Report Name for ACE/FI Reconciliation | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_RECONCILE_ACE_FI_REPORT | Allow NULL? |
| 14 | REP_TREE_PRESEL | Report Name for Selection of Basic Data for Manual Maint. | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_TREE_PRESEL_REPORT | Allow NULL? |
| 15 | REP_CARRY_FORWRD | Report Name for Balance Carryforward in Accrual Engine | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_CARRY_FORWARD_REPORT | Allow NULL? |
| 16 | REP_ARCHIV_PREP | Report Name for Archiving Preparation Run | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_ARCHIVING_PREPARE_REPORT | Allow NULL? |
| 17 | REP_LINEITM_DISP | Name for Component-Specific Line Item Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_LINE_ITEM_REPORT_NAME | Allow NULL? |
| 18 | PRG_REFKEY_SUBSC | Program That Contains Subscreen with REF_KEY Fields | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_REFKEY_SUBSCREEN_REPID | Allow NULL? |
| 19 | REFKEY_SUBSC_NR | Subcreen Number for REF_KEY Fields | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACE_REFKEY_SUBSCREEN_NUMBER | Allow NULL? |
| 20 | PRG_RFSBKY_SUBSC | Program that Contains Subscreen with REF_SUBKEY Fields | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_REF_SUBKEY_SUBSCREEN_REPID | Allow NULL? |
| 21 | RFSBKY_SUBSC_NR | Subcreen Number for REF_KEY Fields | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACE_REF_SUBKEY_SUBSCREEN_NMBER | Allow NULL? |
| 22 | PRG_PARAMS_SUBSC | Program that Contains Subscreen for Parameters | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_PARAMS_SUBSCREEN_REPID | Allow NULL? |
| 23 | PARAMS_SUBSC_NR | Number of Subscreen for Parameters | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACE_PARAMS_SUBSCREEN_NUMBER | Allow NULL? |
| 24 | PRG_ASSGMT_SUBSC | Program That Contains a Subscreen with Account Assgmt Fields | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_ASSGMT_SUBSCREEN_REPID | Allow NULL? |
| 25 | ASSGMT_SUBSC_NR | Number of the Subscreen for Account Assignment Fields | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACE_ASSGMT_SUBSCREEN_NMBER | Allow NULL? |
| 26 | PRG_ACCNTS_SUBSC | Program with Subscreen for General Ledger Accounts | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ACE_ACCOUNT_SUBSCREEN_REPID | Allow NULL? |
| 27 | ACCNTS_SUBSC_NR | Number of Subscreen for Accounts | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACE_ACCOUNT_SUBSCREEN_NMBER | Allow NULL? |
