FIN_ACCOUNT_IDCREDIT_ACCT_TYPEALN=Auto Loan
CCD=Credit Card
HEL=Home Equity Loan
MLN=Mortage Loan
PUL=Personal Unsecured Loan
SBL=Small Business Loan
Prompt Table: CURRENCY_CD_TBL
Prompt Table: RBW_ASSET_CATEG
RBF_CREDIT_ACCT(SQL Table) |
Index Back |
|---|---|
Credit AccountThis record is used to store Credit Account information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | CREDIT_ACCT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
credit Account type
ALN=Auto Loan CCD=Credit Card HEL=Home Equity Loan MLN=Mortage Loan PUL=Personal Unsecured Loan SBL=Small Business Loan |
| 3 | TOTAL_LIMIT | Number(29,4) | DECIMAL(28,4) NOT NULL | Total credit limit |
| 4 | NEW_BALANCE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | New Balance |
| 5 | LAST_STMT_BALANCE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | last statement Balance----fsi |
| 6 | LAST_PAYMENT_AMT | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Last Payment Amount |
| 7 | LAST_PAYMENT_DATE | Date(10) | DATE | last payment date |
| 8 | MIN_PAYMENT_DUE | Number(29,4) | DECIMAL(28,4) NOT NULL | min payment due |
| 9 | PAYMENT_DUE_DATE | Date(10) | DATE | payment due date |
| 10 | AMOUNT_PAST_DUE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | amt past due |
| 11 | NO_DAYS_PAST_DUE | Number(4,0) | SMALLINT NOT NULL | no of days past due |
| 12 | CASH_ADVANCE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Cash Advance |
| 13 | CASH_ADVANCE_LIMIT | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Cash Advance Limit |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 15 | ASSET_CATEG_ID | Character(15) | VARCHAR2(15) NOT NULL |
This field is the primary key for Asset category table
Prompt Table: RBW_ASSET_CATEG |
| 16 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 17 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 18 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 19 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 20 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 21 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |