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
Business Partners
1	Business One	9.3	OCPR	50	2	Contact Persons	Business Partners

Column	Field	Description	SQL Type	Length	Relation	Default Value	Constraints	SQL Create Statement
1	CntctCode	Internal Number	int	11				Allow NULL?
2	CardCode	BP Code	nvarchar	15	OCRD			Allow NULL?
3	Name	Contact Person Name	nvarchar	50				Allow NULL?
4	Position	Position	nvarchar	90				Allow NULL?
5	Address	Address	nvarchar	100				Allow NULL?
6	Tel1	Telephone 1	nvarchar	20				Allow NULL?
7	Tel2	Telephone 2	nvarchar	20				Allow NULL?
8	Cellolar	Mobile Phone	nvarchar	50				Allow NULL?
9	Fax	Fax	nvarchar	20				Allow NULL?
10	E_MailL	E-Mail	nvarchar	100				Allow NULL?
11	Pager	Pager	nvarchar	30				Allow NULL?
12	Notes1	Remark 1	nvarchar	100				Allow NULL?
13	Notes2	Remark 2	nvarchar	100				Allow NULL?
14	DataSource	Data Source	char	1		N	A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
15	UserSign	User Signature	int	6	OUSR			Allow NULL?
16	Password	Password	nvarchar	8				Allow NULL?
17	LogInstanc	Log Instance	int	11		0		Allow NULL?
18	ObjType	Object Type	nvarchar	20	ADP1	11		Allow NULL?
19	BirthPlace	Place of Birth	nvarchar	100				Allow NULL?
20	BirthDate	Date of Birth	date	8
21	Gender	Gender	char	1		E	*=Masked, E, F=Female, M=Male	Allow NULL?
22	Profession	Profession	nvarchar	50				Allow NULL?
23	updateDate	Date of Update	date	8
24	updateTime	Update Time	int	11				Allow NULL?
25	Title	Title	nvarchar	10				Allow NULL?
26	BirthCity	City of Birth	nvarchar	100				Allow NULL?
27	Active	Active	char	1		Y	N=No, Y=Yes	Allow NULL?
28	FirstName	First Name	nvarchar	50				Allow NULL?
29	MiddleName	Middle Name	nvarchar	50				Allow NULL?
30	LastName	Last Name	nvarchar	50				Allow NULL?
31	BirthState	State of Birth	nvarchar	3	OCST			Allow NULL?
32	ResidCity	City of Residence	nvarchar	100				Allow NULL?
33	ResidCntry	Country of Residence	nvarchar	100				Allow NULL?
34	ResidState	State of Residence	nvarchar	3	OCST			Allow NULL?
35	NFeRcpn	NF-e Recipient	char	1		N	N=No, Y=Yes	Allow NULL?
36	EmlGrpCode	E-Mail Group Code	nvarchar	20	OEGP			Allow NULL?
37	BlockComm	Block Sending Marketing	char	1		N	N=No, Y=Yes	Allow NULL?
38	FiscalCode	Fiscal Code for Resident	nvarchar	16				Allow NULL?
39	CtyPrvsYr	City for Previous Year	nvarchar	100				Allow NULL?
40	SttPrvsYr	State for Previous Year	nvarchar	3	OCST			Allow NULL?
41	CtyCdPrvsY	City Code for Previous Year	nvarchar	4				Allow NULL?
42	CtyCurYr	City for Current Year	nvarchar	100				Allow NULL?
43	SttCurYr	State for Current Year	nvarchar	3	OCST			Allow NULL?
44	CtyCdCurYr	City Code for Current Year	nvarchar	4				Allow NULL?
45	NotResdSch	Not resident Schumacker	char	1			N=No, Y=Yes	Allow NULL?
46	CtyFsnCode	Fusione comuni	nvarchar	100				Allow NULL?
47	NaturalPer	Natural Person	char	1		N	N=No, Y=Yes	Allow NULL?
48	DPPStatus	Data Protection Status	char	1		N	B=Blocked, D=Erased, N=None, U=Unblocked	Allow NULL?
49	CreateDate	Creation Date	date	8
50	CreateTS	Creation Time Incl. Sec.	int	11				Allow NULL?

Name	Primary	Unique	Type	Columns
PRIMARY	No	Yes		CntctCode
CARD	No	Yes		CardCode, Name

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

50 COLUMNS | 2 INDEXES | B1 9.3 | OCPR TABLE

TOP B1 9.3 | OCPR COLUMNS

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

50 COLUMNS | 2 INDEXES | B1 9.3 | OCPR TABLE

TOPB1 9.3 | OCPR COLUMNS

TOPB1 9.3 | OCPR INDEXES

TOP B1 9.3 | OCPR COLUMNS

TOP B1 9.3 | OCPR INDEXES