The ADDRESS table stores the address information for Infor CRM accounts, contacts, users, and Remote Offices. This information includes type of address, description, number and street, city, state, postal code, county, country, designations for use as primary or mailing address, salutation to use for mailing, routing, additional addresses, and time zone.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ADDRESSID (PK) |
STANDARDID |
NOT NULL
|
ADDRESS_ADDRESSID_PK (CA) ADDRESS_ADDRESSID_EXT (IE) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPSHIPMENTADDRESS.ADDRESSID | ||||
| (One) to (Many) | QUOTEADDRESS.ADDRESSID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
ENTITYID (FK) |
STANDARDID |
NOT NULL |
ADDRESS_ENTITYID (CA) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
(Many) to (One) |
|||||
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS1 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS2 |
varchar(64) |
NULLS |
|
|
|
|
CITY |
varchar(32) |
NULLS |
ADDRESS_CITY (IE) |
|
|
|
STATE |
varchar(32) |
NULLS |
ADDRESS_STATE (IE) |
|
|
|
POSTALCODE |
varchar(24) |
NULLS |
ADDRESS_POSTALCODE (IE) |
|
|
|
COUNTY |
varchar(32) |
NULLS |
|
|
|
|
COUNTRY |
varchar(32) |
NULLS |
ADDRESS_COUNTRY (IE) |
|
|
|
ISPRIMARY |
BOOLEAN |
NULLS |
|
|
|
|
ISMAILING |
BOOLEAN |
NULLS |
|
|
|
|
SALUTATION |
varchar(64) |
NULLS |
|
|
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
ROUTING |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS3 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS4 |
varchar(64) |
NULLS |
|
|
|
|
TIMEZONE |
varchar(64) |
NULLS |
|
|
|
|
ERPNAME |
varchar(64) |
NULLS |
|
|
|
|
TICK |
int |
NULLS |
|
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
ADDRESS_GLOBALSYNCID (IE) |
|
|
|
ADDRESSTYPE |
varchar(32) |
NULLS |
|
|
|
|
PRIMARYADDRESS |
varchar(1) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| ENTITYTYPE |
varchar(128) |
NULLS |
|||
| ADDRESS6 |
varchar(64) |
NULLS |
|||
| COUNTRYCODE |
varchar(3) |
NULLS |
|||
| ADDRESS5 |
varchar(64) |
NULLS |
|||
| GEOCODEPROVIDER |
nvarchar(64) |
NULLS | |||
| GEOCODELONGITUDE | float | NULLS | |||
| GEOCODELATITUDE | float | NULLS | |||
| GEOCODEFAILED |
nchar(1) |
NULLS |