Show/Hide Toolbars

JContAddress contains information about the addresses in a contact record. This information includes the city, street, zip code, county, state, address type (such as Home or Business), and the contact record to which the address belongs. This table represents the Addresses block on the General tab of a contact record.

Object: JContAddress (J_CONT_ADDRESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

city

CITY

(VARCHAR2) (50)

City

x

 

 

string (50)

The city in the contact address.

x

x

countryItem-->

COUNTRY_ITEM_ID

(NUMBER)

Country

x

x

LCountryItem

object

8 The country in the contact address.

--> Links to definition information for the country item.

x

x

county

COUNTY

(VARCHAR2) (50)

County

x

 

 

string (50)

The county of the contact address.

x

x

currentOn

CURRENT_ON

(DATE)

Current as of

x

 

 

date

The last known date the address was current. Time-zone-independent.

 

x

isCurrent

IS_CURRENT

(NUMBER)

 

x

 

 

boolean

Indicates whether the addess is current.

0 - Not Current

1 - Current

x

x

owner-->

CONTACT_ID

(NUMBER)

 

x

x

TContact

object

8 The contact to which the address belongs.

--> Links to specific information about the contact record.

 

x

postalCode

POSTAL_CODE

(VARCHAR2) (50)

Zip

x

 

 

string (50)

The zip code in the contact address.

x

x

primaryKey

PRIMARY_KEY

(NUMBER)

 

x

 

 

int

The unique ID of the contact address.

 

 

referenceNumberString

REFERENCE_NUMBER_STRING

(VARCHAR2) (50)

Guide No.

x

 

 

string (50)

The reference number for the contact address.

 

x

state

STATE

(VARCHAR2) (50)

State/Province

x

 

 

string (50)

The U.S. state in the contact address.

x

x

street

STREET

(VARCHAR20) (250)

Street

x

 

 

string (250)

The street address in the contact address.

x

x

type-->

TYPE_ID

(NUMBER)

Type

x

x

LContAddressType

object

8 The type of the contact address (such as Home or Business).

--> Links to definition information for the address type.

x

x

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates how many times the contact address was updated.