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
Finance
1	Business One	8.82	OACT	108	5	G/L Accounts	Finance

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	AcctCode	Account Code	nvarchar	15	0				Allow NULL?
2	AcctName	Account Name	nvarchar	100	0				Allow NULL?
3	CurrTotal	Current Balance	num	19	6				Allow NULL?
4	EndTotal	Opening Balance	num	19	6				Allow NULL?
5	Finanse	Cash Account [Y/N]	char	1	0		N	N, Y	Allow NULL?
6	Groups	Main Group	nvarchar	8	0				Allow NULL?
7	Budget	Budget	char	1	0		N	N, Y	Allow NULL?
8	Frozen	Account on Hold [Y/N]	char	1	0		N	N, Y	Allow NULL?
9	Free_2	Free 2	char	1	0				Allow NULL?
10	Postable	Account [Active/Title]	char	1	0		Y	N, Y	Allow NULL?
11	Fixed	Main Account	char	1	0				Allow NULL?
12	Levels	Account Level	int	6	0		2		Allow NULL?
13	ExportCode	Data Export Code	nvarchar	10	0				Allow NULL?
14	GrpLine	Serial No. in Group	int	11	0				Allow NULL?
15	FatherNum	Parent Account Key	nvarchar	15	0				Allow NULL?
16	AccntntCod	External Code	nvarchar	12	0				Allow NULL?
17	CashBox	Capital Account [Y/N]	char	1	0		N	N, Y	Allow NULL?
18	GroupMask	Group Mask	int	6	0		1		Allow NULL?
19	RateTrans	For Conversion Differences	char	1	0		Y	N, Y	Allow NULL?
20	TaxIncome	Tax Definition	char	1	0		N	N, Y	Allow NULL?
21	ExmIncome	Tax Definition	char	1	0		N	N, Y	Allow NULL?
22	ExtrMatch	External Reconciliation No.	int	11	0				Allow NULL?
23	IntrMatch	Internal Reconciliation No.	int	11	0				Allow NULL?
24	ActType	Account Category	char	1	0		N	E, I, N	Allow NULL?
25	Transfered	Year Transfer [Y/N]	char	1	0		N	N, Y	Allow NULL?
26	BlncTrnsfr	Balances Transferred [Y/N]	char	1	0		N	N, Y	Allow NULL?
27	OverType	Loading Type	char	1	0		N	N, Y	Allow NULL?
28	OverCode	Loading Factor Code	nvarchar	8	0	OOCR			Allow NULL?
29	SysMatch	System Reconciliation No.	int	11	0		-1		Allow NULL?
30	PrevYear	There are accounts from the previous year	char	1	0		N	N, Y	Allow NULL?
31	ActCurr	Account Currency	nvarchar	3	0				Allow NULL?
32	RateDifAct	Rate Differences Account	nvarchar	15	0				Allow NULL?
33	SysTotal	Balance in System Currency	num	19	6				Allow NULL?
34	FcTotal	Balance in Account Currency	num	19	6				Allow NULL?
35	Protected	Protected Account [Y/N]	char	1	0		N	N, Y	Allow NULL?
36	RealAcct	Reconciled Account [Y/N]	char	1	0		N	N, Y	Allow NULL?
37	Advance	Liable for Advances	char	1	0		Y	N, Y	Allow NULL?
38	CreateDate	Creation Date	date	8	0
39	UpdateDate	Date of Update	date	8	0
40	FrgnName	Foreign Name	nvarchar	100	0				Allow NULL?
41	Details	Details	nvarchar	254	0				Allow NULL?
42	ExtraSum	Additional Amount	num	19	6				Allow NULL?
43	Project	Project Code	nvarchar	20	0	OPRJ			Allow NULL?
44	RevalMatch	Revaluation Coordinated [Yes/No]	char	1	0		N	N, Y	Allow NULL?
45	DataSource	Data Source	char	1	0		N	A, D, I, M, N, O, P, T, U	Allow NULL?
46	LocMth	LC Reconciliation	char	1	0		Y	N, Y	Allow NULL?
47	MTHCounter	MTH Counter	int	11	0				Allow NULL?
48	BNKCounter	BNK Counter	int	11	0				Allow NULL?
49	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
50	LocManTran	Lock Manual Transaction	char	1	0		N	N, Y	Allow NULL?
51	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
52	ObjType	Object Type	nvarchar	20	0		1		Allow NULL?
53	ValidFor	Active	char	1	0		N	N, Y	Allow NULL?
54	ValidFrom	Active From	date	8	0
55	ValidTo	Active To	date	8	0
56	ValidComm	Active Remarks	nvarchar	30	0				Allow NULL?
57	FrozenFor	Inactive	char	1	0		N	N, Y	Allow NULL?
58	FrozenFrom	Inactive From	date	8	0
59	FrozenTo	Inactive To	date	8	0
60	FrozenComm	Inactive Remarks	nvarchar	30	0				Allow NULL?
61	Counter	Counter	int	11	0		0		Allow NULL?
62	Segment_0	Segment 0	nvarchar	20	0				Allow NULL?
63	Segment_1	Segment 1	nvarchar	20	0				Allow NULL?
64	Segment_2	Segment 2	nvarchar	20	0				Allow NULL?
65	Segment_3	Segment 3	nvarchar	20	0				Allow NULL?
66	Segment_4	Segment 4	nvarchar	20	0				Allow NULL?
67	Segment_5	Segment 5	nvarchar	20	0				Allow NULL?
68	Segment_6	Segment 6	nvarchar	20	0				Allow NULL?
69	Segment_7	Segment 7	nvarchar	20	0				Allow NULL?
70	Segment_8	Segment 8	nvarchar	20	0				Allow NULL?
71	Segment_9	Segment 9	nvarchar	20	0				Allow NULL?
72	FormatCode	Format Code	nvarchar	210	0				Allow NULL?
73	CfwRlvnt	Cash Flow Relevant [Y/N]	char	1	0		N	N, Y	Allow NULL?
74	ExchRate	Exchange Rate Differences	char	1	0		Y	N, Y	Allow NULL?
75	RevalAcct	Revaluation Account	nvarchar	15	0				Allow NULL?
76	LastRevBal	Last Revaluation Balance	num	19	6				Allow NULL?
77	LastRevDat	Last Revaluation Date	date	8	0
78	DfltVat	Default VAT Group	nvarchar	8	0	OVTG			Allow NULL?
79	VatChange	Allow Change VAT Group	char	1	0		Y	N, Y	Allow NULL?
80	Category	Category	int	11	0	OACG			Allow NULL?
81	TransCode	Transaction Code	nvarchar	4	0	OTRC			Allow NULL?
82	OverCode5	Loading Factor Code 5	nvarchar	8	0	OOCR			Allow NULL?
83	OverCode2	Loading Factor Code 2	nvarchar	8	0	OOCR			Allow NULL?
84	OverCode3	Loading Factor Code 3	nvarchar	8	0	OOCR			Allow NULL?
85	OverCode4	Loading Factor Code 4	nvarchar	8	0	OOCR			Allow NULL?
86	DfltTax	Default Tax Code	nvarchar	8	0	OSTC			Allow NULL?
87	TaxPostAcc	Default Tax Posting Account	char	1	0		N	N, P, R	Allow NULL?
88	AcctStrLe	Account Structure Level	nvarchar	2	0				Allow NULL?
89	MeaUnit	Measurement Unit	nvarchar	10	0				Allow NULL?
90	BalDirect	Direction of Balance	nvarchar	4	0		0	0, 1, 2	Allow NULL?
91	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
92	PlngLevel	B1i Info for Integration	nvarchar	2	0				Allow NULL?
93	MultiLink	Allow Multiple Linking	char	1	0		N	N, Y	Allow NULL?
94	PrjRelvnt	Project Relevant	char	1	0		N	N, Y	Allow NULL?
95	Dim1Relvnt	Dimension 1 Relevant	char	1	0		N	N, Y	Allow NULL?
96	Dim2Relvnt	Dimension 2 Relevant	char	1	0		N	N, Y	Allow NULL?
97	Dim3Relvnt	Dimension 3 Relevant	char	1	0		N	N, Y	Allow NULL?
98	Dim4Relvnt	Dimension 4 Relevant	char	1	0		N	N, Y	Allow NULL?
99	Dim5Relvnt	Dimension 5 Relevant	char	1	0		N	N, Y	Allow NULL?
100	AccrualTyp	Accrual Type	char	1	0		N	C, I, N, P	Allow NULL?
101	DatevAcct	DATEV Account	int	11	0				Allow NULL?
102	DatevAutoA	DATEV Automatic Account	char	1	0		N	N, Y	Allow NULL?
103	DatevFirst	First Data Entry	char	1	0		Y	N, Y	Allow NULL?
104	SnapShotId	Snapshot ID	int	11	0		0		Allow NULL?
105	PCN874Rpt	PCN 874 Report Relevant	char	1	0		N	N, Y	Allow NULL?
106	BPLId	Assigned Branch	int	11	0	OBPL			Allow NULL?
107	BPLName	Branch Name	nvarchar	100	0				Allow NULL?
108	VATRegNum	VAT Reg. Number	nvarchar	32	0				Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	AcctCode
INTER_KEY	No	No	FatherNum
CURRENCY	No	No	ActCurr
FORMAT	No	No	FormatCode
COUNTER	No	No	Counter

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

108 COLUMNS | 5 INDEXES | B1 8.82 | OACT TABLE

TOP B1 8.82 | OACT COLUMNS

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

108 COLUMNS | 5 INDEXES | B1 8.82 | OACT TABLE

TOPB1 8.82 | OACT COLUMNS

TOPB1 8.82 | OACT INDEXES

TOP B1 8.82 | OACT COLUMNS

TOP B1 8.82 | OACT INDEXES