RO_FLTR_INTG_VW (SQL View)	Index Back
Integration Table Stores the external ID's for all external system objects (i.e. orders in other systems)

RO_FLTR_INTG_VW

(SQL View)

Integration Table

Stores the external ID's for all external system objects (i.e. orders in other systems)

SELECT H.SYNCID , I.EXTERNAL_ID_1 , I.EXTERNAL_ID_2 , I.EXTERNAL_ID_3 FROM %Table(RO_HEADER) H , %Table(RO_INTEGRATION) I WHERE H.CAPTURE_ID=I.CAPTURE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

2 EXTERNAL_ID_1 Character(20) VARCHAR2(20) NOT NULL This field is used to store an ID that came from an external system.

3 EXTERNAL_ID_2 Character(20) VARCHAR2(20) NOT NULL This field is used to store an ID that came from an external system.

4 EXTERNAL_ID_3 Character(20) VARCHAR2(20) NOT NULL This field is used to store an ID that came from an external system.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2	EXTERNAL_ID_1	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store an ID that came from an external system.
3	EXTERNAL_ID_2	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store an ID that came from an external system.
4	EXTERNAL_ID_3	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store an ID that came from an external system.