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.adjust_altcost_pct , p.adjust_altcost_flg , p.business_unit_pc , p.catalog_nbr , m.cfg_code_opt , m.cfg_cost_opt , p.cfg_kit_flag , p.comm_flag , p.comm_pct , p.cost_element , m.cp_template_id , m.cp_tree_dist , p.physical_nature , 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.eoep_mrgbase_flg , 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 , m.promise_option , 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 , m.non_own_flag , p.vat_svc_perfrm_flg 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: ORD_PITEM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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 Activity ID
    6 ADJUST_ALTCOST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Alternate Cost Adjust Percent
    7 ADJUST_ALTCOST_FLG Character(1) VARCHAR2(1) NOT NULL Adjust Alternate cost flag indicates whether 0% adjustment is a valid value.
    8 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    9 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
    10 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
    B=Both
    N=No
    Y=Yes

    Y/N Table Edit

    11 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
    12 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit

    Y/N Table Edit

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

    Y/N Table Edit

    14 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %
    15 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    16 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    17 CP_TREE_DIST Character(18) VARCHAR2(18) NOT NULL Distribution Model Field
    18 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    19 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Product Char 10 A
    20 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Product Char 10 B
    21 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Product Char 10 C
    22 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Product Char 10 D
    23 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Product Char1 A
    24 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Product Char1 B
    25 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Product Char1 C
    26 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Product Char1 D
    27 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Product Char 2
    28 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Product Char 30 A
    29 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Product Char 30 B
    30 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Product Char 30 C
    31 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Product Char 30 D
    32 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Product Char 8
    33 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Product Char 6
    34 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Product Char 8
    35 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 A
    36 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 B
    37 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 C
    38 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 D
    39 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 A
    40 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 B
    41 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 C
    42 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 D
    43 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
    44 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
    N=No
    Y=Yes

    Y/N Table Edit

    45 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    46 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
    NO=No
    YES=Yes

    Y/N Table Edit

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

    Y/N Table Edit

    48 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    49 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    50 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes

    Y/N Table Edit

    51 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
    52 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
    53 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    54 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future
    55 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    56 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
    1=Cost
    2=Alternate
    57 LOWER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Lower Margin %
    58 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model Number
    59 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration
    60 PRICE_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Price Kit Flag
    C=Price Kit at Component Level
    T=Price Kit at Top Level
    61 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand
    62 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
    63 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

    Y/N Table Edit

    64 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    65 PROMISE_OPTION Character(1) VARCHAR2(1) NOT NULL Order Promise Option
    2=Perform ATP Reservations
    66 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned

    Y/N Table Edit

    67 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    68 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number
    69 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
    70 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    71 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    72 UPPER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Upper Margin %
    73 PRODUCT_GROUP_FLAG Character(2) VARCHAR2(2) NOT NULL Product Group
    74 QTY_MIN_MAX_EXCEED Signed Number(2,0) DECIMAL(1) NOT NULL Min/Max Quantity Exceeded
    75 TOT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
    76 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
    77 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
    1=Ship To Location
    2=Ship From Location
    3=Buyer's Location
    4=Supplier's Location