RF_AGTEMPSRC_VW

(SQL View)
 Index Back

Agreement Template View

View to return all Agreement Templates from Agreement table

SELECT SETID , AGR_TEMPLATE_ID , AGREEMENT_CODE , AGR_RENEWAL_NUM , AGREEMENT_CATEGORY , RO_CAPTURE_FLAG FROM PS_RF_AGREEMENT WHERE AGR_TEMPLATE_FLG = 'Y'

# 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 AGR_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL This field stores the Agreement template id.
3 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
4 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)

Default Value: 1

5 AGREEMENT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Field for defining the Category for the Agreement, to be used in the Agreement Header Record.
1=External
2=Internal
3=External - No Pricing
6 RO_CAPTURE_FLAG Character(1) VARCHAR2(1) NOT NULL This field indicates if an agreement is created through Order Capture. It also indicates if an Agreement Template may be sold through Order Capture.
N=No
Y=Yes