SETIDPRODUCT_IDRBT_PURPOSE_IDLANGUAGE_CDRPC_PRDBILL_LVW(SQL View) |
Index Back |
|---|---|
Telco base object for CIRecord used for fetching related language description of the Billing purpose for each product |
| SELECT A.SETID , A.PRODUCT_ID , A.RBT_PURPOSE_ID , A.LANGUAGE_CD , A.RBT_PURPOSE_DESCR , D.XLATLONGNAME FROM PS_RBT_PROD_DTL B , PS_RBT_PROD_DTLLNG A , PSXLATITEMLANG D WHERE A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID AND A.RBT_PURPOSE_ID = B.RBT_PURPOSE_ID AND B.RBT_ACCOUNT_TYPE = D.FIELDVALUE AND A.LANGUAGE_CD = D.LANGUAGE_CD AND D.FIELDNAME = 'RBT_ACCOUNT_TYPE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | RBT_PURPOSE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for storing Billing Account Purpose ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | RBT_PURPOSE_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Field used for storing Billing Account Purpose |
| 6 | ACCT_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Account type description |