ORD_PROD_PRC_VW

(SQL View)
 Index Back

OM Product Item view

This record holds all the Product attributes for an Order Management Product that will be used for pricing.

SELECT %Sql(OM_ORD_PROD_PRC_VW_FIELDS) , p.eoep_mrgbase_flg , p.adjust_altcost_pct , p.adjust_altcost_flg FROM PS_PROD_ITEM p , ps_ord_invmast_vw m WHERE p.setid = m.setid (+) AND p.inv_item_id = m.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 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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    64 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    65 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number
    66 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
    67 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    68 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    69 UPPER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Upper Margin %
    70 PRODUCT_GROUP_FLAG Character(2) VARCHAR2(2) NOT NULL Product Group
    71 QTY_MIN_MAX_EXCEED Signed Number(2,0) DECIMAL(1) NOT NULL Min/Max Quantity Exceeded
    72 TOT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
    73 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
    74 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
    75 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code
    76 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
    1=Cost
    2=Alternate
    77 ADJUST_ALTCOST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Alternate Cost Adjust Percent
    78 ADJUST_ALTCOST_FLG Character(1) VARCHAR2(1) NOT NULL Adjust Alternate cost flag indicates whether 0% adjustment is a valid value.