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 QUOTEADDRESS.QUOTEADDRESSID information, see the Index Changes.pdf document.
Added in Version 8.3
The QUOTE table stores information about quotes.
|
|
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 QUOTEADDRESS.QUOTEADDRESSID information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
QUOTEID (PK) |
nchar(12) |
NOT NULL |
QUOTE_PRIMARY (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime(8) |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
SECCODEID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
||
|
ACCOUNTID (FK) |
nchar(12) |
NULLS |
QUOTE_ACCOUNTID (IE) |
(One) to (Many) |
|
|
ACCOUNTMANAGERID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
||
|
BILLINGCONTACTID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
||
|
BILLINGADDRESSID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
||
|
BILLTONAME |
varchar(64) |
NULLS |
|
||
|
SHIPPINGCONTACTID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
||
|
SHIPPINGADDRESSID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
||
|
SHIPTONAME |
varchar(64) |
NULLS |
|
||
|
SHIPTOID |
nchar(12) |
NULLS |
QUOTE.SHIPTOID (IE) |
(One) to (Many) |
|
|
OPPORTUNITYID (FK) |
nchar(12) |
NULLS |
QUOTE_OPPORTUNITYID (IE) |
(One) to (Many) |
|
|
USERID (FK) |
nchar(12) |
NULLS |
|
||
|
STATUS |
varchar(64) |
NULLS |
|
||
|
STATUSDATE |
datetime(8) |
NULLS |
|
|
|
|
TYPE |
varchar(64) |
NULLS |
|
||
|
BASECURRENCYCODE |
varchar(64) |
NULLS |
|
||
|
CURRENCYCODE |
varchar(64) |
NULLS |
|
||
|
EXCHANGERATE |
float(8) |
NULLS |
|
||
|
EXCHANGERATEDATE |
datetime(8) |
NULLS |
|
||
|
EXCHANGERATELOCKED |
nchar(1) |
NULLS |
|
||
|
DISCOUNT |
float |
NULLS |
|
||
|
TRADEDISCOUNT |
float |
NULLS |
|
||
|
DISCOUNTTOTAL |
float |
NULLS |
|
|
|
|
TAX |
float |
NULLS |
|
||
|
TAXEXEMPT |
varchar(64) |
NULLS |
|
||
|
TAXTOTAL |
float |
NULLS |
|
||
|
TOTAL |
float |
NULLS |
|
||
|
GRANDTOTAL |
float |
NULLS |
|
||
|
ALTERNATEKEYPREFIX |
varchar(64) |
NULLS |
|
||
|
ALTERNATEKEYSUFFIX |
varchar(64) |
NULLS |
|
||
|
CREATESOURCE |
varchar(64) |
NULLS |
|
||
|
CUSTOMERRFQNUMBER |
varchar(64) |
NULLS |
|
||
|
STARTDATE |
datetime |
NULLS |
|
||
|
ENDDATE |
datetime |
NULLS |
|
||
|
LASTMODIFIEDDATE |
datetime |
NULLS |
|
||
|
TRANSMITDATE |
datetime |
NULLS |
|
||
|
DOCUMENTID (FK) |
nchar(12) |
NULLS |
|
|
|
|
TERMSID |
nchar(12) |
NULLS |
|
||
|
COMMENTS |
text |
NULLS |
|
|
|
|
PRICELISTID (FK) |
nchar(12) |
NULLS |
|
(One) to (Many) |
|
|
SALESCOMMISSION |
float |
NULLS |
|
|
|
|
SHIPVIA |
varchar(64) |
NULLS |
|
||
|
REQUESTEDBYID (FK) |
nchar(12) |
NULLS |
|
(One) to (Many) |
|
|
BILLTOID (FK) |
nchar(12) |
NULLS |
QUOTE_BILLTOID (IE) |
(One) to (Many) |
|
|
DOCUMENTDATE |
datetime |
NULLS |
|
||
|
DROPSHIP |
nchar(1) |
NULLS |
|
|
|
|
ERPEXTID |
varchar(100) |
NULLS |
QUOTE_ERPEXTID (IE) |
|
|
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|
|
|
|
ERPLOGICALID |
varchar(255) |
NULLS |
|
|
|
|
ERPSTATUS |
varchar(64) |
NULLS |
|
|
|
|
ERPUNIQUEID |
varchar(377) |
NULLS |
QUOTE_ERPUNIQUEID (IE) |
||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|||
|
EXPECTEDDELIVERYDATE |
datetime(8) |
NULLS |
|
||
|
INCOTERM |
varchar(64) |
NULLS |
|||
|
PARTIALSHIP |
nchar(1) |
NULLS |
|||
|
PAYFROMADDRESSID |
nchar(12) |
NULLS |
(Many) to (One) | ||
|
PAYFROMID (FK) |
nchar(12) |
NULLS |
QUOTE.ERPPAYFROMID (IE) (IE) |
(One) to (Many) | |
|
SHIPEARLY |
nchar(1) |
NULLS |
|||
|
WAREHOUSEID |
nchar(12) |
NULLS |
(Many) to (One) | ||
|
PAYMENTTERM |
varchar(64) |
NULLS |
|||
| PERSONROLE |
varchar(255) |
NULLS |
|||
|
FREIGHT |
float |
NULLS |
|
|
|
|
SALESORDERID (FK) |
nchar(12) |
NULLS |
|
(Many) to (One) |
|
|
OPPORTUNITYSYNCENABLED |
nchar(1) |
NULLS |
|
|
|
|
CARRIERID |
nchar(12) |
NULLS |
(One) to (Many) | ||
| DOCTOTAL |
float |
NULLS |
|||
| DOCGRANDTOTAL |
float |
NULLS |
|||
| DOCEXTENDEDPRETAXAMOUNT |
float |
NULLS |
|||
| EXTENDEDPRETAXAMOUNT |
float |
NULLS |
|||
| ERPLOCATION |
varchar(22) |
NULLS |
|||
| LOCATIONID |
nchar(12) |
NULLS |
(Many) to (One) | ||
| SYNCSTATUS |
varchar(64) |
NULLS |
|||
|
ERPNOTES |
text |
NULLS |
|||
|
ISNORMALIZED |
nchar(1) |
NULLS |