PROD_INVITEM_VW

(SQL View)
 Index Back

Product Inventory Item View

Date Initials Issue Description 033101 dms 6529701 Add drop_ship_flag, product_kit_flag, return_flag 021602 dms R-XXXXXX-XXXXX Add cfg_kit_flag

SELECT A.SETID , A.PRODUCT_ID , A.DESCR , A.INV_ITEM_ID , A.TAX_PRODUCT_NBR , A.TAX_TRANS_TYPE , A.TAX_TRANS_SUB_TYPE , B.DESCR , B.INVENTORY_ITEM , B.DIST_CFG_FLAG , B.PRDN_CFG_FLAG , B.CFG_CODE_OPT , B.CFG_COST_OPT , B.UNIT_MEASURE_STD , B.LOT_CONTROL , B.SERIAL_CONTROL , B.SHIP_SERIAL_CNTRL , A.COST_ELEMENT , A.DROP_SHIP_FLAG , A.PRODUCT_KIT_FLAG , A.CFG_KIT_FLAG , A.RETURN_FLAG , B.NON_OWN_FLAG , A.PHYSICAL_NATURE FROM PS_PROD_ITEM A , PS_MASTER_ITEM_TBL B WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID

  • Related Language Record: PROD_INVITMVLNG

    • # 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: MASTER_ITEM_TBL

    5 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number
    6 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    7 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
    1=Property
    2=Freight
    3=Service
    4=Rental or Lease
    5=Expense
    6=Misc
    N=None
    8 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
    9 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes
    10 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
    11 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration
    12 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
    B=Both
    N=No
    Y=Yes
    13 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
    14 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    15 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    16 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    17 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
    18 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    19 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
    N=No
    Y=Yes
    20 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
    21 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit
    22 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned
    23 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
    N=No
    Y=Yes
    24 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services