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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Business Partners
1	Business One	9.2	OCPR	44	2	Contact Persons	Business Partners

Column	Field	Description	SQL Type	Length	Default Value	Constraints	SQL Create Statement
1	CntctCode	Internal Number	int	11			Allow NULL?
2	CardCode	BP Code	nvarchar	15			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			Allow NULL?
16	Password	Password	nvarchar	8			Allow NULL?
17	LogInstanc	Log Instance	int	11	0		Allow NULL?
18	ObjType	Object Type	nvarchar	20	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	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			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			Allow NULL?
35	NFeRcpn	NF-e Recipient	char	1	N	N=No, Y=Yes	Allow NULL?
36	EmlGrpCode	E-Mail Group Code	nvarchar	20			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			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			Allow NULL?
44	CtyCdCurYr	City Code for Current Year	nvarchar	4			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

44 COLUMNS | 2 INDEXES | B1 9.2 | OCPR TABLE

TOP B1 9.2 | OCPR COLUMNS

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

44 COLUMNS | 2 INDEXES | B1 9.2 | OCPR TABLE

TOPB1 9.2 | OCPR COLUMNS

TOPB1 9.2 | OCPR INDEXES

TOP B1 9.2 | OCPR COLUMNS

TOP B1 9.2 | OCPR INDEXES