RF_UNDR_SVC_VW2

(SQL View)
Index Back

Products Under Service

Agreement Line Installed Products view

SELECT A.SETID , B.AGREEMENT_CODE , B.AGR_RENEWAL_NUM , C.AGREEMENT_LINE , A.INST_PROD_ID , B.BO_ID_CUST , C.START_DT , B.AGRT_STATUS , C.END_DT , I.PRODUCT_ID , I.INV_ITEM_ID , I.BO_ID_CONTACT , I.ROLE_TYPE_ID_CNTCT , I.SERIAL_ID , I.SITE_ID , I.PERSON_ID FROM PS_RF_UNDER_SVC A , PS_RF_AGREEMENT B , PS_RF_AGREEMENT_LN C , PS_RF_INST_PROD I , PS_SET_CNTRL_REC S WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGREEMENT_CODE = C.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.AGR_RENEWAL_NUM = C.AGR_RENEWAL_NUM AND A.AGREEMENT_LINE = C.AGREEMENT_LINE AND A.INST_PROD_ID = I.INST_PROD_ID AND I.SETID = S.SETID AND S.SETCNTRLVALUE = A.SETID AND S.RECNAME = 'RF_INST_PROD'

# 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 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
4 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
5 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
7 START_DT Date(10) DATE Start date field to store start date value.
8 AGRT_STATUS Character(3) VARCHAR2(3) NOT NULL This field represents the agreement status value.
001=Pending
002=Pending Activation
003=Action Required
005=Active
009=Closed
9 END_DT Date(10) DATE This field stores the end date values.
10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL This field represents the business object ID for a Contact
13 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
14 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
15 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
16 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID