SF_CFGVAR2_VW

(SQL View)
 Index Back

Config Variance View


SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.INV_ITEM_ID , A.COMPONENT_ID , A.OP_SEQUENCE , A.COST_ELEMENT , A.VARIANCE_SOURCE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.VARIANCE_TYPE , %Substring(B.MESSAGE_TEXT, 1,40) , A.CURR_SCHED_QTY , A.SCHED_QTY , A.ISSUE_QTY , A.COMPLETED_QTY , A.SCRAP_QTY , A.NEW_PRDN_QTY , A.QTY_CODE , A.CM_UNIT_COST_STD_O , A.CM_UNIT_COST_STD_C , A.VARIANCE_AMOUNT , A.VARIANCE_AMOUNT3 FROM PS_SF_CFGVAR_DET A , PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR

  • Related Language Record: SF_CFGVAR2_VWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
    5 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
    6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    7 VARIANCE_SOURCE Character(2) VARCHAR2(2) NOT NULL Variance Source
    C=Close
    O=Re-Open
    R=Report
    8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    10 VARIANCE_TYPE Character(2) VARCHAR2(2) NOT NULL 9/9/02 CRC: added variance type '15' for Yield Variance
    01=Configuration Variance
    02=Usage Variance
    03=Component Yield Variance
    04=Labor Lot Size Variance
    05=Process Routing Variance
    06=Efficiency Variance
    07=Rate Variance
    08=Material Lot Size Variance
    09=Rework Expense
    10=Rework Labor Expense
    11=Outside Processing PPV
    12=Mix Variance
    13=Teardown Material Expense
    14=Teardown Conversion Expense
    15=Yield Variance
    16=Co-Product Rate Var
    17=Material Rate Variance
    11 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
    12 CURR_SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
    13 SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL Component Scheduled Qty
    14 ISSUE_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
    15 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
    16 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
    17 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
    18 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
    ASY=Assembly
    ORD=Order
    19 CM_UNIT_COST_STD_O Number(15,4) DECIMAL(14,4) NOT NULL Standard Cost per Unit OLD
    20 CM_UNIT_COST_STD_C Number(15,4) DECIMAL(14,4) NOT NULL Current Standard Cost
    21 VARIANCE_AMOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL Variance Amount
    22 VARIANCE_AMOUNT3 Signed Number(18,6) DECIMAL(16,6) NOT NULL Variance Amount with decimal precision of 6 used by Variance Drilldown.