| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccrual Engine |
| 1 | ACEDSOI | Item Data for Accrual Subobject | 7 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 2 | ACEDSOI_ACCOUNTS | Accounts for Accrual Postings per Accrual Item | 7 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 3 | ACEPSOI | Accrual Item: Values in Posting Component | 8 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 4 | ACEPSOIT | Line Items for Accrual Item in Accrual Engine | 8 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 5 | TACE_ACRTYPE_OPN | Calculation Rules for Derived Accrual Types | 3 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 6 | TACE_COMBINATION | Possible Combinations in the Accrual Engine | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 7 | TACE_DS_CALC | Distribution Server: Accrual Type Settings | 3 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 8 | TACE_PS_POST | Posting Server: Posting Control | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 9 | TACE_VSR_001 | Assignment of Validations | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| TOPActual Update and Commitment Update |
| 10 | GMA_ACE_BILLING | Accrual Engine: Grant Master Data Transfer by Billing Rule | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 11 | GMA_ACE_GMFI | Accrual Engine: Assignment for Grant Master Data Transfer | 3 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 12 | GMA_ACE_GRANT | Accrual Engine: Assignment for Grant Master Data Transfer | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| TOPCRM Accruals |
| 13 | CRM_ACE_CU_COND | Customizing for CRM Accruals: Relevant Revenue Elements | 4 | ACCRULE | Accounting Principle (AP) | nvarchar | 4 | 0 | | |
| 14 | CRM_ACE_OI_DATA | CRM Accruals: Item Detail Data of Object | 5 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 15 | IPM_ACE_CU_BVAL | Customizing Settings for Data Values for Rights Usage Conf. | 4 | ACCRULE | Accounting Principle (AP) | nvarchar | 4 | 0 | | |
| 16 | IPM_ACE_CU_VALTY | Customizing Data Values Relevant to Accrual Types | 4 | ACCRULE | Accounting Principle (AP) | nvarchar | 4 | 0 | | |
| TOPLease Accounting |
| 17 | FIEH_STATUS | Object Status for Restart Exception Handling | 6 | ACCRULE | Accounting Principle (AP) | nvarchar | 4 | 0 | | |
| 18 | FIOTPOI | One-Time Postings: Items | 8 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 19 | LAE_CRM_CLASS | Contract Classification | 6 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 20 | TFILAFM_IRCM | Assignment of Acct Prin. to Interest Rate Calc. Methods | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 21 | TFILA_ACCRULE | Accounting Principles for Classification in CRM | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 22 | TFILA_ACCRULET | Accounting Principles for CRM Classification -Texts | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 23 | TFILA_FA_001 | Process+Accounting Principle -> Transaction Type | 5 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 24 | TFILA_FA_002 | Assignment Accounting Principle -> Depreciation Area | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 25 | TFILA_FA_003 | Control of Useful Life Adjustment for Upgrades | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 26 | TFILA_GF_003M | For Later Use of Value IDs for Retrieval | 5 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 27 | TFILA_GF_003R | Value IDs Referenced from Method | 7 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 28 | TFILA_GF_004 | Assignment Value ID -> Accrual Method | 5 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 29 | TFILA_GF_004CF | Assignment of Payment Schedule for Accrual Postings | 5 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 30 | TFILA_GF_005 | Specifications for One-Time Postings per Value ID | 5 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 31 | TFILA_GF_006 | Assignment Company Code -> Accounting Principles | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 32 | TFILA_GF_007C | Value IDs to Be Included in Payment Schedule | 6 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 33 | TFILA_GF_009 | Assignment of Value IDs to Structure Field | 6 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 34 | TFILA_GF_009V | Mapping Table for Structure Fields in Value IDs | 6 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 35 | TFILA_GF_020S | Assign Value IDs for Determining Residual Value | 3 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 36 | TFILA_GF_020T | Fill New Residual Values in Conditions | 3 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 37 | TFILA_LC_002TO | Specification Asset Values Copied for Following Business | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 38 | TFILA_RE_VAL | Assign Refinancing Category and Value Identifier | 6 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| 39 | TFIOTP_003 | Posting Key for Document Grouping Characteristic | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
| TOPProvisions for Awards |
| 40 | ACE_SOP_HRFI | Accrual Engine: Assignment for HR Data Transfer | 4 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | | |
