CA_RNW_LN_VW

(SQL View)
 Index Back

Renewable line linked to Cycle


SELECT L.RNW_PKG_ID , L.RNW_CYCLE_NBR , L.CONTRACT_NUM , L.CONTRACT_LINE_NUM , D.START_DT , D.END_DT , D.GROSS_AMT , D.NET_AMOUNT , D.LIST_PRICE , L.PRODUCT_ID , L.UNIT_OF_MEASURE , L.QTY , L.GROSS_AMT , L.ACCTG_DIST_OPT , L.NET_AMOUNT , L.GROSS_AMT_REV , L.NET_AMOUNT_REV , L.BUNDLE_OFFERING FROM PS_CA_DETAIL D , PS_CA_RNW_LN_LINK L WHERE D.CONTRACT_NUM = L.CONTRACT_NUM AND D.CONTRACT_LINE_NUM = L.CONTRACT_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK
2 RNW_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK
3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
8 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.
9 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
13 TARGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Target Sales
14 ACCTG_DIST_OPT Character(1) VARCHAR2(1) NOT NULL Accounting Distribution Option
D=Default
L=Inherit From Line
15 TOTAL_NET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Net Amount
16 GROSS_AMT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
17 NET_AMOUNT_REV Signed Number(28,3) DECIMAL(26,3) NOT NULL Revenue Amount
18 BUNDLE_OFFERING Character(20) VARCHAR2(20) NOT NULL Offering ID