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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Finance
1	Business One	9.2	AGAR	84	1	G/L Account Advanced Rules - History	Finance

Column	Field	Description	SQL Type	Length	Default Value	Constraints	SQL Create Statement
1	AbsEntry	Internal Number	int	11			Allow NULL?
2	PeriodCat	Period Category	nvarchar	10			Allow NULL?
3	FinancYear	Beginning of Financial Year	date	8
4	Year	Financial Year	int	6			Allow NULL?
5	PeriodName	Period Name	nvarchar	20			Allow NULL?
6	SubType	Sub-Period Type	char	1	Y	D=Days, M=Months, Q=Quarters, Y=Year	Allow NULL?
7	PeriodNum	Number of Periods	int	11			Allow NULL?
8	F_RefDate	Posting Date From	date	8
9	T_RefDate	Posting Date To	date	8
10	F_DueDate	Due Date From	date	8
11	T_DueDate	Due Date To	date	8
12	F_TaxDate	Document Date From	date	8
13	T_TaxDate	Document Date To	date	8
14	LogInstanc	Log Instance	int	11			Allow NULL?
15	UpdateDate	Date of Update	date	8
16	UserSign	User Signature	int	6			Allow NULL?
17	UserSign2	Updating User	int	6			Allow NULL?
18	ItemCode	Item No.	nvarchar	20			Allow NULL?
19	ItmsGrpCod	Item Group	int	6			Allow NULL?
20	WhsCode	Warehouse Code	nvarchar	8			Allow NULL?
21	BPGrpCod	BP Group	int	6			Allow NULL?
22	LicTradNum	Federal Tax ID	nvarchar	32	!^\|	!^\|=All, !^\|E=Empty, !^\|F=Filled, Enter Tax ID=Enter Tax ID	Allow NULL?
23	ShipCountr	Ship-to Country	nvarchar	3			Allow NULL?
24	ShipState	Ship-To State	nvarchar	3			Allow NULL?
25	Comments	Remarks	nvarchar	254			Allow NULL?
26	CreateDate	Creation Date	date	8
27	RuleCode	Advanced Rule Code	nvarchar	20			Allow NULL?
28	GLMethod	Get G/L Account By	char	1	A	A=General, C=Item Group, W=Warehouse	Allow NULL?
29	Transfered	Year Transfer [Y/N]	char	1	N	N=No, Y=Yes	Allow NULL?
30	FromDate	From Date	date	8
31	ToDate	To Date	date	8
32	DfltExpn	Expense Account	nvarchar	15			Allow NULL?
33	DfltIncom	Revenue Account	nvarchar	15			Allow NULL?
34	ExmptIncom	Tax Exempt Revenue Account	nvarchar	15			Allow NULL?
35	StockAct	Inventory Account	nvarchar	15			Allow NULL?
36	COGM_Act	Cost of Goods Sold Account	nvarchar	15			Allow NULL?
37	AlocCstAct	Allocation Account	nvarchar	15			Allow NULL?
38	VariancAct	Variance Account	nvarchar	15			Allow NULL?
39	PricDifAct	Price Difference Account	nvarchar	15			Allow NULL?
40	NegStckAct	Negative Inventory Adj. Acct	nvarchar	15			Allow NULL?
41	DfltLoss	Inventory Offset - Decr. Acct	nvarchar	15			Allow NULL?
42	DfltProfit	Inventory Offset - Incr. Acct	nvarchar	15			Allow NULL?
43	RturnngAct	Sales Returns Account	nvarchar	15			Allow NULL?
44	ECIncome	Revenue Account - EU	nvarchar	15			Allow NULL?
45	ECExepnses	Expense Account - EU	nvarchar	15			Allow NULL?
46	ForgnIncm	Revenue Account - Foreign	nvarchar	15			Allow NULL?
47	ForgnExpn	Expense Account - Foreign	nvarchar	15			Allow NULL?
48	PurchseAct	Purchase Account	nvarchar	15			Allow NULL?
49	PaReturnAc	Purchase Return Account	nvarchar	15			Allow NULL?
50	PaOffsetAc	Purchase Offset Account	nvarchar	15			Allow NULL?
51	ExDiffAct	Exchange Rate Differences Acct	nvarchar	15			Allow NULL?
52	BalanceAct	Goods Clearing Account	nvarchar	15			Allow NULL?
53	DecresGlAc	G/L Decrease Account	nvarchar	15			Allow NULL?
54	IncresGlAc	G/L Increase Account	nvarchar	15			Allow NULL?
55	WipAcct	WIP Inventory Account	nvarchar	15			Allow NULL?
56	WipVarAcct	WIP Inventory Variance Account	nvarchar	15			Allow NULL?
57	WipOffset	WIP Offset P&L Account	nvarchar	15			Allow NULL?
58	StockOffst	Inventory Offset P&L Account	nvarchar	15			Allow NULL?
59	StockRvAct	Inventory Revaluation Account	nvarchar	15			Allow NULL?
60	StkRvOfAct	Inventory Reval. Offset Acct	nvarchar	15			Allow NULL?
61	CostRevAct	COGS Revaluation Acct	nvarchar	15			Allow NULL?
62	CostOffAct	COGS Revaluation Offset Acct	nvarchar	15			Allow NULL?
63	ExpClrAct	Expense Clearing Account	nvarchar	15			Allow NULL?
64	ExpOfstAct	Expense Offset Account	nvarchar	15			Allow NULL?
65	StkInTnAct	Stock In Transit Account	nvarchar	15			Allow NULL?
66	ShpdGdsAct	Shipped Goods Account	nvarchar	15			Allow NULL?
67	VatRevAct	VAT in Revenue Account	nvarchar	15			Allow NULL?
68	ARCMAct	Sales Credit Account	nvarchar	15			Allow NULL?
69	APCMAct	Purchase Credit Account	nvarchar	15			Allow NULL?
70	ARCMExpAct	Tax Exempt Credit Account	nvarchar	15			Allow NULL?
71	ARCMFrnAct	Sales Credit Account - Foreign	nvarchar	15			Allow NULL?
72	APCMFrnAct	Purchase Credit Acct - Foreign	nvarchar	15			Allow NULL?
73	ARCMEUAct	Sales Credit Account - EU	nvarchar	15			Allow NULL?
74	APCMEUAct	Purchase Credit Account - EU	nvarchar	15			Allow NULL?
75	PurBalAct	Purchase Balance Account	nvarchar	15			Allow NULL?
76	WhICenAct	Incoming CENVAT Account (WH)	nvarchar	15			Allow NULL?
77	WhOCenAct	Outgoing CENVAT Account (WH)	nvarchar	15			Allow NULL?
78	Active	Is Rule Active	char	1	Y	N=No, Y=Yes	Allow NULL?
79	CmpPrivate	Company/Private/Government	char	1	A	A=All, C=Company, G=Government, I=Private	Allow NULL?
80	VatGroup	Tax Definition	nvarchar	8			Allow NULL?
81	CardCode	Customer/Vendor Code	nvarchar	15			Allow NULL?
82	Usage	Usage Code for Document	int	11			Allow NULL?
83	FreeChrgSA	Free of Charge Sales Account	nvarchar	15			Allow NULL?
84	FreeChrgPU	Free of Charge Purchase Account	nvarchar	15			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

84 COLUMNS | 1 INDEXES | B1 9.2 | AGAR TABLE

TOP B1 9.2 | AGAR COLUMNS

TOP B1 9.2 | AGAR 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

84 COLUMNS | 1 INDEXES | B1 9.2 | AGAR TABLE

TOPB1 9.2 | AGAR COLUMNS

TOPB1 9.2 | AGAR INDEXES

TOP B1 9.2 | AGAR COLUMNS

TOP B1 9.2 | AGAR INDEXES