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
Inventory and Production
1	Business One	9.3	AIT13	67	1	Asset Attributes	Inventory and Production

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	SQL Create Statement
1	ItemCode	Item No.	nvarchar	50	0	OITM		Allow NULL?
2	AttriTxt1	Attribute 1	nvarchar	100	0			Allow NULL?
3	AttriTxt2	Attribute 2	nvarchar	100	0			Allow NULL?
4	AttriTxt3	Attribute 3	nvarchar	100	0			Allow NULL?
5	AttriTxt4	Attribute 4	nvarchar	100	0			Allow NULL?
6	AttriTxt5	Attribute 5	nvarchar	100	0			Allow NULL?
7	AttriTxt6	Attribute 6	nvarchar	100	0			Allow NULL?
8	AttriTxt7	Attribute 7	nvarchar	100	0			Allow NULL?
9	AttriTxt8	Attribute 8	nvarchar	100	0			Allow NULL?
10	AttriTxt9	Attribute 9	nvarchar	100	0			Allow NULL?
11	AttriTxt10	Attribute 10	nvarchar	100	0			Allow NULL?
12	AttriTxt11	Attribute 11	nvarchar	100	0			Allow NULL?
13	AttriTxt12	Attribute 12	nvarchar	100	0			Allow NULL?
14	AttriTxt13	Attribute 13	nvarchar	100	0			Allow NULL?
15	AttriTxt14	Attribute 14	nvarchar	100	0			Allow NULL?
16	AttriTxt15	Attribute 15	nvarchar	100	0			Allow NULL?
17	AttriTxt16	Attribute 16	nvarchar	100	0			Allow NULL?
18	AttriTxt17	Attribute 17	nvarchar	100	0			Allow NULL?
19	AttriTxt18	Attribute 18	nvarchar	100	0			Allow NULL?
20	AttriTxt19	Attribute 19	nvarchar	100	0			Allow NULL?
21	AttriTxt20	Attribute 20	nvarchar	100	0			Allow NULL?
22	AttriTxt21	Attribute 21	nvarchar	100	0			Allow NULL?
23	AttriTxt22	Attribute 22	nvarchar	100	0			Allow NULL?
24	AttriTxt23	Attribute 23	nvarchar	100	0			Allow NULL?
25	AttriTxt24	Attribute 24	nvarchar	100	0			Allow NULL?
26	AttriTxt25	Attribute 25	nvarchar	100	0			Allow NULL?
27	AttriTxt26	Attribute 26	nvarchar	100	0			Allow NULL?
28	AttriTxt27	Attribute 27	nvarchar	100	0			Allow NULL?
29	AttriTxt28	Attribute 28	nvarchar	100	0			Allow NULL?
30	AttriTxt29	Attribute 29	nvarchar	100	0			Allow NULL?
31	AttriTxt30	Attribute 30	nvarchar	100	0			Allow NULL?
32	AttriTxt31	Attribute 31	nvarchar	100	0			Allow NULL?
33	AttriTxt32	Attribute 32	nvarchar	100	0			Allow NULL?
34	AttriInt33	Attribute 33	int	11	0			Allow NULL?
35	AttriInt34	Attribute 34	int	11	0			Allow NULL?
36	AttriInt35	Attribute 35	int	11	0			Allow NULL?
37	AttriInt36	Attribute 36	int	11	0			Allow NULL?
38	AttriInt37	Attribute 37	int	11	0			Allow NULL?
39	AttriInt38	Attribute 38	int	11	0			Allow NULL?
40	AttriInt39	Attribute 39	int	11	0			Allow NULL?
41	AttriInt40	Attribute 40	int	11	0			Allow NULL?
42	AttriInt41	Attribute 41	int	11	0			Allow NULL?
43	AttriInt42	Attribute 42	int	11	0			Allow NULL?
44	AttriDt43	Attribute 43	date	8	0
45	AttriDt44	Attribute 44	date	8	0
46	AttriDt45	Attribute 45	date	8	0
47	AttriDt46	Attribute 46	date	8	0
48	AttriDt47	Attribute 47	date	8	0
49	AttriAm48	Attribute 48	num	19	6			Allow NULL?
50	AttriAm49	Attribute 49	num	19	6			Allow NULL?
51	AttriAm50	Attribute 50	num	19	6			Allow NULL?
52	AttriAm51	Attribute 51	num	19	6			Allow NULL?
53	AttriAm52	Attribute 52	num	19	6			Allow NULL?
54	AttriAm53	Attribute 53	num	19	6			Allow NULL?
55	AttriAm54	Attribute 54	num	19	6			Allow NULL?
56	AttriPr55	Attribute 55	num	19	6			Allow NULL?
57	AttriPr56	Attribute 56	num	19	6			Allow NULL?
58	AttriPr57	Attribute 57	num	19	6			Allow NULL?
59	AttriPr58	Attribute 58	num	19	6			Allow NULL?
60	AttriPr59	Attribute 59	num	19	6			Allow NULL?
61	AttriQTY60	Attribute 60	num	19	6			Allow NULL?
62	AttriQTY61	Attribute 61	num	19	6			Allow NULL?
63	AttriQTY62	Attribute 62	num	19	6			Allow NULL?
64	AttriQTY63	Attribute 63	num	19	6			Allow NULL?
65	AttriQTY64	Attribute 64	num	19	6			Allow NULL?
66	LogInstanc	Log Instance	int	11	0		0	Allow NULL?
67	ObjType	Object	nvarchar	20	0	ADP1	4	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

67 COLUMNS | 1 INDEXES | B1 9.3 | AIT13 TABLE

TOP B1 9.3 | AIT13 COLUMNS

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

67 COLUMNS | 1 INDEXES | B1 9.3 | AIT13 TABLE

TOPB1 9.3 | AIT13 COLUMNS

TOPB1 9.3 | AIT13 INDEXES

TOP B1 9.3 | AIT13 COLUMNS

TOP B1 9.3 | AIT13 INDEXES