SP_RATESHEET_VW

(SQL View)
Index Back

Ratesheet for a region

Ratesheet for a region

SELECT SETID , PROJ_ROLE , REGION_CD , REGION_CD_TYPE , CURRENCY_CD FROM PS_SPB_RATESHEET

# 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 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Prompt Table: %EDITTABLE16
Set Control Field: SETID

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
Set Control Field: SETID

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