CDT_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 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

SELECT p.setid , p.product_id , p.descr , p.descr254 , p.activity_id , 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.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.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 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 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 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Product Char 10 A
    17 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Product Char 10 B
    18 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Product Char 10 C
    19 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Product Char 10 D
    20 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Product Char1 A
    21 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Product Char1 B
    22 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Product Char1 C
    23 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Product Char1 D
    24 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Product Char 2
    25 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Product Char 30 A
    26 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Product Char 30 B
    27 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Product Char 30 C
    28 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Product Char 30 D
    29 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Product Char 8
    30 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Product Char 6
    31 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Product Char 8
    32 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 A
    33 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 B
    34 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 C
    35 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 D
    36 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 A
    37 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 B
    38 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 C
    39 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 D
    40 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
    41 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    45 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    46 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    47 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes

    Y/N Table Edit

    48 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
    49 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
    50 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    51 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future
    52 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    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 PROMISE_OPTION Character(1) VARCHAR2(1) NOT NULL Order Promise Option
    2=Perform ATP Reservations
    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
    N=N
    Y=Y
    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
    4=Purchase
    5=Lease
    B=Return
    65 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    66 UPPER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Upper Margin %