RDFSITE_SERVIC1 (SQL View)	Index Back
FSI Location Services Services associate to Service Location

RDFSITE_SERVIC1

(SQL View)

FSI Location Services

Services associate to Service Location

SELECT SITE_ID , SERVICE_ID , START_DATE , END_DATE FROM PS_RDFSITE_SERVICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SITE_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.

2 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
Prompt Table: RBF_SERVICE_FVW

3 START_DATE Date(10) DATE Start Date for Gen Standing PO
Default Value: %date

4 END_DATE Date(10) DATE End date field to store an end date.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SITE_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.
2	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID Prompt Table: RBF_SERVICE_FVW
3	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO Default Value: %date
4	END_DATE	Date(10)	DATE	End date field to store an end date.