PC_TIER_TPL_SEQ

(SQL Table)
 Index Back

Tiered Pricing Template Seq

Tiered Pricing Template with template, arbitration sequence number, transaction identifier and unit of measure.

  • Parent record: PC_TIER_TPL

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

    Default Value: PC_TIER_TPL.SETID

    Prompt Table: SP_SETID_NONVW

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

    Default Value: PC_TIER_TPL.TIER_TEMPLATE

    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    4 PC_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Transaction Identifier

    Prompt Table: PC_TRANS_ID

    5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL