	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

377 COLUMNS | 1 INDEXES | B1 8.82 | OADM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	8.82	OADM	377	1	Administration	Administration

SQL: selectupdate insert create

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

SELECT CompnyName, CompnyAddr, Country, PrintHeadr, Phone1, Phone2, Fax, E_Mail, Manager, CompType, MainCurncy, SysCurrncy, DispPosDeb, DefLengthU, DefWeightU, DfltVendPM, DirectRate, MinAmnt347, AutoITW, BankCountr, TaxIdNum, RevOffice, FreeZoneNo, DdctFileNo, VatCharge, PayOutVat, VatPrcnt, DpsitPrcnt, IncomeTax, VendorDdct, CustmrDdct, DdctPercnt, DdctExpire, DdctOffice, EURepSqntl, BoxRptSeq, WTLiable, DfltCustPM, AllowFuPos, UseProdWip, CurrPeriod, XmlPath, DflBnkKey, BSInstled, UseShpdGd, UseExtRpt, ERpPerType, DfSVatExmp, DfPVatExmp, Manager1, Manager1F, CCMask, ObligLimit, CreditLimt, SalesLimit, DlnLimit, OrderLimit, AddDlnBlnc, CreditDpst, MultiLang, DbVers, ApplVers, DflWebSite, DflFTPSite, UseTax, RevisionPo, Reindex, DllPath, TaxIdValid, PchName, RpcName, PdnName, RpdName, PorName, LevelWarn, CrdCommUse, ItmCommUse, SlpCommUse, DfCustTerm, DfVendTerm, SaleProfit, CostPrcLst, GrossBySal, TreePricOn, AddVat, BaseFld, ClosedQuot, UseCode, Code1, Code2, Code3, Code4, Color, SumDec, QtyDec, PriceDec, RateDec, PercentDec, MeasureDec, DdAutoRun, DdNextDue, DdHour, CmpnyAddrF, DflTaxCode, PrintHdrF, Phone1F, Phone2F, FaxF, ManagerF, TimeFormat, CigCup, DateFormat, DateSep, FcNoBlnc, ChangeRdr, MultiCurr, PickParDlv, MaxTaxIncr, ISRType, MaxTaxDecr, RoundRmrk, ISRBillerI, UpdStamp, SysCNoEdit, RefDNoEdit, DfltWhs, TaxDNoEdit, DfSVatItem, DfSVatServ, DfPVatItem, DfPVatServ, DoBudget, CustIdNum, BgtBlock, BgtWarning, BdgtPORDoc, BdgtAcctng, BdgtDflt, ContInvnt, InvntSystm, ApplicIFRS, StartYear, According, MltpBrnchs, free34, DftRCN, RoundVat, BdgtPDNDoc, IRSFileNo, DeferrTax, DflIntrst, DfltSlp, DflCrCard, DflBnkCode, DflBnkAcct, DflBranch, UsePaSys, Serv_Usr, Serv_Pass, ParamPath, ExcelPath, TaxIdNum2, TaxIdNum3, DecSep, ThousSep, CurOnRight, WarnByWhs, DflBnkAcKy, PriceSys, DftPVL, useDdctTrc, useDocWrf, BtchStatus, OrderBatch, GLMethod, SetSriUniq, SriUniqFld, MaxHistory, free36, free37, StockNoBas, free39, free40, free41, ChCtrAPAct, ChCtrARAct, free42, free43, CaredType, PBSNumber, PBSGroupNo, OrgNumber, ActSep, DspBokpWin, SHandleWT, SDfltWT, IncresGlAc, PHandleWT, PDfltWT, ExWTLiabl, free44, free45, free46, free47, free48, free49, NegAmount, free61, HldCode, AlphaDoc, free62, free63, free64, free65, OrderBlock, RoundMthd, AdrsFromWH, OrderParty, CrtfcateNO, ExpireDate, NINum, free66, free67, CfwAsnMust, CfwInDflt, CfwOutDflt, free68, free69, free70, AliasName, DftJPELine, RdrConfrmd, PorConfrmd, free71, free72, ChfAcc, TaxMethod, CEO, free73, free74, RndToTDec, SDfltITWT, PDfltITWT, free75, free76, DfActCurr, defTaxVend, free77, free78, free79, free80, free89, AutoVat, ConsumeFCT, ConsumeMtd, DaysBack, DaysFwrd, IsPAPrn, free82, TaxCodeCst, TaxCodeVnd, State, CharMonth, free83, free84, free85, free86, free87, LDiscTotal, Code, DfltDunTrm, Profession, free88, DfltCDP, LogInstanc, UpdateDate, UserSign, DflBCACode, IgrAllCash, TaxPayerRf, EmployerRf, PStatAutCh, PStatDelay, RepBusType, RepBusOthr, BrachNum, BuisnesDsc, ReptMethod, AcctMethod, Bookpitype, ActSoftNam, OpnClsRmrk, TaxRndRule, NegTax, ZeroLine, GBOpenFile, GBIntface, DfltCDPV, OnHldPert, WTRndRule, GPPrcntSrv, DspFrznBP, DspFrznITM, WTAccumAmt, NewDPRCus, ServNature, PickLimit, WTAccAmtAR, UseProdPL, QueryDec, ExRtDefTax, BoletoPath, UserSign2, MMLastImpD, CpyExhRate, MapService, ODWFreq, GTSOutPath, UseMltDims, MDStyle, GTSInPath, GTSSep, GTSDftChk, GTSDftPye, GTSMaxAmt, RspOverAmt, DRBlock1, DRBlock2, DRBlock3, DRBlock4, DRBlock5, PrjBlock, SimReport, SnapShotId, BackOrder, HQLocation, DigCrtPath, DflWTS, EnbApprDI, ChBPSerie, ChItmSerie, ETRTaxOffi, ETRTaxPers, EDocExpFrm, PCN874RTyp, BTWDecProv, BTWDcPrvID, BTWName, BTWStreet, BTWCity, BTWZip, BTWPhone, BTWOB, BTWICP, BTWOBFmt, BTWICPFmt, ETRPhoneNo, EDTestMode, EDocGenTyp, EDocRptFmt, InputMsg, EDProcess, PAC, NotifAlert, NotifEmail, free52, free51, free50, free22, free21, ETRFaxNo, ETRMgrPhn, EDFormat, AIDFormat, CrtLineRFQ, DflJET, OnlyPaidIn FROM OADM

