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	9.3	OINS	55	4	Customer Equipment Card	Service

Column	Field	Description	SQL Type	Length	Relation	Default Value	Constraints	SQL Create Statement
1	insID	Equipment Card No.	int	11				Allow NULL?
2	customer	Business Partner Code	nvarchar	15	OCRD			Allow NULL?
3	custmrName	Business Partner Name	nvarchar	100				Allow NULL?
4	contactCod	Contact Person Code	int	11	OCPR			Allow NULL?
5	directCsmr	Direct Customer	nvarchar	15				Allow NULL?
6	drctCsmNam	Direct Customer Name	nvarchar	100				Allow NULL?
7	manufSN	Mfr Serial No.	nvarchar	36				Allow NULL?
8	internalSN	Serial Number	nvarchar	36				Allow NULL?
9	warranty	Warranty	char	1		N	N=No, Y=Yes	Allow NULL?
10	wrrntyStrt	Warranty Start Date	date	8
11	wrrntyEnd	Warranty End Date	date	8
12	responsVal	Time Required for Response	int	6				Allow NULL?
13	responsUnt	Time Unit	char	1		D	D=Day(s), H=Hour(s)	Allow NULL?
14	itemCode	Item No.	nvarchar	50	OITM			Allow NULL?
15	itemName	Item Description	nvarchar	100				Allow NULL?
16	itemGroup	Item Group	int	6	OITB			Allow NULL?
17	manufDate	Manufacture Date	date	8
18	delivery	Delivery Key	int	11	ODLN			Allow NULL?
19	deliveryNo	Delivery Number	int	11				Allow NULL?
20	invoice	Invoice Key	int	11	OINV			Allow NULL?
21	invoiceNum	Invoice Number	int	11				Allow NULL?
22	dlvryDate	Delivery Date	date	8
23	cntctPhone	Contact Phone	nvarchar	20				Allow NULL?
24	street	Street	nvarchar	100				Allow NULL?
25	block	Block	nvarchar	100				Allow NULL?
26	zip	Zip Code	nvarchar	20				Allow NULL?
27	city	City	nvarchar	100				Allow NULL?
28	county	County	nvarchar	100				Allow NULL?
29	country	Country	nvarchar	3	OCRY			Allow NULL?
30	state	State	nvarchar	3	OCST			Allow NULL?
31	instLction	Installation Location	nvarchar	254				Allow NULL?
32	contract	Contract	int	11	OCTR			Allow NULL?
33	cntrctStrt	Contract Start Date	date	8
34	cntrctEnd	Contract End Date	date	8
35	attachment	Attachments	text	16
36	objType	Object Type	nvarchar	20		176		Allow NULL?
37	logInstanc	Log Instance	int	11				Allow NULL?
38	userSign	Creating User	int	6	OUSR			Allow NULL?
39	createDate	Creation Date	date	8
40	userSign2	Updating User	int	6	OUSR			Allow NULL?
41	updateDate	Date of Update	date	8
42	Building	Building/Floor/Room	text	16
43	status	Status	char	1		A	A=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated	Allow NULL?
44	replcIns	The CEC this replaced	int	11	OINS			Allow NULL?
45	repByIns	The CEC this is replaced by	int	11	OINS			Allow NULL?
46	technician	Default Technician	int	11	OHEM			Allow NULL?
47	territory	Default Territory	int	11	OTER			Allow NULL?
48	AtcEntry	Attachment Entry	int	11	OATC			Allow NULL?
49	Transfered	Year Transfer	char	1		N		Allow NULL?
50	AddrType	Address Type	nvarchar	100				Allow NULL?
51	Instance	Instance	int	6		0		Allow NULL?
52	StreetNo	Street No.	nvarchar	100				Allow NULL?
53	BPType	BP Type	char	1		R	P=Purchasing, R=Sales	Allow NULL?
54	OwnerCode	Equipment Card Owner	int	11	OHEM			Allow NULL?
55	DPPStatus	Data Protection Status	char	1		N	D=Erased, N=None	Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	insID
C_ITM_SN_S	No	No	customer, itemCode, internalSN, status
ITM_MNFSN	No	No	itemCode, manufSN
ITM_INTSN	No	No	itemCode, internalSN

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

55 COLUMNS | 4 INDEXES | B1 9.3 | OINS TABLE

TOP B1 9.3 | OINS COLUMNS

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

55 COLUMNS | 4 INDEXES | B1 9.3 | OINS TABLE

TOPB1 9.3 | OINS COLUMNS

TOPB1 9.3 | OINS INDEXES

TOP B1 9.3 | OINS COLUMNS

TOP B1 9.3 | OINS INDEXES