RO_SOLDTOC_VW(SQL View) |
Index Back |
---|---|
Order Capture Sold To viewThis 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 |