| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
CM_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table:
CM_PROFILE_DEFN
|
| 3 |
CM_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
07/99 GMG CN800-9.0:
0=Non Cost
1=Actual
2=Std Cost
|
| 4 |
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
|
| 5 |
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
|
| 6 |
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
Default Value: 1
|
| 7 |
CM_MATERIAL_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Material Cost Method
0=Not Applicable
1=Production ID Level
2=Serialized Assembly Level
|
| 8 |
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
|
| 9 |
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
|
| 10 |
CM_STOR_AREA_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
CN# CM800-9.0 GMG
Storage Area Control for Costing. If this flag is on (Y) depletions will only deplete receipts in the storage area from which the depletion was made. If it is off (N), depletions will not consider the storage area when selecting qualifying receipts to deplete.
Y/N Table Edit
Default Value: N
|
| 11 |
CM_STOR_BIN_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Storage Bin Control for Costs
Y/N Table Edit
Default Value: N
|
| 12 |
CM_WAIT_FINAL_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Y/N Table Edit
Default Value: N
|
| 13 |
CM_SCRAP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Cost of Scrap
Y/N Table Edit
Default Value: N
|
| 14 |
CM_MAKE_PROFILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile for Makeable Items
Y/N Table Edit
Default Value: N
|
| 15 |
CM_WIP_RCPT_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Partial Putaway Cost Option
1=Perpetual Weighted Avg Cost
2=Periodic Weighted Avg Cost
3=Frozen Standard
4=Retroactive Perpetual Average
5=Last Actual Cost
|
| 16 |
CM_COST_ELEMNT_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
08/16/02 8.8 Actual Cost Mfg.
Cost Element Option for Average Costed items.
1=Default Cost Element
2=Maintain Avg by Cost Element
|
| 17 |
CM_COST_NEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Insufficient Qty Cost Option
0=Don't cost if insufficient qty
1=Cost to point of zero quantity
2=Cost in Regular Mode Only
3=Always cost insufficient qty
Default Value: 0
|
| 18 |
CM_WRITEOFF_VAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Writeoff PPV and ERV
Y/N Table Edit
Default Value: N
|