CM_STDCSTD2_VW

(SQL View)
Index Back

Standard cost

13/03/2013 vid : This view has the total costs, for a cost element. This view is used for items using standard cost method.

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE , A.EFFDT , A.COST_ELEMENT , (A.TL_COST + A.LL_COST) , C.COST_CATEGORY FROM PS_CM_PRODCOST A , PS_CM_ELEMENT C , PS_SET_CNTRL_REC D WHERE D.RECNAME = 'CM_ELEMENT' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.SETID = D.SETID AND C.COST_ELEMENT = A.COST_ELEMENT

# 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 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
4 EFFDT Date(10) DATE Effective Date
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
7 COST_CATEGORY Character(3) VARCHAR2(3) NOT NULL 1/12/99 ebn CN#CM800-2.0 : Added Landed Cost translate value
ATC=Addl Trans
COH=Con Ovhd
CON=Conversion
INB=Inbound
LND=Landed
MAT=Material
OTH=Other
OUB=Outbound