FO_ORDR_PAST_VW

(SQL View)
 Index Back

SELECT a.business_unit , %Substring(a.ownership_id , 1 , 5) , a.cust_id , b.so_status , a.user_order_type , a.so_id , a.descr , a.start_date , d.so_line , d.reg_bill_rate , d.reg_pay_rate FROM PS_RS_SO_HDR a , PS_RS_SO_STATUS b , PS_RS_SO_LINE d WHERE a.business_unit = d.business_unit AND a.so_id = d.so_id AND a.business_unit = b.business_unit AND a.so_id = b.so_id AND b.lastupddttm = ( SELECT MAX(c.lastupddttm) FROM PS_RS_SO_STATUS c WHERE b.business_unit = c.business_unit AND b.so_id = c.so_id) AND a.system_source = 'STF'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 FO_BRANCH Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: CUSTOMER

4 FO_ORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Order Status
D=Draft
E=Ended
F=Filled
U=Unfilled
5 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
6 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 START_DATE Date(10) DATE Start Date for Gen Standing PO
9 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
10 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate
11 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate