| 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 | * | 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 | * | 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 | DOCNR | Document Number of an Accrual Engine Document | nvarchar | 15 | 0 | CHAR | (N' ') | No | | ACEPS_DOCNR | Allow NULL? |
| 10 | VALCUM | Cumulative Value (Previously Accrued) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_AMOUNT_CUMULATED | |
| 11 | VALTBP | Amount Currently Posted | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_AMOUNT_TBP | |
| 12 | CURRENCY | Currency Calculated/Posted in the Accrual Amounts | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | ACEDS_VALCURRENCY | Allow NULL? |
| 13 | TRANSTYPE | Transaction in Accrual Engine | char | 1 | 0 | CHAR | (N' ') | Yes | | ACE_TRANSTYPE | Allow NULL? |
| 14 | EFFDATE | Key Date/Posting Date for Accruals | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ACE_EFFDATE | Allow NULL? |
| 15 | PODATE | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ACE_PODATE | Allow NULL? |
| 16 | POPER | Posting Period in Financial Accounting | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ACE_POPER | Allow NULL? |
| 17 | POYEAR | Fiscal Year in Financial Accounting | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACE_POYEAR | Allow NULL? |
| 18 | RUNID | Number (Run ID) of a Periodic Accrual Run in the Accl Engine | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ACEPS_RUNID | Allow NULL? |
| 19 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 20 | AWKEY | Reference Key for Accounting Document | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ACE_AWKEY | Allow NULL? |
| 21 | AWSYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AWSYS | Allow NULL? |
| 22 | TIMESTMP | Time Added (Greenwich Meantime) | decimal | 16 | 0 | DEC | ((0)) | Yes | | ACE_HZSTMP | |
| 23 | REVERSAL_DOC | Indicator: Document Is a Reversal Document | char | 1 | 0 | CHAR | (N' ') | Yes | | ACEPS_FLAG_REVERSAL_DOC | Allow NULL? |
| 24 | REVERSED_DOC | Number of the Reversed Accrual Engine Document | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ACEPS_DOCNR_REVERSED | Allow NULL? |
