ACCOUNT_NUMBERCONFIRMATION_NOA=Annually
D=Daily
M=Monthly
U=User-Defined
W=Weekly
RBF_BPAY_DETAIL(SQL Table) |
Index Back |
|---|---|
Bill Pay History DetailsThis record hold all the bill payment hstory details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT_NUMBER |
Character(20) | VARCHAR2(20) NOT NULL | Account number ---------> FSI Account |
| 2 | CONFIRMATION_NO |
Character(15) | VARCHAR2(15) NOT NULL | This is the field used for internet banking to display confirmation number |
| 3 | PAYMENT_DUE_DATE | Date(10) | DATE | payment due date |
| 4 | PAYEE_NAME | Character(40) | VARCHAR2(40) NOT NULL | Payee Name for Bill Payment |
| 5 | FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Frequency
A=Annually D=Daily M=Monthly U=User-Defined W=Weekly |
| 6 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |