CA_OPR_CONTR_VW

(SQL View)
 Index Back

My Contracts View

My Contracts View

SELECT A.OPRID , A.CONTRACT_NUM , B.BUSINESS_UNIT , B.SOLD_TO_CUST_ID , B.CA_STATUS , B.CURRENCY_CD , B.CA_PROC_STATUS , B.CONTRACT_TYPE , B.CA_RQST_SRC , B.REGION_CD , B.CONTR_LEGAL_ENTITY , B.CONTRACT_SIGN_DT , B.CONTRACT_ADMIN , B.REVISED_GROSS , B.REVISED_REDUCT FROM PS_CA_OPRID_CONTR A , PS_CA_CONTR_HDR B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
5 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 CA_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
A=Active
C=Closed
P=Pending
8 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
9 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
10 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
11 CONTR_LEGAL_ENTITY Character(15) VARCHAR2(15) NOT NULL Contract Legal Entity
12 CONTRACT_SIGN_DT Date(10) DATE Contract Signed
13 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.
14 REVISED_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Negotiated Amount
15 REVISED_REDUCT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discounts/Surcharges