SP_RATESHEET_VW(SQL View) |
Index Back |
---|---|
Ratesheet for a regionRatesheet 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
|
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 |