Payment Arrangement
Module: Customer Analytics
Type: Fact
SA_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SA_ID | VARCHAR2 | 10 | True | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | |
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| A1_DAYS_FROM_START | NUMBER | 15 | 0 | Days from Start | |||
| A1_FUTURE_PAY_AMT | NUMBER | 15 | 2 | Future Payment Amount | |||
| A1_INSTALLMENT_CNT | NUMBER | 15 | 0 | Total Number of Installments | |||
| A1_PAID_TO_DATE_AMT | NUMBER | 15 | 2 | Paid to Date Amount | |||
| A1_PA_END_DT | NUMBER | 38 | 0 | Payment Arrangement End Date | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET01 | NUMBER | 15 | 2 | Future Payment Amount Bucket 01 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET02 | NUMBER | 15 | 2 | Future Payment Amount Bucket 02 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET03 | NUMBER | 15 | 2 | Future Payment Amount Bucket 03 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET04 | NUMBER | 15 | 2 | Future Payment Amount Bucket 04 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET05 | NUMBER | 15 | 2 | Future Payment Amount Bucket 05 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET06 | NUMBER | 15 | 2 | Future Payment Amount Bucket 06 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET07 | NUMBER | 15 | 2 | Future Payment Amount Bucket 07 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET08 | NUMBER | 15 | 2 | Future Payment Amount Bucket 08 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET09 | NUMBER | 15 | 2 | Future Payment Amount Bucket 09 | |||
| A1_PA_FUTURE_PAY_AMT_BUCKET10 | NUMBER | 15 | 2 | Future Payment Amount Bucket 10 | |||
| A1_PA_START_DT | NUMBER | 38 | 0 | Payment Arrangement Start Date | |||
| A1_REC_CHARGE_AMT | NUMBER | 15 | 2 | Total Scheduled Payment Amount | |||
| A1_TOTAL_PA_AMT | NUMBER | 15 | 2 | Total Payment Arrangement Amount | |||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | ||||
| MAILING_PREM_ID | VARCHAR2 | 38 | Mailing Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| PA_CNT | NUMBER | 1 | 0 | Count | |||
| PA_STATUS_FLG | VARCHAR2 | 4 | PA Status | ||||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |