BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
SP_REQ_IDDefault Value: NEXT
LINE_NBRDefault Value: 1
SPF_REQ_LINE_PT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW |
| 2 | SP_REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Service Request ID
Default Value: NEXT |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | SP_PAY_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | pay rate |
| 5 | SP_FIXED_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | fixed costs |
| 6 | SP_VNDR_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | vendor markup |
| 7 | SP_VNDR_MARKUP_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | vendor markup percent |
| 8 | SP_3RDPARTY_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | third party markup amount |
| 9 | SP_3RDPTY_MKUP_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | third party vendor markup percent |
| 10 | SP_3RDPARTY_VNDR | Character(40) | VARCHAR2(40) NOT NULL | the name of the 3rd party vendor used when bidding, part of the rate breakdown feature |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | SP_PAY_RATE_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | pay rate in the base currency |
| 13 | SP_FIXED_COST_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | fixed costs in the base currency |
| 14 | SP_VNDR_MARKUP_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | vendor markup in the base currency |
| 15 | SP_3RDPTY_MKUP_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | third party markup amount in the base currency |
| 16 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |