FIN_ACCOUNT_IDBO_ID_OWNERPrompt Table: BO
FIN_ACCOUNT_TYPECHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings
LANGUAGE_CDRBF_CUST_POL_LV(SQL View) |
Index Back |
|---|---|
View to display cust policiesView to display customer policies...... |
| SELECT DISTINCT b.FIN_ACCOUNT_ID , b.BO_ID_OWNER ,b.FIN_ACCOUNT_TYPE ,c.LANGUAGE_CD ,C.DESCR FROM PS_RBF_FIN_ACCOUNT b , PS_PROD_ITEM_LNG C WHERE b.PROD_SETID = C.SETID AND b.PRODUCT_ID = C.PRODUCT_ID AND b.FIN_ACCOUNT_TYPE = 'POL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | BO_ID_OWNER |
Number(31,0) | DECIMAL(31) NOT NULL |
Financial Account Business Object ID
Prompt Table: BO |
| 3 | FIN_ACCOUNT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Account type
CHK=Checking CRE=Credit INV=Investment LON=Loan POL=Insurance SAV=Savings |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |