CM_STDCSTD2_VW(SQL View) |
Index Back |
---|---|
Standard cost13/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 |