RF_SO_ADDR_VW(SQL View) |
Index Back |
---|---|
SO Address CM ViewThis is the address view that is based on a specified customer and is used on the service order. |
SELECT A.BO_ID , A.ROLE_TYPE_ID , A.PROFILE_CM_SEQ , %TrimSubstr(A.ADDRESS1,1,37) %Concat ', ' %Concat %TrimSubstr(A.CITY,1,20) %Concat ', ' %Concat %TrimSubstr(A.STATE,1,6) %Concat '-' %Concat %TrimSubstr(A.POSTAL,1,12) , A.CM_ID , A.PRIMARY_IND , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.ADDRESS1_AC , A.ADDRESS2_AC , A.ADDRESS3_AC , A.ADDRESS4_AC , A.CITY_AC , A.STATE , A.POSTAL , A.COUNTRY FROM PS_BO_ROLECM_CADDR A |
# | 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 | 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 | ADDRESS80 | Character(80) | VARCHAR2(80) NOT NULL | Address |
5 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
6 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |
7 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
8 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
9 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
10 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
12 | ADDRESS1_AC | Character(55) | VARCHAR2(55) NOT NULL | ADDRESS1_AC |
13 | ADDRESS2_AC | Character(55) | VARCHAR2(55) NOT NULL | ADDRESS2_AC |
14 | ADDRESS3_AC | Character(55) | VARCHAR2(55) NOT NULL | ADDRESS3_AC |
15 | ADDRESS4_AC | Character(55) | VARCHAR2(55) NOT NULL | Alternate Character Address 4. |
16 | CITY_AC | Character(30) | VARCHAR2(30) NOT NULL | CITY_AC |
17 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
18 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
19 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |