FIN_ACCOUNT_IDPAYMENT_IDCO=Sent to Collection Agency
DU=Due - Unpaid
PA=Paid
PD=Past Due
AFT=Automatic Funds Transfer
CASH=Cash
CC=Credit Card
CHK=Check
Prompt Table: CURRENCY_CD_TBL
RBI_PAYHIST_DTL(SQL Table) |
Index Back |
|---|---|
Payment History for InsurancePayment History for Insurance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | PAYMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 3 | PAYMENTSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
payment status
CO=Sent to Collection Agency DU=Due - Unpaid PA=Paid PD=Past Due |
| 4 | PAYMENTMETHOD | Character(4) | VARCHAR2(4) NOT NULL |
Payment Method for Payment History
AFT=Automatic Funds Transfer CASH=Cash CC=Credit Card CHK=Check |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 7 | PAYMENTDATE | Date(10) | DATE | Payment Date used on RBI_PAYHIST_DTL |