RO_HDR_ADD_VW (SQL View)	Index Back
Capture Header Search View This is the search view for order capture headers

RO_HDR_ADD_VW

(SQL View)

Capture Header Search View

This is the search view for order capture headers

SELECT CAPTURE_ID , BUSINESS_UNIT , CAPTURE_TYPE_CD , 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.
Default Value: NEW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RO_NONVW

3 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order
Prompt Table: RO_TYPE

4 BULK_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used to determinate if an order is the master order when using bulk ordering.

5 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.

6 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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. Default Value: NEW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RO_NONVW
3	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order Prompt Table: RO_TYPE
4	BULK_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determinate if an order is the master order when using bulk ordering.
5	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.
6	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time