INV_TURN_RET_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CM_METHOD , SUM(%DecMult(B.QTY_BASE, -1)) FROM PS_CM_ITEM_LED_VW A , PS_TRANSACTION_INV B WHERE A.DEFAULT_LEDGER_GRP = 'Y' AND A.PRIMARY_LEDGER = 'Y' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.TRANSACTION_GROUP = '024' GROUP BY A.BUSINESS_UNIT, A.INV_ITEM_ID, A.CM_METHOD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 CM_METHOD Character(2) VARCHAR2(2) NOT NULL 8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average

4 DEMAND_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Demand Qty

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	CM_METHOD	Character(2)	VARCHAR2(2) NOT NULL	8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements 0=Non Cost 1=Actual Cost 6=Perpetual Weighted Average 7=Periodic Weighted Average 8=Value at Current Standard 9=Retroactive Perpetual Average
4	DEMAND_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Demand Qty