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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Marketing Documents
1	Business One	9.2	CSV6	64	1	A/R Correction Invoice Reversal - Installments	Marketing Documents

Column	Field	Description	SQL Type	Length	Decimals	Default Value	Constraints	SQL Create Statement
1	DocEntry	Document Internal ID	int	11	0			Allow NULL?
2	InstlmntID	Installment ID	int	6	0	1		Allow NULL?
3	ObjType	Object Type	nvarchar	20	0	166		Allow NULL?
4	LogInstanc	Log Instance	int	11	0	0		Allow NULL?
5	DueDate	Due Date	date	8	0
6	Status	Installment Status	char	1	0	O	C=Closed, O=Open	Allow NULL?
7	DunnLevel	Dunning Level	int	11	0	0		Allow NULL?
8	InsTotal	Total Installment	num	19	6			Allow NULL?
9	InsTotalFC	Total Installment (FC)	num	19	6			Allow NULL?
10	InsTotalSy	Total Installment (SC)	num	19	6			Allow NULL?
11	PaidToDate	Paid to Date	num	19	6			Allow NULL?
12	PaidFC	Paid (FC)	num	19	6			Allow NULL?
13	PaidSys	Paid (SC)	num	19	6			Allow NULL?
14	VatSum	Total Tax	num	19	6			Allow NULL?
15	VatSumFC	Tax Amount (FC)	num	19	6			Allow NULL?
16	VatSumSy	Tax Amount (SC)	num	19	6			Allow NULL?
17	VatPaid	Tax Paid to Date	num	19	6			Allow NULL?
18	VatPaidFC	Tax Paid (FC)	num	19	6			Allow NULL?
19	VatPaidSys	Tax Paid (SC)	num	19	6			Allow NULL?
20	TotalExpns	Total Freight Charges	num	19	6			Allow NULL?
21	TotalExpFC	Total Freight Charges (FC)	num	19	6			Allow NULL?
22	TotalExpSC	Total Freight Charges (SC)	num	19	6			Allow NULL?
23	ExpAppl	Applied Freight Charges	num	19	6			Allow NULL?
24	ExpApplFC	Applied Freight Charges (FC)	num	19	6			Allow NULL?
25	ExpApplSC	Applied Freight Charges (SC)	num	19	6			Allow NULL?
26	WTSum	WTax Amount	num	19	6			Allow NULL?
27	WTSumFC	WTax Amount (FC)	num	19	6			Allow NULL?
28	WTSumSC	WTax Amount (SC)	num	19	6			Allow NULL?
29	WTApplied	Applied WTax	num	19	6			Allow NULL?
30	WTAppliedF	Applied WTax (FC)	num	19	6			Allow NULL?
31	WTAppliedS	Applied WTax (SC)	num	19	6			Allow NULL?
32	TotalBlck	Total Reserved Amount	num	19	6			Allow NULL?
33	TotalBlckF	Total Reserved Amount (FC)	num	19	6			Allow NULL?
34	TotalBlckS	Total Reserved Amount (SC)	num	19	6			Allow NULL?
35	VATBlck	Reserved Tax Amount	num	19	6			Allow NULL?
36	VATBlckFC	Reserved Tax Amount (FC)	num	19	6			Allow NULL?
37	VATBlckSC	Reserved Tax Amount (SC)	num	19	6			Allow NULL?
38	ExpnsBlck	Reserved Freight Amount	num	19	6			Allow NULL?
39	ExpnsBlckF	Reserved Freight Amount (FC)	num	19	6			Allow NULL?
40	ExpnsBlckS	Reserved Freight Amount (SC)	num	19	6			Allow NULL?
41	WTBlocked	Reserved WTax Amount	num	19	6			Allow NULL?
42	WTBlockedF	Reserved WTax Amount (FC)	num	19	6			Allow NULL?
43	WTBlockedS	Reserved WTax Amount (SC)	num	19	6			Allow NULL?
44	InstPrcnt	Installment %	num	19	6			Allow NULL?
45	DunWizBlck	Wizard dunning block	char	1	0	N	N=No, Y=Yes	Allow NULL?
46	DunDate	Last Dunning Date	date	8	0
47	Paid	Paid	num	19	6			Allow NULL?
48	PaidFrgn	Paid (FC)	num	19	6			Allow NULL?
49	PaidSc	Paid (SC)	num	19	6			Allow NULL?
50	reserved	Reserved	char	1	0	N	N=No, Y=Yes	Allow NULL?
51	TaxOnExp	Tax on Expenses	num	19	6			Allow NULL?
52	TaxOnExpFc	Tax on Expenses (FC)	num	19	6			Allow NULL?
53	TaxOnExpSc	Tax on Expenses (SC)	num	19	6			Allow NULL?
54	TaxOnExpAp	Applied Tax on Expenses	num	19	6			Allow NULL?
55	TaxOnExApF	Applied Tax on Expenses (FC)	num	19	6			Allow NULL?
56	TaxOnExApS	Applied Tax on Expenses (SC)	num	19	6			Allow NULL?
57	TaxOnExBlo	Reserved Tax on Freight Amount	num	19	6			Allow NULL?
58	TaxOnExBlF	Reserved Tax on Freight Amt FC	num	19	6			Allow NULL?
59	TaxOnExBlS	Reserved Tax on Freight Amt SC	num	19	6			Allow NULL?
60	LvlUpdDate	Dunning Level Update Date	date	8	0
61	Ordered	Payment Ordered	char	1	0	N	N=No, Y=Yes	Allow NULL?
62	PaidDpm	Paid by Down Payment	num	19	6			Allow NULL?
63	PaidDpmFc	Paid by Down Payment (FC)	num	19	6			Allow NULL?
64	PaidDpmSc	Paid by Down Payment (SC)	num	19	6			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

64 COLUMNS | 1 INDEXES | B1 9.2 | CSV6 TABLE

TOP B1 9.2 | CSV6 COLUMNS

TOP B1 9.2 | CSV6 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

64 COLUMNS | 1 INDEXES | B1 9.2 | CSV6 TABLE

TOPB1 9.2 | CSV6 COLUMNS

TOPB1 9.2 | CSV6 INDEXES

TOP B1 9.2 | CSV6 COLUMNS

TOP B1 9.2 | CSV6 INDEXES