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.3AADM5221Administration - 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, 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 AADM

TOPB1 9.3  | AADM COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CompnyNameCompany Namenvarchar1000 Allow NULL? 
2CompnyAddrAddressnvarchar2540 Allow NULL? 
3CountryCountrynvarchar30OCRY 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? 
13DispPosDebOpen Balance with Minus Signchar10NN=No, Y=Yes Allow NULL? 
14DefLengthUStandard Unit of Lengthint602 Allow NULL? 
15DefWeightUDefault Weight UoMint602 Allow NULL? 
16DfltVendPMDefault Payt Method for Vendornvarchar150OPYM 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.nvarchar150OPYM 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 Keyint110ODSC 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 Report 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 Deliv. Notes (PO)char10NN=No, Y=Yes Allow NULL? 
57OrderLimitRestrict Orderschar10NN=No, Y=Yes Allow NULL? 
58AddDlnBlncConsider Del. Notes in Sales Restrictionchar10NN=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? 
70PchNameAlternate Name for Purchasenvarchar200 Allow NULL? 
71RpcNameAlternate Name for A/P Creditnvarchar200 Allow NULL? 
72PdnNameAlternate Name for Goods Rcptnvarchar200 Allow NULL? 
73RpdNameAlternate Name for Goods Rtnnvarchar200 Allow NULL? 
74PorNameAlternate Name for Purchasenvarchar200 Allow NULL? 
75LevelWarnAlert Type for Whse Inventorychar10WB=Block, N=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? 
78SlpCommUseSet Commission by Sales Empl.char10NN=No, Y=Yes Allow NULL? 
79DfCustTermDefault Payment Term for Cust.int60-1 Allow NULL? 
80DfVendTermDefault Payment Term for Vend.int60-1 Allow NULL? 
81SaleProfitCalc. Gross Profit per Trans.char10YN=No, Y=Yes Allow NULL? 
82CostPrcLstPrice List for Reval. Priceint60-1 Allow NULL? 
83GrossBySalGross Profit After Salechar10NN=No, Y=Yes Allow NULL? 
84TreePricOnDisplay Price for Parent Onlychar10NN=No, Y=Yes Allow NULL? 
85AddVatCalc. Tax in Sales Quotationchar10YN=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? 
100DdAutoRunDD Auto Runchar10NN=No, Y=Yes Allow NULL? 
101DdNextDueDD Next Due Datedate80
102DdHourDD Hourint60 Allow NULL? 
103CmpnyAddrFAddress in Foreign Languagenvarchar2540 Allow NULL? 
104DflTaxCodeDefault Tax Codenvarchar80OSTC 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? 
109ManagerFManaging Director (For. 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? 
157UsePaSysUse PA Systemchar10NN=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.int110DSC1 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 Codenvarchar40OWHT Allow NULL? 
197IncresGlAcG/L Increase Accountnvarchar150OACTN=No, Y=Yes Allow NULL? 
198PHandleWTWithholding Taxchar10 Allow NULL? 
199PDfltWTDefault Withholding Tax Codenvarchar40OWHT 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? 
209HldCodeHoliday Namenvarchar200OHLD Allow NULL? 
210AlphaDocUse Alphanum. ID for Documentchar10NN=No, Y=Yes Allow NULL? 
211EDocURL2El. Doc. Service URL 2nvarchar2540 Allow NULL? 
212EnPriceModEnable Separate Price Modechar10NN=No, Y=Yes Allow NULL? 
213TaaSEnableEnable Tax as a Servicechar10NN=No, Y=Yes Allow NULL? 
214TaaSUserTaaS User Namenvarchar500 Allow NULL? 
215OrderBlockOrder Blockchar10 Allow NULL? 
216RoundMthdRounding Methodchar10N, N=No, Y=Yes Allow NULL? 
217AdrsFromWHUse Whse Address in A/P Docschar10YN=No, Y=Yes Allow NULL? 
218OrderPartyOrdering Partynvarchar300 Allow NULL? 
219CrtfcateNOCertificate No.nvarchar200 Allow NULL? 
220ExpireDateExpiration Datedate80
221NINumNational Insurance No.nvarchar200 Allow NULL? 
222TaaSPassTaaS User Passwordnvarchar200 Allow NULL? 
223TaaSAutURLTaaS oAuth URLnvarchar2500 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? 
227TaaSURLTaaS Service URLnvarchar2500 Allow NULL? 
228TaaSSaleAcTaaS Default Sales Accountnvarchar150 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? 
234TaaSPurcAcTaaS Default Purchase Accountnvarchar150 Allow NULL? 
235AdvImagePrExtended Image Processingchar10NN=Partial, O=Without, Y=Full Allow NULL? 
236ChfAccChief Accountantint110OHEM Allow NULL? 
237TaxMethodTaxation Methodchar100=On Shipment, 1=On Payment Allow NULL? 
238CEOCEOint110OHEM Allow NULL? 
239WllPprDspWallpaper Displayint6011=Centralized, 2=Full Screen, 3=Tile Allow NULL? 
240WallPaperWallpapertext160
241RndToTDecRound VAT to Tenthschar10NN=No, Y=Yes Allow NULL? 
242SDfltITWTDefault Income Tax WTax Codenvarchar40OWHT Allow NULL? 
243PDfltITWTDefault Income Tax WTax Codenvarchar40OWHT Allow NULL? 
244CheckFilesFile Checkchar10NN=No, Y=Yes Allow NULL? 
245DsplyRatesDisplay Rate Table on start upchar10NN=No, Y=Yes Allow NULL? 
246DfActCurrDefault Account Currencychar10YN=Local Currency, Y=All Currencies Allow NULL? 
247defTaxVendDeferred Tax for Vendorschar10NN=No, Y=Yes Allow NULL? 
248RcrFlagDisplay Transactions Scheduled for Todaychar10NN=No, Y=Yes Allow NULL? 
249RclFlagDisplay Recurring Transactionschar10NN=No, Y=Yes Allow NULL? 
250ContactLogToday's Activity Alertchar10NN=No, Y=Yes Allow NULL? 
251ShowNewMsgOpen Message on Arrivalchar10YN=No, Y=Yes Allow NULL? 
252OpenCdtOpen Window for Credit Referencechar10NN=No, Y=Yes Allow NULL? 
253AutoVatAutomatic VAT Row Creation Inchar10NN=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? 
259ShowNewTskOpen Worklist on Task Arrivalchar10YN=No, Y=Yes Allow NULL? 
260TaxCodeCstDef. Tax Code (New Customers)nvarchar80OSTC Allow NULL? 
261TaxCodeVndDef. Tax Code (New Vendors)nvarchar80OSTC Allow NULL? 
262StateStatusnvarchar30OCST Allow NULL? 
263CharMonthNumber of Characters in Monthint110 Allow NULL? 
264free83Free83char10 Allow NULL? 
265ScreenLockScreen Lock Delayint6030 Allow NULL? 
266OpenCreditOpen Postdated Credit Vouchers Windowchar10ND=By Date, N=No, Y=Always Allow NULL? 
267OpenDpsOpen Postdated Checks Windowchar10NN=No, Y=Yes Allow NULL? 
268AltBOEPostActive Alternative BOE Postchar10NN=No, Y=Yes Allow NULL? 
269LDiscTotalCalc. Row Disc. from Tot. Pr.char10YN=No, Y=Yes Allow NULL? 
270CodeCodeint1101 Allow NULL? 
271DfltDunTrmDefault Dunning Termsnvarchar250ODUT Allow NULL? 
272ProfessionProfessionnvarchar500 Allow NULL? 
273AlertPolFrMessage Check Frequencyint605 Allow NULL? 
274DfltCDPDefault Closing Date Procedureint60-1 Allow NULL? 
275LogInstancLog Instanceint1100 Allow NULL? 
276UpdateDateUpdate Datedate80
277UserSignUser Signatureint60OUSR Allow NULL? 
278DflBCACodeDefault Bank Charges Alloc.nvarchar30OBCA Allow NULL? 
279IgrAllCashIgnore All Cash Flow Relevantchar10YN=No, Y=Yes Allow NULL? 
280TaxPayerRfUnique Taxpayer Ref. (UTR)nvarchar320 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, 99=Report includes more than one business, 9=Other, N=No, Y=Yes Allow NULL? 
285RepBusOthrReporting Business Type Desc.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 Userint60OUSR Allow NULL? 
314MMLastImpDLast Import File Datedate80
315CpyExhRateCopy Exchange Rate in Copy Tochar10NN=No, Y=Yes Allow NULL? 
316MapServiceMap Serviceint110OMPS-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 Checkerint110OHEM Allow NULL? 
324GTSDftPyeGTS Default Payeeint110OHEM 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 Processchar10NN=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 Officeint110OTOF0 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? 
355BTWOBFmtBTW OB Mapping Formatint110 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? 
361EDocPassEl. Doc. Service Passwordnvarchar1000 Allow NULL? 
362EDProcessElectronic Document Processchar10IC=CFD, I=CFDI Allow NULL? 
363PACPACnvarchar200OPACXML Allow NULL? 
364NotifAlertNotification by Alertchar10YN=No, Y=Yes Allow NULL? 
365NotifEmailNotification by E-Mailchar10NN=No, Y=Yes Allow NULL? 
366EDocUDQCatElectronic Document UDQ Categoryint110 Allow NULL? 
367EOutputPthOuput Directory for Electronic Documentstext160
368EDelDocFrmElectronic Delivery Doc. Export Formatint110 Allow NULL? 
369EDocPmnFmtEl. Doc. Payment Formatint110 Allow NULL? 
370EDocURL1El. Doc. Service URL 1nvarchar2540 Allow NULL? 
371ETRFaxNoETR Fax Numbernvarchar200 Allow NULL? 
372ETRMgrPhnETR Manager's Phone Numbernvarchar200 Allow NULL? 
373EDFormatElectronic Document Formatint110OLLF Allow NULL? 
374AIDFormatAnnual Invoice Decl. Formatint110OLLF Allow NULL? 
375CrtLineRFQCreate Online Quotationchar10NN=No, Y=Yes Allow NULL? 
376DflJETDefault JE Typenvarchar600OJET 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? 
401CreditDay1Credit Handling Day 1int601 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 Formatint110OLLF 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 IDint60UICU Allow NULL? 
451TxtSrchText Searchchar10NN=No, Y=Yes Allow NULL? 
452ApyIBtoACTApply IBAN Vldt. to Bank Acctchar10NN=No, Y=Yes Allow NULL? 
453JeUnGroupJournal Entry Split Lineschar10NN=No Split, S=Split, Y=In Preview Only Allow NULL? 
454IgnoreAddePrint Document Without Addendachar10NN=No, Y=Yes Allow NULL? 
455EnterAsTabUse Numeric Keypad ENTER Key as TAB Keychar10NN=No, Y=Yes Allow NULL? 
456MouseOnlyDocument Operation by Mouse Onlychar10NN=No, Y=Yes Allow NULL? 
457PrjMngmntEnable Project Managementchar10NN=No, Y Allow NULL? 
458ElectrDocsEnable Electronic Documentschar10NN=No, Y=Yes Allow NULL? 
459DotAsSepUse Dot Key As Separatorchar10NN=No, Y=Yes Allow NULL? 
460DoMngMthData Ownership Management Methodnvarchar110DA=Business Partner and Document, B=Business Partner Only, D=Document Only, R=Branch Allow NULL? 
461AlwBPNOwnAllow BP Without an Ownerchar10NN=No, Y=Yes Allow NULL? 
462EmptyPKLCreate an Empty Pick Listchar10NN=No, Y=Yes Allow NULL? 
463ExcNInvItmExclude Non-Inventory Itemschar10NN=No, Y=Yes Allow NULL? 
464PayRefCalcPayment Reference Calculationint6011=Payment Reference, 2=Global Structured Creditor Reference Allow NULL? 
465MultiSchedMultiple scheduling on Service Callchar10NN=No, Y=Yes Allow NULL? 
466CloseWipVClose to Parent Item WIP Variance Accountchar10NN=No, Y=Yes Allow NULL? 
467onHldLimtCapital Goods on Hold Limitnum196 Allow NULL? 
468EnbApUpDocEnable Updating Doc Added/Updated via Approval Processchar10NN=No, Y=Yes Allow NULL? 
469EnbApUpDftEnable Updating Draft in Status Pending/Approvedchar10NN=No, Y=Yes Allow NULL? 
470EnPackingDisplay Packing Drawerchar10NN=No, Y=Yes Allow NULL? 
471BlockZeroQBlock Stock Negative Quantitychar10YN=No, Y=Yes Allow NULL? 
472NegStoLvNegative Stock: Check Levelchar10IC=Company, I=Item Setting, W=Warehouse Allow NULL? 
473EnUpdBAPlnEnable Update BA Planchar10NN=No, Y=Yes Allow NULL? 
474BAOpPORBA Option for Purchase Orderschar10NB=Block Posting, N=Without Warning, W=Warning Allow NULL? 
475BAOpPDNBA Option for GRPOschar10NB=Block Posting, N=Without Warning, W=Warning Allow NULL? 
476BAOpAcctngBA Option for Accountingchar10NB=Block Posting, N=Without Warning, W=Warning Allow NULL? 
477AssgnOBAAPAssign only valid BA for APchar10NN=No, Y=Yes Allow NULL? 
478AssngOBAARAssign only valid BA for ARchar10NN=No, Y=Yes Allow NULL? 
479ApyToNewBPApply Change Only to New BPchar10NN=No, Y=Yes Allow NULL? 
480PrrConfrmdGoods Return Request Confirmedchar10YN=No, Y=Yes Allow NULL? 
481RrrConfrmdReturn Request Confirmedchar10YN=No, Y=Yes Allow NULL? 
482DflSeriesDefault Seriesint110NNM1 Allow NULL? 
483EnblLCEnable Live Collaborationchar10NN=No, Y=Yes Allow NULL? 
484DflAcctDefault Accountnvarchar2100OACT Allow NULL? 
485SmtpServerSMTP Servernvarchar1000 Allow NULL? 
486SmtpPortSMTP Portnvarchar100 Allow NULL? 
487SmtpNameSMTP User Namenvarchar1000 Allow NULL? 
488SmtpPasswdSMTP Passwordnvarchar1000 Allow NULL? 
489SmtpEncodeSMTP Encodingnvarchar1000OLNG33=English Allow NULL? 
490SmtpAuthenSMTP Authenticationnvarchar1000NL=Login Authentication, N=No Authentication, P=Plain Password Allow NULL? 
491TlsEncrypTLS Encryptionchar10N Allow NULL? 
492HtmlDirectHTML Direction Right to Leftchar10N Allow NULL? 
493IncSubjectInclude Subject in Msg Bodychar10N Allow NULL? 
494TenLevelTenant Level Configurationchar10N Allow NULL? 
495CreditDay2Credit Handling Day 2int6015 Allow NULL? 
496CdtPrvDaysVouchers from Last Daysint1101 Allow NULL? 
497AuImpRatesImport Currency Rates Automaticallychar10NN=No, Y=Yes Allow NULL? 
498ValidateBaValidate Account Balancechar10NB=Block Posting, N=Without Warning, W=Warning Only Allow NULL? 
499ManRemarkMandatory Remarkchar10NN=No, Y=Yes Allow NULL? 
500ManRmkTypeMandatory Remark Typechar10HB=Rows and Header, H=Header Only, R=Rows Only Allow NULL? 
501ManRmkAltMandatory Remark Alert Typechar10BB=Block Posting, W=Warning Only Allow NULL? 
502TermsPathTerms and Conditions Pathtext160
503EDocWSFrmEl. Doc. WS Formatint110 Allow NULL? 
504DspBUoMDisplay Batch Quantities Bychar1000=Document Row UoM, 1=Inventory UoM Allow NULL? 
505EDocSNameEl. Doc. Sender Namenvarchar2000 Allow NULL? 
506EDocSEMailEl. Doc. Sender E-Mailnvarchar2000 Allow NULL? 
507CpyRulToTxCopy Distribution Rules to Tax Related Rowschar10NN=No, Y=Yes Allow NULL? 
508BpNoLockBusiness Partner Without Lockchar10NN=No, Y=Yes Allow NULL? 
509SearchUrlSearch Engine URLnvarchar2540http://www.google.com/search?q={SapName} {FormName} {MessageString} site:sap.com Allow NULL? 
510EnableMTDEnable Making Tax Digitalchar10NN=No, Y=Yes Allow NULL? 
511ClientIDMaking Tax Digital Client IDnvarchar1000 Allow NULL? 
512ClntSecretMaking Tax Digital Client Secretnvarchar1000 Allow NULL? 
513AuthURLMaking Tax Digital Authorized URLnvarchar2540 Allow NULL? 
514TokenURLMaking Tax Digital Token URLnvarchar2540 Allow NULL? 
515RedrctURLMaking Tax Digital Redirect URLnvarchar2540 Allow NULL? 
516ThresholdThreshold for Customer Accountingnum196 Allow NULL? 
517PublicCompPublic Companychar10NN=No, Y=Yes Allow NULL? 
518EnableEWBE-Way Bill Auto-Generationchar10NN=No, Y=Yes Allow NULL? 
519TspEntryDefault Transporterint110 Allow NULL? 
520TspLineDefault Transportation Lineint110 Allow NULL? 
521EwbGenTypeDefault E-Way Bill Generation Typechar10NG=Generate, L=Generate - Later, N=Not Relevant Allow NULL? 
522VolumeLicUse Volume Based Licensingchar10NN=No, Y=Yes Allow NULL? 

TOPB1 9.3  | AADM INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesCode, LogInstanc