CM_BUITMMAST_VW (SQL View)	Index Back
Business Unit and Item Master .

CM_BUITMMAST_VW

(SQL View)

Business Unit and Item Master

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , B.UNIT_MEASURE_STD , A.COST_ELEMENT , A.QTY_OWNED , D.BASE_CURRENCY FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_BUS_UNIT_TBL_IN D WHERE A.INV_ITEM_ID = B.INV_ITEM_ID AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = C.SETID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT

# 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 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

4 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

5 QTY_OWNED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Owned

6 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

#	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	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
4	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
5	QTY_OWNED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Owned
6	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "