RC_CUST_TIME_VW(SQL View) |
Index Back |
|---|---|
RMA Address CM View |
| SELECT DISTINCT A.BO_ID , A.ROLE_TYPE_ID ,A.TIMEZONE ,A.CM_ID , A.PROFILE_CM_SEQ , A.PRIMARY_IND FROM PS_BO_ROLECM_ADDR A WHERE A.CM_TYPE_ID = 1 AND A.ROLE_START_DT <= %CurrentDateIn AND A.ROLE_END_DT > %CurrentDateIn AND A.BO_CM_START_DT <= %CurrentDateIn AND A.BO_CM_END_DT > %CurrentDateIn AND A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_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 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 3 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 4 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 5 | 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. |
| 6 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |