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
Banking
1	Business One	8.82	ODPS	62	3	Deposit	Banking

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DeposId	Payment Internal ID	int	11	0		0		Allow NULL?
2	DeposType	Payment Type	char	1	0		K	B, C, K, V	Allow NULL?
3	DeposNum	Payment No.	int	11	0				Allow NULL?
4	DeposDate	Payment Date	date	8	0
5	DeposCurr	Currency for Payments	nvarchar	3	0				Allow NULL?
6	BanckAcct	Deposit Account	nvarchar	15	0				Allow NULL?
7	DeposAcct	Bank Account Number	nvarchar	50	0				Allow NULL?
8	DeposBrnch	Branch for Payments	nvarchar	50	0				Allow NULL?
9	Memo	Details	nvarchar	250	0				Allow NULL?
10	LocTotal	Total (LC)	num	19	6				Allow NULL?
11	FcTotal	Total (FC)	num	19	6				Allow NULL?
12	SysTotal	Total (SC)	num	19	6				Allow NULL?
13	TransAbs	Journal Entry Key	int	11	0	OJDT			Allow NULL?
14	Ref1	Reference 1	nvarchar	11	0				Allow NULL?
15	Ref2	Reference 2	nvarchar	11	0				Allow NULL?
16	DocTime	Pay-In Time	int	6	0				Allow NULL?
17	AllocAcct	Cash	nvarchar	15	0				Allow NULL?
18	ChkType	Check Deposit Type	char	1	0		C	C, S	Allow NULL?
19	DpsBank	Bank Name for Payments	nvarchar	30	0				Allow NULL?
20	DpostorNam	Name of Depositor	nvarchar	30	0				Allow NULL?
21	Printed	Original/Copy	char	1	0		N	N, Y	Allow NULL?
22	DocRate	Payment Rate	num	19	6				Allow NULL?
23	CrdBankAct	Voucher Account	nvarchar	15	0				Allow NULL?
24	IsCard	Business Partner or Account	char	1	0		A	A, C	Allow NULL?
25	Transfered	Year Transfer	char	1	0		N	N, Y	Allow NULL?
26	UpdateDate	Date of Update	date	8	0
27	Splited	Split	char	1	0		N	N, Y	Allow NULL?
28	CreateDate	Creation Date	date	8	0
29	VatAct	Tax Account	nvarchar	15	0				Allow NULL?
30	ComissAct	Commissions Account	nvarchar	15	0				Allow NULL?
31	VatTotal	Total Tax	num	19	6				Allow NULL?
32	Comission	Commission	num	19	6				Allow NULL?
33	ComissDate	Commission Date	date	8	0
34	TaxDate	Document Date	date	8	0
35	Series	Series	int	6	0				Allow NULL?
36	DataSource	Data Source	char	1	0		N	A, D, I, M, N, O, P, T, U	Allow NULL?
37	ObjType	Object Type	nvarchar	20	0				Allow NULL?
38	FinncPriod	Posting Period	int	11	0	OFPR			Allow NULL?
39	VatTotlSys	Total Tax on Input (SC)	num	19	6				Allow NULL?
40	ComissnSys	Total Commission (SC)	num	19	6				Allow NULL?
41	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
42	DepostNorm	Deposit Norm	nvarchar	8	0				Allow NULL?
43	PostType	Transaction Type	char	1	0		C	C, D	Allow NULL?
44	BankCountr	Bank Country	nvarchar	3	0	OCRY			Allow NULL?
45	Canceled	Canceled	char	1	0		N	N, Y	Allow NULL?
46	CnclDps	Cancel Deposit	int	11	0		-1		Allow NULL?
47	CommisVat	Commission VAT Group	nvarchar	8	0	OVTG			Allow NULL?
48	SeqCode	Sequence Code	int	6	0				Allow NULL?
49	Serial	Serial Number	int	11	0				Allow NULL?
50	SeriesStr	Series String	nvarchar	3	0				Allow NULL?
51	SubStr	Subseries String	nvarchar	3	0				Allow NULL?
52	Project	Project Code	nvarchar	20	0	OPRJ			Allow NULL?
53	ReconAfter	Reconcile Amounts After Dpst	char	1	0		Y		Allow NULL?
54	OcrCode	Distribution Rule	nvarchar	8	0	OOCR			Allow NULL?
55	OcrCode2	Distribution Rule 2	nvarchar	8	0	OOCR			Allow NULL?
56	OcrCode3	Distribution Rule 3	nvarchar	8	0	OOCR			Allow NULL?
57	OcrCode4	Distribution Rule 4	nvarchar	8	0	OOCR			Allow NULL?
58	OcrCode5	Distribution Rule 5	nvarchar	8	0	OOCR			Allow NULL?
59	ComisFC	Total Commission (FC)	num	19	6				Allow NULL?
60	VatTotlFC	Total Tax on Input (FC)	num	19	6				Allow NULL?
61	ComisCurr	Commission Currency	nvarchar	3	0				Allow NULL?
62	SupplCode	Supplementary Code	nvarchar	254	0				Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	DeposId
VIS_NUM	No	No	DeposNum
SERIES	No	No	Series

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

62 COLUMNS | 3 INDEXES | B1 8.82 | ODPS TABLE

TOP B1 8.82 | ODPS COLUMNS

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

62 COLUMNS | 3 INDEXES | B1 8.82 | ODPS TABLE

TOPB1 8.82 | ODPS COLUMNS

TOPB1 8.82 | ODPS INDEXES

TOP B1 8.82 | ODPS COLUMNS

TOP B1 8.82 | ODPS INDEXES