BUSINESS_UNITSP_REQ_IDLINE_NBRD=Rate Defined by SC
N=Not Applicable
P=Pending Rate Synchronization
R=Ready for rate
S=Sent to SC for Rate
D=Default from Business Unit
N=No
Y=Yes
SPF_REQRATE_TMP(SQL Table) |
Index Back |
|---|---|
Temporary Table for Rates SyncTemporary Table to store the Req Rates submitted by the Services Coordinator. The rates will be synched up with the Requisition when the Requester submits the Requsition for approval. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SP_REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SP_NUM_OF_POSITION | Number(5,0) | INTEGER NOT NULL | Number of Positions |
| 5 | SP_PAY_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | pay rate |
| 6 | SP_PAY_RATE_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | pay rate in the base currency |
| 7 | SP_FIXED_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | fixed costs |
| 8 | SP_FIXED_COST_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | fixed costs in the base currency |
| 9 | SP_VNDR_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | vendor markup |
| 10 | SP_VNDR_MARKUP_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | vendor markup in the base currency |
| 11 | SP_3RDPARTY_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | third party markup amount |
| 12 | SP_3RDPTY_MKUP_BSE | Number(15,4) | DECIMAL(14,4) NOT NULL | third party markup amount in the base currency |
| 13 | SPF_RATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Rate |
| 14 | SPF_RATE_BSE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Base Rate field for sPro Requisitions |
| 15 | SP_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL | Rate Unit of Measure |
| 16 | SPF_EXPENSE_RATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Expense Rate |
| 17 | SPF_EXP_RATE_BSE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Expense Rate in base currency |
| 18 | SP_EXP_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL | stores the supplier's rate uom |
| 19 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 20 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 21 | SP_RATES_BY_SC | Character(1) | VARCHAR2(1) NOT NULL |
Flag for Rate definition by SC - Translate values
D - Rate defined by SC
N - Not applicable
P - Pending Rate Synchronization
R - Ready for rate definition.
S - Sent to SC for rate definition.
D=Rate Defined by SC N=Not Applicable P=Pending Rate Synchronization R=Ready for rate S=Sent to SC for Rate |
| 22 | SPA_USE_EXPENSES | Character(1) | VARCHAR2(1) NOT NULL |
Field to indicate if the expenses is allowed in the transcation or not.
D=Default from Business Unit N=No Y=Yes |
| 23 | SP_OVERWRITE_AMT | Character(1) | VARCHAR2(1) NOT NULL | Overwrite Requisition amount? |
| 24 | SP_REQLN_AVG_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Stores the supplier's total rate. |
| 25 | SPF_EXPENSE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total expense amount. |
| 26 | SPF_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total expense amount for base currency |
| 27 | SPF_REQ_LN_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Stores the supplier's total rate. |
| 28 | SPF_LN_TOTAL_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Requisition line total in Base currency |
| 29 | RATE_EFFDT | Date(10) | DATE | Rate Effective Date |
| 30 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 31 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |