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.