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
General
1	Business One	9.3	AGRS	55	1	G/L Account Advanced Rules for Resources - History	General

Column	Field	Description	SQL Type	Length	Relation	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	OUSR			Allow NULL?
17	UserSign2	Updating User	int	6	OUSR			Allow NULL?
18	ResCode	Resource No.	nvarchar	50	ORSC			Allow NULL?
19	ResGrpCod	Resource Group	int	6	ORSB			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	ResRevAct	Resource Revenue Account	nvarchar	15	OACT			Allow NULL?
33	ResExpAct	Resource Expense Account	nvarchar	15	OACT			Allow NULL?
34	ResSaleAct	Resource Sales Credit Account	nvarchar	15	OACT			Allow NULL?
35	ResPurAct	Resource Purchase Credit Acct	nvarchar	15	OACT			Allow NULL?
36	ResNInvAct	Resource Received Not Inv.	nvarchar	15	OACT			Allow NULL?
37	ResStdExp1	Resource Std. Cost Expense 1	nvarchar	15	OACT			Allow NULL?
38	ResStdExp2	Resource Std. Cost Expense 2	nvarchar	15	OACT			Allow NULL?
39	ResStdExp3	Resource Std. Cost Expense 3	nvarchar	15	OACT			Allow NULL?
40	ResStdExp4	Resource Std. Cost Expense 4	nvarchar	15	OACT			Allow NULL?
41	ResStdExp5	Resource Std. Cost Expense 5	nvarchar	15	OACT			Allow NULL?
42	ResStdExp6	Resource Std. Cost Expense 6	nvarchar	15	OACT			Allow NULL?
43	ResStdExp7	Resource Std. Cost Expense 7	nvarchar	15	OACT			Allow NULL?
44	ResStdExp8	Resource Std. Cost Expense 8	nvarchar	15	OACT			Allow NULL?
45	ResStdExp9	Resource Std. Cost Expense 9	nvarchar	15	OACT			Allow NULL?
46	ResStdEx10	Resource Std. Cost Expense 10	nvarchar	15	OACT			Allow NULL?
47	ResWipAct	Resource WIP Account	nvarchar	15	OACT			Allow NULL?
48	ResScrapAc	Scrap Account	nvarchar	15	OACT			Allow NULL?
49	WipOffPlAc	WIP Offset P&L Account	nvarchar	15	OACT			Allow NULL?
50	ResOffPlAc	Resource Offset P&L Account	nvarchar	15	OACT			Allow NULL?
51	Active	Is Rule Active	char	1		Y	N=No, Y=Yes	Allow NULL?
52	CmpPrivate	Company/Private	char	1		A	A=All, C=Company, I=Private	Allow NULL?
53	VatGroup	Tax Definition	nvarchar	8	OVTG			Allow NULL?
54	CardCode	Customer/Vendor Code	nvarchar	15	OCRD			Allow NULL?
55	Usage	Usage Code for Document	int	11	OUSG			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

55 COLUMNS | 1 INDEXES | B1 9.3 | AGRS TABLE

TOP B1 9.3 | AGRS COLUMNS

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

55 COLUMNS | 1 INDEXES | B1 9.3 | AGRS TABLE

TOPB1 9.3 | AGRS COLUMNS

TOPB1 9.3 | AGRS INDEXES

TOP B1 9.3 | AGRS COLUMNS

TOP B1 9.3 | AGRS INDEXES