Skip to main content

Items & Products - Key Tables

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

ITEM (125 columns)

# Column Type Length Nullable Default
1 Iid int NO
2 Istatus int YES
3 Igeneric int YES
4 Inote nvarchar -1 YES
5 idesc nvarchar 4000 YES
6 idesc2 nvarchar 4000 YES
7 idesc3 nvarchar 4000 YES
8 Iqtyinstock float YES
9 Iqtyonorder float YES
10 Igoodsinunit nvarchar 4000 YES
11 Igoodsoutunit nvarchar 4000 YES
12 Iinoutconversion int YES
13 Iqtyissuedthisyear float YES
14 Ibaseprice float YES
15 Icreatedby int YES
16 Isupplier int YES
17 Itypenum int YES
18 Iminstockqty float YES
19 Isecondprice float YES
20 Ipromptforprice bit NO ((0))
21 Isleeveprice float YES
22 Itaxcode int YES ((0))
23 ICostPrice float YES
24 Iaccountsid nvarchar 4000 YES
25 Imargin float YES ((0))
26 Ireorderqty float YES
27 IBinLocation nvarchar 4000 YES
28 IInternalReference nvarchar 4000 YES
29 IExternalReference nvarchar 4000 YES
30 INominalCode nvarchar 4000 YES
31 ICostingMethod int YES ((0))
32 Iservicefee float YES ((0))
33 Irecovery float YES ((0))
34 IAVCO float YES ((0))
35 IQtyOnAllSalesOrders float YES
36 IDoesNotNeedConsigning bit NO ((0))
37 Ichangeseq int YES ((1))
38 ITaxCodeOther int YES ((0))
39 IPhoto varbinary -1 YES
40 ISHAccountsID nvarchar 500 YES ('')
41 iApplyDiscount bit YES ((0))
42 isecondhandprice float YES ((0.00))
43 ihours float YES ((0.00))
44 IMarkUpPerc float YES ((0.00))
45 IMeterType int YES ((0))
46 IMeterLife int YES ((0))
47 IIsRecurringItem bit YES ((0))
48 IConsignRequestTemplate int YES ((0))
49 IRecurringPrice float YES ((0.00))
50 IShowMobileScanner bit YES ((1))
51 iphotobase64 nvarchar -1 YES
52 ithirdpartyid nvarchar 200 YES ('')
53 IPurchaseNominalCode nvarchar 500 YES
54 idesc4 nvarchar 4000 YES ('')
55 ISalesTaxIncluded bit YES ((0))
56 IPurchaseTaxIncluded bit YES ((0))
57 ITaxable bit YES ((0))
58 IAssetAccountCode int YES ((0))
59 IQBOQuantity float YES
60 IQBOInitialQuantityDate datetime YES ((0))
61 IXeroTenantId nvarchar 100 YES ('')
62 IIncomeAccountName nvarchar 250 YES ('')
63 IExpenseAccountName nvarchar 250 YES ('')
64 IAssetAccountName nvarchar 250 YES ('')
65 IQBOSKU nvarchar 100 YES ('')
66 IQBOCategoryId nvarchar 10 YES ('')
67 IQBOCategoryName nvarchar 100 YES ('')
68 IAutotaskServiceId int YES ((-1))
69 IAutotaskProductId int YES ((-1))
70 icontractitem bit YES ((0))
71 idontinvoice bit YES ((0))
72 IKashflowId int YES ((0))
73 IKashflowTenantId int YES ((0))
74 ILinkedItemId int YES ((0))
75 ISnelStartId nvarchar 100 YES ('')
76 ISnelStartDepartmentId nvarchar 100 YES ('')
77 ISnelStartDepartmentName nvarchar 100 YES ('')
78 imaxitemdiscount float YES ((100))
79 idefaultbillingperiod int YES ((3))
80 IPrimaryImageId int YES ((0))
81 idatecreated datetime YES ((0))
82 ilastmodified datetime YES ((0))
83 IQBOCompanyId nvarchar 100 YES
84 IExtraInvoiceDescription nvarchar 4000 YES
85 iintaccttype nvarchar 200 YES
86 irecurringcost float YES ((0))
87 IType int YES ((0))
88 IDBCCompanyId nvarchar 100 YES ('')
89 isagebusinessclouddetailsid int YES
90 ibudgettypeid int YES
91 iserialiseonlyone bit YES
92 iexactdivision int YES
93 iuserdesc nvarchar 4000 YES
94 idattocommercetenant int YES
95 iweight float YES
96 iignorefromaccountingsync bit YES
97 iinvoiceclass nvarchar 250 YES
98 isage50ukdepartmentid int YES ((0))
99 idonttrackstock bit YES ((0))
100 ixeroinventoryaccountcode nvarchar 100 YES
101 ixerocogsaccountcode nvarchar 100 YES
102 iintacctproductlineid nvarchar 500 YES
103 imyobrowversion nvarchar 500 YES
104 imyobassetaccountcode nvarchar 4000 YES
105 iitemspersellingprice float YES
106 iitemsperbuyingprice float YES
107 iminpurchaseqty float YES
108 iavalaraitemcode nvarchar 500 YES
109 ipurchasecurrencycode int YES
110 idontreceiveonpo bit YES ((0))
111 iautorenewquotelinedefault bit YES ((0))
112 ipricecalculatedfromcomponents bit YES ((0))
113 icostcalculatedfromcomponents bit YES ((0))
114 iautoreordertype int YES ((0))
115 irelatedcategories_list nvarchar 4000 YES
116 iitemlistedonlyonbundlesetup bit YES
117 imanufacturer int YES ((0))
118 IUseTieredPricing bit YES
119 itieredpricingmethod int YES ((0))
120 idefaultsupplierpartcode nvarchar 200 YES
121 idbctemplate nvarchar 1000 YES
122 iismeteritem bit YES
123 iprojectbilltype int YES ((0))
124 iquantitydecimalplaces int YES ((0))
125 iintacctsaveloc nvarchar 1000 YES

ItemStock (13 columns)

# Column Type Length Nullable Default
1 ISid int NO
2 ISiid int NO
3 ISlocation int NO
4 ISdate datetime NO
5 ISquantityIn float YES
6 ISquantityRemaining float YES
7 IScost float YES
8 ISsupplierid int YES
9 ISshid int YES
10 ISohid int YES
11 ISfaultid int YES ((0))
12 isstbid int YES
13 issdid int YES
Back to top