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

Column	Field	Description	SQL Type	Length	Decimals	Default Value	Constraints	SQL Create Statement
1	TransId	Transaction Key	int	11	0			Allow NULL?
2	Line_ID	Row Number	int	11	0	0		Allow NULL?
3	Account	Account Code	nvarchar	15	0			Allow NULL?
4	Debit	Debit Amount	num	19	6			Allow NULL?
5	Credit	Credit Amount	num	19	6			Allow NULL?
6	SYSCred	System Credit Amount	num	19	6			Allow NULL?
7	SYSDeb	System Debit Amount	num	19	6			Allow NULL?
8	FCDebit	Debit Amount (FC)	num	19	6			Allow NULL?
9	FCCredit	Credit Amount (FC)	num	19	6			Allow NULL?
10	FCCurrency	Foreign Currency	nvarchar	3	0			Allow NULL?
11	DueDate	Due Date	date	8	0
12	SourceID	Source Key	int	11	0			Allow NULL?
13	SourceLine	Source Row Number	int	6	0			Allow NULL?
14	ShortName	BP/Account Code	nvarchar	15	0			Allow NULL?
15	IntrnMatch	Internal Reconciliation No.	int	11	0	0		Allow NULL?
16	ExtrMatch	External Reconciliation No.	int	11	0	0		Allow NULL?
17	ContraAct	Offset Account	nvarchar	15	0			Allow NULL?
18	LineMemo	Row Details	nvarchar	50	0			Allow NULL?
19	Ref3Line	Reference 3	nvarchar	27	0			Allow NULL?
20	TransType	Original Journal	nvarchar	20	0	-1	(-0=(-, (-1=(-, (-2=(-, (-3=(-, (-4=(-, (-5=(-, -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 10000079=TDS Adjustment, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 164=A/P Cor	Allow NULL?
21	RefDate	Posting Date	date	8	0
22	Ref2Date	Posting Date 3	date	8	0
23	Ref1	Reference 1	nvarchar	100	0			Allow NULL?
24	Ref2	Reference 2	nvarchar	100	0			Allow NULL?
25	CreatedBy	Origin	int	11	0			Allow NULL?
26	BaseRef	Base Reference	nvarchar	11	0			Allow NULL?
27	Project	Project Code	nvarchar	20	0			Allow NULL?
28	TransCode	Transaction Code	nvarchar	4	0			Allow NULL?
29	ProfitCode	Distribution Rule	nvarchar	8	0			Allow NULL?
30	TaxDate	Document Date	date	8	0
31	SystemRate	System Price	num	19	6			Allow NULL?
32	MthDate	Reconciliation Date	date	8	0
33	ToMthSum	Reconciliation Total	num	19	6			Allow NULL?
34	UserSign	User Signature	int	6	0			Allow NULL?
35	BatchNum	Journal Voucher No.	int	11	0			Allow NULL?
36	FinncPriod	Posting Period	int	11	0			Allow NULL?
37	RelTransId	Linked Transaction Key	int	11	0	-1		Allow NULL?
38	RelLineID	Linked Row No.	int	11	0	-1		Allow NULL?
39	RelType	Link Type	char	1	0	N	D=WTax Deduction - Correction, N=Without Link	Allow NULL?
40	LogInstanc	Log Instance	int	11	0	0		Allow NULL?
41	VatGroup	Tax Group	nvarchar	8	0			Allow NULL?
42	BaseSum	Base Amount	num	19	6			Allow NULL?
43	VatRate	Tax %	num	19	6			Allow NULL?
44	Indicator	Indicator Code	nvarchar	2	0			Allow NULL?
45	AdjTran	Adjusting Trans. (Period 13)	char	1	0	N	N=No, Y=Yes	Allow NULL?
46	RevSource	Revaluation Source	char	1	0	N	F=Foreign Currency, N=No, S=System	Allow NULL?
47	ObjType	Object Type	nvarchar	20	0	30		Allow NULL?
48	VatDate	Document Date	date	8	0
49	PaymentRef	Payment Reference No.	nvarchar	27	0			Allow NULL?
50	SYSBaseSum	System Base Amount	num	19	6			Allow NULL?
51	MultMatch	Multiple BP Reconciliation No.	int	11	0	0		Allow NULL?
52	VatLine	VAT Row	char	1	0	N	N=No, Y=Yes	Allow NULL?
53	VatAmount	VAT Amount	num	19	6			Allow NULL?
54	SYSVatSum	System VAT Amount	num	19	6			Allow NULL?
55	Closed	Closed	char	1	0	N		Allow NULL?
56	GrossValue	Gross Value	num	19	6			Allow NULL?
57	CheckAbs	Internal Check Number	int	11	0			Allow NULL?
58	LineType	Line Type	int	11	0	0		Allow NULL?
59	DebCred	Debit Credit Line Indicator	char	1	0		C=Credit, D=Debit	Allow NULL?
60	SequenceNr	Assigned Sequence No.	int	11	0	0		Allow NULL?
61	StornoAcc	Storno Account Code	nvarchar	15	0			Allow NULL?
62	BalDueDeb	Balance Due - Debit	num	19	6			Allow NULL?
63	BalDueCred	Balance Due - Credit	num	19	6			Allow NULL?
64	BalFcDeb	Balance Due (FC) - Debit	num	19	6			Allow NULL?
65	BalFcCred	Balance Due (FC) - Credit	num	19	6			Allow NULL?
66	BalScDeb	Balance Due (SC) - Debit	num	19	6			Allow NULL?
67	BalScCred	Balance Due (SC) - Credit	num	19	6			Allow NULL?
68	IsNet	Use Net Amount	char	1	0	Y	N=No, Y=Yes	Allow NULL?
69	DunWizBlck	Wizard Dunning Block	char	1	0	N	, N=No, Y=Yes	Allow NULL?
70	DunnLevel	Dunning Level	int	11	0	0		Allow NULL?
71	DunDate	Last Dunning Date	date	8	0
72	TaxType	Tax Type	int	6	0	0		Allow NULL?
73	TaxPostAcc	Tax Posting Account	char	1	0	N	N, P=Purchasing Tax Account, R=Sales Tax Account	Allow NULL?
74	StaCode	Authority Code	nvarchar	8	0			Allow NULL?
75	StaType	Authority Type	int	11	0			Allow NULL?
76	TaxCode	Tax Code	nvarchar	8	0			Allow NULL?
77	ValidFrom	Valid From	date	8	0	19000101		Allow NULL?
78	GrossValFc	Gross Value (FC)	num	19	6			Allow NULL?
79	LvlUpdDate	Dunning Level Update Date	date	8	0
80	OcrCode2	Costing Code 2	nvarchar	8	0			Allow NULL?
81	OcrCode3	Costing Code 3	nvarchar	8	0			Allow NULL?
82	OcrCode4	Costing Code 4	nvarchar	8	0			Allow NULL?
83	OcrCode5	Costing Code 5	nvarchar	8	0			Allow NULL?
84	MIEntry	MI Entry when include this OB	int	11	0	0		Allow NULL?
85	MIVEntry	A/P Monthly Invoice	int	11	0	0		Allow NULL?
86	ClsInTP	Tax Payment Wizard	int	11	0	0		Allow NULL?
87	CenVatCom	CENVAT Component	int	11	0	-1		Allow NULL?
88	MatType	Material Type	int	11	0	-1		Allow NULL?
89	PstngType	Posting Type	int	11	0	0		Allow NULL?
90	ValidFrom2	Valid from2	date	8	0	19000101		Allow NULL?
91	ValidFrom3	Valid from3	date	8	0	19000101		Allow NULL?
92	ValidFrom4	Valid from4	date	8	0	19000101		Allow NULL?
93	ValidFrom5	Valid from5	date	8	0	19000101		Allow NULL?
94	Location	Loc.	int	11	0			Allow NULL?
95	WTaxCode	Withholding Tax Code	nvarchar	4	0			Allow NULL?
96	EquVatRate	Equalization Tax %	num	19	6			Allow NULL?
97	EquVatSum	Equalization Tax Amount	num	19	6			Allow NULL?
98	SYSEquSum	System Equalization Tax Amount	num	19	6			Allow NULL?
99	TotalVat	Total Tax	num	19	6			Allow NULL?
100	SYSTVat	System Total Tax	num	19	6			Allow NULL?
101	WTLiable	WTax-Liable	char	1	0	N	N=No, Y=Yes	Allow NULL?
102	WTLine	WTax Row	char	1	0	N	N=No, Y=Yes	Allow NULL?
103	WTApplied	Applied WTax	num	19	6			Allow NULL?
104	WTAppliedS	Applied WTax (SC)	num	19	6			Allow NULL?
105	WTAppliedF	Applied WTax (FC)	num	19	6			Allow NULL?
106	WTSum	WTax Amount	num	19	6			Allow NULL?
107	WTSumFC	WTax Amount (FC)	num	19	6			Allow NULL?
108	WTSumSC	WTax Amount (SC)	num	19	6			Allow NULL?
109	PayBlock	Payment Block	char	1	0	N	N=No, Y=Yes	Allow NULL?
110	PayBlckRef	Payment Block Abs Entry	int	11	0			Allow NULL?
111	LicTradNum	Federal Tax ID	nvarchar	32	0			Allow NULL?
112	InterimTyp	Interim Account Type	int	11	0	0		Allow NULL?
113	DprId	Down Payment Request Key	int	11	0			Allow NULL?
114	MatchRef	Reconciliation Reference	nvarchar	20	0			Allow NULL?
115	Ordered	Payment Ordered	char	1	0	N	N=No, Y=Yes	Allow NULL?
116	CUP	Unique Code of Project	int	11	0			Allow NULL?
117	CIG	Contract Code Identification	int	11	0			Allow NULL?
118	BPLId	Branch	int	11	0			Allow NULL?
119	BPLName	Branch Name	nvarchar	100	0			Allow NULL?
120	VatRegNum	VAT Reg. Number	nvarchar	32	0			Allow NULL?
121	SLEDGERF	Subledger Flag	char	1	0			Allow NULL?
122	ExTransId	Exposed Transaction ID	int	11	0			Allow NULL?
123	InitRef2	Initial Reference 2	nvarchar	100	0			Allow NULL?
124	InitRef3Ln	Initial Reference 3	nvarchar	27	0			Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	TransId, Line_ID
SHORT_NAME	No	No	ShortName, IntrnMatch
ACCOUNT	No	No	Account, IntrnMatch
TRANS_TYPE	No	No	TransType
PROFIT_ID	No	No	ProfitCode
CURRENCY	No	No	FCCurrency
DUEDATE	No	No	DueDate
REFDATE	No	No	RefDate
INTRNMATCH	No	No	ShortName, Account, IntrnMatch
JDT1BASEL	No	No	TransType, CreatedBy, SourceLine
JDT1CHECKA	No	No	CheckAbs, TransType

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 | 11 INDEXES | B1 9.2 | JDT1 TABLE

TOP B1 9.2 | JDT1 COLUMNS

TOP B1 9.2 | JDT1 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 | 11 INDEXES | B1 9.2 | JDT1 TABLE

TOPB1 9.2 | JDT1 COLUMNS

TOPB1 9.2 | JDT1 INDEXES

TOP B1 9.2 | JDT1 COLUMNS

TOP B1 9.2 | JDT1 INDEXES