Added in version 8.3
The ERPPERSON table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPPERSONID (PK) |
nchar(12) |
NOT NULL |
ERPPERSON_PRIMARY (AK) |
(One) to (Many) | ERPACCOUNTPERSON.ERPPERSONID |
| (One) to (Many) | ERPINVOICEPERSON.ERPPERSONID | ||||
| (One) to (Many) | ERPSALESORDERPERSON.ERPPERSONID | ||||
| (One) to (Many) | ERPSHIPTOPERSON.ERPPERSONID | ||||
| (One) to (Many) | QUOTEPERSON.PERSONID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ADDRESSID (FK) |
nchar(12) |
NULLS |
ERPPERSON_ADDRESSID(IE) |
(Many) to (One) | ADDRESS.ADDRESSID |
|
NAME |
varchar(64) |
NULLS |
|||
|
MAINPHONE |
varchar(48) |
NULLS |
|||
|
|
varchar(255) |
NULLS |
|||
|
DESCRIPTION |
varchar(1024) |
NULLS |
|||
|
ERPEXTID |
varchar(100) |
NULLS |
ERPPERSON_ERPEXTID (IE) |
||
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|||
|
ERPLOGICALID |
varchar(255) |
NULLS |
|||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|||
|
ERPSTATUS |
varchar(64) |
NULLS |
|||
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPPERSON_ERPUNIQUEID(IE) |
||
|
ERPDISPLAYID |
varchar(100) |
NULLS |
|||
|
ROLE |
varchar(100) |
NULLS |
|||
|
ACCOUNTMANAGERID |
nchar(12) |
NULLS |
ERPPERSON_ACCOUNTMANAGERID(IE) | (Many) to (One) | USERINFO.USERID |
|
MAPPEDOWNER |
nchar(12) |
NULLS |
ERPPERSON_MAPPEDOWNER(IE) |
(Many) to (One) | SECCODE.SECCODEID |