While this table does not have a field defined as a primary key, the ACCOUNTID field should be unique and considered a primary key.
Added in version 7.5.4
The ERPTRADINGACCOUNT table is an extension table of the ACCOUNT table used to store the additional trading account (company) information from the accounting system. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the ACCOUNTID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ACCOUNTID (FK) |
char(12) |
NOT NULL |
ERPTRADINGACCOUNT_PRIMARY (AK) |
(One) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
ERPTRADINGACCOUNT_SECCODEID (IE) |
(Many) to (One) |
|
|
CUSTOMERSUPPLIERFLAG |
varchar(32) |
NULLS |
|
|
|
|
OPENEDDATE |
datetime |
NULLS |
|
|
|
|
SHORTNAME |
varchar(64) |
NULLS |
|
|
|
|
DELIVERYMETHOD |
varchar(64) |
NULLS |
|
|
|
|
FINANCEBALANCE |
numeric(17,4) |
NULLS |
|
|
|
|
FINANCELIMIT |
numeric(17,4) |
NULLS |
|
|
|
|
FINANCEBALANCEDATE |
datetime |
NULLS |
|
|
|
|
FINANCESTATUSFLAG |
varchar(1) |
NULLS |
|
|
|
|
FINANCESTATUSTEXT |
varchar(64) |
NULLS |
|
|
|
|
PAYMENTTERMS |
varchar(32) |
NULLS |
|
|
|
|
ERPSTATUS |
varchar(64) |
NULLS |
|
|
|
|
REFERENCE1 |
varchar(24) |
NULLS |
|
|
|
|
REFERENCE2 |
varchar(24) |
NULLS |
|
|
|
| CURRENCYCODE |
varchar(64) |
NULLS |
|||
| FINANCELIMITBASEAMOUNT |
numeric(17,4) |
NULLS |
|||
| BASECURRENCYCODE |
varchar(64) |
NULLS |