Added in version 8.3
The ERPCONTACTACCOUNT table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPCONTACTACCOUNTID (PK) |
nchar(12) |
NOT NULL |
ERPCONTACTACCOUNT_PRIMARY (AK) |
||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ACCOUNTID(FK) |
nchar(12) |
NULLS |
ERPCONTACTACCOUNT_ACCOUNTID(IE) |
(One) to (Many) | ACCOUNT.ACCOUNTID |
|
CONTACTID(FK) |
nchar(12) |
NULLS |
ERPCONTACTACCOUNT_CONTACTID(IE) |
(One) to (Many) | CONTACT.CONTACTID |