FIN_ACCOUNT_IDBO_ID_OWNERLANGUAGE_CDRBF_CUST_ACT_LV(SQL View) |
Index Back |
|---|---|
View to display customer acctView to display customer account list ........................ |
| SELECT DISTINCT b.FIN_ACCOUNT_ID ,b.BO_ID_OWNER ,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 |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |