	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

260 COLUMNS | 7 INDEXES | B1 8.82 | AITM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Inventory and Production
1	Business One	8.82	AITM	260	7	Items - History	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, Spec, TaxCtg, Series, Number, FuelCode, BeverTblC, BeverGrpC, BeverTM, Attachment, AtcEntry, ToleranDay FROM AITM

TOP B1 8.82 | AITM COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	ItemCode	Item Number	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	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, Y	Allow NULL?
9	PrchseItem	Purchase Item [Yes/No]	char	1	0		Y	N, Y	Allow NULL?
10	SellItem	Sales Item [Yes/No]	char	1	0		Y	N, Y	Allow NULL?
11	InvntItem	Inventory Item [Yes/No]	char	1	0		Y	N, Y	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	Free1	num	19	6				Allow NULL?
18	DfltWH	Default Whse	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		Unit		Allow NULL?
22	NumInBuy	No. of Items per Purchase Unit	num	19	6				Allow NULL?
23	ReorderQty	Required 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 Revaluation Price	date	8	0
27	CustomPer	Customs Rate	num	19	6				Allow NULL?
28	Canceled	Canceled Item [Yes/No]	char	1	0		N	N, Y	Allow NULL?
29	MnufctTime	Production Date	int	11	0				Allow NULL?
30	WholSlsTax	Tax Rate for Wholesaler	char	1	0				Allow NULL?
31	RetilrTax	Sales Tax %	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, Y	Allow NULL?
35	SalUnitMsr	Sales UoM	nvarchar	20	0		Unit		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	Counted Qty	num	19	6				Allow NULL?
40	OpenBlnc	Opening Stock	num	19	6				Allow NULL?
41	EvalSystem	Valuation Method	char	1	0			A, F, S	Allow NULL?
42	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
43	FREE	Free Item [Y/N]	char	1	0		N	N, Y	Allow NULL?
44	PicturName	Picture	nvarchar	200	0				Allow NULL?
45	Transfered	Year Transferred [Y/N]	char	1	0		N	N, Y	Allow NULL?
46	BlncTrnsfr	Balances Transferred [Y/N]	char	1	0		N	N, Y	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	Bill of Materials Type	char	1	0		N	A, N, P, S, T	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	Release Currency	nvarchar	3	0				Allow NULL?
58	ExitPrice	Release Price	num	19	6				Allow NULL?
59	ExitWH	Release Warehouse	nvarchar	8	0				Allow NULL?
60	AssetItem	Fixed Assets	char	1	0		N	N, Y	Allow NULL?
61	WasCounted	Counted	char	1	0		N	N, Y	Allow NULL?
62	ManSerNum	Serial No. Management	char	1	0		N	N, Y	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, Y	Allow NULL?
103	QryGroup2	Property 2	char	1	0		N	N, Y	Allow NULL?
104	QryGroup3	Property 3	char	1	0		N	N, Y	Allow NULL?
105	QryGroup4	Property 4	char	1	0		N	N, Y	Allow NULL?
106	QryGroup5	Property 5	char	1	0		N	N, Y	Allow NULL?
107	QryGroup6	Property 6	char	1	0		N	N, Y	Allow NULL?
108	QryGroup7	Property 7	char	1	0		N	N, Y	Allow NULL?
109	QryGroup8	Property 8	char	1	0		N	N, Y	Allow NULL?
110	QryGroup9	Property 9	char	1	0		N	N, Y	Allow NULL?
111	QryGroup10	Property 10	char	1	0		N	N, Y	Allow NULL?
112	QryGroup11	Property 11	char	1	0		N	N, Y	Allow NULL?
113	QryGroup12	Property 12	char	1	0		N	N, Y	Allow NULL?
114	QryGroup13	Property 13	char	1	0		N	N, Y	Allow NULL?
115	QryGroup14	Property 14	char	1	0		N	N, Y	Allow NULL?
116	QryGroup15	Property 15	char	1	0		N	N, Y	Allow NULL?
117	QryGroup16	Property 16	char	1	0		N	N, Y	Allow NULL?
118	QryGroup17	Property 17	char	1	0		N	N, Y	Allow NULL?
119	QryGroup18	Property 18	char	1	0		N	N, Y	Allow NULL?
120	QryGroup19	Property 19	char	1	0		N	N, Y	Allow NULL?
121	QryGroup20	Property 20	char	1	0		N	N, Y	Allow NULL?
122	QryGroup21	Property 21	char	1	0		N	N, Y	Allow NULL?
123	QryGroup22	Property 22	char	1	0		N	N, Y	Allow NULL?
124	QryGroup23	Property 23	char	1	0		N	N, Y	Allow NULL?
125	QryGroup24	Property 24	char	1	0		N	N, Y	Allow NULL?
126	QryGroup25	Property 25	char	1	0		N	N, Y	Allow NULL?
127	QryGroup26	Property 26	char	1	0		N	N, Y	Allow NULL?
128	QryGroup27	Property 27	char	1	0		N	N, Y	Allow NULL?
129	QryGroup28	Property 28	char	1	0		N	N, Y	Allow NULL?
130	QryGroup29	Property 29	char	1	0		N	N, Y	Allow NULL?
131	QryGroup30	Property 30	char	1	0		N	N, Y	Allow NULL?
132	QryGroup31	Property 31	char	1	0		N	N, Y	Allow NULL?
133	QryGroup32	Property 32	char	1	0		N	N, Y	Allow NULL?
134	QryGroup33	Property 33	char	1	0		N	N, Y	Allow NULL?
135	QryGroup34	Property 34	char	1	0		N	N, Y	Allow NULL?
136	QryGroup35	Property 35	char	1	0		N	N, Y	Allow NULL?
137	QryGroup36	Property 36	char	1	0		N	N, Y	Allow NULL?
138	QryGroup37	Property 37	char	1	0		N	N, Y	Allow NULL?
139	QryGroup38	Property 38	char	1	0		N	N, Y	Allow NULL?
140	QryGroup39	Property 39	char	1	0		N	N, Y	Allow NULL?
141	QryGroup40	Property 40	char	1	0		N	N, Y	Allow NULL?
142	QryGroup41	Property 41	char	1	0		N	N, Y	Allow NULL?
143	QryGroup42	Property 42	char	1	0		N	N, Y	Allow NULL?
144	QryGroup43	Property 43	char	1	0		N	N, Y	Allow NULL?
145	QryGroup44	Property 44	char	1	0		N	N, Y	Allow NULL?
146	QryGroup45	Property 45	char	1	0		N	N, Y	Allow NULL?
147	QryGroup46	Property 46	char	1	0		N	N, Y	Allow NULL?
148	QryGroup47	Property 47	char	1	0		N	N, Y	Allow NULL?
149	QryGroup48	Property 48	char	1	0		N	N, Y	Allow NULL?
150	QryGroup49	Property 49	char	1	0		N	N, Y	Allow NULL?
151	QryGroup50	Property 50	char	1	0		N	N, Y	Allow NULL?
152	QryGroup51	Property 51	char	1	0		N	N, Y	Allow NULL?
153	QryGroup52	Property 52	char	1	0		N	N, Y	Allow NULL?
154	QryGroup53	Property 53	char	1	0		N	N, Y	Allow NULL?
155	QryGroup54	Property 54	char	1	0		N	N, Y	Allow NULL?
156	QryGroup55	Property 55	char	1	0		N	N, Y	Allow NULL?
157	QryGroup56	Property 56	char	1	0		N	N, Y	Allow NULL?
158	QryGroup57	Property 57	char	1	0		N	N, Y	Allow NULL?
159	QryGroup58	Property 58	char	1	0		N	N, Y	Allow NULL?
160	QryGroup59	Property 59	char	1	0		N	N, Y	Allow NULL?
161	QryGroup60	Property 60	char	1	0		N	N, Y	Allow NULL?
162	QryGroup61	Property 61	char	1	0		N	N, Y	Allow NULL?
163	QryGroup62	Property 62	char	1	0		N	N, Y	Allow NULL?
164	QryGroup63	Property 63	char	1	0		N	N, Y	Allow NULL?
165	QryGroup64	Property 64	char	1	0		N	N, Y	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	Tax Definition	nvarchar	8	0	OVTG			Allow NULL?
180	AvgPrice	Item Cost	num	19	6				Allow NULL?
181	PurPackMsr	Purchasing Pack	nvarchar	8	0		Box		Allow NULL?
182	PurPackUn	Quantity per Packaging UoM	num	19	6				Allow NULL?
183	SalPackMsr	Sales Pack	nvarchar	8	0		Box		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, Y	Allow NULL?
187	ManOutOnly	Manage SN on Release Only	char	1	0		N	N, Y	Allow NULL?
188	DataSource	Data Source	char	1	0		N	A, D, I, M, N, O, P, T, U	Allow NULL?
189	validFor	Active	char	1	0		N	N, Y	Allow NULL?
190	validFrom	Active From	date	8	0
191	validTo	Active To	date	8	0
192	frozenFor	Inactive	char	1	0		N	N, Y	Allow NULL?
193	frozenFrom	Inactive From	date	8	0
194	frozenTo	Inactive To	date	8	0
195	BlockOut	Force Selection of Serial No. or Batch No.	char	1	0		Y	N, Y	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				Allow NULL?
200	SWW	Additional Identifier	nvarchar	16	0				Allow NULL?
201	Deleted	Deleted	char	1	0		N	N, Y	Allow NULL?
202	DocEntry	Numerator	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 Accounts By	char	1	0		W	C, L, W	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, U, Y	Allow NULL?
211	ByWh	Inventory Management by Whse	char	1	0				Allow NULL?
212	WTLiable	Withholding Tax Liable	char	1	0		Y	N, Y	Allow NULL?
213	ItemType	Item Type	char	1	0		I	I, L, T	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, Y	Allow NULL?
219	IssueMthd	Issue Method	char	1	0		B	B, M	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, R	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, N	Allow NULL?
226	PrcrmntMtd	Procurement Method	char	1	0		B	B, M	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, Y	Allow NULL?
232	TaxCodeAR	Sales Tax Code	nvarchar	8	0	OSTC			Allow NULL?
233	TaxCodeAP	Purchasing Tax Code	nvarchar	8	0	OSTC			Allow NULL?
234	OSvcCode	Outgoing Service Code	int	11	0	OSCD			Allow NULL?
235	ISvcCode	Incoming Service Code	int	11	0	OSCD			Allow NULL?
236	ServiceGrp	Service Group	int	11	0	OSGP			Allow NULL?
237	NCMCode	NCM Code	int	11	0	ONCM			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, 2, 3, 4	Allow NULL?
241	ServiceCtg	Service Category	int	11	0	OSCG	-1	-1	Allow NULL?
242	ItemClass	Service or Material	char	1	0		2	1, 2	Allow NULL?
243	Excisable	Excisable [Yes/No]	char	1	0		N	N, Y	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?
250	Spec	Item Specification	nvarchar	30	0				Allow NULL?
251	TaxCtg	Tax Category	nvarchar	4	0				Allow NULL?
252	Series	Series	int	6	0	NNM1			Allow NULL?
253	Number	Number	int	11	0				Allow NULL?
254	FuelCode	Fuel	int	11	0	OBFI	-1		Allow NULL?
255	BeverTblC	Beverage Table	nvarchar	2	0	OBSI			Allow NULL?
256	BeverGrpC	Beverage Group	nvarchar	2	0	OBSI			Allow NULL?
257	BeverTM	Beverage Brand	int	11	0	OBNI	-1		Allow NULL?
258	Attachment	Attachment	text	16	0
259	AtcEntry	Attachment Entry	int	11	0				Allow NULL?
260	ToleranDay	Tolerance Days	int	11	0				Allow NULL?

TOP B1 8.82 | AITM INDEXES

Name	Primary	Unique	Columns
PRIMARY	No	Yes	ItemCode, LogInstanc
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

260 COLUMNS | 7 INDEXES | B1 8.82 | AITM TABLE

TOP B1 8.82 | AITM COLUMNS

TOP B1 8.82 | AITM 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

260 COLUMNS | 7 INDEXES | B1 8.82 | AITM TABLE

TOPB1 8.82 | AITM COLUMNS

TOPB1 8.82 | AITM INDEXES

TOP B1 8.82 | AITM COLUMNS

TOP B1 8.82 | AITM INDEXES