RO_HDR_SRCH_VW

(SQL View)
Index Back

Capture Header Search View

Capture Header Search View for Chat

SELECT CAPTURE_ID , BULK_ORDER_FLAG , SYNCID , SYNCDTTM FROM PS_RO_HEADER

# 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 BULK_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used to determinate if an order is the master order when using bulk ordering.
3 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.
4 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time