TOP B1 8.82 | OADM COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	CompnyName	Company Name	nvarchar	100	0				Allow NULL?
2	CompnyAddr	Address	nvarchar	254	0				Allow NULL?
3	Country	Country	nvarchar	3	0	OCRY			Allow NULL?
4	PrintHeadr	Printing Header	nvarchar	100	0				Allow NULL?
5	Phone1	Telephone Number 1	nvarchar	20	0				Allow NULL?
6	Phone2	Telephone Number 2	nvarchar	20	0				Allow NULL?
7	Fax	Fax Number	nvarchar	20	0				Allow NULL?
8	E_Mail	E-Mail	nvarchar	100	0				Allow NULL?
9	Manager	Managing Director	nvarchar	100	0				Allow NULL?
10	CompType	Chart of Accounts Template	char	1	0		U		Allow NULL?
11	MainCurncy	Local Currency	nvarchar	3	0				Allow NULL?
12	SysCurrncy	System Currency	nvarchar	3	0				Allow NULL?
13	DispPosDeb	Open Balance with Minus Sign	char	1	0		N	N, Y	Allow NULL?
14	DefLengthU	Standard Unit of Length	int	6	0		2		Allow NULL?
15	DefWeightU	Default Weight UoM	int	6	0		2		Allow NULL?
16	DfltVendPM	Default Payt Method for Vendor	nvarchar	15	0	OPYM			Allow NULL?
17	DirectRate	Direct/Indirect Rate	char	1	0		Y	N, Y	Allow NULL?
18	MinAmnt347	Minimum Amount for 347 Report	num	19	6				Allow NULL?
19	AutoITW	Set Items - Warehouses	char	1	0		N	N, Y	Allow NULL?
20	BankCountr	Bank Country	nvarchar	3	0				Allow NULL?
21	TaxIdNum	Federal Tax ID	nvarchar	32	0				Allow NULL?
22	RevOffice	Tax Office	nvarchar	100	0				Allow NULL?
23	FreeZoneNo	Additional ID Number	nvarchar	32	0				Allow NULL?
24	DdctFileNo	Deduction File No.	nvarchar	50	0				Allow NULL?
25	VatCharge	Tax Collection	char	1	0		Y	N, Y	Allow NULL?
26	PayOutVat	Tax Definition	char	1	0		N	N, Y	Allow NULL?
27	VatPrcnt	Tax Rate	num	19	6				Allow NULL?
28	DpsitPrcnt	Advances on Corp. Income Tax %	num	19	6				Allow NULL?
29	IncomeTax	Withholding Tax %	num	19	6				Allow NULL?
30	VendorDdct	Withholding Tax	char	1	0		N	N, Y	Allow NULL?
31	CustmrDdct	Customer's Deduction at Source	char	1	0		N	N, Y	Allow NULL?
32	DdctPercnt	Withholding Tax Deduction %	num	19	6				Allow NULL?
33	DdctExpire	Withholding Tax Ded. in % - Ex	date	8	0
34	DdctOffice	Withholding Tax Deduction - Of	nvarchar	100	0				Allow NULL?
35	EURepSqntl	Sequential Number of EU Sales	int	11	0		0		Allow NULL?
36	BoxRptSeq	Box Report Sequential Number	int	11	0		0		Allow NULL?
37	WTLiable	WTax Liable	char	1	0		Y		Allow NULL?
38	DfltCustPM	Default Payt Method for Cust.	nvarchar	15	0	OPYM			Allow NULL?
39	AllowFuPos	Allow Future Posting Date	char	1	0		N	N, Y	Allow NULL?
40	UseProdWip	Use Product WIP Account	char	1	0		Y	N, Y	Allow NULL?
41	CurrPeriod	Free7	nvarchar	10	0				Allow NULL?
42	XmlPath	XML File Path	text	16	0
43	DflBnkKey	Default Bank Key	int	11	0	ODSC			Allow NULL?
44	BSInstled	Bank Statement Installed	char	1	0		N	N, Y	Allow NULL?
45	UseShpdGd	Use Shipped Goods Account	char	1	0		N	N, Y	Allow NULL?
46	UseExtRpt	Use Extended Reporting	char	1	0		N	N, Y	Allow NULL?
47	ERpPerType	Period Type for Report Generation	char	1	0		M	M, P, Q, Y	Allow NULL?
48	DfSVatExmp	Sales Tax Group for Exempt	nvarchar	8	0				Allow NULL?
49	DfPVatExmp	Purchases Tax Group for Exempt	nvarchar	8	0				Allow NULL?
50	Manager1	General Manager	nvarchar	100	0				Allow NULL?
51	Manager1F	General Manager (For. Lang.)	nvarchar	100	0				Allow NULL?
52	CCMask	Mask Credit Card Number	char	1	0		Y	N, Y	Allow NULL?
53	ObligLimit	Commitment Restriction	char	1	0		N	N, Y	Allow NULL?
54	CreditLimt	Credit Restriction	char	1	0		N	N, Y	Allow NULL?
55	SalesLimit	Restrict Sales	char	1	0		N	N, Y	Allow NULL?
56	DlnLimit	Restrict Deliv. Notes (PO)	char	1	0		N	N, Y	Allow NULL?
57	OrderLimit	Restrict Orders	char	1	0		N	N, Y	Allow NULL?
58	AddDlnBlnc	Consider Del. Notes in Sales Restriction	char	1	0		N	N, Y	Allow NULL?
59	CreditDpst	Credit Deposit Type	char	1	0		N	N, Y	Allow NULL?
60	MultiLang	Multi-Language Support Enabled	char	1	0		N	N, Y	Allow NULL?
61	DbVers	Database Version	int	11	0				Allow NULL?
62	ApplVers	Application Version	int	11	0				Allow NULL?
63	DflWebSite	Default for Web Site	text	16	0
64	DflFTPSite	Default for FTP Site	text	16	0
65	UseTax	Use Tax	char	1	0		N	N, Y	Allow NULL?
66	RevisionPo	Split PO	char	1	0		N	N, Y	Allow NULL?
67	Reindex	Rebuild Indexes	char	1	0		N	N, Y	Allow NULL?
68	DllPath	Path to Validation DLL	text	16	0
69	TaxIdValid	Tax ID Mandatory Validation	char	1	0		N	N, Y	Allow NULL?
70	PchName	Alternate Name for Purchase	nvarchar	20	0				Allow NULL?
71	RpcName	Alternate Name for A/P Credit	nvarchar	20	0				Allow NULL?
72	PdnName	Alternate Name for Goods Rcpt	nvarchar	20	0				Allow NULL?
73	RpdName	Alternate Name for Gds Return	nvarchar	20	0				Allow NULL?
74	PorName	Alternate Name for Purchase	nvarchar	20	0				Allow NULL?
75	LevelWarn	Alert Type for Whse Inventory	char	1	0		W	B, N, W	Allow NULL?
76	CrdCommUse	Set Commission by Customer	char	1	0		N	N, Y	Allow NULL?
77	ItmCommUse	Set Commission by Item	char	1	0		N	N, Y	Allow NULL?
78	SlpCommUse	Set Commission by Sales Empl.	char	1	0		N	N, Y	Allow NULL?
79	DfCustTerm	Default Payment Term for Cust.	int	6	0		-1		Allow NULL?
80	DfVendTerm	Default Payment Term for Vend.	int	6	0		-1		Allow NULL?
81	SaleProfit	Calc. Gross Profit per Trans.	char	1	0		Y	N, Y	Allow NULL?
82	CostPrcLst	Price List for Reval. Price	int	6	0		-1		Allow NULL?
83	GrossBySal	Gross Profit After Sale	char	1	0		N	N, Y	Allow NULL?
84	TreePricOn	Display Price for Parent Only	char	1	0		N	N, Y	Allow NULL?
85	AddVat	Calc. Tax in Sales Quotation	char	1	0		Y	N, Y	Allow NULL?
86	BaseFld	Base Field	char	1	0		Y	N, Y	Allow NULL?
87	ClosedQuot	Allow Closed Sales Quotations	char	1	0		N	N, Y	Allow NULL?
88	UseCode	User Conversion Code	char	1	0		N	N, Y	Allow NULL?
89	Code1	CODE1	nvarchar	8	0				Allow NULL?
90	Code2	CODE2	nvarchar	8	0				Allow NULL?
91	Code3	CODE3	nvarchar	8	0				Allow NULL?
92	Code4	CODE4	nvarchar	8	0				Allow NULL?
93	Color	Company Color	int	6	0		1	0, 1, 2, 3, 4, 5, 6, 7, 8, 9	Allow NULL?
94	SumDec	Totals Accuracy	int	6	0		2		Allow NULL?
95	QtyDec	Accuracy of Quantities	int	6	0		3		Allow NULL?
96	PriceDec	Price Accuracy	int	6	0		2		Allow NULL?
97	RateDec	Rate Accuracy	int	6	0		4		Allow NULL?
98	PercentDec	Percentage Rate Accuracy	int	6	0		4		Allow NULL?
99	MeasureDec	Measuring Accuracy for Units	int	6	0		3		Allow NULL?
100	DdAutoRun	DD Auto Run	char	1	0		N	N, Y	Allow NULL?
101	DdNextDue	DD Next Due Date	date	8	0
102	DdHour	DD Hour	int	6	0				Allow NULL?
103	CmpnyAddrF	Address in Foreign Language	nvarchar	254	0				Allow NULL?
104	DflTaxCode	Default Tax Code	nvarchar	8	0	OSTC			Allow NULL?
105	PrintHdrF	Letter Header in Foreign Lang.	nvarchar	100	0				Allow NULL?
106	Phone1F	Tel. No. 1 (Foreign Language)	nvarchar	20	0				Allow NULL?
107	Phone2F	Tel. No. 2 (Foreign Language)	nvarchar	20	0				Allow NULL?
108	FaxF	Fax Number (Foreign Lang.)	nvarchar	20	0				Allow NULL?
109	ManagerF	Managing Director (For. Lang.)	nvarchar	100	0				Allow NULL?
110	TimeFormat	Time Template	char	1	0		0	0, 1	Allow NULL?
111	CigCup	Cig and Cup Warning	char	1	0		N	N, Y	Allow NULL?
112	DateFormat	Date Template	char	1	0		0	0, 1, 2, 3, 4, 5, 6	Allow NULL?
113	DateSep	Date Separator	char	1	0		/		Allow NULL?
114	FcNoBlnc	FC Checking Account	char	1	0		B	B, D	Allow NULL?
115	ChangeRdr	Changed Existing Orders	char	1	0		Y	N, Y	Allow NULL?
116	MultiCurr	All Currencies Check	char	1	0		B	B, D	Allow NULL?
117	PickParDlv	Partial Deliv. Pick and Pack	char	1	0		N	N, Y	Allow NULL?
118	MaxTaxIncr	Maximum Increase of Tax Amount	num	19	6				Allow NULL?
119	ISRType	ISR Type	int	6	0		2	1, 2, 3, 4	Allow NULL?
120	MaxTaxDecr	Maximum Decrease of Tax Amount	num	19	6				Allow NULL?
121	RoundRmrk	Display Rounding Remark	char	1	0		Y	N, Y	Allow NULL?
122	ISRBillerI	ISR Biller ID	nvarchar	9	0				Allow NULL?
123	UpdStamp	Update Stamp	int	11	0				Allow NULL?
124	SysCNoEdit	Block System Currency Editing	char	1	0		Y	N, Y	Allow NULL?
125	RefDNoEdit	Block Updating of Posting Date	char	1	0		Y	N, Y	Allow NULL?
126	DfltWhs	Default Warehouse	nvarchar	8	0				Allow NULL?
127	TaxDNoEdit	Free	char	1	0		Y	N, Y	Allow NULL?
128	DfSVatItem	Tax Definition	nvarchar	8	0				Allow NULL?
129	DfSVatServ	Tax Definition	nvarchar	8	0				Allow NULL?
130	DfPVatItem	Tax Group for Purchase Item	nvarchar	8	0				Allow NULL?
131	DfPVatServ	Tax Group for Service Purchase	nvarchar	8	0				Allow NULL?
132	DoBudget	Calculate Budget	char	1	0		N	N, Y	Allow NULL?
133	CustIdNum	Customer ID Number	nvarchar	6	0		0		Allow NULL?
134	BgtBlock	Block Budget	char	1	0		N	B, N, W	Allow NULL?
135	BgtWarning	Budget Alert	char	1	0		A	A, M	Allow NULL?
136	BdgtPORDoc	Block Purchase Orders	char	1	0		Y	N, Y	Allow NULL?
137	BdgtAcctng	Block Bookkeeping	char	1	0		N	N, Y	Allow NULL?
138	BdgtDflt	Default Budget Cost Assmt Mthd	int	11	0		1		Allow NULL?
139	ContInvnt	Perpetual Inventory Management	char	1	0		N	N, Y	Allow NULL?
140	InvntSystm	Perpetual Inventory System	char	1	0		A	A, F, S	Allow NULL?
141	ApplicIFRS	Application of IFRS	char	1	0		N	N, Y	Allow NULL?
142	StartYear	Starting in Fiscal Year	int	6	0				Allow NULL?
143	According	Report According to	int	6	0		1	1, 2, 3	Allow NULL?
144	MltpBrnchs	Allow Multiple Branches	char	1	0		N	N, Y	Allow NULL?
145	free34	Free34	char	1	0				Allow NULL?
146	DftRCN	Default for Retail Chains	int	11	0		-6		Allow NULL?
147	RoundVat	Round Tax Amounts	char	1	0		N	N, Y	Allow NULL?
148	BdgtPDNDoc	Block Dlv. Notes for Purchase	char	1	0		Y	N, Y	Allow NULL?
149	IRSFileNo	File Number in Income Tax	nvarchar	9	0				Allow NULL?
150	DeferrTax	Deferred Tax	char	1	0		N	N, Y	Allow NULL?
151	DflIntrst	Min. Default Interest Amount	num	19	6				Allow NULL?
152	DfltSlp	Sales Employee	int	6	0		-1		Allow NULL?
153	DflCrCard	Default Credit Card	int	6	0				Allow NULL?
154	DflBnkCode	Default Bank No.	nvarchar	30	0				Allow NULL?
155	DflBnkAcct	Default Bank Account	nvarchar	50	0				Allow NULL?
156	DflBranch	Default Branch	nvarchar	50	0				Allow NULL?
157	UsePaSys	Use PA System	char	1	0		N	N, Y	Allow NULL?
158	Serv_Usr	Service Code	nvarchar	20	0				Allow NULL?
159	Serv_Pass	Service Password	nvarchar	20	0				Allow NULL?
160	ParamPath	Param. Folder Path	text	16	0
161	ExcelPath	Excel Folder Path	text	16	0
162	TaxIdNum2	Federal Tax ID 2	nvarchar	32	0				Allow NULL?
163	TaxIdNum3	Federal Tax ID 3	nvarchar	32	0				Allow NULL?
164	DecSep	Decimal Separator	char	1	0		.		Allow NULL?
165	ThousSep	Thousandths Separator	char	1	0		,		Allow NULL?
166	CurOnRight	Display Currency on the Right	char	1	0		N	N, Y	Allow NULL?
167	WarnByWhs	Alert by Warehouse	char	1	0		N	N, Y	Allow NULL?
168	DflBnkAcKy	Default Bank Account Number	int	11	0	DSC1			Allow NULL?
169	PriceSys	Price System	char	1	0		Y	N, Y	Allow NULL?
170	DftPVL	Preferred Vendor Credit	int	11	0		-1		Allow NULL?
171	useDdctTrc	WTax Deduction Hierarchy	char	1	0		N	N, Y	Allow NULL?
172	useDocWrf	Doc. Confirmation	char	1	0		N	N, Y	Allow NULL?
173	BtchStatus	Default for Batch Status	char	1	0		0	0, 1, 2	Allow NULL?
174	OrderBatch	Manage Orders in Batches	char	1	0		Y	N, Y	Allow NULL?
175	GLMethod	Set G/L Account by	char	1	0		W	C, L, W	Allow NULL?
176	SetSriUniq	Set Unique Serial No.	char	1	0		N	N, Y	Allow NULL?
177	SriUniqFld	Unique Serial No.	char	1	0		3	0, 2, 3, 4	Allow NULL?
178	MaxHistory	Max. History	int	11	0		99		Allow NULL?
179	free36	Free36	char	1	0				Allow NULL?
180	free37	Free37	char	1	0				Allow NULL?
181	StockNoBas	StockNoBase	char	1	0				Allow NULL?
182	free39	Free39	char	1	0				Allow NULL?
183	free40	Free40	char	1	0				Allow NULL?
184	free41	Free41	char	1	0				Allow NULL?
185	ChCtrAPAct	Change Def. Recon. A/P Accts	char	1	0		N	N, Y	Allow NULL?
186	ChCtrARAct	Change Def. Recon. A/R Accts	char	1	0		N	N, Y	Allow NULL?
187	free42	Free42	char	1	0				Allow NULL?
188	free43	Free43	char	1	0				Allow NULL?
189	CaredType	BP Type Code	nvarchar	2	0			01, 04, 15, 71, 73, 75	Allow NULL?
190	PBSNumber	PBS Number	nvarchar	8	0				Allow NULL?
191	PBSGroupNo	PBS Group Number	nvarchar	5	0				Allow NULL?
192	OrgNumber	Organization Number	nvarchar	100	0				Allow NULL?
193	ActSep	Account Segments Separator	char	1	0		-		Allow NULL?
194	DspBokpWin	Display Bookkeeping Window	char	1	0		N	N, Y	Allow NULL?
195	SHandleWT	Withholding Tax	char	1	0		N	N, Y	Allow NULL?
196	SDfltWT	Default Withholding Tax Code	nvarchar	4	0	OWHT			Allow NULL?
197	IncresGlAc	G/L Increase Account	nvarchar	15	0	OACT		N, Y	Allow NULL?
198	PHandleWT	Withholding Tax	char	1	0				Allow NULL?
199	PDfltWT	Default Withholding Tax Code	nvarchar	4	0	OWHT			Allow NULL?
200	ExWTLiabl	WTax-Liable Expense	char	1	0		N	N, Y	Allow NULL?
201	free44	Free44	char	1	0				Allow NULL?
202	free45	Free45	char	1	0				Allow NULL?
203	free46	Free46	char	1	0				Allow NULL?
204	free47	Free47	char	1	0				Allow NULL?
205	free48	Free48	char	1	0				Allow NULL?
206	free49	Free49	char	1	0				Allow NULL?
207	NegAmount	Use Negative Amounts	char	1	0		Y	N, Y	Allow NULL?
208	free61	Free61	char	1	0				Allow NULL?
209	HldCode	Holiday Name	nvarchar	20	0	OHLD			Allow NULL?
210	AlphaDoc	Use Alphanum. ID for Document	char	1	0		N	N, Y	Allow NULL?
211	free62	Free62	char	1	0				Allow NULL?
212	free63	Free63	char	1	0				Allow NULL?
213	free64	Free64	char	1	0				Allow NULL?
214	free65	Free65	char	1	0				Allow NULL?
215	OrderBlock	Order Block	char	1	0				Allow NULL?
216	RoundMthd	Rounding Method	char	1	0		N	, N, Y	Allow NULL?
217	AdrsFromWH	Use Whse Address in A/P Docs.	char	1	0		Y	N, Y	Allow NULL?
218	OrderParty	Ordering Party	nvarchar	30	0				Allow NULL?
219	CrtfcateNO	Certificate No.	nvarchar	20	0				Allow NULL?
220	ExpireDate	Expiration Date	date	8	0
221	NINum	National Insurance No.	nvarchar	20	0				Allow NULL?
222	free66	Free66	char	1	0				Allow NULL?
223	free67	Free67	char	1	0				Allow NULL?
224	CfwAsnMust	CFW Assignment Mandatory [Y/N]	char	1	0		Y	N, Y	Allow NULL?
225	CfwInDflt	Incoming Payment Dflt CFW Item	int	11	0				Allow NULL?
226	CfwOutDflt	Outgoing Payment Dflt CFW Item	int	11	0				Allow NULL?
227	free68	Free68	char	1	0				Allow NULL?
228	free69	Free69	char	1	0				Allow NULL?
229	free70	Free70	char	1	0				Allow NULL?
230	AliasName	Alias Name	text	16	0
231	DftJPELine	Default Line For Local Area	char	1	0				Allow NULL?
232	RdrConfrmd	Sales Order Confirmed	char	1	0		Y	N, Y	Allow NULL?
233	PorConfrmd	Purchase Order Confirmed	char	1	0		Y	N, Y	Allow NULL?
234	free71	Free71	char	1	0				Allow NULL?
235	free72	Free72	char	1	0				Allow NULL?
236	ChfAcc	Chief Accountant	int	11	0	OHEM			Allow NULL?
237	TaxMethod	Taxation Method	char	1	0			0, 1	Allow NULL?
238	CEO	CEO	int	11	0	OHEM			Allow NULL?
239	free73	Free73	char	1	0				Allow NULL?
240	free74	Free74	char	1	0				Allow NULL?
241	RndToTDec	Round VAT to Tenths	char	1	0		N	N, Y	Allow NULL?
242	SDfltITWT	Default Income Tax WTax Code	nvarchar	4	0	OWHT			Allow NULL?
243	PDfltITWT	Default Income Tax WTax Code	nvarchar	4	0	OWHT			Allow NULL?
244	free75	Free75	char	1	0				Allow NULL?
245	free76	Free76	char	1	0				Allow NULL?
246	DfActCurr	Default Account Currency	char	1	0		Y	N, Y	Allow NULL?
247	defTaxVend	Deferred Tax for Vendors	char	1	0		N	N, Y	Allow NULL?
248	free77	Free77	char	1	0				Allow NULL?
249	free78	Free78	char	1	0				Allow NULL?
250	free79	Free79	char	1	0				Allow NULL?
251	free80	Free80	char	1	0				Allow NULL?
252	free89	Free89	char	1	0				Allow NULL?
253	AutoVat	Automatic VAT Row Creation in	char	1	0		N	N, Y	Allow NULL?
254	ConsumeFCT	Consumption Forecast	char	1	0		Y	N, Y	Allow NULL?
255	ConsumeMtd	Consumption Method	char	1	0		B	B, F	Allow NULL?
256	DaysBack	Days Backward	int	11	0		7		Allow NULL?
257	DaysFwrd	Days Forward	int	11	0		7		Allow NULL?
258	IsPAPrn	Panama Printer Connected	char	1	0		N	N, Y	Allow NULL?
259	free82	Free82	char	1	0				Allow NULL?
260	TaxCodeCst	Default Tax Code (New Custs.)	nvarchar	8	0	OSTC			Allow NULL?
261	TaxCodeVnd	Default Tax Code (New Vendors)	nvarchar	8	0	OSTC			Allow NULL?
262	State	Status	nvarchar	3	0	OCST			Allow NULL?
263	CharMonth	Number of Characters in Month	int	11	0				Allow NULL?
264	free83	Free83	char	1	0				Allow NULL?
265	free84	Free84	char	1	0				Allow NULL?
266	free85	Free85	char	1	0				Allow NULL?
267	free86	Free86	char	1	0				Allow NULL?
268	free87	Free87	char	1	0				Allow NULL?
269	LDiscTotal	Calc Row Disc. from Tot. Price	char	1	0		Y	N, Y	Allow NULL?
270	Code	Code	int	11	0		1		Allow NULL?
271	DfltDunTrm	Default Dunning Terms	nvarchar	25	0	ODUT			Allow NULL?
272	Profession	Profession	nvarchar	50	0				Allow NULL?
273	free88	Free88	char	1	0				Allow NULL?
274	DfltCDP	Default Closing Date Procedure	int	6	0		-1		Allow NULL?
275	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
276	UpdateDate	Date of Update	date	8	0
277	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
278	DflBCACode	Default Bank Charges Alloc.	nvarchar	3	0	OBCA			Allow NULL?
279	IgrAllCash	Ignore All Cash Flow Relevant	char	1	0		Y	N, Y	Allow NULL?
280	TaxPayerRf	Unique Taxpayer Ref. (UTR)	nvarchar	32	0				Allow NULL?
281	EmployerRf	Employer's Reference	nvarchar	32	0				Allow NULL?
282	PStatAutCh	Period Status Automatic Change	char	1	0		Y	N, Y	Allow NULL?
283	PStatDelay	Period Status Change Delay	int	6	0		1		Allow NULL?
284	RepBusType	Reporting Business Type	nvarchar	2	0		2	1, 2, 3, 4, 9, 99, N, Y	Allow NULL?
285	RepBusOthr	Reporting Business Type Desc.	nvarchar	32	0				Allow NULL?
286	BrachNum	Branch Number	nvarchar	4	0				Allow NULL?
287	BuisnesDsc	Business Description	nvarchar	50	0			N, Y	Allow NULL?
288	ReptMethod	Reporting Method	nvarchar	2	0		2	1, 2, 3	Allow NULL?
289	AcctMethod	Accounting Method	nvarchar	2	0		2	1, 2	Allow NULL?
290	Bookpitype	Bookkeeping Type	nvarchar	2	0		2	1, 2, 3	Allow NULL?
291	ActSoftNam	Accounting Software Name	nvarchar	100	0				Allow NULL?
292	OpnClsRmrk	Copy Opening/Closing Remarks	char	1	0		Y	N, Y	Allow NULL?
293	TaxRndRule	Default Tax Rounding Rule	char	1	0			C, F, R	Allow NULL?
294	NegTax	Allow Negative Tax Amt in Rpt	char	1	0		N	N, Y	Allow NULL?
295	ZeroLine	Allow Zero Row in JE	char	1	0		Y	N, Y	Allow NULL?
296	GBOpenFile	Open GBI File After Export	char	1	0		N	N, Y	Allow NULL?
297	GBIntface	GB Data Interface Enable	char	1	0		N	N, Y	Allow NULL?
298	DfltCDPV	Default A/P Closing Date Proc	int	6	0		-1		Allow NULL?
299	OnHldPert	Capital Goods On Hold Percent	num	19	6				Allow NULL?
300	WTRndRule	Default WTax Rounding Rule	char	1	0			C, F, R	Allow NULL?
301	GPPrcntSrv	Default GP % in Service Doc	num	19	6				Allow NULL?
302	DspFrznBP	Display Inactive BPs in Rpt	char	1	0		Y	N, Y	Allow NULL?
303	DspFrznITM	Display Inactive Items in Rpt	char	1	0		Y	N, Y	Allow NULL?
304	WTAccumAmt	Accum. Amount for WTax on AP	num	19	6				Allow NULL?
305	NewDPRCus	Hide Dpm Invoice	char	1	0		Y	N, Y	Allow NULL?
306	ServNature	Service Nature	char	1	0			D, P	Allow NULL?
307	PickLimit	Restrict Pick List	char	1	0		N	N, Y	Allow NULL?
308	WTAccAmtAR	Accum. Amount for WTax on AR	num	19	6				Allow NULL?
309	UseProdPL	Use Production P&L Accounts	char	1	0		N	N, Y	Allow NULL?
310	QueryDec	Calculated Query Accuracy	int	6	0				Allow NULL?
311	ExRtDefTax	Exchange Rate on Deferred Tax	char	1	0		N	N, Y	Allow NULL?
312	BoletoPath	Boleto Path	text	16	0
313	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
314	MMLastImpD	Last Import File Date	date	8	0
315	CpyExhRate	Copy Exchange Rate in Copy to	char	1	0		N	N, Y	Allow NULL?
316	MapService	Map Service	int	11	0	OMPS	-1		Allow NULL?
317	ODWFreq	Open Doc. Refresh Frequency	int	11	0		30		Allow NULL?
318	GTSOutPath	GTS Outbound Path	text	16	0
319	UseMltDims	Use Multidimensions	char	1	0		Y	N, Y	Allow NULL?
320	MDStyle	Multidimensions Display Style	char	1	0		U	S, U	Allow NULL?
321	GTSInPath	GTS Inbound Path	text	16	0
322	GTSSep	GTS Separator	nvarchar	10	0				Allow NULL?
323	GTSDftChk	GTS Default Checker	int	11	0	OHEM			Allow NULL?
324	GTSDftPye	GTS Default Payee	int	11	0	OHEM			Allow NULL?
325	GTSMaxAmt	GTS Max. Amount	num	19	6				Allow NULL?
326	RspOverAmt	Response to Exceeding Amount	char	1	0		B	B, S	Allow NULL?
327	DRBlock1	Distribution Rule: Block 1	char	1	0		N	B, N	Allow NULL?
328	DRBlock2	Distribution Rule: Block 2	char	1	0		N	B, N	Allow NULL?
329	DRBlock3	Distribution Rule: Block 3	char	1	0		N	B, N	Allow NULL?
330	DRBlock4	Distribution Rule: Block 4	char	1	0		N	B, N	Allow NULL?
331	DRBlock5	Distribution Rule: Block 5	char	1	0		N	B, N	Allow NULL?
332	PrjBlock	Project Block	char	1	0		N	B, N	Allow NULL?
333	SimReport	Simulation Report	char	1	0		N	N, Y	Allow NULL?
334	SnapShotId	Snapshot ID	int	11	0		0		Allow NULL?
335	BackOrder	Pick and Pack Back Order	char	1	0		N	N, Y	Allow NULL?
336	HQLocation	Headquarters Location	char	1	0		B	A, B, C, M	Allow NULL?
337	DigCrtPath	Digital Certificate Path	text	16	0			N, Y
338	DflWTS	Default E-Tax Web Site	int	6	0		-1		Allow NULL?
339	EnbApprDI	Enable DI Approval Procedure	char	1	0		N	N, Y	Allow NULL?
340	ChBPSerie	Verify Non-manual BP Series	char	1	0		N	N, Y	Allow NULL?
341	ChItmSerie	Verify Non-manual ITM Series	char	1	0		N	N, Y	Allow NULL?
342	ETRTaxOffi	ETR Tax Office	int	11	0	OTOF	0		Allow NULL?
343	ETRTaxPers	ETR Tax Person Type	char	1	0			D, I, R, S, T	Allow NULL?
344	EDocExpFrm	Electronic Doc. Export Format	int	11	0			N, Y	Allow NULL?
345	PCN874RTyp	PCN874 Report Type	char	1	0		1	1, 6	Allow NULL?
346	BTWDecProv	BTW Declaration Provider	nvarchar	3	0		BPL	BPL, INT	Allow NULL?
347	BTWDcPrvID	BTW Declaration Provider ID	nvarchar	100	0				Allow NULL?
348	BTWName	BTW Name	nvarchar	100	0				Allow NULL?
349	BTWStreet	BTW Street	nvarchar	100	0				Allow NULL?
350	BTWCity	BTW City	nvarchar	100	0				Allow NULL?
351	BTWZip	BTW ZIP Code	nvarchar	30	0				Allow NULL?
352	BTWPhone	BTW Phone Number	nvarchar	100	0				Allow NULL?
353	BTWOB	BTW OB ID	int	11	0		1		Allow NULL?
354	BTWICP	BTW ICL ID	int	11	0		1		Allow NULL?
355	BTWOBFmt	BTW OB Mapping Format	int	11	0				Allow NULL?
356	BTWICPFmt	BTW ICP Mapping Format	int	11	0				Allow NULL?
357	ETRPhoneNo	ETR Telephone Number	nvarchar	20	0				Allow NULL?
358	EDTestMode	Electronic Document Test Mode	char	1	0		N	N, Y	Allow NULL?
359	EDocGenTyp	El. Doc. Default Gen. Type	char	1	0		N	G, L, N	Allow NULL?
360	EDocRptFmt	El. Document Report Format	int	11	0				Allow NULL?
361	InputMsg	El. Doc. Input Message Format	int	11	0				Allow NULL?
362	EDProcess	Electronic Document Process	char	1	0		I	C, I	Allow NULL?
363	PAC	PAC	nvarchar	20	0	OPAC	XML		Allow NULL?
364	NotifAlert	Notification by Alert	char	1	0		Y	N, Y	Allow NULL?
365	NotifEmail	Notification by E-mail	char	1	0		N	N, Y	Allow NULL?
366	free52	Free52	char	1	0				Allow NULL?
367	free51	Free51	char	1	0				Allow NULL?
368	free50	Free50	char	1	0				Allow NULL?
369	free22	Free22	char	1	0				Allow NULL?
370	free21	Free21	char	1	0				Allow NULL?
371	ETRFaxNo	ETR Fax Number	nvarchar	20	0				Allow NULL?
372	ETRMgrPhn	ETR Manager's Phone Number	nvarchar	20	0				Allow NULL?
373	EDFormat	Electronic Document Format	int	11	0	OLLF			Allow NULL?
374	AIDFormat	Annual Invoice Decl. Format	int	11	0	OLLF			Allow NULL?
375	CrtLineRFQ	Create online quotation	char	1	0		N	N, Y	Allow NULL?
376	DflJET	Default JE Type	nvarchar	60	0	OJET			Allow NULL?
377	OnlyPaidIn	Display Only Paid Reserve Inv.	char	1	0		N	N, Y	Allow NULL?

TOP B1 8.82 | OADM INDEXES

Name	Primary	Unique	Type	Columns
PRIMARY	No	Yes		Code

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

377 COLUMNS | 1 INDEXES | B1 8.82 | OADM TABLE

TOP B1 8.82 | OADM COLUMNS

TOP B1 8.82 | OADM 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

377 COLUMNS | 1 INDEXES | B1 8.82 | OADM TABLE

TOPB1 8.82 | OADM COLUMNS

TOPB1 8.82 | OADM INDEXES

TOP B1 8.82 | OADM COLUMNS

TOP B1 8.82 | OADM INDEXES