While this table does not have a field defined as a primary key, the ERPPHONENUMBERID field should be unique and considered a primary key.
Added in version 7.5.4
The ERPPHONENUMBER table stores the phone numbers for any entity (account, contact) and maps the phone number columns in these tables to rows in itself. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the ERPPHONENUMBERID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPPHONENUMBERID |
char(12) |
NOT NULL |
ERPPHONENUMBER_PRIMARY (AK) |
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
ERPPHONENUMBER_GLOBALSYNCID (IE) |
|
|
|
ENTITYID (FK) |
char(12) |
NULLS |
ERPPHONENUMBER_ENTITYID (IE) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
COLUMNMAP |
varchar(32) |
NULLS |
|
|
|
|
PHONETYPE |
varchar(32) |
NULLS |
|
|
|
|
TEXT |
varchar(32) |
NULLS |
|
|
|
|
COUNTRYCODE |
varchar(32) |
NULLS |
|
|
|
|
AREACODE |
varchar(6) |
NULLS |
|
|
|
|
PHONENUMBER |
varchar(32) |
NULLS |
|
|
|
|
EXTENSION |
varchar(8) |
NULLS |
|
|
|
|
ENTITYTYPE |
varchar(32) |
NULLS |
|
|
|
|
TICK |
int |
NULLS |
|
|
|
|
URI |
varchar(32) |
NULLS |
|
|
|
|
APPID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|