Skip to main content

Quotes & Opportunities - Key Tables

Full column listings for the 2 key tables in this category.

QUOTATIONDETAIL (62 columns)

# Column Type Length Nullable Default
1 QDid int NO
2 QDProductCode nvarchar 4000 YES
3 QDDesc nvarchar 4000 YES
4 QDPrice float YES ((0))
5 QDCostPrice float YES ((0))
6 QDQuantity float YES
7 QDTax float YES ((0))
8 QDQHid int YES ((0))
9 QDItemid int YES ((0))
10 QDNote ntext 1073741823 YES
11 QDservicefee float YES ((0))
12 QDRecovery float YES ((0))
13 QDMargin float YES ((0))
14 QDBillingPeriod int YES ((0))
15 QDStartDate datetime YES
16 QDAutoRenew bit NO ((0))
17 QDGroupID int YES ((0))
18 QDPrintItem bit NO ((-1))
19 QDIsGroupDesc bit NO ((0))
20 QDDiscount float YES ((0))
21 QDsupplier int YES ((0))
22 qdOptional bit YES ((0))
23 qdCostCentre int YES ((0))
24 QDStockLocation int YES ((0))
25 QDsortseq int YES ((0))
26 QDapprovalStatus int YES ((0))
27 QDItemUrl nvarchar 4000 YES ('')
28 qdtaxcodeoverride int YES ((-1))
29 qdsiteid int YES ((-1))
30 qdperiods int YES ((0))
31 qdhideitems bit YES ((0))
32 qdcurrentquantity float YES
33 qdcurrentprice float YES
34 qdisleased bit YES
35 qdstbid int YES
36 QDQuoterId nvarchar 100 YES
37 qdisbundledline bit YES ((0))
38 qdhidegroupeditemsprice bit YES
39 qdbasepriceconverted float YES
40 qdoneoptionalmandatory_list nvarchar 500 YES
41 qdnominalcode nvarchar 500 YES
42 qdforcequantityrelationship bit YES ((0))
43 qdforcepricerelationship bit YES ((0))
44 qdforcetermrelationship bit YES ((0))
45 qdpricecalculationformula nvarchar 500 YES
46 qdfromgroupid int YES ((0))
47 qdpurchasecurrencycode int YES
48 qdpurchaseconversionrate float YES
49 qdcostconverted float YES
50 qdexcludefromautoincrease bit YES
51 qdautoincreaseperiod int YES
52 qdpercentincrease float YES
53 qduserpiincrease bit YES
54 qdconsignmentaddress1 nvarchar 200 YES
55 qdconsignmentaddress2 nvarchar 200 YES
56 qdconsignmentaddress3 nvarchar 200 YES
57 qdconsignmentaddress4 nvarchar 200 YES
58 qdconsignmentaddress5 nvarchar 200 YES
59 qddelivertous int YES
60 qdtax_rate float YES
61 qdorderclientoverride int YES
62 qdprojectbilltype int YES ((0))

QUOTATIONHEADER (93 columns)

# Column Type Length Nullable Default
1 QHid int NO
2 QHfaultID int YES ((0))
3 QHstatus int YES ((0))
4 QHPORef nvarchar 4000 YES
5 QHDate datetime YES
6 QHExpiryDate datetime YES
7 QHCarriageDesc nvarchar 4000 YES
8 QHCarriagePrice float YES ((0))
9 QHAuthBy nvarchar 4000 YES
10 QHNote ntext 1073741823 YES
11 QHUserID int YES ((0))
12 QHScope ntext 1073741823 YES
13 QHRisk ntext 1073741823 YES
14 QHQR2Filename nvarchar 4000 YES
15 QHUnum int YES ((0))
16 QHIncludeGroupedItemPrice bit YES ((0))
17 QHIncludeGroupedItemQty bit YES ((0))
18 QHtitle nvarchar 4000 YES ('')
19 QHDaysToDeliver int YES ((0))
20 QHCurrency nvarchar 10 YES ('£')
21 QHIncludeQuotationLineNotes bit YES ((0))
22 QHIncludeGroupPriceAndQty bit YES ((0))
23 QHApprovalState int NO ((0))
24 QHApprovalDateTime datetime YES ((0))
25 QHApprovalNote nvarchar 1000 YES ('')
26 QHApprovalPONumber nvarchar 500 YES ('')
27 QHPdfTemplateId int YES ((0))
28 QHGUID uniqueidentifier YES (newid())
29 QHSignatureAttachmentId int YES ((0))
30 QHCreatedBy int YES ((-1))
31 QHapprovername nvarchar 100 YES ('')
32 QHapproveremail nvarchar 100 YES ('')
33 qhquoteviewed bit YES ((0))
34 qhcannedtextid int YES ((0))
35 qhlastupdatetime datetime YES ((0))
36 qhinternalapprovalstatus int YES ((0))
37 qhinternalapprovalagent int YES ((0))
38 qhinternalapprovalemailaddr nvarchar 1000 YES ('')
39 qhinternalapprovalemailreply nvarchar 1000 YES ('')
40 qhinternaltechrequestedapproval int YES ((0))
41 qhinternalapprovalrequestdate datetime YES ((0))
42 QHcurrencycode int YES ((0))
43 QHcurrencyConversionRate float YES ((1))
44 qhdattocommerceid int YES ((-1))
45 qhdattocommerceurl nvarchar 250 YES
46 qhlinkedpdfid int YES
47 qhcontactuser int YES
48 QHThirdPartyNumber nvarchar 100 YES
49 QHThirdPartyURL nvarchar 1000 YES
50 qhassignedunum int YES
51 qhtaxtotalestimate float YES
52 qhintacctclass nvarchar 500 YES
53 qhintacctclassname nvarchar 500 YES
54 qhintacctsaveloc nvarchar 500 YES
55 qhbillingcontactname nvarchar 250 YES
56 qhbillingcontactemailaddress nvarchar 250 YES
57 qhbillingcontactphonenumber nvarchar 50 YES
58 qhisleased bit YES
59 qhtermlimit float YES
60 qhmargin decimal YES
61 qhdattocommercetenantid int YES
62 qhuseticketapproval bit YES
63 qhaddress1 nvarchar 255 YES
64 qhaddress2 nvarchar 255 YES
65 qhaddress3 nvarchar 255 YES
66 qhaddress4 nvarchar 255 YES
67 qhaddress5 nvarchar 255 YES
68 qhdeladdress1 nvarchar 255 YES
69 qhdeladdress2 nvarchar 255 YES
70 qhdeladdress3 nvarchar 255 YES
71 qhdeladdress4 nvarchar 255 YES
72 qhdeladdress5 nvarchar 255 YES
73 qhsitedeliveryoverride int YES ((0))
74 qhavalaradetailsid int YES
75 qhadobeacrobatdetailsid int YES
76 qhoriginaddress1 nvarchar 4000 YES
77 qhoriginaddress2 nvarchar 4000 YES
78 qhoriginaddress3 nvarchar 4000 YES
79 qhoriginaddress4 nvarchar 4000 YES
80 qhoriginaddress5 nvarchar 4000 YES
81 CFQuoteSoW image 2147483647 YES
82 CFQuoteSoWHTML nvarchar -1 YES
83 CFQuoteSoWPLAIN nvarchar -1 YES
84 CFEmailFirstName nvarchar 255 YES
85 CFEmailLastName nvarchar 255 YES
86 CFEmailJobTitle nvarchar 255 YES
87 qhoriginalrevisedfromid int YES
88 qhvorbossorderids nvarchar 1000 YES
89 qhcountersiguseagentsig bit YES
90 qhcountersigattachmentid int YES
91 qhcountersigdatetime datetime YES ((0))
92 qhchangeseq int YES ((1))
93 qhlastchangeagent int YES
Back to top