SPB_RATESHEET_V

(SQL View)
 Index Back

Ratesheet view with all entrie


SELECT A.SETID , A.PROJ_ROLE , A.REGION_CD ,A.REGION_CD_TYPE ,A.CURRENCY_CD ,A.EFFDT ,A.UNIT_OF_MEASURE ,A.EFF_STATUS ,A.MINRATE ,A.MAXRATE ,A.TARGETRATE ,A.DESCR , A.SP_ALLOW_OVRIDE_RT , A.SP_MIN_PAY_RATE , A.SP_MAX_PAY_RATE , A.SP_TAR_PAY_RATE , A.SP_MIN_FIXED_COST , A.SP_MAX_FIXED_COST , A.SP_TAR_FIXED_COST , A.SP_MIN_VNDR_MARKUP , A.SP_MAX_VNDR_MARKUP , A.SP_TAR_VNDR_MARKUP , A.SP_MIN_3RDPARTY , A.SP_MAX_3RDPARTY , A.SP_TAR_3RDPARTY , A.SP_EXP_RATE_UOM , A.SP_MIN_EXP_RATE , A.SP_MAX_EXP_RATE , A.SP_TAR_EXP_RATE FROM PS_SPB_RATESHEET A

  • Related Language Record: SPB_RHTSHT_LG_V

  • Parent record: SPB_ROLERATE_VW

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

    Prompt Table: SETID_TBL

    2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    3 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: SPB_REGIONCD_VW

    4 REGION_CD_TYPE Character(4) VARCHAR2(4) NOT NULL Region Code Type
    ACCT=Accounting
    BO=Backorder/Reservation
    CDOM=Contract Domain
    CNTR=Contracts
    FRT=Freight
    MBR=Team Member
    PRC=Pricing
    RPT=Reporting
    RS=Resource Management
    SPRS=Procurement
    SSRC=Alternate Sources Of Supply
    TRPT=Transportation

    Default Value: SPRS

    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    6 EFFDT Date(10) DATE NOT NULL Effective Date
    7 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

    8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    9 MINRATE Number(15,4) DECIMAL(14,4) NOT NULL Minimum rate
    10 MAXRATE Number(15,4) DECIMAL(14,4) NOT NULL Max rate
    11 TARGETRATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Target Rate
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 SP_ALLOW_OVRIDE_RT Character(1) VARCHAR2(1) NOT NULL Flag used in the rate sheet page. It will indicated whether to allow rate override on the requisition page.

    Y/N Table Edit

    Default Value: Y

    14 SP_MIN_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL Pay rate Minimum
    15 SP_MAX_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL Pay rate Maximum
    16 SP_TAR_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL Pay rate Maximum
    17 SP_MIN_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL Fixed Cost Minimum
    18 SP_MAX_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL Fixed Cost Maximum
    19 SP_TAR_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL Fixed Cost Maximum
    20 SP_MIN_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL Vendor Markup Minimum
    21 SP_MAX_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL Vendor Markup Maximum
    22 SP_TAR_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL Vendor Markup Target
    23 SP_MIN_3RDPARTY Number(15,4) DECIMAL(14,4) NOT NULL 3rd Party Markup Minimum
    24 SP_MAX_3RDPARTY Number(15,4) DECIMAL(14,4) NOT NULL 3rd Party Markup Maximum
    25 SP_TAR_3RDPARTY Number(15,4) DECIMAL(14,4) NOT NULL 3rd Party Markup Target
    26 SP_EXP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL stores the supplier's rate uom

    Prompt Table: SPF_UOM_VW
    Set Control Field: UOM_WK

    27 SP_MIN_EXP_RATE Number(15,4) DECIMAL(14,4) NOT NULL Expense rate Minimum
    28 SP_MAX_EXP_RATE Number(15,4) DECIMAL(14,4) NOT NULL Expense rate Maximum
    29 SP_TAR_EXP_RATE Number(15,4) DECIMAL(14,4) NOT NULL Expense rate Target