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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
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 Signchar10NY=Yes, N=No Allow NULL? 
14DefLengthUStandard Unit of Lengthint602 Allow NULL? 
15DefWeightUDefault Weight UoMint602 Allow NULL? 
16DfltVendPMDefault Payt Method for Vendornvarchar150 Allow NULL? 
17DirectRateDirect/Indirect Ratechar10YY=Yes, N=No Allow NULL? 
18MinAmnt347Minimum Amount for 347 Reportnum196 Allow NULL? 
19AutoITWSet Items - Warehouseschar10NY=Yes, N=No 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 Collectionchar10YY=Yes, N=No Allow NULL? 
26PayOutVatTax Definitionchar10NY=Yes, N=No Allow NULL? 
27VatPrcntTax Ratenum196 Allow NULL? 
28DpsitPrcntAdvances on Corp. Income Tax %num196 Allow NULL? 
29IncomeTaxWithholding Tax %num196 Allow NULL? 
30VendorDdctWithholding Taxchar10NY=Yes, N=No Allow NULL? 
31CustmrDdctCustomer's Deduction at Sourcechar10NY=Yes, N=No 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 Datechar10NY=Yes, N=No Allow NULL? 
40UseProdWipUse Product WIP Accountchar10YY=Yes, N=No Allow NULL? 
41CurrPeriodCurrent Periodnvarchar100 Allow NULL? 
42XmlPathXML File Pathtext160
43DflBnkKeyDefault Bank Keyint110 Allow NULL? 
44BSInstledBank Statement Installedchar10NY=Yes, N=No Allow NULL? 
45UseShpdGdUse Shipped Goods Accountchar10NY=Yes, N=No Allow NULL? 
46UseExtRptUse Extended Reporting (OTRS)char10NY=Yes, N=No Allow NULL? 
47ERpPerTypePeriod Type for Generationchar10MY=Year, Q=Quarter, M=Month, P=Period 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 Numberchar10YY=Yes, N=No Allow NULL? 
53ObligLimitCommitment Restrictionchar10NY=Yes, N=No Allow NULL? 
54CreditLimtCredit Restrictionchar10NY=Yes, N=No Allow NULL? 
55SalesLimitRestrict Saleschar10NY=Yes, N=No Allow NULL? 
56DlnLimitRestrict Del. Notes (PO)char10NY=Yes, N=No Allow NULL? 
57OrderLimitRestrict Orderschar10NY=Yes, N=No Allow NULL? 
58AddDlnBlncConsider Deliv - Sales Revenuechar10NY=Yes, N=No Allow NULL? 
59CreditDpstCredit Deposit Typechar10NY=Manually, N=Automatically Allow NULL? 
60MultiLangMulti-Language Support Enabledchar10NY=Yes, N=No Allow NULL? 
61DbVersDatabase Versionint110 Allow NULL? 
62ApplVersApplication Versionint110 Allow NULL? 
63DflWebSiteDefault for Web Sitetext160
64DflFTPSiteDefault for FTP Sitetext160
65UseTaxUse Taxchar10NY=Yes, N=No Allow NULL? 
66RevisionPoSplit Purchase Orderchar10NY=Yes, N=No Allow NULL? 
67ReindexRebuild Indexeschar10NY=Yes, N=No Allow NULL? 
68DllPathPath to Validation DLLtext160
69TaxIdValidTax ID Mandatory Validationchar10NY=Yes, N=No 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 Stockchar10WW=Warning Only, B=Block, D=No Message Allow NULL? 
76CrdCommUseSet Commission by Customerchar10NY=Yes, N=No Allow NULL? 
77ItmCommUseSet Commission by Itemchar10NY=Yes, N=No Allow NULL? 
78SlpCommUseAlternative Name for Purchasechar10NY=Yes, N=No Allow NULL? 
79DfCustTermDefault Pmt Terms for Cust.int60-1 Allow NULL? 
80DfVendTermDefault Vendor Payment Termsint60-1 Allow NULL? 
81SaleProfitCalc. Gross Profit per Trans.char10YY=Yes, N=No Allow NULL? 
82CostPrcLstSet Commission by Sales Emp.int60-1 Allow NULL? 
83GrossBySalGross Profit After Salechar10NY=Yes, N=No Allow NULL? 
84TreePricOnDisplay Price for Parent Onlychar10NY=Yes, N=No Allow NULL? 
85AddVatCalc. Gross Profit per Trans.char10YY=Yes, N=No Allow NULL? 
86BaseFldBase Fieldchar10YY=Yes, N=No Allow NULL? 
87ClosedQuotAllow Closed Sales Quotationschar10NY=Yes, N=No Allow NULL? 
88UseCodeUser Conversion Codechar10NY=Yes, N=No 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 Accuracychar10NY=Yes, N=No 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 Warningchar10NY=Yes, N=No 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 Orderschar10YY=Yes, N=No Allow NULL? 
116MultiCurrMulti-Currency Checkchar10BB=Block, D=No Message Allow NULL? 
117PickParDlvPartial Deliv. Pick and Packchar10NY=Yes, N=No 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 Remarkchar10YY=Yes, N=No Allow NULL? 
122ISRBillerIISR Biller IDnvarchar90 Allow NULL? 
123UpdStampUpdate Stampint110 Allow NULL? 
124SysCNoEditBlock System Currency Editingchar10YY=Yes, N=No Allow NULL? 
125RefDNoEditBlock Updating of Posting Datechar10YY=Yes, N=No Allow NULL? 
126DfltWhsDefault Warehousenvarchar80 Allow NULL? 
127TaxDNoEditFreechar10YY=Yes, N=No 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 Budgetchar10NY=Yes, N=No 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 Orderschar10YY=Yes, N=No Allow NULL? 
137BdgtAcctngBlock Bookkeepingchar10NY=Yes, N=No Allow NULL? 
138BdgtDfltDefault Budget Cost Assmt Mthdint1101 Allow NULL? 
139ContInvntPerpetual Inventory Managementchar10NY=Yes, N=No Allow NULL? 
140InvntSystmPerpetual Inventory Systemchar10AA=Moving Average, S=Standard, F=FIFO 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 Brancheschar10NY=Yes, N=No Allow NULL? 
145EnblSrvTaxEnable Service Taxchar10NY=Yes, N=No Allow NULL? 
146DftRCNDefault for Retail Chainsint110-6 Allow NULL? 
147RoundVatRound Tax Amountschar10NY=Yes, N=No Allow NULL? 
148BdgtPDNDocBlock Deliv. Notes for Purch.char10YY=Yes, N=No Allow NULL? 
149IRSFileNoFile Number in Income Taxnvarchar90 Allow NULL? 
150DeferrTaxDeferred Taxchar10NY=Yes, N=No 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 Employeechar10NY=Yes, N=No 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 Rightchar10NY=Yes, N=No Allow NULL? 
167WarnByWhsAlert by Warehousechar10NN=No, Y=Yes Allow NULL? 
168DflBnkAcKyDefault Bank Account No.int110 Allow NULL? 
169PriceSysPrice Systemchar10YY=Whse, N=Item Allow NULL? 
170DftPVLPreferred Vendor Creditint110-1 Allow NULL? 
171useDdctTrcWTax Deduction - Hierarchychar10NY=Yes, N=No Allow NULL? 
172useDocWrfDoc. Confirmationchar10NY=Yes, N=No Allow NULL? 
173BtchStatusDefault for Batch Statuschar1000=Released, 1=Not Accessible, 2=Locked Allow NULL? 
174OrderBatchManage Orders in Batcheschar10YY=Yes, N=No Allow NULL? 
175GLMethodSet G/L Account Bychar10WW=Warehouse, C=Item Group, L=Item Level Allow NULL? 
176SetSriUniqSet Unique Serial No.char10NY=Yes, N=No 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 Determinationchar10PP=Posting Date, D=Document Date Allow NULL? 
180RefreshQtyRefresh in Whse Qty in DIchar10NY=Yes, N=No 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 Acctschar10NY=Yes, N=No Allow NULL? 
186ChCtrARActChange Def. Recon. A/R Accountschar10NY=Yes, N=No 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 Windowchar10NY=Yes, N=No Allow NULL? 
195SHandleWTWithholding Taxchar10NY=Yes, N=No Allow NULL? 
196SDfltWTDefault Withholding Tax Codenvarchar40 Allow NULL? 
197IncresGlAcG/L Increase Accountnvarchar150Y=Yes, N=No Allow NULL? 
198PHandleWTWithholding Taxchar10 Allow NULL? 
199PDfltWTDefault Withholding Tax Codenvarchar40 Allow NULL? 
200ExWTLiablWTax Liable Expensechar10NY=Yes, N=No Allow NULL? 
201EDocSeqNumElectronic Document Sequence Numberint1101 Allow NULL? 
202AllowPostZAllow Inb. Pstng W/o a Pricechar10NY=Yes, N=No Allow NULL? 
203PostDiffRDisplay in Red Greater Than %num19655=Variance Percentage Default Value Allow NULL? 
204EnableROEnable Release Only Snb in Pstchar10NY=Yes, N=No Allow NULL? 
205UalLastDelLast Delete Date on Table OUALdate80
206UalKeepDayDays for keeping data on OUALint11030 Allow NULL? 
207NegAmountUse Negative Amountschar10YY=Yes, N=No Allow NULL? 
208EnbDocOptEnable Document Optimizationchar10YY=Yes, N=No 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 Methodchar10NY=Yes, N=No,  Allow NULL? 
217AdrsFromWHFree63char10YY=Yes, N=No 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 Orderchar10YY=Yes, N=No Allow NULL? 
233PorConfrmdConfirmed Purchase Orderchar10YY=Yes, N=No 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 Tenthschar10NY=Yes, N=No Allow NULL? 
242SDfltITWTDefault Income Tax WTax Codenvarchar40 Allow NULL? 
243PDfltITWTDefault Income Tax WTax Codenvarchar40 Allow NULL? 
244free75Free75char10 Allow NULL? 
245free76Free76char10 Allow NULL? 
246DfActCurrDefault Account Currencychar10YY=All Currencies, N=Local Currency Allow NULL? 
247defTaxVendDeferred Tax for Vendorschar10NY=Yes, N=No Allow NULL? 
248free77Free77char10 Allow NULL? 
249free78Free78char10 Allow NULL? 
250free79Free79char10 Allow NULL? 
251free80Free80char10 Allow NULL? 
252free89Free89char10 Allow NULL? 
253AutoVatFree77char10NY=Yes, N=No Allow NULL? 
254ConsumeFCTConsumer Forecastchar10YY=Yes, N=No Allow NULL? 
255ConsumeMtdConsumption Methodchar10BB=Backward-Forward, F=Forward-Backward Allow NULL? 
256DaysBackDays Backwardint1107 Allow NULL? 
257DaysFwrdDays Forwardint1107 Allow NULL? 
258IsPAPrnPanama Printer Connectedchar10NY=Yes, N=No 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 Postchar10NY=Yes, N=No Allow NULL? 
269LDiscTotalFree83char10YY=Yes, N=No 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 Relevantchar10YY=Yes, N=No Allow NULL? 
280TaxPayerRfLog Instancenvarchar320 Allow NULL? 
281EmployerRfEmployer's Referencenvarchar320 Allow NULL? 
282PStatAutChPeriod Status Automatic Changechar10YY=Yes, N=No Allow NULL? 
283PStatDelayPeriod Status Change Delayint601 Allow NULL? 
284RepBusTypeReporting Business Typenvarchar202Y=Yes, N=No, 1=Industrial, 2=Commercial, 3=Service Provider, 9=Other, 4=Contractor Allow NULL? 
285RepBusOthrUnique Taxpayer Ref. (UTR)nvarchar320 Allow NULL? 
286BrachNumBranch Numbernvarchar40 Allow NULL? 
287BuisnesDscBusiness Descriptionnvarchar500Y=Yes, N=No 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 Remarkschar10YY=Yes, N=No Allow NULL? 
293TaxRndRuleDefault Tax Rounding Rulechar10R=Round Off, C=Round Up, F=Round Down Allow NULL? 
294NegTaxAllow Neg. Tax Amt in Returnschar10NY=Yes, N=No Allow NULL? 
295ZeroLineAllow Zero Amt Row in JEchar10YY=Yes, N=No Allow NULL? 
296GBOpenFileOpen GBI File After Exportchar10NY=Yes, N=No Allow NULL? 
297GBIntfaceGBI enabledchar10NY=Yes, N=No Allow NULL? 
298DfltCDPVDefault A/P Closing Date Proc.int60-1 Allow NULL? 
299OnHldPertCapital Goods On Hold Percent.num196 Allow NULL? 
300WTRndRuleDefault WTax Rounding Rulechar10R=Round Off, C=Round Up, F=Round Down Allow NULL? 
301GPPrcntSrvDefault GP % in Service Doc.num196 Allow NULL? 
302DspFrznBPDisplay Inactive BPs in Rptchar10YY=Yes, N=No Allow NULL? 
303DspFrznITMDisplay Inactive Items in Rptchar10YY=Yes, N=No Allow NULL? 
304WTAccumAmtAccum. Amount for WTax on APnum196 Allow NULL? 
305NewDPRCusHide Dpm Invoicechar10YY=Yes, N=No Allow NULL? 
306ServNatureService Naturechar10P=Service Provider, D=Service Distributor Allow NULL? 
307PickLimitRestrict Pick Listchar10NY=Yes, N=No 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 Taxchar10NY=Yes, N=No Allow NULL? 
312BoletoPathBoleto Pathtext160
313UserSign2Updating Userint60 Allow NULL? 
314MMLastImpDLast Import File Datedate80
315CpyExhRateCopy Exchange Rate in Copy Tochar10NY=Yes, N=No Allow NULL? 
316MapServiceMap Serviceint110-1 Allow NULL? 
317ODWFreqOpen Doc. Refresh Frequencyint11030 Allow NULL? 
318GTSOutPathGTS Outbound Pathtext160
319UseMltDimsUse Multidimensionschar10YY=Yes, N=No Allow NULL? 
320MDStyleMultidimensions Display Stylechar10UU=Unified, S=Separate 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 1char10NN=Without Warning, B=Block Posting Allow NULL? 
328DRBlock2Distribution Rule: Block 2char10NN=Without Warning, B=Block Posting Allow NULL? 
329DRBlock3Distribution Rule: Block 3char10NN=Without Warning, B=Block Posting Allow NULL? 
330DRBlock4Distribution Rule: Block 4char10NN=Without Warning, B=Block Posting Allow NULL? 
331DRBlock5Distribution Rule: Block 5char10NN=Without Warning, B=Block Posting Allow NULL? 
332PrjBlockProject Blockchar10NN=Without Warning, B=Block Posting Allow NULL? 
333SimReportSimulation Reportchar10NY=Yes, N=No Allow NULL? 
334SnapShotIdSnapshot IDint1100 Allow NULL? 
335BackOrderPick and Pack Back Orderchar10NY=Yes, N=No Allow NULL? 
336HQLocationHeadquarters Locationchar10BB, C=Continent, M=Madeira, A=Azores Allow NULL? 
337DigCrtPathDigital Certificate Pathtext160
338DflWTSDefault E-Tax Web Siteint60-1 Allow NULL? 
339EnbApprDIEnable DI Approval Procedurechar10NY=Yes, N=No Allow NULL? 
340ChBPSerieVerify Non-manual BP Serieschar10NY=Yes, N=No Allow NULL? 
341ChItmSerieVerify Non-manual ITM Serieschar10NY=Yes, N=No Allow NULL? 
342ETRTaxOffiETR Tax Officeint1100 Allow NULL? 
343ETRTaxPersETR Tax Person Typechar10T=VAT Payer, R=Another Person Registered for Tax, S=Person required to submit a tax declaration/return according to section 78, paragraphs 3, 4, and 9, D=Taxable person according to section 3, subsection 5, when applying a tax deduction, I=Tax agent when importing goods according to section 69 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 Modechar10NY=Yes, N=No 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 Alertchar10YY=Yes, N=No Allow NULL? 
365NotifEmailNotification by E-Mailchar10NY=Yes, N=No 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 Quotationchar10NY=Yes, N=No 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 Itemschar10YY=Enabled, N=Disabled Allow NULL? 
381AutoAddPkgAuto. Add Pkgs to Itemschar10YY=Enabled, N=Disabled Allow NULL? 
382BinActivatHas Whse Bin Activated [Y/N]char10NY=Yes, N=No Allow NULL? 
383IssuePriByIssue Primarily By SnB or Binint6000=Issue Primarily By Serial/Batch Numbers, 1=Issue Primarily By Bin Location Allow NULL? 
384InstFixAstEnable Fixed Assetschar10NY=Yes, N=No Allow NULL? 
385DeprecCalcDepreciation Calculationchar10MM=Month, D=Day Allow NULL? 
386FixAstModFixed Asset Modechar10PP=Production, T=Transfer Allow NULL? 
387SopPathSolution Packager Exe. Pathtext160
388NewAcctDeNew G/L Account Determinationchar10NY=Yes, N=No Allow NULL? 
389ClnZeroPlnClean Zero Price Row in ITM1char10NN=No, Y=Yes Allow NULL? 
390CmdDisBothDisplay Both Related Docs.char10YY=Yes, N=No 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.char10YY=Yes, N=No Allow NULL? 
398ClsNoConfiClose Without Confirmationchar10NY=Enabled, N=Disabled 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 Requestchar10NY=Yes, N=No 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 Reportschar10NY=Yes, N=No Allow NULL? 
412SIPLDocShow Inactive PL in Docschar10NY=Yes, N=No Allow NULL? 
413SIPLSetingShow Inactive PL in Settingschar10NY=Yes, N=No Allow NULL? 
414PriceProcMOn Change UoM Conversion Ruleschar10UR=Remove UoM Prices, U=Update UoM Prices Accordingly, L=Keep Corresponding UoM Prices Unchanged, K=Keep All UoM Prices Unchanged Allow NULL? 
415ChkQtyINVEnable Check Quantity in INVchar10NY=Yes, N=No Allow NULL? 
416EnbAdvATPEnable Advanced ATPchar10NY=Yes, N=No Allow NULL? 
417EnblCaseEnable Case Sensitivitychar10NN=No, Y=Yes Allow NULL? 
418EnbSupplCEnable Supplementary Codechar10YY=Yes, N=No 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 Priceschar10NY=Yes, N=No Allow NULL? 
423ApyBsActPVApply Active Period and Volumechar10NY=Yes, N=No Allow NULL? 
424ApyBsActPLApply Active Price Listschar10NY=Yes, N=No Allow NULL? 
425IsUpdNstdBUpdate Non-Std Based Priceschar10NY=Yes, N=No Allow NULL? 
426SnBDfltSBSnB Default Eval. System SBchar10NY=Yes, N=No Allow NULL? 
427OneBOneRecOne Batch One Receiptchar10NY=Yes, N=No 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.char10YY=Yes, N=No Allow NULL? 
431POrCByINCPosting or Create Date by INCchar10NY=Based on Posting Date, N=Based on Creation Date Allow NULL? 
432EnbNegPymEnable Negative Paymentchar10NY=Yes, N=No 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 Closingchar10NY=Yes, N=No Allow NULL? 
438ApyPRinPECApply PJ in Period End Closingchar10NY=Yes, N=No 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 Resourceschar10YY=Yes, N=No Allow NULL? 
443InActRptInactive Reportschar10YY=Yes, N=No Allow NULL? 
444InActMktInactive Marketing Documentschar10YY=Yes, N=No Allow NULL? 
445InActPlnInactive Price Listschar10YY=Yes, N=No Allow NULL? 
446StartFromStart Fromchar1011=Today, 2=Month Start, 3=Month End Allow NULL? 
447MonthsMonthsint601 Allow NULL? 
448DaysDaysint600 Allow NULL? 
449JEInFATranAlways Create JE in Transferchar10NY=Yes, N=No Allow NULL? 
450TPLIdUI Template IDint60 Allow NULL? 
451TxtSrchText Searchchar10NY=Yes, N=No Allow NULL? 
452ApyIBtoACTApply IBAN Vldt. to Bank Acctchar10NY=Yes, N=No Allow NULL? 
453JeUnGroupJournal Entry Lines Ungroupingchar10N Allow NULL? 
454IgnoreAddeImpresiĆ³n de documento sin Addendachar10NY=Yes, N=No Allow NULL? 

TOPB1 9.2  | AADM INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesCode, LogInstanc