RC_ADDRESS_VW(SQL View) |
Index Back |
|---|---|
RMA Address CM ViewThis is an Address Contact Method view for RMA. |
| SELECT DISTINCT A.BO_ID_2 , A.BO_ID_1 , B.PROFILE_CM_SEQ , C.CM_ID , C.TIMEZONE , C.REGION_ID , C.CM_CONCAT FROM PS_BO_REL A , PS_BO_CM B , PS_CM C WHERE (A.BO_ID_2 = B.BO_ID OR A.BO_ID_1 = B.BO_ID) AND A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn AND B.CM_TYPE_ID = 1 AND B.CM_TYPE_ID = C.CM_TYPE_ID AND B.CM_ID = C.CM_ID AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 3 | PROFILE_CM_SEQ_ADD | Number(31,0) | DECIMAL(31) NOT NULL | This field is used to store the profile contact method sequence number for an address. |
| 4 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 5 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 6 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 7 | CM_CONCAT | Character(100) | VARCHAR2(100) NOT NULL | Concatenated Contact Method |