	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

249 COLUMNS | 7 INDEXES | B1 8.8 | OITM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Inventory and Production
1	Business One	8.8	OITM	249	7	Items	Inventory and Production

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT ItemCode, ItemName, FrgnName, ItmsGrpCod, CstGrpCode, VatGourpSa, CodeBars, VATLiable, PrchseItem, SellItem, InvntItem, OnHand, IsCommited, OnOrder, IncomeAcct, ExmptIncom, MaxLevel, DfltWH, CardCode, SuppCatNum, BuyUnitMsr, NumInBuy, ReorderQty, MinLevel, LstEvlPric, LstEvlDate, CustomPer, Canceled, MnufctTime, WholSlsTax, RetilrTax, SpcialDisc, DscountCod, TrackSales, SalUnitMsr, NumInSale, Consig, QueryGroup, Counted, OpenBlnc, EvalSystem, UserSign, FREE, PicturName, Transfered, BlncTrnsfr, UserText, SerialNum, CommisPcnt, CommisSum, CommisGrp, TreeType, TreeQty, LastPurPrc, LastPurCur, LastPurDat, ExitCur, ExitPrice, ExitWH, AssetItem, WasCounted, ManSerNum, SHeight1, SHght1Unit, SHeight2, SHght2Unit, SWidth1, SWdth1Unit, SWidth2, SWdth2Unit, SLength1, SLen1Unit, Slength2, SLen2Unit, SVolume, SVolUnit, SWeight1, SWght1Unit, SWeight2, SWght2Unit, BHeight1, BHght1Unit, BHeight2, BHght2Unit, BWidth1, BWdth1Unit, BWidth2, BWdth2Unit, BLength1, BLen1Unit, Blength2, BLen2Unit, BVolume, BVolUnit, BWeight1, BWght1Unit, BWeight2, BWght2Unit, FixCurrCms, FirmCode, LstSalDate, QryGroup1, QryGroup2, QryGroup3, QryGroup4, QryGroup5, QryGroup6, QryGroup7, QryGroup8, QryGroup9, QryGroup10, QryGroup11, QryGroup12, QryGroup13, QryGroup14, QryGroup15, QryGroup16, QryGroup17, QryGroup18, QryGroup19, QryGroup20, QryGroup21, QryGroup22, QryGroup23, QryGroup24, QryGroup25, QryGroup26, QryGroup27, QryGroup28, QryGroup29, QryGroup30, QryGroup31, QryGroup32, QryGroup33, QryGroup34, QryGroup35, QryGroup36, QryGroup37, QryGroup38, QryGroup39, QryGroup40, QryGroup41, QryGroup42, QryGroup43, QryGroup44, QryGroup45, QryGroup46, QryGroup47, QryGroup48, QryGroup49, QryGroup50, QryGroup51, QryGroup52, QryGroup53, QryGroup54, QryGroup55, QryGroup56, QryGroup57, QryGroup58, QryGroup59, QryGroup60, QryGroup61, QryGroup62, QryGroup63, QryGroup64, CreateDate, UpdateDate, ExportCode, SalFactor1, SalFactor2, SalFactor3, SalFactor4, PurFactor1, PurFactor2, PurFactor3, PurFactor4, SalFormula, PurFormula, VatGroupPu, AvgPrice, PurPackMsr, PurPackUn, SalPackMsr, SalPackUn, SCNCounter, ManBtchNum, ManOutOnly, DataSource, validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo, BlockOut, ValidComm, FrozenComm, LogInstanc, ObjType, SWW, Deleted, DocEntry, ExpensAcct, FrgnInAcct, ShipType, GLMethod, ECInAcct, FrgnExpAcc, ECExpAcc, TaxType, ByWh, WTLiable, ItemType, WarrntTmpl, BaseUnit, CountryOrg, StockValue, Phantom, IssueMthd, FREE1, PricingPrc, MngMethod, ReorderPnt, InvntryUom, PlaningSys, PrcrmntMtd, OrdrIntrvl, OrdrMulti, MinOrdrQty, LeadTime, IndirctTax, TaxCodeAR, TaxCodeAP, OSvcCode, ISvcCode, ServiceGrp, NCMCode, MatType, MatGrp, ProductSrc, ServiceCtg, ItemClass, Excisable, ChapterID, NotifyASN, ProAssNum, AssblValue, DNFEntry, UserSign2 FROM OITM

TOP B1 8.8 | OITM COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	ItemCode	Item No.	nvarchar	20	0				Allow NULL?
2	ItemName	Item Description	nvarchar	100	0				Allow NULL?
3	FrgnName	Description in Foreign Lang.	nvarchar	100	0				Allow NULL?
4	ItmsGrpCod	Item Group	int	6	0	OITB	100		Allow NULL?
5	CstGrpCode	Customs Group	int	6	0	OARG	-1		Allow NULL?
6	VatGourpSa	Sales Tax Definition	nvarchar	8	0	OVTG			Allow NULL?
7	CodeBars	Bar Code	nvarchar	16	0				Allow NULL?
8	VATLiable	Tax Definition	char	1	0		Y	N=No, Y=Yes	Allow NULL?
9	PrchseItem	Purchase Item [Yes/No]	char	1	0		Y	N=No, Y=Yes	Allow NULL?
10	SellItem	Sales Item [Yes/No]	char	1	0		Y	N=No, Y=Yes	Allow NULL?
11	InvntItem	Inventory Item [Yes/No]	char	1	0		Y	N=No, Y=Yes	Allow NULL?
12	OnHand	In Stock	num	19	6				Allow NULL?
13	IsCommited	Qty Ordered by Customers	num	19	6				Allow NULL?
14	OnOrder	Qty Ordered from Vendors	num	19	6				Allow NULL?
15	IncomeAcct	Revenue Account	nvarchar	15	0	OACT			Allow NULL?
16	ExmptIncom	Exempt Revenue Account	nvarchar	15	0	OACT			Allow NULL?
17	MaxLevel	Maximum Inventory Level	num	19	6				Allow NULL?
18	DfltWH	Default Warehouse	nvarchar	8	0				Allow NULL?
19	CardCode	Preferred Vendor	nvarchar	15	0	OCRD			Allow NULL?
20	SuppCatNum	Mfr Catalog No.	nvarchar	17	0				Allow NULL?
21	BuyUnitMsr	Purchasing UoM	nvarchar	20	0				Allow NULL?
22	NumInBuy	No. of Items per Purchase Unit	num	19	6				Allow NULL?
23	ReorderQty	Pref. Qty in Purchase Units	num	19	6				Allow NULL?
24	MinLevel	Minimum Inventory Level	num	19	6				Allow NULL?
25	LstEvlPric	Last Evaluated Price	num	19	6				Allow NULL?
26	LstEvlDate	Date of Last Reval. Price	date	8	0
27	CustomPer	Customs Rate	num	19	6				Allow NULL?
28	Canceled	Canceled Item [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
29	MnufctTime	Production Date in Days	int	11	0				Allow NULL?
30	WholSlsTax	Tax Rate for Wholesaler	char	1	0				Allow NULL?
31	RetilrTax	Sales Tax in %	char	1	0				Allow NULL?
32	SpcialDisc	Special Discount %	num	19	6				Allow NULL?
33	DscountCod	Discount Code	int	6	0				Allow NULL?
34	TrackSales	Follow-Up [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
35	SalUnitMsr	Sales UoM	nvarchar	20	0				Allow NULL?
36	NumInSale	No. of Items per Sales Unit	num	19	6				Allow NULL?
37	Consig	Consignment Goods Whse	num	19	6				Allow NULL?
38	QueryGroup	Properties	int	11	0		0		Allow NULL?
39	Counted	Quantity Counted in Inventory	num	19	6				Allow NULL?
40	OpenBlnc	Initial Stock	num	19	6				Allow NULL?
41	EvalSystem	Valuation Method	char	1	0			A=Moving Average, F=FIFO, S=Standard	Allow NULL?
42	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
43	FREE	Free [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
44	PicturName	Picture	nvarchar	200	0				Allow NULL?
45	Transfered	Year Transfer [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
46	BlncTrnsfr	Balances transferred [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
47	UserText	Item Remarks	text	16	0
48	SerialNum	Serial Number	nvarchar	17	0				Allow NULL?
49	CommisPcnt	% Commission for Item	num	19	6				Allow NULL?
50	CommisSum	Total Commission for Item	num	19	6				Allow NULL?
51	CommisGrp	Commission Group	int	6	0		0		Allow NULL?
52	TreeType	BOM Type	char	1	0		N	A=Assembly, N=Not a BOM, P=Production, S=Sales, T=Template	Allow NULL?
53	TreeQty	No. of Units	num	19	6				Allow NULL?
54	LastPurPrc	Last Purchase Price	num	19	6				Allow NULL?
55	LastPurCur	Last Purchase Currency	nvarchar	3	0				Allow NULL?
56	LastPurDat	Last Purchase Date	date	8	0
57	ExitCur	Issue Currency	nvarchar	3	0				Allow NULL?
58	ExitPrice	Issue Price	num	19	6				Allow NULL?
59	ExitWH	Release Warehouse	nvarchar	8	0				Allow NULL?
60	AssetItem	Fixed Assets	char	1	0		N	N=No, Y=Yes	Allow NULL?
61	WasCounted	Counted	char	1	0		N	N=No, Y=Yes	Allow NULL?
62	ManSerNum	Serial No. Management	char	1	0		N	N=No, Y=Yes	Allow NULL?
63	SHeight1	Height 1 - Sales Unit	num	19	6				Allow NULL?
64	SHght1Unit	Height 1 - UoM for Sales	int	6	0				Allow NULL?
65	SHeight2	Height 2 - Sales Unit	num	19	6				Allow NULL?
66	SHght2Unit	Height 2 - UoM for Sales	int	6	0				Allow NULL?
67	SWidth1	Width 1 - Sales Unit	num	19	6				Allow NULL?
68	SWdth1Unit	Width 1 - UoM for Sales	int	6	0				Allow NULL?
69	SWidth2	Width 2 - Sales Unit	num	19	6				Allow NULL?
70	SWdth2Unit	Width 2 - UoM for Sales	int	6	0				Allow NULL?
71	SLength1	Length 1 - Sales Unit	num	19	6				Allow NULL?
72	SLen1Unit	Length 1 - UoM for Sales	int	6	0				Allow NULL?
73	Slength2	Length 2 - Sales Unit	num	19	6				Allow NULL?
74	SLen2Unit	Length 2 - UoM for Sales	int	6	0				Allow NULL?
75	SVolume	Volume - Sales Unit	num	19	6				Allow NULL?
76	SVolUnit	Volume - UoM for Sales	int	6	0				Allow NULL?
77	SWeight1	Weight 1 - Sales Unit	num	19	6				Allow NULL?
78	SWght1Unit	Weight 1 - UoM for Sales	int	6	0				Allow NULL?
79	SWeight2	Weight 2 - Sales Unit	num	19	6				Allow NULL?
80	SWght2Unit	Weight 2 - UoM for Sales	int	6	0				Allow NULL?
81	BHeight1	Height 1 - Purchasing Unit	num	19	6				Allow NULL?
82	BHght1Unit	Height 1 - UoM for Purchasing	int	6	0				Allow NULL?
83	BHeight2	Height 2 - Purchasing Unit	num	19	6				Allow NULL?
84	BHght2Unit	Height 2 - UoM for Purchasing	int	6	0				Allow NULL?
85	BWidth1	Width 1 - Purchasing Unit	num	19	6				Allow NULL?
86	BWdth1Unit	Width 1 - UoM for Purchasing	int	6	0				Allow NULL?
87	BWidth2	Width 2 - Purchasing Unit	num	19	6				Allow NULL?
88	BWdth2Unit	Width 2 - UoM for Purchasing	int	6	0				Allow NULL?
89	BLength1	Length 1 - Purchase Unit	num	19	6				Allow NULL?
90	BLen1Unit	Length 1 - UoM for Purchasing	int	6	0				Allow NULL?
91	Blength2	Length 2 - Purchase Unit	num	19	6				Allow NULL?
92	BLen2Unit	Length 2 - UoM for Purchasing	int	6	0				Allow NULL?
93	BVolume	Quantity - Purchasing Unit	num	19	6				Allow NULL?
94	BVolUnit	Volume - UoM for Purchasing	int	6	0				Allow NULL?
95	BWeight1	Weight 1 - Purchasing Unit	num	19	6				Allow NULL?
96	BWght1Unit	Weight 1 - UoM for Purchasing	int	6	0				Allow NULL?
97	BWeight2	Weight 2 - Purchasing Unit	num	19	6				Allow NULL?
98	BWght2Unit	Weight 2 - UoM for Purchasing	int	6	0				Allow NULL?
99	FixCurrCms	Currency of Fixed Commission	nvarchar	3	0				Allow NULL?
100	FirmCode	Manufacturer	int	6	0	OMRC	-1		Allow NULL?
101	LstSalDate	Last Sale Date	date	8	0
102	QryGroup1	Property 1	char	1	0		N	N=No, Y=Yes	Allow NULL?
103	QryGroup2	Property 2	char	1	0		N	N=No, Y=Yes	Allow NULL?
104	QryGroup3	Property 3	char	1	0		N	N=No, Y=Yes	Allow NULL?
105	QryGroup4	Property 4	char	1	0		N	N=No, Y=Yes	Allow NULL?
106	QryGroup5	Property 5	char	1	0		N	N=No, Y=Yes	Allow NULL?
107	QryGroup6	Property 6	char	1	0		N	N=No, Y=Yes	Allow NULL?
108	QryGroup7	Property 7	char	1	0		N	N=No, Y=Yes	Allow NULL?
109	QryGroup8	Property 8	char	1	0		N	N=No, Y=Yes	Allow NULL?
110	QryGroup9	Property 9	char	1	0		N	N=No, Y=Yes	Allow NULL?
111	QryGroup10	Property 10	char	1	0		N	N=No, Y=Yes	Allow NULL?
112	QryGroup11	Property 11	char	1	0		N	N=No, Y=Yes	Allow NULL?
113	QryGroup12	Property 12	char	1	0		N	N=No, Y=Yes	Allow NULL?
114	QryGroup13	Property 13	char	1	0		N	N=No, Y=Yes	Allow NULL?
115	QryGroup14	Property 14	char	1	0		N	N=No, Y=Yes	Allow NULL?
116	QryGroup15	Property 15	char	1	0		N	N=No, Y=Yes	Allow NULL?
117	QryGroup16	Property 16	char	1	0		N	N=No, Y=Yes	Allow NULL?
118	QryGroup17	Property 17	char	1	0		N	N=No, Y=Yes	Allow NULL?
119	QryGroup18	Property 18	char	1	0		N	N=No, Y=Yes	Allow NULL?
120	QryGroup19	Property 19	char	1	0		N	N=No, Y=Yes	Allow NULL?
121	QryGroup20	Property 20	char	1	0		N	N=No, Y=Yes	Allow NULL?
122	QryGroup21	Property 21	char	1	0		N	N=No, Y=Yes	Allow NULL?
123	QryGroup22	Property 22	char	1	0		N	N=No, Y=Yes	Allow NULL?
124	QryGroup23	Property 23	char	1	0		N	N=No, Y=Yes	Allow NULL?
125	QryGroup24	Property 24	char	1	0		N	N=No, Y=Yes	Allow NULL?
126	QryGroup25	Property 25	char	1	0		N	N=No, Y=Yes	Allow NULL?
127	QryGroup26	Property 26	char	1	0		N	N=No, Y=Yes	Allow NULL?
128	QryGroup27	Property 27	char	1	0		N	N=No, Y=Yes	Allow NULL?
129	QryGroup28	Property 28	char	1	0		N	N=No, Y=Yes	Allow NULL?
130	QryGroup29	Property 29	char	1	0		N	N=No, Y=Yes	Allow NULL?
131	QryGroup30	Property 30	char	1	0		N	N=No, Y=Yes	Allow NULL?
132	QryGroup31	Property 31	char	1	0		N	N=No, Y=Yes	Allow NULL?
133	QryGroup32	Property 32	char	1	0		N	N=No, Y=Yes	Allow NULL?
134	QryGroup33	Property 33	char	1	0		N	N=No, Y=Yes	Allow NULL?
135	QryGroup34	Property 34	char	1	0		N	N=No, Y=Yes	Allow NULL?
136	QryGroup35	Property 35	char	1	0		N	N=No, Y=Yes	Allow NULL?
137	QryGroup36	Property 36	char	1	0		N	N=No, Y=Yes	Allow NULL?
138	QryGroup37	Property 37	char	1	0		N	N=No, Y=Yes	Allow NULL?
139	QryGroup38	Property 38	char	1	0		N	N=No, Y=Yes	Allow NULL?
140	QryGroup39	Property 39	char	1	0		N	N=No, Y=Yes	Allow NULL?
141	QryGroup40	Property 40	char	1	0		N	N=No, Y=Yes	Allow NULL?
142	QryGroup41	Property 41	char	1	0		N	N=No, Y=Yes	Allow NULL?
143	QryGroup42	Property 42	char	1	0		N	N=No, Y=Yes	Allow NULL?
144	QryGroup43	Property 43	char	1	0		N	N=No, Y=Yes	Allow NULL?
145	QryGroup44	Property 44	char	1	0		N	N=No, Y=Yes	Allow NULL?
146	QryGroup45	Property 45	char	1	0		N	N=No, Y=Yes	Allow NULL?
147	QryGroup46	Property 46	char	1	0		N	N=No, Y=Yes	Allow NULL?
148	QryGroup47	Property 47	char	1	0		N	N=No, Y=Yes	Allow NULL?
149	QryGroup48	Property 48	char	1	0		N	N=No, Y=Yes	Allow NULL?
150	QryGroup49	Property 49	char	1	0		N	N=No, Y=Yes	Allow NULL?
151	QryGroup50	Property 50	char	1	0		N	N=No, Y=Yes	Allow NULL?
152	QryGroup51	Property 51	char	1	0		N	N=No, Y=Yes	Allow NULL?
153	QryGroup52	Property 52	char	1	0		N	N=No, Y=Yes	Allow NULL?
154	QryGroup53	Property 53	char	1	0		N	N=No, Y=Yes	Allow NULL?
155	QryGroup54	Property 54	char	1	0		N	N=No, Y=Yes	Allow NULL?
156	QryGroup55	Property 55	char	1	0		N	N=No, Y=Yes	Allow NULL?
157	QryGroup56	Property 56	char	1	0		N	N=No, Y=Yes	Allow NULL?
158	QryGroup57	Property 57	char	1	0		N	N=No, Y=Yes	Allow NULL?
159	QryGroup58	Property 58	char	1	0		N	N=No, Y=Yes	Allow NULL?
160	QryGroup59	Property 59	char	1	0		N	N=No, Y=Yes	Allow NULL?
161	QryGroup60	Property 60	char	1	0		N	N=No, Y=Yes	Allow NULL?
162	QryGroup61	Property 61	char	1	0		N	N=No, Y=Yes	Allow NULL?
163	QryGroup62	Property 62	char	1	0		N	N=No, Y=Yes	Allow NULL?
164	QryGroup63	Property 63	char	1	0		N	N=No, Y=Yes	Allow NULL?
165	QryGroup64	Property 64	char	1	0		N	N=No, Y=Yes	Allow NULL?
166	CreateDate	Production Date	date	8	0
167	UpdateDate	Date of Update	date	8	0
168	ExportCode	Data Export Code	nvarchar	20	0				Allow NULL?
169	SalFactor1	Sales Factor 1	num	19	6				Allow NULL?
170	SalFactor2	Sales Factor 2	num	19	6				Allow NULL?
171	SalFactor3	Sales Factor 3	num	19	6				Allow NULL?
172	SalFactor4	Sales Factor 4	num	19	6				Allow NULL?
173	PurFactor1	Purchasing Factor 1	num	19	6				Allow NULL?
174	PurFactor2	Purchasing Factor 2	num	19	6				Allow NULL?
175	PurFactor3	Purchasing Factor 3	num	19	6				Allow NULL?
176	PurFactor4	Purchasing Factor 4	num	19	6				Allow NULL?
177	SalFormula	Sales Formula	nvarchar	40	0				Allow NULL?
178	PurFormula	Purchasing Formula	nvarchar	40	0				Allow NULL?
179	VatGroupPu	Purchase Tax Definition	nvarchar	8	0	OVTG			Allow NULL?
180	AvgPrice	Item Cost	num	19	6				Allow NULL?
181	PurPackMsr	Packaging UoM (Purchasing)	nvarchar	8	0				Allow NULL?
182	PurPackUn	Quantity per Packaging UoM	num	19	6				Allow NULL?
183	SalPackMsr	Sales Pack	nvarchar	8	0				Allow NULL?
184	SalPackUn	Packaging UoM (Sales)	num	19	6				Allow NULL?
185	SCNCounter	SCN Counter	int	6	0				Allow NULL?
186	ManBtchNum	Manage Batch No. [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
187	ManOutOnly	Manage SN Only on Exit	char	1	0		N	N=No, Y=Yes	Allow NULL?
188	DataSource	Data Source	char	1	0		N	A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
189	validFor	Active	char	1	0		N	N=No, Y=Yes	Allow NULL?
190	validFrom	Active From	date	8	0
191	validTo	Active To	date	8	0
192	frozenFor	Inactive	char	1	0		N	N=No, Y=Yes	Allow NULL?
193	frozenFrom	Inactive From	date	8	0
194	frozenTo	Inactive To	date	8	0
195	BlockOut	Force selection of serial no.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
196	ValidComm	Active Remarks	nvarchar	30	0				Allow NULL?
197	FrozenComm	Inactive Remarks	nvarchar	30	0				Allow NULL?
198	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
199	ObjType	Object Type	nvarchar	20	0		4		Allow NULL?
200	SWW	Additional Identifier	nvarchar	16	0				Allow NULL?
201	Deleted	Deleted	char	1	0		N	N=No, Y=Yes	Allow NULL?
202	DocEntry	Internal Number	int	11	0				Allow NULL?
203	ExpensAcct	Expense Account	nvarchar	15	0	OACT			Allow NULL?
204	FrgnInAcct	Revenue Account - Foreign	nvarchar	15	0	OACT			Allow NULL?
205	ShipType	Shipping Type	int	6	0	OSHP			Allow NULL?
206	GLMethod	Set G/L Account by	char	1	0		W	C=Item Group, L=Item Level, W=Warehouse	Allow NULL?
207	ECInAcct	Revenue Account - EU	nvarchar	15	0				Allow NULL?
208	FrgnExpAcc	Expense Account - Foreign	nvarchar	15	0				Allow NULL?
209	ECExpAcc	Expense Account - EU	nvarchar	15	0				Allow NULL?
210	TaxType	Tax Type	char	1	0		Y	N=No Tax, U=Use Tax, Y=Regular Tax	Allow NULL?
211	ByWh	Inventory Management by Whse	char	1	0				Allow NULL?
212	WTLiable	WTax Liable	char	1	0		Y	N=No, Y=Yes	Allow NULL?
213	ItemType	Item Type	char	1	0		I	I=Items, L=Labor, T=Travel	Allow NULL?
214	WarrntTmpl	Warranty Template	nvarchar	20	0				Allow NULL?
215	BaseUnit	Base Unit Name	nvarchar	20	0				Allow NULL?
216	CountryOrg	Country of Origin	nvarchar	3	0				Allow NULL?
217	StockValue	Inventory Value	num	19	6				Allow NULL?
218	Phantom	Phantom Item	char	1	0		N	N=No, Y=Yes	Allow NULL?
219	IssueMthd	Issue Method	char	1	0			B=Backflush, M=Manual	Allow NULL?
220	FREE1	Yield in %	char	1	0				Allow NULL?
221	PricingPrc	Pricing Percentage	num	19	6				Allow NULL?
222	MngMethod	Management Method	char	1	0		R	A=On Every Transaction, R=On Release Only	Allow NULL?
223	ReorderPnt	Reorder Point	num	19	6				Allow NULL?
224	InvntryUom	Inventory UoM	nvarchar	20	0				Allow NULL?
225	PlaningSys	Planning Method	char	1	0		N	M=MRP, N=None	Allow NULL?
226	PrcrmntMtd	Procurement Method	char	1	0		B	B=Buy, M=Make	Allow NULL?
227	OrdrIntrvl	Order Intervals	int	6	0				Allow NULL?
228	OrdrMulti	Order Multiple	num	19	6				Allow NULL?
229	MinOrdrQty	Minimum Order Quantity	num	19	6				Allow NULL?
230	LeadTime	Lead Time	int	11	0				Allow NULL?
231	IndirctTax	Indirect Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
232	TaxCodeAR	Tax Code (A/R)	nvarchar	8	0	OSTC			Allow NULL?
233	TaxCodeAP	Tax Code (A/P)	nvarchar	8	0	OSTC			Allow NULL?
234	OSvcCode	Outgoing Service Code	int	11	0	OSCD	-1		Allow NULL?
235	ISvcCode	Incoming Service Code	int	11	0	OSCD	-1		Allow NULL?
236	ServiceGrp	Service Group	int	11	0	OSGP	-1		Allow NULL?
237	NCMCode	NCM Code	int	11	0	ONCM	-1		Allow NULL?
238	MatType	Material Type	nvarchar	3	0	OMTP	1		Allow NULL?
239	MatGrp	Material Group	int	11	0	OMGP	-1		Allow NULL?
240	ProductSrc	Product Source	char	1	0		1	1=Purchased from the domestic vendor, 2=Imported by company, 3=Imported goods purchased from the domestic vendor, 4=Produced by the Company	Allow NULL?
241	ServiceCtg	Service Category	int	11	0	OSCG	-1	-1	Allow NULL?
242	ItemClass	Service or Material	char	1	0		2	1=Service, 2=Material	Allow NULL?
243	Excisable	Excisable [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
244	ChapterID	Chapter ID	int	11	0	OCHP	-1		Allow NULL?
245	NotifyASN	Notification Availed SN.	nvarchar	40	0				Allow NULL?
246	ProAssNum	Provisional Assessment No.	nvarchar	20	0				Allow NULL?
247	AssblValue	Assessable Value	num	19	6				Allow NULL?
248	DNFEntry	DNF Code Entry	int	11	0	ODNF	-1		Allow NULL?
249	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?

TOP B1 8.8 | OITM INDEXES

Name	Primary	Unique	Columns
PRIMARY	No	Yes	ItemCode
ITEM_NAME	No	No	ItemName
TREE_TYPE	No	No	TreeType
COM_GROUP	No	No	CommisGrp
SALE	No	No	SellItem
PURCHASE	No	No	PrchseItem
INVENTORY	No	No	InvntItem

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

249 COLUMNS | 7 INDEXES | B1 8.8 | OITM TABLE

TOP B1 8.8 | OITM COLUMNS

TOP B1 8.8 | OITM INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

249 COLUMNS | 7 INDEXES | B1 8.8 | OITM TABLE

TOPB1 8.8 | OITM COLUMNS

TOPB1 8.8 | OITM INDEXES

TOP B1 8.8 | OITM COLUMNS

TOP B1 8.8 | OITM INDEXES