RO_HDR_REP_VW (SQL View)	Index Back
Search View - Customer contact Search View - sold-to, bill-to and ship-to contact for an order. List the original and merged bo id's

RO_HDR_REP_VW

(SQL View)

Search View - Customer contact

Search View - sold-to, bill-to and ship-to contact for an order. List the original and merged bo id's

SELECT HDR.CAPTURE_ID , SLR.BO_ID , SLR.PROFILE_CM_SEQ , SLR.ROLE_TYPE_ID , BIR.BO_ID , BIR.PROFILE_CM_SEQ , SHR.BO_ID , SHR.PROFILE_CM_SEQ , SLR.BO_ID_EIP , SLR.PROFILE_CM_SEQ_EIP , BIR.BO_ID_EIP , BIR.PROFILE_CM_SEQ_EIP , SHR.BO_ID_EIP , SHR.PROFILE_CM_SEQ_EIP FROM PS_RO_HEADER HDR , PS_RO_BOID SLR , PS_RO_BOID BIR , PS_RO_DEST DSR , PS_RO_BOID SHR WHERE HDR.CAPTURE_ID=SLR.CAPTURE_ID AND HDR.UID20F_SOLDC=SLR.UID20 AND HDR.CAPTURE_ID=BIR.CAPTURE_ID AND HDR.UID20F_BILLC=BIR.UID20 AND HDR.CAPTURE_ID=DSR.CAPTURE_ID AND HDR.UID20F=DSR.UID20 AND DSR.CAPTURE_ID=SHR.CAPTURE_ID AND DSR.UID20F_SHIPC=SHR.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_SOLDR Number(31,0) DECIMAL(31) NOT NULL Business Object ID

3 PROFILE_CM_SQ_SLDR Number(31,0) DECIMAL(31) NOT NULL Profile Sequence

4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

5 BO_ID_BILLR Number(31,0) DECIMAL(31) NOT NULL Business Object ID

6 PROFILE_CM_SQ_BILR Number(31,0) DECIMAL(31) NOT NULL Profile Sequence

7 BO_ID_SHIPR Number(31,0) DECIMAL(31) NOT NULL Business Object ID

8 PROFILE_CM_SQ_SHPR Number(31,0) DECIMAL(31) NOT NULL Profile Sequence

9 BO_ID_EIP_SLD Signed Number(32,0) DECIMAL(31) NOT NULL This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems

10 PRO_CM_SEQ_EIP_SLD 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.

11 BO_ID_EIP_BIL Signed Number(32,0) DECIMAL(31) NOT NULL This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems

12 PRO_CM_SEQ_EIP_BIL 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.

13 BO_ID_EIP_SHP Signed Number(32,0) DECIMAL(31) NOT NULL This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems

14 PRO_CM_SEQ_EIP_SHP 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_SOLDR	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
3	PROFILE_CM_SQ_SLDR	Number(31,0)	DECIMAL(31) NOT NULL	Profile Sequence
4	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
5	BO_ID_BILLR	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
6	PROFILE_CM_SQ_BILR	Number(31,0)	DECIMAL(31) NOT NULL	Profile Sequence
7	BO_ID_SHIPR	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
8	PROFILE_CM_SQ_SHPR	Number(31,0)	DECIMAL(31) NOT NULL	Profile Sequence
9	BO_ID_EIP_SLD	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems
10	PRO_CM_SEQ_EIP_SLD	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.
11	BO_ID_EIP_BIL	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems
12	PRO_CM_SEQ_EIP_BIL	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.
13	BO_ID_EIP_SHP	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems
14	PRO_CM_SEQ_EIP_SHP	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.