While this table does not have a field defined as a primary key, the ACCOUNTOPERATINGCOMPID field should be unique and considered a primary key.
Added in version 7.5.4
The ACCOUNTOPERATINGCOMP table stores the operating companies with which an account is linked. This table is the Many to Many mapping between the ACCOUNT and APPIDMAPPING tables. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the ACCOUNTOPERATINGCOMPID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ACCOUNTOPERATINGCOMPID |
char(12) |
NOT NULL
|
ACCOUNTOPERATINGCOMP_PRIMARY (AK) |
|
|
|
ACCOUNTID (FK) |
char(12) |
NOT NULL |
ACCOUNTOPERATINGCOMP_ACCOUNTID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
ACCOUNTOPERATINGCOMP_APPID (IE) |
(Many) to (One) |
|
|
SHAREDID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
ACCOUNTOPERATINCOMP.ACCOUNTOPERATINGCOMPID |
|
LINKEDDATE |
datetime |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|