FO_PST_ORDER_VW (SQL View)	Index Back
Search view for order This View is created for Related Content Feature. This view is created to find the customer id assoicated with order

FO_PST_ORDER_VW

(SQL View)

Search view for order

This View is created for Related Content Feature. This view is created to find the customer id assoicated with order

SELECT BUSINESS_UNIT , SO_ID ,CUST_ID FROM PS_RS_SO_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
Prompt Table: FO_ORDR_SRCH_VW

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID Prompt Table: FO_ORDR_SRCH_VW
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.