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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Banking
1	Business One	8.82	ARCT	168	6	Incoming Payment - History	Banking

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Internal Number	int	11	0				Allow NULL?
2	DocNum	Document Number	int	11	0				Allow NULL?
3	DocType	Document Type	char	1	0		C	A, C, D, P, S, T	Allow NULL?
4	Canceled	Cancelled	char	1	0		N	N, Y	Allow NULL?
5	Handwrtten	Manual Numbering	char	1	0		N	N, Y	Allow NULL?
6	Printed	Printed	char	1	0		N	N, Y	Allow NULL?
7	DocDate	Posting Date	date	8	0
8	DocDueDate	Due Date	date	8	0
9	CardCode	BP Code	nvarchar	15	0				Allow NULL?
10	CardName	BP Name	nvarchar	100	0				Allow NULL?
11	Address	Address	nvarchar	254	0				Allow NULL?
12	DdctPrcnt	Deduction %	num	19	6				Allow NULL?
13	DdctSum	Total Deductions	num	19	6				Allow NULL?
14	DdctSumFC	Total Deductions (FC)	num	19	6				Allow NULL?
15	CashAcct	Cash Account	nvarchar	15	0	OACT			Allow NULL?
16	CashSum	Cash Amount	num	19	6				Allow NULL?
17	CashSumFC	Cash Amount (FC)	num	19	6				Allow NULL?
18	CreditSum	Credit Amount	num	19	6				Allow NULL?
19	CredSumFC	Credit Amount (FC)	num	19	6				Allow NULL?
20	CheckAcct	Cash Account	nvarchar	15	0	OACT			Allow NULL?
21	CheckSum	Check Amount	num	19	6				Allow NULL?
22	CheckSumFC	Check Amount (FC)	num	19	6				Allow NULL?
23	TrsfrAcct	Bank Transfer Account	nvarchar	15	0	OACT			Allow NULL?
24	TrsfrSum	Bank Transfer Amount	num	19	6				Allow NULL?
25	TrsfrSumFC	Bank Transfer Amount (FC)	num	19	6				Allow NULL?
26	TrsfrDate	Bank Transfer Date	date	8	0
27	TrsfrRef	Intended Purpose	nvarchar	27	0				Allow NULL?
28	PayNoDoc	Non-Calculated Payment	char	1	0		N	N, Y	Allow NULL?
29	NoDocSum	Non-Calculated Amount	num	19	6				Allow NULL?
30	NoDocSumFC	Non-Calculated Amount (FC)	num	19	6				Allow NULL?
31	DocCurr	Document Currency	nvarchar	3	0	OCRN			Allow NULL?
32	DiffCurr	Entered in LC	char	1	0		N	N, Y	Allow NULL?
33	DocRate	Document Rate	num	19	6				Allow NULL?
34	SysRate	Price (SC)	num	19	6				Allow NULL?
35	DocTotal	Total Document	num	19	6				Allow NULL?
36	DocTotalFC	Total Document (FC)	num	19	6				Allow NULL?
37	Ref1	Ref. 2	nvarchar	8	0				Allow NULL?
38	Ref2	Ref. 3	nvarchar	8	0				Allow NULL?
39	CounterRef	Counter Reference	nvarchar	8	0				Allow NULL?
40	Comments	Remarks	nvarchar	254	0				Allow NULL?
41	JrnlMemo	Journal Remark	nvarchar	50	0				Allow NULL?
42	TransId	Transaction Number	int	11	0	OJDT			Allow NULL?
43	DocTime	Creation Time	int	6	0				Allow NULL?
44	ShowAtCard	Display Customer Ref. No.	char	1	0		N	N, Y	Allow NULL?
45	SpiltTrans	Split Journal Entry	char	1	0		N	N, Y	Allow NULL?
46	CreateTran	Create Journal Entry	char	1	0		Y	N, Y	Allow NULL?
47	Flags	Flags	int	11	0		0		Allow NULL?
48	CntctCode	Contact Person	int	11	0	OCPR			Allow NULL?
49	DdctSumSy	Deduction Amount (SC)	num	19	6				Allow NULL?
50	CashSumSy	Cash Amount in (SC)	num	19	6				Allow NULL?
51	CredSumSy	Credit Amount (SC)	num	19	6				Allow NULL?
52	CheckSumSy	Check Amount (SC)	num	19	6				Allow NULL?
53	TrsfrSumSy	Bank Transfer Amount (SC)	num	19	6				Allow NULL?
54	NoDocSumSy	Not Invoiced Amount (SC)	num	19	6				Allow NULL?
55	DocTotalSy	Total Document (SC)	num	19	6				Allow NULL?
56	ObjType	Object Type	nvarchar	20	0				Allow NULL?
57	StornoRate	Cancellation Rate	num	19	6				Allow NULL?
58	UpdateDate	Date of Update	date	8	0
59	CreateDate	Creation Date	date	8	0
60	ApplyVAT	Tax Definition	char	1	0		N	N, Y	Allow NULL?
61	TaxDate	Document Date	date	8	0
62	Series	Series	int	6	0	NNM1			Allow NULL?
63	confirmed	Approved	char	1	0		N	N, Y	Allow NULL?
64	ShowJDT	Display Journal Entries	char	1	0		N	N, Y	Allow NULL?
65	BankCode	Bank Code for Bank Transfer	nvarchar	30	0				Allow NULL?
66	BankAcct	Account for Bank Transfer	nvarchar	50	0				Allow NULL?
67	DataSource	Data Source	char	1	0		N	A, B, D, I, M, N, O, P, T, U	Allow NULL?
68	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
69	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
70	VatGroup	Tax Group	nvarchar	8	0	OVTG			Allow NULL?
71	VatSum	Tax Amount	num	19	6				Allow NULL?
72	VatSumFC	Tax Amount (FC)	num	19	6				Allow NULL?
73	VatSumSy	Tax Amount (SC)	num	19	6				Allow NULL?
74	FinncPriod	Posting Period	int	11	0	OFPR			Allow NULL?
75	VatPrcnt	Tax %	num	19	6				Allow NULL?
76	Dcount	Discount	num	19	6				Allow NULL?
77	DcntSum	Discount Amount	num	19	6				Allow NULL?
78	DcntSumFC	Discount Amount (FC)	num	19	6				Allow NULL?
79	DcntSumSy	Discount Amount (SC)	num	19	6				Allow NULL?
80	SpltCredLn	Split Credit Voucher	char	1	0		N	N, Y	Allow NULL?
81	PrjCode	Project Code	nvarchar	20	0	OPRJ			Allow NULL?
82	PaymentRef	Payment Reference No.	nvarchar	27	0				Allow NULL?
83	Submitted	Submitted	char	1	0		N	N, Y	Allow NULL?
84	Status	Created by Payment Wizard	char	1	0		N	C, N, Y	Allow NULL?
85	PayMth	Payment Method	nvarchar	15	0	OPYM			Allow NULL?
86	BankCountr	Bank Country	nvarchar	3	0	OCRY			Allow NULL?
87	FreightSum	Freight Sum	num	19	6				Allow NULL?
88	FreigtFC	Freight Sum (FC)	num	19	6				Allow NULL?
89	FreigtSC	Freight Sum (SC)	num	19	6				Allow NULL?
90	BoeAcc	Boe Account	nvarchar	15	0	OACT			Allow NULL?
91	BoeNum	Bill of Exchange No.	int	11	0				Allow NULL?
92	BoeSum	Bill of Exchange Amount	num	19	6				Allow NULL?
93	BoeSumFc	Bill of Exchange Amount (FC)	num	19	6				Allow NULL?
94	BoeSumSc	Bill of Exchange Amount (SC)	num	19	6				Allow NULL?
95	BoeAgent	Bill of Exchange Agent	nvarchar	32	0	OAGP			Allow NULL?
96	BoeStatus	Bill of Exchange Status	char	1	0				Allow NULL?
97	WtCode	WTax Code	nvarchar	4	0	OWHT			Allow NULL?
98	WtSum	WTax Amount	num	19	6				Allow NULL?
99	WtSumFrgn	WTax Amount (FC)	num	19	6				Allow NULL?
100	WtSumSys	WTax Amount (FC)	num	19	6				Allow NULL?
101	WtAccount	WTax Account	nvarchar	15	0	OACT			Allow NULL?
102	WtBaseAmnt	WTax Taxable Amount	num	19	6				Allow NULL?
103	Proforma	Proforma	char	1	0		N	N, Y	Allow NULL?
104	BoeAbs	Boe Key	int	11	0	OBOE			Allow NULL?
105	BpAct	BP Account	nvarchar	15	0	OACT			Allow NULL?
106	BcgSum	Bank Charges Amount	num	19	6				Allow NULL?
107	BcgSumFC	Bank Charges Amount (FC)	num	19	6				Allow NULL?
108	BcgSumSy	Bank Charges Amount (SC)	num	19	6				Allow NULL?
109	PIndicator	Period Indicator	nvarchar	10	0	OPID			Allow NULL?
110	PaPriority	Payment Priority	char	1	0		6	1, 2, 3, 4, 5, 6	Allow NULL?
111	PayToCode	Pay to	nvarchar	50	0				Allow NULL?
112	IsPaytoBnk	Is Pay to Bank	char	1	0		N	N, Y	Allow NULL?
113	PBnkCnt	Pay to Bank Country	nvarchar	3	0	OCRY			Allow NULL?
114	PBnkCode	Pay to Bank Code	nvarchar	30	0				Allow NULL?
115	PBnkAccnt	Pay to Bank Account No.	nvarchar	50	0				Allow NULL?
116	PBnkBranch	Pay to Bank Branch	nvarchar	50	0				Allow NULL?
117	WizDunBlck	Wizard Dunning Block	char	1	0		N	N, Y	Allow NULL?
118	WtBaseSum	WTax Base Sum	num	19	6				Allow NULL?
119	WtBaseSumF	WTax Base Sum (FC)	num	19	6				Allow NULL?
120	WtBaseSumS	WTax Base Sum (SC)	num	19	6				Allow NULL?
121	UndOvDiff	Under/Overpayment Difference	num	19	6				Allow NULL?
122	UndOvDiffS	Under/Overpayment Diff. (SC)	num	19	6				Allow NULL?
123	BankActKey	Bank Account Internal ID	int	11	0	DSC1			Allow NULL?
124	VersionNum	Version Number	nvarchar	11	0				Allow NULL?
125	VatDate	Tax Date	date	8	0
126	TransCode	Transaction Code	nvarchar	4	0	OTRC			Allow NULL?
127	PaymType	Payment Type	char	1	0		N	E, N, P, T, X	Allow NULL?
128	TfrRealAmt	Transfer Real Amount	num	19	6				Allow NULL?
129	CancelDate	Cancellation Date	date	8	0
130	OpenBal	Open Balance Amount	num	19	6				Allow NULL?
131	OpenBalFc	Open Balance Amount (FC)	num	19	6				Allow NULL?
132	OpenBalSc	Open Balance Amount (SC)	num	19	6				Allow NULL?
133	BcgTaxSum	Bank Charge Tax Amount	num	19	6				Allow NULL?
134	BcgTaxSumF	Bank Charge Tax Amount(FC)	num	19	6				Allow NULL?
135	BcgTaxSumS	Bank Charge Tax Amount(SC)	num	19	6				Allow NULL?
136	TpwID	Tax Payment Wizard ID	int	11	0		0		Allow NULL?
137	ChallanNo	Challan No.	nvarchar	32	0				Allow NULL?
138	ChallanBak	Challan Bank Name	nvarchar	60	0				Allow NULL?
139	ChallanDat	Challan Received Date	date	8	0
140	WddStatus	Authorization Status	char	1	0		-	-, A, C, N, P, W, Y	Allow NULL?
141	BcgVatGrp	Bank Charge Tax Group	nvarchar	8	0	OVTG			Allow NULL?
142	BcgVatPcnt	Bank Charge Tax %	num	19	6				Allow NULL?
143	SeqCode	Sequence Code	int	6	0				Allow NULL?
144	Serial	Serial Number	int	11	0				Allow NULL?
145	SeriesStr	Series String	nvarchar	3	0				Allow NULL?
146	SubStr	Subseries String	nvarchar	3	0				Allow NULL?
147	BSRCode	BSR Code	nvarchar	25	0				Allow NULL?
148	LocCode	Location Code	int	11	0	OLCT			Allow NULL?
149	WTOnhldPst	WTax On Hold, Posted	num	19	6				Allow NULL?
150	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
151	BuildDesc	Build Descriptor	nvarchar	50	0				Allow NULL?
152	ResidenNum	Residence Number	char	1	0		1	1, 2, 3, 4, 5, 6	Allow NULL?
153	OperatCode	Operation Code	char	1	0			A, B, C, D, E, F, G, H, I, J, K	Allow NULL?
154	UndOvDiffF	Under/Overpayment Diff. (FC)	num	19	6				Allow NULL?
155	MIEntry	MI Entry Include this Payment	int	11	0		0		Allow NULL?
156	FreeText1	Free Text 1	nvarchar	100	0				Allow NULL?
157	FreeText2	Free Text 2	nvarchar	100	0				Allow NULL?
158	FreeText3	Free Text 3	nvarchar	100	0				Allow NULL?
159	ShowDocNo	Display Document No.	char	1	0		Y	N, Y	Allow NULL?
160	TDSInterst	TDS Interest	num	19	6		0		Allow NULL?
161	TDSCharges	TDS Other Charges	num	19	6		0		Allow NULL?
162	CUP	Unique Code of Project	int	11	0	OCUP			Allow NULL?
163	CIG	Contract Code Identification	int	11	0	OCIG			Allow NULL?
164	MIType	MI Type Include this Payment	nvarchar	20	0			140000014, 270	Allow NULL?
165	SupplCode	Supplementary Code	nvarchar	254	0				Allow NULL?
166	BPLId	Branch	int	11	0	OBPL			Allow NULL?
167	BPLName	Branch Name	nvarchar	100	0				Allow NULL?
168	VATRegNum	VAT Reg. Number	nvarchar	32	0				Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	DocEntry, LogInstanc, ObjType
NUM	No	Yes	DocNum, LogInstanc, ObjType, PIndicator
CARD	No	No	CardCode
HANDWRITEN	No	No	Handwrtten
CANCELED	No	No	Canceled
SERIES	No	No	Series

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

168 COLUMNS | 6 INDEXES | B1 8.82 | ARCT TABLE

TOP B1 8.82 | ARCT COLUMNS

TOP B1 8.82 | ARCT 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

168 COLUMNS | 6 INDEXES | B1 8.82 | ARCT TABLE

TOPB1 8.82 | ARCT COLUMNS

TOPB1 8.82 | ARCT INDEXES

TOP B1 8.82 | ARCT COLUMNS

TOP B1 8.82 | ARCT INDEXES