RO_SOLDTO_VW (SQL View)	Index Back
Order Capture Sold To This view contains the details of Order Capture Sold To

RO_SOLDTO_VW

(SQL View)

Order Capture Sold To

This view contains the details of Order Capture Sold To

SELECT A.CAPTURE_ID , C.BO_NAME , C.BO_NAME_DISPLAY FROM %Table(RO_HEADER) A , %Table(RO_BOID) B , %Table(BO_NAME) C WHERE A.CAPTURE_ID=B.CAPTURE_ID AND A.UID20F_SOLD=B.UID20 AND B.BO_ID=C.BO_ID AND C.PRIMARY_IND = 'Y'

# 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_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	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_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object