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	9.3	OACT	123	6	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	char	1	0		N	N=No, Y=Yes	Allow NULL?
6	Groups	Main Group	nvarchar	8	0				Allow NULL?
7	Budget	Budget	char	1	0		N	N=No, Y=Yes	Allow NULL?
8	Frozen	Account on Hold [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
9	Free_2	Free 2	char	1	0				Allow NULL?
10	Postable	Account [Active/Title]	char	1	0		Y	N=Title Account, Y=Active Account	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	15	0				Allow NULL?
17	CashBox	Capital Account [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
18	GroupMask	Group Mask	int	6	0		1		Allow NULL?
19	RateTrans	For Conversion Differences	char	1	0		Y	N=No, Y=Yes	Allow NULL?
20	TaxIncome	Tax Definition	char	1	0		N	N=No, Y=Yes	Allow NULL?
21	ExmIncome	Tax Definition	char	1	0		N	N=No, Y=Yes	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 Type	char	1	0		N	E=Expenditure, I=Sales, N=Other	Allow NULL?
25	Transfered	Year Transfer [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
26	BlncTrnsfr	Balances Transferred [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
27	OverType	Loading Type	char	1	0		N	N=None, Y=Yes	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=No, Y=Yes	Allow NULL?
31	ActCurr	Account Currency	nvarchar	3	0	OCRN			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	Confidential Account	char	1	0		N	N=No, Y=Yes	Allow NULL?
36	RealAcct	Indexed Account	char	1	0		N	N=No, Y=Yes	Allow NULL?
37	Advance	Advance Payments	char	1	0		Y	N=No, Y=Yes	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	char	1	0		N	N=No, Y=Yes	Allow NULL?
45	DataSource	Data Source	char	1	0		N	A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
46	LocMth	LC Reconciliation	char	1	0		Y	N=No, Y=Yes	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	Control Account	char	1	0		N	N=No, Y=Yes	Allow NULL?
51	LogInstanc	Log Instance	int	11	0		0		Allow NULL?
52	ObjType	Object Type	nvarchar	20	0	ADP1	1		Allow NULL?
53	ValidFor	Active	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
74	ExchRate	Exchange Rate Differences	char	1	0		Y	N=No, Y=Yes	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=No, Y=Yes	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=Purchasing Tax Account, R=Sales Tax Account	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=Credit, 2=Debit	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=No, Y=Yes	Allow NULL?
94	PrjRelvnt	Project Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
95	Dim1Relvnt	Dimension 1 Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
96	Dim2Relvnt	Dimension 2 Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
97	Dim3Relvnt	Dimension 3 Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
98	Dim4Relvnt	Dimension 4 Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
99	Dim5Relvnt	Dimension 5 Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
100	AccrualTyp	Accrual Type	char	1	0		N	C=Calculation Account, I=Calculation Interim Account, N=None, P=Posting Account	Allow NULL?
101	DatevAcct	DATEV Account	nvarchar	8	0				Allow NULL?
102	DatevAutoA	DATEV Automatic Account	char	1	0		N	N=No, Y=Yes	Allow NULL?
103	DatevFirst	First Data Entry	char	1	0		Y	N=No, Y=Yes	Allow NULL?
104	SnapShotId	Snapshot ID	int	11	0		0		Allow NULL?
105	PCN874Rpt	PCN 874 Report Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
106	SCAdjust	SC Adjustment	char	1	0		N	N=No, Y=Yes	Allow NULL?
107	BPLId	Assigned Branch	int	11	0	OBPL			Allow NULL?
108	BPLName	Branch Name	nvarchar	100	0				Allow NULL?
109	SubLedgerN	Subledger No.	nvarchar	60	0				Allow NULL?
110	VATRegNum	VAT Reg. Number	nvarchar	32	0				Allow NULL?
111	ActId	Account Identifier	nvarchar	210	0				Allow NULL?
112	ClosingAcc	G/L Account Closing	nvarchar	15	0				Allow NULL?
113	PurpCode	Account Purpose Code	nvarchar	2	0			01=Contas de ativo, 02=Contas de Passivo, 03=Patrimônio Líquido, 04=Contas de Resultado, 05=Contas de Compensação, 09=Outras	Allow NULL?
114	RefCode	Referential Account Code	nvarchar	30	0				Allow NULL?
115	BlocManPos	Block Manual Posting	char	1	0		N	N=No, Y=Yes	Allow NULL?
116	PriAccCode	Primary Closing Account	nvarchar	15	0	OACT			Allow NULL?
117	CstAccOnly	Cost Account Only	char	1	0		N	N=NO, Y=YES	Allow NULL?
118	AlloweFrom	Account Balance Allowed From	num	19	6				Allow NULL?
119	AllowedTo	Account Balance Allowed To	num	19	6				Allow NULL?
120	BalanceA	Account Balance Allowed	char	1	0		N	N=NO, Y=YES	Allow NULL?
121	RmrkTmpt	Remark Text Template	int	11	0	OTTR			Allow NULL?
122	CemRelvnt	Cost Element Relevant	char	1	0		N	N=No, Y=Yes	Allow NULL?
123	CemCode	Cost Element Code	nvarchar	20	0	OCEM			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
IDENTIFIER	No	Yes	ActId

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

123 COLUMNS | 6 INDEXES | B1 9.3 | OACT TABLE

TOP B1 9.3 | OACT COLUMNS

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

123 COLUMNS | 6 INDEXES | B1 9.3 | OACT TABLE

TOPB1 9.3 | OACT COLUMNS

TOPB1 9.3 | OACT INDEXES

TOP B1 9.3 | OACT COLUMNS

TOP B1 9.3 | OACT INDEXES