Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

JContAddress

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.

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 (VARCHAR 2) (50)

City

x

   

string (50)

The city in the contact address.

x

x

countryItem-->

COUNTRY_ITEM_ID (NUMBER)

Country

x

x

LCountry
Item

object

8 The country in the contact address.

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

x

x

county

COUNTY (VARCHAR 2) (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 (VARCHAR 2) (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.

   

reference
Number
String

REFERENCE_
NUMBER_
STRING (VARCHAR2) (50)

Guide No.

x

   

string (50)

The reference number for the contact address.

 

x

state

STATE (VARCHAR 2)(50)

State/Province

x

   

string (50)

The U.S. state in the contact address.

x

x

street

STREET (VARCHAR 20) (250)

Street

x

   

string (250)

The street address in the contact address.

x

x

type-->

TYPE_ID (NUMBER)

Type

x

x

LCont
AddressType

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.

   

LCountryItem

LCountryItem contains information about the country items defined for contact addresses. This includes the name of the country item, tree position, and display order. This table represents the Country Item system lookup table.

Object: LCountryItem (L_COUNTRY_ITEM)

Attribute

 

Database column name

Field in UI

End of path

Bridge

Links to object

 

Data type

 

Comments

 

childList-->

n/a

         

Do not apply. These lookup items cannot have a hierarchical structure.

 

parent-->

PARENT_ID (NUMBER)

         

displayOrder

DISPLAY_
ORDER (NUMBER)

Order

x

   

int

The order in which the table items will be listed in the GUI, lowest number first.

isActive --> IS_ACTIVE         boolean  

name

NAME (VARCHAR2) (50)

Item Name

x

   

string (50)

The name of the country.

primaryKey

PRIMARY_
KEY (NUMBER)

 

x

   

int

The unique ID of the country list item.

treePosition

TREE_
POSITION (VARCHAR2)(250)

Tree Position

x

   

string (250)

The unique four-character alphanumeric code that is created when the country list item is defined.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the country list item was updated.

LContAddressType

LContAddressType contains information about the address types defined for contact addresses. This information includes the name of the address type, tree position, and display order. This table represents the Address Type system lookup table.

Object: LContAddressType (L_CONT_ADDRESS_TYPE)

Attribute

Database column name

Field in UI

End of Path

Bridge

Links to object table

Data Type

Comments

childList-->

n/a

         

Do not apply. These lookup items cannot have a hierarchical structure.

 

parent-->

PARENT_ID (NUMBER)

         

displayOrder

DISPLAY_ORDER (NUMBER)

Order

x

   

int

The order in which the table items will be listed in the GUI, lowest number first.

isActive --> IS_ACTIVE         boolean  

name

NAME (VARCHAR2) (50)

Item Name

x

   

string (50)

The name of the address type.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the address type list item.

treePosition

TREE_POSITION (VARCHAR2) (250)

Tree Position

x

   

string (250)

The unique four- character alphanumeric code that is created when the address type is defined.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the address type list item was updated.

  • Was this article helpful?