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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	NUM_ID	Internal number in the electronic invoice archive	nvarchar	12	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	Allow NULL?
4	GJAHR_IN	Fiscal Year	nvarchar	4	Allow NULL?
5	NUM_IN	10 digit number	nvarchar	10	Allow NULL?
6	BELNR_ORIG	Number of Original VAT Invoice	nvarchar	10	Allow NULL?
7	GJAHR_ORIG	Year of Original VAT Invoice	nvarchar	4	Allow NULL?
8	BELNR_CORR	Number of Corrective VAT Invoice	nvarchar	10	Allow NULL?
9	GJAHR_CORR	Year of Corrective VAT Invoice	nvarchar	4	Allow NULL?
10	REVNO	Revision Number	nvarchar	3	Allow NULL?
11	TYPE	Electronic Invoicing Document Type	nvarchar	3	Allow NULL?
12	DIRECTION	Document direction	nvarchar	3	Allow NULL?
13	EXT_ORIG	External Number of Original VAT Invoice	nvarchar	50	Allow NULL?
14	COUNTER_KEY	Key for differentiation in XML log table	nvarchar	10	Allow NULL?
15	VERS	XML format version	nvarchar	7	Allow NULL?
16	STATUS	Electronic invoicing document status	nvarchar	3	Allow NULL?
17	DOC_TIMESTAMP	Timestamp of document	nvarchar	14	Allow NULL?
18	PARTNER	Counterparty	nvarchar	10	Allow NULL?
19	PARTNER_ID	Partner ID (Electronic Invoicing)	nvarchar	46	Allow NULL?
20	C_TIMESTAMP	Timestamp of creation	nvarchar	14	Allow NULL?
21	C_USER	User who created document	nvarchar	12	Allow NULL?
22	M_TIMESTAMP	Timestamp of modification	nvarchar	14	Allow NULL?
23	M_USER	User who modified document	nvarchar	12	Allow NULL?
24	SIGN_TIMESTAMP	Timestamp of signing	nvarchar	14	Allow NULL?
25	SIGN_USER	User who signed document	nvarchar	12	Allow NULL?
26	FILENAME	File Name (Electronic Documents Exchange)	nvarchar	200	Allow NULL?
27	XMLDATA	XML Data	image	2147483647
28	SXMLDATA	XML Data	image	2147483647
29	SIGNATURE	Digital invoice signature	image	2147483647
30	OPERATOR	Operator of Company Code	nvarchar	10	Allow NULL?

Name	Primary	Unique	Type	Columns
J_3RFDI_ARC~0	Yes	Yes	CLUSTERED	NUM_ID, MANDT
J_3RFDI_ARC~DIR	No	No	NONCLUSTERED	DIRECTION
J_3RFDI_ARC~STA	No	No	NONCLUSTERED	DIRECTION, STATUS, MANDT

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

30 COLUMNS | 3 INDEXES | ERP 6.0 | J_3RFDI_ARC TABLE

TOP ERP 6.0 | J_3RFDI_ARC COLUMNS

TOP ERP 6.0 | J_3RFDI_ARC 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

30 COLUMNS | 3 INDEXES | ERP 6.0 | J_3RFDI_ARC TABLE

TOPERP 6.0 | J_3RFDI_ARC COLUMNS

TOPERP 6.0 | J_3RFDI_ARC INDEXES

TOP ERP 6.0 | J_3RFDI_ARC COLUMNS

TOP ERP 6.0 | J_3RFDI_ARC INDEXES