CA_RNW_LINK_VW

(SQL View)
 Index Back

CA-Renewals not yet Linked

PSIRS-KK This view displays all non-closed Contracts with non-closed, not-yet-renewed, original/non-original renewable lines

SELECT A.CONTRACT_NUM , A.CA_STATUS , B.CONTRACT_LINE_NUM , B.CA_LINE_STATUS , B.START_DT , B.END_DT , A.BUSINESS_UNIT , A.SOLD_TO_CUST_ID , B.PRODUCT_ID , B.RNW_LINKED , B.RNW_PKG_ID , B.RNW_CYCLE_NBR , B.SOURCE_RNW_PKG_ID , B.RENEWAL_ACTION , B.CURRENCY_CD , B.GROSS_AMT , B.NET_AMOUNT , B.LIST_PRICE , B.UNIT_OF_MEASURE , B.QTY FROM PS_CA_DETAIL B , PS_CA_CONTR_HDR A WHERE A.CA_PROC_STATUS IN ( 'A','P') AND B.CA_LINE_STATUS IN ( 'A','P','C') AND B.CHG_STATUS NOT IN ('X','P') AND B.RENEWABLE = 'Y' AND A.CONTRACT_NUM = B.CONTRACT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
4 CA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Obligation status
A=Active
C=Cancelled
P=Pending
R=Renewed
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
10 RNW_LINKED Character(1) VARCHAR2(1) NOT NULL PSIRS-KK
11 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
12 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK
13 SOURCE_RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
14 RENEWAL_ACTION Character(4) VARCHAR2(4) NOT NULL Renewal Action
AUTO=Automatic
MANL=Manual
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
17 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
18 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
19 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
20 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity