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
Inventory and Production
1	Business One	9.3	OIPF	64	6	Landed Costs	Inventory and Production

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	DocDate	Posting Date	date	8	0
4	DocDueDate	Due Date	date	8	0
5	CardCode	Vendor Code	nvarchar	15	0	OCRD			Allow NULL?
6	SuppName	Vendor Name	nvarchar	100	0				Allow NULL?
7	AgentCode	Subst. Code	nvarchar	15	0	OCRD			Allow NULL?
8	AgentName	Subst. Name	nvarchar	100	0				Allow NULL?
9	DocStatus	Document Status	char	1	0		O	C=Closed, O=Open	Allow NULL?
10	AgentNum	File Number	nvarchar	16	0				Allow NULL?
11	Descr	Remarks	nvarchar	250	0				Allow NULL?
12	Ref1	Reference 1	nvarchar	11	0				Allow NULL?
13	Ref2	Reference 2	nvarchar	11	0				Allow NULL?
14	DocCur	Document Currency	nvarchar	3	0				Allow NULL?
15	DocRate	Document Rate	num	19	6				Allow NULL?
16	ExpCustom	Projected Customs	num	19	6				Allow NULL?
17	ActCustom	Act. Import Duty	num	19	6				Allow NULL?
18	Vat1	Tax 2	num	19	6				Allow NULL?
19	Vat2	Tax 2	num	19	6				Allow NULL?
20	BeforeVat	Total Before Tax	num	19	6				Allow NULL?
21	DocTotal	Document Total	num	19	6				Allow NULL?
22	CostSum	Total Costs	num	19	6				Allow NULL?
23	DocTime	Generation Time	int	6	0				Allow NULL?
24	Canceled	Canceled	char	1	0		N	N=No, Y=Yes	Allow NULL?
25	ExCustomFC	Projected Customs (FC)	num	19	6				Allow NULL?
26	AcCustomFC	Act. Import Duty in FC	num	19	6				Allow NULL?
27	Vat1FC	Tax 1 (FC)	num	19	6				Allow NULL?
28	Vat2FC	Tax 2 (FC)	num	19	6				Allow NULL?
29	BeforVatFC	Total Before Tax (FC)	num	19	6				Allow NULL?
30	DocTotalFC	Document Total (FC)	num	19	6				Allow NULL?
31	CostSumFC	Total Costs (FC)	num	19	6				Allow NULL?
32	CloseDate	Closing Date	date	8	0
33	Cost_Match	Expenses Diff. for Reconciliation	num	19	6				Allow NULL?
34	C_Match_FC	Expenses Diff. for Recon. (FC)	num	19	6				Allow NULL?
35	BillOfLad	Bill of Lading No.	nvarchar	20	0				Allow NULL?
36	TrnspCode	Delivery Category	int	6	0	OSHP			Allow NULL?
37	CostFactor	Expenses Factor	num	19	6				Allow NULL?
38	UpdateDate	Date of Update	date	8	0
39	CreateDate	Creation Date	date	8	0
40	Transfered	Year Transfer	char	1	0		N	N=No, Y=Yes	Allow NULL?
41	Instance	Instance	int	6	0		0		Allow NULL?
42	TaxDate	Document Date	date	8	0
43	Series	Series	int	11	0				Allow NULL?
44	JdtNum	Journal Number	int	11	0	OJDT			Allow NULL?
45	JdtMemo	Transaction Details	nvarchar	50	0				Allow NULL?
46	DataSource	Data Source	char	1	0		N	A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
47	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
48	ObjType	Object Type	nvarchar	20	0	ADP1	69		Allow NULL?
49	ExCustomSC	Projected Customs (SC)	num	19	6				Allow NULL?
50	ActCustSC	Actual Customs (SC)	num	19	6				Allow NULL?
51	TtlCostSC	Total Expenditure (SC)	num	19	6				Allow NULL?
52	VersionNum	Version Number	nvarchar	11	0				Allow NULL?
53	OpenForLaC	Open For Landed Costs	char	1	0		Y	N=No, Y=Yes	Allow NULL?
54	incCustom	Include Customs Expenses	char	1	0		Y		Allow NULL?
55	SeqCode	Sequence Code	int	6	0				Allow NULL?
56	Serial	Serial Number	int	11	0				Allow NULL?
57	SeriesStr	Series String	nvarchar	3	0				Allow NULL?
58	SubStr	Subseries String	nvarchar	3	0				Allow NULL?
59	BuildDesc	Build Descriptor	nvarchar	50	0				Allow NULL?
60	SupplCode	Supplementary Code	nvarchar	254	0				Allow NULL?
61	AtcEntry	Attachment Entry	int	11	0				Allow NULL?
62	CustDate	Customs Date	date	8	0
63	BPLId	Branch	int	11	0	OBPL			Allow NULL?
64	DPPStatus	Data Protection Status	char	1	0		N	D=Erased, N=None	Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	DocEntry
NUM	No	Yes	DocNum, Instance, Series
SUPPLIER	No	No	CardCode
AGENT	No	No	AgentCode, AgentNum
CURRENCY	No	No	DocCur
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

64 COLUMNS | 6 INDEXES | B1 9.3 | OIPF TABLE

TOP B1 9.3 | OIPF COLUMNS

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

64 COLUMNS | 6 INDEXES | B1 9.3 | OIPF TABLE

TOPB1 9.3 | OIPF COLUMNS

TOPB1 9.3 | OIPF INDEXES

TOP B1 9.3 | OIPF COLUMNS

TOP B1 9.3 | OIPF INDEXES