ORDENT_LNPRD_VW

(SQL View)
 Index Back

OM ord entry prod view

This record is used by OM order entry and is a view of product information for existing order lines.

SELECT l.business_unit , l.order_no , l.order_int_line_no , p.setid , p.product_id , p.activity_id , p.business_unit_pc , p.catalog_nbr , p.cfg_code_opt , m.cfg_cost_opt , p.cfg_kit_flag , p.comm_flag , p.comm_pct , p.cost_element , p.cp_template_id , p.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 , p.descr , m.dist_cfg_flag , p.drop_ship_flag , p.eff_status , p.export_lic_req , p.hold_update_sw , p.inv_item_id , m.inv_item_group , m.inventory_item , ' ' , m.itm_status_current , 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_sub_type , p.tax_trans_type , m.unit_measure_std , p.upper_margin_pct FROM PS_MASTER_ITEM_TBL m , ps_prod_item p , ps_set_cntrl_rec sc , ps_ord_line l WHERE sc.setcntrlvalue = l.business_unit AND sc.recname = 'PROD_ITEM' AND p.setid = sc.setid AND p.product_id = l.product_id AND m.setid = p.setid AND m.inv_item_id = p.inv_item_id

  • Related Language Record: ORDENT_LNPRDLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    7 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    8 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
    9 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
    B=Both
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    13 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %
    14 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    15 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    16 CP_TREE_DIST Character(18) VARCHAR2(18) NOT NULL Distribution Model Field
    17 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A
    18 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B
    19 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C
    20 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D
    21 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field
    22 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B
    23 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C
    24 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D
    25 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2
    26 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A
    27 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B
    28 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C
    29 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D
    30 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4
    31 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6
    32 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8
    33 CUST_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 A
    34 CUST_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 B
    35 CUST_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 C
    36 CUST_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 D
    37 CUST_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 A
    38 CUST_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 B
    39 CUST_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 C
    40 CUST_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 D
    41 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    42 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
    43 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    47 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    48 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    49 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes
    50 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
    51 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
    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 %