INVITM_UOM_OVW

(SQL View)
 Index Back

Inv Unit of Measure Conversion

View used in Alt Supply sources

SELECT a.SETID ,a.INV_ITEM_ID ,a.UNIT_OF_MEASURE ,b.DESCR ,a.CONVERSION_RATE ,a.QTY_PRECISION ,a.ROUND_RULE ,a.DFLT_UOM_STOCK ,a.packing_weight ,a.packing_volume ,a.shipping_weight ,a.shipping_volume ,a.unit_measure_wt ,a.unit_measure_vol ,a.packing_cd ,a.packaging_cd ,a.container_type FROM PS_INV_ITEM_UOM a , PS_UNITS_TBL b WHERE a.unit_of_measure = b.unit_of_measure

  • Related Language Record: INVITM_UOM_LVW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: MST_ITM_PRPT_VW

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

    Prompt Table: UNITS_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
    6 QTY_PRECISION Character(1) VARCHAR2(1) NOT NULL Quantity Precision
    D=Decimal
    W=Whole Nbr

    Default Value: D

    7 ROUND_RULE Character(1) VARCHAR2(1) NOT NULL Rounding Rule
    D=Round Down
    N=Natural Round
    U=Round Up

    Default Value: N

    8 DFLT_UOM_STOCK Character(1) VARCHAR2(1) NOT NULL Default Stocking UOM

    Y/N Table Edit

    Default Value: N

    9 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
    10 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
    11 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
    12 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
    13 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

    Prompt Table: UNITS_WT_VW

    14 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

    Prompt Table: UNITS_VOL_VW

    15 PACKING_CD Character(4) VARCHAR2(4) NOT NULL Packing Code

    Prompt Table: PACK_CODE_INV

    16 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

    Prompt Table: PACKAGNG_CD_INV

    17 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type

    Prompt Table: CNTR_TYPE_INV