CM_PROFILES

(SQL Table)
 Index Back

Cost Profiles

02/23/99 RML CM800-9.0 This record is maintained and delivered from PS; contains all the valid combinations of cost type, flow, and methods 08/23/02 dmw CM8.8 Actual Cost of Manufacturing - added new fields CM_STD_COST_METHOD, CM_MATERIAL_METHOD, CM_LABOR_METHOD, CM_MACHINE_METHOD.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CM_TYPE Character(2) VARCHAR2(2) NOT NULL 07/99 GMG CN800-9.0:
0=Non Cost
1=Actual
2=Std Cost
2 CM_FLOW Character(2) VARCHAR2(2) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
2=Lot ID
3=Serial ID
4=FIFO
5=LIFO
3 CM_METHOD Character(2) VARCHAR2(2) NOT NULL 8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average
4 CM_STD_COST_METHOD Character(2) VARCHAR2(2) NOT NULL Standard Cost Acctg Method
0=Actual Cost
1=Frozen Standard
2=Planned Standard
3=Production Standard
5 CM_MATERIAL_METHOD Character(2) VARCHAR2(2) NOT NULL Material Cost Method
0=Not Applicable
1=Production ID Level
2=Serialized Assembly Level
6 CM_LABOR_METHOD Character(2) VARCHAR2(2) NOT NULL Labor Cost Method
0=Not Applicable
11=Standard Time-Conversion Rate
12=Standard Time-Crew Rate
21=Actual Time-Conversion Rate
22=Actual Time-Crew Rate
7 CM_MACHINE_METHOD Character(2) VARCHAR2(2) NOT NULL Machine Cost Method
0=Not Applicable
11=Standard Time-Conversion Rate
21=Actual Time-Conversion Rate
8 CM_MFG_ITEM_FLG Number(3,0) SMALLINT NOT NULL 02/23/99 Created for Release 8 - CM800-9.0 by RML

Default Value: 0

9 CM_PERPAVG_FLAG Number(1,0) SMALLINT NOT NULL Maintain Perpetual Average Flg
10 CM_PERRAVG_FLAG Number(1,0) SMALLINT NOT NULL RetroActive Per Avg Costed Flg
11 CM_STDCOST_FLAG Number(1,0) SMALLINT NOT NULL 07/99 GMG CN800-9.0:
12 CM_NONCOST_FLAG Number(1,0) SMALLINT NOT NULL 07/99 GMG CN800-9.0: