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
Administration
1	Business One	9.3	OEOY	124	1	End-of-Year Transfer	Administration

Column	Field	Description	SQL Type	Length	Relation	Default Value	Constraints	SQL Create Statement
1	GenrlDefs	General Definitions	char	1		Y	N, Y	Allow NULL?
2	ReFiles	Transfer Template Designer Files	char	1		Y	N, Y	Allow NULL?
3	ActIndex	Transfer Accounts Index	char	1		Y	N, Y	Allow NULL?
4	ActFromCod	From Code	nvarchar	15				Allow NULL?
5	ActToCode	To Code	nvarchar	15				Allow NULL?
6	ActGroup	ActGroup	nvarchar	16		255		Allow NULL?
7	CrdIndex	Transfer Credit Card Index	char	1		Y	N, Y	Allow NULL?
8	CrdFromCod	From Code	nvarchar	15				Allow NULL?
9	CrdToCode	To Code	nvarchar	15				Allow NULL?
10	CrdGrpCust	Customer Group	int	6				Allow NULL?
11	CrdGrpVndr	Vendor Group	int	6				Allow NULL?
12	CrdToknAnd	CrdToknAnd	char	1				Allow NULL?
13	CrdUseGrps	CrdUseGrps	char	1				Allow NULL?
14	CrdClsRang	CrdClsRang	char	1				Allow NULL?
15	CrdGrpData	Properties	nvarchar	64				Allow NULL?
16	ItmIndex	Transfer Item Index	char	1		Y	N, Y	Allow NULL?
17	ItmFromCod	From Code	nvarchar	50				Allow NULL?
18	ItmToCode	To Code	nvarchar	50				Allow NULL?
19	ItmGroup	Item Group	int	6				Allow NULL?
20	ItmToknAnd	ItmToknAnd	char	1				Allow NULL?
21	ItmUseGrps	ItmUseGrps	char	1				Allow NULL?
22	ItmClsRang	ItmClsRang	char	1				Allow NULL?
23	ItmGrpData	Properties	nvarchar	64				Allow NULL?
24	TransfDoc	Documents Transfer	char	1		N	N, Y	Allow NULL?
25	UnDpsChk	Transfer Undeposited Checks	char	1		N	N, Y	Allow NULL?
26	DpsChk	Transfer Postdated Checks	char	1		N	N, Y	Allow NULL?
27	UnDpsVouch	Transfer Unpaid Vouchers	char	1		N	N, Y	Allow NULL?
28	DpsVouch	Transfer Deffered Vouchers	char	1		N	N, Y	Allow NULL?
29	WorkOrder	Open Work Instructions	char	1		N	N, Y	Allow NULL?
30	RcrTrt	Posting Templates & Rec. Trans	char	1		N	N, Y	Allow NULL?
31	Connection	Activities	char	1		N	N, Y	Allow NULL?
32	SpcPrice	Special Prices	char	1		N	N, Y	Allow NULL?
33	Quotations	Transfer Open Sales Quotations	char	1		N		Allow NULL?
34	Orders	Transfer Open Orders	char	1		N	N, Y	Allow NULL?
35	DlvrNotes	Transfer Open Delivery Notes	char	1		N	N, Y	Allow NULL?
36	DlvrInvocs	Transfer Open Invoices	char	1		N	N, Y	Allow NULL?
37	P_Orders	Transfer Purchase Orders	char	1		N	N, Y	Allow NULL?
38	P_Invoices	A/P Invoices	char	1		N	N, Y	Allow NULL?
39	ProdTree	Product Tree	char	1		N	N, Y	Allow NULL?
40	Subst	Customer/Vendor Catalog No.	char	1		N	N, Y	Allow NULL?
41	Import	Landed Costs	char	1		N	N, Y	Allow NULL?
42	Revert	Returns	char	1		N	N, Y	Allow NULL?
43	ActBlnc	Transfer Account Balances	char	1		N	N, Y	Allow NULL?
44	ActRef1	Ref. 1 for Opening Bal. Trans.	nvarchar	11				Allow NULL?
45	ActRef2	Ref. 2 for Opening Bal. Trans.	nvarchar	11				Allow NULL?
46	ActRefDate	Posting Date for OB Transactions	date	8
47	ActDueDate	Due date for OB transaction	date	8
48	ActMemo	Journal Entry Details	nvarchar	50				Allow NULL?
49	AOpnBlnAct	Opening Balances Account	nvarchar	15				Allow NULL?
50	AEquetyAct	Retained Earnings Account	nvarchar	15				Allow NULL?
51	ActExpLine	Transfer Split Balances	char	1		N	E=Unreconciled Externally, N, Y=Unreconciled Internally	Allow NULL?
52	ActBlncFrC	From Code	nvarchar	15				Allow NULL?
53	ActBlncToC	To Code	nvarchar	15				Allow NULL?
54	ActBlncGrp	ActBlncGrp	nvarchar	16		YYY		Allow NULL?
55	ActZeroBln	Account Transactions with Zero Balance	char	1		Y	N, Y	Allow NULL?
56	CrdBlnc	Transfer Credit Card Balances	char	1		N	N, Y	Allow NULL?
57	CrdRef1	Ref. 1 for OB Transactions	nvarchar	11				Allow NULL?
58	CrdRef2	Ref. 2 for OB Transactions	nvarchar	11				Allow NULL?
59	CrdRefDate	Posting Date for OB Transactions	date	8
60	CrdDueDate	Due date for OB transaction	date	8
61	CrdMemo	Journal Entry Details	nvarchar	50				Allow NULL?
62	COpnBlnAct	Opening Balances Account	nvarchar	15				Allow NULL?
63	CrdExpLine	Transfer Split Balances	char	1		N	N, Y	Allow NULL?
64	CrdBlncFrC	From Code	nvarchar	15				Allow NULL?
65	CrdBlncToC	To Code	nvarchar	15				Allow NULL?
66	CrdBlncGrC	Customer Group	int	6				Allow NULL?
67	CrdBlnGrpV	Vendor Group	int	6				Allow NULL?
68	CrdBTknAnd	CrdBTknAnd	char	1				Allow NULL?
69	CrdBUseGrp	CrdBUseGrp	char	1				Allow NULL?
70	CrdBClsRng	CrdBClsRng	char	1				Allow NULL?
71	CrdBGrpDat	Properties	nvarchar	64				Allow NULL?
72	CrdZeroBln	Card Transactions with Zero Balance	char	1		Y	N, Y	Allow NULL?
73	ItmBlnc	Transfer Item Balances	char	1		N	N, Y	Allow NULL?
74	ItmRef1	Ref. 1 for Opening Bal. Trans.	nvarchar	11				Allow NULL?
75	ItmRef2	Ref. 2 for Opening Bal. Trans.	nvarchar	11				Allow NULL?
76	ItmRefDate	Posting Date for OB Transaction	date	8
77	ItmMemo	Journal Entry Details	nvarchar	50				Allow NULL?
78	ItmBlncFrC	From Code	nvarchar	50				Allow NULL?
79	ItmBlncToC	To Code	nvarchar	50				Allow NULL?
80	ItmBlncGrp	Item Group	int	6				Allow NULL?
81	ItmBTknAnd	ItmBTknAnd	char	1				Allow NULL?
82	ItmBUseGrp	ItmBUseGrp	char	1				Allow NULL?
83	ItmBClsRng	ItmBClsRng	char	1				Allow NULL?
84	ItmBGrpDat	Properties	nvarchar	64				Allow NULL?
85	ItmPlnNum	Transaction Price List	int	6		1		Allow NULL?
86	ItmZeroPr	Transfer Items Without Price	char	1		N	N, Y	Allow NULL?
87	FileReport	Create Report File	char	1		Y	N, Y	Allow NULL?
88	CompName	Company Name for Transfering	nvarchar	100				Allow NULL?
89	WasGnrlDef	Was general data transferred	char	1		N	N, Y	Allow NULL?
90	P_DlvrNots	Transfer PO Del. Notes	char	1		N	N, Y	Allow NULL?
91	Spg	Transfer Discount for Groups	char	1		N	N, Y	Allow NULL?
92	Pdn	Purchase Delivery Notes	char	1		N	N, Y	Allow NULL?
93	PdnClosed	Closed Purchase Delivery Notes	char	1		N	N, Y	Allow NULL?
94	Rpd	Revert Purchase Delivery Notes	char	1		N	N, Y	Allow NULL?
95	ReportTemp	Report Templates	char	1		N	N, Y	Allow NULL?
96	Confirmat	Confirmation	char	1		N	N, Y	Allow NULL?
97	DocDraft	Document Drafts	char	1		N	N, Y	Allow NULL?
98	ChkOutDrft	Checks for Payment Drafts	char	1		N	N, Y	Allow NULL?
99	OptOpen	Open Opportunities	char	1		N	N, Y	Allow NULL?
100	OptClosed	Closed Opportunities	char	1		N	N, Y	Allow NULL?
101	SerBtchNum	Batch/Serial No.	char	1		N	N, Y	Allow NULL?
102	CorrInvoic	Correction Invoice	char	1		N	N, Y	Allow NULL?
103	UserGign	User Signature	int	6	OUSR			Allow NULL?
104	PaymDraf	Payment Draft	char	1		N	N, Y	Allow NULL?
105	PaymentWiz	Saved Payment Wizard	char	1		N	N=No, Y=Yes	Allow NULL?
106	AltItems	Alternative Items	char	1		N	N=No, Y=Yes	Allow NULL?
107	DPIInvoice	A/R Down Payment Invoice	char	1		N		Allow NULL?
108	DPIRequest	A/R Down Payment Request	char	1		N	N=No, Y=Yes	Allow NULL?
109	Ctr	Service Contracts	char	1		N	N=No, Y=Yes	Allow NULL?
110	Ins	Customer Equipment Card	char	1		N	N=No, Y=Yes	Allow NULL?
111	CorrAPInv	A/P Correction Invoice	char	1		N	N=No, Y=Yes	Allow NULL?
112	CorrAPRev	A/P Correction Invoice Reversal	char	1		N	N=No, Y=Yes	Allow NULL?
113	CorrARInv	A/R Correction Invoice	char	1		N	N=No, Y=Yes	Allow NULL?
114	CorrARRev	A/R Correction Invoice Reversal	char	1		N	N=No, Y=Yes	Allow NULL?
115	UserObj	User Object	char	1		N	N=No, Y=Yes	Allow NULL?
116	AdWrkOrdr	Advanced Work Order	char	1		N	N=No, Y=Yes	Allow NULL?
117	DPOInvoice	A/P Down Payment Invoice	char	1		N	N=No, Y=Yes	Allow NULL?
118	DPORequest	A/P Down Payment Request	char	1		N	N=No, Y=Yes	Allow NULL?
119	P_Quotatio	Transfer Open Pur. Quotations	char	1		N	N=No, Y=Yes	Allow NULL?
120	WTQ	Inventory Transfer Requests	char	1		N	N=No, Y=Yes	Allow NULL?
121	Oat	Blanket Agreement	char	1		N	N=No, Y=Yes	Allow NULL?
122	CPN	Campaign	char	1		N	N=No, Y=Yes	Allow NULL?
123	AdvRules	Transfer Advanced Rules	char	1		N	N=No, Y=Yes	Allow NULL?
124	Prq	Purchase Request	char	1		N		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

124 COLUMNS | 1 INDEXES | B1 9.3 | OEOY TABLE

TOP B1 9.3 | OEOY COLUMNS

TOP B1 9.3 | OEOY 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

124 COLUMNS | 1 INDEXES | B1 9.3 | OEOY TABLE

TOPB1 9.3 | OEOY COLUMNS

TOPB1 9.3 | OEOY INDEXES

TOP B1 9.3 | OEOY COLUMNS

TOP B1 9.3 | OEOY INDEXES