| 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 | OBJID | Accrual Object (Internal Display in Form of a GUID) | varbinary | 16 | 0 | RAW | | No | ACEOBJ | ACE_GUID | |
| 5 | SUBID | Accrual Subobject (Internal Display, Sequence Number) | nvarchar | 5 | 0 | NUMC | (N'00000') | No | ACEDSOH | ACE_SUBID | Allow NULL? |
| 6 | ACRTYPE | Accrual Type | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | ACE_ACRTYPE | Allow NULL? |
| 7 | ACCRULE | Accounting Principle | nvarchar | 4 | 0 | CHAR | (N' ') | No | TACC_PRINCIPLE | ACCOUNTING_PRINCIPLE | Allow NULL? |
| 8 | DATE_TO | To Date of Accrual Item | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ACE_DATETO | Allow NULL? |
| 9 | DATE_FROM | From Date of an Entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ACE_DATEFROM | Allow NULL? |
| 10 | INC_START_ACCNT | Start Account for Opening Posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ACEPS_ACCNT_INCEPTION_START | Allow NULL? |
| 11 | INC_TARGET_ACCNT | Target Account for Opening Posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ACEPS_ACCNT_INCEPTION_TARGET | Allow NULL? |
| 12 | PER_START_ACCNT | Start Account for Periodic Accrual Posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ACEPS_ACCNT_PERIODIC_START | Allow NULL? |
| 13 | PER_TARGET_ACCNT | Target Account for Periodic Accrual Posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ACEPS_ACCNT_PERIODIC_TARGET | Allow NULL? |
| 14 | FIN_START_ACCNT | Start Account for Closing Posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ACEPS_ACCNT_FINAL_START | Allow NULL? |
| 15 | FIN_TARGET_ACCNT | Target Account for Closing Posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ACEPS_ACCNT_FINAL_TARGET | Allow NULL? |
| 16 | INC_DOC_TYPE | Document Type for Opening Posting | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ACEPS_INC_BLART | Allow NULL? |
| 17 | PER_DOC_TYPE | Document Type for Periodic Accrual Posting | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ACEPS_PER_BLART | Allow NULL? |
| 18 | FIN_DOC_TYPE | Document Type for Closing Posting | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ACEPS_FIN_BLART | Allow NULL? |
