Adjustment
Module: Customer Analytics
Type: Fact
ADJ_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ADJ_ID | VARCHAR2 | 12 | True | Adjustment | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| A1_ADJ_CAN_RSN_CD | VARCHAR2 | 38 | Adjustment Cancel Reason | DW_EWC_X_EWDI_CUST_CI_ADJ_CAN_RSN_D | CAN_RSN_CD | ||
| ADJ_STATUS_FLG | VARCHAR2 | 2 | Adjustment Status | ||||
| ADJ_TYPE_CD | VARCHAR2 | 8 | Adjustment Type | DW_EWC_X_EWDI_CUST_CI_ADJ_TYPE_D | ADJ_TYPE_CD | ||
| APPR_REQ_ID | VARCHAR2 | 38 | Approval Request | DW_EWC_X_EWDI_CUST_CI_APPR_REQ_D | APPR_REQ_ID | ||
| BASE_AMT | NUMBER | 15 | 2 | Base Amount | |||
| BEHALF_SA_ID | VARCHAR2 | 38 | On Behalf SA | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CURRENCY_CD | VARCHAR2 | 38 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| CUR_AMT | NUMBER | 15 | 2 | Current Amount | |||
| GEN_REF_DT | NUMBER | 38 | 0 | Calculation Date | |||
| SA_ID | VARCHAR2 | 10 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| XFER_ADJ_ID | VARCHAR2 | 38 | Transfer Adjustment | DW_EWC_X_EWDI_CUST_CI_ADJ_D | ADJ_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |