PROCESS_INSTANCECRDT=Credit Card Parameters
CURR=Currency
FEE=Account Fee
PROD=Product
RELN=Account Relationships
STAT=Status
TIN=TIN Type and Number
UPG_RBF_FIN_AET(SQL Table) |
Index Back |
|---|---|
UPG_RBF_FIN_AETstate record for UPG_FINACTID AE program. used to select FIN_ACCOUNT_ID and CUST_ACCT_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SEQ_NUMBER | Number(20,0) | DECIMAL(20) NOT NULL | Sequence number to assign when expanding all the fields in a page including subpages |
| 3 | RBTEXTERNAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose. |
| 4 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 5 | CUST_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | This is the Customer defined Account Number for a financial account |
| 6 | TRANSACTION_NO | Character(15) | VARCHAR2(15) NOT NULL | Transaction table's primary key. |
| 7 | MODIFY_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Modify account Type
CRDT=Credit Card Parameters CURR=Currency FEE=Account Fee PROD=Product RELN=Account Relationships STAT=Status TIN=TIN Type and Number |
| 8 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |