FIN_ACCOUNT_IDLANGUAGE_CDRBI_POLICY_LNG(SQL View) |
Index Back |
|---|---|
View to display customer acctRelated language View to display customer acct |
| SELECT DISTINCT(b.FIN_ACCOUNT_ID) ,D.LANGUAGE_CD ,C.DESCR FROM PS_RBF_SRTY_MATRIX a , PS_RBF_FIN_ACCOUNT b , PS_PROD_ITEM C ,PS_PROD_ITEM_LNG D WHERE a.ACCOUNT_REF_ID = b.BO_ID AND b.PROD_SETID = C.SETID AND b.PRODUCT_ID = C.PRODUCT_ID AND a.APPROVAL_FLG = 'Y' AND b.FIN_ACCOUNT_TYPE = 'POL' AND D.SETID = b.PROD_SETID AND D.PRODUCT_ID = b.PRODUCT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |