SCN_HDR_ORD_VW

(SQL View)
 Index Back

Sales Contract All Order Lines


SELECT D.SETID , D.CNTRCT_ID , A.ORDER_NO , B.ORDER_INT_LINE_NO , B.PRODUCT_ID , B.CUSTOMER_ITEM_NBR , B.UPN_ID , B.UPC_ID , B.CNTRCT_LINE_NBR , B.CNTRCT_SCHED_NBR , A.ORDER_DATE , B.QTY_ORDERED , B.PRICE , %Round(%DecMult(B.QTY_ORDERED, B.PRICE) ,4) , B.PRICE_BASE , %Round(%DecMult(B.QTY_ORDERED, B.PRICE_BASE) ,4) , B.UNIT_OF_MEASURE FROM PS_ORD_LINE B , PS_ORD_HEADER A , PS_SET_CNTRL_REC C , PS_SCON_HDR 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_HDR' AND C.SETID=D.SETID AND D.CNTRCT_ID=B.CNTRCT_ID AND B.ORD_LINE_STATUS <> 'X' AND B.CNTRCT_LINE_NBR > 0

# 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 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
4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
7 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
8 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
9 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
10 CNTRCT_SCHED_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Schedule
11 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
12 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
13 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
14 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
15 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
16 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)
17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage