The AccountSummary table is used by synchronization so that Remote users have basic information regarding accounts to which they have subscribed. The ACCOUNTSUMMARY table is also used to track Account Hierarchy, and is a child table to the ACCOUNT table.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ACCOUNTID (PK)(FK) |
STANDARDID |
NOT NULL |
ACCOUNTSUMMARY_ACCOUNTID_PK (CA) |
(One) to (One) |
|
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
ACCOUNT |
varchar(128) |
NULLS |
ACCOUNTSUMMARY_ACCOUNT (IE) |
|
|
|
SECCODEID (FK) |
STANDARDID |
NOT NULL |
ACCOUNTSUMMARY_SECCODEID (IE) |
(Many) to (One) |
|
|
PARENTID (FK) |
char(12) |
NULLS |
ACCOUNTSUMMARY_PARENTID (IE) |
(Many) to (One) |
(represents the parent account for account hierarchy purposes) ACCOUNTSUMMARY.ACCOUNTID |
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |