CJM_CUSTOMER_ACCRUALS_GT
This table contains intermediate data about summarized prior customer program adjustment accrual amounts to be processed for customer programs. This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: cjm_customer_accruals_gt
Primary Key
| Name | Columns |
|---|---|
|
CJM_CUSTOMER_ACCRUALS_GT_PK |
CUSTOMER_ACCRUAL_ID |
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| CUSTOMER_ACCRUAL_ID | NUMBER | 18 | Yes | Unique identifier for the CJM_CUSTOMER_ACCRUALS_GT table. |
| ORIG_UTILIZATION_ID | NUMBER | 18 | Identifies the original utilization identifier. | |
| PRIOR_ADJ_AMOUNT | NUMBER | Stores the summed amount in transaction currency of previously created rate adjustment accrual records for the original utilization. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CJM_CUSTOMER_ACCRUALS_GT_N1 | Non Unique | ORIG_UTILIZATION_ID |
| CJM_CUSTOMER_ACCRUALS_GT_U1 | Unique | CUSTOMER_ACCRUAL_ID |