	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

322 COLUMNS | 7 INDEXES | B1 9.3 | AITM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Inventory and Production
1	Business One	9.3	AITM	322	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, UgpEntry, PUoMEntry, SUoMEntry, IUoMEntry, IssuePriBy, AssetClass, AssetGroup, InventryNo, Technician, Employee, Location, StatAsset, Cession, DeacAftUL, AsstStatus, CapDate, AcqDate, RetDate, GLPickMeth, NoDiscount, MgrByQty, AssetRmk1, AssetRmk2, AssetAmnt1, AssetAmnt2, DeprGroup, AssetSerNo, CntUnitMsr, NumInCnt, INUoMEntry, OneBOneRec, RuleCode, ScsCode, SpProdType, IWeight1, IWght1Unit, IWeight2, IWght2Unit, CompoWH, CreateTS, UpdateTS, VirtAstItm, SouVirAsst, InCostRoll, PrdStdCst, EnAstSeri, LinkRsc, OnHldPert, onHldLimt, PriceUnit, GSTRelevnt, SACEntry, GstTaxCtg, AssVal4WTR, ExcImpQUoM, ExcFixAmnt, ExcRate, SOIExc, TNVED, Imported, AutoBatch, CstmActing FROM AITM

TOP B1 9.3 | AITM COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	ItemCode	Item Number	nvarchar	50	0				Allow NULL?
2	ItemName	Item Description	nvarchar	100	0				Allow NULL?
3	FrgnName	Foreign Name	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	254	0				Allow NULL?
8	VATLiable	Tax Liable	char	1	0		Y	N=No, Y=Yes	Allow NULL?
9	PrchseItem	Purchase Item	char	1	0		Y	N=No, Y=Yes	Allow NULL?
10	SellItem	Sales Item	char	1	0		Y	N=No, Y=Yes	Allow NULL?
11	InvntItem	Inventory Item	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	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	50	0				Allow NULL?
21	BuyUnitMsr	Purchasing UoM	nvarchar	100	0		Unit		Allow NULL?
22	NumInBuy	No. of Items per Purchase Unit	num	19	6				Allow NULL?
23	ReorderQty	Required (Purchasing UoM)	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
35	SalUnitMsr	Sales UoM	nvarchar	100	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=Moving Average, B=Serial/Batch, F=FIFO, S=Standard	Allow NULL?
42	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
43	FREE	Free Item [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
44	PicturName	Picture	nvarchar	200	0				Allow NULL?
45	Transfered	Year Transferred [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
46	BlncTrnsfr	Balances Transferred [Y/N]	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	OCOG	0		Allow NULL?
52	TreeType	Bill of Materials 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	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 Asset Indicator	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	Volume - 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	Tax Definition	nvarchar	8	0	OVTG			Allow NULL?
180	AvgPrice	Item Cost	num	19	6				Allow NULL?
181	PurPackMsr	Packaging UoM (Purchasing)	nvarchar	30	0		Box		Allow NULL?
182	PurPackUn	Quantity per Package (Purchasing)	num	19	6				Allow NULL?
183	SalPackMsr	Packaging UoM (Sales)	nvarchar	30	0		Box		Allow NULL?
184	SalPackUn	Quantity per Package (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 on Release Only	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, G=Fixed Assets Migration, 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. or Batch 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	11	0		0		Allow NULL?
199	ObjType	Object Type	nvarchar	20	0	ADP1			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	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=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	Manage Inventory by Warehouse	char	1	0				Allow NULL?
212	WTLiable	Withholding Tax Liable	char	1	0		Y	N=No, Y=Yes	Allow NULL?
213	ItemType	Item Type	char	1	0		I	F=Fixed Assets, I=Items, L=Labor, T=Travel	Allow NULL?
214	WarrntTmpl	Warranty Template	nvarchar	20	0	OCTT			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	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	100	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 Interval	int	6	0	OCYC			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	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	nvarchar	2	0	OPSC	0		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?
250	Spec	Item Specification	nvarchar	30	0				Allow NULL?
251	TaxCtg	Tax Category	nvarchar	4	0				Allow NULL?
252	Series	Series	int	11	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?
261	UgpEntry	UoM Group	int	11	0	OUGP			Allow NULL?
262	PUoMEntry	Default Purchase UoM	int	11	0	OUOM			Allow NULL?
263	SUoMEntry	Default Sales UoM	int	11	0	OUOM			Allow NULL?
264	IUoMEntry	Inventory UoM	int	11	0	OUOM			Allow NULL?
265	IssuePriBy	Issue Primarily By SnB or Bin	int	6	0			0=Issue Primarily by Serial/Batch Number, 1=Issue Primarily by Bin Location	Allow NULL?
266	AssetClass	Asset Class	nvarchar	20	0	OACS			Allow NULL?
267	AssetGroup	Asset Group	nvarchar	15	0	OAGS			Allow NULL?
268	InventryNo	Inventory Number of Asset	nvarchar	12	0				Allow NULL?
269	Technician	Technician of Fixed Asset	int	11	0	OHEM			Allow NULL?
270	Employee	Employee of Fixed Asset	int	11	0	OHEM			Allow NULL?
271	Location	Location	int	11	0	OLCT			Allow NULL?
272	StatAsset	Owned by Company	char	1	0		N	N=No, Y=Yes	Allow NULL?
273	Cession	Cession	char	1	0		N	N=No, Y=Yes	Allow NULL?
274	DeacAftUL	Deactivate After Useful Life	char	1	0		N	N=No, Y=Yes	Allow NULL?
275	AsstStatus	Asset Status	char	1	0		N	A=Active, I=Inactive, N=New	Allow NULL?
276	CapDate	Capitalization Date	date	8	0
277	AcqDate	Acquisition Date	date	8	0
278	RetDate	Retirement Date	date	8	0
279	GLPickMeth	G/L Account Pick Method	char	1	0		A	A=General, C=Item Group, W=Warehouse	Allow NULL?
280	NoDiscount	No Discounts	char	1	0		N	N=No, Y=Yes	Allow NULL?
281	MgrByQty	Manage Asset by Quantity	char	1	0		N	N=No, Y=Yes	Allow NULL?
282	AssetRmk1	Asset Remark 1	nvarchar	100	0				Allow NULL?
283	AssetRmk2	Asset Remark 2	nvarchar	100	0				Allow NULL?
284	AssetAmnt1	Asset Amount 1	num	19	6				Allow NULL?
285	AssetAmnt2	Asset Amount 2	num	19	6				Allow NULL?
286	DeprGroup	Depreciation Group	nvarchar	15	0	OADG			Allow NULL?
287	AssetSerNo	Asset Serial Number	nvarchar	32	0				Allow NULL?
288	CntUnitMsr	Inventory Counting UoM Name	nvarchar	100	0				Allow NULL?
289	NumInCnt	No. of Items per Counting Unit	num	19	6				Allow NULL?
290	INUoMEntry	Inventory Counting UoM Entry	int	11	0	OUOM			Allow NULL?
291	OneBOneRec	One Batch One Receipt	char	1	0		N	N=No, Y=Yes	Allow NULL?
292	RuleCode	Checking Rule Code	nvarchar	2	0	ODCR			Allow NULL?
293	ScsCode	Scs Code	nvarchar	10	0				Allow NULL?
294	SpProdType	Special Product Type	nvarchar	2	0			IO=Integrated Circuits, MT=Cellular Phones	Allow NULL?
295	IWeight1	Weight 1 - Inventory	num	19	6				Allow NULL?
296	IWght1Unit	Weight 1 - Inventory Unit	int	6	0				Allow NULL?
297	IWeight2	Weight 2 - Inventory	num	19	6				Allow NULL?
298	IWght2Unit	Weight 2 - Inventory Unit	int	6	0				Allow NULL?
299	CompoWH	Component Warehouse	char	1	0		B	B=From Bill of Materials Line, P=From Parent Item Document Line	Allow NULL?
300	CreateTS	Creatn Time - Incl. Secs	int	11	0				Allow NULL?
301	UpdateTS	Update Full Time	int	11	0				Allow NULL?
302	VirtAstItm	Virtual Asset Item	char	1	0		N	N=No, Y=Yes	Allow NULL?
303	SouVirAsst	Source Virtual Asset Item	nvarchar	50	0	OITM			Allow NULL?
304	InCostRoll	Include in Prod. Cost Rollup	char	1	0		Y	N=No, Y=Yes	Allow NULL?
305	PrdStdCst	Production Std Cost	num	19	6				Allow NULL?
306	EnAstSeri	Enforce Asset Serial Numbers	char	1	0		N	N=No, Y=Yes	Allow NULL?
307	LinkRsc	Linked Resource	nvarchar	50	0	ORSC			Allow NULL?
308	OnHldPert	Capital Goods On Hold Percent	num	19	6				Allow NULL?
309	onHldLimt	Capital Goods on Hold Limit	num	19	6				Allow NULL?
310	PriceUnit	Pricing Unit	int	11	0	OUOM			Allow NULL?
311	GSTRelevnt	GST Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
312	SACEntry	SAC Entry	int	11	0	OSAC	-1		Allow NULL?
313	GstTaxCtg	GST Tax Category	char	1	0		R	E=Exempt, N=Nil Rated, R=Regular	Allow NULL?
314	AssVal4WTR	Assessable Value for WTR	num	19	6				Allow NULL?
315	ExcImpQUoM	Default Excise Imported Quantity UoM	int	11	0			112=Liters, m3, 168=Tonne, metric ton (1000 kg), 251=Horsepower (1 hp = 0.75 kW), 831=Liters of anhydrous (pure) alcohol	Allow NULL?
316	ExcFixAmnt	Default Excise Fixed Amount	num	19	6				Allow NULL?
317	ExcRate	Default Excise Rate	num	19	6				Allow NULL?
318	SOIExc	SOI Excisable	char	1	0		4	1=Excisable, 2=Exemption of excises, 3=Excises are paid to another authority, 4=Not Excisable	Allow NULL?
319	TNVED	TNVED Code	nvarchar	10	0				Allow NULL?
320	Imported	Imported Item	char	1	0		N	N=No, Y=Yes	Allow NULL?
321	AutoBatch	Automatic Batch Creation	char	1	0		N	N=No, Y=Yes	Allow NULL?
322	CstmActing	Customer Accounting	char	1	0		N	N=No, Y=Yes	Allow NULL?

TOP B1 9.3 | 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

322 COLUMNS | 7 INDEXES | B1 9.3 | AITM TABLE

TOP B1 9.3 | AITM COLUMNS

TOP B1 9.3 | 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

322 COLUMNS | 7 INDEXES | B1 9.3 | AITM TABLE

TOPB1 9.3 | AITM COLUMNS

TOPB1 9.3 | AITM INDEXES

TOP B1 9.3 | AITM COLUMNS

TOP B1 9.3 | AITM INDEXES