CJM_XLA_ACCRUALS
This table contains information about the accounting events created as part of accrual creation or accrual adjuestment for channel programs. Data in this table will serve as extract information for create accounting in General Ledger via Subledger Accounting Architechure.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_XLA_ACCRUALS_PK |
XLA_ACCRUAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| XLA_ACCRUAL_ID | NUMBER | 18 | Yes | Indicates internal identifier for XLA Accruals. | |
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||
| ENTITY_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an entity and used for reporting or in reference to an option. Value will be always ACCRUAL | ||
| EVENT_ID | NUMBER | 18 | Identifier of the categorization of accounting events that is unique within an application and event class. | ||
| UTILIZATION_ID | NUMBER | 18 | Yes | Indicates the utilization identifier of the accrual record. | |
| BU_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_XLA_ACCRUALS_N1 | Non Unique | Default | EVENT_TYPE_CODE, UTILIZATION_ID |
| CJM_XLA_ACCRUALS_U1 | Unique | Default | XLA_ACCRUAL_ID |