|
SELECT A.BO_ID , B.ABE_SEQ , A.PROFILE_CM_SEQ , A.BO_CM_START_DT , A.CM_USE_START_DT , A.CM_USE_ID , A.ROLE_TYPE_ID , A.BO_REL_ID , A.BO_REL_POSITION , A.CM_ID , A.BO_CM_END_DT , A.CM_USE_END_DT , A.PRIMARY_IND , A.BO_CM_USE_TYPE , A.CM_CONCAT , A.CM_PURPOSE_TYPE_ID , A.PHYSICAL_LOCATION , A.CM_CONCAT_UPPER , %subrec(GEO_CODE_SBR,A) , %subrec(CM_ADDRESS_SBR,A) FROM %Table(BO_SRCH_ADD) A , %Table(BO_ABE_DTL) B WHERE A.BO_ID = B.BO_ID AND A.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 2 |
ABE_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Address Book sequence number.
|
| 3 |
PROFILE_CM_SEQ |
Number(31,0) |
DECIMAL(31) NOT NULL |
The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
|
| 4 |
BO_CM_START_DT |
Date(10) |
DATE |
The date that a Contact Method of a Business Object takes effect.
|
| 5 |
CM_USE_START_DT |
Date(10) |
DATE |
Contact Method Use Start Date
|
| 6 |
CM_USE_ID |
Number(6,0) |
INTEGER NOT NULL |
Relationship Contact Method Purpose ID
|
| 7 |
ROLE_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
| 8 |
BO_REL_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Relationship ID of a Business Object
|
| 9 |
BO_REL_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
This field describes the position of a Relationship pertaining to a BO. i.e. - To identify a BO in a relationship, BO_REL_ID and BO_REL_POSITION give you the relative position F = First, S = Second.
F=First Position
S=Second Postion
|
| 10 |
CM_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Contact Method ID
|
| 11 |
BO_CM_END_DT |
Date(10) |
DATE |
End date of a Contact Method of a Business Object
|
| 12 |
CM_USE_END_DT |
Date(10) |
DATE |
End date of a Contact Method Use
|
| 13 |
PRIMARY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No
Y=Yes
|
| 14 |
BO_CM_USE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use type of a Busines Object's Contact Method.
E=Business Object Relationship
R=Business Object Role
U=Contact Method Usage
|
| 15 |
CM_CONCAT |
Character(100) |
VARCHAR2(100) NOT NULL |
Concatenated Contact Method
|
| 16 |
CM_PURPOSE_TYPE_ID |
Number(6,0) |
INTEGER NOT NULL |
Relationship Contact Method Purpose ID
|
| 17 |
PHYSICAL_LOCATION |
Character(30) |
VARCHAR2(30) NOT NULL |
Physical Location (Free-Form)
|
| 18 |
CM_CONCAT_UPPER |
Character(100) |
VARCHAR2(100) NOT NULL |
Uppper Concatenated Contact Method
|
| 19 |
LATITUDE |
Signed Number(32,20) |
DECIMAL(30,20) NOT NULL |
LATITUDE
|
| 20 |
LONGITUDE |
Signed Number(32,20) |
DECIMAL(30,20) NOT NULL |
LONGITUDE
|
| 21 |
RD_ADDR_INTERSECT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to determine if the associated address is at an intersection or not.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 22 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 23 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 24 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 25 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 26 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 27 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 28 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 29 |
NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Number 2
|
| 30 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 31 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 32 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 33 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 34 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 35 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 36 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 37 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 38 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
Default Value: Y
|
| 39 |
CROSS_STREET_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Cross Street of a location
|
| 40 |
CROSS_STREET_2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Cross Street of a location
|
| 41 |
ADDRESS_SUB_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Sub Type Field
ADDR=Address
INT=Intersection
Default Value: ADDR
|
| 42 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS1_AC
|
| 43 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS3_AC
|
| 44 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS2_AC
|
| 45 |
ADDRESS4_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 4.
|
| 46 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
CITY_AC
|
| 47 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
Prompt Table:
RD_REGION_VW
|
| 48 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table:
PSTIMEZONE
|
| 49 |
CM_ID_PHONE |
Number(31,0) |
DECIMAL(31) NOT NULL |
CM_ID_PHONE
Prompt Table:
CM_PHONE
|
| 50 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|