UNITS_CVT_TBL

(SQL Table)
 Index Back

Units of Measure Conversion Rt

Units of Measure conversion rates table

  • Parent record: UNITS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    CS=Case
    EA=Each
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    2 UNIT_OF_MEASURE_TO Character(3) VARCHAR2(3) NOT NULL Unit of Measure To

    Prompt Table: UNITS_TBL

    3 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate