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	ABOE	92	5	Bill of Exchange for Payment - History	Banking

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	BoeKey	Bill of Exchange Key	int	11	0				Allow NULL?
2	BoeNum	Bill of Exchange No.	int	11	0				Allow NULL?
3	BoeStatus	Bill of Exchange Status	char	1	0			C=Canceled, D=Deposited, F=Failed, G=Generated, L=Closed, P=Paid, S=Sent, V=BoE to Vendor	Allow NULL?
4	BoeType	Bill of Exchange Type	char	1	0		I	I=Incoming, O=Outgoing	Allow NULL?
5	DpsBankCod	Deposit Bank Code	nvarchar	30	0				Allow NULL?
6	DpsCntrCod	Deposit Country Code	nvarchar	3	0	OCRY			Allow NULL?
7	DueDate	Bill of Exchange Due Date	date	8	0
8	DpstAcct	Bank Account No.	nvarchar	50	0				Allow NULL?
9	DpstBranch	Branch for Payments	nvarchar	50	0				Allow NULL?
10	Details	Details	nvarchar	50	0				Allow NULL?
11	TransRef	Journal Entry Reference	nvarchar	8	0				Allow NULL?
12	PmntDate	Payment Date	date	8	0
13	PmntNum	Payment No.	int	11	0				Allow NULL?
14	BoeSum	Bill of Exchange Amount	num	19	6				Allow NULL?
15	BoeSumSC	Bill of Exchange Amount (SC)	num	19	6				Allow NULL?
16	BoeSumFC	Bill of Exchange Amount (FC)	num	19	6				Allow NULL?
17	CardCode	BP Code	nvarchar	15	0	OCRD			Allow NULL?
18	CardName	BP Name	nvarchar	100	0				Allow NULL?
19	BoeAcct	BP Account Code	nvarchar	15	0	OACT			Allow NULL?
20	Currency	Bill of Exchange Currency	nvarchar	3	0	OCRN			Allow NULL?
21	Printed	Printed	char	1	0		N	N=No, Y=Yes	Allow NULL?
22	TotalWords	Total in Words	nvarchar	100	0				Allow NULL?
23	Signature	Signature	nvarchar	155	0				Allow NULL?
24	TransNum	Transaction No.	int	11	0		0		Allow NULL?
25	LinesSum	Row Totals	num	19	6				Allow NULL?
26	DdctPrcnt	% Withholding Tax Ded.	num	19	6				Allow NULL?
27	Address	Address	nvarchar	254	0				Allow NULL?
28	UpdateDate	Date of Update	date	8	0
29	CreateDate	Creation Date	date	8	0
30	VatTotal	Total Tax	num	19	6				Allow NULL?
31	VatTotalSC	Total Tax (SC)	num	19	6				Allow NULL?
32	VatTotalFC	Total Tax (FC)	num	19	6				Allow NULL?
33	VatCalcult	Calculate Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
34	TaxDate	Document Date	date	8	0
35	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=Upgrade	Allow NULL?
36	SumRfndCln	Deduction Refund Amount	num	19	6				Allow NULL?
37	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
38	PrintedBy	Printed By	int	6	0				Allow NULL?
39	Transfered	Transferred to next year	char	1	0		N	N=No, Y=Yes	Allow NULL?
40	Instance	Instance	int	6	0		0		Allow NULL?
41	LogInstanc	Log Instance	int	11	0		0		Allow NULL?
42	BPBankCod	BP Bank Code	nvarchar	30	0				Allow NULL?
43	BPBankNam	BP Bank Name	nvarchar	250	0				Allow NULL?
44	BPBankAct	BP Bank Account	nvarchar	50	0				Allow NULL?
45	BPBankBrnc	BP Bank Branch	nvarchar	50	0				Allow NULL?
46	BPBankCtr	BP Bank Country	nvarchar	3	0	OCRY			Allow NULL?
47	RefNum	Reference No.	nvarchar	254	0				Allow NULL?
48	IsReconcld	Reconciled	char	1	0		N	N=No, Y=Yes	Allow NULL?
49	Comments	Remarks	nvarchar	254	0				Allow NULL?
50	PayMethCod	Payment Method Code	nvarchar	15	0	OPYM			Allow NULL?
51	DepositNum	Deposit Number	int	11	0				Allow NULL?
52	PymMethNam	Payment Method Name	nvarchar	100	0				Allow NULL?
53	DeductSum	Deduction Amount	num	19	6				Allow NULL?
54	ControlKey	Control Key	nvarchar	2	0				Allow NULL?
55	AgentCode	Agent Code	nvarchar	32	0	OAGP			Allow NULL?
56	ReconcilNu	External Reconciliation No.	int	11	0				Allow NULL?
57	DepositTyp	Deposit Type	char	1	0			C=Collection, D=Discounted	Allow NULL?
58	CreatStatu	Creation Status	char	1	0			G=Generated, S=Sent	Allow NULL?
59	Ref2	Reference 2	nvarchar	254	0				Allow NULL?
60	PayEngSt1	Payment Engine Status 1	char	1	0				Allow NULL?
61	PayEngSt2	Payment Engine Status 2	char	1	0				Allow NULL?
62	PayEngSt3	Payment Engine Status 3	nvarchar	3	0				Allow NULL?
63	StampTax	Stamp Tax Code	nvarchar	8	0	OVTG			Allow NULL?
64	StmpTxAmnt	Stamp Tax Amount	num	19	6				Allow NULL?
65	DpsActKey	Bank Account Internal ID	int	11	0	DSC1			Allow NULL?
66	OutBnkKey	Outgoing Bank Account Key	int	11	0	DSC1			Allow NULL?
67	Portfolio	Portfolio	nvarchar	8	0	OPFT			Allow NULL?
68	VndCodeCEE	Vendor Code	nvarchar	15	0	OCRD			Allow NULL?
69	VndNameCEE	Vendor Name	nvarchar	100	0				Allow NULL?
70	OurNum	Our Number	int	11	0				Allow NULL?
71	BarcodeNum	Bar Code Number	nvarchar	120	0				Allow NULL?
72	BarcodeRep	Bar Code Representation	nvarchar	100	0				Allow NULL?
73	OurNumChk	Our Number Check Digit	char	1	0				Allow NULL?
74	FolioPref	Folio Prefix String	nvarchar	4	0				Allow NULL?
75	FolioNum	Folio Number	int	11	0				Allow NULL?
76	LPgFolioN	Folio No. for Last Page in Doc.	int	11	0				Allow NULL?
77	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
78	IntrstAmnt	Interest Amount	num	19	6				Allow NULL?
79	DiscAmnt	Discount Amount	num	19	6				Allow NULL?
80	FineAmnt	Fine Amount	num	19	6				Allow NULL?
81	IntrstDate	BoE Interest Date	date	8	0
82	DiscDate	BoE Discount Date	date	8	0
83	FineDate	BoE Fine Date	date	8	0
84	PostType	Posting Type	char	1	0			A=Alternative, D=Default	Allow NULL?
85	IOFAmnt	IOF Amount	num	19	6				Allow NULL?
86	ServFeeAm	Service Fee Amount	num	19	6				Allow NULL?
87	OtherExAm	Other Expenses Amount	num	19	6				Allow NULL?
88	OtherInAm	Other Incomes Amount	num	19	6				Allow NULL?
89	BPLId	Branch	int	11	0	OBPL			Allow NULL?
90	EnBPBnkAct	Encryption of BP Bank Account	text	16	0
91	EncryptIV	Encrypt IV	nvarchar	100	0				Allow NULL?
92	DPPStatus	Data Protection Status	char	1	0		N	D=Erased, N=None	Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	BoeKey, LogInstanc
VPM_NUM	No	No	PmntNum
TRANS_NUM	No	No	TransNum
DPS_NUM	No	No	DepositNum
BOE_NUM	No	Yes	BoeNum, BoeType, LogInstanc

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

92 COLUMNS | 5 INDEXES | B1 9.3 | ABOE TABLE

TOP B1 9.3 | ABOE COLUMNS

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

92 COLUMNS | 5 INDEXES | B1 9.3 | ABOE TABLE

TOPB1 9.3 | ABOE COLUMNS

TOPB1 9.3 | ABOE INDEXES

TOP B1 9.3 | ABOE COLUMNS

TOP B1 9.3 | ABOE INDEXES