| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccrual Engine |
| 1 | ACEDSOI | Item Data for Accrual Subobject | 6 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 2 | ACEDSOI_ACCOUNTS | Accounts for Accrual Postings per Accrual Item | 6 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 3 | ACEPSOI | Accrual Item: Values in Posting Component | 7 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 4 | ACEPSOIT | Line Items for Accrual Item in Accrual Engine | 7 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 5 | TACE_ACRTYPE | Accrual Types | 3 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 6 | TACE_ACRTYPET | Text for Accrual Types | 4 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 7 | TACE_ACRTYPE_OPN | Calculation Rules for Derived Accrual Types | 4 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 8 | TACE_DS_CALC | Distribution Server: Accrual Type Settings | 4 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 9 | TACE_PS_POST | Posting Server: Posting Control | 5 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| TOPActual Update and Commitment Update |
| 10 | GMA_ACE_BILLING | Accrual Engine: Grant Master Data Transfer by Billing Rule | 5 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 11 | GMA_ACE_GMFI | Accrual Engine: Assignment for Grant Master Data Transfer | 4 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 12 | GMA_ACE_GRANT | Accrual Engine: Assignment for Grant Master Data Transfer | 5 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| TOPCRM Accruals |
| 13 | CRM_ACE_CU_ACRTY | CRM Accruals: Assignment of Accruals Type to Transact. Type | 5 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 14 | CRM_ACE_CU_COND | Customizing for CRM Accruals: Relevant Revenue Elements | 3 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 15 | CRM_ACE_CU_COPA | CRM Accruals: Assgmt of Accruals Type to Cond.Type for CO-PA | 3 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 16 | CRM_ACE_OI_DATA | CRM Accruals: Item Detail Data of Object | 4 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 17 | IPM_ACE_CU_BVAL | Customizing Settings for Data Values for Rights Usage Conf. | 3 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 18 | IPM_ACE_CU_VALTY | Customizing Data Values Relevant to Accrual Types | 3 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| TOPLease Accounting |
| 19 | TFILA_GF_004 | Assignment Value ID -> Accrual Method | 7 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| 20 | TFILA_GF_004BT | Assignment of Value ID -> Accrual Method for Determ. Balance | 6 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
| TOPProvisions for Awards |
| 21 | ACE_SOP_HRFI | Accrual Engine: Assignment for HR Data Transfer | 5 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | | |
