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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Service
1	Business One	9.3	OSCL	104	5	Service Calls	Service

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	callID	Call ID	int	11	0				Allow NULL?
2	subject	Subject	nvarchar	254	0				Allow NULL?
3	customer	Business Partner Code	nvarchar	15	0	OCRD			Allow NULL?
4	custmrName	Business Partner Name	nvarchar	100	0				Allow NULL?
5	contctCode	Contact Person	int	11	0	OCPR			Allow NULL?
6	manufSN	Mfr Serial No.	nvarchar	36	0				Allow NULL?
7	internalSN	Serial Number	nvarchar	36	0				Allow NULL?
8	contractID	Contract No.	int	11	0	OCTR			Allow NULL?
9	cntrctDate	Contract End Date	date	8	0
10	resolDate	Resolution Date	date	8	0
11	resolTime	Resolution Time	int	6	0				Allow NULL?
12	free_1	Warranty	char	1	0		N	N=No, Y=Yes	Allow NULL?
13	free_2	Warranty End Date	date	8	0
14	origin	Origin	int	6	0	OSCO			Allow NULL?
15	itemCode	Item No.	nvarchar	50	0	OITM			Allow NULL?
16	itemName	Item Description	nvarchar	100	0				Allow NULL?
17	itemGroup	Item Group	int	6	0	OITB			Allow NULL?
18	status	Status	int	6	0	OSCS	-3		Allow NULL?
19	priority	Priority	char	1	0		L	H=High, L=Low, M=Medium	Allow NULL?
20	callType	Call Type	int	6	0	OSCT			Allow NULL?
21	problemTyp	Problem Type	int	6	0	OSCP			Allow NULL?
22	assignee	Handled By	int	6	0	OUSR			Allow NULL?
23	descrption	Description	text	16	0
24	objType	Object Type	nvarchar	20	0		191		Allow NULL?
25	logInstanc	Log Instance	int	11	0				Allow NULL?
26	userSign	Creating User	int	6	0	OUSR			Allow NULL?
27	createDate	Creation Date	date	8	0
28	createTime	Creation Time	int	6	0				Allow NULL?
29	closeDate	Closing Date	date	8	0
30	closeTime	Closing Time	int	6	0				Allow NULL?
31	userSign2	Updating User	int	6	0	OUSR			Allow NULL?
32	updateDate	Date of Update	date	8	0
33	SCL1Count	InternalSCL1Count	int	11	0		0		Allow NULL?
34	SCL2Count	InternalSCL2Count	int	11	0		0		Allow NULL?
35	isEntitled	Entitle for Service	char	1	0		N	C=Valid contract exists, N=Not Entitled	Allow NULL?
36	insID	Install Card No.	int	11	0	OINS			Allow NULL?
37	technician	Technician	int	11	0	OHEM			Allow NULL?
38	resolution	Resolution	text	16	0
39	Scl1NxtLn	SCL1 Next Line	int	11	0				Allow NULL?
40	Scl2NxtLn	SCL2 Next Line	int	11	0				Allow NULL?
41	Scl3NxtLn	SCL3 Next Line	int	11	0				Allow NULL?
42	Scl4NxtLn	SCL4 Next Line	int	11	0				Allow NULL?
43	Scl5NxtLn	SCL5 Next Line	int	11	0				Allow NULL?
44	isQueue	Belongs to a Queue	char	1	0		N	N=No, Y=Yes	Allow NULL?
45	Queue	Queue	nvarchar	20	0	OQUE			Allow NULL?
46	resolOnDat	Resolution on Date	date	8	0
47	resolOnTim	Resolution on Time	int	6	0				Allow NULL?
48	respByDate	Response by Date	date	8	0
49	respByTime	Response by Time	int	6	0				Allow NULL?
50	respOnDate	Response on Date	date	8	0
51	respOnTime	Response on Time	int	6	0				Allow NULL?
52	respAssign	Assigned for Response	int	6	0	OUSR			Allow NULL?
53	AssignDate	Assigned Date	date	8	0
54	AssignTime	Assigned Time	int	6	0				Allow NULL?
55	UpdateTime	Updated Time	int	6	0				Allow NULL?
56	responder	Responder	int	6	0	OUSR			Allow NULL?
57	Transfered	Year Transfer	char	1	0		N		Allow NULL?
58	Instance	Instance	int	6	0		0		Allow NULL?
59	DocNum	Document Number	int	11	0				Allow NULL?
60	Series	Series	int	11	0	NNM1			Allow NULL?
61	Handwrtten	Manual Numbering	char	1	0		N	N=No, Y=Yes	Allow NULL?
62	PIndicator	Period Indicator	nvarchar	10	0	OPID			Allow NULL?
63	StartDate	Start Date	date	8	0
64	StartTime	Start Time	int	11	0				Allow NULL?
65	EndDate	End Date	date	8	0
66	EndTime	End Time	int	11	0				Allow NULL?
67	Duration	Service Call Duration	num	19	6				Allow NULL?
68	DurType	Duration UoM	char	1	0		M	D=Days, H=Hours, M=Minutes, S=Seconds	Allow NULL?
69	Reminder	Reminder	char	1	0		N	N=No, Y=Yes	Allow NULL?
70	RemQty	Reminder Quantity	num	19	6				Allow NULL?
71	RemType	Reminder UoM	char	1	0		M	D=Days, H=Hours, M=Minutes, S=Seconds	Allow NULL?
72	RemDate	Reminder Date	date	8	0
73	RemSent	Reminder Sent	char	1	0		N	N=No, Y=Yes	Allow NULL?
74	RemTime	Reminder Time	int	6	0				Allow NULL?
75	Location	Location	int	6	0	OCLO	-1		Allow NULL?
76	AddrName	Address Name	nvarchar	50	0				Allow NULL?
77	AddrType	Address Type	char	1	0		S	B=Bill to, S=Ship To	Allow NULL?
78	Street	Street	nvarchar	100	0				Allow NULL?
79	City	City	nvarchar	100	0				Allow NULL?
80	Room	Room	nvarchar	50	0				Allow NULL?
81	State	State	nvarchar	3	0	OCST			Allow NULL?
82	Country	Country	nvarchar	3	0	OCRY			Allow NULL?
83	DisplInCal	Display in Calendar	char	1	0		N	N=No, Y=Yes	Allow NULL?
84	SupplCode	Supplementary Code	nvarchar	254	0				Allow NULL?
85	Attachment	Attachment	text	16	0
86	AtcEntry	Attachment Entry	int	11	0				Allow NULL?
87	NumAtCard	Business Partner Ref. No.	nvarchar	100	0				Allow NULL?
88	ProSubType	Problem Subtype	int	6	0	OPST			Allow NULL?
89	BPType	BP Type	char	1	0		R	P=Purchasing, R=Sales	Allow NULL?
90	Telephone	Phone Number	nvarchar	50	0				Allow NULL?
91	BPPhone1	BP Phone Number1	nvarchar	20	0				Allow NULL?
92	BPPhone2	BP Phone Number1	nvarchar	20	0				Allow NULL?
93	BPCellular	BP Mobile Phone Number	nvarchar	50	0				Allow NULL?
94	BPFax	BP Fax Number	nvarchar	20	0				Allow NULL?
95	BPShipCode	BP Ship-to Code	nvarchar	50	0				Allow NULL?
96	BPShipAddr	BP Ship-to Address	nvarchar	254	0				Allow NULL?
97	BPBillCode	BP Bill-to Code	nvarchar	50	0				Allow NULL?
98	BPBillAddr	BP Bill-to Address	nvarchar	254	0				Allow NULL?
99	BPTerrit	BP Territory	int	11	0				Allow NULL?
100	BPE_Mail	BP E-Mail	nvarchar	100	0				Allow NULL?
101	BPProjCode	BP Project Code	nvarchar	20	0				Allow NULL?
102	BPContact	BP Contact Person	nvarchar	245	0				Allow NULL?
103	OwnerCode	Service Call Owner	int	11	0	OHEM			Allow NULL?
104	DPPStatus	Data Protection Status	char	1	0		N	D=Erased, N=None	Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	callID
NUM	No	Yes	DocNum, Instance, PIndicator
SERIES	No	No	Series
REMDATE	No	No	RemDate
REMTIME	No	No	RemTime

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

104 COLUMNS | 5 INDEXES | B1 9.3 | OSCL TABLE

TOP B1 9.3 | OSCL COLUMNS

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

104 COLUMNS | 5 INDEXES | B1 9.3 | OSCL TABLE

TOPB1 9.3 | OSCL COLUMNS

TOPB1 9.3 | OSCL INDEXES

TOP B1 9.3 | OSCL COLUMNS

TOP B1 9.3 | OSCL INDEXES