CAPTURE_IDLANGUAGE_CDRO_SOLDTR_LNGVW(SQL View) |
Index Back |
|---|---|
Sold to RegionThis view is used by Interactive Reports to help BAM query for Order Revenue and Order Metrics |
| SELECT E.CAPTURE_ID , F.LANGUAGE_CD , C.REGION_ID , F.DESCR FROM PS_BO_SRCH_ADD C , PS_RO_BOID D , PS_RO_HEADER E , PS_RB_REGION_LNG 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 |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |