ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	8.82	AINF	194	1	Company Info	Administration

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, L, O	Allow NULL?
14	EnblVTGPmn	Use Tax Groups in Payments	char	1	0			N, Y	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, Y	Allow NULL?
27	EnblRCN	Enable Retail Chain Stores	char	1	0			N, Y	Allow NULL?
28	EnblCorINV	Enable Correction Invoice	char	1	0			N, Y	Allow NULL?
29	EnblCshRep	Enable Cash Report	char	1	0			N, Y	Allow NULL?
30	EnblIRTRep	Enable Interest Report	char	1	0			N, Y	Allow NULL?
31	EnblTrnRep	Enable Turnover Report	char	1	0			N, Y	Allow NULL?
32	EnblVPMRep	Enable Payments Report	char	1	0			N, Y	Allow NULL?
33	EnblACTRep	Enable Adv. Corp. Tax Report	char	1	0			N, Y	Allow NULL?
34	EnblFTZ	Enable Free Trade Zone	char	1	0			N, Y	Allow NULL?
35	EnblSlfPCH	Enable Self A/P Invoice	char	1	0			N, Y	Allow NULL?
36	EnblPCHUpd	Enable Purchase Trans. Update	char	1	0			N, Y	Allow NULL?
37	EnblRsvINV	Enable Reserve Invoice	char	1	0			N, Y	Allow NULL?
38	EnblRTDnld	Enable Rates Download	char	1	0			N, Y	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, Y	Allow NULL?
42	EnblRtrRep	Enable Returns Report	char	1	0			N, Y	Allow NULL?
43	IsEC	European Countries	char	1	0			N, Y	Allow NULL?
44	EnblCshDsc	Enable Cash Discounts	char	1	0			N, V, Y	Allow NULL?
45	EnblLostCD	Enable Lost Cash Discount	char	1	0			N, Y	Allow NULL?
46	NumActLvls	No. of Account Group Levels	int	11	0				Allow NULL?
47	EnblRealRD	Enable Realized Rate Diff.	char	1	0			N, Y	Allow NULL?
48	EnblVTGNoD	Enable Tax on Down Payment	char	1	0		Y	N, Y	Allow NULL?
49	EnblGLManP	Enable Manual Postings in Control Account	char	1	0			N, Y	Allow NULL?
50	EnblOptVIP	Enable Optional Tax in Payments	char	1	0			N, Y	Allow NULL?
51	EnblActCrC	Enable Account Currency Change	char	1	0			N, Y	Allow NULL?
52	EnblFrnAct	Enable Foreign Item Account	char	1	0			N, Y	Allow NULL?
53	EnblECAct	Enable EU Item Account	char	1	0			N, Y	Allow NULL?
54	EnblECRpt	Enable 349 Report	char	1	0			N, Y	Allow NULL?
55	EnblRound	Enable Rounding	char	1	0			N, Y	Allow NULL?
56	EnblPrVatS	Enable Print Tax Amount	char	1	0			N, Y	Allow NULL?
57	EnblYrTrns	Enable Year Transfer	char	1	0			A, N, Y	Allow NULL?
58	EnblActTtl	Enable Account Title	char	1	0			N, Y	Allow NULL?
59	EnblDocWrn	Enable No Base Doc. Alert	char	1	0			N, Y	Allow NULL?
60	ActSegNum	No. of Segments	int	6	0		0		Allow NULL?
61	EnbSgmnAct	Enable Account Segmentation	char	1	0			N, Y	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, Y	Allow NULL?
73	MultiAddss	Multi Address	char	1	0			N, Y	Allow NULL?
74	EnbDunning	Enable Dunning	char	1	0		Y	N, Y	Allow NULL?
75	EnbQtyEDln	Allow Qty in Delivery Note to Exceed Base Doc. Qty	char	1	0			N, Y	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, N, Y	Allow NULL?
80	EnblDfrTax	Enable Deferred Tax	char	1	0			N, Y	Allow NULL?
81	EnblClsPr	Enable Period-End Closing	char	1	0			N, Y	Allow NULL?
82	EnblTaxEL	Enable Tax Exemption Letter	char	1	0			N, Y	Allow NULL?
83	EnableBOE	Enable Bills of Exchange	char	1	0		N	N, Y	Allow NULL?
84	EnableWHT	Enable WTax	char	1	0			N, Y	Allow NULL?
85	EnblEquVat	Enable Equalization Tax	char	1	0			N, Y	Allow NULL?
86	EnblFAsset	Enable Fixed Assets	char	1	0			N, Y	Allow NULL?
87	EnblDoubt	Enable Doubtful Debts	char	1	0			N, Y	Allow NULL?
88	RateBase	Base Date for Exchange Rate	char	1	0		P	P, T	Allow NULL?
89	BOEStatClo	Allow Closed Status for Bill of Exchange	char	1	0			N, Y	Allow NULL?
90	ARDocsInWT	Enable WTax in A/R Docs	char	1	0			N, Y	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, Y	Allow NULL?
96	EnblVATDat	Enable VAT Date	char	1	0			N, Y	Allow NULL?
97	EnblStAgRp	Enable Stock Aging Report	char	1	0			N, Y	Allow NULL?
98	EnblCARepo	Enable Control Acct Reposting	char	1	0			N, Y	Allow NULL?
99	EnblMatRev	Enable Inventory Revaluation	char	1	0			N, Y	Allow NULL?
100	EnblMBPRec	Enable Multiple BPs Reconcil.	char	1	0			N, Y	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, Y	Allow NULL?
103	EnblCorAct	Enable Correspondence of Accts	char	1	0			N, Y	Allow NULL?
104	EnblRuDIP	Enable RU Delivery & Invoice	char	1	0			N, Y	Allow NULL?
105	EnblCurDec	Enable Decimal Places	char	1	0			N, Y	Allow NULL?
106	EnblPayMtd	Enable Payment Method on Inv.	char	1	0			N, Y	Allow NULL?
107	EnblBaseUn	Enable UoM on Invoice	char	1	0			N, Y	Allow NULL?
108	EnblVATAna	Enable VAT Analytics Report	char	1	0			N, Y	Allow NULL?
109	EnblExREnh	Enable Frgn. Curr. Valuation	char	1	0			N, Y	Allow NULL?
110	VATGrpCal	Enable VAT Calculation by Grp	char	1	0			N, Y	Allow NULL?
111	MaxChoose	No. of Choose from List Rows	int	11	0		0		Allow NULL?
112	EnblInfla	Enable Inflation	char	1	0			N, Y	Allow NULL?
113	EnblLAWHT	Enable Latin America WHT	char	1	0			N, Y	Allow NULL?
114	EnblRTWHT	Enable Rounding Type WHT	char	1	0			N, Y	Allow NULL?
115	ChkQunty	Enable Check Quantity In RDR	char	1	0		Y	N, Y	Allow NULL?
116	SriMngSys	SRI Management System	char	1	0		R	A, R	Allow NULL?
117	BtchMngSys	Batch Management System	char	1	0		R	A, R	Allow NULL?
118	SriCreatIn	Auto SRI creation on receipt	char	1	0		N	N, Y	Allow NULL?
119	EnblFolio	Enable Folio Numbers	nvarchar	2	0			CL, MX, N	Allow NULL?
120	EnblDocSbT	Enable Document Subtype	nvarchar	2	0			CL, MX, N	Allow NULL?
121	IepsPayer	IEPS Payers	char	1	0		N	N, Y	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, Y	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, Y	Allow NULL?
127	EnblDownP	Down Payment	char	1	0			N, Y	Allow NULL?
128	EnblNDdctC	Enable Non Deduct VAT Per Card	char	1	0			N, Y	Allow NULL?
129	DocNmMtd	Enable Sharing Series	char	1	0			N, Y	Allow NULL?
130	DoFilter	Data Ownership Indication	char	1	0		N	N, Y	Allow NULL?
131	EnblOnPDCh	Enable Opened Postdated Checks	char	1	0			N, Y	Allow NULL?
132	EnblOnWnCr	Open Window for Credit Voucher	char	1	0			N, Y	Allow NULL?
133	EnblDefInx	Enable Define Indexes	char	1	0			N, Y	Allow NULL?
134	EnblMxComm	Enable Max Commitment	char	1	0			N, Y	Allow NULL?
135	EnblIndxOp	Enable Index Option	char	1	0			N, Y	Allow NULL?
136	EnblSbtCVo	Enable Submit Credit Voucher	char	1	0			N, Y	Allow NULL?
137	MinAmntOAP	Minimum Amount for Appndix O&P	num	19	6				Allow NULL?
138	CredSumm	Credit Card Summary	char	1	0			N, Y	Allow NULL?
139	PostdChk	Postdated Check	char	1	0			N, Y	Allow NULL?
140	PostdCred	Postdated Credit Voucher	char	1	0			N, Y	Allow NULL?
141	CredVend	Credit Vendors	char	1	0			N, Y	Allow NULL?
142	WkoStatus	Old Work Order Status	char	1	0			N, Y	Allow NULL?
143	DispTrByDf	Display Transactions by Dflt	char	1	0		Y	N, Y	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, Y	Allow NULL?
147	AutoCrIns	Auto Create Customer Eq Card	char	1	0		N	N, Y	Allow NULL?
148	EnbRepomo	Enable Inflation for Cash Act	char	1	0			N, Y	Allow NULL?
149	RFCValidat	Enable RFC Validations	char	1	0			N, Y	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, Y	Allow NULL?
152	CashDisc	Cash Discount In Document	char	1	0			N, Y	Allow NULL?
153	EnableSMS	Enable SMS	char	1	0			N, Y	Allow NULL?
154	EnblIndic	Enable Indicator	char	1	0			N, Y	Allow NULL?
155	EnbFedTax	Enable Federal Tax ID	char	1	0			N, Y	Allow NULL?
156	EnblCounty	Enable County	char	1	0			N, Y	Allow NULL?
157	Language	Language on Create Company	int	6	0				Allow NULL?
158	ChkIntgUpd	Check Data Integrity On Update	char	1	0		Y	N, Y	Allow NULL?
159	ChkIntgCre	Check Data Integrity On Create	char	1	0		Y	N, Y	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, Y	Allow NULL?
162	EnbDecWord	Show Check Decimal in Words	char	1	0		Y	N, Y	Allow NULL?
163	ChkWrdOnly	Add the Word Only in Checks	char	1	0			N, Y	Allow NULL?
164	EnBnkStmnt	Bank Statement Processing	char	1	0		N	N, Y	Allow NULL?
165	CalcVatGrp	Group Lines in VAT Calculation	char	1	0			N, Y	Allow NULL?
166	TaxSysType	Defines Tax Calculation System	char	1	0			A, B, C, M, S	Allow NULL?
167	ESEnabled	Is Event Sender enabled?	char	1	0		N	C, N, Y	Allow NULL?
168	RateTotal	Use rate for minor total calc.	char	1	0		N	N, Y	Allow NULL?
169	CompanyHis	Create/Upgrade History	text	16	0
170	EnblAssVal	Enable Assessable Value	char	1	0		N	N, Y	Allow NULL?
171	CompanySta	Company Status	char	1	0		U	A, I, P, S, U, V	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, J	Allow NULL?
174	InstallNo	Installation Number	nvarchar	30	0				Allow NULL?
175	IsOldPA	Is Old for PA	char	1	0		N	N, Y	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, Y	Allow NULL?
179	UpdatedTF	Is Updated Tax Formula	char	1	0		N	N, Y	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, I, W	Allow NULL?
182	SPNEnabled	Enable Transact. Notification	char	1	0		Y		Allow NULL?
183	PrsWkCntEb	Personal Work Center Enabled	char	1	0		N		Allow NULL?
184	DashbdEb	Dashboard Enabled	char	1	0		N	N, Y	Allow NULL?
185	BoxEffDate	Box: Effective From Date	date	8	0
186	LogInstanc	Log Instance	int	6	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, W	Allow NULL?
191	B1SgtEb	B1 Suggest: Enable	char	1	0		Y		Allow NULL?
192	IsHConEnv	Is in High Concurrency Env	char	1	0		N	N, Y	Allow NULL?
193	B1BuzzEb	Enable Streamwork Widget	char	1	0		N		Allow NULL?
194	IMCEEnable	IMCE Enable	char	1	0		N	N, Y	Allow NULL?

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

194 COLUMNS | 1 INDEXES | B1 8.82 | AINF TABLE

TOP B1 8.82 | AINF COLUMNS

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

194 COLUMNS | 1 INDEXES | B1 8.82 | AINF TABLE

TOPB1 8.82 | AINF COLUMNS

TOPB1 8.82 | AINF INDEXES

TOP B1 8.82 | AINF COLUMNS

TOP B1 8.82 | AINF INDEXES