ORDENT_PROD_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.

SELECT setid , product_id , descr , descr254 , activity_id , business_unit_pc , catalog_nbr , cfg_code_opt , ' ' , cfg_kit_flag , comm_flag , comm_pct , cost_element , cp_template_id , cp_tree_dist , physical_nature , prod_field_c10_a , prod_field_c10_b , prod_field_c10_c , prod_field_c10_d , prod_field_c1_a , prod_field_c1_b , prod_field_c1_c , prod_field_c1_d , prod_field_c2 , prod_field_c30_a , prod_field_c30_b , prod_field_c30_c , prod_field_c30_d , prod_field_c4 , prod_field_c6 , prod_field_c8 , prod_field_n12_a , prod_field_n12_b , prod_field_n12_c , prod_field_n12_d , prod_field_n15_a , prod_field_n15_b , prod_field_n15_c , prod_field_n15_d , ' ' , drop_ship_flag , eff_status , export_lic_req , hold_update_sw , ' ' , inv_item_id , ' ' , ' ' , ' ' , ' ' , eoep_mrgbase_flg , lower_margin_pct , model_nbr , ' ' , price_kit_flag , product_kit_flag , project_id , return_flag , ' ' , tax_product_nbr , tax_trans_sub_type , tax_trans_type , ' ' , upper_margin_pct , vat_svc_perfrm_flg , prod_category , prod_brand FROM PS_PROD_ITEM

  • Related Language Record: PROD_ITEM_LNG

    • # 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 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 Configuration Code Generation
    B=Both
    N=No
    Y=Yes

    Y/N Table Edit

    9 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
    10 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    46 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    47 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    48 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes
    49 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
    50 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
    51 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    52 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
    1=Cost
    2=Alternate
    53 LOWER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Lower Margin %
    54 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model Number
    55 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration
    56 PRICE_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Price Kit Flag
    C=Price Kit at Component Level
    T=Price Kit at Top Level
    57 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

    Y/N Table Edit

    58 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    59 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned

    Y/N Table Edit

    60 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    61 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number
    62 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
    63 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    64 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    65 UPPER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Upper Margin %
    66 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
    67 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
    68 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand