EOEP_TEST_SCHED

(SQL Table)
Index Back

Simulator - Pricing schedules

Simulator - Pricing schedules

  • Parent record: EOEP_TEST_LINE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APPCD_VW

    3 EOEP_TEST_ID Character(15) VARCHAR2(15) NOT NULL Price Test ID
    4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    5 PRC_SCHED_NBR Number(6,0) INTEGER NOT NULL Pricing Schedule Number
    6 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty

    Default Value: 1

    7 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.
    8 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    9 PRC_NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    11 PRICING_UOM Character(3) VARCHAR2(3) NOT NULL Pricing UOM