Payment Tender
Module: Customer Analytics
Type: Fact
PAY_TENDER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PAY_TENDER_ID | VARCHAR2 | 12 | True | Pay Tender | |||
| 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 | ||
| ADJ_ID | VARCHAR2 | 38 | Adjustment | DW_EWC_X_EWDI_CUST_CI_ADJ_D | ADJ_ID | ||
| ALT_CURRENCY_CD | VARCHAR2 | 38 | Alternate Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| ALT_TENDER_AMT | NUMBER | 15 | 2 | Alternate Amount | |||
| CHECK_NBR | VARCHAR2 | 38 | Check Number | ||||
| CURRENCY_CD | VARCHAR2 | 38 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| CUST_ID | VARCHAR2 | 38 | Customer ID | ||||
| ENCR_MICR_ID | VARCHAR2 | 64 | Encrypted Micr ID | ||||
| EXT_REFERENCE_ID | VARCHAR2 | 38 | External Reference ID | ||||
| HASH_MICR_ID | VARCHAR2 | 88 | Hash MICR ID | ||||
| IN_TNDR_CTL_BAL_SW | VARCHAR2 | 38 | Included in Tender Ctl Balance | ||||
| MICR_ID | VARCHAR2 | 30 | MICR ID | ||||
| NAME1 | VARCHAR2 | 40 | Name | ||||
| PAYOR_ACCT_ID | VARCHAR2 | 10 | Payor Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| PAY_EVENT_ID | VARCHAR2 | 12 | Payment Event | DW_EWC_X_EWDI_CUST_CI_PAY_EVENT_D | PAY_EVENT_ID | ||
| TENDER_AMT | NUMBER | 15 | 2 | Tender Amount | |||
| TENDER_TYPE_CD | VARCHAR2 | 4 | Tender Type | DW_EWC_X_EWDI_CUST_CI_TENDER_TYPE_D | TENDER_TYPE_CD | ||
| TNDR_CTL_ID | VARCHAR2 | 38 | Tender Control | DW_EWC_X_EWDI_CUST_CI_TNDR_CTL_D | TNDR_CTL_ID | ||
| TNDR_STATUS_FLG | VARCHAR2 | 38 | Tender Status | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |