OCD_CDHMERGE_VW (SQL View)	Index Back
Order Sold to Customer view Search View - List the sold-to customer and sold to contact for an order

OCD_CDHMERGE_VW

(SQL View)

Order Sold to Customer view

Search View - List the sold-to customer and sold to contact for an order

SELECT HDR.CAPTURE_ID , SLD.BO_ID , SLDC.BO_ID FROM PS_RO_HEADER HDR , PS_RO_BOID SLD , PS_RO_BOID SLDC WHERE HDR.CAPTURE_ID=SLD.CAPTURE_ID AND HDR.UID20F_SOLD=SLD.UID20 AND HDR.CAPTURE_ID=SLDC.CAPTURE_ID AND HDR.UID20F_SOLDC=SLDC.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 BO_ID_SOLD_TO_CNT Number(31,0) DECIMAL(31) NOT NULL BO ID for the sold to contact.

#	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	BO_ID_SOLD_TO_CNT	Number(31,0)	DECIMAL(31) NOT NULL	BO ID for the sold to contact.