SPF_WO_RACT_VW

(SQL View)
Index Back

Work Order Activities

Work Order Rate Based Activities

SELECT BUSINESS_UNIT , WORK_ORDER_ID , ACTIVITY_ID , UNIT_OF_MEASURE , PL_RATE , PL_RATE_BSE , QUANTITY , SP_BILL_AMOUNT , SP_BILL_AMOUNT_BSE , CURRENCY_CD , CURRENCY_CD_BASE , RT_TYPE , RATE_EFFDT , RATE_DIV , RATE_MULT FROM PS_SPF_WO_RATE_ACT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: SPF_WO_ACT_VW

4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
5 PL_RATE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate
6 PL_RATE_BSE Number(15,4) DECIMAL(14,4) NOT NULL Progress Log Rate Base
7 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
8 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount
9 SP_BILL_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Time and Expense amount reported in the base currency
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
12 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
13 RATE_EFFDT Date(10) DATE Rate Effective Date
14 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
15 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier