Skip to main content

Supplier Orders & Purchasing - Key Tables

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

ORDERHEAD (59 columns)

# Column Type Length Nullable Default
1 OHid int NO
2 OHsitenum int YES
3 OHstatus int YES
4 OHnote ntext 1073741823 YES
5 OHusername nvarchar 4000 YES
6 OHponumber nvarchar 4000 YES
7 OHorderdate datetime YES
8 OHshipdate datetime YES
9 OHtechie int YES
10 OHdeliverby int YES
11 OHsummary nvarchar 4000 YES
12 OHdatereceived datetime YES
13 OHnumberbottles int YES ((0))
14 OHfaultid int YES ((0))
15 OHShipStatus nvarchar 4000 YES
16 OHSoldBy int YES ((0))
17 OHAccountsRef nvarchar 4000 YES
18 OHUserStatus int YES ((0))
19 OHLeadSource int YES ((0))
20 OHCanvasser int YES ((0))
21 OHInvoiceDate datetime YES
22 OHInvoiceNumber nvarchar 4000 YES
23 OHIncludeGroupedItemPrice bit YES ((0))
24 OHIncludeGroupedItemQty bit YES ((0))
25 OHCurrency nvarchar 10 YES ('£')
26 OHQHID int YES ((0))
27 OHCHid int YES ((0))
28 OHDoNotInvoice bit YES ((0))
29 OHCloseAndConsignWhenPOProcessed bit YES ((0))
30 OHPdfTemplateId int YES ((0))
31 OHtitle nvarchar 500 YES ('')
32 OHCreatedBy int YES ((-1))
33 ohlastupdatetime datetime YES ((0))
34 ohprojectfaultid int YES ((0))
35 ohparentprojecttemplateid int YES ((0))
36 OHcurrencycode int YES ((0))
37 OHcurrencyConversionRate float YES ((1))
38 ohuserid int YES
39 ohincludegrouppriceandqty bit YES ((0))
40 ohassignedunum int YES
41 ohcostperweight float YES
42 ohintacctclass nvarchar 500 YES
43 ohintacctclassname nvarchar 500 YES
44 ohintacctsaveloc nvarchar 500 YES
45 ohoverridedeliveryaddress bit YES
46 ohdeladdress1 nvarchar 1000 YES
47 ohdeladdress2 nvarchar 1000 YES
48 ohdeladdress3 nvarchar 1000 YES
49 ohdeladdress4 nvarchar 1000 YES
50 ohdeladdress5 nvarchar 1000 YES
51 ohavalaradetailsid int YES
52 ohoriginaddress1 nvarchar 4000 YES
53 ohoriginaddress2 nvarchar 4000 YES
54 ohoriginaddress3 nvarchar 4000 YES
55 ohoriginaddress4 nvarchar 4000 YES
56 ohoriginaddress5 nvarchar 4000 YES
57 ohchangeseq int YES ((1))
58 ohlastchangeagent int YES
59 ohorderticketid int YES

ORDERLINE (64 columns)

# Column Type Length Nullable Default
1 OLid int NO
2 OLseq int NO
3 OLitem int YES
4 OLorderqty float YES
5 OLshippedqty float YES
6 OLunit int YES
7 OLNote nvarchar -1 YES
8 OLCostPrice decimal YES
9 OLSellingPrice decimal YES
10 olitemlocation int YES ((0))
11 OLselected bit NO ((0))
12 OLservicefee float YES ((0))
13 OLRecovery float YES ((0))
14 OLMargin float YES ((0))
15 olPOqty float YES
16 OLDesc nvarchar 4000 YES
17 OLBillingPeriod int YES ((0))
18 OLStartDate datetime YES
19 OLAutoRenew bit NO ((0))
20 OLSupplierPO nvarchar 4000 YES
21 OLsupplier int YES ((0))
22 OLQuoteLineID int YES ((0))
23 OLSupplierPartCode nvarchar 4000 YES
24 OLGroupID int YES ((0))
25 OLIsGroupDesc bit YES ((0))
26 OLNominalCode nvarchar 4000 YES ('')
27 olCostCentre int YES ((0))
28 OLProjectFaultid int NO ((0))
29 OLDoNotInvoice bit YES ((0))
30 OLsortseq int YES ((0))
31 OLtax float YES ((0.00))
32 olcontractid int YES ((0))
33 olrecurringinvoiceid int YES ((0))
34 olreservedqty float YES ((0.00))
35 OLlineinvoiceid int YES ((0))
36 OLItemUrl nvarchar 4000 YES ('')
37 oltaxcodeoverride int YES ((-1))
38 olsiteid int YES ((-1))
39 olperiods int YES ((0))
40 olhideitems bit YES ((0))
41 olisleased bit YES
42 olstbid int YES
43 olisfreightline bit YES
44 olprojectchildfaultid int YES
45 olisbundledline bit YES ((0))
46 olfaultid int YES ((0))
47 ollinerecurring bit YES
48 oldattocommercelineid int YES
49 olIsDeferredRevenue bit YES
50 olhidegroupeditemsprice bit YES
51 olbasepriceconverted decimal YES
52 oldiscount float YES
53 id bigint NO
54 olbaseprice decimal YES
55 olmarkascomplete bit YES
56 olconsignmentaddress1 nvarchar 200 YES
57 olconsignmentaddress2 nvarchar 200 YES
58 olconsignmentaddress3 nvarchar 200 YES
59 olconsignmentaddress4 nvarchar 200 YES
60 olconsignmentaddress5 nvarchar 200 YES
61 oaddedbudget bit YES
62 oladdedtoproject bit YES
63 oldelivertous int YES
64 olprojectbilltype int YES ((0))

