SCN_LN_ORD_VW

(SQL View)
 Index Back

Sales Contract Lines Order


SELECT C.SETID , B.CNTRCT_ID , B.CNTRCT_LINE_NBR , B.CNTRCT_SCHED_NBR , A.ORDER_NO , A.ORDER_DATE , B.ORDER_INT_LINE_NO , B.QTY_ORDERED , B.UNIT_OF_MEASURE , B.PRICE , %Round(%DecMult(B.QTY_ORDERED, B.PRICE) ,4) , B.PRICE_BASE , %Round(%DecMult(B.QTY_ORDERED, B.PRICE_BASE) ,4) FROM PS_ORD_LINE B , PS_ORD_HEADER A , PS_SET_CNTRL_REC C , PS_SCON_LINE D WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.ORDER_NO=B.ORDER_NO AND C.SETCNTRLVALUE=A.BUSINESS_UNIT AND C.RECNAME = 'SCON_LINE' AND C.SETID=D.SETID AND D.CNTRCT_ID=B.CNTRCT_ID AND D.LINE_NBR=B.CNTRCT_LINE_NBR AND B.ORD_LINE_STATUS <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
6 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
7 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
8 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
11 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
12 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
13 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)