DCM_PO_LN_SCHED

(SQL View)
 Index Back

View of PO Schedules

PO Schedules view

SELECT A.BUSINESS_UNIT %Concat '.' %Concat A.PO_ID , A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , B.SCHED_NBR , B.DUE_DT , A.INV_ITEM_ID , A.ITM_ID_VNDR , A.UNIT_OF_MEASURE , A.DESCR254_MIXED , A.AMT_ONLY_FLG , B.PRICE_PO , B.SHIPTO_ID , B.QTY_PO , B.QTY_PO , E.QTY_RECEIVED , B.MERCHANDISE_AMT , B.MERCHANDISE_AMT , B.CURRENCY_CD FROM PS_PO_LINE A , PS_PO_LINE_SHIP B , PS_PO_HDR D , PS_DCM_PO_RECV_VW E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND B.BUSINESS_UNIT = E.BUSINESS_UNIT AND B.PO_ID = E.PO_ID AND B.LINE_NBR = E.LINE_NBR AND B.SCHED_NBR = E.SCHED_NBR AND NOT EXISTS ( SELECT 'X' FROM PS_PO_LINE_MATCHED C WHERE C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PO_ID = B.PO_ID AND C.LINE_NBR = B.LINE_NBR AND C.SCHED_NBR = B.SCHED_NBR) AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PO_ID = D.PO_ID AND D.CC_USE_FLAG IN ('N',' ') UNION SELECT AA.BUSINESS_UNIT %Concat '.' %Concat AA.PO_ID , AA.BUSINESS_UNIT , AA.PO_ID , AA.LINE_NBR , BB.SCHED_NBR , BB.DUE_DT , AA.INV_ITEM_ID , AA.ITM_ID_VNDR , AA.UNIT_OF_MEASURE , AA.DESCR254_MIXED , AA.AMT_ONLY_FLG , BB.PRICE_PO , BB.SHIPTO_ID , BB.QTY_PO , BB.QTY_PO - SUM(CC.QTY_VCHR) , EE.QTY_RECEIVED , BB.MERCHANDISE_AMT , BB.MERCHANDISE_AMT - SUM(CC.MERCH_AMT_VCHR) , BB.CURRENCY_CD FROM PS_PO_LINE AA , PS_PO_LINE_SHIP BB , PS_PO_LINE_MATCHED CC , PS_PO_HDR DD , PS_DCM_PO_RECV_VW EE WHERE AA.BUSINESS_UNIT = BB.BUSINESS_UNIT AND AA.PO_ID = BB.PO_ID AND AA.LINE_NBR = BB.LINE_NBR AND BB.BUSINESS_UNIT = CC.BUSINESS_UNIT AND BB.PO_ID = CC.PO_ID AND BB.LINE_NBR = CC.LINE_NBR AND BB.SCHED_NBR = CC.SCHED_NBR AND BB.BUSINESS_UNIT = EE.BUSINESS_UNIT AND BB.PO_ID = EE.PO_ID AND BB.LINE_NBR = EE.LINE_NBR AND BB.SCHED_NBR = EE.SCHED_NBR AND AA.BUSINESS_UNIT = DD.BUSINESS_UNIT AND AA.PO_ID = DD.PO_ID AND DD.CC_USE_FLAG IN ('N',' ') GROUP BY AA.BUSINESS_UNIT, AA.PO_ID, AA.LINE_NBR, BB.SCHED_NBR, BB.DUE_DT, AA.INV_ITEM_ID, AA.ITM_ID_VNDR, AA.UNIT_OF_MEASURE , AA.DESCR254_MIXED, AA.AMT_ONLY_FLG, EE.QTY_RECEIVED, BB.PRICE_PO, BB.SHIPTO_ID, BB.QTY_PO, BB.MERCHANDISE_AMT, BB.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DCM_PO_KEY Character(16) VARCHAR2(16) NOT NULL Purchase Order Key
2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
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 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes
12 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
13 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
14 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
15 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
16 QTY_RECEIVED Number(16,4) DECIMAL(15,4) NOT NULL Received Qty
17 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
18 MERCH_AMT_AVAIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount Available
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code