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
Financial Accounting :: General Ledger Accounting :: Basic Functions
1	ERP EHP7	6.0	TTXY	99	1	External tax interface: tax information	Basic Functions

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	AWTYP	Reference Transaction	nvarchar	5	Allow NULL?
3	AWREF	Reference Document Number	nvarchar	10	Allow NULL?
4	AWORG	Reference Organizational Units	nvarchar	10	Allow NULL?
5	KPOSN	Condition item number	nvarchar	6	Allow NULL?
6	MWSKZ	Tax on sales/purchases code	nvarchar	2	Allow NULL?
7	SHPTO	Tax Jurisdiction	nvarchar	15	Allow NULL?
8	CLIENT	Client	nvarchar	3	Allow NULL?
9	COMP_CODE	Company Code	nvarchar	4	Allow NULL?
10	DIVISION	Business Area	nvarchar	4	Allow NULL?
11	COUNTRY	Tax departure country	nvarchar	3	Allow NULL?
12	DOC_NUMBER	Accounting Document Number	nvarchar	10	Allow NULL?
13	POS_NO	Sales Document Item	nvarchar	6	Allow NULL?
14	ACCNT_NO	Account number	nvarchar	16	Allow NULL?
15	ACCNT_CLS	Classification item of an account (Customer/vendor)	nvarchar	10	Allow NULL?
16	TAX_DATE	Date in CHAR format	nvarchar	8	Allow NULL?
17	REP_DATE	Date in CHAR format	nvarchar	8	Allow NULL?
18	TXJCD_ST	Tax Jurisdiction	nvarchar	15	Allow NULL?
19	TXJCD_SF	Tax Jurisdiction	nvarchar	15	Allow NULL?
20	TXJCD_POA	Tax Jurisdiction	nvarchar	15	Allow NULL?
21	TXJCD_POO	Tax Jurisdiction	nvarchar	15	Allow NULL?
22	TXJCD_IND	Indicator: Jurisdiction code used for tax calculation	char	1	Allow NULL?
23	PTP_IND	Indicator: Point of Title Passage	char	1	Allow NULL?
24	APAR_IND	Indicator for A/P or A/R	char	1	Allow NULL?
25	TXJCD_L1	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	Allow NULL?
26	TXJCD_L2	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	Allow NULL?
27	TXJCD_L3	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	Allow NULL?
28	TXJCD_L4	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	Allow NULL?
29	TAX_TYPE	Indicator: Sales/use/rental/service/tax	char	1	Allow NULL?
30	MATNR	Material number with 18 characters	nvarchar	18	Allow NULL?
31	PROD_CODE	SAP internal product code (external interface)	nvarchar	10	Allow NULL?
32	QUANTITY	Quantity	nvarchar	13	Allow NULL?
33	UNIT	Unit	nvarchar	3	Allow NULL?
34	AMOUNT	Tax base amount	nvarchar	15	Allow NULL?
35	CURRENCY	Currency Key	nvarchar	5	Allow NULL?
36	CURR_DEC	Number of decimal places for currency (characters)	nvarchar	3	Allow NULL?
37	FREIGHT_AM	Freight Amount	nvarchar	15	Allow NULL?
38	EXEMPT_AMT	Exempt amount	nvarchar	15	Allow NULL?
39	EXEMPT_IND	Indicator: Transaction is tax exempt/taxable	char	1	Allow NULL?
40	CREDIT_IND	Indicator: Tax credit	char	1	Allow NULL?
41	UPDATE_IND	Audit file update indicator (external interface)	char	1	Allow NULL?
42	OVWRT_IND	Overwrite indicator	char	1	Allow NULL?
43	TAXPCT0	Level n tax rate	nvarchar	15	Allow NULL?
44	TAXPCT1	Level n tax rate	nvarchar	15	Allow NULL?
45	TAXPCT2	Level n tax rate	nvarchar	15	Allow NULL?
46	TAXPCT3	Level n tax rate	nvarchar	15	Allow NULL?
47	TAXPCT4	Level n tax rate	nvarchar	15	Allow NULL?
48	TAXPCT5	Level n tax rate	nvarchar	15	Allow NULL?
49	TAXPCT6	Level n tax rate	nvarchar	15	Allow NULL?
50	TAXPCT7	Level n tax rate	nvarchar	15	Allow NULL?
51	TAXPCT8	Level n tax rate	nvarchar	15	Allow NULL?
52	TAXPCT9	Level n tax rate	nvarchar	15	Allow NULL?
53	TAXPCOV	Total tax rate	nvarchar	15	Allow NULL?
54	TAXAMT0	Level n tax amount	nvarchar	15	Allow NULL?
55	TAXAMT1	Level n tax amount	nvarchar	15	Allow NULL?
56	TAXAMT2	Level n tax amount	nvarchar	15	Allow NULL?
57	TAXAMT3	Level n tax amount	nvarchar	15	Allow NULL?
58	TAXAMT4	Level n tax amount	nvarchar	15	Allow NULL?
59	TAXAMT5	Level n tax amount	nvarchar	15	Allow NULL?
60	TAXAMT6	Level n tax amount	nvarchar	15	Allow NULL?
61	TAXAMT7	Level n tax amount	nvarchar	15	Allow NULL?
62	TAXAMT8	Level n tax amount	nvarchar	15	Allow NULL?
63	TAXAMT9	Level n tax amount	nvarchar	15	Allow NULL?
64	TAXAMOV	Total tax amount	nvarchar	15	Allow NULL?
65	TAXBAS0	Tax base amount level n	nvarchar	15	Allow NULL?
66	TAXBAS1	Tax base amount level n	nvarchar	15	Allow NULL?
67	TAXBAS2	Tax base amount level n	nvarchar	15	Allow NULL?
68	TAXBAS3	Tax base amount level n	nvarchar	15	Allow NULL?
69	TAXBAS4	Tax base amount level n	nvarchar	15	Allow NULL?
70	TAXBAS5	Tax base amount level n	nvarchar	15	Allow NULL?
71	TAXBAS6	Tax base amount level n	nvarchar	15	Allow NULL?
72	TAXBAS7	Tax base amount level n	nvarchar	15	Allow NULL?
73	TAXBAS8	Tax base amount level n	nvarchar	15	Allow NULL?
74	TAXBAS9	Tax base amount level n	nvarchar	15	Allow NULL?
75	EXMATFLG	Code for material tax exemption	nvarchar	2	Allow NULL?
76	EXCUSFLG	Code for customer tax exemption	nvarchar	2	Allow NULL?
77	EXAMT0	Exempt amount	nvarchar	15	Allow NULL?
78	EXAMT1	Exempt amount	nvarchar	15	Allow NULL?
79	EXAMT2	Exempt amount	nvarchar	15	Allow NULL?
80	EXAMT3	Exempt amount	nvarchar	15	Allow NULL?
81	EXAMT4	Exempt amount	nvarchar	15	Allow NULL?
82	EXAMT5	Exempt amount	nvarchar	15	Allow NULL?
83	EXAMT6	Exempt amount	nvarchar	15	Allow NULL?
84	EXAMT7	Exempt amount	nvarchar	15	Allow NULL?
85	EXAMT8	Exempt amount	nvarchar	15	Allow NULL?
86	EXAMT9	Exempt amount	nvarchar	15	Allow NULL?
87	EXCODE0	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
88	EXCODE1	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
89	EXCODE2	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
90	EXCODE3	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
91	EXCODE4	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
92	EXCODE5	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
93	EXCODE6	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
94	EXCODE7	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
95	EXCODE8	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
96	EXCODE9	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
97	EXCERTIF	Customer tax exemption certificate number defined in SAP	nvarchar	25	Allow NULL?
98	EXREASON	Tax Exemption Reason Code	nvarchar	2	Allow NULL?
99	USER_DATA	User-specific field	nvarchar	50	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

99 COLUMNS | 1 INDEXES | ERP 6.0 | TTXY TABLE

TOP ERP 6.0 | TTXY COLUMNS

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

99 COLUMNS | 1 INDEXES | ERP 6.0 | TTXY TABLE

TOPERP 6.0 | TTXY COLUMNS

TOPERP 6.0 | TTXY INDEXES

TOP ERP 6.0 | TTXY COLUMNS

TOP ERP 6.0 | TTXY INDEXES