	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

522 COLUMNS | 1 INDEXES | B1 9.3 | OADM TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	9.3	OADM	522	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, EnblSrvTax, 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, TaxRateDet, RefreshQty, StockNoBas, MaxCntRows, CentPmtInc, CentPmtOut, ChCtrAPAct, ChCtrARAct, PACUsrName, PACPasswrd, CaredType, PBSNumber, PBSGroupNo, OrgNumber, ActSep, DspBokpWin, SHandleWT, SDfltWT, IncresGlAc, PHandleWT, PDfltWT, ExWTLiabl, EDocSeqNum, AllowPostZ, PostDiffR, EnableRO, UalLastDel, UalKeepDay, NegAmount, EnbDocOpt, HldCode, AlphaDoc, EDocURL2, EnPriceMod, TaaSEnable, TaaSUser, OrderBlock, RoundMthd, AdrsFromWH, OrderParty, CrtfcateNO, ExpireDate, NINum, TaaSPass, TaaSAutURL, CfwAsnMust, CfwInDflt, CfwOutDflt, TaaSURL, TaaSSaleAc, TaxRegime, AliasName, DftJPELine, RdrConfrmd, PorConfrmd, TaaSPurcAc, AdvImagePr, ChfAcc, TaxMethod, CEO, WllPprDsp, WallPaper, RndToTDec, SDfltITWT, PDfltITWT, CheckFiles, DsplyRates, DfActCurr, defTaxVend, RcrFlag, RclFlag, ContactLog, ShowNewMsg, OpenCdt, AutoVat, ConsumeFCT, ConsumeMtd, DaysBack, DaysFwrd, IsPAPrn, ShowNewTsk, TaxCodeCst, TaxCodeVnd, State, CharMonth, free83, ScreenLock, OpenCredit, OpenDps, AltBOEPost, LDiscTotal, Code, DfltDunTrm, Profession, AlertPolFr, 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, EDocPass, EDProcess, PAC, NotifAlert, NotifEmail, EDocUDQCat, EOutputPth, EDelDocFrm, EDocPmnFmt, EDocURL1, ETRFaxNo, ETRMgrPhn, EDFormat, AIDFormat, CrtLineRFQ, DflJET, OnlyPaidIn, PDDEnabled, MaxDays4DD, AutoAddUoM, AutoAddPkg, BinActivat, IssuePriBy, InstFixAst, DeprecCalc, FixAstMod, SopPath, NewAcctDe, ClnZeroPln, CmdDisBoth, CnclMaxDay, AttachPath, ConfigPath, WrkshtPath, ICDifExPe1, ICDifExPe2, ClsZoDiffR, ClsNoConfi, DTWPath, DfltByEml, CreditDay1, INVOBPrice, SplitFBSh, NotifyRqr, DeactivFA, CshDctFA, SendAlert, BdgtPRQDOC, IsReuseNum, IsReuseNFN, SIPLReport, SIPLDoc, SIPLSeting, PriceProcM, ChkQtyINV, EnbAdvATP, EnblCase, EnbSupplC, MBAOnPer, MBAOnAP, MBAOnAR, ApyBsActSP, ApyBsActPV, ApyBsActPL, IsUpdNstdB, SnBDfltSB, OneBOneRec, ReptCurrcy, ICDifExPe3, INCSingToV, POrCByINC, EnbNegPym, SirenNo, SEPACredID, InstitCode, ECDFormat, ApyDRinPEC, ApyPRinPEC, TaxPyerSta, MaxINVRptR, DftResWhs, AutoResWhs, InActRpt, InActMkt, InActPln, StartFrom, Months, Days, JEInFATran, TPLId, TxtSrch, ApyIBtoACT, JeUnGroup, IgnoreAdde, EnterAsTab, MouseOnly, PrjMngmnt, ElectrDocs, DotAsSep, DoMngMth, AlwBPNOwn, EmptyPKL, ExcNInvItm, PayRefCalc, MultiSched, CloseWipV, onHldLimt, EnbApUpDoc, EnbApUpDft, EnPacking, BlockZeroQ, NegStoLv, EnUpdBAPln, BAOpPOR, BAOpPDN, BAOpAcctng, AssgnOBAAP, AssngOBAAR, ApyToNewBP, PrrConfrmd, RrrConfrmd, DflSeries, EnblLC, DflAcct, SmtpServer, SmtpPort, SmtpName, SmtpPasswd, SmtpEncode, SmtpAuthen, TlsEncryp, HtmlDirect, IncSubject, TenLevel, CreditDay2, CdtPrvDays, AuImpRates, ValidateBa, ManRemark, ManRmkType, ManRmkAlt, TermsPath, EDocWSFrm, DspBUoM, EDocSName, EDocSEMail, CpyRulToTx, BpNoLock, SearchUrl, EnableMTD, ClientID, ClntSecret, AuthURL, TokenURL, RedrctURL, Threshold, PublicComp, EnableEWB, TspEntry, TspLine, EwbGenType, VolumeLic FROM OADM

