ORDENT_PITEM_VW

(SQL View)
 Index Back

OM Product Item view

This record holds all the Product attributes for an Order Management Product. This view is used by order entry. Date Initials Issue Description 081301 dms DI-MVANWINK-3 Add work fields from ordent_prod_wk

SELECT p.setid , p.product_id , p.descr , p.descr254 , p.activity_id , p.business_unit_pc , p.catalog_nbr , m.cfg_code_opt , p.cfg_kit_flag , p.comm_flag , p.comm_pct , p.cost_element , m.cp_template_id , m.cp_tree_dist , p.prod_field_c10_a , p.prod_field_c10_b , p.prod_field_c10_c , p.prod_field_c10_d , p.prod_field_c1_a , p.prod_field_c1_b , p.prod_field_c1_c , p.prod_field_c1_d , p.prod_field_c2 , p.prod_field_c30_a , p.prod_field_c30_b , p.prod_field_c30_c , p.prod_field_c30_d , p.prod_field_c4 , p.prod_field_c6 , p.prod_field_c8 , p.prod_field_n12_a , p.prod_field_n12_b , p.prod_field_n12_c , p.prod_field_n12_d , p.prod_field_n15_a , p.prod_field_n15_b , p.prod_field_n15_c , p.prod_field_n15_d , m.dist_cfg_flag , p.drop_ship_flag , p.eff_status , p.export_lic_req , p.hold_update_sw , m.inv_item_group , p.inv_item_id , m.inventory_item , m.descr , m.itm_status_current , m.itm_status_future , m.itm_stat_dt_future , m.lot_control , p.lower_margin_pct , p.model_nbr , m.prdn_cfg_flag , p.price_kit_flag , p.prod_brand , p.prod_category , p.product_kit_flag , p.project_id , p.return_flag , m.serial_control , p.tax_product_nbr , p.tax_trans_type , p.tax_trans_sub_type , m.unit_measure_std , p.upper_margin_pct , 'N' , 0 , 0 FROM ps_master_item_tbl m , PS_PROD_ITEM p WHERE m.setid = p.setid AND m.inv_item_id = p.inv_item_id

  • Related Language Record: PROD_ITEM_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Used in Contracts Integration, Activity Identifier
    6 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    7 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
    8 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configurator Code Generation

    Y/N Table Edit

    9 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
    M=Multilevel Bundle Component
    N=Lightly Configured
    Y=Schema Enabled

    Y/N Table Edit

    10 COMM_FLAG Character(1) VARCHAR2(1) NOT NULL Commissionable

    Y/N Table Edit

    11 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %
    12 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    13 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    14 CP_TREE_DIST Character(18) VARCHAR2(18) NOT NULL Distribution Model Field
    15 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Generic Product Field
    16 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Generic Product Field
    17 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Generic Product Field
    18 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Generic Product Field
    19 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Generic Product Field
    20 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Generic Product Field
    21 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Generic Product Field
    22 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Generic Product Field
    23 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Generic Product Field
    24 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Generic Product Field
    25 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Generic Product Field
    26 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Generic Product Field
    27 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Generic Product Field
    28 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Generic Product Field
    29 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Generic Product Field
    30 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Generic Product Field
    31 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field
    32 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field
    33 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field
    34 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field
    35 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Generic Product Field
    36 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Generic Product Field
    37 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Generic Product Field
    38 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Generic Product Field
    39 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
    40 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship

    Y/N Table Edit

    41 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    42 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Exprt License Required
    NO=No
    YES=Yes

    Y/N Table Edit

    43 HOLD_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Hold Update Switch

    Y/N Table Edit

    44 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    45 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    46 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item

    Y/N Table Edit

    47 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
    48 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    5=Pending Approval
    6=Denied Approval
    7=Under Initialization
    49 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    50 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future
    51 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    52 LOWER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Lower Margin %
    53 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model number field to store model number value.
    54 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration
    55 PRICE_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Price Kit Flag
    C=at Component Level
    T=at Top Level
    56 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand
    57 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
    58 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit Flag

    Y/N Table Edit

    59 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project ID
    60 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned

    Y/N Table Edit

    61 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    62 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number
    63 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
    64 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    65 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Used to store the unit of measure for an item.
    66 UPPER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Upper Margin %
    67 PRODUCT_GROUP_FLAG Character(2) VARCHAR2(2) NOT NULL Product Group FLag
    68 QTY_MIN_MAX_EXCEED Signed Number(2,0) DECIMAL(1) NOT NULL Min/Max Quantity Exceeded
    69 TOT_QTY Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Quantity