RC_ADDRESS_VW3(SQL View) |
Index Back |
|---|---|
Company Site Address CM ViewView used on RMA page to get primary address of the customer. |
| SELECT DISTINCT BO_ID , PROFILE_CM_SEQ , CM_ID , TIMEZONE , REGION_ID FROM PS_BO_SRCH_ADD WHERE PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 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. |