BO_PRI_ADD_VW(SQL View) |
Index Back |
---|---|
Primary add for a Bus ObjectPrimary address for a Bus Object for Person and Company SES |
SELECT A.BO_ID ,A.ROLE_TYPE_ID ,A.CM_CONCAT , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 ,A.COUNTRY ,C.DESCR , A.CITY , A.STATE ,D.DESCR , A.POSTAL , A.CITY_AC FROM PS_BO_SRCH_ADD A , PS_COUNTRY_TBL C ,PS_STATE_TBL D WHERE A.PRIMARY_IND = 'Y' AND A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_END_DT > %CurrentDateIn AND A.COUNTRY=C.COUNTRY AND A.STATE=D.STATE AND A.COUNTRY=D.COUNTRY AND A.ROLE_TYPE_ID <> 4 UNION SELECT A.BO_ID ,86 ,A.CM_CONCAT , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 ,A.COUNTRY ,C.DESCR , A.CITY , A.STATE ,D.DESCR , A.POSTAL , A.CITY_AC FROM PS_BO_SRCH_ADD A , PS_COUNTRY_TBL C ,PS_STATE_TBL D WHERE A.CM_USE_START_DT <= %CurrentDateIn AND A.CM_USE_END_DT > %CurrentDateIn AND A.COUNTRY=C.COUNTRY AND A.STATE=D.STATE AND A.COUNTRY=D.COUNTRY AND A.ROLE_TYPE_ID = 4 AND A.cm_purpose_type_id=32 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID | |
2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID | |
3 | CM_CONCAT | Character(100) | VARCHAR2(100) NOT NULL | Concatenated Contact Method |
4 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
5 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
6 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
7 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
8 | COUNTRY2 | Character(3) | VARCHAR2(3) NOT NULL | Country field used in the response synchronous message. |
9 | DESCR30_1 | Character(30) | VARCHAR2(30) NOT NULL | Short Description...................... |
10 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
11 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
12 | DESCR30_2 | Character(30) | VARCHAR2(30) NOT NULL | Short Description.................... |
13 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
14 | CITY_AC | Character(30) | VARCHAR2(30) NOT NULL | CITY_AC |