CE_CST_TMP

(SQL Table)
Index Back

Conv Cost Calculation

Stored previous op sequence costs and cumulative costs while calculating op sequence costs

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
5 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown
6 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
EN=Engineering
PR=Manufacturing
7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
8 OPSEQ_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Op Sequence Cost
9 PREV_OPSEQ_COST Signed Number(21,4) DECIMAL(19,4) NOT NULL Previous OpSeq Cost Applied
10 CUM_OPSEQ_COST Signed Number(21,4) DECIMAL(19,4) NOT NULL Cumulative Op Seq Cost
11 OPERATION_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Operation Yield