PC_TIER_TPL_BRK

(SQL Table)
Index Back

Tiered Pricing Template Breaks

Tiered Pricing Template for quantity range breaks.

  • Parent record: PC_TIER_TPL_SEQ
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: PC_TIER_TPL_SEQ.SETID

    Prompt Table: SP_SETID_NONVW

    2 TIER_TEMPLATE Character(15) VARCHAR2(15) NOT NULL Tiered Pricing Template

    Default Value: PC_TIER_TPL_SEQ.TIER_TEMPLATE

    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 PC_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Transaction Identifier

    Prompt Table: PC_TRANS_ID

    5 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number

    Default Value: 1

    6 PC_BREAK_QTY_LOW Number(15,2) DECIMAL(14,2) NOT NULL Low Quantity/Amount
    7 PC_BREAK_QTY_HIGH Number(15,2) DECIMAL(14,2) NOT NULL Upper Quantity/Amount
    8 ADJUSTMENT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Percent