CE_CONOH_RATE

(SQL Table)
Index Back

Conversion Overhead Rate

08/04/99 lee - added activity_id for abm overhead cost interface 09/27/99 lee - added gray logic for activity id for abm interface 9/28/99 lee - set activity id to blank and ungray rate, if rate type not per unit. For: ABM overhead cost interface. (ovhd_rate_code.saveprechange).

# 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_BUMGOP_NONVW

2 CE_COST_TYPE Character(4) VARCHAR2(4) NOT NULL Cost Type

Prompt Table: CE_TYPE

3 COST_VERSION Character(10) VARCHAR2(10) NOT NULL Cost Version

Prompt Table: CE_VERSION

4 OVHD_RATE_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Ovhd Rate Code

Prompt Table: CE_CONOH_CODE

5 OVERHEAD_RATE Number(11,4) DECIMAL(10,4) NOT NULL Conversion Overhead Rate
6 OVERHEAD_PERCENT Number(5,1) DECIMAL(4,1) NOT NULL Conversion Overhead %
7 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

Default Value: PU

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

Prompt Table: CE_ELEMENT2_VW

9 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: FS_ACTIVITY_TBL