WM_WO_TTMPL_MAT

(SQL Table)
Index Back

WO Task Tmplt Materials Reqts

WO Task Template -- Materials Requirements

  • Parent record: WM_WO_TTMPL_EFF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number

    Default Value: 1

    5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: WM_WO_TTMITM_VW

    6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD

    Prompt Table: UNITS_TBL

    7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

    Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD

    8 QTY_REQUIRED Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required
    9 QTY_REQUIRED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required base
    10 WO_DELIVERY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used by Work Order parts list processing to signify special delivery instructions if needed

    Y/N Table Edit

    Default Value: N

    11 WO_DELIVERY_INST Character(254) VARCHAR2(254) NOT NULL Delivery instructions for work order parts list
    12 SUPPLIER_REFERENCE Character(20) VARCHAR2(20) NOT NULL Supplier Reference