ORD_INVITEMS_VW

(SQL View)
 Index Back

Inventory Item Master - OM


SELECT S.SETID , S.INV_ITEM_ID , S.EFFDT , S.UPC_ID , S.POTENCY_RATING , S.INV_ITEM_TEMPLATE , S.INV_ITEM_TYPE , S.RECYCLE_FLAG , S.REUSABLE_FLAG , S.DISPOSABLE_FLAG , S.INV_STOCK_TYPE , S.PACKING_CD , S.STOR_RULES_ID , S.SHIP_TYPE_ID , S.RECOM_STOR_TEMP , S.RECOM_HUMIDITY_PCT , S.INV_PROD_GRADE , S.MAX_CAPACITY , S.HAZ_CLASS_CD , S.INTL_HAZARD_ID , S.CHARGE_CODE , S.SHELF_LIFE , S.AVAIL_STATUS , S.INV_ITEM_HEIGHT , S.INV_ITEM_LENGTH , S.INV_ITEM_WIDTH , S.INV_ITEM_WEIGHT , S.INV_ITEM_VOLUME , S.INV_ITEM_SIZE , S.INV_ITEM_COLOR , M.INV_ITEM_GROUP , S.UNIT_MEASURE_DIM , S.UNIT_MEASURE_WT , S.UNIT_MEASURE_TEMP , S.UNIT_MEASURE_VOL , S.COMMODITY_CD , S.HARMONIZED_CD , S.MSDS_ID , M.INVENTORY_ITEM , S.LAST_MAINT_OPRID , S.LAST_DTTM_UPDATE , S.DESCR254 , S.COMMODITY_CD_EU , S.AVAIL_LEAD_TIME , S.RETEST_LEAD_TIME , S.CHARGE_MARKUP_PCNT , S.CHARGE_MARKUP_AMT FROM PS_INV_ITEMS S , PS_MASTER_ITEM_TBL M WHERE S.SETID = M.SETID AND S.INV_ITEM_ID = M.INV_ITEM_ID

  • Related Language Record: ORD_INVITMVWLNG

    • # 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
    5 POTENCY_RATING Character(4) VARCHAR2(4) NOT NULL Potency Code

    Prompt Table: POTENCY_CD_INV

    6 INV_ITEM_TEMPLATE Character(5) VARCHAR2(5) NOT NULL Template ID

    Prompt Table: INV_ITEM_TEMPL

    7 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type

    Prompt Table: TYPE_ITEM_INV

    8 RECYCLE_FLAG Character(1) VARCHAR2(1) NOT NULL Item Recycle Flag

    Y/N Table Edit

    Default Value: N

    9 REUSABLE_FLAG Character(1) VARCHAR2(1) NOT NULL Reusable Item Flag

    Y/N Table Edit

    Default Value: N

    10 DISPOSABLE_FLAG Character(1) VARCHAR2(1) NOT NULL Special Disposable Flag

    Y/N Table Edit

    Default Value: N

    11 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type

    Prompt Table: STOCK_TYPE_INV

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

    Prompt Table: PACK_CODE_INV

    13 STOR_RULES_ID Character(4) VARCHAR2(4) NOT NULL Storage Rule ID

    Prompt Table: STOR_RULES_INV

    14 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    15 RECOM_STOR_TEMP Signed Number(7,2) DECIMAL(5,2) NOT NULL Storage Temp
    16 RECOM_HUMIDITY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Storage Humidity
    17 INV_PROD_GRADE Character(4) VARCHAR2(4) NOT NULL Grade

    Prompt Table: INV_ITEM_GRADE

    18 MAX_CAPACITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Max Capacity
    19 HAZ_CLASS_CD Character(4) VARCHAR2(4) NOT NULL Hazard Code

    Prompt Table: HAZ_TBL_INV

    20 INTL_HAZARD_ID Character(15) VARCHAR2(15) NOT NULL Intl Hazard ID
    21 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code

    Prompt Table: CHARGE_CODE_INV

    22 SHELF_LIFE Number(4,0) SMALLINT NOT NULL Shelf Life (Days)
    23 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
    1=Open
    2=Restricted
    3=Hold
    4=Rejected
    24 INV_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
    25 INV_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
    26 INV_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
    27 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
    28 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume
    29 INV_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
    30 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color
    31 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    32 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

    Prompt Table: UNITS_TBL

    33 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

    Prompt Table: UNITS_TBL

    34 UNIT_MEASURE_TEMP Character(3) VARCHAR2(3) NOT NULL Temperature UOM

    Prompt Table: UNITS_TBL

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

    Prompt Table: UNITS_TBL

    36 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

    Prompt Table: COMMOD_CODE

    37 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code

    Prompt Table: HRMN_TARIFF_CD

    38 MSDS_ID Character(10) VARCHAR2(10) NOT NULL MSDS ID

    Prompt Table: MSDS_ID_INV

    39 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes
    40 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    41 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    42 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    43 COMMODITY_CD_EU Character(10) VARCHAR2(10) NOT NULL EU Commodity Code

    Prompt Table: COMMOD_CODE_EU

    44 AVAIL_LEAD_TIME Number(4,0) SMALLINT NOT NULL Availability Lead Time (Days)
    45 RETEST_LEAD_TIME Number(4,0) SMALLINT NOT NULL Retest Lead Time (Days)
    46 CHARGE_MARKUP_PCNT Signed Number(16,2) DECIMAL(14,2) NOT NULL Charge Markup %
    47 CHARGE_MARKUP_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Charge Markup Amt