RO_HDR_CUST_VW (SQL View)	Index Back
Order Customer view Search View - List the sold-to, bill-to, and ship-to customer for an order

RO_HDR_CUST_VW

(SQL View)

Order Customer view

Search View - List the sold-to, bill-to, and ship-to customer for an order

SELECT HDR.CAPTURE_ID , SLD.BO_ID , SLD.PROFILE_CM_SEQ , SLD.ROLE_TYPE_ID , BIL.BO_ID , BIL.PROFILE_CM_SEQ , BIL.UID20F_ADDR , SHP.BO_ID , SHP.PROFILE_CM_SEQ , SHP.UID20F_ADDR , SLD.BO_ID_EIP , SLD.PROFILE_CM_SEQ_EIP , BIL.BO_ID_EIP , BIL.PROFILE_CM_SEQ_EIP , SHP.BO_ID_EIP , SHP.PROFILE_CM_SEQ_EIP FROM PS_RO_HEADER HDR , PS_RO_BOID SLD , PS_RO_BOID BIL , PS_RO_DEST DSS , PS_RO_BOID SHP WHERE HDR.CAPTURE_ID=SLD.CAPTURE_ID AND HDR.UID20F_SOLD=SLD.UID20 AND HDR.CAPTURE_ID=BIL.CAPTURE_ID AND HDR.UID20F_BILL=BIL.UID20 AND HDR.CAPTURE_ID=DSS.CAPTURE_ID AND HDR.UID20F=DSS.UID20 AND DSS.CAPTURE_ID=SHP.CAPTURE_ID AND DSS.UID20F_SHIP=SHP.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_SOLD Number(31,0) DECIMAL(31) NOT NULL Sole To Business Object ID

3 PROFILE_CM_SEQ_SLD Number(31,0) DECIMAL(31) NOT NULL Profile Contact Method Sequence Number for the Sold To Address

4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

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

6 PROFILE_CM_SEQ_BIL Number(31,0) DECIMAL(31) NOT NULL Profile Contact Method Sequence Number for Billing

7 UID20F_BILL Character(20) VARCHAR2(20) NOT NULL Foreign UID

8 BO_ID_SHIP Number(31,0) DECIMAL(31) NOT NULL Business Object ID

9 PROFILE_CM_SEQ_SHP Number(31,0) DECIMAL(31) NOT NULL Profile Sequence

10 UID20F_ADDR Character(20) VARCHAR2(20) NOT NULL Foreign UID

11 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

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

13 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

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

15 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

16 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_SOLD	Number(31,0)	DECIMAL(31) NOT NULL	Sole To Business Object ID
3	PROFILE_CM_SEQ_SLD	Number(31,0)	DECIMAL(31) NOT NULL	Profile Contact Method Sequence Number for the Sold To Address
4	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
5	BO_ID_BILL	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
6	PROFILE_CM_SEQ_BIL	Number(31,0)	DECIMAL(31) NOT NULL	Profile Contact Method Sequence Number for Billing
7	UID20F_BILL	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
8	BO_ID_SHIP	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
9	PROFILE_CM_SEQ_SHP	Number(31,0)	DECIMAL(31) NOT NULL	Profile Sequence
10	UID20F_ADDR	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
11	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
12	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.
13	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
14	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.
15	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
16	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.