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
Marketing Documents
1	Business One	9.3	ADO11	70	1	A/R Inv (Drawn Dpm Det) - Hist	Marketing Documents

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Document Internal ID	int	11	0	ADOC			Allow NULL?
2	LineNum	Row Number	int	11	0				Allow NULL?
3	LineSeq	Sequence Number	int	11	0				Allow NULL?
4	BaseAbs	Base Document Internal ID	int	11	0				Allow NULL?
5	BaseType	Base Object Type	int	11	0		-1	-1	Allow NULL?
6	VatGroup	VAT Group Code	nvarchar	8	0	OVTG			Allow NULL?
7	VatPrcnt	VAT Percent	num	19	6				Allow NULL?
8	LineTotal	Net LC	num	19	6				Allow NULL?
9	TotalFrgn	Net FC	num	19	6				Allow NULL?
10	TotalSumSy	Net SC	num	19	6				Allow NULL?
11	VatSum	Tax LC	num	19	6				Allow NULL?
12	VatSumFrgn	Tax FC	num	19	6				Allow NULL?
13	VatSumSys	Tax SC	num	19	6				Allow NULL?
14	ObjType	Object Type	nvarchar	20	0	ADP1	13		Allow NULL?
15	LogInstanc	Log Instance	int	11	0				Allow NULL?
16	IsAcq	Acquisition Tax Liable	char	1	0		N	N=No, Y=Yes	Allow NULL?
17	IsAllDrawn	Remaining Amount Drawn	char	1	0		N	N=No, Y=Yes	Allow NULL?
18	IsGross	Is Gross Line	char	1	0		N	N=Net Line, Y=Gross Line	Allow NULL?
19	Gross	Gross LC	num	19	6				Allow NULL?
20	GrossFc	Gross FC	num	19	6				Allow NULL?
21	GrossSc	Gross SC	num	19	6				Allow NULL?
22	ApplNet	Applied Net LC	num	19	6				Allow NULL?
23	ApplNetFc	Applied Net FC	num	19	6				Allow NULL?
24	ApplNetSc	Applied Net SC	num	19	6				Allow NULL?
25	ApplVat	Applied Tax LC	num	19	6				Allow NULL?
26	ApplVatFc	Applied Tax FC	num	19	6				Allow NULL?
27	ApplVatSc	Applied Tax SC	num	19	6				Allow NULL?
28	BaseNet	Base Net LC	num	19	6				Allow NULL?
29	BaseNetFc	Base Net FC	num	19	6				Allow NULL?
30	BaseNetSc	Base Net SC	num	19	6				Allow NULL?
31	BaseVat	Base Tax LC	num	19	6				Allow NULL?
32	BaseVatFc	Base Tax FC	num	19	6				Allow NULL?
33	BaseVatSc	Base Tax SC	num	19	6				Allow NULL?
34	BaseGross	Base Gross LC	num	19	6				Allow NULL?
35	BaseGrossF	Base Gross FC	num	19	6				Allow NULL?
36	BaseGrossS	Base Gross SC	num	19	6				Allow NULL?
37	LineType	Line Type	char	1	0		D	D=Document Row, H=Down Payment Document Rounding, R=Currency Rounding	Allow NULL?
38	DctSum	Deductible Sum LC	num	19	6				Allow NULL?
39	DctSumFc	Deductible Sum FC	num	19	6				Allow NULL?
40	DctSumSc	Deductible Sum SC	num	19	6				Allow NULL?
41	EqSum	Equalization Sum LC	num	19	6				Allow NULL?
42	EqSumFc	Equalization Sum FC	num	19	6				Allow NULL?
43	EqSumSc	Equalization Sum SC	num	19	6				Allow NULL?
44	ApplDct	Applied Deductible Sum LC	num	19	6				Allow NULL?
45	ApplDctFc	Applied Deductible Sum FC	num	19	6				Allow NULL?
46	ApplDctSc	Applied Deductible Sum SC	num	19	6				Allow NULL?
47	ApplEq	Applied Equalization Sum LC	num	19	6				Allow NULL?
48	ApplEqFc	Applied Equalization Sum FC	num	19	6				Allow NULL?
49	ApplEqSc	Applied Equalization Sum SC	num	19	6				Allow NULL?
50	BaseDct	Base Deductible Sum LC	num	19	6				Allow NULL?
51	BaseDctFc	Base Deductible Sum FC	num	19	6				Allow NULL?
52	BaseDctSc	Base Deductible Sum SC	num	19	6				Allow NULL?
53	BaseEq	Base Equalization Sum LC	num	19	6				Allow NULL?
54	BaseEqFc	Base Equalization Sum FC	num	19	6				Allow NULL?
55	BaseEqSc	Base Equalization Sum SC	num	19	6				Allow NULL?
56	TaxCode	Tax Code	nvarchar	8	0	OSTC			Allow NULL?
57	ApplGross	Applied Gross LC	num	19	6				Allow NULL?
58	ApplGrossF	Applied Gross FC	num	19	6				Allow NULL?
59	ApplGrossS	Applied Gross SC	num	19	6				Allow NULL?
60	TaxAdjust	Manual Tax Adjustment	char	1	0		N	N=No, Y=Yes	Allow NULL?
61	RvsChrgSum	Reverse Charge Sum LC	num	19	6				Allow NULL?
62	RvsChrgFc	Reverse Charge Sum FC	num	19	6				Allow NULL?
63	RvsChrgSc	Reverse Charge Sum SC	num	19	6				Allow NULL?
64	BasRvsChrg	Base Reverse Charge LC	num	19	6				Allow NULL?
65	BasRvsFc	Base Reverse Charge FC	num	19	6				Allow NULL?
66	BasRvsSc	Base Reverse Charge SC	num	19	6				Allow NULL?
67	ApplRvs	Applied Reverse Charge LC	num	19	6				Allow NULL?
68	ApplRvsFc	Applied Reverse Charge FC	num	19	6				Allow NULL?
69	ApplRvsSc	Applied Reverse Charge SC	num	19	6				Allow NULL?
70	IsCstmAct	Apply Customer Accounting Tax Rule	char	1	0		N	N=No, Y=Yes	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

70 COLUMNS | 1 INDEXES | B1 9.3 | ADO11 TABLE

TOP B1 9.3 | ADO11 COLUMNS

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

70 COLUMNS | 1 INDEXES | B1 9.3 | ADO11 TABLE

TOPB1 9.3 | ADO11 COLUMNS

TOPB1 9.3 | ADO11 INDEXES

TOP B1 9.3 | ADO11 COLUMNS

TOP B1 9.3 | ADO11 INDEXES