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.
Added in Version 6.2.1
The SALESORDER table stores information about sales orders. In version 8.3 quotes were moved to the QUOTE table.
|
|
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 |
|---|---|---|---|---|---|
|
SALESORDERID (PK) |
char(12) |
NOT NULL |
SALESORDER_SALESORDERID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | DISCOUNTCHARGEITEM.SALESORDERID | ||||
| (One) to (Many) | ERPINVOICEITEM.SALESORDERID | ||||
| (One) to (Many) | ERPSALESORDERPERSON.SALESORDERID | ||||
|
(One) to (One) |
|||||
| (One) to (Many) | ERPSHIPMENTITEM.SALESORDERID | ||||
| (Many) to (One) | QUOTE.SALESORDERID.SALESORDERID | ||||
|
(One) to (Many) |
|||||
| (One) to (Many) | SALESORDERITEMS.ERPQUOTEID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
ACCOUNTID (FK) |
char(12) |
NOT NULL |
SALESORDER_ACCOUNTID (IE) |
(Many) to (One) |
|
|
BILLINGID (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
BILLTONAME |
varchar(64) |
NULLS |
(Many) to (One) |
||
|
COMMENTS |
text(16) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
CURRENCYCODE |
varchar(64) |
NULLS |
|
|
|
|
CUSTOMERPURCHASEORDERNUMBER |
varchar(15) |
NULLS |
|
|
|
|
DOCUMENTID |
char(12) |
NULLS |
|
unknown
|
|
|
FOB |
varchar(15) |
NULLS |
|
|
|
|
FREIGHT |
float(8) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
SALESORDER_MODIFYDATE (IE) |
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
OPPORTUNITYID (FK) |
char(12) |
NULLS |
SALESORDER_OPPORTUNITYID (IE) |
(Many) to (One) |
|
|
ORDERDATE |
datetime(8) |
NULLS |
|
|
|
|
ORDERTOTAL |
float(8) |
NULLS |
|
|
|
|
ORDERTYPE |
varchar(64) |
NULLS |
|
|
|
|
SALESCOMMISSION |
float(8) |
NULLS |
|
|
|
|
SHIPPINGID (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
SHIPTONAME |
varchar(64) |
NULLS |
|
|
|
|
SHIPVIA |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
TAX |
float(8) |
NULLS |
|
|
|
|
TERMSID |
char(12) |
NULLS |
|
unknown |
|
|
TRADEDISCOUNT |
float(8) |
NULLS |
|
|
|
|
TRANSMITDATE |
datetime(8) |
NULLS |
|
|
|
|
USERID (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
BILLINGCONTACTID (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
SHIPPINGCONTACTID (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
USERFIELD1 |
varchar(64) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(64) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(64) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(128) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(128) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(1000) |
NULLS |
|
|
|
|
ALTERNATEPREFIX |
varchar(8) |
NULLS |
|
|
|
|
ALTERNATESUFFIX |
varchar(24) |
NULLS |
|
|
|
|
ACCOUNTMANAGERID (FK) |
char(12) |
NULLS |
SALESORDER_ACCOUNTMANAGERID (IE) |
(Many) to (One) |
|
|
DATEPROMISED |
datetime(8) |
NULLS |
|
|
|
|
DISCOUNT |
float(8) |
NULLS |
|
|
|
|
EXCHANGERATE |
float(8) |
NULLS |
|
|
|
|
EXCHANGERATEDATE |
datetime(8) |
NULLS |
|
|
|
|
EXCHANGERATELOCKED |
varchar(1) |
NULLS |
|
|
|
|
GRANDTOTAL |
float(8) |
NULLS |
|
|
|
|
REQUESTEDBY (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
SECCODEID (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
GLOBALSYNCID |
varchar(36) |
NULLS |
SALESORDER_GLOBALSYNCID (IE) |
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int |
NULLS |
|
|
|
|
ACTIVEFLAG |
varchar(1) |
NULLS |
|
|
|
|
PRICELISTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
DUEDATE |
datetime |
NULLS |
|
|
|
|
OPERATINGCOMPANYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ISQUOTE |
varchar(1) |
NULLS |
|
|
|
|
DISCOUNTTOTAL |
float |
NULLS |
|
|
|
|
TAXTOTAL |
float |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| ERPEXTID | varchar(100) | NULLS | SALESORDER_ERPEXTID (IE) | ||
| ERPBACKORDERED | varchar(1) | NULLS | |||
| ERPBILLINGTRIGGER | varchar(64) | NULLS | |||
| ERPBILLTO | varchar(12) | NULLS | SALESORDER_BILLTOID (IE) | (One) to (Many) | ERPBILLTO.ERPBILLTOID |
| ERPACCOUNTINGENTITYID | varchar(22) | NULLS | |||
| ERPLOGICALID | varchar(255) | NULLS | |||
| ERPDROPSHIP | varchar(1) | NULLS | |||
| ERPSHIPEARLY | varchar(1) | NULLS | |||
| ERPINVOICEIMMEDIATELY | varchar(1) | NULLS | |||
| ERPPARTIALSHIPALLOWED | varchar(1) | NULLS | |||
| ERPCARRIERPARTY | varchar(64) | NULLS | |||
| ERPUNIQUEID | varchar(377) | NULLS | SALESORDER_ERPUNIQUEID (IE) | ||
| ERPPAYFROMID (FK) | varchar(12) | NULLS | SALESORDER_ERPPAYFROMID (IE) | (One) to (Many) | ERPPAYFROM.ERPPAYFROMID |
| ERPPAYMENTTERMID | varchar(64) | NULLS | |||
| ERPPRICINGREQUIRED | varchar(1) | NULLS | |||
| ERPSHIPTOID | varchar(12) | NULLS | SALESORDER_SHIPTOID (IE) | (One) to (Many) | ERPSHIPTO.ERPSHIPTOID |
| ERPSTATUSUPDATE | datetime | NULLS | |||
| ERPTAXEXEMPT | varchar(1) | NULLS | |||
| ERPFOB | varchar(1024) | NULLS | |||
| ERPSALESPERSONROLE | varchar(255) | NULLS | |||
| ERPSTARTDATE | datetime | NULLS | |||
| ERPENDDATE | datetime | NULLS | |||
| ERPPAYFROMADDRESSID | varchar(12) | NULLS | (Many) to (One) | SALESORDERADDRESS.SALESORDERADDRESSID | |
| CUSTOMERRFQNUMBER | varchar(100) | NULLS | |||
| ERPVARIATIONID | varchar(22) | NULLS | |||
| ERPREVISIONID | varchar(22) | NULLS | |||
| ERPLOCATION | varchar(22) | NULLS | |||
| ERPPAYMENTMETHOD | varchar(64) | NULLS | |||
| ERPINCOTERM | varchar(64) | NULLS | |||
| ERPLASTMODIFIEDDATE | datetime | NULLS | |||
| ERPDOCUMENTDATE | datetime | NULLS | |||
| BASECURRENCYCODE | varchar(64) | NULLS | |||
| WAREHOUSELOCATIONID | varchar(12) | NULLS | (Many) to (One) | SLXLOCATION.SLXLOCATIONID | |
| CARRIERID | varchar(12) | NULLS | (One) to (Many) | CARRIER.CARRIERID | |
| DOCORDERTOTAL | float | NULLS | |||
| EXTENDEDPRETAXAMOUNT | float | NULLS | |||
| DOCGRANDTOTAL | float | NULLS | |||
| DOCEXTENDEDPRETAXAMOUNT | float | NULLS | |||
| LOCATIONID | varchar(12) | NULLS | (Many) to (One) | SLXLOCATION.SLXLOCATIONID | |
| SYNCSTATUS | varchar(64) | NULLS | |||
|
ERPNOTES |
text |
NULLS |
|||
|
ISNORMALIZED |
nchar(12) |
NULLS |