RO_SOLDTOC_VW

(SQL View)
Index Back

Order Capture Sold To view

This record is a view for order capture sold to information

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_SOLDC=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_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object