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. 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/ |
||||||||
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 |
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_ |
x |
boolean |
Indicates whether the addess is current. 0 - Not Current |
x |
x |
|||
owner--> |
CONTACT_ ID (NUMBER) |
x |
x |
object |
8 The contact to which the address belongs. --> Links to specific information about the contact record. |
x |
|||
postalCode |
POSTAL_ |
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 |
REFERENCE_ |
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 |
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 |
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_ |
x |
int |
The unique ID of the country list item. |
|||
treePosition |
TREE_ |
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. |