RO_CAPTURE_MAP (SQL Table)	Index Back
Capture ID/ Order ID Table Mapping of underlying Capture ID (random alpha numeric id) to Order ID (numbered by Capture Type)

RO_CAPTURE_MAP

(SQL Table)

Capture ID/ Order ID Table

Mapping of underlying Capture ID (random alpha numeric id) to Order ID (numbered by Capture Type)

# 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 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order

3 CAPTURE_ID_REL Character(20) VARCHAR2(20) NOT NULL This field stores relative capture IDs.

#	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	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order
3	CAPTURE_ID_REL	Character(20)	VARCHAR2(20) NOT NULL	This field stores relative capture IDs.