CM_PRODCOST_DE3

(SQL View)
 Index Back

Detaile Prod'n Costs by Item

09/12/02 dbe (CN#MG880-YBO) - New record/view. Note that EFFDT is lowest ordered key. If not, then Cost Inquiry will issue messages that component must be in Correction/History mode.

SELECT BUSINESS_UNIT , INV_ITEM_ID , CONFIG_CODE , COST_ELEMENT , TL_COST , LL_COST , TRANSACTION_GROUP , COMPONENT_ID , OP_SEQUENCE , EFFDT , COST_CATEGORY , TIME_TYPE , OH_RATE_TYPE FROM PS_CM_PRODCOST_DET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: BU_ITM_INV_VW

3 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
4 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

Prompt Table: CM_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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
9 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
10 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

11 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
12 TIME_TYPE Character(4) VARCHAR2(4) NOT NULL Time / Resource Type
0100=Planning Labor Setup
0200=Planning Labor Fixed Run
0300=Planning Labor Run
0400=Planning Labor Post Prod
0500=Planning Machine Setup
0600=Planning Machine Fixed Run
0700=Planning Machine Run
0800=Planning Machine Post Prod
1100=Costing Labor Setup
1200=Costing Labor Fixed Run
1300=Costing Labor Run
1400=Costing Labor Post Prod
1500=Costing Machine Setup
1600=Costing Machine Fixed Run
1700=Costing Machine Run
1800=Costing Machine Post Prod
2000=Queue Time
3000=Intransit Time
13 OH_RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Conversion Ovhd Rate Type
%L=% of Labor Amt
%M=% of Mach Amt
PL=Amt Per Labor Hr
PM=Amt Per Mach Hr
PU=Per Unit Amt