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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Service
1	Business One	8.8	OSCL	58	1	Service Calls	Service

Column	Field	Description	SQL Type	Length	Relation	Default Value	Constraints	SQL Create Statement
1	callID	Service Call No.	int	11				Allow NULL?
2	subject	Subject	nvarchar	254				Allow NULL?
3	customer	Customer Code	nvarchar	15	OCRD			Allow NULL?
4	custmrName	Customer Name	nvarchar	100	OCRD			Allow NULL?
5	contctCode	Contact Person	int	11	OCPR			Allow NULL?
6	manufSN	Mfr Serial No.	nvarchar	32				Allow NULL?
7	internalSN	Serial Number	nvarchar	32				Allow NULL?
8	contractID	Contract No.	int	11	OCTR			Allow NULL?
9	cntrctDate	Contract End Date	date	8
10	resolDate	Resolution Date	date	8
11	resolTime	Resolution Time	int	6				Allow NULL?
12	free_1	Warranty	char	1		N	N=No, Y=Yes	Allow NULL?
13	free_2	Warranty End Date	date	8
14	origin	Origin	int	6	OSCO			Allow NULL?
15	itemCode	Item No.	nvarchar	20	OITM			Allow NULL?
16	itemName	Item Description	nvarchar	100				Allow NULL?
17	itemGroup	Item Group	int	6	OITB			Allow NULL?
18	status	Status	int	6	OSCS	-3		Allow NULL?
19	priority	Priority	char	1		L	H=High, L=Low, M=Medium	Allow NULL?
20	callType	Call Type	int	6	OSCT			Allow NULL?
21	problemTyp	Problem Type	int	6	OSCP			Allow NULL?
22	assignee	Handled by	int	6	OUSR			Allow NULL?
23	descrption	Description	text	16
24	objType	Object Type	nvarchar	20		191		Allow NULL?
25	logInstanc	Log Instance	int	6				Allow NULL?
26	userSign	Creating User	int	6	OUSR			Allow NULL?
27	createDate	Creation Date	date	8
28	createTime	Creation Time	int	6				Allow NULL?
29	closeDate	Closing Date	date	8
30	closeTime	Closing Time	int	6				Allow NULL?
31	userSign2	Updating User	int	6	OUSR			Allow NULL?
32	updateDate	Date of Update	date	8
33	SCL1Count	InternalSCL1Count	int	11		0		Allow NULL?
34	SCL2Count	InternalSCL2Count	int	11		0		Allow NULL?
35	isEntitled	Entitle for Service	char	1		N	C=Valid contract exists, N=Not Entitled	Allow NULL?
36	insID	Install Card No.	int	11	OINS			Allow NULL?
37	technician	Technician	int	11	OHEM			Allow NULL?
38	resolution	Resolution	text	16
39	Scl1NxtLn	SCL1 Next Line	int	11				Allow NULL?
40	Scl2NxtLn	SCL2 Next Line	int	11				Allow NULL?
41	Scl3NxtLn	SCL3 Next Line	int	11				Allow NULL?
42	Scl4NxtLn	SCL4 Next Line	int	11				Allow NULL?
43	Scl5NxtLn	SCL5 Next Line	int	11				Allow NULL?
44	isQueue	Belongs to a Queue	char	1		N	N=No, Y=Yes	Allow NULL?
45	Queue	Queue	nvarchar	20	OQUE			Allow NULL?
46	resolOnDat	Resolution on Date	date	8
47	resolOnTim	Resolution on Time	int	6				Allow NULL?
48	respByDate	Response by Date	date	8
49	respByTime	Response by Time	int	6				Allow NULL?
50	respOnDate	Response on Date	date	8
51	respOnTime	Response on Time	int	6				Allow NULL?
52	respAssign	Assigned for Response	int	6	OUSR			Allow NULL?
53	AssignDate	Assigned Date	date	8
54	AssignTime	Assigned Time	int	6				Allow NULL?
55	UpdateTime	Updated Time	int	6				Allow NULL?
56	responder	Responder	int	6	OUSR			Allow NULL?
57	Transfered	Year Transfer	char	1		N		Allow NULL?
58	Instance	Instance	int	6		0		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

58 COLUMNS | 1 INDEXES | B1 8.8 | OSCL TABLE

TOP B1 8.8 | OSCL COLUMNS

TOP B1 8.8 | OSCL 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

58 COLUMNS | 1 INDEXES | B1 8.8 | OSCL TABLE

TOPB1 8.8 | OSCL COLUMNS

TOPB1 8.8 | OSCL INDEXES

TOP B1 8.8 | OSCL COLUMNS

TOP B1 8.8 | OSCL INDEXES