| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | ACE_BUKRS | Allow NULL? |
| 4 | GJAHR | Fiscal Year in Accrual Engine | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | ACEPS_GJAHR | Allow NULL? |
| 5 | OBJID | Accrual Object (Internal Display in Form of a GUID) | varbinary | 16 | 0 | RAW | | No | ACEPSOH | ACE_GUID | |
| 6 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | ACE_SUBID | Allow NULL? |
| 7 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | CHAR | (N' ') | No | TACE_ACRTYPE | ACE_ACRTYPE | Allow NULL? |
| 8 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | CHAR | (N' ') | No | TACC_PRINCIPLE | ACCOUNTING_PRINCIPLE | Allow NULL? |
| 9 | CUMVALCAP | Cumulative Asset Balance Sheet Value Posted in Previous Yrs | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_CUM_AMOUNT_CAPITALIZED | |
| 10 | CUMVALACCR | Cumulative Recognition Posted in Previous Years | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_CUM_AMOUNT_ACCRUED | |
| 11 | VALCAP | Posted Asset Balance Sheet Value (by Year) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_AMOUNT_CAPITALIZED | |
| 12 | VALACCR | Recognition Postings Made (Year-Based) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_AMOUNT_ACCRUED | |
| 13 | VALRETIRE | Posted Retirement Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_AMOUNT_RETIRED | |
| 14 | LASTEFFDATE | Last Periodic Posting | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ACE_LASTEFFDATE | Allow NULL? |
| 15 | CURRENCY | Currency Calculated/Posted in the Accrual Amounts | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | ACEDS_VALCURRENCY | Allow NULL? |
