Accrual
Overview
The Accruals subject area provides the framework for managing revenue and cost accruals in the system. It covers deferred revenue, prepayments, and other accrual-related data, which are tracked based on service periods, contracts, or usage. By supporting revenue recognition processes, this subject area helps align financial treatment with accounting requirements. It also records accrual lifecycle events to ensure consistent handling of revenue and expense recognition across billing environments.
Conforming Layers
The Payment subject area has the following conforming layers:
ACCRUAL_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| ACCR_ID | Identifier for the accrual record. | VARCHAR | 19 |
| SA_ID | Identifier for the service agreement associated with the accrual. | VARCHAR | 10 |
| ACCT_ID | Identifier for the account associated with the accrual. | VARCHAR | 10 |
| CIS_DIVISION | Division or business unit categorizing the accrual. | VARCHAR | 5 |
| ACCR_CYC_CD | Accrual cycle code defining the frequency of accrual processing. | VARCHAR | 4 |
| ACCR_TYPE_CD | Code describing the accrual type. | VARCHAR | 30 |
| ACCR_DT | Date when the accrual entry was recorded. | TIMESTAMP | |
| REV_START_DT | Start date of the revenue period. | TIMESTAMP | |
| REV_END_DT | End date of the revenue period. | TIMESTAMP | |
| SOURCE_FLG | Flag describing the source type. | VARCHAR | 4 |
| FREEZE_SW | Indicator whether the accrual is frozen. | VARCHAR | 1 |
| BUS_OBJ_CD | Business object code defining the object type for the accrual and links it to modules. | VARCHAR | 30 |
| BO_STATUS_CD | Status code of the business object. | VARCHAR | 12 |
| BO_STATUS_REASON_CD | Code of the reason for the business object status. | VARCHAR | 30 |
| BO_DATA_AREA | Data area of the business object defining logical data ownership. | VARCHAR | |
| VERSION | Version numnber of the accrual record. | DECIMAL(5,0) | (5,0) |
| TRIAL_BILL_ID | Identifier for the trial bill associated with the accrual. | VARCHAR | 12 |
| ACCR_CRE_DTTM | Date when the accrual was created. | TIMESTAMP | |
| ILM_ARCH_SW | Indicator whether the accrual is marked for archiving. | VARCHAR | 1 |
| ILM_DT | Date when the accrual is scheduled to be archived. | TIMESTAMP | |
| POST_METH | Posting method for the accrual. | VARCHAR | 4 |
| TOT_AMT | Total accrual amount. | DECIMAL(15,2) | (15,2) |
| STATUS_UPD_DTTM | Date when the accrual was last updated. | TIMESTAMP | |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | 7 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in ACCR_ID format. This is the primary key. |
VARCHAR | 19 |
| CDF1_CD CDF2_CD CDF3_CD CDF4_CD CDF5_CD CDF6_CD CDF7_CD CDF8_CD CDF9_CD CDF10_CD CDF11_CD CDF12_CD CDF13_CD CDF14_CD CDF15_CD |
Placeholders for future implementation of ORMB characteristics. | VARCHAR | 254 |
| CDF1_VAL CDF2_VAL CDF3_VAL CDF4_VAL CDF5_VAL CDF6_VAL CDF7_VAL CDF8_VAL CDF9_VAL CDF10_VAL CDF11_VAL CDF12_VAL CDF13_VAL CDF14_VAL CDF15_VAL |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 254 |
ACCRUAL_DTLS_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| ACCR_ID | Links the accrual detail record to its parent accrual, ensures proper header-detail relationship, maintains referential integrity, supports drill-down reporting, provides audit traceability, and guarantees consistency across financial transactions. | VARCHAR | 19 |
| SEQNO | Specifies the sequence number of an accrual. | DECIMAL(5,0) | 5 |
| PRICEITEM_CD | Captures the price item code for the accrual detail, links detail to pricing configuration, ensures proper revenue categorization, supports billing and validation processes, provides consistency in financial postings, and enables detailed reporting. | VARCHAR | 10 |
| AMOUNT | stores the total amount of the accrual. The amount might include various components like revenue, expenses, or adjustments that are recognized over a period. | DECIMAL(15,2) | 15,2 |
| CURRENCY_CD | ISO code for the currency in which this accrual is recorded. | VARCHAR | 3 |
| OVRD_REASON | Specifies the override reason code. | VARCHAR | 8 |
| ENTITY_ID | Identifier used to distinguish external business entities, which establishes relationships between records and supports audit tracking. | VARCHAR | 19 |
| DST_ID | Specifies the distribution identifier used to distinguish the relevant distribution rules. | VARCHAR | 19 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CDC_FLAG | Type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| COMPOSITE_KEY | Unique identifier in ACCR_ID | SEQNO format. This is the primary key. |
VARCHAR | 24 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP |