FO_RL_OR_PST_VW

(SQL View)
 Index Back

Cuastomer past order view

This View is created for Related Content Feature

SELECT a.start_date , a.business_unit , %Substring(a.ownership_id , 1 , 5) , a.cust_id , b.so_status , a.user_order_type , a.so_id , a.descr , 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.so_status IN('U','F') 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 START_DATE Date(10) DATE Start Date for Gen Standing PO
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 FO_BRANCH Character(5) VARCHAR2(5) NOT NULL Business Unit
4 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: FO_CUSTOMER_SR

5 FO_ORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Order Status
D=Draft
E=Ended
F=Filled
U=Unfilled
6 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
7 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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