RBF_ACNT_VLD_VW(SQL View) |
Index Back |
|---|---|
Arrangement Contract VWArrangement Contract View to identify all the contracts for an arrangement |
| SELECT A.SETID , A.ACNT_ID , A.DESCR50 , A.START_DATE , A.END_DATE , A.BUS_CONTACT_TYPE , A.BUS_CONTACT_ID , A.PRODUCT_ID_RELATED , A.ARRANGEMENT_FLAG , CASE WHEN C.PRODUCT_ID_RELATED IS NULL THEN A.PRODUCT_ID_RELATED WHEN C.PRODUCT_ID_RELATED IS NOT NULL THEN C.PRODUCT_ID_RELATED END AS PRODUCT_ID_ORIG , A.ATTRIBUTE_CATEGORY FROM PS_RBF_ACNT_AFLG_V A , PS_RBF_PROD_ARGMT C WHERE A.PRODUCT_ID_RELATED = C.PRODUCT_ID(+) |
| # | 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.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ACNT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Contract ID
Default Value: NEXT |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | START_DATE | Date(10) | DATE NOT NULL |
Start Date
Default Value: %Date |
| 5 | END_DATE | Date(10) | DATE |
End date field to store an end date.
Default Value: %Date |
| 6 | BUS_CONTACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Business Contact Type for Arrangement for FSI
ALT=Alternate Capacity COM=Company PTN=Partnership Default Value: COM |
| 7 | BUS_CONTACT_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Business Contact Id
Prompt Table: %EDIT_BUS_CON |
| 8 | PRODUCT_ID_RELATED | Character(18) | VARCHAR2(18) NOT NULL |
Field used to store related product ID
Prompt Table: RBF_PRD_DF_SRCH |
| 9 | ARRANGEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field is to indicate whether an arrnagement is avilable on the product.
N=No Y=Yes Y/N Table Edit |
| 10 | PRODUCT_ID_ORIG | Character(18) | VARCHAR2(18) NOT NULL |
Product ID Original
Prompt Table: RBF_PRD_DF_SRCH |
| 11 | ATTRIBUTE_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
This field defines the acategory of attributes in product.
Prompt Table: RBF_ACNT |