CM_ITEM_METH_VW

(SQL View)
 Index Back

Item Cost Profiles

01/18/99 RML CN800-9.0: Created new view to show profile for a given item, BU, and book.

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CM_BOOK , E.CM_BOOK_STATUS , A.CM_PROFILE_ID , B.CM_TYPE , B.CM_FLOW , B.CM_METHOD , B.CM_MATERIAL_METHOD , B.CM_LABOR_METHOD , B.CM_MACHINE_METHOD , B.CM_WIP_RCPT_OPT , B.CM_COST_ELEMNT_OPT , B.CM_STOR_AREA_CNTRL , B.CM_STOR_BIN_CNTRL , B.CM_WAIT_FINAL_COST , B.CM_COST_NEG , D.CM_MFG_ITEM_FLG , D.CM_PERPAVG_FLAG , D.CM_PERRAVG_FLAG , D.CM_STDCOST_FLAG , D.CM_NONCOST_FLAG , B.CM_WRITEOFF_VAR FROM PS_CM_ITEM_METHOD A , PS_CM_PROFILE_DEFN B , PS_SET_CNTRL_REC C , PS_CM_PROFILES D , PS_CM_BU_BOOK_TBL E WHERE C.RECNAME = 'CM_PROFILE_DEFN' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = C.SETID AND B.CM_PROFILE_ID = A.CM_PROFILE_ID AND B.CM_TYPE = D.CM_TYPE AND B.CM_FLOW = D.CM_FLOW AND B.CM_METHOD = D.CM_METHOD AND B.CM_MATERIAL_METHOD = D.CM_MATERIAL_METHOD AND B.CM_LABOR_METHOD = D.CM_LABOR_METHOD AND B.CM_MACHINE_METHOD = D.CM_MACHINE_METHOD AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.CM_BOOK = E.CM_BOOK

# 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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
4 CM_BOOK_STATUS Character(1) VARCHAR2(1) NOT NULL 06/30/99 RML Changed Long Name
A=Active
C=Cancel
I=Inactive
P=Pending
S=Stopped
5 CM_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
6 CM_TYPE Character(2) VARCHAR2(2) NOT NULL 07/99 GMG CN800-9.0:
0=Non Cost
1=Actual
2=Std Cost
7 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
8 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
9 CM_MATERIAL_METHOD Character(2) VARCHAR2(2) NOT NULL Material Cost Method
0=Not Applicable
1=Production ID Level
2=Serialized Assembly Level
10 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
11 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
12 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
13 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
14 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.
15 CM_STOR_BIN_CNTRL Character(1) VARCHAR2(1) NOT NULL Storage Bin Control for Costs
16 CM_WAIT_FINAL_COST Character(1) VARCHAR2(1) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
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
18 CM_MFG_ITEM_FLG Number(3,0) SMALLINT NOT NULL 02/23/99 Created for Release 8 - CM800-9.0 by RML
19 CM_PERPAVG_FLAG Number(1,0) SMALLINT NOT NULL Maintain Perpetual Average Flg
20 CM_PERRAVG_FLAG Number(1,0) SMALLINT NOT NULL RetroActive Per Avg Costed Flg
21 CM_STDCOST_FLAG Number(1,0) SMALLINT NOT NULL 07/99 GMG CN800-9.0:
22 CM_NONCOST_FLAG Number(1,0) SMALLINT NOT NULL 07/99 GMG CN800-9.0:
23 CM_WRITEOFF_VAR Character(1) VARCHAR2(1) NOT NULL Writeoff PPV and ERV