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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	RECORD_ID	Parameter ID for Editing object	nvarchar	20	Allow NULL?
2	STATUS_CODE	Address Engine Status Code	nvarchar	10	Allow NULL?
3	STATUS_CODE_PO	Address Engine Status Code	nvarchar	10	Allow NULL?
4	INFO_CODE	Address Information Code	nvarchar	4	Allow NULL?
5	INFO_CODE_PO	PO Address Information Code	nvarchar	4	Allow NULL?
6	ERROR_CODE	Error codes	nvarchar	4	Allow NULL?
7	ERROR_CODE_PO	Error codes	nvarchar	4	Allow NULL?
8	COUNTRY	Country Key	nvarchar	3	Allow NULL?
9	ADDRNUMBER	Address number	nvarchar	10	Allow NULL?
10	PERSNUMBER	Person number	nvarchar	10	Allow NULL?
11	NATION	Version ID for International Addresses	char	1	Allow NULL?
12	DATE_FROM	Valid-from date - in current Release only 00010101 possible	nvarchar	8	Allow NULL?
13	DATE_TO	Valid-to date in current Release only 99991231 possible	nvarchar	8	Allow NULL?
14	PACKAGE_NO	Package number for reading quarterly adjustment data	nvarchar	10	Allow NULL?
15	CITY1	City	nvarchar	40	Allow NULL?
16	CITY2	District	nvarchar	40	Allow NULL?
17	CITY_CODE	City code for city/street file	nvarchar	12	Allow NULL?
18	CITYP_CODE	District code for City and Street file	nvarchar	8	Allow NULL?
19	HOME_CITY	City (different from postal city)	nvarchar	40	Allow NULL?
20	CITYH_CODE	Different city for city/street file	nvarchar	12	Allow NULL?
21	CHCKSTATUS	City file test status	char	1	Allow NULL?
22	REGIOGROUP	Regional structure grouping	nvarchar	8	Allow NULL?
23	POST_CODE1	City postal code	nvarchar	10	Allow NULL?
24	POST_CODE2	PO Box Postal Code	nvarchar	10	Allow NULL?
25	POST_CODE3	Company Postal Code (for Large Customers)	nvarchar	10	Allow NULL?
26	PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	nvarchar	10	Allow NULL?
27	PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	nvarchar	10	Allow NULL?
28	PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	nvarchar	10	Allow NULL?
29	PO_BOX	PO Box	nvarchar	10	Allow NULL?
30	PO_BOX_NUM	Flag: PO Box Without Number	char	1	Allow NULL?
31	PO_BOX_LOC	PO Box city	nvarchar	40	Allow NULL?
32	CITY_CODE2	City PO box code (City file)	nvarchar	12	Allow NULL?
33	PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	nvarchar	3	Allow NULL?
34	PO_BOX_CTY	PO box country	nvarchar	3	Allow NULL?
35	TRANSPZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	Allow NULL?
36	STREET	Street	nvarchar	60	Allow NULL?
37	STREETCODE	Street Number for City/Street File	nvarchar	12	Allow NULL?
38	STREETABBR	(Not Supported) Abbreviation of Street Name	nvarchar	2	Allow NULL?
39	HOUSE_NUM1	House Number	nvarchar	10	Allow NULL?
40	HOUSE_NUM2	House number supplement	nvarchar	10	Allow NULL?
41	STR_SUPPL1	Street 2	nvarchar	40	Allow NULL?
42	STR_SUPPL2	Street 3	nvarchar	40	Allow NULL?
43	STR_SUPPL3	Street 4	nvarchar	40	Allow NULL?
44	LOCATION	Street 5	nvarchar	40	Allow NULL?
45	BUILDING	Building (Number or Code)	nvarchar	20	Allow NULL?
46	FLOOR	Floor in building	nvarchar	10	Allow NULL?
47	ROOMNUMBER	Room or Appartment Number	nvarchar	10	Allow NULL?
48	LANGU	Language Key	char	1	Allow NULL?
49	REGION	Region (State, Province, County)	nvarchar	3	Allow NULL?
50	TIME_ZONE	Address time zone	nvarchar	6	Allow NULL?
51	TAXJURCODE	Tax Jurisdiction	nvarchar	15	Allow NULL?
52	LANGU_CREA	Address record creation original language	char	1	Allow NULL?
53	NAME_CO	c/o name	nvarchar	40	Allow NULL?
54	DONT_USE_S	Street Address Undeliverable Flag	nvarchar	4	Allow NULL?
55	DONT_USE_P	PO Box Address Undeliverable Flag	nvarchar	4	Allow NULL?
56	PO_BOX_LOBBY	PO Box Lobby	nvarchar	40	Allow NULL?
57	DELI_SERV_TYPE	Type of Delivery Service	nvarchar	4	Allow NULL?
58	DELI_SERV_NUMBER	Number of Delivery Service	nvarchar	10	Allow NULL?
59	REGION2_LONG	region2 long name	nvarchar	60	Allow NULL?
60	STOP	General Flag	char	1	Allow NULL?
61	CHCKST_QU	City file check status after quarterly adjustment	char	1	Allow NULL?
62	ERROR_FLAG	Flag: Quarterly adjustment error	char	1	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

62 COLUMNS | 1 INDEXES | ERP 6.0 | /FLDQ/AD_QU_INDX TABLE

TOP ERP 6.0 | /FLDQ/AD_QU_INDX COLUMNS

TOP ERP 6.0 | /FLDQ/AD_QU_INDX 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

62 COLUMNS | 1 INDEXES | ERP 6.0 | /FLDQ/AD_QU_INDX TABLE

TOPERP 6.0 | /FLDQ/AD_QU_INDX COLUMNS

TOPERP 6.0 | /FLDQ/AD_QU_INDX INDEXES

TOP ERP 6.0 | /FLDQ/AD_QU_INDX COLUMNS

TOP ERP 6.0 | /FLDQ/AD_QU_INDX INDEXES