RO_HDR_SITEC_VW (SQL View)	Index Back
Search View Search View

RO_HDR_SITEC_VW

(SQL View)

Search View

SELECT HDR.CAPTURE_ID , BO.BO_ID , BO.PROFILE_CM_SEQ FROM PS_RO_HEADER HDR , PS_RO_DEST DST , PS_RO_BOID BO WHERE HDR.CAPTURE_ID=BO.CAPTURE_ID AND HDR.CAPTURE_ID=DST.CAPTURE_ID AND DST.UID20F_SITEC=BO.UID20

# 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 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

3 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

#	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	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
3	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.