|
|
SQL Administration / Company Info
DTW Administration / Setup / Inventory / Item Groups
API AINF
AINF - Company Info Table
House Bank Accounts DSC1 SQL Table
Tax Definition OVTG SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Version KEY UNIQUE | Version | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CompnyName | Company Name | nVarChar | 100 | |||||
| Flags | Flags | nVarChar | 50 | NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN | ||||
| InfoL1 | Info L1 | Int | 11 | |||||
| InfoL2 | Info L2 | Int | 11 | |||||
| InfoA1 | Info A1 | nVarChar | 127 | |||||
| InfoA2 | Info A2 | nVarChar | 50 | |||||
| ACTStamp | ACT Stamp | Int | 11 | 0 | ||||
| ADMStamp | (( | Int | 11 | 0 | ||||
| RTTStamp | RTT Stamp | Int | 11 | 0 | ||||
| CINFStamp | CINF Stamp | Int | 11 | 0 | ||||
| LawsSet | Laws Set | nVarChar | 3 | |||||
| EnblVatGrp | Tax System | VarChar | O) One Tax L) Tax per Row C) Tax per BP | 1 | ||||
| EnblVTGPmn | Use Tax Groups in Payments | VarChar | Y) Yes N) No | 1 | ||||
| VatOOS_O | Tax Definition | nVarChar | 8 | |||||
| VatOOS_I | Tax Exempt Revenue Account | nVarChar | 8 | |||||
| VatStnd_O | Tax Standard O | nVarChar | 8 | |||||
| VatStnd_I | Tax Standard I | nVarChar | 8 | |||||
| VatExmpt_O | Tax Exempt O | nVarChar | 8 | |||||
| VatExmpt_I | Tax Exempt I | nVarChar | 8 | |||||
| VatHalf_O | Tax Definition | nVarChar | 8 | |||||
| VatHalf_I | Tax Definition | nVarChar | 8 | |||||
| VatZrRt_O | Tax Zero Rate O | nVarChar | 8 | |||||
| VatZrRt_I | Tax Zero Rate I | nVarChar | 8 | |||||
| MaxActGrps | Max. No. of Account Groups | Int | 11 | |||||
| EnblDctSrc | Enable Deduction at Source | VarChar | Y) Yes N) No | 1 | ||||
| EnblRCN | Enable Retail Chain Stores | VarChar | Y) Yes N) No | 1 | ||||
| EnblCorINV | Enable Correction Invoice | VarChar | Y) Yes N) No | 1 | ||||
| EnblCshRep | Enable Cash Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblIRTRep | Enable Interest Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblTrnRep | Enable Turnover Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblVPMRep | Enable Payments Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblACTRep | Enable Adv. Corp. Tax Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblFTZ | Enable Free Trade Zone | VarChar | Y) Yes N) No | 1 | ||||
| EnblSlfPCH | Enable Self A/P Invoice | VarChar | Y) Yes N) No | 1 | ||||
| EnblPCHUpd | Enable Purchase Trans. Update | VarChar | Y) Yes N) No | 1 | ||||
| EnblRsvINV | Enable Reserve Invoice | VarChar | Y) Yes N) No | 1 | ||||
| EnblRTDnld | Enable Rates Download | VarChar | Y) Yes N) No | 1 | ||||
| RTTDnldAdr | Rates Download Web Address | nVarChar | 127 | |||||
| ZPrcCode | Zero Center Code | nVarChar | 8 | |||||
| EnblExpns | Enable Freight Management | VarChar | Y) Yes N) No | 1 | ||||
| EnblRtrRep | Enable Returns Report | VarChar | Y) Yes N) No | 1 | ||||
| IsEC | European Countries | VarChar | Y) Yes N) No | 1 | ||||
| EnblCshDsc | Enable Cash Discounts | VarChar | Y) Yes N) No V) No Tax Adjustment | 1 | ||||
| EnblLostCD | Enable Lost Cash Discount | VarChar | Y) Yes N) No | 1 | ||||
| NumActLvls | No. of Account Group Levels | Int | 11 | |||||
| EnblRealRD | Enable Realized Rate Diff. | VarChar | Y) Yes N) No | 1 | ||||
| EnblVTGNoD | Enable Tax on Down Payment | VarChar | Y) Yes N) No | 1 | Y | |||
| EnblGLManP | Enable Manual Postings in Control Accoun | VarChar | N) No Y) Yes | 1 | ||||
| EnblOptVIP | Enable Optional Tax in Payments | VarChar | Y) Yes N) No | 1 | ||||
| EnblActCrC | Enable Account Currency Change | VarChar | Y) Yes N) No | 1 | ||||
| EnblFrnAct | Enable Foreign Item Account | VarChar | Y) Yes N) No | 1 | ||||
| EnblECAct | Enable EU Item Account | VarChar | Y) Yes N) No | 1 | ||||
| EnblECRpt | Enable 349 Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblRound | Enable Rounding | VarChar | Y) Yes N) No | 1 | ||||
| EnblPrVatS | Enable Print Tax Amount | VarChar | Y) Yes N) No | 1 | ||||
| EnblYrTrns | Enable Year Transfer | VarChar | Y) Year Transfer N) No A) Data Archive | 1 | ||||
| EnblActTtl | Enable Account Title | VarChar | Y) Yes N) No | 1 | ||||
| EnblDocWrn | Enable No Base Doc. Alert | VarChar | Y) Yes N) No | 1 | ||||
| ActSegNum | No. of Segments | Int | 6 | 0 | ||||
| EnbSgmnAct | Enable Account Segmentation | VarChar | Y) Yes N) No | 1 | ||||
| SizeOfSeg0 | Size of Segment 0 | Int | 6 | 0 | ||||
| SizeOfSeg1 | Size of Segment 1 | Int | 6 | 0 | ||||
| SizeOfSeg2 | Size of Segment 2 | Int | 6 | 0 | ||||
| SizeOfSeg3 | Size of Segment 3 | Int | 6 | 0 | ||||
| SizeOfSeg4 | Size of Segment 4 | Int | 6 | 0 | ||||
| SizeOfSeg5 | Size of Segment 5 | Int | 6 | 0 | ||||
| SizeOfSeg6 | Size of Segment 6 | Int | 6 | 0 | ||||
| SizeOfSeg7 | Size of Segment 7 | Int | 6 | 0 | ||||
| SizeOfSeg8 | Size of Segment 8 | Int | 6 | 0 | ||||
| SizeOfSeg9 | Size of Segment 9 | Int | 6 | 0 | ||||
| Rprt1099 | 1099 Report | VarChar | Y) Yes N) No | 1 | ||||
| MultiAddss | Multi Address | VarChar | Y) Yes N) No | 1 | ||||
| EnbDunning | Enable Dunning | VarChar | Y) Yes N) No | 1 | Y | |||
| EnbQtyEDln | Allow Qty in Delivery Note to Exceed Bas | VarChar | Y) Yes N) No | 1 | ||||
| Itw1Date | Next Alert Date | Date | 8 | |||||
| Itw1Time | Next Alert Time | Int | 11 | |||||
| Itw1Count | ITW1 Counter | Int | 11 | |||||
| EnbPayRef | Calculate Payment Ref. No. | VarChar | Y) Payment Reference No. N) No I) ISR Reference | 1 | ||||
| EnblDfrTax | Enable Deferred Tax | VarChar | Y) Yes N) No | 1 | ||||
| EnblClsPr | Enable Period-End Closing | VarChar | Y) Yes N) No | 1 | ||||
| EnblTaxEL | Enable Tax Exemption Letter | VarChar | Y) Yes N) No | 1 | ||||
| EnableBOE | Enable Bills of Exchange | VarChar | Y) Yes N) No | 1 | N | |||
| EnableWHT | Enable WTax | VarChar | Y) Yes N) No | 1 | N | |||
| EnblEquVat | Enable Equalization Tax | VarChar | Y) Yes N) No | 1 | ||||
| EnblFAsset | Enable Fixed Assets | VarChar | Y) Yes N) No | 1 | ||||
| EnblDoubt | Enable Doubtful Debts | VarChar | Y) Yes N) No | 1 | ||||
| RateBase | Base Date for Exchange Rate | VarChar | P) Posting Date T) Document Date | 1 | P | |||
| BOEStatClo | Allow Closed Status for Bill of Exchange | VarChar | Y) Yes N) No | 1 | ||||
| ARDocsInWT | Enable WTax in A/R Docs | VarChar | N) No Y) Yes | 1 | ||||
| BISBnkCnt | BISR Bank Country | nVarChar | 3 | |||||
| BISRBnkCd | BISR Bank No. | nVarChar | 30 | |||||
| BISRBnkAc | BISR Bank Account | nVarChar | 50 | |||||
| BISRBranch | BISR Branch | nVarChar | 50 | |||||
| EnblBPConn | Enable BP Cards Connection | VarChar | Y) Yes N) No | 1 | ||||
| EnblVATDat | Enable VAT Date | VarChar | Y) Yes N) No | 1 | ||||
| EnblStAgRp | Enable Stock Aging Report | VarChar | Y) Yes N) No | 1 | ||||
| EnblCARepo | Enable Control Acct Reposting | VarChar | Y) Yes N) No | 1 | ||||
| EnblMatRev | Enable Inventory Revaluation | VarChar | Y) Yes N) No | 1 | ||||
| EnblMBPRec | Enable Multiple BPs Reconcil. | VarChar | Y) Yes N) No | 1 | ||||
| CshDscGros | Cash Discount Flag For CN, HK | VarChar | 1 | N | ||||
| EnblTaxInv | Enable Tax Invoices | VarChar | Y) Yes N) No | 1 | ||||
| EnblCorAct | Enable Correspondence of Accts | VarChar | N) No Y) Yes | 1 | ||||
| EnblRuDIP | Enable RU Delivery & Invoice | VarChar | N) No Y) Yes | 1 | ||||
| EnblCurDec | Enable Decimal Places | VarChar | N) No Y) Yes | 1 | ||||
| EnblPayMtd | Enable Payment Method on Inv. | VarChar | N) No Y) Yes | 1 | ||||
| EnblBaseUn | Enable UoM on Invoice | VarChar | N) No Y) Yes | 1 | ||||
| EnblVATAna | Enable VAT Analytics Report | VarChar | N) No Y) Yes | 1 | ||||
| EnblExREnh | Enable Frgn. Curr. Valuation | VarChar | Y) Yes N) No | 1 | ||||
| VATGrpCal | Enable VAT Calculation by Grp | VarChar | Y) Yes N) No | 1 | ||||
| MaxChoose | No. of Choose from List Rows | Int | 11 | 0 | ||||
| EnblInfla | Enable Inflation | VarChar | Y) Yes N) No | 1 | ||||
| EnblLAWHT | Enable Latin America WHT | VarChar | Y) Yes N) No | 1 | ||||
| EnblRTWHT | Enable Rounding Type WHT | VarChar | Y) Yes N) No | 1 | ||||
| ChkQunty | Enable Check Quantity In RDR | VarChar | Y) Yes N) No | 1 | N | |||
| SriMngSys | SRI Management System | VarChar | A) On Every Transaction R) On Release Only | 1 | R | |||
| BtchMngSys | Batch Management System | VarChar | A) On Every Transaction R) On Release Only | 1 | R | |||
| SriCreatIn | Auto SRI creation on receipt | VarChar | N) No Y) Yes | 1 | N | |||
| EnblFolio | Enable Folio Numbers | nVarChar | N) No CL) Chile MX) Mexico | 2 | ||||
| EnblDocSbT | Enable Document Subtype | nVarChar | N) No CL) Chile MX) Mexico | 2 | ||||
| IepsPayer | IEPS Payers | VarChar | Y) Yes N) No | 1 | N | |||
| DaysOrdCnc | Default Days for Ord. Canc. | Int | 11 | 30 | ||||
| EnblLATaxS | Enable Latin America Tax Sys | VarChar | Y) Yes N) No | 1 | ||||
| PercOfAcq | Percent of Total Acquisition | Num | 20 | |||||
| MinBaseDoc | Minimum Base Amount per Doc | Num | 20 | |||||
| EnblDpmJdt | Create JE Rows in Down Pmnt | VarChar | Y) Yes N) No | 1 | ||||
| EnblDownP | Down Payment | VarChar | Y) Yes N) No | 1 | ||||
| EnblNDdctC | Enable Non Deduct VAT Per Card | VarChar | Y) Yes N) No | 1 | ||||
| DocNmMtd | Enable Sharing Series | VarChar | Y) Yes N) No. | 1 | ||||
| DoFilter | Data Ownership Indication | VarChar | Y) Yes N) No. | 1 | N | |||
| EnblOnPDCh | Enable Opened Postdated Checks | VarChar | Y) Yes N) No | 1 | ||||
| EnblOnWnCr | Open Window for Credit Voucher | VarChar | Y) Yes N) No | 1 | ||||
| EnblDefInx | Enable Define Indexes | VarChar | Y) Yes N) No | 1 | ||||
| EnblMxComm | Enable Max Commitment | VarChar | Y) Yes N) No | 1 | ||||
| EnblIndxOp | Enable Index Option | VarChar | Y) Yes N) No | 1 | ||||
| EnblSbtCVo | Enable Submit Credit Voucher | VarChar | Y) Yes N) No | 1 | ||||
| MinAmntOAP | Minimum Amount for Appndix O&P | Num | 20 | |||||
| CredSumm | Credit Card Summary | VarChar | Y) Yes N) No | 1 | ||||
| PostdChk | Postdated Check | VarChar | Y) Yes N) No | 1 | ||||
| PostdCred | Postdated Credit Voucher | VarChar | Y) Yes N) No | 1 | ||||
| CredVend | Credit Vendors | VarChar | Y) Yes N) No | 1 | ||||
| WkoStatus | Old Work Order Status | VarChar | Y) Yes N) No | 1 | ||||
| DispTrByDf | Display Transactions by Dflt | VarChar | Y) Yes N) No | 1 | Y | |||
| stampTax | Default Stamp Tax | nVarChar | 8 | OVTG Tax Definition | ||||
| MinAmntAL | Minimum Amount for Annual List | Num | 20 | |||||
| BlockZeroQ | Block Stock Negative Quantity | VarChar | Y) Yes N) No | 1 | Y | |||
| AutoCrIns | Auto Create Customer Eq Card | VarChar | Y) Yes N) No | 1 | N | |||
| EnbRepomo | Enable Inflation for Cash Act | VarChar | Y) Yes N) No | 1 | ||||
| RFCValidat | Enable RFC Validations | VarChar | Y) Yes N) No | 1 | ||||
| MxDcsInPmt | Max. Number of Documents in Payment | Int | 11 | 0 | ||||
| RelStkNoPr | Enable Stock Release without Item Cost | VarChar | Y) Yes N) No | 1 | N | |||
| CashDisc | Cash Discount In Document | VarChar | Y) Yes N) No | 1 | ||||
| EnableSMS | Enable SMS | VarChar | Y) Yes N) No | 1 | ||||
| EnblIndic | Enable Indicator | VarChar | Y) Yes N) No | 1 | ||||
| EnbFedTax | Enable Federal Tax ID | VarChar | Y) Yes N) No | 1 | ||||
| EnblCounty | Enable County | VarChar | Y) Yes N) No | 1 | ||||
| Language | Language on Create Company | Int | 6 | |||||
| ChkIntgUpd | Check Data Integrity On Update | VarChar | Y) Yes N) No | 1 | Y | |||
| ChkIntgCre | Check Data Integrity On Create | VarChar | Y) Yes N) No | 1 | Y | |||
| BisBnkAcKy | BISR Bank Account Key | Int | 11 | DSC1 House Bank Accounts | ||||
| EnbZeroDec | Enable Print Check Show Zero Decimal | VarChar | Y) Yes N) No | 1 | N | |||
| EnbDecWord | Show Check Decimal in Words | VarChar | Y) Yes N) No | 1 | Y | |||
| ChkWrdOnly | Add the Word Only in Checks | VarChar | Y) Yes N) No | 1 | ||||
| EnBnkStmnt | Bank Statement Processing | VarChar | Y) Yes N) No | 1 | N | |||
| CalcVatGrp | Group Lines in VAT Calculation | VarChar | Y) Yes N) No | 1 | ||||
| TaxSysType | Defines Tax Calculation System | VarChar | A) Preconfigured Formula with Jurisdiction Support B) User-Defined Formula C) Preconfigured Formula M) Fixed Implementation with Jurisdiction Support S) Fixed Implementation | 1 | ||||
| ESEnabled | Is Event Sender enabled? | VarChar | Y) Yes N) No C) Customize | 1 | N | |||
| RateTotal | Use rate for minor total calc. | VarChar | N) No Y) Yes | 1 | N | |||
| CompanyHis | Create/Upgrade History | Text | 16 | |||||
| EnblAssVal | Enable Assessable Value | VarChar | Y) Yes N) No | 1 | N | |||
| CompanySta | Company Status | VarChar | V) Valid I) Invalid U) Upgrading A) Archived S) Inventory Valuation Utility P) Upgrade Simulation | 1 | U | |||
| eFRTActLvs | No. of Levels in Elect. FRT | Int | 11 | |||||
| TaxGrpType | Defines Tax Grouping Type | VarChar | C) Code J) Jurisdiction | 1 | C | |||
| InstallNo | Installation Number | nVarChar | 30 | |||||
| IsOldPA | Is Old for PA | VarChar | N) No Y) Yes | 1 | N | |||
| EnbNegDoc | Enable Negative Total in Doc | VarChar | 1 | |||||
| Algo | Encryption Algorithm | Int | 6 | |||||
| ArcComp | Archived Company | VarChar | Y) Yes N) No | 1 | N | |||
| UpdatedTF | Is Updated Tax Formula | VarChar | N) No Y) Yes | 1 | N | |||
| DARDBGUID | Readonly DB GUID for Archiving | nVarChar | 32 | |||||
| NegStoLv | Negative Inv.: Check Level | VarChar | C) Company W) Warehouse I) Item Setting | 1 | I | |||
| SPNEnabled | Enable Transact. Notification | VarChar | 1 | Y | ||||
| PrsWkCntEb | Personal Work Center Enabled | VarChar | N) No Cockpit Y) Normal Style Cockpit F) Fiori Style Cockpit | 1 | N | |||
| DashbdEb | Dashboard Enabled | VarChar | Y) Yes N) No | 1 | N | |||
| BoxEffDate | Box: Effective From Date | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| SnapShotId | Snapshot ID | Int | 11 | 0 | ||||
| CreatedBy | Created By | VarChar | N) P) Solution Packager W) Express Configuration Wizard | 1 | N | |||
| B1SgtEb | B1 Suggest: Enable | VarChar | 1 | N | ||||
| IsHConEnv | Is in High Concurrency Env | VarChar | Y) Yes N) No D) High Throughput | 1 | N | |||
| B1BuzzEb | Enable Streamwork Widget | VarChar | 1 | N | ||||
| IMCEEnable | IMCE Enable | VarChar | Y) Yes N) No | 1 | N | |||
| DKeyId | Current Dynamic Key ID | nVarChar | 127 | |||||
| ResetDData | Reset Dyn. Key Data to Default | VarChar | 1 | N | ||||
| ConvDifAct | Enable Conversion Diff. Acct | VarChar | Y) Yes N) No | 1 | Y | |||
| BasEffDate | Base Effective From Date | Date | 8 | |||||
| oldFxAss | Has Used Old Fixed Assets | VarChar | Y) Yes N) No | 1 | N | |||
| MaxRowsCFL | Max. Rows for Choose from List | Int | 0 5000) 5000 10000) 10000 50000) 50000 100000) 100000 | 11 | 0 | |||
| ColSel | Column Selection | Text | 16 | |||||
| EnblSPEDUF | Enable SPED Related UDFs | VarChar | Y) Yes N) No | 1 | N | |||
| DpmAffTot | Down Payment Affects Total | VarChar | Y) Yes N) No | 1 | Y | |||
| AliasUpd | Installation Date | nVarChar | 127 | |||||
| TrailDays | Trial Days | Int | 6 | |||||
| TestComp | Test Comp. | VarChar | N) No Y) Yes | 1 | N | |||
| DashConf | Enable Side Bar | Text | 16 | |||||
| SideEnable | Enable Side Bar | VarChar | Y) Yes N) No | 1 | N | |||
| IsPALInit | Is PAL Init. or Not | VarChar | 1 | N | ||||
| PANAVer | Pervasive Version | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
AINF.Version AS 'Version',
AINF.CompnyName AS 'Company Name',
AINF.Flags AS 'Flags',
AINF.InfoL1 AS 'Info L1',
AINF.InfoL2 AS 'Info L2',
AINF.InfoA1 AS 'Info A1',
AINF.InfoA2 AS 'Info A2',
AINF.ACTStamp AS 'ACT Stamp',
AINF.ADMStamp AS '((',
AINF.RTTStamp AS 'RTT Stamp',
AINF.CINFStamp AS 'CINF Stamp',
AINF.LawsSet AS 'Laws Set',
AINF.EnblVatGrp AS 'Tax System',
AINF.EnblVTGPmn AS 'Use Tax Groups in Payments',
AINF.VatOOS_O AS 'Tax Definition',
AINF.VatOOS_I AS 'Tax Exempt Revenue Account',
AINF.VatStnd_O AS 'Tax Standard O',
AINF.VatStnd_I AS 'Tax Standard I',
AINF.VatExmpt_O AS 'Tax Exempt O',
AINF.VatExmpt_I AS 'Tax Exempt I',
AINF.VatHalf_O AS 'Tax Definition',
AINF.VatHalf_I AS 'Tax Definition',
AINF.VatZrRt_O AS 'Tax Zero Rate O',
AINF.VatZrRt_I AS 'Tax Zero Rate I',
AINF.MaxActGrps AS 'Max. No. of Account Groups',
AINF.EnblDctSrc AS 'Enable Deduction at Source',
AINF.EnblRCN AS 'Enable Retail Chain Stores',
AINF.EnblCorINV AS 'Enable Correction Invoice',
AINF.EnblCshRep AS 'Enable Cash Report',
AINF.EnblIRTRep AS 'Enable Interest Report',
AINF.EnblTrnRep AS 'Enable Turnover Report',
AINF.EnblVPMRep AS 'Enable Payments Report',
AINF.EnblACTRep AS 'Enable Adv. Corp. Tax Report',
AINF.EnblFTZ AS 'Enable Free Trade Zone',
AINF.EnblSlfPCH AS 'Enable Self A/P Invoice',
AINF.EnblPCHUpd AS 'Enable Purchase Trans. Update',
AINF.EnblRsvINV AS 'Enable Reserve Invoice',
AINF.EnblRTDnld AS 'Enable Rates Download',
AINF.RTTDnldAdr AS 'Rates Download Web Address',
AINF.ZPrcCode AS 'Zero Center Code',
AINF.EnblExpns AS 'Enable Freight Management',
AINF.EnblRtrRep AS 'Enable Returns Report',
AINF.IsEC AS 'European Countries',
AINF.EnblCshDsc AS 'Enable Cash Discounts',
AINF.EnblLostCD AS 'Enable Lost Cash Discount',
AINF.NumActLvls AS 'No. of Account Group Levels',
AINF.EnblRealRD AS 'Enable Realized Rate Diff.',
AINF.EnblVTGNoD AS 'Enable Tax on Down Payment',
AINF.EnblGLManP AS 'Enable Manual Postings in Control Accoun',
AINF.EnblOptVIP AS 'Enable Optional Tax in Payments',
AINF.EnblActCrC AS 'Enable Account Currency Change',
AINF.EnblFrnAct AS 'Enable Foreign Item Account',
AINF.EnblECAct AS 'Enable EU Item Account',
AINF.EnblECRpt AS 'Enable 349 Report',
AINF.EnblRound AS 'Enable Rounding',
AINF.EnblPrVatS AS 'Enable Print Tax Amount',
AINF.EnblYrTrns AS 'Enable Year Transfer',
AINF.EnblActTtl AS 'Enable Account Title',
AINF.EnblDocWrn AS 'Enable No Base Doc. Alert',
AINF.ActSegNum AS 'No. of Segments',
AINF.EnbSgmnAct AS 'Enable Account Segmentation',
AINF.SizeOfSeg0 AS 'Size of Segment 0',
AINF.SizeOfSeg1 AS 'Size of Segment 1',
AINF.SizeOfSeg2 AS 'Size of Segment 2',
AINF.SizeOfSeg3 AS 'Size of Segment 3',
AINF.SizeOfSeg4 AS 'Size of Segment 4',
AINF.SizeOfSeg5 AS 'Size of Segment 5',
AINF.SizeOfSeg6 AS 'Size of Segment 6',
AINF.SizeOfSeg7 AS 'Size of Segment 7',
AINF.SizeOfSeg8 AS 'Size of Segment 8',
AINF.SizeOfSeg9 AS 'Size of Segment 9',
AINF.Rprt1099 AS '1099 Report',
AINF.MultiAddss AS 'Multi Address',
AINF.EnbDunning AS 'Enable Dunning',
AINF.EnbQtyEDln AS 'Allow Qty in Delivery Note to Exceed Bas',
AINF.Itw1Date AS 'Next Alert Date',
AINF.Itw1Time AS 'Next Alert Time',
AINF.Itw1Count AS 'ITW1 Counter',
AINF.EnbPayRef AS 'Calculate Payment Ref. No.',
AINF.EnblDfrTax AS 'Enable Deferred Tax',
AINF.EnblClsPr AS 'Enable Period-End Closing',
AINF.EnblTaxEL AS 'Enable Tax Exemption Letter',
AINF.EnableBOE AS 'Enable Bills of Exchange',
AINF.EnableWHT AS 'Enable WTax',
AINF.EnblEquVat AS 'Enable Equalization Tax',
AINF.EnblFAsset AS 'Enable Fixed Assets',
AINF.EnblDoubt AS 'Enable Doubtful Debts',
AINF.RateBase AS 'Base Date for Exchange Rate',
AINF.BOEStatClo AS 'Allow Closed Status for Bill of Exchange',
AINF.ARDocsInWT AS 'Enable WTax in A/R Docs',
AINF.BISBnkCnt AS 'BISR Bank Country',
AINF.BISRBnkCd AS 'BISR Bank No.',
AINF.BISRBnkAc AS 'BISR Bank Account',
AINF.BISRBranch AS 'BISR Branch',
AINF.EnblBPConn AS 'Enable BP Cards Connection',
AINF.EnblVATDat AS 'Enable VAT Date',
AINF.EnblStAgRp AS 'Enable Stock Aging Report',
AINF.EnblCARepo AS 'Enable Control Acct Reposting',
AINF.EnblMatRev AS 'Enable Inventory Revaluation',
AINF.EnblMBPRec AS 'Enable Multiple BPs Reconcil.',
AINF.CshDscGros AS 'Cash Discount Flag For CN, HK',
AINF.EnblTaxInv AS 'Enable Tax Invoices',
AINF.EnblCorAct AS 'Enable Correspondence of Accts',
AINF.EnblRuDIP AS 'Enable RU Delivery & Invoice',
AINF.EnblCurDec AS 'Enable Decimal Places',
AINF.EnblPayMtd AS 'Enable Payment Method on Inv.',
AINF.EnblBaseUn AS 'Enable UoM on Invoice',
AINF.EnblVATAna AS 'Enable VAT Analytics Report',
AINF.EnblExREnh AS 'Enable Frgn. Curr. Valuation',
AINF.VATGrpCal AS 'Enable VAT Calculation by Grp',
AINF.MaxChoose AS 'No. of Choose from List Rows',
AINF.EnblInfla AS 'Enable Inflation',
AINF.EnblLAWHT AS 'Enable Latin America WHT',
AINF.EnblRTWHT AS 'Enable Rounding Type WHT',
AINF.ChkQunty AS 'Enable Check Quantity In RDR',
AINF.SriMngSys AS 'SRI Management System',
AINF.BtchMngSys AS 'Batch Management System',
AINF.SriCreatIn AS 'Auto SRI creation on receipt',
AINF.EnblFolio AS 'Enable Folio Numbers',
AINF.EnblDocSbT AS 'Enable Document Subtype',
AINF.IepsPayer AS 'IEPS Payers',
AINF.DaysOrdCnc AS 'Default Days for Ord. Canc.',
AINF.EnblLATaxS AS 'Enable Latin America Tax Sys',
AINF.PercOfAcq AS 'Percent of Total Acquisition',
AINF.MinBaseDoc AS 'Minimum Base Amount per Doc',
AINF.EnblDpmJdt AS 'Create JE Rows in Down Pmnt',
AINF.EnblDownP AS 'Down Payment',
AINF.EnblNDdctC AS 'Enable Non Deduct VAT Per Card',
AINF.DocNmMtd AS 'Enable Sharing Series',
AINF.DoFilter AS 'Data Ownership Indication',
AINF.EnblOnPDCh AS 'Enable Opened Postdated Checks',
AINF.EnblOnWnCr AS 'Open Window for Credit Voucher',
AINF.EnblDefInx AS 'Enable Define Indexes',
AINF.EnblMxComm AS 'Enable Max Commitment',
AINF.EnblIndxOp AS 'Enable Index Option',
AINF.EnblSbtCVo AS 'Enable Submit Credit Voucher',
AINF.MinAmntOAP AS 'Minimum Amount for Appndix O&P',
AINF.CredSumm AS 'Credit Card Summary',
AINF.PostdChk AS 'Postdated Check',
AINF.PostdCred AS 'Postdated Credit Voucher',
AINF.CredVend AS 'Credit Vendors',
AINF.WkoStatus AS 'Old Work Order Status',
AINF.DispTrByDf AS 'Display Transactions by Dflt',
AINF.stampTax AS 'Default Stamp Tax',
AINF.MinAmntAL AS 'Minimum Amount for Annual List',
AINF.BlockZeroQ AS 'Block Stock Negative Quantity',
AINF.AutoCrIns AS 'Auto Create Customer Eq Card',
AINF.EnbRepomo AS 'Enable Inflation for Cash Act',
AINF.RFCValidat AS 'Enable RFC Validations',
AINF.MxDcsInPmt AS 'Max. Number of Documents in Payment',
AINF.RelStkNoPr AS 'Enable Stock Release without Item Cost',
AINF.CashDisc AS 'Cash Discount In Document',
AINF.EnableSMS AS 'Enable SMS',
AINF.EnblIndic AS 'Enable Indicator',
AINF.EnbFedTax AS 'Enable Federal Tax ID',
AINF.EnblCounty AS 'Enable County',
AINF.Language AS 'Language on Create Company',
AINF.ChkIntgUpd AS 'Check Data Integrity On Update',
AINF.ChkIntgCre AS 'Check Data Integrity On Create',
AINF.BisBnkAcKy AS 'BISR Bank Account Key',
AINF.EnbZeroDec AS 'Enable Print Check Show Zero Decimal',
AINF.EnbDecWord AS 'Show Check Decimal in Words',
AINF.ChkWrdOnly AS 'Add the Word Only in Checks',
AINF.EnBnkStmnt AS 'Bank Statement Processing',
AINF.CalcVatGrp AS 'Group Lines in VAT Calculation',
AINF.TaxSysType AS 'Defines Tax Calculation System',
AINF.ESEnabled AS 'Is Event Sender enabled?',
AINF.RateTotal AS 'Use rate for minor total calc.',
AINF.CompanyHis AS 'Create/Upgrade History',
AINF.EnblAssVal AS 'Enable Assessable Value',
AINF.CompanySta AS 'Company Status',
AINF.eFRTActLvs AS 'No. of Levels in Elect. FRT',
AINF.TaxGrpType AS 'Defines Tax Grouping Type',
AINF.InstallNo AS 'Installation Number',
AINF.IsOldPA AS 'Is Old for PA',
AINF.EnbNegDoc AS 'Enable Negative Total in Doc',
AINF.Algo AS 'Encryption Algorithm',
AINF.ArcComp AS 'Archived Company',
AINF.UpdatedTF AS 'Is Updated Tax Formula',
AINF.DARDBGUID AS 'Readonly DB GUID for Archiving',
AINF.NegStoLv AS 'Negative Inv.: Check Level',
AINF.SPNEnabled AS 'Enable Transact. Notification',
AINF.PrsWkCntEb AS 'Personal Work Center Enabled',
AINF.DashbdEb AS 'Dashboard Enabled',
AINF.BoxEffDate AS 'Box: Effective From Date',
AINF.LogInstanc AS 'Log Instance',
AINF.UpdateDate AS 'Date of Update',
AINF.UserSign2 AS 'Updating User',
AINF.SnapShotId AS 'Snapshot ID',
AINF.CreatedBy AS 'Created By',
AINF.B1SgtEb AS 'B1 Suggest: Enable',
AINF.IsHConEnv AS 'Is in High Concurrency Env',
AINF.B1BuzzEb AS 'Enable Streamwork Widget',
AINF.IMCEEnable AS 'IMCE Enable',
AINF.DKeyId AS 'Current Dynamic Key ID',
AINF.ResetDData AS 'Reset Dyn. Key Data to Default',
AINF.ConvDifAct AS 'Enable Conversion Diff. Acct',
AINF.BasEffDate AS 'Base Effective From Date',
AINF.oldFxAss AS 'Has Used Old Fixed Assets',
AINF.MaxRowsCFL AS 'Max. Rows for Choose from List',
AINF.ColSel AS 'Column Selection',
AINF.EnblSPEDUF AS 'Enable SPED Related UDFs',
AINF.DpmAffTot AS 'Down Payment Affects Total',
AINF.AliasUpd AS 'Installation Date',
AINF.TrailDays AS 'Trial Days',
AINF.TestComp AS 'Test Comp.',
AINF.DashConf AS 'Enable Side Bar',
AINF.SideEnable AS 'Enable Side Bar',
AINF.IsPALInit AS 'Is PAL Init. or Not',
AINF.PANAVer AS 'Pervasive Version'
FROM AINF AS AINF
Related information
House Bank Accounts DSC1 SQL Table
Tax Definition OVTG SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
