BUSINESS_UNITINV_ITEM_IDEFFDTCOST_ELEMENTATC=Addl Trans
COH=Con Ovhd
CON=Conversion
INB=Inbound
LND=Landed
MAT=Material
OTH=Other
OUB=Outbound
CM_STDCOSTDI_VW(SQL View) |
Index Back |
|---|---|
Current Std Cost Details View03/2004 Created. Current Standard Cost Details view by item. For configure code level current standard cost see CM_STDCOSTD_VW |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.EFFDT , A.COST_ELEMENT , A.TL_COST , A.LL_COST , A.TRANSACTION_GROUP , C.COST_CATEGORY FROM PS_CM_PRODCOST A , PS_CM_STDCOSTCI_VW B , PS_CM_ELEMENT C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.EFFDT = B.EFFDT AND 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 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 5 | TL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | This Level Cost |
| 6 | LL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Lower Level Cost |
| 7 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 8 | 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 |