RO_FLTR_INTG_VW(SQL View) |
Index Back |
---|---|
Integration TableStores 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. |