SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.2AADM4541Administration - LogAdministration
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, free62, free63, free64, free65, OrderBlock, RoundMthd, AdrsFromWH, OrderParty, CrtfcateNO, ExpireDate, NINum, free66, free67, CfwAsnMust, CfwInDflt, CfwOutDflt, free68, free69, TaxRegime, 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, AltBOEPost, 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, EDocUDQCat, EOutputPth, EDelDocFrm, free22, free21, 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, free46, 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 FROM AADM

TOPB1 9.2  | AADM COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CompnyNameCompany Namenvarchar1000 Allow NULL? 
2CompnyAddrAddressnvarchar2540 Allow NULL? 
3CountryCountrynvarchar30 Allow NULL? 
4PrintHeadrPrinting Headernvarchar1000 Allow NULL? 
5Phone1Telephone Number 1nvarchar200 Allow NULL? 
6Phone2Telephone Number 2nvarchar200 Allow NULL? 
7FaxFax Numbernvarchar200 Allow NULL? 
8E_MailE-Mailnvarchar1000 Allow NULL? 
9ManagerManaging Directornvarchar1000 Allow NULL? 
10CompTypeChart of Accounts Templatechar10U Allow NULL? 
11MainCurncyLocal Currencynvarchar30 Allow NULL? 
12SysCurrncySystem Currencynvarchar30 Allow NULL? 
13DispPosDebCredit Balance with Minus Signchar10NN=No, Y=Yes Allow NULL? 
14DefLengthUStandard Unit of Lengthint602 Allow NULL? 
15DefWeightUDefault Weight UoMint602 Allow NULL? 
16DfltVendPMDefault Payt Method for Vendornvarchar150 Allow NULL? 
17DirectRateDirect/Indirect Ratechar10YN=No, Y=Yes Allow NULL? 
18MinAmnt347Minimum Amount for 347 Reportnum196 Allow NULL? 
19AutoITWSet Items - Warehouseschar10NN=No, Y=Yes Allow NULL? 
20BankCountrBank Countrynvarchar30 Allow NULL? 
21TaxIdNumFederal Tax IDnvarchar320 Allow NULL? 
22RevOfficeTax Officenvarchar1000 Allow NULL? 
23FreeZoneNoAdditional ID Numbernvarchar320 Allow NULL? 
24DdctFileNoDeduction File No.nvarchar500 Allow NULL? 
25VatChargeTax Collectionchar10YN=No, Y=Yes Allow NULL? 
26PayOutVatTax Definitionchar10NN=No, Y=Yes Allow NULL? 
27VatPrcntTax Ratenum196 Allow NULL? 
28DpsitPrcntAdvances on Corp. Income Tax %num196 Allow NULL? 
29IncomeTaxWithholding Tax %num196 Allow NULL? 
30VendorDdctWithholding Taxchar10NN=No, Y=Yes Allow NULL? 
31CustmrDdctCustomer's Deduction at Sourcechar10NN=No, Y=Yes Allow NULL? 
32DdctPercntWithholding Tax Deduction %num196 Allow NULL? 
33DdctExpireWithholding Tax Ded. in % - Exdate80
34DdctOfficeWithholding Tax Deduction - Ofnvarchar1000 Allow NULL? 
35EURepSqntlSequential Number of EU Salesint1100 Allow NULL? 
36BoxRptSeqBox Report Sequential Numberint1100 Allow NULL? 
37WTLiableWTax Liablechar10Y Allow NULL? 
38DfltCustPMDefault Payt Method for Cust.nvarchar150 Allow NULL? 
39AllowFuPosAllow Future Posting Datechar10NN=No, Y=Yes Allow NULL? 
40UseProdWipUse Product WIP Accountchar10YN=No, Y=Yes Allow NULL? 
41CurrPeriodCurrent Periodnvarchar100 Allow NULL? 
42XmlPathXML File Pathtext160
43DflBnkKeyDefault Bank Keyint110 Allow NULL? 
44BSInstledBank Statement Installedchar10NN=No, Y=Yes Allow NULL? 
45UseShpdGdUse Shipped Goods Accountchar10NN=No, Y=Yes Allow NULL? 
46UseExtRptUse Extended Reporting (OTRS)char10NN=No, Y=Yes Allow NULL? 
47ERpPerTypePeriod Type for Generationchar10MM=Month, P=Period, Q=Quarter, Y=Year Allow NULL? 
48DfSVatExmpSales Tax Group for Exemptnvarchar80 Allow NULL? 
49DfPVatExmpPurchases Tax Group for Exemptnvarchar80 Allow NULL? 
50Manager1General Managernvarchar1000 Allow NULL? 
51Manager1FGeneral Manager (For. Lang.)nvarchar1000 Allow NULL? 
52CCMaskMask Credit Card Numberchar10YN=No, Y=Yes Allow NULL? 
53ObligLimitCommitment Restrictionchar10NN=No, Y=Yes Allow NULL? 
54CreditLimtCredit Restrictionchar10NN=No, Y=Yes Allow NULL? 
55SalesLimitRestrict Saleschar10NN=No, Y=Yes Allow NULL? 
56DlnLimitRestrict Del. Notes (PO)char10NN=No, Y=Yes Allow NULL? 
57OrderLimitRestrict Orderschar10NN=No, Y=Yes Allow NULL? 
58AddDlnBlncConsider Deliv - Sales Revenuechar10NN=No, Y=Yes Allow NULL? 
59CreditDpstCredit Deposit Typechar10NN=Automatically, Y=Manually Allow NULL? 
60MultiLangMulti-Language Support Enabledchar10NN=No, Y=Yes Allow NULL? 
61DbVersDatabase Versionint110 Allow NULL? 
62ApplVersApplication Versionint110 Allow NULL? 
63DflWebSiteDefault for Web Sitetext160
64DflFTPSiteDefault for FTP Sitetext160
65UseTaxUse Taxchar10NN=No, Y=Yes Allow NULL? 
66RevisionPoSplit Purchase Orderchar10NN=No, Y=Yes Allow NULL? 
67ReindexRebuild Indexeschar10NN=No, Y=Yes Allow NULL? 
68DllPathPath to Validation DLLtext160
69TaxIdValidTax ID Mandatory Validationchar10NN=No, Y=Yes Allow NULL? 
70PchNameSplit Purchase Ordernvarchar200 Allow NULL? 
71RpcNameRebuild Indexesnvarchar200 Allow NULL? 
72PdnNameFree24nvarchar200 Allow NULL? 
73RpdNameAlt Name for Goods Returnnvarchar200 Allow NULL? 
74PorNameAlternative Name for Purchasenvarchar200 Allow NULL? 
75LevelWarnAlert Type for Whse Stockchar10WB=Block, D=No Message, W=Warning Only Allow NULL? 
76CrdCommUseSet Commission by Customerchar10NN=No, Y=Yes Allow NULL? 
77ItmCommUseSet Commission by Itemchar10NN=No, Y=Yes Allow NULL? 
78SlpCommUseAlternative Name for Purchasechar10NN=No, Y=Yes Allow NULL? 
79DfCustTermDefault Pmt Terms for Cust.int60-1 Allow NULL? 
80DfVendTermDefault Vendor Payment Termsint60-1 Allow NULL? 
81SaleProfitCalc. Gross Profit per Trans.char10YN=No, Y=Yes Allow NULL? 
82CostPrcLstSet Commission by Sales Emp.int60-1 Allow NULL? 
83GrossBySalGross Profit After Salechar10NN=No, Y=Yes Allow NULL? 
84TreePricOnDisplay Price for Parent Onlychar10NN=No, Y=Yes Allow NULL? 
85AddVatCalc. Gross Profit per Trans.char10YN=No, Y=Yes Allow NULL? 
86BaseFldBase Fieldchar10YN=No, Y=Yes Allow NULL? 
87ClosedQuotAllow Closed Sales Quotationschar10NN=No, Y=Yes Allow NULL? 
88UseCodeUser Conversion Codechar10NN=No, Y=Yes Allow NULL? 
89Code1CODE1nvarchar80 Allow NULL? 
90Code2CODE2nvarchar80 Allow NULL? 
91Code3CODE3nvarchar80 Allow NULL? 
92Code4CODE4nvarchar80 Allow NULL? 
93ColorCompany Colorint6010=Combined, 1=Classic, 2=Gray, 3=Violet, 4=Blue, 5=Green, 6=Yellow, 7=Orange, 8=Red, 9=Brown Allow NULL? 
94SumDecTotals Accuracyint602 Allow NULL? 
95QtyDecAccuracy of Quantitiesint603 Allow NULL? 
96PriceDecPrice Accuracyint602 Allow NULL? 
97RateDecRate Accuracyint604 Allow NULL? 
98PercentDecPercentage Rate Accuracyint604 Allow NULL? 
99MeasureDecMeasuring Accuracy for Unitsint603 Allow NULL? 
100DdAutoRunPrice Accuracychar10NN=No, Y=Yes Allow NULL? 
101DdNextDueRate Accuracydate80
102DdHourPercentage Rate Accuracyint60 Allow NULL? 
103CmpnyAddrFAddress in Foreign Languagenvarchar2540 Allow NULL? 
104DflTaxCodeDefault Tax Codenvarchar80 Allow NULL? 
105PrintHdrFLetter Header in Foreign Lang.nvarchar1000 Allow NULL? 
106Phone1FTel. No. 1 (Foreign Language)nvarchar200 Allow NULL? 
107Phone2FTel. No. 2 (Foreign Language)nvarchar200 Allow NULL? 
108FaxFFax Number (Foreign Lang.)nvarchar200 Allow NULL? 
109ManagerFLetter Header in Foreign Lang.nvarchar1000 Allow NULL? 
110TimeFormatTime Templatechar1000=24H, 1=12H Allow NULL? 
111CigCupCig and Cup Warningchar10NN=No, Y=Yes Allow NULL? 
112DateFormatDate Templatechar1000=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? 
113DateSepDate Separatorchar10/ Allow NULL? 
114FcNoBlncForeign Currency Checking Accountchar10BB=Block, D=No Message Allow NULL? 
115ChangeRdrChanged Existing Orderschar10YN=No, Y=Yes Allow NULL? 
116MultiCurrMulti-Currency Checkchar10BB=Block, D=No Message Allow NULL? 
117PickParDlvPartial Deliv. Pick and Packchar10NN=No, Y=Yes Allow NULL? 
118MaxTaxIncrMaximum Increase of Tax Amountnum196 Allow NULL? 
119ISRTypeISR Typeint6021=ISR, 2=BISR, 3=ISR+, 4=BISR+ Allow NULL? 
120MaxTaxDecrMaximum Decrease of Tax Amountnum196 Allow NULL? 
121RoundRmrkDisplay Rounding Remarkchar10YN=No, Y=Yes Allow NULL? 
122ISRBillerIISR Biller IDnvarchar90 Allow NULL? 
123UpdStampUpdate Stampint110 Allow NULL? 
124SysCNoEditBlock System Currency Editingchar10YN=No, Y=Yes Allow NULL? 
125RefDNoEditBlock Updating of Posting Datechar10YN=No, Y=Yes Allow NULL? 
126DfltWhsDefault Warehousenvarchar80 Allow NULL? 
127TaxDNoEditFreechar10YN=No, Y=Yes Allow NULL? 
128DfSVatItemTax Definitionnvarchar80 Allow NULL? 
129DfSVatServTax Definitionnvarchar80 Allow NULL? 
130DfPVatItemTax Group for Purchase Itemnvarchar80 Allow NULL? 
131DfPVatServTax Group for Service Purchasenvarchar80 Allow NULL? 
132DoBudgetCalculate Budgetchar10NN=No, Y=Yes Allow NULL? 
133CustIdNumCustomer IDnvarchar600 Allow NULL? 
134BgtBlockBlock Budgetchar10NB=Only Annual Alert, N=Monthly Alert Only, W=Block Allow NULL? 
135BgtWarningBudget Alertchar10AA=Annual Alert, M=Monthly Alert Allow NULL? 
136BdgtPORDocBlock Purchase Orderschar10YN=No, Y=Yes Allow NULL? 
137BdgtAcctngBlock Bookkeepingchar10NN=No, Y=Yes Allow NULL? 
138BdgtDfltDefault Budget Cost Assmt Mthdint1101 Allow NULL? 
139ContInvntPerpetual Inventory Managementchar10NN=No, Y=Yes Allow NULL? 
140InvntSystmPerpetual Inventory Systemchar10AA=Moving Average, F=FIFO, S=Standard Allow NULL? 
141ApplicIFRSApplication of IFRSchar10NN=No, Y=Yes Allow NULL? 
142StartYearStarting in Fiscal Yearint60 Allow NULL? 
143AccordingReport According Toint6011, 2, 3 Allow NULL? 
144MltpBrnchsEnable Multiple Brancheschar10NN=No, Y=Yes Allow NULL? 
145EnblSrvTaxEnable Service Taxchar10NN=No, Y=Yes Allow NULL? 
146DftRCNDefault for Retail Chainsint110-6 Allow NULL? 
147RoundVatRound Tax Amountschar10NN=No, Y=Yes Allow NULL? 
148BdgtPDNDocBlock Deliv. Notes for Purch.char10YN=No, Y=Yes Allow NULL? 
149IRSFileNoFile Number in Income Taxnvarchar90 Allow NULL? 
150DeferrTaxDeferred Taxchar10NN=No, Y=Yes Allow NULL? 
151DflIntrstMin. Default Interest Amountnum196 Allow NULL? 
152DfltSlpSales Employeeint60-1 Allow NULL? 
153DflCrCardDefault Credit Cardint60 Allow NULL? 
154DflBnkCodeDefault Bank No.nvarchar300 Allow NULL? 
155DflBnkAcctDefault Bank Accountnvarchar500 Allow NULL? 
156DflBranchDefault Branchnvarchar500 Allow NULL? 
157UsePaSysSales Employeechar10NN=No, Y=Yes Allow NULL? 
158Serv_UsrService Codenvarchar200 Allow NULL? 
159Serv_PassService Passwordnvarchar200 Allow NULL? 
160ParamPathParameter Folder Pathtext160
161ExcelPathExcel Folder Pathtext160
162TaxIdNum2Federal Tax ID 2nvarchar320 Allow NULL? 
163TaxIdNum3Federal Tax ID 3nvarchar320 Allow NULL? 
164DecSepDecimal Separatorchar10. Allow NULL? 
165ThousSepThousands Separatorchar10, Allow NULL? 
166CurOnRightDisplay Currency on the Rightchar10NN=No, Y=Yes Allow NULL? 
167WarnByWhsAlert by Warehousechar10NN=No, Y=Yes Allow NULL? 
168DflBnkAcKyDefault Bank Account No.int110 Allow NULL? 
169PriceSysPrice Systemchar10YN=Item, Y=Whse Allow NULL? 
170DftPVLPreferred Vendor Creditint110-1 Allow NULL? 
171useDdctTrcWTax Deduction - Hierarchychar10NN=No, Y=Yes Allow NULL? 
172useDocWrfDoc. Confirmationchar10NN=No, Y=Yes Allow NULL? 
173BtchStatusDefault for Batch Statuschar1000=Released, 1=Not Accessible, 2=Locked Allow NULL? 
174OrderBatchManage Orders in Batcheschar10YN=No, Y=Yes Allow NULL? 
175GLMethodSet G/L Account Bychar10WC=Item Group, L=Item Level, W=Warehouse Allow NULL? 
176SetSriUniqSet Unique Serial No.char10NN=No, Y=Yes Allow NULL? 
177SriUniqFldUnique Serial No.char1030=None, 2=Mfr Serial No., 3=Serial Number, 4=Lot Number Allow NULL? 
178MaxHistoryMax. Historyint11099 Allow NULL? 
179TaxRateDetTax Rate Determinationchar10PD=Document Date, P=Posting Date Allow NULL? 
180RefreshQtyRefresh in Whse Qty in DIchar10NN=No, Y=Yes Allow NULL? 
181StockNoBasStock No. Basechar10 Allow NULL? 
182MaxCntRowsAllowed Max Rows in Countingint11010000 Allow NULL? 
183CentPmtIncEnable Incom. Centralized Paytchar10NN=No, Y=Yes Allow NULL? 
184CentPmtOutEnable Outg. Centralized Paytchar10NN=No, Y=Yes Allow NULL? 
185ChCtrAPActChange Def. Recon. A/P Acctschar10NN=No, Y=Yes Allow NULL? 
186ChCtrARActChange Def. Recon. A/R Accountschar10NN=No, Y=Yes Allow NULL? 
187PACUsrNamePAC User Namenvarchar1000 Allow NULL? 
188PACPasswrdPAC Passwordnvarchar1000 Allow NULL? 
189CaredTypeBP Type Codenvarchar2001=01, 04=04, 15=15, 71=71, 73=73, 75=75 Allow NULL? 
190PBSNumberPBS Numbernvarchar80 Allow NULL? 
191PBSGroupNoPBS Group Numbernvarchar50 Allow NULL? 
192OrgNumberOrganization Numbernvarchar1000 Allow NULL? 
193ActSepAccount Segments Separatorchar10- Allow NULL? 
194DspBokpWinDisplay Bookkeeping Windowchar10NN=No, Y=Yes Allow NULL? 
195SHandleWTWithholding Taxchar10NN=No, Y=Yes Allow NULL? 
196SDfltWTDefault Withholding Tax Codenvarchar40 Allow NULL? 
197IncresGlAcG/L Increase Accountnvarchar150N=No, Y=Yes Allow NULL? 
198PHandleWTWithholding Taxchar10 Allow NULL? 
199PDfltWTDefault Withholding Tax Codenvarchar40 Allow NULL? 
200ExWTLiablWTax Liable Expensechar10NN=No, Y=Yes Allow NULL? 
201EDocSeqNumElectronic Document Sequence Numberint1101 Allow NULL? 
202AllowPostZAllow Inb. Pstng W/o a Pricechar10NN=No, Y=Yes Allow NULL? 
203PostDiffRDisplay in Red Greater Than %num19655=Variance Percentage Default Value Allow NULL? 
204EnableROEnable Release Only Snb in Pstchar10NN=No, Y=Yes Allow NULL? 
205UalLastDelLast Delete Date on Table OUALdate80
206UalKeepDayDays for keeping data on OUALint11030 Allow NULL? 
207NegAmountUse Negative Amountschar10YN=No, Y=Yes Allow NULL? 
208EnbDocOptEnable Document Optimizationchar10YN=No, Y=Yes Allow NULL? 
209HldCodeFree57nvarchar200 Allow NULL? 
210AlphaDocFree58char10NN=No, Y=Yes Allow NULL? 
211free62Free62char10 Allow NULL? 
212free63Free63char10 Allow NULL? 
213free64Free64char10 Allow NULL? 
214free65Free65char10 Allow NULL? 
215OrderBlockOrder Blockchar10 Allow NULL? 
216RoundMthdRounding Methodchar10N, N=No, Y=Yes Allow NULL? 
217AdrsFromWHFree63char10YN=No, Y=Yes Allow NULL? 
218OrderPartyOrdering Partynvarchar300 Allow NULL? 
219CrtfcateNOCertificate No.nvarchar200 Allow NULL? 
220ExpireDateExpiration Datedate80
221NINumNational Insurance No.nvarchar200 Allow NULL? 
222free66Free66char10 Allow NULL? 
223free67Free67char10 Allow NULL? 
224CfwAsnMustCFW Assignment Mandatory [Y/N]char10YN=No, Y=Yes Allow NULL? 
225CfwInDfltIncoming Payment Draft CF Itemint110 Allow NULL? 
226CfwOutDfltOutgoing Payment Dflt CFW Itemint110 Allow NULL? 
227free68Free68char10 Allow NULL? 
228free69Free69char10 Allow NULL? 
229TaxRegimeTax Regimenvarchar1000 Allow NULL? 
230AliasNameAlias Nametext160
231DftJPELineDefault Line For Local Areachar10 Allow NULL? 
232RdrConfrmdConfirmed Sales Orderchar10YN=No, Y=Yes Allow NULL? 
233PorConfrmdConfirmed Purchase Orderchar10YN=No, Y=Yes Allow NULL? 
234free71Free71char10 Allow NULL? 
235free72Free72char10 Allow NULL? 
236ChfAccChief Accountantint110 Allow NULL? 
237TaxMethodTaxation Methodchar100=On Shipment, 1=On Payment Allow NULL? 
238CEOCEOint110 Allow NULL? 
239free73Free73char10 Allow NULL? 
240free74Free74char10 Allow NULL? 
241RndToTDecRound VAT to Tenthschar10NN=No, Y=Yes Allow NULL? 
242SDfltITWTDefault Income Tax WTax Codenvarchar40 Allow NULL? 
243PDfltITWTDefault Income Tax WTax Codenvarchar40 Allow NULL? 
244free75Free75char10 Allow NULL? 
245free76Free76char10 Allow NULL? 
246DfActCurrDefault Account Currencychar10YN=Local Currency, Y=All Currencies Allow NULL? 
247defTaxVendDeferred Tax for Vendorschar10NN=No, Y=Yes Allow NULL? 
248free77Free77char10 Allow NULL? 
249free78Free78char10 Allow NULL? 
250free79Free79char10 Allow NULL? 
251free80Free80char10 Allow NULL? 
252free89Free89char10 Allow NULL? 
253AutoVatFree77char10NN=No, Y=Yes Allow NULL? 
254ConsumeFCTConsumer Forecastchar10YN=No, Y=Yes Allow NULL? 
255ConsumeMtdConsumption Methodchar10BB=Backward-Forward, F=Forward-Backward Allow NULL? 
256DaysBackDays Backwardint1107 Allow NULL? 
257DaysFwrdDays Forwardint1107 Allow NULL? 
258IsPAPrnPanama Printer Connectedchar10NN=No, Y=Yes Allow NULL? 
259free82Free82char10 Allow NULL? 
260TaxCodeCstDef. Tax Code (New Customers)nvarchar80 Allow NULL? 
261TaxCodeVndDef. Tax Code (New Vendors)nvarchar80 Allow NULL? 
262StateStatusnvarchar30 Allow NULL? 
263CharMonthNumber of Characters in Monthint110 Allow NULL? 
264free83Free83char10 Allow NULL? 
265free84Free84char10 Allow NULL? 
266free85Free85char10 Allow NULL? 
267free86Free86char10 Allow NULL? 
268AltBOEPostActive Alternative BOE Postchar10NN=No, Y=Yes Allow NULL? 
269LDiscTotalFree83char10YN=No, Y=Yes Allow NULL? 
270CodeCodeint1101 Allow NULL? 
271DfltDunTrmDefault Dunning Termsnvarchar250 Allow NULL? 
272ProfessionProfessionnvarchar500 Allow NULL? 
273free88Free88char10 Allow NULL? 
274DfltCDPDefault Closing Date Procedureint60-1 Allow NULL? 
275LogInstancLog Instanceint1100 Allow NULL? 
276UpdateDateUpdate Datedate80
277UserSignUser Signatureint60 Allow NULL? 
278DflBCACodeFree88nvarchar30 Allow NULL? 
279IgrAllCashIgnore All Cash Flow Relevantchar10YN=No, Y=Yes Allow NULL? 
280TaxPayerRfLog Instancenvarchar320 Allow NULL? 
281EmployerRfEmployer's Referencenvarchar320 Allow NULL? 
282PStatAutChPeriod Status Automatic Changechar10YN=No, Y=Yes Allow NULL? 
283PStatDelayPeriod Status Change Delayint601 Allow NULL? 
284RepBusTypeReporting Business Typenvarchar2021=Industrial, 2=Commercial, 3=Service Provider, 4=Contractor, 9=Other, N=No, Y=Yes Allow NULL? 
285RepBusOthrUnique Taxpayer Ref. (UTR)nvarchar320 Allow NULL? 
286BrachNumBranch Numbernvarchar40 Allow NULL? 
287BuisnesDscBusiness Descriptionnvarchar500N=No, Y=Yes Allow NULL? 
288ReptMethodReporting Methodnvarchar2021=Cash, 2=Cumulative, 3=US Dollar Regulation Allow NULL? 
289AcctMethodAccounting Methodnvarchar2021=Unilateral, 2=Double Allow NULL? 
290BookpitypeBookkeeping Typenvarchar2021=Manual, 2=Computerized, 3=Mixed Allow NULL? 
291ActSoftNamAccounting Software Namenvarchar1000 Allow NULL? 
292OpnClsRmrkCopy Opening/Closing Remarkschar10YN=No, Y=Yes Allow NULL? 
293TaxRndRuleDefault Tax Rounding Rulechar10C=Round Up, F=Round Down, R=Round Off Allow NULL? 
294NegTaxAllow Neg. Tax Amt in Returnschar10NN=No, Y=Yes Allow NULL? 
295ZeroLineAllow Zero Amt Row in JEchar10YN=No, Y=Yes Allow NULL? 
296GBOpenFileOpen GBI File After Exportchar10NN=No, Y=Yes Allow NULL? 
297GBIntfaceGBI enabledchar10NN=No, Y=Yes Allow NULL? 
298DfltCDPVDefault A/P Closing Date Proc.int60-1 Allow NULL? 
299OnHldPertCapital Goods On Hold Percent.num196 Allow NULL? 
300WTRndRuleDefault WTax Rounding Rulechar10C=Round Up, F=Round Down, R=Round Off Allow NULL? 
301GPPrcntSrvDefault GP % in Service Doc.num196 Allow NULL? 
302DspFrznBPDisplay Inactive BPs in Rptchar10YN=No, Y=Yes Allow NULL? 
303DspFrznITMDisplay Inactive Items in Rptchar10YN=No, Y=Yes Allow NULL? 
304WTAccumAmtAccum. Amount for WTax on APnum196 Allow NULL? 
305NewDPRCusHide Dpm Invoicechar10YN=No, Y=Yes Allow NULL? 
306ServNatureService Naturechar10D=Service Distributor, P=Service Provider Allow NULL? 
307PickLimitRestrict Pick Listchar10NN=No, Y=Yes Allow NULL? 
308WTAccAmtARAccum. Amount for WTax on ARnum196 Allow NULL? 
309UseProdPLUse Production P&L Accountschar10NN=Use Balance Sheet Only, Y=Use Balance Sheet and Profit and Loss Account Allow NULL? 
310QueryDecCalculated Query Accuracyint60 Allow NULL? 
311ExRtDefTaxExchange Rate on Deferred Taxchar10NN=No, Y=Yes Allow NULL? 
312BoletoPathBoleto Pathtext160
313UserSign2Updating Userint60 Allow NULL? 
314MMLastImpDLast Import File Datedate80
315CpyExhRateCopy Exchange Rate in Copy Tochar10NN=No, Y=Yes Allow NULL? 
316MapServiceMap Serviceint110-1 Allow NULL? 
317ODWFreqOpen Doc. Refresh Frequencyint11030 Allow NULL? 
318GTSOutPathGTS Outbound Pathtext160
319UseMltDimsUse Multidimensionschar10YN=No, Y=Yes Allow NULL? 
320MDStyleMultidimensions Display Stylechar10US=Separate, U=Unified Allow NULL? 
321GTSInPathGTS Inbound Pathtext160
322GTSSepGTS Separatornvarchar100 Allow NULL? 
323GTSDftChkGTS Default Checkerint110 Allow NULL? 
324GTSDftPyeGTS Default Payeeint110 Allow NULL? 
325GTSMaxAmtGTS Max. Amountnum196 Allow NULL? 
326RspOverAmtResponse to Exceeding Amountchar10BB=Block, S=Split Allow NULL? 
327DRBlock1Distribution Rule: Block 1char10NB=Block Posting, N=Without Warning Allow NULL? 
328DRBlock2Distribution Rule: Block 2char10NB=Block Posting, N=Without Warning Allow NULL? 
329DRBlock3Distribution Rule: Block 3char10NB=Block Posting, N=Without Warning Allow NULL? 
330DRBlock4Distribution Rule: Block 4char10NB=Block Posting, N=Without Warning Allow NULL? 
331DRBlock5Distribution Rule: Block 5char10NB=Block Posting, N=Without Warning Allow NULL? 
332PrjBlockProject Blockchar10NB=Block Posting, N=Without Warning Allow NULL? 
333SimReportSimulation Reportchar10NN=No, Y=Yes Allow NULL? 
334SnapShotIdSnapshot IDint1100 Allow NULL? 
335BackOrderPick and Pack Back Orderchar10NN=No, Y=Yes Allow NULL? 
336HQLocationHeadquarters Locationchar10BA=Azores, B, C=Continent, M=Madeira Allow NULL? 
337DigCrtPathDigital Certificate Pathtext160
338DflWTSDefault E-Tax Web Siteint60-1 Allow NULL? 
339EnbApprDIEnable DI Approval Procedurechar10NN=No, Y=Yes Allow NULL? 
340ChBPSerieVerify Non-manual BP Serieschar10NN=No, Y=Yes Allow NULL? 
341ChItmSerieVerify Non-manual ITM Serieschar10NN=No, Y=Yes Allow NULL? 
342ETRTaxOffiETR Tax Officeint1100 Allow NULL? 
343ETRTaxPersETR Tax Person Typechar10D=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? 
344EDocExpFrmElectronic Doc. Export Formatint110 Allow NULL? 
345PCN874RTypPCN874 Report Typechar1011=Registered Business, 6=Finan. Institution/Non-Profit Org. Allow NULL? 
346BTWDecProvBTW Declaration Providernvarchar30BPLBPL=BPL, INT=INT Allow NULL? 
347BTWDcPrvIDBTW Declaration Provider IDnvarchar1000 Allow NULL? 
348BTWNameBTW Namenvarchar1000 Allow NULL? 
349BTWStreetBTW Streetnvarchar1000 Allow NULL? 
350BTWCityBTW Citynvarchar1000 Allow NULL? 
351BTWZipBTW ZIP Codenvarchar300 Allow NULL? 
352BTWPhoneBTW Phone Numbernvarchar1000 Allow NULL? 
353BTWOBBTW OB IDint1101 Allow NULL? 
354BTWICPBTW ICL IDint1101 Allow NULL? 
355BTWOBFmtETR Telephone Numberint110 Allow NULL? 
356BTWICPFmtBTW ICP Mapping Formatint110 Allow NULL? 
357ETRPhoneNoETR Telephone Numbernvarchar200 Allow NULL? 
358EDTestModeElectronic Document Test Modechar10NN=No, Y=Yes Allow NULL? 
359EDocGenTypEl. Doc. Default Gen. Typechar10NG=Generate, L=Generate - Later, N=Not Relevant Allow NULL? 
360EDocRptFmtEl. Document Report Formatint110 Allow NULL? 
361InputMsgEl. Doc. Input Message Formatint110 Allow NULL? 
362EDProcessElectronic Document Processchar10IC=CFD, I=CFDI Allow NULL? 
363PACPACnvarchar200XML Allow NULL? 
364NotifAlertNotification by Alertchar10YN=No, Y=Yes Allow NULL? 
365NotifEmailNotification by E-Mailchar10NN=No, Y=Yes Allow NULL? 
366EDocUDQCatFree58int110 Allow NULL? 
367EOutputPthFree58text160
368EDelDocFrmElectronic Delivery Doc. Export Formatint110 Allow NULL? 
369free22Free22char10 Allow NULL? 
370free21Free21char10 Allow NULL? 
371ETRFaxNoETR Fax Numbernvarchar200 Allow NULL? 
372ETRMgrPhnETR Manager's Phone Numbernvarchar200 Allow NULL? 
373EDFormatElectronic Document Formatint110 Allow NULL? 
374AIDFormatAnnual Invoice Decl. Formatint110 Allow NULL? 
375CrtLineRFQCreate Online Quotationchar10NN=No, Y=Yes Allow NULL? 
376DflJETDefault JE Typenvarchar600 Allow NULL? 
377OnlyPaidInDisplay Only Paid Reserve Inv.char10NN=No, Y=Yes Allow NULL? 
378PDDEnabledPayments Due Date Enabledchar10N Allow NULL? 
379MaxDays4DDMax. Allowed Range for Due Dteint1100 Allow NULL? 
380AutoAddUoMAuto. Add UoMs to Itemschar10YN=Disabled, Y=Enabled Allow NULL? 
381AutoAddPkgAuto. Add Pkgs to Itemschar10YN=Disabled, Y=Enabled Allow NULL? 
382BinActivatHas Whse Bin Activated [Y/N]char10NN=No, Y=Yes Allow NULL? 
383IssuePriByIssue Primarily By SnB or Binint6000=Issue Primarily By Serial/Batch Numbers, 1=Issue Primarily By Bin Location Allow NULL? 
384InstFixAstEnable Fixed Assetschar10NN=No, Y=Yes Allow NULL? 
385DeprecCalcDepreciation Calculationchar10MD=Day, M=Month Allow NULL? 
386FixAstModFixed Asset Modechar10PP=Production, T=Transfer Allow NULL? 
387SopPathSolution Packager Exe. Pathtext160
388NewAcctDeNew G/L Account Determinationchar10NN=No, Y=Yes Allow NULL? 
389ClnZeroPlnClean Zero Price Row in ITM1char10NN=No, Y=Yes Allow NULL? 
390CmdDisBothDisplay Both Related Docs.char10YN=No, Y=Yes Allow NULL? 
391CnclMaxDayMax. No. of Days For Cancelint110 Allow NULL? 
392AttachPathAttachment Pathtext160
393ConfigPathConfiguration Pathtext160
394WrkshtPathWorksheet Pathtext160
395ICDifExPe1Single Count Variance (%)num19655=Single Counting Type - Default Variance Percentage Allow NULL? 
396ICDifExPe2Multiple Count Max. Variance (%)num19655=Multiple Counting Type - Default Max Variance Percentage Allow NULL? 
397ClsZoDiffRClose Rows Cont. Zero Diff.char10YN=No, Y=Yes Allow NULL? 
398ClsNoConfiClose Without Confirmationchar10NN=Disabled, Y=Enabled Allow NULL? 
399DTWPathDTW Exe. Pathtext160
400DfltByEmlDefault by E-Mailchar10EE=E-Mail, O=Outlook E-Mail Allow NULL? 
401free46Free46char10 Allow NULL? 
402INVOBPriceInventory OB Price Zerochar10NN=No, Y=Yes Allow NULL? 
403SplitFBShSplit Fix Balance Sheet [Y/N]char10N Allow NULL? 
404NotifyRqrNotify Requesterchar10N Allow NULL? 
405DeactivFADeactivate Asset When End Lifechar10NN=No, Y=Yes Allow NULL? 
406CshDctFACM for Payment Cash Discountchar10NN=No, Y=Yes Allow NULL? 
407SendAlertSend Internal Messagechar10N Allow NULL? 
408BdgtPRQDOCBlock Purchase Requestchar10NN=No, Y=Yes Allow NULL? 
409IsReuseNumEnable Document Number Reusechar10NN=No, Y=Yes Allow NULL? 
410IsReuseNFNEnable Nota Fiscal No. Reusechar10NN=No, Y=Yes Allow NULL? 
411SIPLReportShow Inactive PL in Reportschar10NN=No, Y=Yes Allow NULL? 
412SIPLDocShow Inactive PL in Docschar10NN=No, Y=Yes Allow NULL? 
413SIPLSetingShow Inactive PL in Settingschar10NN=No, Y=Yes Allow NULL? 
414PriceProcMOn Change UoM Conversion Ruleschar10UK=Keep All UoM Prices Unchanged, L=Keep Corresponding UoM Prices Unchanged, R=Remove UoM Prices, U=Update UoM Prices Accordingly Allow NULL? 
415ChkQtyINVEnable Check Quantity in INVchar10NN=No, Y=Yes Allow NULL? 
416EnbAdvATPEnable Advanced ATPchar10NN=No, Y=Yes Allow NULL? 
417EnblCaseEnable Case Sensitivitychar10NN=No, Y=Yes Allow NULL? 
418EnbSupplCEnable Supplementary Codechar10YN=No, Y=Yes Allow NULL? 
419MBAOnPerAllow Multiple BAs for Periodchar10NN=No, Y=Yes Allow NULL? 
420MBAOnAPBlock Multiple BAs for AP Doc.char10NN=No, Y=Yes Allow NULL? 
421MBAOnARBlock Multiple BAs for AR Doc.char10NN=No, Y=Yes Allow NULL? 
422ApyBsActSPApply Active Special Priceschar10NN=No, Y=Yes Allow NULL? 
423ApyBsActPVApply Active Period and Volumechar10NN=No, Y=Yes Allow NULL? 
424ApyBsActPLApply Active Price Listschar10NN=No, Y=Yes Allow NULL? 
425IsUpdNstdBUpdate Non-Std Based Priceschar10NN=No, Y=Yes Allow NULL? 
426SnBDfltSBSnB Default Eval. System SBchar10NN=No, Y=Yes Allow NULL? 
427OneBOneRecOne Batch One Receiptchar10NN=No, Y=Yes Allow NULL? 
428ReptCurrcyR6111 Report Currencynvarchar2011=Amounts in NIS, 2=Amounts in USD Allow NULL? 
429ICDifExPe3Multiple Count Vldt. Variance (%)num19655=Multiple Counting Type - Default Individual Counter Variance Percentage Allow NULL? 
430INCSingToVCopy Single Counter to Validt.char10YN=No, Y=Yes Allow NULL? 
431POrCByINCPosting or Create Date by INCchar10NN=Based on Creation Date, Y=Based on Posting Date Allow NULL? 
432EnbNegPymEnable Negative Paymentchar10NN=No, Y=Yes Allow NULL? 
433SirenNoSiren Numbernvarchar90 Allow NULL? 
434SEPACredIDSEPA Creditor IDnvarchar350 Allow NULL? 
435InstitCodeInstitution Codenvarchar2010=Secretaria da Receita Federal do Brasil, 20=Banco Central do Brasil (COSIF) Allow NULL? 
436ECDFormatECD File Formatint110 Allow NULL? 
437ApyDRinPECApply DR in Period End Closingchar10NN=No, Y=Yes Allow NULL? 
438ApyPRinPECApply PJ in Period End Closingchar10NN=No, Y=Yes Allow NULL? 
439TaxPyerStaTAX_PAYER_STATUSnvarchar20 Allow NULL? 
440MaxINVRptRAllowed Rows in INC Trans Rptint11085000 Allow NULL? 
441DftResWhsDefault Resource Warehousenvarchar80 Allow NULL? 
442AutoResWhsAuto Add All Warehouses to New Resourceschar10YN=No, Y=Yes Allow NULL? 
443InActRptInactive Reportschar10YN=No, Y=Yes Allow NULL? 
444InActMktInactive Marketing Documentschar10YN=No, Y=Yes Allow NULL? 
445InActPlnInactive Price Listschar10YN=No, Y=Yes Allow NULL? 
446StartFromStart Fromchar1011=Today, 2=Month Start, 3=Month End Allow NULL? 
447MonthsMonthsint601 Allow NULL? 
448DaysDaysint600 Allow NULL? 
449JEInFATranAlways Create JE in Transferchar10NN=No, Y=Yes Allow NULL? 
450TPLIdUI Template IDint60 Allow NULL? 
451TxtSrchText Searchchar10NN=No, Y=Yes Allow NULL? 
452ApyIBtoACTApply IBAN Vldt. to Bank Acctchar10NN=No, Y=Yes Allow NULL? 
453JeUnGroupJournal Entry Lines Ungroupingchar10N Allow NULL? 
454IgnoreAddeImpresiĆ³n de documento sin Addendachar10NN=No, Y=Yes Allow NULL? 

TOPB1 9.2  | AADM INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesCode, LogInstanc