PC_CRATE_DEFN

(SQL Table)
 Index Back

Project Custom Rate Definition

Define attributes for a Project Costing Custom Rate.

  • Related Language Record: PC_CRATE_LANG

  • Parent Record Of PC_CRATE_LN

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 RATE_NAME Character(15) VARCHAR2(15) NOT NULL Unique Identifier for a Custom Rate Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 APPLY_RATE_TO Character(1) VARCHAR2(1) NOT NULL Apply Rates to
    A=Source Amount
    Q=Source Quantity

    Default Value: Q

    5 NUM_FIELDS Number(5,0) INTEGER NOT NULL Number of Fields
    6 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: PC_CR_FIELDS_VW

    7 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2

    Prompt Table: PC_CR_FIELDS_VW

    8 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: PC_CR_FIELDS_VW

    9 FIELDNAME4 Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: PC_CR_FIELDS_VW

    10 FIELDNAME5 Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: PC_CR_FIELDS_VW

    11 PRICE_WHERE_SQL Character(254) VARCHAR2(254) NOT NULL SQL fragment for use with the PC_PRICING engine.