CAPTURE_IDRO_INTHDR_VW(SQL View) |
Index Back |
|---|---|
Integration TableStores the external ID's for all external system objects (i.e. orders in other systems) |
| SELECT CAPTURE_ID ,EXTERNAL_ID_1 ,EXTERNAL_ID_2 ,EXTERNAL_ID_3 FROM PS_RO_INTEGRATION WHERE RECNAME='RO_HEADER' AND UID20F=CAPTURE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 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. |