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
Public Sector Management :: Functions for U.S. Federal Government
1	ERP EHP7	6.0	FMCCRTVENDOR	120	1	CCR Vendor Table	Functions for U.S. Federal Government

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	DUNS	DUNS Number	nvarchar	9	Allow NULL?
3	DUNS4	DUNS+4	nvarchar	4	Allow NULL?
4	CAGE	CAGE Code	nvarchar	5	Allow NULL?
5	EXCODE	Extract Code	char	1	Allow NULL?
6	REGDATE	Registration date	nvarchar	8	Allow NULL?
7	RENDATE	Obsolete field (do not use) - Renewal date for CCR Vendor	nvarchar	8	Allow NULL?
8	BUSNAME		nvarchar	120	Allow NULL?
9	DBANAME		nvarchar	60	Allow NULL?
10	COMPDIV		nvarchar	60	Allow NULL?
11	DIVNUM		nvarchar	10	Allow NULL?
12	STADD1		nvarchar	55	Allow NULL?
13	STADD2		nvarchar	55	Allow NULL?
14	CITY		nvarchar	35	Allow NULL?
15	STATE		nvarchar	2	Allow NULL?
16	POSTAL		nvarchar	35	Allow NULL?
17	COUNTRY		nvarchar	3	Allow NULL?
18	BUSSTART		nvarchar	8	Allow NULL?
19	FISCEND		nvarchar	4	Allow NULL?
20	COSECLVL		nvarchar	15	Allow NULL?
21	EMSECLVL		nvarchar	15	Allow NULL?
22	URL		nvarchar	200	Allow NULL?
23	ORGTYP		nvarchar	2	Allow NULL?
24	STATEINC		nvarchar	2	Allow NULL?
25	COUNTRYINC		nvarchar	3	Allow NULL?
26	PARENTDUNS		nvarchar	13	Allow NULL?
27	BUSTYPES		nvarchar	20	Allow NULL?
28	BUSTYP01		nvarchar	2	Allow NULL?
29	BUSTYP02		nvarchar	2	Allow NULL?
30	BUSTYP03		nvarchar	2	Allow NULL?
31	BUSTYP04		nvarchar	2	Allow NULL?
32	BUSTYP05		nvarchar	2	Allow NULL?
33	BUSTYP06		nvarchar	2	Allow NULL?
34	BUSTYP07		nvarchar	2	Allow NULL?
35	BUSTYP08		nvarchar	2	Allow NULL?
36	BUSTYP09		nvarchar	2	Allow NULL?
37	BUSTYP10		nvarchar	2	Allow NULL?
38	SICCODE		nvarchar	160	Allow NULL?
39	SIC01		nvarchar	8	Allow NULL?
40	SIC02		nvarchar	8	Allow NULL?
41	SIC03		nvarchar	8	Allow NULL?
42	SIC04		nvarchar	8	Allow NULL?
43	SIC05		nvarchar	8	Allow NULL?
44	SIC06		nvarchar	8	Allow NULL?
45	SIC07		nvarchar	8	Allow NULL?
46	SIC08		nvarchar	8	Allow NULL?
47	SIC09		nvarchar	8	Allow NULL?
48	SIC10		nvarchar	8	Allow NULL?
49	SIC11		nvarchar	8	Allow NULL?
50	SIC12		nvarchar	8	Allow NULL?
51	SIC13		nvarchar	8	Allow NULL?
52	SIC14		nvarchar	8	Allow NULL?
53	SIC15		nvarchar	8	Allow NULL?
54	SIC16		nvarchar	8	Allow NULL?
55	SIC17		nvarchar	8	Allow NULL?
56	SIC18		nvarchar	8	Allow NULL?
57	SIC19		nvarchar	8	Allow NULL?
58	SIC20		nvarchar	8	Allow NULL?
59	NAICS		nvarchar	120	Allow NULL?
60	NAICS01		nvarchar	6	Allow NULL?
61	NAICS02		nvarchar	6	Allow NULL?
62	NAICS03		nvarchar	6	Allow NULL?
63	NAICS04		nvarchar	6	Allow NULL?
64	NAICS05		nvarchar	6	Allow NULL?
65	NAICS06		nvarchar	6	Allow NULL?
66	NAICS07		nvarchar	6	Allow NULL?
67	NAICS08		nvarchar	6	Allow NULL?
68	NAICS09		nvarchar	6	Allow NULL?
69	NAICS10		nvarchar	6	Allow NULL?
70	NAICS11		nvarchar	6	Allow NULL?
71	NAICS12		nvarchar	6	Allow NULL?
72	NAICS13		nvarchar	6	Allow NULL?
73	NAICS14		nvarchar	6	Allow NULL?
74	NAICS15		nvarchar	6	Allow NULL?
75	NAICS16		nvarchar	6	Allow NULL?
76	NAICS17		nvarchar	6	Allow NULL?
77	NAICS18		nvarchar	6	Allow NULL?
78	NAICS19		nvarchar	6	Allow NULL?
79	NAICS20		nvarchar	6	Allow NULL?
80	FSCCODE		nvarchar	40	Allow NULL?
81	FSC01		nvarchar	4	Allow NULL?
82	FSC02		nvarchar	4	Allow NULL?
83	FSC03		nvarchar	4	Allow NULL?
84	FSC04		nvarchar	4	Allow NULL?
85	FSC05		nvarchar	4	Allow NULL?
86	FSC06		nvarchar	4	Allow NULL?
87	FSC07		nvarchar	4	Allow NULL?
88	FSC08		nvarchar	4	Allow NULL?
89	FSC09		nvarchar	4	Allow NULL?
90	FSC10		nvarchar	4	Allow NULL?
91	PSCCODE		nvarchar	40	Allow NULL?
92	PSC01		nvarchar	4	Allow NULL?
93	PSC02		nvarchar	4	Allow NULL?
94	PSC03		nvarchar	4	Allow NULL?
95	PSC04		nvarchar	4	Allow NULL?
96	PSC05		nvarchar	4	Allow NULL?
97	PSC06		nvarchar	4	Allow NULL?
98	PSC07		nvarchar	4	Allow NULL?
99	PSC08		nvarchar	4	Allow NULL?
100	PSC09		nvarchar	4	Allow NULL?
101	PSC10		nvarchar	4	Allow NULL?
102	CREDCARD		char	1	Allow NULL?
103	CORRFLAG		char	1	Allow NULL?
104	EDI		char	1	Allow NULL?
105	TAXID	CCR TaxID	nvarchar	9	Allow NULL?
106	AVGNUMEMP		nvarchar	15	Allow NULL?
107	ANNUALREV		nvarchar	15	Allow NULL?
108	SSN		nvarchar	9	Allow NULL?
109	FININST		nvarchar	30	Allow NULL?
110	ACCNTNO		nvarchar	20	Allow NULL?
111	ABAROUTE		nvarchar	9	Allow NULL?
112	PAYTYPE		char	1	Allow NULL?
113	LOCKBOXNO		nvarchar	20	Allow NULL?
114	AUTHDATE		nvarchar	8	Allow NULL?
115	EFTWAIVER		char	1	Allow NULL?
116	ACH_US_PHONE		nvarchar	30	Allow NULL?
117	ACH_NUS_PHONE		nvarchar	30	Allow NULL?
118	ACH_FAX		nvarchar	30	Allow NULL?
119	ACH_EMAIL		nvarchar	80	Allow NULL?
120	MPIN		nvarchar	9	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

120 COLUMNS | 1 INDEXES | ERP 6.0 | FMCCRTVENDOR TABLE

TOP ERP 6.0 | FMCCRTVENDOR COLUMNS

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

120 COLUMNS | 1 INDEXES | ERP 6.0 | FMCCRTVENDOR TABLE

TOPERP 6.0 | FMCCRTVENDOR COLUMNS

TOPERP 6.0 | FMCCRTVENDOR INDEXES

TOP ERP 6.0 | FMCCRTVENDOR COLUMNS

TOP ERP 6.0 | FMCCRTVENDOR INDEXES