If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The ACCOUNT table stores all information pertaining to an account. This information includes, but is not limited to, account name, division name, type of account whether national or target, sales territory the account is located in, telephone numbers, account Web address, annual revenue, number of employees, and credit rating.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ACCOUNTID (PK) |
char(12) |
NOT NULL |
ACCOUNT_ACCOUNTID_PK (AK) |
(One) to (Many) |
ACCOUNT.PARENTID |
|
(One) to (Many) |
ACCOUNTACCOUNTINGENTITY.ACCOUNTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
| (Many) to (One) | ADDRESS.ADDRESSID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | BACKOFFICE.ACCOUNTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPACCOUNTPERSON.ACCOUNTID | ||||
| (One) to (Many) | ERPBILLTOACCOUNT.ACCOUNTID | ||||
| (One) to (Many) | ERPCONTACTACCOUNT.ACCOUNTID | ||||
| (One) to (Many) | ERPINVOICE.ACCOUNTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPRECEIVABLE.ACCOUNTID | ||||
| (One) to (Many) | ERPSHIPMENT.ACCOUNTID | ||||
| (One) to (Many) | ERPSHIPTOACCOUNT.ACCOUNTID | ||||
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | QUOTE.ACCOUNTID | ||||
|
(One) to (Many) |
RETURN.ACCOUNTID in Entity Model |
||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
TYPE |
varchar(64) |
NULLS |
ACCOUNT_TYPE (IE) |
|
|
|
ACCOUNT |
varchar(128) |
NULLS |
ACCOUNT_ACCOUNT (IE) |
|
|
|
DIVISION |
varchar(64) |
NULLS |
|
|
|
|
SICCODE |
varchar(64) |
NULLS |
|
|
|
|
PARENTID (FK) |
char(12) |
NULLS |
ACCOUNT_PARENTID (IE) |
(Many) to (One) |
(represents the parent account for account hierarchy purposes) ACCOUNT.ACCOUNTID |
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
ADDRESSID (FK) |
char(12) |
NULLS |
ACCOUNT_ADDRESSID (IE) |
(Many) to (One) |
(primary address) |
|
SHIPPINGID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
REGION |
varchar(64) |
NULLS |
|
|
|
|
MAINPHONE |
varchar(32) |
NULLS |
|
|
|
|
ALTERNATEPHONE |
varchar(32) |
NULLS |
|
|
|
|
FAX |
varchar(32) |
NULLS |
|
|
|
|
TOLLFREE |
varchar(32) |
NULLS |
|
|
|
|
TOLLFREE2 |
varchar(32) |
NULLS |
|
|
|
|
OTHERPHONE1 |
varchar(32) |
NULLS |
|
|
|
|
OTHERPHONE2 |
varchar(32) |
NULLS |
|
|
|
|
OTHERPHONE3 |
varchar(32) |
NULLS |
|
|
|
|
|
varchar(128) |
NULLS |
|
|
|
|
EMAILTYPE |
varchar(64) |
NULLS |
|
|
|
|
WEBADDRESS |
varchar(128) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NOT NULL |
ACCOUNT_SECCODEID (CA) |
(Many) to (One) |
|
|
REVENUE |
decimal(17,4) |
NULLS |
|
|
|
|
EMPLOYEES |
int |
NULLS |
|
|
|
|
INDUSTRY |
varchar(64) |
NULLS |
|
|
|
|
CREDITRATING |
varchar(10) |
NULLS |
|
|
|
|
NOTES |
text |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
ACCOUNT_STATUS (IE) |
|
|
|
ACCOUNTMANAGERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
REGIONALMANAGERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
DIVISIONALMANAGERID(FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
NATIONALACCOUNT |
char(1) |
NULLS |
|
|
|
|
TARGETACCOUNT |
char(1) |
NULLS |
|
|
|
|
TERRITORY |
varchar(64) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
ACCOUNT_CREATEDATE (IE) |
|
|
|
MODIFYDATE |
datetime |
NULLS |
ACCOUNT_MODIFYDATE (IE) |
|
|
|
ACCOUNT_UC |
varchar(128) |
NULLS |
|
|
|
|
AKA |
varchar(64) |
NULLS |
|
|
|
|
CURRENCYCODE |
varchar(64) |
NULLS |
|
|
|
|
INTERNALACCOUNTNO |
varchar(32) |
NULLS |
|
|
|
|
EXTERNALACCOUNTNO |
varchar(32) |
NULLS |
|
|
|
|
PARENTACCOUNTNO |
varchar(32) |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
ACCOUNT_ALTERNATEKETPREFIX (IE) |
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
ACCOUNT_ALTERNATEKETSUFFIX (IE) |
|
|
|
DEFAULTTICKETSECCODEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
NOTIFYDEFECTS |
char(1) |
NULLS |
|
|
|
|
NOTIFYONCLOSE |
char(1) |
NULLS |
|
|
|
|
NOTIFYONSTATUS |
char(1) |
NULLS |
|
|
|
|
SHORTNOTES |
varchar(255) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
CAMPAIGNID(FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
DONOTSOLICIT |
char(1) |
NULLS |
|
|
|
|
SCORE |
varchar(32) |
NULLS |
|
|
|
|
TICKER |
varchar(16) |
NULLS |
|
|
|
|
SUBTYPE |
varchar(64) |
NULLS |
|
|
|
|
LEADSOURCEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
IMPORTSOURCE |
varchar(24) |
NULLS |
|
|
|
|
ENGINEERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SALESENGINEERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
RELATIONSHIP |
int |
NULLS |
|
|
|
|
LASTHISTORYBY (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
LASTHISTORYDATE |
datetime |
NULLS |
|
|
|
|
BUSINESSDESCRIPTION |
varchar(2000) |
NULLS |
|
|
|
|
WEBADDRESS2 |
varchar(128) |
NULLS |
|
|
|
|
WEBADDRESS3 |
varchar(128) |
NULLS |
|
|
|
|
WEBADDRESS4 |
varchar(128) |
NULLS |
|
|
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
ACCOUNT_GLOBALSYNCID (IE) |
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int |
NULLS |
ACCOUNT_TICK (IE) |
|
|
|
LASTERPSYNCUPDATE |
datetime |
NULLS |
|
|
|
|
PRIMARYOPERATINGCOMPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
PROMOTEDTOACCOUNTING |
varchar(1) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| ERPEXTID | varchar (100) | NULLS | ACCOUNT_ERPEXTID (IE) | ||
| ERPCUSTTYPE |
varchar(64) |
NULLS |
|||
| ERPCARRIERNAME |
varchar(64) |
NULLS |
|||
| ERPINCOTERM |
varchar(64) |
NULLS |
|||
|
ERPTERRITORY |
varchar(64) |
NULLS |
|||
| ERPPREFERENCE |
varchar(1) |
NULLS |
|||
| ERPINTERNALCUST |
varchar(64) |
NULLS |
|||
| ERPLOGICALID |
varchar(255) |
NULLS |
|||
| ERPTAXID |
varchar(64) |
NULLS |
|||
| ERPPAYMENTTERM |
varchar(64) |
NULLS |
|||
| ERPSTATUSDATE | datetime | NULLS | |||
| ERPACCOUNTINGID |
varchar(22) |
NULLS |
|||
| ERPPAYMENTMETHOD |
varchar(64) |
NULLS |
|||
| ERPVARIATIONID |
varchar(22) |
NULLS |
|||
|
ERPBUYERCONTACTID |
varchar(12) |
NULLS |
(Many) to (One) | CONTACT.CONTACTID | |
| ERPUNIQUEID |
varchar(377) |
NULLS |
ACCOUNT_ERPUNIQUEID (IE) | (One) to (Many) | CARRIER.ACCOUNT |
| ERPDEFAULTWAREHOUSEID |
varchar(12) |
NULLS |
(Many) to (One) | SLXLOCATION.SLXLOCATIONID | |
| ERPSHIPLINECOMPLETE |
varchar(1) |
NULLS |
|||
| ERPSHIPORDERCOMPLETE |
varchar(1) |
NULLS |
|||
| ERPSICCODE |
varchar(64) |
NULLS |
|||
| ERPSTATUS |
varchar(64) |
NULLS |
|||
| CARRIERID |
varchar(12) |
NULLS |
|||
| SYNCSTATUS |
varchar(64) |
NULLS |
|||
| ALTERNATEKEYPREFIX | nvarchar(64) | NULLS | |||
| ALTERNATEKEYSUFFIX | nvarchar(64) | NULLS | |||
|
ERPNOTES |
text |
NULLS |
|||
| ISNORMALIZED | nchar(1) | NULLS |