	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

328 COLUMNS | 1 INDEXES | B1 8.8 | OADM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	8.8	OADM	328	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, free20, free21, ObligLimit, CreditLimt, SalesLimit, DlnLimit, OrderLimit, AddDlnBlnc, CreditDpst, free22, MultiLang, DbVers, ApplVers, DflWebSite, DflFTPSite, UseTax, RevisionPo, Reindex, free24, free25, 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, free26, DateFormat, DateSep, FcNoBlnc, ChangeRdr, MultiCurr, free27, free28, ISRType, free29, RoundRmrk, ISRBillerI, UpdStamp, SysCNoEdit, RefDNoEdit, DfltWhs, TaxDNoEdit, DfSVatItem, DfSVatServ, DfPVatItem, DfPVatServ, DoBudget, CustIdNum, BgtBlock, BgtWarning, BdgtPORDoc, BdgtAcctng, BdgtDflt, ContInvnt, InvntSystm, free30, free31, free32, free33, 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, free50, free51, free52, free53, free54, free55, free56, free57, free58, free59, free60, 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, free81, 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, free18, free19, QueryDec, ExRtDefTax, BoletoPath, UserSign2, MMLastImpD, CpyExhRate FROM OADM

TOP B1 8.8 | 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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
18	MinAmnt347	Minimum Amount for 347 Report	num	19	6				Allow NULL?
19	AutoITW	Set Items - Warehouses	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
26	PayOutVat	Tax Definition	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
31	CustmrDdct	Customer's Deduction at Source	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
40	UseProdWip	Use Product WIP Account	char	1	0		Y	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
45	UseShpdGd	Use Shipped Goods Account	char	1	0		N	N=No, Y=Yes	Allow NULL?
46	UseExtRpt	Use Extended Reporting	char	1	0		N	N=No, Y=Yes	Allow NULL?
47	ERpPerType	Period Type for Report GeneratiÌERpPerType	char	1	0		M	M=Month, P=Period, Q=Quarter, Y=Year	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	free20	Free20	char	1	0				Allow NULL?
53	free21	Free21	char	1	0				Allow NULL?
54	ObligLimit	Commitment Restriction	char	1	0		N	N=No, Y=Yes	Allow NULL?
55	CreditLimt	Credit Restriction	char	1	0		N	N=No, Y=Yes	Allow NULL?
56	SalesLimit	Restrict Sales	char	1	0		N	N=No, Y=Yes	Allow NULL?
57	DlnLimit	Restrict Deliv. Notes (PO)	char	1	0		N	N=No, Y=Yes	Allow NULL?
58	OrderLimit	Restrict Orders	char	1	0		N	N=No, Y=Yes	Allow NULL?
59	AddDlnBlnc	Consider Del. Notes in Sales R	char	1	0		N	N=No, Y=Yes	Allow NULL?
60	CreditDpst	Credit Deposit Type	char	1	0		N	N=Automatically, Y=Manually	Allow NULL?
61	free22	Free22	char	1	0				Allow NULL?
62	MultiLang	Multi-Language Support Enabled	char	1	0		N	N=No, Y=Yes	Allow NULL?
63	DbVers	Database Version	int	11	0				Allow NULL?
64	ApplVers	Application Version	int	11	0				Allow NULL?
65	DflWebSite	Default for Web Site	text	16	0
66	DflFTPSite	Default for FTP Site	text	16	0
67	UseTax	Use Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
68	RevisionPo	Split PO	char	1	0		N	N=No, Y=Yes	Allow NULL?
69	Reindex	Rebuild Indexes	char	1	0		N	N=No, Y=Yes	Allow NULL?
70	free24	Free24	char	1	0				Allow NULL?
71	free25	Free25	char	1	0				Allow NULL?
72	PchName	Alternate Name for Purchase	nvarchar	20	0				Allow NULL?
73	RpcName	Alternate Name for A/P Credit	nvarchar	20	0				Allow NULL?
74	PdnName	Alternate Name for Goods Rcpt	nvarchar	20	0				Allow NULL?
75	RpdName	Alternate Name for Gds Return	nvarchar	20	0				Allow NULL?
76	PorName	Alternate Name for Purchase	nvarchar	20	0				Allow NULL?
77	LevelWarn	Alert Type for Whse Inventory	char	1	0		W	B=Block, N=No Message, W=Warning Only	Allow NULL?
78	CrdCommUse	Set Commission by Customer	char	1	0		N	N=No, Y=Yes	Allow NULL?
79	ItmCommUse	Set Commission by Item	char	1	0		N	N=No, Y=Yes	Allow NULL?
80	SlpCommUse	Set Commission by Sales Empl.	char	1	0		N	N=No, Y=Yes	Allow NULL?
81	DfCustTerm	Default Payment Term for Cust.	int	6	0		-1		Allow NULL?
82	DfVendTerm	Default Payment Term for Vend.	int	6	0		-1		Allow NULL?
83	SaleProfit	Calc. Gross Profit per Trans.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
84	CostPrcLst	Price List for Reval. Price	int	6	0		-1		Allow NULL?
85	GrossBySal	Gross Profit After Sale	char	1	0		N	N=No, Y=Yes	Allow NULL?
86	TreePricOn	Display Price for Price Only	char	1	0		N	N=No, Y=Yes	Allow NULL?
87	AddVat	Calc. Tax in Sales Quotation	char	1	0		Y	N=No, Y=Yes	Allow NULL?
88	BaseFld	Base Field	char	1	0		Y	N=No, Y=Yes	Allow NULL?
89	ClosedQuot	Allow Closed Sales Quotations	char	1	0		N	N=No, Y=Yes	Allow NULL?
90	UseCode	User Conversion Code	char	1	0		N	N=No, Y=Yes	Allow NULL?
91	Code1	CODE1	nvarchar	8	0				Allow NULL?
92	Code2	CODE2	nvarchar	8	0				Allow NULL?
93	Code3	CODE3	nvarchar	8	0				Allow NULL?
94	Code4	CODE4	nvarchar	8	0				Allow NULL?
95	Color	Company Color	int	6	0		1	0=Combined, 1=Classic, 2=Gray, 3=Violet, 4=Blue, 5=Green, 6=Yellow, 7=Orange, 8=Red, 9=Brown	Allow NULL?
96	SumDec	Totals Accuracy	int	6	0		2		Allow NULL?
97	QtyDec	Accuracy of Quantities	int	6	0		3		Allow NULL?
98	PriceDec	Price Accuracy	int	6	0		2		Allow NULL?
99	RateDec	Rate Accuracy	int	6	0		4		Allow NULL?
100	PercentDec	Percentage Rate Accuracy	int	6	0		4		Allow NULL?
101	MeasureDec	Measuring Accuracy for Units	int	6	0		3		Allow NULL?
102	DdAutoRun	DD Auto Run	char	1	0		N	N=No, Y=Yes	Allow NULL?
103	DdNextDue	DD Next Due Date	date	8	0
104	DdHour	DD Hour	int	6	0				Allow NULL?
105	CmpnyAddrF	Address in Foreign Language	nvarchar	254	0				Allow NULL?
106	DflTaxCode	Default Tax Code	nvarchar	8	0	OSTC			Allow NULL?
107	PrintHdrF	Letter Header in Foreign Lang.	nvarchar	100	0				Allow NULL?
108	Phone1F	Tel. No. 1 (Foreign Language)	nvarchar	20	0				Allow NULL?
109	Phone2F	Tel. No. 2 (Foreign Language)	nvarchar	20	0				Allow NULL?
110	FaxF	Fax Number (Foreign Lang.)	nvarchar	20	0				Allow NULL?
111	ManagerF	Managing Director (For. Lang.)	nvarchar	100	0				Allow NULL?
112	TimeFormat	Time Template	char	1	0		0	0=24H, 1=12H	Allow NULL?
113	free26	Free26	char	1	0				Allow NULL?
114	DateFormat	Date Template	char	1	0		0	0=DD/MM/YY, 1=DD/MM/CCYY, 2=MM/DD/YY, 3=MM/DD/CCYY, 4=CCYY/MM/DD, 5=DD/Month/YYYY, 6=YY/MM/DD	Allow NULL?
115	DateSep	Date Separator	char	1	0		/		Allow NULL?
116	FcNoBlnc	FC Checking Account	char	1	0		B	B=Block, D=No Message	Allow NULL?
117	ChangeRdr	Changed Existing Orders	char	1	0		Y	N=No, Y=Yes	Allow NULL?
118	MultiCurr	All Currencies Check	char	1	0		B	B=Block, D=No Message	Allow NULL?
119	free27	Free27	char	1	0				Allow NULL?
120	free28	Free28	char	1	0				Allow NULL?
121	ISRType	ISR Type	int	6	0		2	1=ISR, 2=BISR, 3=ISR+, 4=BISR+	Allow NULL?
122	free29	Free29	char	1	0				Allow NULL?
123	RoundRmrk	Display Rounding Remark	char	1	0		Y	N=No, Y=Yes	Allow NULL?
124	ISRBillerI	ISR Biller ID	nvarchar	9	0				Allow NULL?
125	UpdStamp	Update Stamp	int	11	0				Allow NULL?
126	SysCNoEdit	Block System Currency Editing	char	1	0		Y	N=No, Y=Yes	Allow NULL?
127	RefDNoEdit	Block Updating of Posting Date	char	1	0		Y	N=No, Y=Yes	Allow NULL?
128	DfltWhs	Default Warehouse	nvarchar	8	0				Allow NULL?
129	TaxDNoEdit	Free	char	1	0		Y	N=No, Y=Yes	Allow NULL?
130	DfSVatItem	Tax Definition	nvarchar	8	0				Allow NULL?
131	DfSVatServ	Tax Definition	nvarchar	8	0				Allow NULL?
132	DfPVatItem	Tax Group for Purchase Item	nvarchar	8	0				Allow NULL?
133	DfPVatServ	Tax Group for Service Purchase	nvarchar	8	0				Allow NULL?
134	DoBudget	Calculate Budget	char	1	0		N	N=No, Y=Yes	Allow NULL?
135	CustIdNum	Customer Id Number	nvarchar	6	0		0		Allow NULL?
136	BgtBlock	Block Budget	char	1	0		N	B=Only Annual Alert, N=Monthly Alert Only, W=Block	Allow NULL?
137	BgtWarning	Budget Alert	char	1	0		A	A=Annual Alert, M=Monthly Alert	Allow NULL?
138	BdgtPORDoc	Block Purchase Orders	char	1	0		Y	N=No, Y=Yes	Allow NULL?
139	BdgtAcctng	Block Bookkeeping	char	1	0		N	N=No, Y=Yes	Allow NULL?
140	BdgtDflt	Default Budget Cost Assmt Mthd	int	11	0		1		Allow NULL?
141	ContInvnt	Perpetual Inventory Management	char	1	0		N	N=No, Y=Yes	Allow NULL?
142	InvntSystm	Perpetual Inventory System	char	1	0		A	A=Moving Average, F=FIFO, S=Standard	Allow NULL?
143	free30	Free30	char	1	0				Allow NULL?
144	free31	Free31	char	1	0				Allow NULL?
145	free32	Free32	char	1	0				Allow NULL?
146	free33	Free33	char	1	0				Allow NULL?
147	free34	Free34	char	1	0				Allow NULL?
148	DftRCN	Default for Retail Chains	int	11	0		-6		Allow NULL?
149	RoundVat	Round Tax Amounts	char	1	0		N	N=No, Y=Yes	Allow NULL?
150	BdgtPDNDoc	Block Dlv. Notes for Purchase	char	1	0		Y	N=No, Y=Yes	Allow NULL?
151	IRSFileNo	File Number in Income Tax	nvarchar	9	0				Allow NULL?
152	DeferrTax	Deferred Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
153	DflIntrst	Min. Default Interest Amount	num	19	6				Allow NULL?
154	DfltSlp	Sales Employee	int	6	0		-1		Allow NULL?
155	DflCrCard	Default Credit Card	int	6	0				Allow NULL?
156	DflBnkCode	Default Bank No.	nvarchar	30	0				Allow NULL?
157	DflBnkAcct	Default Bank Account	nvarchar	50	0				Allow NULL?
158	DflBranch	Default Branch	nvarchar	50	0				Allow NULL?
159	UsePaSys	Use PA System	char	1	0		N	N=No, Y=Yes	Allow NULL?
160	Serv_Usr	Service Code	nvarchar	20	0				Allow NULL?
161	Serv_Pass	Service Password	nvarchar	20	0				Allow NULL?
162	ParamPath	Param. Folder Path	text	16	0
163	ExcelPath	Excel Folder Path	text	16	0
164	TaxIdNum2	Federal Tax ID 2	nvarchar	32	0				Allow NULL?
165	TaxIdNum3	Federal Tax ID 3	nvarchar	32	0				Allow NULL?
166	DecSep	Decimal Separator	char	1	0		.		Allow NULL?
167	ThousSep	Thousandths Separator	char	1	0		,		Allow NULL?
168	CurOnRight	Display Currency on the Right	char	1	0		N	N=No, Y=Yes	Allow NULL?
169	WarnByWhs	Alert by Warehouse	char	1	0		N	N=No, Y=Yes	Allow NULL?
170	DflBnkAcKy	Default Bank Account Number	int	11	0	DSC1			Allow NULL?
171	PriceSys	Price System	char	1	0		Y	N=Item, Y=Whse	Allow NULL?
172	DftPVL	Preferred Vendor Credit	int	11	0		-1		Allow NULL?
173	useDdctTrc	WTax Deduction Hierarchy	char	1	0		N	N=No, Y=Yes	Allow NULL?
174	useDocWrf	Doc. Confirmation	char	1	0		N	N=No, Y=Yes	Allow NULL?
175	BtchStatus	Default for Batch Status	char	1	0		0	0=Released, 1=Not Accessible, 2=Locked	Allow NULL?
176	OrderBatch	Manage Orders in Batches	char	1	0		Y	N=No, Y=Yes	Allow NULL?
177	GLMethod	Set G/L Account by	char	1	0		W	C=Item Group, L=Item Level, W=Warehouse	Allow NULL?
178	SetSriUniq	Set Unique Serial No.	char	1	0		N	N=No, Y=Yes	Allow NULL?
179	SriUniqFld	Unique Serial No.	char	1	0		3	0=None, 2=Mfr Serial No., 3=Serial Number, 4=Lot Number	Allow NULL?
180	MaxHistory	Max. History	int	11	0		99		Allow NULL?
181	free36	Free36	char	1	0				Allow NULL?
182	free37	Free37	char	1	0				Allow NULL?
183	StockNoBas	StockNoBase	char	1	0				Allow NULL?
184	free39	Free39	char	1	0				Allow NULL?
185	free40	Free40	char	1	0				Allow NULL?
186	free41	Free41	char	1	0				Allow NULL?
187	ChCtrAPAct	Change Def. Recon. A/P Accts	char	1	0		N	N=No, Y=Yes	Allow NULL?
188	ChCtrARAct	Change Def. Recon. A/R Accts	char	1	0		N	N=No, Y=Yes	Allow NULL?
189	free42	Free42	char	1	0				Allow NULL?
190	free43	Free43	char	1	0				Allow NULL?
191	CaredType	BP Type Code	nvarchar	2	0			01=01, 04=04, 15=15, 71=71, 73=73, 75=75	Allow NULL?
192	PBSNumber	PBS Number	nvarchar	8	0				Allow NULL?
193	PBSGroupNo	PBS Group Number	nvarchar	5	0				Allow NULL?
194	OrgNumber	Organization Number	nvarchar	100	0				Allow NULL?
195	ActSep	Account Segments Separator	char	1	0		-		Allow NULL?
196	DspBokpWin	Display Bookkeeping Window	char	1	0		N	N=No, Y=Yes	Allow NULL?
197	SHandleWT	Withholding Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
198	SDfltWT	Default Withholding Tax Code	nvarchar	4	0	OWHT			Allow NULL?
199	IncresGlAc	G/L Increase Account	nvarchar	15	0	OACT		N=No, Y=Yes	Allow NULL?
200	PHandleWT	Withholding Tax	char	1	0				Allow NULL?
201	PDfltWT	Default Withholding Tax Code	nvarchar	4	0	OWHT			Allow NULL?
202	ExWTLiabl	WTax-Liable Expense	char	1	0		N	N=No, Y=Yes	Allow NULL?
203	free44	Free44	char	1	0				Allow NULL?
204	free45	Free45	char	1	0				Allow NULL?
205	free46	Free46	char	1	0				Allow NULL?
206	free47	Free47	char	1	0				Allow NULL?
207	free48	Free48	char	1	0				Allow NULL?
208	free49	Free49	char	1	0				Allow NULL?
209	NegAmount	Use Negative Amounts	char	1	0		Y	N=No, Y=Yes	Allow NULL?
210	free50	Free50	char	1	0				Allow NULL?
211	free51	Free51	char	1	0				Allow NULL?
212	free52	Free52	char	1	0				Allow NULL?
213	free53	Free53	char	1	0				Allow NULL?
214	free54	Free54	char	1	0				Allow NULL?
215	free55	Free55	char	1	0				Allow NULL?
216	free56	Free56	char	1	0				Allow NULL?
217	free57	Free57	char	1	0				Allow NULL?
218	free58	Free58	char	1	0				Allow NULL?
219	free59	Free59	char	1	0				Allow NULL?
220	free60	Free60	char	1	0				Allow NULL?
221	free61	Free61	char	1	0				Allow NULL?
222	HldCode	Holiday Name	nvarchar	20	0	OHLD			Allow NULL?
223	AlphaDoc	Use Alphanum. ID for Document	char	1	0		N	N=No, Y=Yes	Allow NULL?
224	free62	Free62	char	1	0				Allow NULL?
225	free63	Free63	char	1	0				Allow NULL?
226	free64	Free64	char	1	0				Allow NULL?
227	free65	Free65	char	1	0				Allow NULL?
228	OrderBlock	Order Block	char	1	0				Allow NULL?
229	RoundMthd	Rounding Method	char	1	0		N	, N=No, Y=Yes	Allow NULL?
230	AdrsFromWH	Use Whse Address in A/P Docs.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
231	OrderParty	Ordering Party	nvarchar	30	0				Allow NULL?
232	CrtfcateNO	Certificate No.	nvarchar	20	0				Allow NULL?
233	ExpireDate	Expiration Date	date	8	0
234	NINum	National Insurance No.	nvarchar	20	0				Allow NULL?
235	free66	Free66	char	1	0				Allow NULL?
236	free67	Free67	char	1	0				Allow NULL?
237	CfwAsnMust	CFW Assignment Mandatory [Y/N]	char	1	0		Y	N=No, Y=Yes	Allow NULL?
238	CfwInDflt	Incoming Payment Dflt CFW Item	int	11	0				Allow NULL?
239	CfwOutDflt	Outgoing Payment Dflt CFW Item	int	11	0				Allow NULL?
240	free68	Free68	char	1	0				Allow NULL?
241	free69	Free69	char	1	0				Allow NULL?
242	free70	Free70	char	1	0				Allow NULL?
243	AliasName	Alias Name	text	16	0
244	DftJPELine	Default Line For Local Area	char	1	0				Allow NULL?
245	RdrConfrmd	Sales Order Confirmed	char	1	0		Y	N=No, Y=Yes	Allow NULL?
246	PorConfrmd	Purchase Order Confirmed	char	1	0		Y	N=No, Y=Yes	Allow NULL?
247	free71	Free71	char	1	0				Allow NULL?
248	free72	Free72	char	1	0				Allow NULL?
249	ChfAcc	Chief Accountant	int	11	0	OHEM			Allow NULL?
250	TaxMethod	Taxation Method	char	1	0			0=On Shipment, 1=On Payment	Allow NULL?
251	CEO	CEO	int	11	0	OHEM			Allow NULL?
252	free73	Free73	char	1	0				Allow NULL?
253	free74	Free74	char	1	0				Allow NULL?
254	RndToTDec	Round VAT to Tenths	char	1	0		N	N=No, Y=Yes	Allow NULL?
255	SDfltITWT	Default Income Tax WTax Code	nvarchar	4	0	OWHT			Allow NULL?
256	PDfltITWT	Default Income Tax WTax Code	nvarchar	4	0	OWHT			Allow NULL?
257	free75	Free75	char	1	0				Allow NULL?
258	free76	Free76	char	1	0				Allow NULL?
259	DfActCurr	Default Account Currency	char	1	0		Y	N=Local Currency, Y=All Currencies	Allow NULL?
260	defTaxVend	Deferred Tax for Vendors	char	1	0		N	N=No, Y=Yes	Allow NULL?
261	free77	Free77	char	1	0				Allow NULL?
262	free78	Free78	char	1	0				Allow NULL?
263	free79	Free79	char	1	0				Allow NULL?
264	free80	Free80	char	1	0				Allow NULL?
265	free89	Free89	char	1	0				Allow NULL?
266	AutoVat	Automatic VAT Row Creation in	char	1	0		N	N=No, Y=Yes	Allow NULL?
267	ConsumeFCT	Consumption Forecast	char	1	0		Y	N=No, Y=Yes	Allow NULL?
268	ConsumeMtd	Consumption Method	char	1	0		B	B=Backward-Forward, F=Forward-Backward	Allow NULL?
269	DaysBack	Days Backward	int	11	0		7		Allow NULL?
270	DaysFwrd	Days Forward	int	11	0		7		Allow NULL?
271	free81	Free81	char	1	0				Allow NULL?
272	free82	Free82	char	1	0				Allow NULL?
273	TaxCodeCst	Default Tax Code (New Custs.)	nvarchar	8	0	OSTC			Allow NULL?
274	TaxCodeVnd	Default Tax Code (New Vendors)	nvarchar	8	0	OSTC			Allow NULL?
275	State	Status	nvarchar	3	0	OCST			Allow NULL?
276	CharMonth	Number of Characters in Month	int	11	0				Allow NULL?
277	free83	Free83	char	1	0				Allow NULL?
278	free84	Free84	char	1	0				Allow NULL?
279	free85	Free85	char	1	0				Allow NULL?
280	free86	Free86	char	1	0				Allow NULL?
281	free87	Free87	char	1	0				Allow NULL?
282	LDiscTotal	Calc Row Disc. from Tot. Price	char	1	0		Y	N=No, Y=Yes	Allow NULL?
283	Code	Code	int	11	0		1		Allow NULL?
284	DfltDunTrm	Default Dunning Terms	nvarchar	25	0	ODUT			Allow NULL?
285	Profession	Profession	nvarchar	50	0				Allow NULL?
286	free88	Free88	char	1	0				Allow NULL?
287	DfltCDP	Default Closing Date Procedure	int	6	0		-1		Allow NULL?
288	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
289	UpdateDate	Date of Update	date	8	0
290	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
291	DflBCACode	Default Bank Charges Alloc.	nvarchar	3	0	OBCA			Allow NULL?
292	IgrAllCash	Ignore All Cash Flow Relevant	char	1	0		Y	N=No, Y=Yes	Allow NULL?
293	TaxPayerRf	Unique Taxpayer Ref. (UTR)	nvarchar	32	0				Allow NULL?
294	EmployerRf	Employer's Reference	nvarchar	32	0				Allow NULL?
295	PStatAutCh	Period Status Automatic Change	char	1	0		Y	N=No, Y=Yes	Allow NULL?
296	PStatDelay	Period Status Change Delay	int	6	0		1		Allow NULL?
297	RepBusType	Reporting Business Type	nvarchar	2	0		2	1=Industrial, 2=Commercial, 3=Service Provider, 4=Contractor, 99=Report includes more than one business, 9=Other, N=No, Y=Yes	Allow NULL?
298	RepBusOthr	Reporting Business Type Desc.	nvarchar	32	0				Allow NULL?
299	BrachNum	Branch Number	nvarchar	4	0				Allow NULL?
300	BuisnesDsc	Business Description	nvarchar	50	0			N=No, Y=Yes	Allow NULL?
301	ReptMethod	Reporting Method	nvarchar	2	0		2	1=Cash, 2=Cumulative	Allow NULL?
302	AcctMethod	Accounting Method	nvarchar	2	0		2	1=Unilateral, 2=Double	Allow NULL?
303	Bookpitype	Bookkeeping Type	nvarchar	2	0		2	1=Manual, 2=Computerized, 3=Mixed	Allow NULL?
304	ActSoftNam	Accounting Software Name	nvarchar	100	0				Allow NULL?
305	OpnClsRmrk	Copy Opening/Closing Remarks	char	1	0		Y	N=No, Y=Yes	Allow NULL?
306	TaxRndRule	Default Tax Rounding Rule	char	1	0			C=Round Up, F=Round Down, R=Round Off	Allow NULL?
307	NegTax	Allow Negative Tax Amt in Rpt	char	1	0		N	N=No, Y=Yes	Allow NULL?
308	ZeroLine	Allow Zero Row in JE	char	1	0		Y	N=No, Y=Yes	Allow NULL?
309	GBOpenFile	Open GBI File After Export	char	1	0		N	N=No, Y=Yes	Allow NULL?
310	GBIntface	GB Data Interface Enable	char	1	0		N	N=No, Y=Yes	Allow NULL?
311	DfltCDPV	Default A/P Closing Date Proc	int	6	0		-1		Allow NULL?
312	OnHldPert	Capital Goods On Hold Percent	num	19	6				Allow NULL?
313	WTRndRule	Default WTax Rounding Rule	char	1	0			C=Round Up, F=Round Down, R=Round Off	Allow NULL?
314	GPPrcntSrv	Default GP % in Service Doc	num	19	6				Allow NULL?
315	DspFrznBP	Display Inactive BPs in Rpt	char	1	0		Y	N=No, Y=Yes	Allow NULL?
316	DspFrznITM	Display Inactive Items in Rpt	char	1	0		Y	N=No, Y=Yes	Allow NULL?
317	WTAccumAmt	Accumulated Amount for WTax	num	19	6				Allow NULL?
318	NewDPRCus	Hide Dpm Invoice	char	1	0		Y	N=No, Y=Yes	Allow NULL?
319	ServNature	Service Nature	char	1	0			D=Service Distributor, P=Service Provider	Allow NULL?
320	PickLimit	Restrict Pick List	char	1	0		N	N=No, Y=Yes	Allow NULL?
321	free18	Free18	char	1	0				Allow NULL?
322	free19	Free19	char	1	0				Allow NULL?
323	QueryDec	Calculated Query Accuracy	int	6	0				Allow NULL?
324	ExRtDefTax	Exchange Rate on Deferred Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
325	BoletoPath	Boleto Path	text	16	0
326	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
327	MMLastImpD	Last Import File Date	date	8	0
328	CpyExhRate	Copy Exchange Rate in Copy to	char	1	0		N	N=No, Y=Yes	Allow NULL?

TOP B1 8.8 | 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

328 COLUMNS | 1 INDEXES | B1 8.8 | OADM TABLE

TOP B1 8.8 | OADM COLUMNS

TOP B1 8.8 | 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

328 COLUMNS | 1 INDEXES | B1 8.8 | OADM TABLE

TOPB1 8.8 | OADM COLUMNS

TOPB1 8.8 | OADM INDEXES

TOP B1 8.8 | OADM COLUMNS

TOP B1 8.8 | OADM INDEXES