	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

219 COLUMNS | 1 INDEXES | B1 9.3 | AINF TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	9.3	AINF	219	1	Company Info	Administration

SQL: selectupdate insert create

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

SELECT Version, CompnyName, Flags, InfoL1, InfoL2, InfoA1, InfoA2, ACTStamp, ADMStamp, RTTStamp, CINFStamp, LawsSet, EnblVatGrp, EnblVTGPmn, VatOOS_O, VatOOS_I, VatStnd_O, VatStnd_I, VatExmpt_O, VatExmpt_I, VatHalf_O, VatHalf_I, VatZrRt_O, VatZrRt_I, MaxActGrps, EnblDctSrc, EnblRCN, EnblCorINV, EnblCshRep, EnblIRTRep, EnblTrnRep, EnblVPMRep, EnblACTRep, EnblFTZ, EnblSlfPCH, EnblPCHUpd, EnblRsvINV, EnblRTDnld, RTTDnldAdr, ZPrcCode, EnblExpns, EnblRtrRep, IsEC, EnblCshDsc, EnblLostCD, NumActLvls, EnblRealRD, EnblVTGNoD, EnblGLManP, EnblOptVIP, EnblActCrC, EnblFrnAct, EnblECAct, EnblECRpt, EnblRound, EnblPrVatS, EnblYrTrns, EnblActTtl, EnblDocWrn, ActSegNum, EnbSgmnAct, SizeOfSeg0, SizeOfSeg1, SizeOfSeg2, SizeOfSeg3, SizeOfSeg4, SizeOfSeg5, SizeOfSeg6, SizeOfSeg7, SizeOfSeg8, SizeOfSeg9, Rprt1099, MultiAddss, EnbDunning, EnbQtyEDln, Itw1Date, Itw1Time, Itw1Count, EnbPayRef, EnblDfrTax, EnblClsPr, EnblTaxEL, EnableBOE, EnableWHT, EnblEquVat, EnblFAsset, EnblDoubt, RateBase, BOEStatClo, ARDocsInWT, BISBnkCnt, BISRBnkCd, BISRBnkAc, BISRBranch, EnblBPConn, EnblVATDat, EnblStAgRp, EnblCARepo, EnblMatRev, EnblMBPRec, CshDscGros, EnblTaxInv, EnblCorAct, EnblRuDIP, EnblCurDec, EnblPayMtd, EnblBaseUn, EnblVATAna, EnblExREnh, VATGrpCal, MaxChoose, EnblInfla, EnblLAWHT, EnblRTWHT, ChkQunty, SriMngSys, BtchMngSys, SriCreatIn, EnblFolio, EnblDocSbT, IepsPayer, DaysOrdCnc, EnblLATaxS, PercOfAcq, MinBaseDoc, EnblDpmJdt, EnblDownP, EnblNDdctC, DocNmMtd, DoFilter, EnblOnPDCh, EnblOnWnCr, EnblDefInx, EnblMxComm, EnblIndxOp, EnblSbtCVo, MinAmntOAP, CredSumm, PostdChk, PostdCred, CredVend, WkoStatus, DispTrByDf, stampTax, MinAmntAL, BlockZeroQ, AutoCrIns, EnbRepomo, RFCValidat, MxDcsInPmt, RelStkNoPr, CashDisc, EnableSMS, EnblIndic, EnbFedTax, EnblCounty, Language, ChkIntgUpd, ChkIntgCre, BisBnkAcKy, EnbZeroDec, EnbDecWord, ChkWrdOnly, EnBnkStmnt, CalcVatGrp, TaxSysType, ESEnabled, RateTotal, CompanyHis, EnblAssVal, CompanySta, eFRTActLvs, TaxGrpType, InstallNo, IsOldPA, EnbNegDoc, Algo, ArcComp, UpdatedTF, DARDBGUID, NegStoLv, SPNEnabled, PrsWkCntEb, DashbdEb, BoxEffDate, LogInstanc, UpdateDate, UserSign2, SnapShotId, CreatedBy, B1SgtEb, IsHConEnv, B1BuzzEb, IMCEEnable, DKeyId, ResetDData, ConvDifAct, BasEffDate, oldFxAss, MaxRowsCFL, ColSel, EnblSPEDUF, DpmAffTot, AliasUpd, TrailDays, TestComp, DashConf, SideEnable, IsPALInit, PANAVer, ExpEnable, LastSsrDat, LastSsrHsh, B1iTimeOut, CpRfshEnbl, CpRfshIntv, EnbMBFilt, CompnyGUID, ShutTime FROM AINF

TOP B1 9.3 | AINF COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	Version	Version	int	11	0				Allow NULL?
2	CompnyName	Company Name	nvarchar	100	0				Allow NULL?
3	Flags	Flags	nvarchar	50	0		NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN		Allow NULL?
4	InfoL1	Info L1	int	11	0				Allow NULL?
5	InfoL2	Info L2	int	11	0				Allow NULL?
6	InfoA1	Info A1	nvarchar	128	0				Allow NULL?
7	InfoA2	Info A2	nvarchar	50	0				Allow NULL?
8	ACTStamp	ACT Stamp	int	11	0		0		Allow NULL?
9	ADMStamp	((	int	11	0		0		Allow NULL?
10	RTTStamp	RTT Stamp	int	11	0		0		Allow NULL?
11	CINFStamp	CINF Stamp	int	11	0		0		Allow NULL?
12	LawsSet	Laws Set	nvarchar	3	0				Allow NULL?
13	EnblVatGrp	Tax System	char	1	0			C=Tax per BP, L=Tax per Row, O=One Tax	Allow NULL?
14	EnblVTGPmn	Use Tax Groups in Payments	char	1	0			N=No, Y=Yes	Allow NULL?
15	VatOOS_O	Tax Definition	nvarchar	8	0				Allow NULL?
16	VatOOS_I	Tax Exempt Revenue Account	nvarchar	8	0				Allow NULL?
17	VatStnd_O	Tax Standard O	nvarchar	8	0				Allow NULL?
18	VatStnd_I	Tax Standard I	nvarchar	8	0				Allow NULL?
19	VatExmpt_O	Tax Exempt O	nvarchar	8	0				Allow NULL?
20	VatExmpt_I	Tax Exempt I	nvarchar	8	0				Allow NULL?
21	VatHalf_O	Tax Definition	nvarchar	8	0				Allow NULL?
22	VatHalf_I	Tax Definition	nvarchar	8	0				Allow NULL?
23	VatZrRt_O	Tax Zero Rate O	nvarchar	8	0				Allow NULL?
24	VatZrRt_I	Tax Zero Rate I	nvarchar	8	0				Allow NULL?
25	MaxActGrps	Max. No. of Account Groups	int	11	0				Allow NULL?
26	EnblDctSrc	Enable Deduction at Source	char	1	0			N=No, Y=Yes	Allow NULL?
27	EnblRCN	Enable Retail Chain Stores	char	1	0			N=No, Y=Yes	Allow NULL?
28	EnblCorINV	Enable Correction Invoice	char	1	0			N=No, Y=Yes	Allow NULL?
29	EnblCshRep	Enable Cash Report	char	1	0			N=No, Y=Yes	Allow NULL?
30	EnblIRTRep	Enable Interest Report	char	1	0			N=No, Y=Yes	Allow NULL?
31	EnblTrnRep	Enable Turnover Report	char	1	0			N=No, Y=Yes	Allow NULL?
32	EnblVPMRep	Enable Payments Report	char	1	0			N=No, Y=Yes	Allow NULL?
33	EnblACTRep	Enable Adv. Corp. Tax Report	char	1	0			N=No, Y=Yes	Allow NULL?
34	EnblFTZ	Enable Free Trade Zone	char	1	0			N=No, Y=Yes	Allow NULL?
35	EnblSlfPCH	Enable Self A/P Invoice	char	1	0			N=No, Y=Yes	Allow NULL?
36	EnblPCHUpd	Enable Purchase Trans. Update	char	1	0			N=No, Y=Yes	Allow NULL?
37	EnblRsvINV	Enable Reserve Invoice	char	1	0			N=No, Y=Yes	Allow NULL?
38	EnblRTDnld	Enable Rates Download	char	1	0			N=No, Y=Yes	Allow NULL?
39	RTTDnldAdr	Rates Download Web Address	nvarchar	254	0				Allow NULL?
40	ZPrcCode	Zero Center Code	nvarchar	8	0				Allow NULL?
41	EnblExpns	Enable Freight Management	char	1	0			N=No, Y=Yes	Allow NULL?
42	EnblRtrRep	Enable Returns Report	char	1	0			N=No, Y=Yes	Allow NULL?
43	IsEC	European Countries	char	1	0			N=No, Y=Yes	Allow NULL?
44	EnblCshDsc	Enable Cash Discounts	char	1	0			N=No, V=No Tax Adjustment, Y=Yes	Allow NULL?
45	EnblLostCD	Enable Lost Cash Discount	char	1	0			N=No, Y=Yes	Allow NULL?
46	NumActLvls	No. of Account Group Levels	int	11	0				Allow NULL?
47	EnblRealRD	Enable Realized Rate Diff.	char	1	0			N=No, Y=Yes	Allow NULL?
48	EnblVTGNoD	Enable Tax on Down Payment	char	1	0		Y	N=No, Y=Yes	Allow NULL?
49	EnblGLManP	Enable Manual Postings in Control Account	char	1	0			N=No, Y=Yes	Allow NULL?
50	EnblOptVIP	Enable Optional Tax in Payments	char	1	0			N=No, Y=Yes	Allow NULL?
51	EnblActCrC	Enable Account Currency Change	char	1	0			N=No, Y=Yes	Allow NULL?
52	EnblFrnAct	Enable Foreign Item Account	char	1	0			N=No, Y=Yes	Allow NULL?
53	EnblECAct	Enable EU Item Account	char	1	0			N=No, Y=Yes	Allow NULL?
54	EnblECRpt	Enable 349 Report	char	1	0			N=No, Y=Yes	Allow NULL?
55	EnblRound	Enable Rounding	char	1	0			N=No, Y=Yes	Allow NULL?
56	EnblPrVatS	Enable Print Tax Amount	char	1	0			N=No, Y=Yes	Allow NULL?
57	EnblYrTrns	Enable Year Transfer	char	1	0			A=Data Archive, N=No, Y=Year Transfer	Allow NULL?
58	EnblActTtl	Enable Account Title	char	1	0			N=No, Y=Yes	Allow NULL?
59	EnblDocWrn	Enable No Base Doc. Alert	char	1	0			N=No, Y=Yes	Allow NULL?
60	ActSegNum	No. of Segments	int	6	0		0		Allow NULL?
61	EnbSgmnAct	Enable Account Segmentation	char	1	0			N=No, Y=Yes	Allow NULL?
62	SizeOfSeg0	Size of Segment 0	int	6	0		0		Allow NULL?
63	SizeOfSeg1	Size of Segment 1	int	6	0		0		Allow NULL?
64	SizeOfSeg2	Size of Segment 2	int	6	0		0		Allow NULL?
65	SizeOfSeg3	Size of Segment 3	int	6	0		0		Allow NULL?
66	SizeOfSeg4	Size of Segment 4	int	6	0		0		Allow NULL?
67	SizeOfSeg5	Size of Segment 5	int	6	0		0		Allow NULL?
68	SizeOfSeg6	Size of Segment 6	int	6	0		0		Allow NULL?
69	SizeOfSeg7	Size of Segment 7	int	6	0		0		Allow NULL?
70	SizeOfSeg8	Size of Segment 8	int	6	0		0		Allow NULL?
71	SizeOfSeg9	Size of Segment 9	int	6	0		0		Allow NULL?
72	Rprt1099	1099 Report	char	1	0			N=No, Y=Yes	Allow NULL?
73	MultiAddss	Multi Address	char	1	0			N=No, Y=Yes	Allow NULL?
74	EnbDunning	Enable Dunning	char	1	0		Y	N=No, Y=Yes	Allow NULL?
75	EnbQtyEDln	Allow Qty in Delivery Note to Exceed Base Doc. Qty	char	1	0			N=No, Y=Yes	Allow NULL?
76	Itw1Date	Next Alert Date	date	8	0
77	Itw1Time	Next Alert Time	int	11	0				Allow NULL?
78	Itw1Count	ITW1 Counter	int	11	0				Allow NULL?
79	EnbPayRef	Calculate Payment Ref. No.	char	1	0			I=ISR Reference, N=No, Y=Payment Reference No.	Allow NULL?
80	EnblDfrTax	Enable Deferred Tax	char	1	0			N=No, Y=Yes	Allow NULL?
81	EnblClsPr	Enable Period-End Closing	char	1	0			N=No, Y=Yes	Allow NULL?
82	EnblTaxEL	Enable Tax Exemption Letter	char	1	0			N=No, Y=Yes	Allow NULL?
83	EnableBOE	Enable Bills of Exchange	char	1	0		N	N=No, Y=Yes	Allow NULL?
84	EnableWHT	Enable WTax	char	1	0		N	N=No, Y=Yes	Allow NULL?
85	EnblEquVat	Enable Equalization Tax	char	1	0			N=No, Y=Yes	Allow NULL?
86	EnblFAsset	Enable Fixed Assets	char	1	0			N=No, Y=Yes	Allow NULL?
87	EnblDoubt	Enable Doubtful Debts	char	1	0			N=No, Y=Yes	Allow NULL?
88	RateBase	Base Date for Exchange Rate	char	1	0		P	P=Posting Date, T=Document Date	Allow NULL?
89	BOEStatClo	Allow Closed Status for Bill of Exchange	char	1	0			N=No, Y=Yes	Allow NULL?
90	ARDocsInWT	Enable WTax in A/R Docs	char	1	0			N=No, Y=Yes	Allow NULL?
91	BISBnkCnt	BISR Bank Country	nvarchar	3	0				Allow NULL?
92	BISRBnkCd	BISR Bank No.	nvarchar	30	0				Allow NULL?
93	BISRBnkAc	BISR Bank Account	nvarchar	50	0				Allow NULL?
94	BISRBranch	BISR Branch	nvarchar	50	0				Allow NULL?
95	EnblBPConn	Enable BP Cards Connection	char	1	0			N=No, Y=Yes	Allow NULL?
96	EnblVATDat	Enable VAT Date	char	1	0			N=No, Y=Yes	Allow NULL?
97	EnblStAgRp	Enable Stock Aging Report	char	1	0			N=No, Y=Yes	Allow NULL?
98	EnblCARepo	Enable Control Acct Reposting	char	1	0			N=No, Y=Yes	Allow NULL?
99	EnblMatRev	Enable Inventory Revaluation	char	1	0			N=No, Y=Yes	Allow NULL?
100	EnblMBPRec	Enable Multiple BPs Reconcil.	char	1	0			N=No, Y=Yes	Allow NULL?
101	CshDscGros	Cash Discount Flag For CN, HK	char	1	0		N		Allow NULL?
102	EnblTaxInv	Enable Tax Invoices	char	1	0			N=No, Y=Yes	Allow NULL?
103	EnblCorAct	Enable Correspondence of Accts	char	1	0			N=No, Y=Yes	Allow NULL?
104	EnblRuDIP	Enable RU Delivery & Invoice	char	1	0			N=No, Y=Yes	Allow NULL?
105	EnblCurDec	Enable Decimal Places	char	1	0			N=No, Y=Yes	Allow NULL?
106	EnblPayMtd	Enable Payment Method on Inv.	char	1	0			N=No, Y=Yes	Allow NULL?
107	EnblBaseUn	Enable UoM on Invoice	char	1	0			N=No, Y=Yes	Allow NULL?
108	EnblVATAna	Enable VAT Analytics Report	char	1	0			N=No, Y=Yes	Allow NULL?
109	EnblExREnh	Enable Frgn. Curr. Valuation	char	1	0			N=No, Y=Yes	Allow NULL?
110	VATGrpCal	Enable VAT Calculation by Grp	char	1	0			N=No, Y=Yes	Allow NULL?
111	MaxChoose	No. of Choose from List Rows	int	11	0		0		Allow NULL?
112	EnblInfla	Enable Inflation	char	1	0			N=No, Y=Yes	Allow NULL?
113	EnblLAWHT	Enable Latin America WHT	char	1	0			N=No, Y=Yes	Allow NULL?
114	EnblRTWHT	Enable Rounding Type WHT	char	1	0			N=No, Y=Yes	Allow NULL?
115	ChkQunty	Enable Check Quantity In RDR	char	1	0		N	N=No, Y=Yes	Allow NULL?
116	SriMngSys	SRI Management System	char	1	0		R	A=On Every Transaction, R=On Release Only	Allow NULL?
117	BtchMngSys	Batch Management System	char	1	0		R	A=On Every Transaction, R=On Release Only	Allow NULL?
118	SriCreatIn	Auto SRI creation on receipt	char	1	0		N	N=No, Y=Yes	Allow NULL?
119	EnblFolio	Enable Folio Numbers	nvarchar	2	0			CL=Chile, MX=Mexico, N=No	Allow NULL?
120	EnblDocSbT	Enable Document Subtype	nvarchar	2	0			CL=Chile, IN=India, MX=Mexico, N=No	Allow NULL?
121	IepsPayer	IEPS Payers	char	1	0		N	N=No, Y=Yes	Allow NULL?
122	DaysOrdCnc	Default Days for Ord. Canc.	int	11	0		30		Allow NULL?
123	EnblLATaxS	Enable Latin America Tax Sys	char	1	0			N=No, Y=Yes	Allow NULL?
124	PercOfAcq	Percent of Total Acquisition	num	19	6				Allow NULL?
125	MinBaseDoc	Minimum Base Amount per Doc	num	19	6				Allow NULL?
126	EnblDpmJdt	Create JE Rows in Down Pmnt	char	1	0			N=No, Y=Yes	Allow NULL?
127	EnblDownP	Down Payment	char	1	0			N=No, Y=Yes	Allow NULL?
128	EnblNDdctC	Enable Non Deduct VAT Per Card	char	1	0			N=No, Y=Yes	Allow NULL?
129	DocNmMtd	Enable Sharing Series	char	1	0			N=No., Y=Yes	Allow NULL?
130	DoFilter	Data Ownership Indication	char	1	0		N	N=No, Y=Yes	Allow NULL?
131	EnblOnPDCh	Enable Opened Postdated Checks	char	1	0			N=No, Y=Yes	Allow NULL?
132	EnblOnWnCr	Open Window for Credit Voucher	char	1	0			N=No, Y=Yes	Allow NULL?
133	EnblDefInx	Enable Define Indexes	char	1	0			N=No, Y=Yes	Allow NULL?
134	EnblMxComm	Enable Max Commitment	char	1	0			N=No, Y=Yes	Allow NULL?
135	EnblIndxOp	Enable Index Option	char	1	0			N=No, Y=Yes	Allow NULL?
136	EnblSbtCVo	Enable Submit Credit Voucher	char	1	0			N=No, Y=Yes	Allow NULL?
137	MinAmntOAP	Minimum Amount for Appndix O&P	num	19	6				Allow NULL?
138	CredSumm	Credit Card Summary	char	1	0			N=No, Y=Yes	Allow NULL?
139	PostdChk	Postdated Check	char	1	0			N=No, Y=Yes	Allow NULL?
140	PostdCred	Postdated Credit Voucher	char	1	0			N=No, Y=Yes	Allow NULL?
141	CredVend	Credit Vendors	char	1	0			N=No, Y=Yes	Allow NULL?
142	WkoStatus	Old Work Order Status	char	1	0			N=No, Y=Yes	Allow NULL?
143	DispTrByDf	Display Transactions by Dflt	char	1	0		Y	N=No, Y=Yes	Allow NULL?
144	stampTax	Default Stamp Tax	nvarchar	8	0	OVTG			Allow NULL?
145	MinAmntAL	Minimum Amount for Annual List	num	19	6				Allow NULL?
146	BlockZeroQ	Block Stock Negative Quantity	char	1	0		Y	N=No, Y=Yes	Allow NULL?
147	AutoCrIns	Auto Create Customer Eq Card	char	1	0		N	N=No, Y=Yes	Allow NULL?
148	EnbRepomo	Enable Inflation for Cash Act	char	1	0			N=No, Y=Yes	Allow NULL?
149	RFCValidat	Enable RFC Validations	char	1	0			N=No, Y=Yes	Allow NULL?
150	MxDcsInPmt	Max. Number of Documents in Payment	int	11	0		0		Allow NULL?
151	RelStkNoPr	Enable Stock Release without Item Cost	char	1	0		N	N=No, Y=Yes	Allow NULL?
152	CashDisc	Cash Discount In Document	char	1	0			N=No, Y=Yes	Allow NULL?
153	EnableSMS	Enable SMS	char	1	0			N=No, Y=Yes	Allow NULL?
154	EnblIndic	Enable Indicator	char	1	0			N=No, Y=Yes	Allow NULL?
155	EnbFedTax	Enable Federal Tax ID	char	1	0			N=No, Y=Yes	Allow NULL?
156	EnblCounty	Enable County	char	1	0			N=No, Y=Yes	Allow NULL?
157	Language	Language on Create Company	int	11	0				Allow NULL?
158	ChkIntgUpd	Check Data Integrity On Update	char	1	0		Y	N=No, Y=Yes	Allow NULL?
159	ChkIntgCre	Check Data Integrity On Create	char	1	0		Y	N=No, Y=Yes	Allow NULL?
160	BisBnkAcKy	BISR Bank Account Key	int	11	0	DSC1			Allow NULL?
161	EnbZeroDec	Enable Print Check Show Zero Decimal	char	1	0		N	N=No, Y=Yes	Allow NULL?
162	EnbDecWord	Show Check Decimal in Words	char	1	0		Y	N=No, Y=Yes	Allow NULL?
163	ChkWrdOnly	Add the Word Only in Checks	char	1	0			N=No, Y=Yes	Allow NULL?
164	EnBnkStmnt	Bank Statement Processing	char	1	0		N	N=No, Y=Yes	Allow NULL?
165	CalcVatGrp	Group Lines in VAT Calculation	char	1	0			N=No, Y=Yes	Allow NULL?
166	TaxSysType	Defines Tax Calculation System	char	1	0			A=Preconfigured Formula with Jurisdiction Support, B=User-Defined Formula, C=Preconfigured Formula, M=Fixed Implementation with Jurisdiction Support, S=Fixed Implementation	Allow NULL?
167	ESEnabled	Is Event Sender enabled?	char	1	0		N	C=Customize, N=No, Y=Yes	Allow NULL?
168	RateTotal	Use rate for minor total calc.	char	1	0		N	N=No, Y=Yes	Allow NULL?
169	CompanyHis	Create/Upgrade History	text	16	0
170	EnblAssVal	Enable Assessable Value	char	1	0		N	N=No, Y=Yes	Allow NULL?
171	CompanySta	Company Status	char	1	0		U	A=Archived, I=Invalid, P=Upgrade Simulation, S=Inventory Valuation Utility, U=Upgrading, V=Valid	Allow NULL?
172	eFRTActLvs	No. of Levels in Elect. FRT	int	11	0				Allow NULL?
173	TaxGrpType	Defines Tax Grouping Type	char	1	0		C	C=Code, J=Jurisdiction	Allow NULL?
174	InstallNo	Installation Number	nvarchar	30	0				Allow NULL?
175	IsOldPA	Is Old for PA	char	1	0		N	N=No, Y=Yes	Allow NULL?
176	EnbNegDoc	Enable Negative Total in Doc	char	1	0				Allow NULL?
177	Algo	Encryption Algorithm	int	6	0				Allow NULL?
178	ArcComp	Archived Company	char	1	0		N	N=No, Y=Yes	Allow NULL?
179	UpdatedTF	Is Updated Tax Formula	char	1	0		N	N=No, Y=Yes	Allow NULL?
180	DARDBGUID	Readonly DB GUID for Archiving	nvarchar	32	0				Allow NULL?
181	NegStoLv	Negative Inv.: Check Level	char	1	0		I	C=Company, I=Item Setting, W=Warehouse	Allow NULL?
182	SPNEnabled	Enable Transact. Notification	char	1	0		Y	N=No, Y=Yes	Allow NULL?
183	PrsWkCntEb	Personal Work Center Enabled	char	1	0		N	F=Fiori Style Cockpit, N=No Cockpit, Y=Normal Style Cockpit	Allow NULL?
184	DashbdEb	Dashboard Enabled	char	1	0		N	N=No, Y=Yes	Allow NULL?
185	BoxEffDate	Box: Effective From Date	date	8	0
186	LogInstanc	Log Instance	int	11	0		0		Allow NULL?
187	UpdateDate	Date of Update	date	8	0
188	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
189	SnapShotId	Snapshot ID	int	11	0		0		Allow NULL?
190	CreatedBy	Created By	char	1	0		N	N, P=Solution Packager, W=Express Configuration Wizard	Allow NULL?
191	B1SgtEb	B1 Suggest: Enable	char	1	0		N	N=No, Y=Yes	Allow NULL?
192	IsHConEnv	Is in High Concurrency Env	char	1	0		N	N=No, Y=Yes	Allow NULL?
193	B1BuzzEb	Enable Streamwork Widget	char	1	0		N		Allow NULL?
194	IMCEEnable	IMCE Enable	char	1	0		N	N=No, Y=Yes	Allow NULL?
195	DKeyId	Current Dynamic Key ID	nvarchar	128	0				Allow NULL?
196	ResetDData	Reset Dyn. Key Data to Default	char	1	0		N		Allow NULL?
197	ConvDifAct	Enable Conversion Diff. Acct	char	1	0		Y	N=No, Y=Yes	Allow NULL?
198	BasEffDate	Base Effective From Date	date	8	0
199	oldFxAss	Has Used Old Fixed Assets	char	1	0		N	N=No, Y=Yes	Allow NULL?
200	MaxRowsCFL	Max. Rows for Choose from List	int	11	0		0	0=Unlimited, 100000=100000, 10000=10000, 50000=50000, 5000=5000	Allow NULL?
201	ColSel	Column Selection	text	16	0
202	EnblSPEDUF	Enable SPED Related UDFs	char	1	0		N	N=No, Y=Yes	Allow NULL?
203	DpmAffTot	Down Payment Affects Total	char	1	0		Y	N=No, Y=Yes	Allow NULL?
204	AliasUpd	Installation Date	nvarchar	254	0				Allow NULL?
205	TrailDays	Trial Days	int	6	0				Allow NULL?
206	TestComp	Test Comp.	char	1	0		N	N=No, Y=Yes	Allow NULL?
207	DashConf	Enable Side Bar	text	16	0
208	SideEnable	Enable Side Bar	char	1	0		N	N=No, Y=Yes	Allow NULL?
209	IsPALInit	Is PAL Init. or Not	char	1	0		N		Allow NULL?
210	PANAVer	Pervasive Version	int	11	0		0		Allow NULL?
211	ExpEnable	Enable Expense Claim	char	1	0		Y		Allow NULL?
212	LastSsrDat	Last SSR upload date	date	8	0
213	LastSsrHsh	Last SSR upload date hash	nvarchar	33	0				Allow NULL?
214	B1iTimeOut	B1i Request Timeout	int	11	0		30		Allow NULL?
215	CpRfshEnbl	Enable Cockpit Auto Refresh	char	1	0		N		Allow NULL?
216	CpRfshIntv	Cockpit Refresh Interval	int	11	0		300		Allow NULL?
217	EnbMBFilt	Enable Filtering Mechanism by Branch	char	1	0		N	N=No, Y=Yes	Allow NULL?
218	CompnyGUID	Company GUID	nvarchar	40	0				Allow NULL?
219	ShutTime	SAP Business One Shutdown Time	int	11	0				Allow NULL?

TOP B1 9.3 | AINF INDEXES

Name	Primary	Unique	Type	Columns
PRIMARY	No	Yes		Version, LogInstanc

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

219 COLUMNS | 1 INDEXES | B1 9.3 | AINF TABLE

TOP B1 9.3 | AINF COLUMNS

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

219 COLUMNS | 1 INDEXES | B1 9.3 | AINF TABLE

TOPB1 9.3 | AINF COLUMNS

TOPB1 9.3 | AINF INDEXES

TOP B1 9.3 | AINF COLUMNS

TOP B1 9.3 | AINF INDEXES