If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
Added in Version 7.0
The LEAD_ADDRESS table stores the address information for Infor CRM leads. 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.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
LEAD_ADDRESSID (PK) |
char(12) |
NOT NULL |
LEAD_ADDRESS_LEAD_ADDRESSID_PK (CA) |
(Many) to (One) |
|
|
LEADID (FK) |
char(12) |
NOT NULL |
LEAD_ADDRESS_LEADID(IE) |
(One) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
MODIFYDATE |
datetime(8) |
NULLS |
|||
|
ADDRESS1 |
varchar(64) |
NULLS |
|||
|
ADDRESS2 |
varchar(64) |
NULLS |
|||
|
ADDRESS3 |
varchar(64) |
NULLS |
|||
|
ADDRESS4 |
varchar(64) |
NULLS |
|||
|
CITY |
varchar(32) |
NULLS |
LEAD_ADDRESS_CITY (IE) |
||
|
COUNTRY |
varchar(32) |
NULLS |
LEAD_ADDRESS_COUNTRY (IE) |
||
|
COUNTY |
varchar(32) |
NULLS |
|||
|
DESCRIPTION |
varchar(64) |
NULLS |
|||
|
IMPORTID (FK) |
char(12) |
NULLS |
LEAD_ADDRESS_IMPORTID (IE) |
unknown |
|
|
ISMAILING |
char(1) |
NULLS |
|||
|
ISPRIMARY |
char(1) |
NULLS |
|||
|
POSTALCODE |
varchar(24) |
NULLS |
LEAD_ADDRESS_POSTALCODE (IE) |
||
|
ROUTING |
varchar(64) |
NULLS |
|||
|
SALUTATION |
varchar(64) |
NULLS |
|||
|
STATE |
varchar(32) |
NULLS |
LEAD_ADDRESS_STATE (IE) |
||
|
TIMEZONE |
varchar(64) |
NULLS |
|||
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|