SUPPLIERORDERDETAIL (36 columns)

# Column Type Length Nullable Default
1 SDid int NO
2 SDProductCode nvarchar 4000 YES
3 SDDesc nvarchar 4000 YES
4 SDPrice float YES ((0))
5 SDTax float YES ((0))
6 SDSHid int YES ((0))
7 SDItemid int YES ((0))
8 SDquantity float YES
9 SDQtyReceived float YES
10 SDTaxCode int YES ((0))
11 SDOLID int YES ((0))
12 SDOLSeq int YES ((0))
13 SDNote ntext 1073741823 YES
14 SDGroupID int YES ((0))
15 SDIsGroupDesc bit YES ((0))
16 SDsortseq int YES ((0))
17 SDXeroLineId nvarchar 100 YES ('')
18 SDItemCode nvarchar 100 YES ('')
19 SDAccountsCode nvarchar 100 YES
20 sdsiteid int YES ((-1))
21 SDQBOLineId nvarchar 100 YES
22 sdhideitems bit YES ((0))
23 sdlineinvoiceid int YES
24 sdsyncedtointacct bit YES
25 sdintacctwarehouseid nvarchar 500 YES
26 sdintacctlocationid nvarchar 500 YES
27 sdintacctdepid nvarchar 1000 YES
28 sdmyobrowversion nvarchar 500 YES
29 sdmyoblocation nvarchar 500 YES
30 sdmyobrowid int YES
31 sdbasepriceconverted float YES
32 sdtaxcodeoverride int YES
33 sddatereceived datetime YES ((0))
34 sdtrackingnumber nvarchar 200 YES
35 sdcarriername nvarchar 200 YES
36 sdtrackingurl nvarchar 400 YES

SUPPLIERORDERHEADER (71 columns)

# Column Type Length Nullable Default
1 SHid int NO
2 SHSupplierID int YES ((0))
3 SHfaultID int YES ((0))
4 SHPORef nvarchar 4000 YES
5 SHPODate datetime YES
6 SHCarriageDesc nvarchar 4000 YES
7 SHCarriagePrice float YES ((0))
8 SHAuthBy nvarchar 4000 YES
9 SHNote ntext 1073741823 YES
10 SHStatus int YES ((0))
11 SHGoodsInStatus int YES ((0))
12 SH3rdPartyPONumber nvarchar 4000 YES
13 SHDatePOPublished datetime YES
14 SHApprovalStatus int YES ((0))
15 SHApprovalemailaddr nvarchar 4000 YES
16 SHApprovalEmailReply ntext 1073741823 YES
17 SHUserDefStatus int YES ((0))
18 SHAccountsRef nvarchar 4000 YES
19 SHDeliverToUs bit YES ((0))
20 SHEstDelDate datetime YES
21 SHOHID int YES ((0))
22 SHCurrency nvarchar 10 YES ('£')
23 SHSite int YES ((0))
24 SHUsername nvarchar 400 YES ('')
25 SHCostCentre int NO ((-1))
26 SHTechRequestedApproval int YES ((0))
27 SHApprovalRequestDate datetime YES ((0))
28 SHPdfTemplateId int YES ((0))
29 SHtitle nvarchar 500 YES ('')
30 SHCreatedBy int YES ((-1))
31 SHdatesent datetime YES ((0))
32 SHXeroId nvarchar 100 YES ('')
33 SHXeroTenantId nvarchar 100 YES ('')
34 SHXeroStatus nvarchar 10 YES ('')
35 SHLastSynced datetime YES ((0))
36 shlastupdatetime datetime YES ((0))
37 SHapprovalAgent int YES ((0))
38 shuserid int YES
39 SHQBOCompanyId nvarchar 100 YES
40 SHQBOId int YES ((0))
41 SHWarrantyURL nvarchar 2000 YES
42 shassignedunum int YES
43 shintacctsaveloc nvarchar 1000 YES
44 shcurrencycode int YES
45 shduedate datetime YES ((0))
46 shcurrencyconversionrate float YES
47 shintacctclass nvarchar 500 YES
48 shintacctclassname nvarchar 500 YES
49 SHSuppliersOrderReference nvarchar 200 YES ('')
50 shdeladdress1 nvarchar 1000 YES
51 shdeladdress2 nvarchar 1000 YES
52 shdeladdress3 nvarchar 1000 YES
53 shdeladdress4 nvarchar 1000 YES
54 shdeladdress5 nvarchar 1000 YES
55 shmyobrowversion nvarchar 500 YES
56 shthirdpartyid nvarchar 500 YES
57 shavalaradetailsid int YES
58 shoriginaddress1 nvarchar 4000 YES
59 shoriginaddress2 nvarchar 4000 YES
60 shoriginaddress3 nvarchar 4000 YES
61 shoriginaddress4 nvarchar 4000 YES
62 shoriginaddress5 nvarchar 4000 YES
63 shuseticketapproval bit YES
64 shreceiptconfirmed bit YES
65 shreceiptconfirmationdate datetime YES ((0))
66 shchangeseq int YES ((1))
67 shlastchangeagent int YES
68 shdbccompanyid nvarchar 1000 YES
69 shincludegroupeditemprice bit YES ((1))
70 shincludegroupeditemqty bit YES ((1))
71 shincludegrouppriceandqty bit YES
Back to top