Payment Header
Module: Customer Analytics
Type: Fact
PAY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PAY_ID | VARCHAR2 | 12 | True | Payment | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| A1_PAY_CAN_RSN_CD | VARCHAR2 | 38 | Pay Cancel Reason | DW_EWC_X_EWDI_CUST_CI_PAY_CAN_RSN_D | CAN_RSN_CD | ||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| CURRENCY_CD | VARCHAR2 | 38 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| MATCH_TYPE_CD | VARCHAR2 | 38 | Match Type | DW_EWC_X_EWDI_CUST_CI_MATCH_TYPE_D | MATCH_TYPE_CD | ||
| MATCH_VAL | VARCHAR2 | 30 | Match Value | ||||
| NON_CIS_COMMENT | VARCHAR2 | 254 | Non CIS Comments | ||||
| NON_CIS_NAME | VARCHAR2 | 50 | Non CIS Name | ||||
| NON_CIS_REF_NBR | VARCHAR2 | 30 | Reference Number | ||||
| PAY_AMT | NUMBER | 15 | 2 | Payment Amount | |||
| PAY_EVENT_ID | VARCHAR2 | 12 | Payment Event | DW_EWC_X_EWDI_CUST_CI_PAY_EVENT_D | PAY_EVENT_ID | ||
| PAY_STATUS_FLG | VARCHAR2 | 38 | Payment Status | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |