CJM_XLA_CUSTOMER_ACCRUALS
This table contains information about the accounting events created as part of customer accrual creation or customer accrual adjustment for channel programs. Data in this table will serve as extract information for create accounting in General Ledger via Subledger Accounting Architecture.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_XLA_CUSTOMER_ACCRUALS_PK |
XLA_CUSTOMER_ACCRUAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| XLA_CUSTOMER_ACCRUAL_ID | NUMBER | 18 | Yes | Indicates internal identifier for XLA customer 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. The 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. | ||
| CUSTOMER_ACCRUAL_ID | NUMBER | 18 | Yes | Indicates the customer accrual identifier of the accrual record. | |
| BU_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated with 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_CUSTOMER_ACCRUALS_U1 | Unique | Default | XLA_CUSTOMER_ACCRUAL_ID |