RC_ADDRESS_VW1(SQL View) |
Index Back |
|---|---|
RMA Address CM View |
| SELECT B.BO_ID , B.PROFILE_CM_SEQ , C.CM_ID , C.TIMEZONE , C.REGION_ID FROM PS_BO_CM B , PS_CM C WHERE 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 | 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. |
| 3 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 4 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 5 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |