	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

	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

	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

292 COLUMNS | 1 INDEXES | B1 9.3 | OFLT TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Reports
1	Business One	9.3	OFLT	292	1	Report - Selection Criteria	Reports

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT FormNum, QueryStr, ItmOrCrd, CardInclud, CardFrom1, CardTo1, CardExclud, CardFrom2, CardTo2, ClienGroup, VendGroup, ClntQryGrp, VeQryGroup, ItmInclud, ItmFrom1, ItmTo1, ItmExclud, ItmFrom2, ItmTo2, ItmGroup, ItQryGroup, WhsInclude, WhsFrom1, WhsTo1, WhsExclude, WhsFrom2, WhsTo2, FromAcct, ToAcct, GroupMask, FromDate, ToDate, FrmDueDate, ToDueDate, FromDate3, ToDate3, FromDate4, ToDate4, SourceType, FrmTrnsNum, ToTrnsNum, FromRef1, ToRef1, FromRef2, ToRef2, FrmTrnsCod, ToTrnsCod, FromSum, ToSum, FrmFRNAmnt, ToFRNAmnt, MemoIn, SortField1, Break1, SortField2, Break2, SortField3, Break3, Display, PrntCutDat, CheckBox0, CheckBox1, CheckBox2, CheckBox3, CheckBox4, CheckBox5, CheckBox6, CheckBox7, CheckBox8, CheckBox9, ShowZero, DateCheck, DueCheck, CutCheck, CutByObj, ObjectC1, ObjectC2, ObjectC3, ObjectC4, ObjectC5, ObjectC6, ObjectC7, ObjectC8, ObjectC9, ObjectC10, ObjectC11, ObjectC12, ObjectC13, ObjectC14, ObjectC15, ObjectC16, FromAmount, ToAmount, FrmSalsMan, ToSalsMan, USER_CHK1, USER_CHK2, USER_CHK3, USER_CHK4, USER_CHK5, UseSort, Sort1Up, Sort2Up, Sort3Up, FromAmnt2, ToAmount2, TaxDateFro, TaxDateTo, FinancYear, BdgtScenar, CompFolder, CheckBox10, FROM_FC, TO_FC, FCCurrency, TaxCheck, DateType, DateType2, FromPrject, ToProject, TemplateId, ShowLeads, MthDate, AccntntCod, UserSign, BlcNunFrom, BlcNunTo, ImpLogFrom, ImpLogTo, FolderNum, MainField, TransMode, MonthMode, CheckBox11, FromIdc, ToIdc, IgnoreAdj, RefNumFrom, RefNumTo, PymNumfrom, PymNumTo, BankFrom, BankTo, DpstFrom, DpstTo, DpstType, ObjectC17, ObjectC18, ObjectC19, ObjAbs, AddBTF, FilePath, DpsBnkActF, DpsBnkActT, FromKey, ToKey, ObjectC20, ObjectC21, ObjectC22, ObjectC23, ObjectC25, USER_CHK6, OcrChkDim2, OcrChkDim3, OcrChkDim4, OcrChkDim5, OcrFrom2, OcrFrom3, OcrFrom4, OcrFrom5, OcrTo2, OcrTo3, OcrTo4, OcrTo5, TaxAdjRep, ObjectC26, CBFilter, OBIncluded, OBFilter, ExportCurr, CBIncluded, SlpFrom, SlpTo, CBUDF, CBREF, CheckBoxB, FilterName, JDTFixedF, JDT1FixedF, JDTUserF, JDT1UserF, BPFilter, AcctFltr, ZeroLCAmt, SplitByBin, SplitBySnb, CheckBox12, CheckBox13, CheckBox14, CheckBox15, CheckBox16, CheckBox17, CheckBox18, CheckBox19, CheckBox20, CheckBox21, CheckBox22, CheckBox23, CheckBox24, CheckBox25, CheckBox26, CheckBox27, CheckBox28, CheckBox29, CheckBox30, CheckBox31, CheckBox32, CheckBox33, BatchFrom, BatchTo, BatAttr1F, BatAttr1T, BatAttr2F, BatAttr2T, SerialNoF, SerialNoT, MfrSerailF, MfrSerailT, LotNumberF, LotNumberT, BinLocFrom, BinLocTo, AltSrtCodF, AltSrtCodT, BinSbl1F, BinSbl1To, BinSbl2F, BinSbl2To, BinSbl3F, BinSbl3To, BinSbl4F, BinSbl4To, BinAttr1F, BinAttr1To, BinAttr2F, BinAttr2To, BinAttr3F, BinAttr3To, BinAttr4F, BinAttr4To, BinAttr5F, BinAttr5To, BinAttr6F, BinAttr6To, BinAttr7F, BinAttr7To, BinAttr8F, BinAttr8To, BinAttr9F, BinAttr9To, BinAttr10F, BinAttr10T, EnfBinFltr, ExItemFrom, ExItemTo, ExBPFrom, ExBPTo, CheckBox34, CheckBox35, BlAgreem, BAFrom, BATo, AdjTrans, TitAcctLvl, CCDFrom1, CCDTo1, CCDFrom2, CCDTo2, ArchJrnal, CardFrom3, CardTo3, OBBranch, AccumDbCr, RscFrom1, RscTo1, RscGroup, RouteStage, ExRSTFrom, ExRSTTo, StgSeqNum, ExSSNFrom, ExSSNTo FROM OFLT

TOP B1 9.3 | OFLT COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	FormNum	Form Number	nvarchar	20	0				Allow NULL?
2	QueryStr	Query	nvarchar	250	0				Allow NULL?
3	ItmOrCrd	Items or BP	char	1	0		Y	N=No, Y=Yes	Allow NULL?
4	CardInclud	BP Area	char	1	0		Y	N=No, Y=Yes	Allow NULL?
5	CardFrom1	From BP	nvarchar	15	0	OCRD			Allow NULL?
6	CardTo1	To BP	nvarchar	15	0	OCRD			Allow NULL?
7	CardExclud	Excluding BP	char	1	0		N	N=No, Y=Yes	Allow NULL?
8	CardFrom2	BP Rejected	nvarchar	15	0				Allow NULL?
9	CardTo2	BP Rejected	nvarchar	15	0				Allow NULL?
10	ClienGroup	Customer Group	int	6	0				Allow NULL?
11	VendGroup	Vendor Group	int	6	0				Allow NULL?
12	ClntQryGrp	Customer Properties	nvarchar	250	0				Allow NULL?
13	VeQryGroup	Vendor Properties	nvarchar	250	0				Allow NULL?
14	ItmInclud	Item Range	char	1	0		Y	N=No, Y=Yes	Allow NULL?
15	ItmFrom1	From Item	nvarchar	50	0	OITM			Allow NULL?
16	ItmTo1	To Item	nvarchar	50	0	OITM			Allow NULL?
17	ItmExclud	Excluding Materials	char	1	0		N	N=No, Y=Yes	Allow NULL?
18	ItmFrom2	Item Rejected	nvarchar	50	0	OITM			Allow NULL?
19	ItmTo2	Item Rejected	nvarchar	50	0	OITM			Allow NULL?
20	ItmGroup	Item Group	int	6	0	OITB			Allow NULL?
21	ItQryGroup	Item Properties	nvarchar	250	0				Allow NULL?
22	WhsInclude	Warehouse Range	char	1	0		Y	N=No, Y=Yes	Allow NULL?
23	WhsFrom1	From Warehouse	nvarchar	8	0	OWHS			Allow NULL?
24	WhsTo1	To Warehouse	nvarchar	8	0	OWHS			Allow NULL?
25	WhsExclude	Excluding Warehouses	char	1	0		N	N=No, Y=Yes	Allow NULL?
26	WhsFrom2	Warehouse Rejected	nvarchar	8	0				Allow NULL?
27	WhsTo2	Warehouse Rejected	nvarchar	8	0				Allow NULL?
28	FromAcct	From Account	nvarchar	15	0				Allow NULL?
29	ToAcct	To Account	nvarchar	15	0				Allow NULL?
30	GroupMask	Group Mask	nvarchar	12	0				Allow NULL?
31	FromDate	From Posting Date	date	8	0
32	ToDate	To Posting Date	date	8	0
33	FrmDueDate	Due Date From	date	8	0
34	ToDueDate	Due Date To	date	8	0
35	FromDate3	From Date 3	date	8	0
36	ToDate3	To Date 3	date	8	0
37	FromDate4	From Date 4	date	8	0
38	ToDate4	To Date 4	date	8	0
39	SourceType	Original Journal	int	6	0		-1	-1=All Transactions, -2=Opening Balance, -3=Closing Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt, 21=Goods Returns, 24=Incoming Payment, 25=De	Allow NULL?
40	FrmTrnsNum	From Transaction No.	int	11	0				Allow NULL?
41	ToTrnsNum	To Transaction No.	int	11	0				Allow NULL?
42	FromRef1	From Reference 1	nvarchar	100	0				Allow NULL?
43	ToRef1	To Reference 1	nvarchar	100	0				Allow NULL?
44	FromRef2	From Reference 2	nvarchar	100	0				Allow NULL?
45	ToRef2	To Reference 2	nvarchar	100	0				Allow NULL?
46	FrmTrnsCod	From Transaction Code	nvarchar	4	0				Allow NULL?
47	ToTrnsCod	To Transaction Code	nvarchar	4	0				Allow NULL?
48	FromSum	From Amount	num	19	6				Allow NULL?
49	ToSum	To Amount	num	19	6				Allow NULL?
50	FrmFRNAmnt	From FC Amount	num	19	6				Allow NULL?
51	ToFRNAmnt	To FC Amount	num	19	6				Allow NULL?
52	MemoIn	Details Contained	nvarchar	50	0				Allow NULL?
53	SortField1	Sort Field 1	int	6	0		-1		Allow NULL?
54	Break1	Subtotal by Sort 1	char	1	0		N	N=No, Y=Yes	Allow NULL?
55	SortField2	Sort Field 2	int	6	0		-1		Allow NULL?
56	Break2	Subtotal by Sort 2	char	1	0		N	N=No, Y=Yes	Allow NULL?
57	SortField3	Sort Field 3	int	6	0		-1		Allow NULL?
58	Break3	Subtotal by Sort 3	char	1	0		N	N=No, Y=Yes	Allow NULL?
59	Display	Display	char	1	0		L	B=Postings + Totals, L=Postings Only, T=Totals Only	Allow NULL?
60	PrntCutDat	Print Date Selection Criteria	char	1	0		Y	N=No, Y=Yes	Allow NULL?
61	CheckBox0	Check box 0	char	1	0		N	N=No, Y=Yes	Allow NULL?
62	CheckBox1	Check box 1	char	1	0		N	N=No, Y=Yes	Allow NULL?
63	CheckBox2	Check box 2	char	1	0		N	N=No, Y=Yes	Allow NULL?
64	CheckBox3	Check box 3	char	1	0		N	N=No, Y=Yes	Allow NULL?
65	CheckBox4	Check box 4	char	1	0		N	N=No, Y=Yes	Allow NULL?
66	CheckBox5	Check box 5	char	1	0		N	N=No, Y=Yes	Allow NULL?
67	CheckBox6	Check box 6	char	1	0		N	N=No, Y=Yes	Allow NULL?
68	CheckBox7	Check box 7	char	1	0		N	N=No, Y=Yes	Allow NULL?
69	CheckBox8	Check box 8	char	1	0		N	N=No, Y=Yes	Allow NULL?
70	CheckBox9	Check box 9	char	1	0		N	N=No, Y=Yes	Allow NULL?
71	ShowZero	Display Zero Balances	char	1	0		N	N=No, Y=Yes	Allow NULL?
72	DateCheck	Confirm Date Range	char	1	0		N	N=No, Y=Yes	Allow NULL?
73	DueCheck	Confirm Due Date Range	char	1	0		N	N=No, Y=Yes	Allow NULL?
74	CutCheck	Confirm Date Selectn Criteria	char	1	0		N	N=No, Y=Yes	Allow NULL?
75	CutByObj	Selection Criteria by Object	char	1	0		N	N=No, Y=Yes	Allow NULL?
76	ObjectC1	C1	char	1	0		N	N=No, Y=Yes	Allow NULL?
77	ObjectC2	C2	char	1	0		N	N=No, Y=Yes	Allow NULL?
78	ObjectC3	C3	char	1	0		N	N=No, Y=Yes	Allow NULL?
79	ObjectC4	C4	char	1	0		N	N=No, Y=Yes	Allow NULL?
80	ObjectC5	C5	char	1	0		N	N=No, Y=Yes	Allow NULL?
81	ObjectC6	C6	char	1	0		N	N=No, Y=Yes	Allow NULL?
82	ObjectC7	C7	char	1	0		N	N=No, Y=Yes	Allow NULL?
83	ObjectC8	C8	char	1	0		N	N=No, Y=Yes	Allow NULL?
84	ObjectC9	C9	char	1	0		N	N=No, Y=Yes	Allow NULL?
85	ObjectC10	C10	char	1	0		N	N=No, Y=Yes	Allow NULL?
86	ObjectC11	C11	char	1	0		N	N=No, Y=Yes	Allow NULL?
87	ObjectC12	C12	char	1	0		N	N=No, Y=Yes	Allow NULL?
88	ObjectC13	C13	char	1	0		N	N=No, Y=Yes	Allow NULL?
89	ObjectC14	C14	char	1	0		N	N=No, Y=Yes	Allow NULL?
90	ObjectC15	C15	char	1	0		N	N=No, Y=Yes	Allow NULL?
91	ObjectC16	C16	char	1	0		N	N=No, Y=Yes	Allow NULL?
92	FromAmount	From Amount	num	19	6				Allow NULL?
93	ToAmount	To Amount	num	19	6				Allow NULL?
94	FrmSalsMan	From Sales Employee	int	6	0				Allow NULL?
95	ToSalsMan	To Sales Employee	int	6	0				Allow NULL?
96	USER_CHK1	User CheckBox 1	char	1	0		N	N=No, Y=Yes	Allow NULL?
97	USER_CHK2	User CheckBox 2	char	1	0		N	N=No, Y=Yes	Allow NULL?
98	USER_CHK3	User CheckBox 3	char	1	0		N	N=No, Y=Yes	Allow NULL?
99	USER_CHK4	System Currrency	char	1	0		N	N=No, Y=Yes	Allow NULL?
100	USER_CHK5	System and Local Currency	char	1	0		N	N=No, Y=Yes	Allow NULL?
101	UseSort	Sort	char	1	0		N	N=No, Y=Yes	Allow NULL?
102	Sort1Up	Sort1	char	1	0		Y	N=Descending, Y=Ascending	Allow NULL?
103	Sort2Up	Sort2	char	1	0		Y	N=Descending, Y=Ascending	Allow NULL?
104	Sort3Up	Sort3	char	1	0		Y	N=Descending, Y=Ascending	Allow NULL?
105	FromAmnt2	From Quantity Release	num	19	6				Allow NULL?
106	ToAmount2	For Quantity Release	num	19	6				Allow NULL?
107	TaxDateFro	Lower Limit for Tax Data	date	8	0
108	TaxDateTo	Top Limit for Document Dates	date	8	0
109	FinancYear	Start of Fiscal Year	date	8	0
110	BdgtScenar	Budget Scenario	int	11	0				Allow NULL?
111	CompFolder	Company Database	nvarchar	100	0				Allow NULL?
112	CheckBox10	Exapan Check Box 1	char	1	0		N	N=No, Y=Yes	Allow NULL?
113	FROM_FC	Foreign Currency from	num	19	6				Allow NULL?
114	TO_FC	Foreign Currency to	num	19	6				Allow NULL?
115	FCCurrency	Foreign Currency	nvarchar	3	0				Allow NULL?
116	TaxCheck	Confirm Document Date Range	char	1	0		N	N=No, Y=Yes	Allow NULL?
117	DateType	Selection Criteria Type	char	1	0		R	D=Due Date, R=Posting Date, T=Document Date	Allow NULL?
118	DateType2	Selection Criteria Type	char	1	0		R	D=Due Date, R=Posting Date, T=Document Date	Allow NULL?
119	FromPrject	From Project	nvarchar	20	0	OPRJ			Allow NULL?
120	ToProject	To Project	nvarchar	20	0	OPRJ			Allow NULL?
121	TemplateId	Template	int	11	0		0		Allow NULL?
122	ShowLeads	Display Leads	char	1	0		N	N=No, Y=Yes	Allow NULL?
123	MthDate	Reconciliation Date	char	1	0		N	N=No, Y=Yes	Allow NULL?
124	AccntntCod	External Code	char	1	0		N	N=No, Y=Yes	Allow NULL?
125	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
126	BlcNunFrom	Block Number From	nvarchar	100	0				Allow NULL?
127	BlcNunTo	Block Number To	nvarchar	100	0				Allow NULL?
128	ImpLogFrom	Import Log From	nvarchar	20	0				Allow NULL?
129	ImpLogTo	Import Log To	nvarchar	20	0				Allow NULL?
130	FolderNum	Folder Number	char	1	0		1		Allow NULL?
131	MainField	Main Field	int	6	0		23		Allow NULL?
132	TransMode	Transaction Mode	char	1	0		Y	N=No, Y=Yes	Allow NULL?
133	MonthMode	Month Totals Mode	char	1	0		N	N=No, Y=Yes	Allow NULL?
134	CheckBox11	Expan Check Box 11	char	1	0		N	N=No, Y=Yes	Allow NULL?
135	FromIdc	Indicator From	nvarchar	2	0				Allow NULL?
136	ToIdc	Indicator To	nvarchar	2	0				Allow NULL?
137	IgnoreAdj	Ignore Adjustments	char	1	0		N	N=No, Y=Yes	Allow NULL?
138	RefNumFrom	From Reference No.	nvarchar	254	0				Allow NULL?
139	RefNumTo	To Reference No.	nvarchar	254	0				Allow NULL?
140	PymNumfrom	Payment No. From	int	11	0				Allow NULL?
141	PymNumTo	To Payment No.	int	11	0				Allow NULL?
142	BankFrom	From Bank Code	nvarchar	30	0				Allow NULL?
143	BankTo	To Bank Code	nvarchar	30	0				Allow NULL?
144	DpstFrom	From Deposit Code	int	11	0				Allow NULL?
145	DpstTo	To Deposit Code	int	11	0				Allow NULL?
146	DpstType	Deposit Type	char	1	0				Allow NULL?
147	ObjectC17	Obj C17	char	1	0		N	N=No, Y=Yes	Allow NULL?
148	ObjectC18	Obj C18	char	1	0		N	N=No, Y=Yes	Allow NULL?
149	ObjectC19	Obj C19	char	1	0		N	N=No, Y=Yes	Allow NULL?
150	ObjAbs	Document Internal Number	int	11	0				Allow NULL?
151	AddBTF	Add Journal Vouchers	char	1	0		N	N=No, Y=Yes	Allow NULL?
152	FilePath	File Path	text	16	0
153	DpsBnkActF	From Deposit Bank Account	nvarchar	50	0				Allow NULL?
154	DpsBnkActT	To Deposit Bank Account	nvarchar	50	0				Allow NULL?
155	FromKey	From Key	int	11	0				Allow NULL?
156	ToKey	To Key	int	11	0				Allow NULL?
157	ObjectC20	Object C20	char	1	0		N	N=No, Y=Yes	Allow NULL?
158	ObjectC21	Object C21	char	1	0		N	N=No, Y=Yes	Allow NULL?
159	ObjectC22	Object C22	char	1	0		N	N=No, Y=Yes	Allow NULL?
160	ObjectC23	Object C23	char	1	0		N	N=No, Y=Yes	Allow NULL?
161	ObjectC25	Object C25	char	1	0		N	N=No, Y=Yes	Allow NULL?
162	USER_CHK6	Include CB in P/L Accounts	char	1	0		N	N=No, Y=Yes	Allow NULL?
163	OcrChkDim2	Checkbox for Dimension 2	char	1	0		N	N=No, Y=Yes	Allow NULL?
164	OcrChkDim3	Checkbox for Dimension 3	char	1	0		N	N=No, Y=Yes	Allow NULL?
165	OcrChkDim4	Checkbox for Dimension 4	char	1	0		N	N=No, Y=Yes	Allow NULL?
166	OcrChkDim5	Checkbox for Dimension 5	char	1	0		N	N=No, Y=Yes	Allow NULL?
167	OcrFrom2	From Costing Code 2	nvarchar	8	0	OOCR			Allow NULL?
168	OcrFrom3	From Costing Code 3	nvarchar	8	0	OOCR			Allow NULL?
169	OcrFrom4	From Costing Code 4	nvarchar	8	0	OOCR			Allow NULL?
170	OcrFrom5	From Costing Code 5	nvarchar	8	0	OOCR			Allow NULL?
171	OcrTo2	To Costing Code 2	nvarchar	8	0	OOCR			Allow NULL?
172	OcrTo3	To Costing Code 3	nvarchar	8	0	OOCR			Allow NULL?
173	OcrTo4	To Costing Code 4	nvarchar	8	0	OOCR			Allow NULL?
174	OcrTo5	To Costing Code 5	nvarchar	8	0	OOCR			Allow NULL?
175	TaxAdjRep	Object C24	text	16	0
176	ObjectC26	Object C26	char	1	0		N	N=No, Y=Yes	Allow NULL?
177	CBFilter	Closing Balances Filter	char	1	0		2	1=Closing Balance of Life-to-Date, 2=Closing Balance Before Selected Period Only	Allow NULL?
178	OBIncluded	Add Opening Balance for Period	char	1	0		N	N=No, Y=Yes	Allow NULL?
179	OBFilter	Opening Balances Filter	char	1	0		1	1=Opening Balance from Start of Company Activity, 2=Opening Balance from Start of Fiscal Year	Allow NULL?
180	ExportCurr	Export Currency	char	1	0		L	L=Local Currency, S=System Currency	Allow NULL?
181	CBIncluded	Add Closing Balances	char	1	0		N	N=No, Y=Yes	Allow NULL?
182	SlpFrom	Slp From	nvarchar	155	0				Allow NULL?
183	SlpTo	Slp To	nvarchar	155	0				Allow NULL?
184	CBUDF	User-Defined Fields	char	1	0		N	N=No, Y=Yes	Allow NULL?
185	CBREF	Reference Fields	char	1	0		N	N=No, Y=Yes	Allow NULL?
186	CheckBoxB	Checkbox for Branch	char	1	0		N	N=No, Y=Yes	Allow NULL?
187	FilterName	Filter Name	nvarchar	30	0		_		Allow NULL?
188	JDTFixedF	JE Fixed Fields	int	6	0				Allow NULL?
189	JDT1FixedF	JE Line Fixed Fields	int	6	0				Allow NULL?
190	JDTUserF	JE User Fields	int	6	0				Allow NULL?
191	JDT1UserF	JE Line User Fields	int	6	0				Allow NULL?
192	BPFilter	BP Filter Enabled	char	1	0		N	N=No, Y=Yes	Allow NULL?
193	AcctFltr	Account Filter Enabled	char	1	0		N	N=No, Y=Yes	Allow NULL?
194	ZeroLCAmt	Show Zero LC Amount Lines	char	1	0		N	N=No, Y=Yes	Allow NULL?
195	SplitByBin	Split By Bin Location	char	1	0		N	N=No, Y=Yes	Allow NULL?
196	SplitBySnb	Split By Batch/Serial	char	1	0		N	N=No, Y=Yes	Allow NULL?
197	CheckBox12	Check Box 12	char	1	0		N	N=No, Y=Yes	Allow NULL?
198	CheckBox13	Check Box 13	char	1	0		N	N=No, Y=Yes	Allow NULL?
199	CheckBox14	Check Box 14	char	1	0		N	N=No, Y=Yes	Allow NULL?
200	CheckBox15	Check Box 15	char	1	0		N	N=No, Y=Yes	Allow NULL?
201	CheckBox16	Check Box 16	char	1	0		N	N=No, Y=Yes	Allow NULL?
202	CheckBox17	Check Box 17	char	1	0		N	N=No, Y=Yes	Allow NULL?
203	CheckBox18	Check Box 18	char	1	0		N	N=No, Y=Yes	Allow NULL?
204	CheckBox19	Check Box 19	char	1	0		N	N=No, Y=Yes	Allow NULL?
205	CheckBox20	Check Box 20	char	1	0		N	N=No, Y=Yes	Allow NULL?
206	CheckBox21	Check Box 21	char	1	0		N	N=No, Y=Yes	Allow NULL?
207	CheckBox22	Check Box 22	char	1	0		N	N=No, Y=Yes	Allow NULL?
208	CheckBox23	Check Box 23	char	1	0		N	N=No, Y=Yes	Allow NULL?
209	CheckBox24	Check Box 24	char	1	0		N	N=No, Y=Yes	Allow NULL?
210	CheckBox25	Check Box 25	char	1	0		N	N=No, Y=Yes	Allow NULL?
211	CheckBox26	Check Box 26	char	1	0		N	N=No, Y=Yes	Allow NULL?
212	CheckBox27	Check Box 27	char	1	0		N	N=No, Y=Yes	Allow NULL?
213	CheckBox28	Check Box 28	char	1	0		N	N=No, Y=Yes	Allow NULL?
214	CheckBox29	Check Box 29	char	1	0		N	N=No, Y=Yes	Allow NULL?
215	CheckBox30	Check Box 30	char	1	0		N	N=No, Y=Yes	Allow NULL?
216	CheckBox31	Check Box 31	char	1	0		N	N=No, Y=Yes	Allow NULL?
217	CheckBox32	Check Box 32	char	1	0		N	N=No, Y=Yes	Allow NULL?
218	CheckBox33	Check Box 33	char	1	0		N	N=No, Y=Yes	Allow NULL?
219	BatchFrom	Batch From	nvarchar	36	0				Allow NULL?
220	BatchTo	Batch To	nvarchar	36	0				Allow NULL?
221	BatAttr1F	Batch Attr. 1 From	nvarchar	36	0				Allow NULL?
222	BatAttr1T	Batch Attr. 1 To	nvarchar	36	0				Allow NULL?
223	BatAttr2F	Batch Attr. 2 From	nvarchar	36	0				Allow NULL?
224	BatAttr2T	Batch Attr. 2 To	nvarchar	36	0				Allow NULL?
225	SerialNoF	Serial Number From	nvarchar	36	0				Allow NULL?
226	SerialNoT	Serial Number To	nvarchar	36	0				Allow NULL?
227	MfrSerailF	Mfr Serial Number From	nvarchar	36	0				Allow NULL?
228	MfrSerailT	Mfr Serial Number To	nvarchar	36	0				Allow NULL?
229	LotNumberF	Lot Number From	nvarchar	36	0				Allow NULL?
230	LotNumberT	Lot Number To	nvarchar	36	0				Allow NULL?
231	BinLocFrom	Bin Location From	nvarchar	228	0				Allow NULL?
232	BinLocTo	Bin Location To	nvarchar	228	0				Allow NULL?
233	AltSrtCodF	Alternative Sort Code From	nvarchar	50	0				Allow NULL?
234	AltSrtCodT	Alternative Sort Code To	nvarchar	50	0				Allow NULL?
235	BinSbl1F	Bin Sublevel 1 From	nvarchar	50	0				Allow NULL?
236	BinSbl1To	Bin Sublevel 1 To	nvarchar	50	0				Allow NULL?
237	BinSbl2F	Bin Sublevel 2 From	nvarchar	50	0				Allow NULL?
238	BinSbl2To	Bin Sublevel 2 To	nvarchar	50	0				Allow NULL?
239	BinSbl3F	Bin Sublevel 3 From	nvarchar	50	0				Allow NULL?
240	BinSbl3To	Bin Sublevel 3 To	nvarchar	50	0				Allow NULL?
241	BinSbl4F	Bin Sublevel 4 From	nvarchar	50	0				Allow NULL?
242	BinSbl4To	Bin Sublevel 4 To	nvarchar	50	0				Allow NULL?
243	BinAttr1F	Bin Attribute 1 From	nvarchar	20	0				Allow NULL?
244	BinAttr1To	Bin Attribute 1 To	nvarchar	20	0				Allow NULL?
245	BinAttr2F	Bin Attribute 2 From	nvarchar	20	0				Allow NULL?
246	BinAttr2To	Bin Attribute 2 To	nvarchar	20	0				Allow NULL?
247	BinAttr3F	Bin Attribute 3 From	nvarchar	20	0				Allow NULL?
248	BinAttr3To	Bin Attribute 3 To	nvarchar	20	0				Allow NULL?
249	BinAttr4F	Bin Attribute 4 From	nvarchar	20	0				Allow NULL?
250	BinAttr4To	Bin Attribute 4 To	nvarchar	20	0				Allow NULL?
251	BinAttr5F	Bin Attribute 5 From	nvarchar	20	0				Allow NULL?
252	BinAttr5To	Bin Attribute 5 To	nvarchar	20	0				Allow NULL?
253	BinAttr6F	Bin Attribute 6 From	nvarchar	20	0				Allow NULL?
254	BinAttr6To	Bin Attribute 6 To	nvarchar	20	0				Allow NULL?
255	BinAttr7F	Bin Attribute 7 From	nvarchar	20	0				Allow NULL?
256	BinAttr7To	Bin Attribute 7 To	nvarchar	20	0				Allow NULL?
257	BinAttr8F	Bin Attribute 8 From	nvarchar	20	0				Allow NULL?
258	BinAttr8To	Bin Attribute 8 To	nvarchar	20	0				Allow NULL?
259	BinAttr9F	Bin Attribute 9 From	nvarchar	20	0				Allow NULL?
260	BinAttr9To	Bin Attribute 9 To	nvarchar	20	0				Allow NULL?
261	BinAttr10F	Bin Attribute 10 From	nvarchar	20	0				Allow NULL?
262	BinAttr10T	Bin Attribute 10 To	nvarchar	20	0				Allow NULL?
263	EnfBinFltr	Enforced Bin Filter	char	1	0		N	B=Both, E=Enforced Bin Location, N=Bin not activated, U=Unenforced Bin Location	Allow NULL?
264	ExItemFrom	Expand from Item	nvarchar	50	0	OITM			Allow NULL?
265	ExItemTo	Expand to Item	nvarchar	50	0	OITM			Allow NULL?
266	ExBPFrom	Expand from BP	nvarchar	15	0	OCRD			Allow NULL?
267	ExBPTo	Expand to BP	nvarchar	15	0	OCRD			Allow NULL?
268	CheckBox34	Check Box 34	char	1	0		N	N=No, Y=Yes	Allow NULL?
269	CheckBox35	Check Box 35	char	1	0		N	N=No, Y=Yes	Allow NULL?
270	BlAgreem	Checkbox for Blanket Agreement	char	1	0		N		Allow NULL?
271	BAFrom	Blanket Agreement From	nvarchar	8	0				Allow NULL?
272	BATo	Blanket Agreement To	nvarchar	8	0				Allow NULL?
273	AdjTrans	Adjustment Transactions	char	1	0		N	N=No, Y=Yes	Allow NULL?
274	TitAcctLvl	Title Account Level	int	11	0		2		Allow NULL?
275	CCDFrom1	CCD Number from condition 1	nvarchar	40	0				Allow NULL?
276	CCDTo1	CCD Number to Condition 1	nvarchar	40	0				Allow NULL?
277	CCDFrom2	CCD Number from Condition 2	nvarchar	40	0				Allow NULL?
278	CCDTo2	CCD Number to Condition 2	nvarchar	40	0				Allow NULL?
279	ArchJrnal	Archiving Journal	char	1	0		N	N=No, Y=Yes	Allow NULL?
280	CardFrom3	From BP	nvarchar	15	0				Allow NULL?
281	CardTo3	To BP	nvarchar	15	0				Allow NULL?
282	OBBranch	Divide Totals by Branch	char	1	0		N	N=No, Y=Yes	Allow NULL?
283	AccumDbCr	Accumulated Debit/Credit	char	1	0		N	N=No, Y=Yes	Allow NULL?
284	RscFrom1	From Resource	nvarchar	50	0	ORSC			Allow NULL?
285	RscTo1	To Resource	nvarchar	50	0	ORSC			Allow NULL?
286	RscGroup	Resource Group	int	6	0	ORSB			Allow NULL?
287	RouteStage	Use Route Stage	char	1	0		N	N=No, Y=Yes	Allow NULL?
288	ExRSTFrom	From Route Stage	int	11	0	ORST			Allow NULL?
289	ExRSTTo	To Route Stage	int	11	0	ORST			Allow NULL?
290	StgSeqNum	Use Stage Sequence Number	char	1	0		N	N=No, Y=Yes	Allow NULL?
291	ExSSNFrom	From Stage Sequence Number	int	11	0				Allow NULL?
292	ExSSNTo	To Stage Sequence Number	int	11	0				Allow NULL?

TOP B1 9.3 | OFLT INDEXES

Name	Primary	Unique	Type	Columns
PRIMARY	No	Yes		FormNum, UserSign, FilterName

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

292 COLUMNS | 1 INDEXES | B1 9.3 | OFLT TABLE

TOP B1 9.3 | OFLT COLUMNS

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

292 COLUMNS | 1 INDEXES | B1 9.3 | OFLT TABLE

TOPB1 9.3 | OFLT COLUMNS

TOPB1 9.3 | OFLT INDEXES

TOP B1 9.3 | OFLT COLUMNS

TOP B1 9.3 | OFLT INDEXES