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
Banking
1	Business One	9.3	OPDF	183	6	Payment Draft	Banking

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Numerator	int	11	0				Allow NULL?
2	DocNum	Document Number	int	11	0				Allow NULL?
3	DocType	Document Type	char	1	0			A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor	Allow NULL?
4	Canceled	Canceled	char	1	0			N=No, Y=Yes	Allow NULL?
5	Handwrtten	Manual Numbering	char	1	0			N=No, Y=Yes	Allow NULL?
6	Printed	Printed	char	1	0		N	N=Original, Y=Copy	Allow NULL?
7	DocDate	Posting Date	date	8	0
8	DocDueDate	Value Date	date	8	0
9	CardCode	Customer/Vendor Code	nvarchar	15	0				Allow NULL?
10	CardName	Customer/Vendor Name	nvarchar	100	0				Allow NULL?
11	Address	Address	nvarchar	254	0				Allow NULL?
12	DdctPrcnt	Deduction Percent	num	19	6				Allow NULL?
13	DdctSum	Total Deductions	num	19	6				Allow NULL?
14	DdctSumFC	Total Deductions in 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 in FC	num	19	6				Allow NULL?
18	CreditSum	Credit Amount	num	19	6				Allow NULL?
19	CredSumFC	Credit Amount in FC	num	19	6				Allow NULL?
20	CheckAcct	Current Account	nvarchar	15	0	OACT			Allow NULL?
21	CheckSum	Check Amount	num	19	6				Allow NULL?
22	CheckSumFC	Check Amount in FC	num	19	6				Allow NULL?
23	TrsfrAcct	Transfer Account	nvarchar	15	0	OACT			Allow NULL?
24	TrsfrSum	Transfer Amount	num	19	6				Allow NULL?
25	TrsfrSumFC	Transfer Amount in FC	num	19	6				Allow NULL?
26	TrsfrDate	Transfer Date	date	8	0
27	TrsfrRef	Intended Purpose	nvarchar	27	0				Allow NULL?
28	PayNoDoc	Non-Calculated Payment	char	1	0		N	N=No, Y=Yes	Allow NULL?
29	NoDocSum	Non-Calculated Amount	num	19	6				Allow NULL?
30	NoDocSumFC	Non-Calculated Amount in FC	num	19	6				Allow NULL?
31	DocCurr	Document Currency	nvarchar	3	0	OCRN			Allow NULL?
32	DiffCurr	Enter in local currency	char	1	0		N	N=No, Y=Yes	Allow NULL?
33	DocRate	Document Rate	num	19	6				Allow NULL?
34	SysRate	System Price	num	19	6				Allow NULL?
35	DocTotal	Document Total	num	19	6				Allow NULL?
36	DocTotalFC	Document Total in FC	num	19	6				Allow NULL?
37	Ref1	Reference 1	nvarchar	11	0				Allow NULL?
38	Ref2	Reference 2	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 Remarks	nvarchar	50	0				Allow NULL?
42	TransId	Transaction Number	int	11	0	OJDT			Allow NULL?
43	DocTime	Generation Time	int	6	0				Allow NULL?
44	ShowAtCard	Display Customer Ref. No.	char	1	0		N	N=No, Y=Yes	Allow NULL?
45	SpiltTrans	Split Transaction Journal	char	1	0		N	N=No, Y=Yes	Allow NULL?
46	CreateTran	Create Journal Entry	char	1	0		Y	N=No, Y=Yes	Allow NULL?
47	Flags	Flags	int	11	0		0		Allow NULL?
48	CntctCode	Contact Person	int	11	0	OCPR			Allow NULL?
49	DdctSumSy	System Deduction Amount	num	19	6				Allow NULL?
50	CashSumSy	Cash Amount in SC	num	19	6				Allow NULL?
51	CredSumSy	System Credit Amount	num	19	6				Allow NULL?
52	CheckSumSy	Check Amount in SC	num	19	6				Allow NULL?
53	TrsfrSumSy	Transfer Amount in SC	num	19	6				Allow NULL?
54	NoDocSumSy	Non-Invoiced System Amount	num	19	6				Allow NULL?
55	DocTotalSy	Document Total in SC	num	19	6				Allow NULL?
56	ObjType	Object Type	nvarchar	20	0	ADP1		24=Incoming Payment, 46=Outgoing Payments	Allow NULL?
57	StornoRate	Cancellation Rate	num	19	6				Allow NULL?
58	UpdateDate	Update Date	date	8	0
59	CreateDate	Creation Date	date	8	0
60	ApplyVAT	Tax Definition	char	1	0		N	N=No, Y=Yes	Allow NULL?
61	TaxDate	Tax Date	date	8	0
62	Series	Series	int	11	0	NNM1			Allow NULL?
63	confirmed	Approved	char	1	0		N	N=No, Y=Yes	Allow NULL?
64	ShowJDT	Display Journal Entries	char	1	0			N=No, Y=Yes	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=Doc. Generation Wizard, B=BSP, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
68	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
69	LogInstanc	Log Instance	int	11	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 Vendor Credit Row	char	1	0			N=No, Y=Yes	Allow NULL?
81	PrjCode	Project	nvarchar	20	0	OPRJ			Allow NULL?
82	PaymentRef	Payment Reference	nvarchar	27	0				Allow NULL?
83	Submitted	Submitted	char	1	0		N	N=No, Y=Yes	Allow NULL?
84	Status	Created by Payment Run	char	1	0		N	C=BoE Canceled, N=No, Y=Yes	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	WT Code	nvarchar	4	0	OWHT			Allow NULL?
98	WtSum	WT Amount	num	19	6				Allow NULL?
99	WtSumFrgn	WT Amount (FC)	num	19	6				Allow NULL?
100	WtSumSys	WT Amount (SC)	num	19	6				Allow NULL?
101	WtAccount	WT Account	nvarchar	15	0	OACT			Allow NULL?
102	WtBaseAmnt	WT Taxable Amount	num	19	6				Allow NULL?
103	Proforma	Proforma	char	1	0		N	N=No, Y=Yes	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 Charge Amount	num	19	6				Allow NULL?
107	BcgSumFC	Bank Charge Amount in FC	num	19	6				Allow NULL?
108	BcgSumSy	Bank Charge Amount in 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=No, Y=Yes	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=No., Y=YES	Allow NULL?
118	WtBaseSum	Wt Base Sum	num	19	6				Allow NULL?
119	WtBaseSumF	Wt Base Sum (FC)	num	19	6				Allow NULL?
120	WtBaseSumS	Wt 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=Electronic, N, P=Mail, T=Telegraph, X=Express	Allow NULL?
128	TfrRealAmt	Transfer Real Amount	num	19	6				Allow NULL?
129	CancelDate	Cancelation 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		-	-=Without, A=Generated by Authorizer, C=Canceled, N=Rejected, P=Generated, W=Pending, Y=Approved	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=Spanish Fiscal ID, 2=VAT Registration Number, 3=Passport, 4=Fiscal ID Issued by the Residence Country, 5=Certificate of Fiscal Residence, 6=Other Document	Allow NULL?
153	OperatCode	Operation Code	char	1	0			A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio	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=No, Y=Yes	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=A/P Monthly Invoice, 270=A/R Monthly Invoice	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?
169	BPLCentPmt	Centralized Payment	char	1	0		N	N=No, Y=Yes	Allow NULL?
170	DraftKey	Payment Draft Internal ID	int	11	0	OPDF			Allow NULL?
171	TDSFee	TDS Fee	num	19	6				Allow NULL?
172	MinHeadCL	Minor Head of Challan	int	11	0			200=TDS Payable by Taxpayer, 400=TDS Regular Assessment (Raised by IT Dept)	Allow NULL?
173	SEPADate	Requested SEPA Pmt Date	date	8	0
174	OwnerCode	Payment Owner	int	11	0	OHEM			Allow NULL?
175	AgrNo	Agreement No.	int	11	0	OOAT			Allow NULL?
176	CreateTS	Create Time - Incl. Secs	int	11	0				Allow NULL?
177	UpdateTS	Update Full Time	int	11	0				Allow NULL?
178	TDSType	TDS Type	char	1	0			C=GST TCS, D=GST TDS, E=eTDS	Allow NULL?
179	DrNo	Dr. No.	nvarchar	32	0				Allow NULL?
180	PmntWTCert	Payment by WT Certificate Only	char	1	0		N	N=No, Y=Yes	Allow NULL?
181	EnPBnkAcct	Encryption of Pay to Bank Acct	text	16	0
182	EncryptIV	Encrypt IV	nvarchar	100	0				Allow NULL?
183	DPPStatus	Data Protection Status	char	1	0		N	D=Erased, N=None	Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	DocEntry
NUM	No	No	DocNum, 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

183 COLUMNS | 6 INDEXES | B1 9.3 | OPDF TABLE

TOP B1 9.3 | OPDF COLUMNS

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

183 COLUMNS | 6 INDEXES | B1 9.3 | OPDF TABLE

TOPB1 9.3 | OPDF COLUMNS

TOPB1 9.3 | OPDF INDEXES

TOP B1 9.3 | OPDF COLUMNS

TOP B1 9.3 | OPDF INDEXES