| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Administration / Setup / Banking / House Bank Accounts API AADM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AADM - Administration - Log Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
AADM.CompnyName AS 'Company Name',
AADM.CompnyAddr AS 'Address',
AADM.Country AS 'Country',
AADM.PrintHeadr AS 'Printing Header',
AADM.Phone1 AS 'Telephone Number 1',
AADM.Phone2 AS 'Telephone Number 2',
AADM.Fax AS 'Fax Number',
AADM.E_Mail AS 'E-Mail',
AADM.Manager AS 'Managing Director',
AADM.CompType AS 'Chart of Accounts Template',
AADM.MainCurncy AS 'Local Currency',
AADM.SysCurrncy AS 'System Currency',
AADM.DispPosDeb AS 'Credit Balance with Minus Sign',
AADM.DefLengthU AS 'Standard Unit of Length',
AADM.DefWeightU AS 'Default Weight UoM',
AADM.DfltVendPM AS 'Default Payt Method for Vendor',
AADM.DirectRate AS 'Direct/Indirect Rate',
AADM.MinAmnt347 AS 'Minimum Amount for 347 Report',
AADM.AutoITW AS 'Set Items - Warehouses',
AADM.BankCountr AS 'Bank Country',
AADM.TaxIdNum AS 'Federal Tax ID',
AADM.RevOffice AS 'Tax Office',
AADM.FreeZoneNo AS 'Additional ID Number',
AADM.DdctFileNo AS 'Deduction File No.',
AADM.VatCharge AS 'Tax Collection',
AADM.PayOutVat AS 'Tax Definition',
AADM.VatPrcnt AS 'Tax Rate',
AADM.DpsitPrcnt AS 'Advances on Corp. Income Tax %',
AADM.IncomeTax AS 'Withholding Tax %',
AADM.VendorDdct AS 'Withholding Tax',
AADM.CustmrDdct AS 'Customer's Deduction at Source',
AADM.DdctPercnt AS 'Withholding Tax Deduction %',
AADM.DdctExpire AS 'Withholding Tax Ded. in % - Ex',
AADM.DdctOffice AS 'Withholding Tax Deduction - Of',
AADM.EURepSqntl AS 'Sequential Number of EU Sales',
AADM.BoxRptSeq AS 'Box Report Sequential Number',
AADM.WTLiable AS 'WTax Liable',
AADM.DfltCustPM AS 'Default Payt Method for Cust.',
AADM.AllowFuPos AS 'Allow Future Posting Date',
AADM.UseProdWip AS 'Use Product WIP Account',
AADM.CurrPeriod AS 'Current Period',
AADM.XmlPath AS 'XML File Path',
AADM.DflBnkKey AS 'Default Bank Key',
AADM.BSInstled AS 'Bank Statement Installed',
AADM.UseShpdGd AS 'Use Shipped Goods Account',
AADM.UseExtRpt AS 'Use Extended Reporting (OTRS)',
AADM.ERpPerType AS 'Period Type for Generation',
AADM.DfSVatExmp AS 'Sales Tax Group for Exempt',
AADM.DfPVatExmp AS 'Purchases Tax Group for Exempt',
AADM.Manager1 AS 'General Manager',
AADM.Manager1F AS 'General Manager (For. Lang.)',
AADM.CCMask AS 'Mask Credit Card Number',
AADM.ObligLimit AS 'Commitment Restriction',
AADM.CreditLimt AS 'Credit Restriction',
AADM.SalesLimit AS 'Restrict Sales',
AADM.DlnLimit AS 'Restrict Del. Notes (PO)',
AADM.OrderLimit AS 'Restrict Orders',
AADM.AddDlnBlnc AS 'Consider Deliv - Sales Revenue',
AADM.CreditDpst AS 'Credit Deposit Type',
AADM.MultiLang AS 'Multi-Language Support Enabled',
AADM.DbVers AS 'Database Version',
AADM.ApplVers AS 'Application Version',
AADM.DflWebSite AS 'Default for Web Site',
AADM.DflFTPSite AS 'Default for FTP Site',
AADM.UseTax AS 'Use Tax',
AADM.RevisionPo AS 'Split Purchase Order',
AADM.Reindex AS 'Rebuild Indexes',
AADM.DllPath AS 'Path to Validation DLL',
AADM.TaxIdValid AS 'Tax ID Mandatory Validation',
AADM.PchName AS 'Split Purchase Order',
AADM.RpcName AS 'Rebuild Indexes',
AADM.PdnName AS 'Free24',
AADM.RpdName AS 'Alt Name for Goods Return',
AADM.PorName AS 'Alternative Name for Purchase',
AADM.LevelWarn AS 'Alert Type for Whse Stock',
AADM.CrdCommUse AS 'Set Commission by Customer',
AADM.ItmCommUse AS 'Set Commission by Item',
AADM.SlpCommUse AS 'Alternative Name for Purchase',
AADM.DfCustTerm AS 'Default Pmt Terms for Cust.',
AADM.DfVendTerm AS 'Default Vendor Payment Terms',
AADM.SaleProfit AS 'Calc. Gross Profit per Trans.',
AADM.CostPrcLst AS 'Set Commission by Sales Emp.',
AADM.GrossBySal AS 'Gross Profit After Sale',
AADM.TreePricOn AS 'Display Price for Parent Only',
AADM.AddVat AS 'Calc. Gross Profit per Trans.',
AADM.BaseFld AS 'Base Field',
AADM.ClosedQuot AS 'Allow Closed Sales Quotations',
AADM.UseCode AS 'User Conversion Code',
AADM.Code1 AS 'CODE1',
AADM.Code2 AS 'CODE2',
AADM.Code3 AS 'CODE3',
AADM.Code4 AS 'CODE4',
AADM.Color AS 'Company Color',
AADM.SumDec AS 'Totals Accuracy',
AADM.QtyDec AS 'Accuracy of Quantities',
AADM.PriceDec AS 'Price Accuracy',
AADM.RateDec AS 'Rate Accuracy',
AADM.PercentDec AS 'Percentage Rate Accuracy',
AADM.MeasureDec AS 'Measuring Accuracy for Units',
AADM.DdAutoRun AS 'Price Accuracy',
AADM.DdNextDue AS 'Rate Accuracy',
AADM.DdHour AS 'Percentage Rate Accuracy',
AADM.CmpnyAddrF AS 'Address in Foreign Language',
AADM.DflTaxCode AS 'Default Tax Code',
AADM.PrintHdrF AS 'Letter Header in Foreign Lang.',
AADM.Phone1F AS 'Tel. No. 1 (Foreign Language)',
AADM.Phone2F AS 'Tel. No. 2 (Foreign Language)',
AADM.FaxF AS 'Fax Number (Foreign Lang.)',
AADM.ManagerF AS 'Letter Header in Foreign Lang.',
AADM.TimeFormat AS 'Time Template',
AADM.CigCup AS 'Cig and Cup Warning',
AADM.DateFormat AS 'Date Template',
AADM.DateSep AS 'Date Separator',
AADM.FcNoBlnc AS 'Foreign Currency Checking Account',
AADM.ChangeRdr AS 'Changed Existing Orders',
AADM.MultiCurr AS 'Multi-Currency Check',
AADM.PickParDlv AS 'Partial Deliv. Pick and Pack',
AADM.MaxTaxIncr AS 'Maximum Increase of Tax Amount',
AADM.ISRType AS 'ISR Type',
AADM.MaxTaxDecr AS 'Maximum Decrease of Tax Amount',
AADM.RoundRmrk AS 'Display Rounding Remark',
AADM.ISRBillerI AS 'ISR Biller ID',
AADM.UpdStamp AS 'Update Stamp',
AADM.SysCNoEdit AS 'Block System Currency Editing',
AADM.RefDNoEdit AS 'Block Updating of Posting Date',
AADM.DfltWhs AS 'Default Warehouse',
AADM.TaxDNoEdit AS 'Free',
AADM.DfSVatItem AS 'Tax Definition',
AADM.DfSVatServ AS 'Tax Definition',
AADM.DfPVatItem AS 'Tax Group for Purchase Item',
AADM.DfPVatServ AS 'Tax Group for Service Purchase',
AADM.DoBudget AS 'Calculate Budget',
AADM.CustIdNum AS 'Customer ID',
AADM.BgtBlock AS 'Block Budget',
AADM.BgtWarning AS 'Budget Alert',
AADM.BdgtPORDoc AS 'Block Purchase Orders',
AADM.BdgtAcctng AS 'Block Bookkeeping',
AADM.BdgtDflt AS 'Default Budget Cost Assmt Mthd',
AADM.ContInvnt AS 'Perpetual Inventory Management',
AADM.InvntSystm AS 'Perpetual Inventory System',
AADM.ApplicIFRS AS 'Application of IFRS',
AADM.StartYear AS 'Starting in Fiscal Year',
AADM.According AS 'Report According To',
AADM.MltpBrnchs AS 'Enable Multiple Branches',
AADM.EnblSrvTax AS 'Enable Service Tax',
AADM.DftRCN AS 'Default for Retail Chains',
AADM.RoundVat AS 'Round Tax Amounts',
AADM.BdgtPDNDoc AS 'Block Deliv. Notes for Purch.',
AADM.IRSFileNo AS 'File Number in Income Tax',
AADM.DeferrTax AS 'Deferred Tax',
AADM.DflIntrst AS 'Min. Default Interest Amount',
AADM.DfltSlp AS 'Sales Employee',
AADM.DflCrCard AS 'Default Credit Card',
AADM.DflBnkCode AS 'Default Bank No.',
AADM.DflBnkAcct AS 'Default Bank Account',
AADM.DflBranch AS 'Default Branch',
AADM.UsePaSys AS 'Sales Employee',
AADM.Serv_Usr AS 'Service Code',
AADM.Serv_Pass AS 'Service Password',
AADM.ParamPath AS 'Parameter Folder Path',
AADM.ExcelPath AS 'Excel Folder Path',
AADM.TaxIdNum2 AS 'Federal Tax ID 2',
AADM.TaxIdNum3 AS 'Federal Tax ID 3',
AADM.DecSep AS 'Decimal Separator',
AADM.ThousSep AS 'Thousands Separator',
AADM.CurOnRight AS 'Display Currency on the Right',
AADM.WarnByWhs AS 'Alert by Warehouse',
AADM.DflBnkAcKy AS 'Default Bank Account No.',
AADM.PriceSys AS 'Price System',
AADM.DftPVL AS 'Preferred Vendor Credit',
AADM.useDdctTrc AS 'WTax Deduction - Hierarchy',
AADM.useDocWrf AS 'Doc. Confirmation',
AADM.BtchStatus AS 'Default for Batch Status',
AADM.OrderBatch AS 'Manage Orders in Batches',
AADM.GLMethod AS 'Set G/L Account By',
AADM.SetSriUniq AS 'Set Unique Serial No.',
AADM.SriUniqFld AS 'Unique Serial No.',
AADM.MaxHistory AS 'Max. History',
AADM.TaxRateDet AS 'Tax Rate Determination',
AADM.RefreshQty AS 'Refresh in Whse Qty in DI',
AADM.StockNoBas AS 'Stock No. Base',
AADM.MaxCntRows AS 'Allowed Max Rows in Counting',
AADM.CentPmtInc AS 'Enable Incom. Centralized Payt',
AADM.CentPmtOut AS 'Enable Outg. Centralized Payt',
AADM.ChCtrAPAct AS 'Change Def. Recon. A/P Accts',
AADM.ChCtrARAct AS 'Change Def. Recon. A/R Accounts',
AADM.PACUsrName AS 'PAC User Name',
AADM.PACPasswrd AS 'PAC Password',
AADM.CaredType AS 'BP Type Code',
AADM.PBSNumber AS 'PBS Number',
AADM.PBSGroupNo AS 'PBS Group Number',
AADM.OrgNumber AS 'Organization Number',
AADM.ActSep AS 'Account Segments Separator',
AADM.DspBokpWin AS 'Display Bookkeeping Window',
AADM.SHandleWT AS 'Withholding Tax',
AADM.SDfltWT AS 'Default Withholding Tax Code',
AADM.IncresGlAc AS 'G/L Increase Account',
AADM.PHandleWT AS 'Withholding Tax',
AADM.PDfltWT AS 'Default Withholding Tax Code',
AADM.ExWTLiabl AS 'WTax Liable Expense',
AADM.EDocSeqNum AS 'Electronic Document Sequence Number',
AADM.AllowPostZ AS 'Allow Inb. Pstng W/o a Price',
AADM.PostDiffR AS 'Display in Red Greater Than %',
AADM.EnableRO AS 'Enable Release Only Snb in Pst',
AADM.UalLastDel AS 'Last Delete Date on Table OUAL',
AADM.UalKeepDay AS 'Days for keeping data on OUAL',
AADM.NegAmount AS 'Use Negative Amounts',
AADM.EnbDocOpt AS 'Enable Document Optimization',
AADM.HldCode AS 'Free57',
AADM.AlphaDoc AS 'Free58',
AADM.free62 AS 'Free62',
AADM.free63 AS 'Free63',
AADM.free64 AS 'Free64',
AADM.free65 AS 'Free65',
AADM.OrderBlock AS 'Order Block',
AADM.RoundMthd AS 'Rounding Method',
AADM.AdrsFromWH AS 'Free63',
AADM.OrderParty AS 'Ordering Party',
AADM.CrtfcateNO AS 'Certificate No.',
AADM.ExpireDate AS 'Expiration Date',
AADM.NINum AS 'National Insurance No.',
AADM.free66 AS 'Free66',
AADM.free67 AS 'Free67',
AADM.CfwAsnMust AS 'CFW Assignment Mandatory [Y/N]',
AADM.CfwInDflt AS 'Incoming Payment Draft CF Item',
AADM.CfwOutDflt AS 'Outgoing Payment Dflt CFW Item',
AADM.free68 AS 'Free68',
AADM.free69 AS 'Free69',
AADM.TaxRegime AS 'Tax Regime',
AADM.AliasName AS 'Alias Name',
AADM.DftJPELine AS 'Default Line For Local Area',
AADM.RdrConfrmd AS 'Confirmed Sales Order',
AADM.PorConfrmd AS 'Confirmed Purchase Order',
AADM.free71 AS 'Free71',
AADM.free72 AS 'Free72',
AADM.ChfAcc AS 'Chief Accountant',
AADM.TaxMethod AS 'Taxation Method',
AADM.CEO AS 'CEO',
AADM.free73 AS 'Free73',
AADM.free74 AS 'Free74',
AADM.RndToTDec AS 'Round VAT to Tenths',
AADM.SDfltITWT AS 'Default Income Tax WTax Code',
AADM.PDfltITWT AS 'Default Income Tax WTax Code',
AADM.free75 AS 'Free75',
AADM.free76 AS 'Free76',
AADM.DfActCurr AS 'Default Account Currency',
AADM.defTaxVend AS 'Deferred Tax for Vendors',
AADM.free77 AS 'Free77',
AADM.free78 AS 'Free78',
AADM.free79 AS 'Free79',
AADM.free80 AS 'Free80',
AADM.free89 AS 'Free89',
AADM.AutoVat AS 'Free77',
AADM.ConsumeFCT AS 'Consumer Forecast',
AADM.ConsumeMtd AS 'Consumption Method',
AADM.DaysBack AS 'Days Backward',
AADM.DaysFwrd AS 'Days Forward',
AADM.IsPAPrn AS 'Panama Printer Connected',
AADM.free82 AS 'Free82',
AADM.TaxCodeCst AS 'Def. Tax Code (New Customers)',
AADM.TaxCodeVnd AS 'Def. Tax Code (New Vendors)',
AADM.State AS 'Status',
AADM.CharMonth AS 'Number of Characters in Month',
AADM.free83 AS 'Free83',
AADM.free84 AS 'Free84',
AADM.free85 AS 'Free85',
AADM.free86 AS 'Free86',
AADM.AltBOEPost AS 'Active Alternative BOE Post',
AADM.LDiscTotal AS 'Free83',
AADM.Code AS 'Code',
AADM.DfltDunTrm AS 'Default Dunning Terms',
AADM.Profession AS 'Profession',
AADM.free88 AS 'Free88',
AADM.DfltCDP AS 'Default Closing Date Procedure',
AADM.LogInstanc AS 'Log Instance',
AADM.UpdateDate AS 'Update Date',
AADM.UserSign AS 'User Signature',
AADM.DflBCACode AS 'Free88',
AADM.IgrAllCash AS 'Ignore All Cash Flow Relevant',
AADM.TaxPayerRf AS 'Log Instance',
AADM.EmployerRf AS 'Employer's Reference',
AADM.PStatAutCh AS 'Period Status Automatic Change',
AADM.PStatDelay AS 'Period Status Change Delay',
AADM.RepBusType AS 'Reporting Business Type',
AADM.RepBusOthr AS 'Unique Taxpayer Ref. (UTR)',
AADM.BrachNum AS 'Branch Number',
AADM.BuisnesDsc AS 'Business Description',
AADM.ReptMethod AS 'Reporting Method',
AADM.AcctMethod AS 'Accounting Method',
AADM.Bookpitype AS 'Bookkeeping Type',
AADM.ActSoftNam AS 'Accounting Software Name',
AADM.OpnClsRmrk AS 'Copy Opening/Closing Remarks',
AADM.TaxRndRule AS 'Default Tax Rounding Rule',
AADM.NegTax AS 'Allow Neg. Tax Amt in Returns',
AADM.ZeroLine AS 'Allow Zero Amt Row in JE',
AADM.GBOpenFile AS 'Open GBI File After Export',
AADM.GBIntface AS 'GBI enabled',
AADM.DfltCDPV AS 'Default A/P Closing Date Proc.',
AADM.OnHldPert AS 'Capital Goods On Hold Percent.',
AADM.WTRndRule AS 'Default WTax Rounding Rule',
AADM.GPPrcntSrv AS 'Default GP % in Service Doc.',
AADM.DspFrznBP AS 'Display Inactive BPs in Rpt',
AADM.DspFrznITM AS 'Display Inactive Items in Rpt',
AADM.WTAccumAmt AS 'Accum. Amount for WTax on AP',
AADM.NewDPRCus AS 'Hide Dpm Invoice',
AADM.ServNature AS 'Service Nature',
AADM.PickLimit AS 'Restrict Pick List',
AADM.WTAccAmtAR AS 'Accum. Amount for WTax on AR',
AADM.UseProdPL AS 'Use Production P&L Accounts',
AADM.QueryDec AS 'Calculated Query Accuracy',
AADM.ExRtDefTax AS 'Exchange Rate on Deferred Tax',
AADM.BoletoPath AS 'Boleto Path',
AADM.UserSign2 AS 'Updating User',
AADM.MMLastImpD AS 'Last Import File Date',
AADM.CpyExhRate AS 'Copy Exchange Rate in Copy To',
AADM.MapService AS 'Map Service',
AADM.ODWFreq AS 'Open Doc. Refresh Frequency',
AADM.GTSOutPath AS 'GTS Outbound Path',
AADM.UseMltDims AS 'Use Multidimensions',
AADM.MDStyle AS 'Multidimensions Display Style',
AADM.GTSInPath AS 'GTS Inbound Path',
AADM.GTSSep AS 'GTS Separator',
AADM.GTSDftChk AS 'GTS Default Checker',
AADM.GTSDftPye AS 'GTS Default Payee',
AADM.GTSMaxAmt AS 'GTS Max. Amount',
AADM.RspOverAmt AS 'Response to Exceeding Amount',
AADM.DRBlock1 AS 'Distribution Rule: Block 1',
AADM.DRBlock2 AS 'Distribution Rule: Block 2',
AADM.DRBlock3 AS 'Distribution Rule: Block 3',
AADM.DRBlock4 AS 'Distribution Rule: Block 4',
AADM.DRBlock5 AS 'Distribution Rule: Block 5',
AADM.PrjBlock AS 'Project Block',
AADM.SimReport AS 'Simulation Report',
AADM.SnapShotId AS 'Snapshot ID',
AADM.BackOrder AS 'Pick and Pack Back Order',
AADM.HQLocation AS 'Headquarters Location',
AADM.DigCrtPath AS 'Digital Certificate Path',
AADM.DflWTS AS 'Default E-Tax Web Site',
AADM.EnbApprDI AS 'Enable DI Approval Procedure',
AADM.ChBPSerie AS 'Verify Non-manual BP Series',
AADM.ChItmSerie AS 'Verify Non-manual ITM Series',
AADM.ETRTaxOffi AS 'ETR Tax Office',
AADM.ETRTaxPers AS 'ETR Tax Person Type',
AADM.EDocExpFrm AS 'Electronic Doc. Export Format',
AADM.PCN874RTyp AS 'PCN874 Report Type',
AADM.BTWDecProv AS 'BTW Declaration Provider',
AADM.BTWDcPrvID AS 'BTW Declaration Provider ID',
AADM.BTWName AS 'BTW Name',
AADM.BTWStreet AS 'BTW Street',
AADM.BTWCity AS 'BTW City',
AADM.BTWZip AS 'BTW ZIP Code',
AADM.BTWPhone AS 'BTW Phone Number',
AADM.BTWOB AS 'BTW OB ID',
AADM.BTWICP AS 'BTW ICL ID',
AADM.BTWOBFmt AS 'ETR Telephone Number',
AADM.BTWICPFmt AS 'BTW ICP Mapping Format',
AADM.ETRPhoneNo AS 'ETR Telephone Number',
AADM.EDTestMode AS 'Electronic Document Test Mode',
AADM.EDocGenTyp AS 'El. Doc. Default Gen. Type',
AADM.EDocRptFmt AS 'El. Document Report Format',
AADM.InputMsg AS 'El. Doc. Input Message Format',
AADM.EDProcess AS 'Electronic Document Process',
AADM.PAC AS 'PAC',
AADM.NotifAlert AS 'Notification by Alert',
AADM.NotifEmail AS 'Notification by E-Mail',
AADM.EDocUDQCat AS 'Free58',
AADM.EOutputPth AS 'Free58',
AADM.EDelDocFrm AS 'Electronic Delivery Doc. Export Format',
AADM.free22 AS 'Free22',
AADM.free21 AS 'Free21',
AADM.ETRFaxNo AS 'ETR Fax Number',
AADM.ETRMgrPhn AS 'ETR Manager's Phone Number',
AADM.EDFormat AS 'Electronic Document Format',
AADM.AIDFormat AS 'Annual Invoice Decl. Format',
AADM.CrtLineRFQ AS 'Create Online Quotation',
AADM.DflJET AS 'Default JE Type',
AADM.OnlyPaidIn AS 'Display Only Paid Reserve Inv.',
AADM.PDDEnabled AS 'Payments Due Date Enabled',
AADM.MaxDays4DD AS 'Max. Allowed Range for Due Dte',
AADM.AutoAddUoM AS 'Auto. Add UoMs to Items',
AADM.AutoAddPkg AS 'Auto. Add Pkgs to Items',
AADM.BinActivat AS 'Has Whse Bin Activated [Y/N]',
AADM.IssuePriBy AS 'Issue Primarily By SnB or Bin',
AADM.InstFixAst AS 'Enable Fixed Assets',
AADM.DeprecCalc AS 'Depreciation Calculation',
AADM.FixAstMod AS 'Fixed Asset Mode',
AADM.SopPath AS 'Solution Packager Exe. Path',
AADM.NewAcctDe AS 'New G/L Account Determination',
AADM.ClnZeroPln AS 'Clean Zero Price Row in ITM1',
AADM.CmdDisBoth AS 'Display Both Related Docs.',
AADM.CnclMaxDay AS 'Max. No. of Days For Cancel',
AADM.AttachPath AS 'Attachment Path',
AADM.ConfigPath AS 'Configuration Path',
AADM.WrkshtPath AS 'Worksheet Path',
AADM.ICDifExPe1 AS 'Single Count Variance (%)',
AADM.ICDifExPe2 AS 'Multiple Count Max. Variance (%)',
AADM.ClsZoDiffR AS 'Close Rows Cont. Zero Diff.',
AADM.ClsNoConfi AS 'Close Without Confirmation',
AADM.DTWPath AS 'DTW Exe. Path',
AADM.DfltByEml AS 'Default by E-Mail',
AADM.free46 AS 'Free46',
AADM.INVOBPrice AS 'Inventory OB Price Zero',
AADM.SplitFBSh AS 'Split Fix Balance Sheet [Y/N]',
AADM.NotifyRqr AS 'Notify Requester',
AADM.DeactivFA AS 'Deactivate Asset When End Life',
AADM.CshDctFA AS 'CM for Payment Cash Discount',
AADM.SendAlert AS 'Send Internal Message',
AADM.BdgtPRQDOC AS 'Block Purchase Request',
AADM.IsReuseNum AS 'Enable Document Number Reuse',
AADM.IsReuseNFN AS 'Enable Nota Fiscal No. Reuse',
AADM.SIPLReport AS 'Show Inactive PL in Reports',
AADM.SIPLDoc AS 'Show Inactive PL in Docs',
AADM.SIPLSeting AS 'Show Inactive PL in Settings',
AADM.PriceProcM AS 'On Change UoM Conversion Rules',
AADM.ChkQtyINV AS 'Enable Check Quantity in INV',
AADM.EnbAdvATP AS 'Enable Advanced ATP',
AADM.EnblCase AS 'Enable Case Sensitivity',
AADM.EnbSupplC AS 'Enable Supplementary Code',
AADM.MBAOnPer AS 'Allow Multiple BAs for Period',
AADM.MBAOnAP AS 'Block Multiple BAs for AP Doc.',
AADM.MBAOnAR AS 'Block Multiple BAs for AR Doc.',
AADM.ApyBsActSP AS 'Apply Active Special Prices',
AADM.ApyBsActPV AS 'Apply Active Period and Volume',
AADM.ApyBsActPL AS 'Apply Active Price Lists',
AADM.IsUpdNstdB AS 'Update Non-Std Based Prices',
AADM.SnBDfltSB AS 'SnB Default Eval. System SB',
AADM.OneBOneRec AS 'One Batch One Receipt',
AADM.ReptCurrcy AS 'R6111 Report Currency',
AADM.ICDifExPe3 AS 'Multiple Count Vldt. Variance (%)',
AADM.INCSingToV AS 'Copy Single Counter to Validt.',
AADM.POrCByINC AS 'Posting or Create Date by INC',
AADM.EnbNegPym AS 'Enable Negative Payment',
AADM.SirenNo AS 'Siren Number',
AADM.SEPACredID AS 'SEPA Creditor ID',
AADM.InstitCode AS 'Institution Code',
AADM.ECDFormat AS 'ECD File Format',
AADM.ApyDRinPEC AS 'Apply DR in Period End Closing',
AADM.ApyPRinPEC AS 'Apply PJ in Period End Closing',
AADM.TaxPyerSta AS 'TAX_PAYER_STATUS',
AADM.MaxINVRptR AS 'Allowed Rows in INC Trans Rpt',
AADM.DftResWhs AS 'Default Resource Warehouse',
AADM.AutoResWhs AS 'Auto Add All Warehouses to New Resources',
AADM.InActRpt AS 'Inactive Reports',
AADM.InActMkt AS 'Inactive Marketing Documents',
AADM.InActPln AS 'Inactive Price Lists',
AADM.StartFrom AS 'Start From',
AADM.Months AS 'Months',
AADM.Days AS 'Days',
AADM.JEInFATran AS 'Always Create JE in Transfer',
AADM.TPLId AS 'UI Template ID',
AADM.TxtSrch AS 'Text Search',
AADM.ApyIBtoACT AS 'Apply IBAN Vldt. to Bank Acct',
AADM.JeUnGroup AS 'Journal Entry Lines Ungrouping',
AADM.IgnoreAdde AS 'Impresión de documento sin Addenda'
FROM AADM AS AADM Related informationLegal List Format OLLF SQL Table Employees OHEM SQL Table Countries OCRY SQL Table Bank Charges Allocation Codes OBCA SQL Table House Bank Accounts DSC1 SQL Table Bank Codes ODSC SQL Table JE Document Type OJET SQL Table Sales Tax Codes OSTC SQL Table Payment Methods for Payment Wizard OPYM SQL Table Dunning Terms ODUT SQL Table Holiday Table OHLD SQL Table G/L Accounts OACT SQL Table Map Services OMPS SQL Table PAC Companies OPAC SQL Table Withholding Tax OWHT SQL Table States OCST SQL Table Customized Template UICU SQL Table Users OUSR SQL Table |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |