RO_SOLDTORGN_VW

(SQL View)
 Index Back

Sold to Region

This view is used by Interactive Reports to help BAM query for Order Revenue and Order Metrics

SELECT E.CAPTURE_ID , C.REGION_ID , F.DESCR FROM PS_BO_SRCH_ADD C , PS_RO_BOID D , PS_RO_HEADER E , PS_RB_REGION F WHERE D.CAPTURE_ID = E.CAPTURE_ID AND E.UID20F_SOLD = D.UID20 AND D.BO_ID = C.BO_ID AND D.PROFILE_CM_SEQ = C.PROFILE_CM_SEQ AND C.ROLE_TYPE_ID = D.ROLE_TYPE_ID AND F.REGION_CATEGORY = 'GEOG' AND F.REGION_ID = C.REGION_ID

  • Related Language Record: RO_SOLDTR_LNGVW

    • # 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 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description