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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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
Basis Components
1	ERP EHP7	6.0	/XFT/INV_Q	141	9	Invoice receipt queue: Header	Basis Components

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PROCESS_ID	Process ID	nvarchar	34	0	Allow NULL?
3	INV_TYPE	Invoice Receipt Type	nvarchar	4	0	Allow NULL?
4	PROCESS_ID_CHILD	Child Process ID	nvarchar	34	0	Allow NULL?
5	RATING	Rating	nvarchar	4	0	Allow NULL?
6	FOLLOW_ON_DOC	Follow-On Object Created?	nvarchar	4	0	Allow NULL?
7	WORKFLOW	Workflow created?	nvarchar	4	0	Allow NULL?
8	NUMBERWF	Number of Unfinished Workflows	int	10	0	Allow NULL?
9	STATUS	Status	nvarchar	10	0	Allow NULL?
10	STATUS_TEXT	Current Status	nvarchar	32	0	Allow NULL?
11	SYST_STATUS	System status	nvarchar	4	0	Allow NULL?
12	CREATE_DATE	Creation Date	nvarchar	8	0	Allow NULL?
13	CREATE_TIME	Creation Time	nvarchar	6	0	Allow NULL?
14	CHANGE_DATE	Change date	nvarchar	8	0	Allow NULL?
15	CHANGE_TIME	Time of change	nvarchar	6	0	Allow NULL?
16	CHANGE_USER	Change - User	nvarchar	12	0	Allow NULL?
17	MESS_EX	Messages	nvarchar	4	0	Allow NULL?
18	ITER_NUM_VAL	Repeat Counter Validation	int	10	0	Allow NULL?
19	ITERATION_NUM	Repeat Counter	int	10	0	Allow NULL?
20	PROCESS_TYPE_DIS	Process type	nvarchar	64	0	Allow NULL?
21	PROCESS_TYPE	Process type	nvarchar	32	0	Allow NULL?
22	PROCESS_TYPE_VAL	Process Type Validation	nvarchar	32	0	Allow NULL?
23	RECORD_ID	Record ID	nvarchar	32	0	Allow NULL?
24	TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
25	DOCUMENTS	Serialized Doc. IDs	ntext	1073741823	0
26	DOC_STRUCNAME	Character field, length 64	nvarchar	64	0	Allow NULL?
27	MESSAGES	Serialized Messages	ntext	1073741823	0
28	MESS_STRUCNAME	Character field, length 64	nvarchar	64	0	Allow NULL?
29	BARCODE	Barcode	nvarchar	40	0	Allow NULL?
30	REB_COLOR	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	Allow NULL?
31	INV_DOC_NO	Invoice Document Number	nvarchar	10	0	Allow NULL?
32	INV_DOC_YEAR	Fiscal Year of Current Period	nvarchar	4	0	Allow NULL?
33	OBJECT_TYPE	Object type	nvarchar	10	0	Allow NULL?
34	MIRO_ICON	PO Reference?	nvarchar	4	0	Allow NULL?
35	MRM_VORGANG	Transaction Types for Incoming Invoice	char	1	0	Allow NULL?
36	INVOICE_IND	Invoice Indicator	char	1	0	Allow NULL?
37	DOC_TYPE	Document Type	nvarchar	2	0	Allow NULL?
38	DOC_DATE	Document Date in Document	nvarchar	8	0	Allow NULL?
39	PSTNG_DATE	Posting Date in the Document	nvarchar	8	0	Allow NULL?
40	REF_DOC_NO	Reference Document Number	nvarchar	16	0	Allow NULL?
41	COMP_CODE	Company Code	nvarchar	4	0	Allow NULL?
42	DIFF_INV	Invoicing party	nvarchar	10	0	Allow NULL?
43	CURRENCY	Currency Key	nvarchar	5	0	Allow NULL?
44	CURRENCY_ISO	ISO currency code	nvarchar	3	0	Allow NULL?
45	GROSS_AMOUNT	Currency amount	decimal	23	4
46	INV_REC_DATE	Invoice Receipt Date	nvarchar	8	0	Allow NULL?
47	CALC_TAX_IND	Calculate Tax Automatically?	char	1	0	Allow NULL?
48	BLINE_DATE	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
49	PMNTTRMS	Terms of Payment Key	nvarchar	4	0	Allow NULL?
50	DSCT_DAYS1	Cash discount days 1	decimal	3	0
51	DSCT_PCT1	Cash Discount Percentage 1	decimal	5	3
52	DSCT_DAYS2	Cash discount days 2	decimal	3	0
53	DSCT_PCT2	Cash Discount Percentage 2	decimal	5	3
54	NETTERMS	Net Payment Terms Period	decimal	3	0
55	FIXEDTERMS	Fixed Payment Terms	char	1	0	Allow NULL?
56	PMNT_BLOCK	Payment Block Key	char	1	0	Allow NULL?
57	DSCT_AMOUNT	Cash discount in document currency	decimal	23	4
58	PYMT_METH	Payment Method	char	1	0	Allow NULL?
59	INV_REF_NO	Invoice Reference: Document Number for Invoice Reference	nvarchar	10	0	Allow NULL?
60	INV_YEAR	Fiscal year of related invoice (in case of credit memo)	nvarchar	4	0	Allow NULL?
61	PARTNER_BK	Partner Bank Type	nvarchar	4	0	Allow NULL?
62	HOUSEBANKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
63	EXCH_RATE	Direct Quoted Exchange Rate	decimal	9	5
64	EXCH_RATE_V	Indirect Quoted Exchange Rate	decimal	9	5
65	IV_CATEGORY	Origin of a Logistics Invoice Verification Document	char	1	0	Allow NULL?
66	DEL_COSTS	Unplanned delivery costs	decimal	23	4
67	DEL_COSTS_TAXC	Tax code, delivery costs	nvarchar	2	0	Allow NULL?
68	DEL_COSTS_TAXJ	Jurisdiction code, delivery costs	nvarchar	15	0	Allow NULL?
69	PERSON_EXT	Name of creator of external system	nvarchar	12	0	Allow NULL?
70	PMTMTHSUPL	Payment Method Supplement	nvarchar	2	0	Allow NULL?
71	SCBANK_IND	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
72	SUPCOUNTRY	Supplying Country	nvarchar	3	0	Allow NULL?
73	BLLSRV_IND	Service Indicator (Foreign Payment)	char	1	0	Allow NULL?
74	REF_DOC_NO_LONG	Reference Document Number (for Dependencies see Long Text)	nvarchar	35	0	Allow NULL?
75	PO_SUB_NO	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
76	PO_CHECKDG	ISR Check Digit	nvarchar	2	0	Allow NULL?
77	PO_REF_NO	ISR Reference Number	nvarchar	27	0	Allow NULL?
78	PAYEE_PAYER	Payee/Payer	nvarchar	10	0	Allow NULL?
79	ALLOC_NMBR	Assignment Number	nvarchar	18	0	Allow NULL?
80	PAYMT_REF	Payment Reference	nvarchar	30	0	Allow NULL?
81	PLANNING_LEVEL	Planning Level	nvarchar	2	0	Allow NULL?
82	PLANNING_DATE	Planning Date	nvarchar	8	0	Allow NULL?
83	BUS_AREA	Business Area	nvarchar	4	0	Allow NULL?
84	LOT_NUMBER	Bundeling Indicator for Documents	nvarchar	10	0	Allow NULL?
85	ITEM_TEXT	Item Text	nvarchar	50	0	Allow NULL?
86	J_1BNFTYPE	Nota Fiscal Type	nvarchar	2	0	Allow NULL?
87	EU_TRIANG_DEAL	Indicator: Triangular Deal within the EU ?	char	1	0	Allow NULL?
88	REPCOUNTRY	Reporting Country for Delivery of Goods within the EU	nvarchar	3	0	Allow NULL?
89	BU_PARTNER	Business Partner Number	nvarchar	10	0	Allow NULL?
90	ACC_1_TIME	Indicator: Is the account a one-time account?	char	1	0	Allow NULL?
91	NAME	Name 1	nvarchar	35	0	Allow NULL?
92	NAME_2	Name 2	nvarchar	35	0	Allow NULL?
93	NAME_3	Name 3	nvarchar	35	0	Allow NULL?
94	NAME_4	Name 4	nvarchar	35	0	Allow NULL?
95	POSTL_CODE	Postal Code	nvarchar	10	0	Allow NULL?
96	CITY	City	nvarchar	35	0	Allow NULL?
97	COUNTRY	Country Key	nvarchar	3	0	Allow NULL?
98	STREET	House number and street	nvarchar	35	0	Allow NULL?
99	PO_BOX	PO Box	nvarchar	10	0	Allow NULL?
100	POBX_PCD	P.O. Box Postal Code	nvarchar	10	0	Allow NULL?
101	REGION	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
102	FORM_OF_ADDR	Title	nvarchar	15	0	Allow NULL?
103	LANGU	Language Key	char	1	0	Allow NULL?
104	POBK_CURAC	Account Number of Bank Account At Post Office	nvarchar	16	0	Allow NULL?
105	BANK_ACCT	Bank account number	nvarchar	18	0	Allow NULL?
106	BANK_NO	Bank number	nvarchar	15	0	Allow NULL?
107	BANK_CTRY	Bank country key	nvarchar	3	0	Allow NULL?
108	CTRL_KEY	Bank Control Key	nvarchar	2	0	Allow NULL?
109	BANK_REF	Reference specifications for bank details	nvarchar	20	0	Allow NULL?
110	TAX_NO_1	Tax Number 1	nvarchar	16	0	Allow NULL?
111	TAX_NO_2	Tax Number 2	nvarchar	11	0	Allow NULL?
112	TAX_NO_3	Tax Number 3	nvarchar	18	0	Allow NULL?
113	TAX_NO_4	Tax Number 4	nvarchar	18	0	Allow NULL?
114	SLS_PUR_TX	Liable for VAT	char	1	0	Allow NULL?
115	EQUAL_TAX	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	Allow NULL?
116	TAX_CATEGORY	Tax type	nvarchar	2	0	Allow NULL?
117	TAX_NO_TY	Tax Number Type	nvarchar	2	0	Allow NULL?
118	SOLE_PROP	Natural Person	char	1	0	Allow NULL?
119	VAT_REG_NO	VAT Registration Number	nvarchar	20	0	Allow NULL?
120	USER_STATUS	User status	nvarchar	10	0	Allow NULL?
121	PERSON_RESP	Agent	nvarchar	12	0	Allow NULL?
122	ORG_UNIT	Organizational Unit	nvarchar	14	0	Allow NULL?
123	DESCRIPTION	Comment	nvarchar	4	0	Allow NULL?
124	USER1	User Field	nvarchar	128	0	Allow NULL?
125	USER2	User Field	nvarchar	128	0	Allow NULL?
126	USER3	User Field	nvarchar	128	0	Allow NULL?
127	USER4	User Field	nvarchar	128	0	Allow NULL?
128	USER5	User Field	nvarchar	128	0	Allow NULL?
129	USER6	User Field	nvarchar	128	0	Allow NULL?
130	USER7	User Field	nvarchar	128	0	Allow NULL?
131	USER8	User Field	nvarchar	128	0	Allow NULL?
132	USER9	User Field	nvarchar	128	0	Allow NULL?
133	USER10	User Field	nvarchar	128	0	Allow NULL?
134	USER11	User Field	nvarchar	128	0	Allow NULL?
135	USER12	User Field	nvarchar	128	0	Allow NULL?
136	USER13	User Field	nvarchar	128	0	Allow NULL?
137	USER14	User Field	nvarchar	128	0	Allow NULL?
138	USER15	User Field	nvarchar	128	0	Allow NULL?
139	MIRO	Flag: Reference to Purchase Order	char	1	0	Allow NULL?
140	REFERENZBELEGTYP	Reference Document Category	char	1	0	Allow NULL?
141	BLART_FI	FI Document Type	nvarchar	2	0	Allow NULL?

Name	Primary	Unique	Type	Columns
/XFT/INV_Q~0	Yes	Yes	CLUSTERED	PROCESS_ID, MANDT
/XFT/INV_Q~IN1	No	No	NONCLUSTERED	OBJECT_TYPE
/XFT/INV_Q~IN2	No	No	NONCLUSTERED	RECORD_ID, MANDT
/XFT/INV_Q~IN3	No	No	NONCLUSTERED	COMP_CODE, INV_DOC_YEAR, INV_DOC_NO, MANDT
/XFT/INV_Q~IN4	No	No	NONCLUSTERED	PERSON_RESP, MANDT
/XFT/INV_Q~IN5	No	No	NONCLUSTERED	COMP_CODE, MANDT
/XFT/INV_Q~IN6	No	No	NONCLUSTERED	USER1, MANDT
/XFT/INV_Q~IN7	No	No	NONCLUSTERED	PROCESS_ID_CHILD, MANDT
/XFT/INV_Q~IN8	No	No	NONCLUSTERED	DIFF_INV, REF_DOC_NO, DOC_DATE, 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

141 COLUMNS | 9 INDEXES | ERP 6.0 | /XFT/INV_Q TABLE

TOP ERP 6.0 | /XFT/INV_Q COLUMNS

TOP ERP 6.0 | /XFT/INV_Q 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

141 COLUMNS | 9 INDEXES | ERP 6.0 | /XFT/INV_Q TABLE

TOPERP 6.0 | /XFT/INV_Q COLUMNS

TOPERP 6.0 | /XFT/INV_Q INDEXES

TOP ERP 6.0 | /XFT/INV_Q COLUMNS

TOP ERP 6.0 | /XFT/INV_Q INDEXES