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
Inventory and Production
1	Business One	9.3	OWHS	102	2	Warehouses	Inventory and Production

Column	Field	Description	SQL Type	Length	Relation	Default Value	Constraints	SQL Create Statement
1	WhsCode	Warehouse Code	nvarchar	8				Allow NULL?
2	WhsName	Warehouse Name	nvarchar	100				Allow NULL?
3	IntrnalKey	Internal Key	int	11				Allow NULL?
4	Grp_Code	Group Code	nvarchar	4				Allow NULL?
5	BalInvntAc	Inventory Account	nvarchar	15	OACT			Allow NULL?
6	SaleCostAc	Cost of Goods Sold Account	nvarchar	15	OACT			Allow NULL?
7	TransferAc	Allocation Account	nvarchar	15	OACT			Allow NULL?
8	Locked	Locked	char	1		N	N=Changeable, Y=Locked	Allow NULL?
9	DataSource	Data Source	char	1		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?
10	UserSign	User Signature	int	6	OUSR			Allow NULL?
11	RevenuesAc	Revenue Account	nvarchar	15	OACT			Allow NULL?
12	VarianceAc	Variance Account	nvarchar	15	OACT			Allow NULL?
13	DecreasAc	Inventory Offset - Decrease Account	nvarchar	15	OACT			Allow NULL?
14	IncreasAc	Inventory Offset - Increase Account	nvarchar	15	OACT			Allow NULL?
15	ReturnAc	Sales Returns Account	nvarchar	15	OACT			Allow NULL?
16	ExpensesAc	Expense Account	nvarchar	15	OACT			Allow NULL?
17	EURevenuAc	Revenue Account - EU	nvarchar	15	OACT			Allow NULL?
18	EUExpensAc	Expense Account - EU	nvarchar	15	OACT			Allow NULL?
19	FrRevenuAc	Revenue Account - Foreign	nvarchar	15	OACT			Allow NULL?
20	FrExpensAc	Expense Account - Foreign	nvarchar	15	OACT			Allow NULL?
21	VatGroup	Tax Group	nvarchar	8	OSTC			Allow NULL?
22	Street	Street	nvarchar	100				Allow NULL?
23	Block	Block	nvarchar	100				Allow NULL?
24	ZipCode	Zip Code	nvarchar	20				Allow NULL?
25	City	City	nvarchar	100				Allow NULL?
26	County	County	nvarchar	100	OCNT			Allow NULL?
27	Country	Country	nvarchar	3	OCRY			Allow NULL?
28	State	State	nvarchar	3	OCST			Allow NULL?
29	Location	Location	int	11	OLCT			Allow NULL?
30	DropShip	Drop-Ship	char	1		N	N=No, Y=Yes	Allow NULL?
31	ExmptIncom	Exempt Revenue Account	nvarchar	15	OACT			Allow NULL?
32	UseTax	Allow Use Tax	char	1		N	N=No, Y=Yes	Allow NULL?
33	PriceDifAc	Price Difference Account	nvarchar	15	OACT			Allow NULL?
34	ExchangeAc	Exchange Rate Differences Account	nvarchar	15	OACT			Allow NULL?
35	BalanceAcc	Goods Clearing Account	nvarchar	15	OACT			Allow NULL?
36	PurchaseAc	Purchase Account	nvarchar	15	OACT			Allow NULL?
37	PAReturnAc	Purchase Return Account	nvarchar	15	OACT			Allow NULL?
38	PurchOfsAc	Purchase Offset Account	nvarchar	15	OACT			Allow NULL?
39	FedTaxID	Federal Tax ID	nvarchar	32				Allow NULL?
40	Building	Building/Floor/Room	text	16
41	ShpdGdsAct	Shipped Goods Account	nvarchar	15	OACT			Allow NULL?
42	VatRevAct	VAT in Revenue Account	nvarchar	15	OACT			Allow NULL?
43	DecresGlAc	G/L Decrease Account	nvarchar	15	OACT			Allow NULL?
44	IncresGlAc	G/L Increase Account	nvarchar	15	OACT			Allow NULL?
45	Nettable	Nettable	char	1		Y	N=No, Y=Yes	Allow NULL?
46	StokRvlAct	Inventory Revaluation Account	nvarchar	15	OACT			Allow NULL?
47	StkOffsAct	Inventory Revaluation Offset Account	nvarchar	15	OACT			Allow NULL?
48	WipAcct	WIP Inventory Account	nvarchar	15	OACT			Allow NULL?
49	WipVarAcct	WIP Inventory Variance Account	nvarchar	15	OACT			Allow NULL?
50	CostRvlAct	COGS Revaluation Account	nvarchar	15	OACT			Allow NULL?
51	CstOffsAct	COGS Revaluation Offset Acct	nvarchar	15	OACT			Allow NULL?
52	ExpClrAct	Expense Clearing Account	nvarchar	15	OACT			Allow NULL?
53	ExpOfstAct	Expense Offset Account	nvarchar	15	OACT			Allow NULL?
54	objType	Object Type - History	nvarchar	20		64		Allow NULL?
55	logInstanc	Log Instance - History	int	11				Allow NULL?
56	createDate	Creation Date - History	date	8
57	userSign2	Updating User - History	int	6	OUSR			Allow NULL?
58	updateDate	Date of Update - History	date	8
59	ARCMAct	Sales Credit Account	nvarchar	15	OACT			Allow NULL?
60	ARCMFrnAct	Sales Credit Account - Foreign	nvarchar	15	OACT			Allow NULL?
61	ARCMEUAct	Sales Credit Account - EU	nvarchar	15	OACT			Allow NULL?
62	ARCMExpAct	Tax Exempt Credit Account	nvarchar	15	OACT			Allow NULL?
63	APCMAct	Purchase Credit Account	nvarchar	15	OACT			Allow NULL?
64	APCMFrnAct	Purchase Credit Account - Foreign	nvarchar	15	OACT			Allow NULL?
65	APCMEUAct	Purchase Credit Account - EU	nvarchar	15	OACT			Allow NULL?
66	RevRetAct	Revenue Returns Account	nvarchar	15	OACT			Allow NULL?
67	BPLid	Business Place ID	int	11	OBPL			Allow NULL?
68	OwnerCode	Owner Code	char	1		1	1=Company Item Property, 2=Third-Party Warehouse, 3=Third-Party Item in my Property	Allow NULL?
69	NegStckAct	Negative Inventory Adjustment Acct	nvarchar	15	OACT			Allow NULL?
70	StkInTnAct	Stock In Transit Account	nvarchar	15	OACT			Allow NULL?
71	AddrType	Address Type	nvarchar	100				Allow NULL?
72	StreetNo	Street No.	nvarchar	100				Allow NULL?
73	PurBalAct	Purchase Balance Account	nvarchar	15	OACT			Allow NULL?
74	Excisable	Excisable [Yes/No]	char	1		N	N=No, Y=Yes	Allow NULL?
75	WhICenAct	Incoming CENVAT Account (WH)	nvarchar	15	OACT			Allow NULL?
76	WhOCenAct	Outgoing CENVAT Account (WH)	nvarchar	15	OACT			Allow NULL?
77	WhShipTo	Ship-to Name (WH)	nvarchar	100				Allow NULL?
78	WipOffset	WIP Offset P&L Account	nvarchar	15	OACT			Allow NULL?
79	StockOffst	Inventory Offset P&L Account	nvarchar	15	OACT			Allow NULL?
80	StorKeeper	Storekeeper	int	11	OHEM			Allow NULL?
81	Shipper	Shipper	nvarchar	15	OCRD			Allow NULL?
82	BinActivat	Bin Activated [Y/N]	char	1		N	N=No, Y=Yes	Allow NULL?
83	BinSeptor	Bin Separator	nvarchar	5		-		Allow NULL?
84	DftBinAbs	Default Bin Internal Number	int	11	OBIN			Allow NULL?
85	DftBinEnfd	Default Bin Enforced [Y/N]	char	1		N	N=No, Y=Yes	Allow NULL?
86	AutoIssMtd	Auto. Issue Method	int	6		0	0=Single Choice, 1=Bin Location Code Order, 2=Alternative Sort Code Order, 3=Descending Quantity, 4=Ascending Quantity, 5=FIFO, 6=LIFO, 7=Ascending Quantity - Single Bin Preferred	Allow NULL?
87	ManageSnB	Drop-Ship Manage SnB	char	1		N	N=No, Y=Yes	Allow NULL?
88	RecItemsBy	Receiving Bin Locations Method	int	6		0	0=Bin Location Code Order, 1=Alternative Sort Code Order	Allow NULL?
89	RecBinEnab	Enable Receiving Bin Locations	char	1		N	N=No, Y=Yes	Allow NULL?
90	GlblLocNum	Global Location Number	nvarchar	50				Allow NULL?
91	RecvEmpBin	Restrict Receipts to Empty Bin	char	1		Y	N=No, Y=Yes	Allow NULL?
92	Inactive	Inactive	char	1		N	N=No, Y=Yes	Allow NULL?
93	RecvMaxQty	Recv. up to Max. Qty	char	1		N	N=No, Y=Yes	Allow NULL?
94	AutoRecvMd	Auto. Receipt Method	int	6		0	0=Default Bin Location, 1=Last Bin Location That Received Item, 2=Item's Current Bin Locations, 3=Item's Current and Historical Bin Locations	Allow NULL?
95	RecvMaxWT	Recv. up to Max. Weight	char	1		N	N=No, Y=Yes	Allow NULL?
96	RecvUpTo	Receive up to	nvarchar	6		0	0=Maximum Qty, 1=Maximum Weight, 2=Max. Qty and Weight	Allow NULL?
97	FreeChrgSA	Free of Charge Sales Account	nvarchar	15	OACT			Allow NULL?
98	FreeChrgPU	Free of Charge Purchase Account	nvarchar	15	OACT			Allow NULL?
99	TaxOffice	Tax Office	nvarchar	50				Allow NULL?
100	Address2	Address Name 2	nvarchar	50				Allow NULL?
101	Address3	Address Name 3	nvarchar	50				Allow NULL?
102	External	External	char	1		N	N=No, Y=Yes	Allow NULL?

Name	Primary	Unique	Type	Columns
PRIMARY	No	Yes		WhsCode
DFT_BIN	No	No		DftBinAbs

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

102 COLUMNS | 2 INDEXES | B1 9.3 | OWHS TABLE

TOP B1 9.3 | OWHS COLUMNS

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

102 COLUMNS | 2 INDEXES | B1 9.3 | OWHS TABLE

TOPB1 9.3 | OWHS COLUMNS

TOPB1 9.3 | OWHS INDEXES

TOP B1 9.3 | OWHS COLUMNS

TOP B1 9.3 | OWHS INDEXES