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	9.3	ADS1	79	1	House Bank Accounts	Banking

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	BankCode	Bank Code	nvarchar	30	0				Allow NULL?
2	Account	Acct No.	nvarchar	50	0				Allow NULL?
3	Branch	Branch	nvarchar	50	0				Allow NULL?
4	NextCheck	Next Check No.	int	11	0				Allow NULL?
5	GLAccount	G/L Account	nvarchar	15	0	OACT			Allow NULL?
6	Free	Free	char	1	0				Allow NULL?
7	Street	Street	nvarchar	100	0				Allow NULL?
8	Block	Block	nvarchar	100	0				Allow NULL?
9	ZipCode	Zip Code	nvarchar	20	0				Allow NULL?
10	City	City	nvarchar	100	0				Allow NULL?
11	County	County	nvarchar	100	0				Allow NULL?
12	Country	Country	nvarchar	3	0	OCRY			Allow NULL?
13	State	State	nvarchar	3	0	OCST			Allow NULL?
14	BISR	BISR	char	1	0		N	N=No, Y=Yes	Allow NULL?
15	ControlKey	Control Key	nvarchar	2	0				Allow NULL?
16	UsrNumber1	User No. 1	nvarchar	25	0				Allow NULL?
17	UsrNumber2	User No. 2	nvarchar	25	0				Allow NULL?
18	UsrNumber3	User No. 3	nvarchar	25	0				Allow NULL?
19	UsrNumber4	User No. 4	nvarchar	25	0				Allow NULL?
20	IBAN	IBAN	nvarchar	50	0				Allow NULL?
21	DscountBOE	Debt of Discounted BoE	nvarchar	15	0	OACT			Allow NULL?
22	TolrnceDay	Tolerance Days	int	11	0				Allow NULL?
23	MinAmntBOE	Min. Amount of Bill of Exchange	num	19	6				Allow NULL?
24	MaxAmntBOE	Max. Amount of Bill of Exchange	num	19	6				Allow NULL?
25	DscntLimit	Discount Limit	num	19	6				Allow NULL?
26	DaysInAdva	Days in Advance	int	11	0				Allow NULL?
27	BankCollec	Bank on Collection	nvarchar	15	0	OACT			Allow NULL?
28	BankDiscou	Bank on Discounted	nvarchar	15	0	OACT			Allow NULL?
29	BranchName	Branch Name	nvarchar	50	0				Allow NULL?
30	AliasName	Alias Name	nvarchar	50	0				Allow NULL?
31	CompanyCod	Company Code	nvarchar	10	0				Allow NULL?
32	AcctType	Account Type	char	1	0				Allow NULL?
33	Building	Building/Floor/Room	text	16	0
34	BIK	BIK	nvarchar	15	0				Allow NULL?
35	AcctName	Bank Account Name	nvarchar	250	0				Allow NULL?
36	CorresAcct	Correspondent Account	nvarchar	30	0				Allow NULL?
37	Phone	Telephone No.	nvarchar	25	0				Allow NULL?
38	Fax	Fax	nvarchar	25	0				Allow NULL?
39	GLIntriAct	G/L Interim Account	nvarchar	15	0	OACT			Allow NULL?
40	ChkPaper	Paper Type	char	1	0		D	B=Blank Paper, D=Default, P=Overflow Blank Paper, S=Overflow Prenumbered Check Stock	Allow NULL?
41	MaxChkLine	Maximum Lines	int	6	0				Allow NULL?
42	TmpltName	Template Name	nvarchar	8	0				Allow NULL?
43	AbsEntry	Internal Number	int	11	0				Allow NULL?
44	BankKey	Bank ID	int	11	0	ODSC			Allow NULL?
45	LockChk	Lock Checks Printing	char	1	0		N	N=No, Y=Yes	Allow NULL?
46	OurNum	Our Number in Next Boleto	int	11	0				Allow NULL?
47	AgreeNum	Agreement Number	nvarchar	10	0				Allow NULL?
48	AccountChk	Account Check Digit	char	1	0				Allow NULL?
49	ISRType	ISR Type	int	6	0		2	1=ISR, 2=BISR, 3=ISR+, 4=BISR+	Allow NULL?
50	ISRBillerI	ISR Biller ID	nvarchar	9	0				Allow NULL?
51	CustIdNum	Customer ID Number	nvarchar	10	0		0		Allow NULL?
52	InSeri	Incoming Payment Series	int	11	0	NNM1	-1		Allow NULL?
53	OutSeri	Outgoing Payment Series	int	11	0	NNM1	-1		Allow NULL?
54	JDTSeri	Journal Entry Series	int	11	0	NNM1	-1		Allow NULL?
55	FilePlug	Import File Name	nvarchar	50	0				Allow NULL?
56	ImpStmt	Imported Bank Statement	char	1	0		N	N=Create New - Manually, Y=Create New - From File	Allow NULL?
57	PreNumber	Prenumbered Check	char	1	0		Y	N=No, Y=Yes	Allow NULL?
58	AddrType	Address Type	nvarchar	100	0				Allow NULL?
59	StreetNo	Street No.	nvarchar	100	0				Allow NULL?
60	LogInstanc	Log Instance	int	11	0		0		Allow NULL?
61	UpdateDate	Date of Update	date	8	0
62	UsrLogSign	User Signature	int	6	0	OUSR			Allow NULL?
63	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
64	SwiftNum	BIC/SWIFT Code	nvarchar	50	0				Allow NULL?
65	FineAcct	Fine Account	nvarchar	15	0	OACT			Allow NULL?
66	IntrstAcct	Interest Account	nvarchar	15	0	OACT			Allow NULL?
67	DscntAcct	Discount Account	nvarchar	15	0	OACT			Allow NULL?
68	SvcFeeAcct	Service Fee Account	nvarchar	15	0	OACT			Allow NULL?
69	BranchChk	Branch Check Digit	nvarchar	5	0				Allow NULL?
70	RetFile	Retorno File Format	nvarchar	50	0				Allow NULL?
71	IOFTaxAcct	IOF Tax Account	nvarchar	15	0				Allow NULL?
72	OthExpAcct	Other Expenses Account	nvarchar	15	0	OACT			Allow NULL?
73	OthIncAcct	Other Incomes Account	nvarchar	15	0	OACT			Allow NULL?
74	CollCode	Collection Code	nvarchar	50	0				Allow NULL?
75	FileSeqNNo	File Sequence Next Number	int	11	0				Allow NULL?
76	RefCoLevel	Reference Control Level	char	1	0		H	F=Hard Control with fixed length, H=Hard Control, S=Soft Control, V=Hard Control with variable length	Allow NULL?
77	RefFixLen1	Reference fixed length 1	int	6	0				Allow NULL?
78	RefFixLen2	Reference fixed length 2	int	6	0				Allow NULL?
79	Currency	Currency	nvarchar	3	0	OCRN			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

79 COLUMNS | 1 INDEXES | B1 9.3 | ADS1 TABLE

TOP B1 9.3 | ADS1 COLUMNS

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

79 COLUMNS | 1 INDEXES | B1 9.3 | ADS1 TABLE

TOPB1 9.3 | ADS1 COLUMNS

TOPB1 9.3 | ADS1 INDEXES

TOP B1 9.3 | ADS1 COLUMNS

TOP B1 9.3 | ADS1 INDEXES