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

	Product	Version	Table	Columns	Indexes	Description	Module
Inventory and Production
1	Business One	8.82	OSRI	28	4	Serial Numbers for Items	Inventory and Production

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	ItemCode	Item No.	nvarchar	20	0	OITM			Allow NULL?
2	SysSerial	System Number	int	11	0	OSRI			Allow NULL?
3	SuppSerial	Manufacturer Serial No.	nvarchar	32	0	OSRI			Allow NULL?
4	IntrSerial	Serial Number	nvarchar	32	0	OSRI			Allow NULL?
5	BatchId	Lot Number	nvarchar	32	0	OSRI			Allow NULL?
6	ExpDate	Expiration Date	date	8	0
7	PrdDate	Manufacturing Date	date	8	0
8	InDate	Admission Date	date	8	0
9	GrntStart	Mfr Warranty Start Date	date	8	0
10	GrntExp	Mfr Warranty End Date	date	8	0
11	WhsCode	Warehouse Code	nvarchar	8	0	OWHS			Allow NULL?
12	Located	Location	nvarchar	100	0				Allow NULL?
13	Notes	Details	text	16	0
14	Quantity	Quantity	num	19	6				Allow NULL?
15	BaseType	Base Doc. Type	int	11	0				Allow NULL?
16	BaseEntry	Base Document Internal ID	int	11	0				Allow NULL?
17	BaseNum	Base Document Number	int	11	0				Allow NULL?
18	BaseLinNum	Row No. in Base Document	int	11	0				Allow NULL?
19	CreateDate	Creation Date	date	8	0
20	CardCode	BP Code	nvarchar	15	0	OCRD			Allow NULL?
21	CardName	Card Name	nvarchar	100	0				Allow NULL?
22	ItemName	Item Description	nvarchar	100	0				Allow NULL?
23	Status	Status	char	1	0		0	0=Available, 1=Unavailable	Allow NULL?
24	Direction	Direction	char	1	0		0	0=In, 1=Out	Allow NULL?
25	DataSource	Data Source	char	1	0		N	A=Document Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
26	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
27	Transfered	Transferred	char	1	0		N	N=No, Y=Yes	Allow NULL?
28	Instance	Instance	int	6	0		0		Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	ITEM_CODE, SYS_SERIAL
SUP_SERIAL	No	No	SUPPLY_SERIAL
INT_SERIAL	No	No	INTERNAL_SERIAL
BATCH_ID	No	No	BATCH_ID