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)

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.