TOP B1 9.3 | 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	Current Period	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 Generation	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	CCMask	Mask Credit Card Number	char	1	0		Y	N=No, Y=Yes	Allow NULL?
53	ObligLimit	Commitment Restriction	char	1	0		N	N=No, Y=Yes	Allow NULL?
54	CreditLimt	Credit Restriction	char	1	0		N	N=No, Y=Yes	Allow NULL?
55	SalesLimit	Restrict Sales	char	1	0		N	N=No, Y=Yes	Allow NULL?
56	DlnLimit	Restrict Deliv. Notes (PO)	char	1	0		N	N=No, Y=Yes	Allow NULL?
57	OrderLimit	Restrict Orders	char	1	0		N	N=No, Y=Yes	Allow NULL?
58	AddDlnBlnc	Consider Del. Notes in Sales Restriction	char	1	0		N	N=No, Y=Yes	Allow NULL?
59	CreditDpst	Credit Deposit Type	char	1	0		N	N=Automatically, Y=Manually	Allow NULL?
60	MultiLang	Multi-Language Support Enabled	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
66	RevisionPo	Split PO	char	1	0		N	N=No, Y=Yes	Allow NULL?
67	Reindex	Rebuild Indexes	char	1	0		N	N=No, Y=Yes	Allow NULL?
68	DllPath	Path to Validation DLL	text	16	0
69	TaxIdValid	Tax ID Mandatory Validation	char	1	0		N	N=No, Y=Yes	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=Block, N=No Message, W=Warning Only	Allow NULL?
76	CrdCommUse	Set Commission by Customer	char	1	0		N	N=No, Y=Yes	Allow NULL?
77	ItmCommUse	Set Commission by Item	char	1	0		N	N=No, Y=Yes	Allow NULL?
78	SlpCommUse	Set Commission by Sales Empl.	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
84	TreePricOn	Display Price for Parent Only	char	1	0		N	N=No, Y=Yes	Allow NULL?
85	AddVat	Calc. Tax in Sales Quotation	char	1	0		Y	N=No, Y=Yes	Allow NULL?
86	BaseFld	Base Field	char	1	0		Y	N=No, Y=Yes	Allow NULL?
87	ClosedQuot	Allow Closed Sales Quotations	char	1	0		N	N=No, Y=Yes	Allow NULL?
88	UseCode	User Conversion Code	char	1	0		N	N=No, Y=Yes	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=Combined, 1=Classic, 2=Gray, 3=Violet, 4=Blue, 5=Green, 6=Yellow, 7=Orange, 8=Red, 9=Brown	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=No, Y=Yes	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=24H, 1=12H	Allow NULL?
111	CigCup	Cig and Cup Warning	char	1	0		N	N=No, Y=Yes	Allow NULL?
112	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?
113	DateSep	Date Separator	char	1	0		/		Allow NULL?
114	FcNoBlnc	FC Checking Account	char	1	0		B	B=Block, D=No Message	Allow NULL?
115	ChangeRdr	Changed Existing Orders	char	1	0		Y	N=No, Y=Yes	Allow NULL?
116	MultiCurr	All Currencies Check	char	1	0		B	B=Block, D=No Message	Allow NULL?
117	PickParDlv	Partial Deliv. Pick and Pack	char	1	0		N	N=No, Y=Yes	Allow NULL?
118	MaxTaxIncr	Maximum Increase of Tax Amount	num	19	6				Allow NULL?
119	ISRType	ISR Type	int	6	0		2	1=ISR, 2=BISR, 3=ISR+, 4=BISR+	Allow NULL?
120	MaxTaxDecr	Maximum Decrease of Tax Amount	num	19	6				Allow NULL?
121	RoundRmrk	Display Rounding Remark	char	1	0		Y	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
125	RefDNoEdit	Block Updating of Posting Date	char	1	0		Y	N=No, Y=Yes	Allow NULL?
126	DfltWhs	Default Warehouse	nvarchar	8	0				Allow NULL?
127	TaxDNoEdit	Free	char	1	0		Y	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
133	CustIdNum	Customer ID Number	nvarchar	6	0		0		Allow NULL?
134	BgtBlock	Block Budget	char	1	0		N	B=Only Annual Alert, N=Monthly Alert Only, W=Block	Allow NULL?
135	BgtWarning	Budget Alert	char	1	0		A	A=Annual Alert, M=Monthly Alert	Allow NULL?
136	BdgtPORDoc	Block Purchase Orders	char	1	0		Y	N=No, Y=Yes	Allow NULL?
137	BdgtAcctng	Block Bookkeeping	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
140	InvntSystm	Perpetual Inventory System	char	1	0		A	A=Moving Average, F=FIFO, S=Standard	Allow NULL?
141	ApplicIFRS	Application of IFRS	char	1	0		N	N=No, Y=Yes	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	Enable Multiple Branches	char	1	0		N	N=No, Y=Yes	Allow NULL?
145	EnblSrvTax	Enable Service Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
146	DftRCN	Default for Retail Chains	int	11	0		-6		Allow NULL?
147	RoundVat	Round Tax Amounts	char	1	0		N	N=No, Y=Yes	Allow NULL?
148	BdgtPDNDoc	Block Deliv. Notes for Purch.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
149	IRSFileNo	File Number in Income Tax	nvarchar	9	0				Allow NULL?
150	DeferrTax	Deferred Tax	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
167	WarnByWhs	Alert by Warehouse	char	1	0		N	N=No, Y=Yes	Allow NULL?
168	DflBnkAcKy	Default Bank Account Number	int	11	0	DSC1			Allow NULL?
169	PriceSys	Price System	char	1	0		Y	N=Item, Y=Whse	Allow NULL?
170	DftPVL	Preferred Vendor Credit	int	11	0		-1		Allow NULL?
171	useDdctTrc	WTax Deduction Hierarchy	char	1	0		N	N=No, Y=Yes	Allow NULL?
172	useDocWrf	Doc. Confirmation	char	1	0		N	N=No, Y=Yes	Allow NULL?
173	BtchStatus	Default for Batch Status	char	1	0		0	0=Released, 1=Not Accessible, 2=Locked	Allow NULL?
174	OrderBatch	Manage Orders in Batches	char	1	0		Y	N=No, Y=Yes	Allow NULL?
175	GLMethod	Set G/L Account By	char	1	0		W	C=Item Group, L=Item Level, W=Warehouse	Allow NULL?
176	SetSriUniq	Set Unique Serial No.	char	1	0		N	N=No, Y=Yes	Allow NULL?
177	SriUniqFld	Unique Serial No.	char	1	0		3	0=None, 2=Mfr Serial No., 3=Serial Number, 4=Lot Number	Allow NULL?
178	MaxHistory	Max. History	int	11	0		99		Allow NULL?
179	TaxRateDet	Tax Rate Determination	char	1	0		P	D=Document Date, P=Posting Date	Allow NULL?
180	RefreshQty	Refresh in Whse Qty in DI	char	1	0		N	N=No, Y=Yes	Allow NULL?
181	StockNoBas	Stock No. Base	char	1	0				Allow NULL?
182	MaxCntRows	Allowed Max Rows in Counting	int	11	0		10000		Allow NULL?
183	CentPmtInc	Enable Incom. Centralized Payt	char	1	0		N	N=No, Y=Yes	Allow NULL?
184	CentPmtOut	Enable Outg. Centralized Payt	char	1	0		N	N=No, Y=Yes	Allow NULL?
185	ChCtrAPAct	Change Def. Recon. A/P Accts	char	1	0		N	N=No, Y=Yes	Allow NULL?
186	ChCtrARAct	Change Def. Recon. A/R Accts	char	1	0		N	N=No, Y=Yes	Allow NULL?
187	PACUsrName	PAC User Name	nvarchar	100	0				Allow NULL?
188	PACPasswrd	PAC Password	nvarchar	100	0				Allow NULL?
189	CaredType	BP Type Code	nvarchar	2	0			01=01, 04=04, 15=15, 71=71, 73=73, 75=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=No, Y=Yes	Allow NULL?
195	SHandleWT	Withholding Tax	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
201	EDocSeqNum	Electronic Document Sequence Number	int	11	0		1		Allow NULL?
202	AllowPostZ	Allow Inb. Pstng W/o a Price	char	1	0		N	N=No, Y=Yes	Allow NULL?
203	PostDiffR	Display in Red Greater Than %	num	19	6		5	5=Variance Percentage Default Value	Allow NULL?
204	EnableRO	Enable Release Only Snb in Pst	char	1	0		N	N=No, Y=Yes	Allow NULL?
205	UalLastDel	Last Delete Date on Table OUAL	date	8	0
206	UalKeepDay	Days for keeping data on OUAL	int	11	0		30		Allow NULL?
207	NegAmount	Use Negative Amounts	char	1	0		Y	N=No, Y=Yes	Allow NULL?
208	EnbDocOpt	Enable Document Optimization	char	1	0		Y	N=No, Y=Yes	Allow NULL?
209	HldCode	Holiday Name	nvarchar	20	0	OHLD			Allow NULL?
210	AlphaDoc	Use Alphanum. ID for Document	char	1	0		N	N=No, Y=Yes	Allow NULL?
211	EDocURL2	El. Doc. Service URL 2	nvarchar	254	0				Allow NULL?
212	EnPriceMod	Enable Separate Price Mode	char	1	0		N	N=No, Y=Yes	Allow NULL?
213	TaaSEnable	Enable Tax as a Service	char	1	0		N	N=Do Not Use, S=Sales Only, Y=Sales and Purchase	Allow NULL?
214	TaaSUser	TaaS User Name	nvarchar	50	0				Allow NULL?
215	OrderBlock	Order Block	char	1	0				Allow NULL?
216	RoundMthd	Rounding Method	char	1	0		N	, N=No, Y=Yes	Allow NULL?
217	AdrsFromWH	Use Whse Address in A/P Docs.	char	1	0		Y	N=No, Y=Yes	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	TaaSPass	TaaS User Password	nvarchar	20	0				Allow NULL?
223	TaaSAutURL	TaaS oAuth URL	nvarchar	250	0				Allow NULL?
224	CfwAsnMust	CFW Assignment Mandatory [Y/N]	char	1	0		Y	N=No, Y=Yes	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	TaaSURL	TaaS Service URL	nvarchar	250	0				Allow NULL?
228	TaaSSaleAc	TaaS Default Sales Account	nvarchar	15	0				Allow NULL?
229	TaxRegime	Tax Regime	nvarchar	100	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=No, Y=Yes	Allow NULL?
233	PorConfrmd	Purchase Order Confirmed	char	1	0		Y	N=No, Y=Yes	Allow NULL?
234	TaaSPurcAc	TaaS Default Purchase Account	nvarchar	15	0				Allow NULL?
235	AdvImagePr	Extended Image Processing	char	1	0		N	N=Partial, O=Without, Y=Full	Allow NULL?
236	ChfAcc	Chief Accountant	int	11	0	OHEM			Allow NULL?
237	TaxMethod	Taxation Method	char	1	0			0=On Shipment, 1=On Payment	Allow NULL?
238	CEO	CEO	int	11	0	OHEM			Allow NULL?
239	WllPprDsp	Wallpaper Display	int	6	0		1	1=Centralized, 2=Full Screen, 3=Tile	Allow NULL?
240	WallPaper	Wallpaper	text	16	0
241	RndToTDec	Round VAT to Tenths	char	1	0		N	N=No, Y=Yes	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	CheckFiles	File Check	char	1	0		N	N=No, Y=Yes	Allow NULL?
245	DsplyRates	Display Rate Table on start up	char	1	0		N	N=No, Y=Yes	Allow NULL?
246	DfActCurr	Default Account Currency	char	1	0		Y	N=Local Currency, Y=All Currencies	Allow NULL?
247	defTaxVend	Deferred Tax for Vendors	char	1	0		N	N=No, Y=Yes	Allow NULL?
248	RcrFlag	Display Transactions Scheduled for Today	char	1	0		N	N=No, Y=Yes	Allow NULL?
249	RclFlag	Display Recurring Transactions	char	1	0		N	N=No, Y=Yes	Allow NULL?
250	ContactLog	Today's Activity Alert	char	1	0		N	N=No, Y=Yes	Allow NULL?
251	ShowNewMsg	Open Message on Arrival	char	1	0		Y	N=No, Y=Yes	Allow NULL?
252	OpenCdt	Open Window for Credit Reference	char	1	0		N	N=No, Y=Yes	Allow NULL?
253	AutoVat	Automatic VAT Row Creation In	char	1	0		N	N=No, Y=Yes	Allow NULL?
254	ConsumeFCT	Consumption Forecast	char	1	0		Y	N=No, Y=Yes	Allow NULL?
255	ConsumeMtd	Consumption Method	char	1	0		B	B=Backward-Forward, F=Forward-Backward	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=No, Y=Yes	Allow NULL?
259	ShowNewTsk	Open Worklist on Task Arrival	char	1	0		Y	N=No, Y=Yes	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	ScreenLock	Screen Lock Delay	int	6	0		30		Allow NULL?
266	OpenCredit	Open Postdated Credit Vouchers Window	char	1	0		N	D=By Date, N=No, Y=Always	Allow NULL?
267	OpenDps	Open Postdated Checks Window	char	1	0		N	N=No, Y=Yes	Allow NULL?
268	AltBOEPost	Active Alternative BOE Post	char	1	0		N	N=No, Y=Yes	Allow NULL?
269	LDiscTotal	Calc. Row Disc. from Tot. Pr.	char	1	0		Y	N=No, Y=Yes	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	AlertPolFr	Message Check Frequency	int	6	0		5		Allow NULL?
274	DfltCDP	Default Closing Date Procedure	int	6	0		-1		Allow NULL?
275	LogInstanc	Log Instance	int	11	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
283	PStatDelay	Period Status Change Delay	int	6	0		1		Allow NULL?
284	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?
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=No, Y=Yes	Allow NULL?
288	ReptMethod	Reporting Method	nvarchar	2	0		2	1=Cash, 2=Cumulative, 3=US Dollar Regulation	Allow NULL?
289	AcctMethod	Accounting Method	nvarchar	2	0		2	1=Unilateral, 2=Double	Allow NULL?
290	Bookpitype	Bookkeeping Type	nvarchar	2	0		2	1=Manual, 2=Computerized, 3=Mixed	Allow NULL?
291	ActSoftNam	Accounting Software Name	nvarchar	100	0				Allow NULL?
292	OpnClsRmrk	Copy Opening/Closing Remarks	char	1	0		Y	N=No, Y=Yes	Allow NULL?
293	TaxRndRule	Default Tax Rounding Rule	char	1	0			C=Round Up, F=Round Down, R=Round Off	Allow NULL?
294	NegTax	Allow Negative Tax Amt in Rpt	char	1	0		N	N=No, Y=Yes	Allow NULL?
295	ZeroLine	Allow Zero Row in JE	char	1	0		Y	N=No, Y=Yes	Allow NULL?
296	GBOpenFile	Open GBI File After Export	char	1	0		N	N=No, Y=Yes	Allow NULL?
297	GBIntface	GB Data Interface Enable	char	1	0		N	N=No, Y=Yes	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=Round Up, F=Round Down, R=Round Off	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=No, Y=Yes	Allow NULL?
303	DspFrznITM	Display Inactive Items in Rpt	char	1	0		Y	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
306	ServNature	Service Nature	char	1	0			D=Service Distributor, P=Service Provider	Allow NULL?
307	PickLimit	Restrict Pick List	char	1	0		N	N=No, Y=Yes	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=Use Balance Sheet Only, Y=Use Balance Sheet and Profit and Loss Account	Allow NULL?
310	QueryDec	Calculated Query Accuracy	int	6	0				Allow NULL?
311	ExRtDefTax	Exchange Rate on Deferred Tax	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
320	MDStyle	Multidimensions Display Style	char	1	0		U	S=Separate, U=Unified	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=Block, S=Split	Allow NULL?
327	DRBlock1	Distribution Rule: Block 1	char	1	0		N	B=Block Posting, N=Without Warning	Allow NULL?
328	DRBlock2	Distribution Rule: Block 2	char	1	0		N	B=Block Posting, N=Without Warning	Allow NULL?
329	DRBlock3	Distribution Rule: Block 3	char	1	0		N	B=Block Posting, N=Without Warning	Allow NULL?
330	DRBlock4	Distribution Rule: Block 4	char	1	0		N	B=Block Posting, N=Without Warning	Allow NULL?
331	DRBlock5	Distribution Rule: Block 5	char	1	0		N	B=Block Posting, N=Without Warning	Allow NULL?
332	PrjBlock	Project Block	char	1	0		N	B=Block Posting, N=Without Warning	Allow NULL?
333	SimReport	Simulation Report	char	1	0		N	N=No, Y=Yes	Allow NULL?
334	SnapShotId	Snapshot ID	int	11	0		0		Allow NULL?
335	BackOrder	Pick and Pack Back Order	char	1	0		N	N=No, Y=Yes	Allow NULL?
336	HQLocation	Headquarters Location	char	1	0		B	A=Azores, B, C=Continent, M=Madeira	Allow NULL?
337	DigCrtPath	Digital Certificate Path	text	16	0
338	DflWTS	Default E-Tax Web Site	int	6	0		-1		Allow NULL?
339	EnbApprDI	Enable DI Approval Process	char	1	0		N	N=No, Y=Yes	Allow NULL?
340	ChBPSerie	Verify Non-manual BP Series	char	1	0		N	N=No, Y=Yes	Allow NULL?
341	ChItmSerie	Verify Non-manual ITM Series	char	1	0		N	N=No, Y=Yes	Allow NULL?
342	ETRTaxOffi	ETR Tax Office	int	11	0	OTOF	0		Allow NULL?
343	ETRTaxPers	ETR Tax Person Type	char	1	0			D=Taxable person according to section 3, subsection 5, when applying a tax deduction, I=Tax agent when importing goods according to section 69, R=Another Person Registered for Tax, S=Person required to submit a tax declaration/return according to section 78, paragraphs 3, 4, and 9, T=VAT Payer	Allow NULL?
344	EDocExpFrm	Electronic Doc. Export Format	int	11	0				Allow NULL?
345	PCN874RTyp	PCN874 Report Type	char	1	0		1	1=Registered Business, 6=Finan. Institution/Non-Profit Org.	Allow NULL?
346	BTWDecProv	BTW Declaration Provider	nvarchar	3	0		BPL	BPL=BPL, INT=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=No, Y=Yes	Allow NULL?
359	EDocGenTyp	El. Doc. Default Gen. Type	char	1	0		N	G=Generate, L=Generate - Later, N=Not Relevant	Allow NULL?
360	EDocRptFmt	El. Document Report Format	int	11	0				Allow NULL?
361	EDocPass	El. Doc. Service Password	nvarchar	100	0				Allow NULL?
362	EDProcess	Electronic Document Process	char	1	0		I	C=CFD, I=CFDI	Allow NULL?
363	PAC	PAC	nvarchar	20	0	OPAC	XML		Allow NULL?
364	NotifAlert	Notification by Alert	char	1	0		Y	N=No, Y=Yes	Allow NULL?
365	NotifEmail	Notification by E-Mail	char	1	0		N	N=No, Y=Yes	Allow NULL?
366	EDocUDQCat	Electronic Document UDQ Category	int	11	0				Allow NULL?
367	EOutputPth	Ouput Directory for Electronic Documents	text	16	0
368	EDelDocFrm	Electronic Delivery Doc. Export Format	int	11	0				Allow NULL?
369	EDocPmnFmt	El. Doc. Payment Format	int	11	0				Allow NULL?
370	EDocURL1	El. Doc. Service URL 1	nvarchar	254	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
378	PDDEnabled	Payments Due Date Enabled	char	1	0		N		Allow NULL?
379	MaxDays4DD	Max. Allowed Range for Due Dte	int	11	0		0		Allow NULL?
380	AutoAddUoM	Auto. Add UoMs to Items	char	1	0		Y	N=Disabled, Y=Enabled	Allow NULL?
381	AutoAddPkg	Auto. Add Pkgs to Items	char	1	0		Y	N=Disabled, Y=Enabled	Allow NULL?
382	BinActivat	Has Whse Bin Activated [Y/N]	char	1	0		N	N=No, Y=Yes	Allow NULL?
383	IssuePriBy	Issue Primarily By SnB or Bin	int	6	0		0	0=Issue Primarily By Serial/Batch Numbers, 1=Issue Primarily By Bin Location	Allow NULL?
384	InstFixAst	Enable Fixed Assets	char	1	0		N	N=No, Y=Yes	Allow NULL?
385	DeprecCalc	Depreciation Calculation	char	1	0		M	D=Day, M=Month	Allow NULL?
386	FixAstMod	Fixed Asset Mode	char	1	0		P	P=Production, T=Transfer	Allow NULL?
387	SopPath	Solution Packager Exe. Path	text	16	0
388	NewAcctDe	New G/L Account Determination	char	1	0		N	N=No, Y=Yes	Allow NULL?
389	ClnZeroPln	Clean Zero Price Row in ITM1	char	1	0		N	N=No, Y=Yes	Allow NULL?
390	CmdDisBoth	Display Both Related Docs.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
391	CnclMaxDay	Max. No. of Days For Cancel	int	11	0				Allow NULL?
392	AttachPath	Attachments Path	text	16	0
393	ConfigPath	Configuration Path	text	16	0
394	WrkshtPath	Worksheet Path	text	16	0
395	ICDifExPe1	Single Count Variance (%)	num	19	6		5	5=Single Counting Type - Default Variance Percentage	Allow NULL?
396	ICDifExPe2	Multiple Count Max. Variance (%)	num	19	6		5	5=Multiple Counting Type - Default Max Variance Percentage	Allow NULL?
397	ClsZoDiffR	Close Rows Cont. Zero Diff.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
398	ClsNoConfi	Close Without Confirmation	char	1	0		N	N=Disabled, Y=Enabled	Allow NULL?
399	DTWPath	DTW Exe. Path	text	16	0
400	DfltByEml	Default by E-Mail	char	1	0		E	E=E-Mail, O=Outlook E-Mail	Allow NULL?
401	CreditDay1	Credit Handling Day 1	int	6	0		1		Allow NULL?
402	INVOBPrice	Inventory OB Price Zero	char	1	0		N	N=No, Y=Yes	Allow NULL?
403	SplitFBSh	Split Asset Balance Sheet Acct	char	1	0		N		Allow NULL?
404	NotifyRqr	Notify Requester	char	1	0		N		Allow NULL?
405	DeactivFA	Deactivate Asset When End Life	char	1	0		N	N=No, Y=Yes	Allow NULL?
406	CshDctFA	CM for Payment Cash Discount	char	1	0		N	N=No, Y=Yes	Allow NULL?
407	SendAlert	Send Internal Message	char	1	0		N		Allow NULL?
408	BdgtPRQDOC	Block Purchase Request	char	1	0		N	N=No, Y=Yes	Allow NULL?
409	IsReuseNum	Enable Document Number Reuse	char	1	0		N	N=No, Y=Yes	Allow NULL?
410	IsReuseNFN	Enable Nota Fiscal No. Reuse	char	1	0		N	N=No, Y=Yes	Allow NULL?
411	SIPLReport	Show Inactive PL in Reports	char	1	0		N	N=No, Y=Yes	Allow NULL?
412	SIPLDoc	Show Inactive PL in Docs	char	1	0		N	N=No, Y=Yes	Allow NULL?
413	SIPLSeting	Show Inactive PL in Settings	char	1	0		N	N=No, Y=Yes	Allow NULL?
414	PriceProcM	On Change UoM Conversion Rules	char	1	0		U	K=Keep All UoM Prices Unchanged, L=Keep Corresponding UoM Prices Unchanged, R=Remove UoM Prices, U=Update UoM Prices Accordingly	Allow NULL?
415	ChkQtyINV	Enable Check Quantity in INV	char	1	0		N	N=No, Y=Yes	Allow NULL?
416	EnbAdvATP	Enable Advanced ATP	char	1	0		N	N=No, Y=Yes	Allow NULL?
417	EnblCase	Enable Case Sensitivity	char	1	0		N	N=No, Y=Yes	Allow NULL?
418	EnbSupplC	Enable Supplementary Code	char	1	0		Y	N=No, Y=Yes	Allow NULL?
419	MBAOnPer	Allow Multiple BAs for Period	char	1	0		N	N=No, Y=Yes	Allow NULL?
420	MBAOnAP	Block Multiple BAs for AP Doc.	char	1	0		N	N=No, Y=Yes	Allow NULL?
421	MBAOnAR	Block Multiple BAs for AR Doc.	char	1	0		N	N=No, Y=Yes	Allow NULL?
422	ApyBsActSP	Apply Active Special Prices	char	1	0		N	N=No, Y=Yes	Allow NULL?
423	ApyBsActPV	Apply Active Period and Volume	char	1	0		N	N=No, Y=Yes	Allow NULL?
424	ApyBsActPL	Apply Active Price Lists	char	1	0		N	N=No, Y=Yes	Allow NULL?
425	IsUpdNstdB	Update Non-Std Based Prices	char	1	0		N	N=No, Y=Yes	Allow NULL?
426	SnBDfltSB	SnB Default Eval. System SB	char	1	0		N	N=No, Y=Yes	Allow NULL?
427	OneBOneRec	One Batch One Receipt	char	1	0		N	N=No, Y=Yes	Allow NULL?
428	ReptCurrcy	R6111 Report Currency	nvarchar	2	0		1	1=Amounts in NIS, 2=Amounts in USD	Allow NULL?
429	ICDifExPe3	Multiple Count Vldt. Variance (%)	num	19	6		5	5=Multiple Counting Type - Default Individual Counter Variance Percentage	Allow NULL?
430	INCSingToV	Copy Single Counter to Validt.	char	1	0		Y	N=No, Y=Yes	Allow NULL?
431	POrCByINC	Posting or Create Date by INC	char	1	0		N	N=Based on Creation Date, Y=Based on Posting Date	Allow NULL?
432	EnbNegPym	Enable Negative Payment	char	1	0		N	N=No, Y=Yes	Allow NULL?
433	SirenNo	Siren Number	nvarchar	9	0				Allow NULL?
434	SEPACredID	SEPA Creditor ID	nvarchar	35	0				Allow NULL?
435	InstitCode	Institution Code	nvarchar	2	0			10=Secretaria da Receita Federal do Brasil, 20=Banco Central do Brasil (COSIF)	Allow NULL?
436	ECDFormat	ECD File Format	int	11	0	OLLF			Allow NULL?
437	ApyDRinPEC	Apply DR in Period End Closing	char	1	0		N	N=No, Y=Yes	Allow NULL?
438	ApyPRinPEC	Apply PJ in Period End Closing	char	1	0		N	N=No, Y=Yes	Allow NULL?
439	TaxPyerSta	TAX_PAYER_STATUS	nvarchar	2	0				Allow NULL?
440	MaxINVRptR	Allowed Rows in INC Trans Rpt	int	11	0		85000		Allow NULL?
441	DftResWhs	Default Resource Warehouse	nvarchar	8	0				Allow NULL?
442	AutoResWhs	Auto Add All Warehouses to New Resources	char	1	0		Y	N=No, Y=Yes	Allow NULL?
443	InActRpt	Inactive Reports	char	1	0		Y	N=No, Y=Yes	Allow NULL?
444	InActMkt	Inactive Marketing Documents	char	1	0		Y	N=No, Y=Yes	Allow NULL?
445	InActPln	Inactive Price Lists	char	1	0		Y	N=No, Y=Yes	Allow NULL?
446	StartFrom	Start From	char	1	0		1	1=Today, 2=Month Start, 3=Month End	Allow NULL?
447	Months	Months	int	6	0		1		Allow NULL?
448	Days	Days	int	6	0		0		Allow NULL?
449	JEInFATran	Always Create JE in Transfer	char	1	0		N	N=No, Y=Yes	Allow NULL?
450	TPLId	UI Template ID	int	6	0	UICU			Allow NULL?
451	TxtSrch	Text Search	char	1	0		N	N=No, Y=Yes	Allow NULL?
452	ApyIBtoACT	Apply IBAN Vldt. to Bank Acct	char	1	0		N	N=No, Y=Yes	Allow NULL?
453	JeUnGroup	Journal Entry Split Lines	char	1	0		N	N=No Split, S=Split, Y=Split in Journal Entry Preview Only	Allow NULL?
454	IgnoreAdde	Print Document Without Addenda	char	1	0		N	N=No, Y=Yes	Allow NULL?
455	EnterAsTab	Use Numeric Keypad ENTER Key as TAB Key	char	1	0		N	N=No, Y=Yes	Allow NULL?
456	MouseOnly	Document Operation by Mouse Only	char	1	0		N	N=No, Y=Yes	Allow NULL?
457	PrjMngmnt	Enable Project Management	char	1	0		N	N=No, Y	Allow NULL?
458	ElectrDocs	Enable Electronic Documents	char	1	0		N	N=No, Y=Yes	Allow NULL?
459	DotAsSep	Use Dot Key As Separator	char	1	0		N	N=No, Y=Yes	Allow NULL?
460	DoMngMth	Data Ownership Management Method	nvarchar	11	0		D	A=Business Partner and Document, B=Business Partner Only, D=Document Only, R=Branch	Allow NULL?
461	AlwBPNOwn	Allow BP Without an Owner	char	1	0		N	N=No, Y=Yes	Allow NULL?
462	EmptyPKL	Create an Empty Pick List	char	1	0		N	N=No, Y=Yes	Allow NULL?
463	ExcNInvItm	Exclude Non-Inventory Items	char	1	0		N	N=No, Y=Yes	Allow NULL?
464	PayRefCalc	Payment Reference Calculation	int	6	0		1	1=Payment Reference, 2=Global Structured Creditor Reference	Allow NULL?
465	MultiSched	Multiple scheduling on Service Call	char	1	0		N	N=No, Y=Yes	Allow NULL?
466	CloseWipV	Close to Parent Item WIP Variance Account	char	1	0		N	N=No, Y=Yes	Allow NULL?
467	onHldLimt	Capital Goods on Hold Limit	num	19	6				Allow NULL?
468	EnbApUpDoc	Enable Updating Doc Added/Updated via Approval Process	char	1	0		N	N=No, Y=Yes	Allow NULL?
469	EnbApUpDft	Enable Updating Draft in Status Pending/Approved	char	1	0		N	N=No, Y=Yes	Allow NULL?
470	EnPacking	Display Packing Drawer	char	1	0		N	N=No, Y=Yes	Allow NULL?
471	BlockZeroQ	Block Stock Negative Quantity	char	1	0		Y	N=No, Y=Yes	Allow NULL?
472	NegStoLv	Negative Stock: Check Level	char	1	0		I	C=Company, I=Item Setting, W=Warehouse	Allow NULL?
473	EnUpdBAPln	Enable Update BA Plan	char	1	0		N	N=No, Y=Yes	Allow NULL?
474	BAOpPOR	BA Option for Purchase Orders	char	1	0		N	B=Block Posting, N=Without Warning, W=Warning	Allow NULL?
475	BAOpPDN	BA Option for GRPOs	char	1	0		N	B=Block Posting, N=Without Warning, W=Warning	Allow NULL?
476	BAOpAcctng	BA Option for Accounting	char	1	0		N	B=Block Posting, N=Without Warning, W=Warning	Allow NULL?
477	AssgnOBAAP	Assign only valid BA for AP	char	1	0		N	N=No, Y=Yes	Allow NULL?
478	AssngOBAAR	Assign only valid BA for AR	char	1	0		N	N=No, Y=Yes	Allow NULL?
479	ApyToNewBP	Apply Change Only to New BP	char	1	0		N	N=No, Y=Yes	Allow NULL?
480	PrrConfrmd	Goods Return Request Confirmed	char	1	0		Y	N=No, Y=Yes	Allow NULL?
481	RrrConfrmd	Return Request Confirmed	char	1	0		Y	N=No, Y=Yes	Allow NULL?
482	DflSeries	Default Series	int	11	0	NNM1			Allow NULL?
483	EnblLC	Enable Live Collaboration	char	1	0		N	N=No, Y=Yes	Allow NULL?
484	DflAcct	Default Account	nvarchar	210	0	OACT			Allow NULL?
485	SmtpServer	SMTP Server	nvarchar	100	0				Allow NULL?
486	SmtpPort	SMTP Port	nvarchar	10	0				Allow NULL?
487	SmtpName	SMTP User Name	nvarchar	100	0				Allow NULL?
488	SmtpPasswd	SMTP Password	nvarchar	100	0				Allow NULL?
489	SmtpEncode	SMTP Encoding	nvarchar	100	0	OLNG	3	3=English	Allow NULL?
490	SmtpAuthen	SMTP Authentication	nvarchar	100	0		N	I=Integrated Windows Authentication, L=Login Authentication, N=No Authentication	Allow NULL?
491	TlsEncryp	TLS Encryption	char	1	0		N		Allow NULL?
492	HtmlDirect	HTML Direction Right to Left	char	1	0		N		Allow NULL?
493	IncSubject	Include Subject in Msg Body	char	1	0		N		Allow NULL?
494	TenLevel	Tenant Level Configuration	char	1	0		N		Allow NULL?
495	CreditDay2	Credit Handling Day 2	int	6	0		15		Allow NULL?
496	CdtPrvDays	Vouchers from Last Days	int	11	0		1		Allow NULL?
497	AuImpRates	Import Currency Rates Automatically	char	1	0		N	N=No, Y=Yes	Allow NULL?
498	ValidateBa	Validate Account Balance	char	1	0		N	B=Block Posting, N=Without Warning, W=Warning Only	Allow NULL?
499	ManRemark	Mandatory Remark	char	1	0		N	N=No, Y=Yes	Allow NULL?
500	ManRmkType	Mandatory Remark Type	char	1	0		H	B=Rows and Header, H=Header Only, R=Rows Only	Allow NULL?
501	ManRmkAlt	Mandatory Remark Alert Type	char	1	0		B	B=Block Posting, W=Warning Only	Allow NULL?
502	TermsPath	Terms and Conditions Path	text	16	0
503	EDocWSFrm	El. Doc. WS Format	int	11	0				Allow NULL?
504	DspBUoM	Display Batch Quantities By	char	1	0		0	0=Document Row UoM, 1=Inventory UoM	Allow NULL?
505	EDocSName	El. Doc. Sender Name	nvarchar	200	0				Allow NULL?
506	EDocSEMail	El. Doc. Sender E-Mail	nvarchar	200	0				Allow NULL?
507	CpyRulToTx	Copy Distribution Rules to Tax Related Rows	char	1	0		N	N=No, Y=Yes	Allow NULL?
508	BpNoLock	Business Partner Without Lock	char	1	0		N	N=No, Y=Yes	Allow NULL?
509	SearchUrl	Search Engine URL	nvarchar	254	0		http://www.google.com/search?q={SapName} {FormName} {MessageString} site:sap.com		Allow NULL?
510	EnableMTD	Enable Making Tax Digital	char	1	0		N	N=No, Y=Yes	Allow NULL?
511	ClientID	Making Tax Digital Client ID	nvarchar	100	0				Allow NULL?
512	ClntSecret	Making Tax Digital Client Secret	nvarchar	100	0				Allow NULL?
513	AuthURL	Making Tax Digital Authorized URL	nvarchar	254	0				Allow NULL?
514	TokenURL	Making Tax Digital Token URL	nvarchar	254	0				Allow NULL?
515	RedrctURL	Making Tax Digital Redirect URL	nvarchar	254	0				Allow NULL?
516	Threshold	Threshold for Customer Accounting	num	19	6				Allow NULL?
517	PublicComp	Public Company	char	1	0		N	N=No, Y=Yes	Allow NULL?
518	EnableEWB	E-Way Bill Auto-Generation	char	1	0		N	N=No, Y=Yes	Allow NULL?
519	TspEntry	Default Transporter	int	11	0	OTSP			Allow NULL?
520	TspLine	Default Transportation Line	int	11	0				Allow NULL?
521	EwbGenType	Default E-Way Bill Generation Type	char	1	0		N	G=Generate, L=Generate - Later, N=Not Relevant	Allow NULL?
522	VolumeLic	Use Volume Based Licensing	char	1	0		N	N=No, Y=Yes	Allow NULL?

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

522 COLUMNS | 1 INDEXES | B1 9.3 | OADM TABLE

TOP B1 9.3 | OADM COLUMNS

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

522 COLUMNS | 1 INDEXES | B1 9.3 | OADM TABLE

TOPB1 9.3 | OADM COLUMNS

TOPB1 9.3 | OADM INDEXES

TOP B1 9.3 | OADM COLUMNS

TOP B1 9.3 | OADM INDEXES