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	8.82	UILM	79	4	IVI Inventory Log Message	Inventory and Production

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	MessageID	Message ID	int	11	0				Allow NULL?
2	DocEntry	Doc Number	int	11	0				Allow NULL?
3	TransType	Transaction Type	int	11	0		-1		Allow NULL?
4	DocLineNum	Doc Row Number	int	11	0				Allow NULL?
5	Quantity	Quantity in Doc	num	19	6				Allow NULL?
6	EffectQty	Stock Effective Qty	num	19	6				Allow NULL?
7	LocType	Location Type	int	6	0				Allow NULL?
8	LocCode	Location Code	nvarchar	8	0				Allow NULL?
9	TotalLC	Inventory Total LC	num	19	6				Allow NULL?
10	TotalFC	Inventory Total FC	num	19	6				Allow NULL?
11	TotalSC	Inventory Total SC	num	19	6				Allow NULL?
12	BaseAbsEnt	Internal ID of Base Document	int	11	0				Allow NULL?
13	BaseType	Base Transaction Type	int	11	0		-1	-1, 0, 13, 15, 16, 163, 164, 165, 166, 17, 18, 20, 202, 203, 204, 21, 22, 23, 59, 67, 69	Allow NULL?
14	BaseCurr	Base Currency	nvarchar	3	0				Allow NULL?
15	Currency	Doc Currency	nvarchar	3	0	OCRN			Allow NULL?
16	AccumType	Accumulator Type	int	11	0		0	0, 1, 2, 3, 4, 5	Allow NULL?
17	ActionType	Action Type	int	11	0		5	0, 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 2, 3, 4, 5, 6, 7, 8, 9	Allow NULL?
18	ExpensesLC	Expenses (LC)	num	19	6				Allow NULL?
19	ExpensesFC	Expenses (FC)	num	19	6				Allow NULL?
20	ExpensesSC	Expenses (SC)	num	19	6				Allow NULL?
21	DocDueDate	Doc. Due Date	date	8	0
22	ItemCode	Item Code	nvarchar	20	0	OITM			Allow NULL?
23	BPCardCode	Business Partner Code	nvarchar	15	0	OCRD			Allow NULL?
24	DocDate	Doc Date	date	8	0
25	DocRate	Doc. Rate	num	19	6				Allow NULL?
26	Comment	Comment	nvarchar	254	0				Allow NULL?
27	JrnlMemo	Journal Remarks	nvarchar	50	0				Allow NULL?
28	Ref1	Reference 1	nvarchar	11	0				Allow NULL?
29	Ref2	Reference 2	nvarchar	11	0				Allow NULL?
30	BaseLine	Base Row Number	int	11	0		-1		Allow NULL?
31	SnBType	Serials and Batches Type	int	11	0		-1	0, 1	Allow NULL?
32	CreateTime	Generation Time	int	6	0				Allow NULL?
33	DataSource	Data Source	char	1	0		N	A, D, I, M, N, O, P, T, U	Allow NULL?
34	CreateDate	Creation Date	date	8	0
35	OcrCode	Distribution Rule	nvarchar	8	0	OOCR			Allow NULL?
36	OcrCode2	Distribution Rule2	nvarchar	8	0	OOCR			Allow NULL?
37	OcrCode3	Distribution Rule3	nvarchar	8	0	OOCR			Allow NULL?
38	OcrCode4	Distribution Rule4	nvarchar	8	0	OOCR			Allow NULL?
39	OcrCode5	Distribution Rule5	nvarchar	8	0	OOCR			Allow NULL?
40	DocPrice	Doc Price	num	19	6				Allow NULL?
41	CardName	BP Name	nvarchar	100	0				Allow NULL?
42	Dscription	Item Description	nvarchar	100	0				Allow NULL?
43	TreeType	BOM Type	char	1	0		N	A, I, N, S	Allow NULL?
44	ApplObj	Applied Object	int	11	0		-1		Allow NULL?
45	AppObjAbs	Applied Object Internal ID	int	11	0		-1		Allow NULL?
46	AppObjType	Applied Object Type	char	1	0				Allow NULL?
47	AppObjLine	Applied Object Row	int	11	0		-1		Allow NULL?
48	BASE_REF	Base Reference	nvarchar	11	0				Allow NULL?
49	TransSeqRf	Transaction Sequence Ref	int	11	0		-1		Allow NULL?
50	LayerIDRef	Layer ID Reference	int	11	0		-1		Allow NULL?
51	VersionNum	Version Number	nvarchar	11	0				Allow NULL?
52	PriceRate	Price Rate	num	19	6				Allow NULL?
53	PriceCurr	Price Currency	nvarchar	3	0	OCRN			Allow NULL?
54	DocTotal	Document Total	num	19	6				Allow NULL?
55	Price	Price	num	19	6				Allow NULL?
56	CIShbQty	Corr. Inv. Doc. Should Be Qty	num	19	6				Allow NULL?
57	SubLineNum	Sub Line Number	int	11	0		-1		Allow NULL?
58	PrjCode	Project code	nvarchar	20	0	OPRJ			Allow NULL?
59	SlpCode	Sales Employee	int	6	0	OSLP	-1		Allow NULL?
60	TaxDate	Document Date	date	8	0
61	UseDocPric	Use Document Price	char	1	0		N	N, Y	Allow NULL?
62	VendorNum	Vendor Catalog No.	nvarchar	17	0				Allow NULL?
63	SerialNum	Serial Number	nvarchar	17	0				Allow NULL?
64	BlockNum	Block Number	nvarchar	100	0				Allow NULL?
65	ImportLog	Import Log	nvarchar	20	0				Allow NULL?
66	Location	Location	int	11	0	OLCT			Allow NULL?
67	DocPrcRate	Document Price Rate	num	19	6				Allow NULL?
68	DocPrcCurr	Document Price Currency	nvarchar	3	0	OCRN			Allow NULL?
69	CgsOcrCod	COGS Distribution Rule	nvarchar	8	0	OOCR			Allow NULL?
70	CgsOcrCod2	COGS Distribution Rule 2	nvarchar	8	0	OOCR			Allow NULL?
71	CgsOcrCod3	COGS Distribution Rule 3	nvarchar	8	0	OOCR			Allow NULL?
72	CgsOcrCod4	COGS Distribution Rule 4	nvarchar	8	0	OOCR			Allow NULL?
73	CgsOcrCod5	COGS Distribution Rule 5	nvarchar	8	0	OOCR			Allow NULL?
74	BSubLineNo	Base Subrow Number	int	11	0		-1		Allow NULL?
75	AppSubLine	Applied Subrow Number	int	11	0		-1		Allow NULL?
76	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
77	SysRate	System Rate	num	19	6				Allow NULL?
78	ExFromRpt	Exclude from Report	char	1	0		N	N, Y	Allow NULL?
79	Ref3	Reference 3	nvarchar	11	0				Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	MessageID
CARD	No	No	BPCardCode
DocLine	No	No	TransType, DocEntry, DocLineNum, SubLineNum
APPOBJ	No	No	ApplObj, AppObjAbs, AppObjType, AppObjLine

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 | 4 INDEXES | B1 8.82 | UILM TABLE

TOP B1 8.82 | UILM COLUMNS

TOP B1 8.82 | UILM 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 | 4 INDEXES | B1 8.82 | UILM TABLE

TOPB1 8.82 | UILM COLUMNS

TOPB1 8.82 | UILM INDEXES

TOP B1 8.82 | UILM COLUMNS

TOP B1 8.82 | UILM INDEXES