VRBT_NETVOU_VW (SQL View)	Index Back
Supplier Rebate Net QtyVoucher Supplier Rebate - PO Schedule amounts not vouchered

VRBT_NETVOU_VW

(SQL View)

Supplier Rebate Net QtyVoucher

Supplier Rebate - PO Schedule amounts not vouchered

SELECT DISTINCT M.BUSINESS_UNIT , M.PO_ID , M.LINE_NBR , M.SCHED_NBR , SUM(M.QTY_VCHR_CNVT) FROM PS_VRBT_RCVPOSH_VW P , PS_PO_LINE_MATCHED M WHERE P.RECV_REQ <> 'Y' AND P.MATCH_STATUS_LN_PO IN ('N', 'P') AND P.MATCH_LINE_OPT = 'F' AND M.BUSINESS_UNIT = P.BUSINESS_UNIT_PO AND M.PO_ID = P.PO_ID AND M.LINE_NBR = P.LINE_NBR AND M.SCHED_NBR = P.SCHED_NBR AND (M.BUSINESS_UNIT_RECV = ' ' OR M.RECEIVER_ID = ' ') AND M.RTV_TYPE = 'VCHR' GROUP BY M.BUSINESS_UNIT, M.PO_ID, M.LINE_NBR, M.SCHED_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 QTY_SHORT Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Short

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	QTY_SHORT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Short