FAI_EXT_SRC_VW (SQL View)	Index Back
External source view External source view

FAI_EXT_SRC_VW

(SQL View)

External source view

SELECT DISTINCT A.EXT_SYSTEM_ID , A.SOURCE FROM PS_FAI_EXT_SRC_TBL A , PS_FAI_EXTSYS_TBL B WHERE A.Ext_SYSTEM_ID = B.EXT_SYSTEM_ID AND B.FAI_ENABLE_EXT_SRC = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_SYSTEM_ID Character(10) VARCHAR2(10) NOT NULL External System ID

2 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_SYSTEM_ID	Character(10)	VARCHAR2(10) NOT NULL	External System ID
2	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.