Formules et queries disponibles pour la fusion des documents

  • BankAccount.Number
  • CapitalShareholderList
  • CapitalShareholderRepresentativeList
  • CapitalShareholderRepresentativeWithAddressListFR
  • CapitalShareholderRepresentativeWithAddressListEN
  • Client.FileNumber
  • Company.Name
  • CompPers.Rel = Destinataire des factures.FirstName
  • CompPers.Rel = Destinataire des factures.LastName
  • CompPers.Rel = Destinataire des factures.Name
  • CompPers.Rel = Destinataire des factures.Title
  • CompPers.Fax
  • CompPers.LegalCountry.Name
  • CompPers.MailCountry.Name
  • CompPers.MailHouseNum
  • CompPers.MailLocality
  • CompPers.MailPostalCode
  • CompPers.MailStreet
  • CompPers.Name
  • CompPers.telephone1
  • Job.Number
  • Licence.Name
  • Login.Name
  • NetworkAlias
  • Person.Name
  • PrtArticle
  • PrtFixedAssetsIntangible
  • PrtFixedAssetsIntangibleByAccount
  • PrtFixedAssetsIntangibleOnlyRateAndMode
  • PrtFixedAssetsTangible
  • PrtFixedAssetsTangibleByAccount
  • PrtFixedAssetsTangibleOnlyRateAndMode
  • PrtGLCaption
  • Reminder.CompanyNameAndAddress
  • Reminder.CompanyName
  • Reminder.CompanyAddress
  • Reminder.DirectorNameAndAddressListEN
  • Reminder.DirectorNameAndAddressListFR
  • Reminder.DirectorNameListActiveEN
  • Reminder.DirectorNameListActiveFR
  • Reminder.ReminderDateEN
  • Reminder.ReminderDateFR
  • Reminder.StatutoryAuditorNameAndAddressListEN
  • Reminder.StatutoryAuditorNameAndAddressListFR
  • Reminder.ToTime
  • ReminderDetail.CalcResult
  • ReminderDetail.GLPeriodEndDateEN
  • ReminderDetail.GLPeriodEndDateFR
  • ReminderDetail.GLPeriodEndDateStr
  • ReminderDetail.GLPeriodStartDateEN
  • ReminderDetail.GLPeriodStartDateFR
  • ReminderDetail.GLPeriodStartDateStr
  • ReminderDetail.ResultAllocation
  • ReminderDetail.TotalBalanceSheet
  • ReminderDetail.TotalExpenses
  • ReminderDetail.TotalRevenues
  • ReminderDetailRelation.DirectorNameList
  • ReminderDetailRelation.DirectorNameAndAddressListEN
  • ReminderDetailRelation.DirectorNameAndAddressListFR
  • ReminderDetailRelation.DirectorNominationNameAndAddressListEN
  • ReminderDetailRelation.DirectorNominationNameAndAddressListFR
  • ReminderDetailRelation.ShareholderName
  • ReminderDetailRelation.ShareholderNameAndAddressEN
  • ReminderDetailRelation.ShareholderNameAndAddressFR
  • ReminderDetailRelation.ShareholderShareQty
  • ReminderDetailRelation.StatutoryAuditorNameAndAddressListEN
  • ReminderDetailRelation.StatutoryAuditorNameAndAddressListFR
  • ReminderDirectorList
  • ReminderDirectorListWithDate
  • ReminderShareholderListWithDate
  • ReminderDetailRelation.ShareholderListWithText
  • ReminderDetailRelation.StatutoryNominationName
  • ReminderDetailRelation.DirectorNameListWithText
  • ReminderDetailRelation.PresidentName
  • ReminderDetailRelation.DirectorNameListWithLongText
  • User.Checksum
  • User.DocumentPathFileName
  • User.EndDate
  • User.FirstName
  • User.Id
  • User.Language
  • User.LastName
  • User.LoginDBId
  • User.LoginLastPWChange
  • User.LoginName
  • User.LoginPassword
  • User.LoginPasswordTry
  • User.LoginSerialNumber
  • User.LoginTime
  • User.LoginWorkstation
  • User.LogoutTime
  • User.Message
  • User.Name
  • User.PhoneExtension
  • User.ReportLanguageId
  • User.StartDate
  • User.UtilsHelpPathFileName
  • Capital.TotalNominalAmount
  • Capital.TotalShareNum
  • Capital.ParValueOfShares
  • Capital.AuthorizedAmount
  • PeriodProfit
  • Accounting Status
  • CLTFILENBR
  • DOCDATE
  • DOCNBR
  • GET_DBLIST SORTED BY DBID
  • GET_DBLIST SORTED BY NAME
  • Query.Merge Client Company FileNumber
  • Query.Merge Client FileNumber
  • Query.Merge Get Actionnaire and Address
  • Query.Merge Get Actionnaire and Shares
  • Query.Merge Get Actionnaire Totshares
  • Query.Merge Get Active Company Bank Country
  • Query.Merge Get Active Company BankAccount Manager
  • Query.Merge Get Active Person Bank Country
  • Query.Merge Get Active Person BankAccount Manager
  • Query.Merge Get Administrateur and Enter
  • Query.Merge Get Administrateur and Tab
  • Query.Merge Get Administrateur et Gérant
  • Query.Merge Get Administrateur et Gérant signature
  • Query.Merge Get Administrateur Profession and Address
  • Query.Merge Get AGE Rem Memo
  • Query.Merge Get Agent suivi legal
  • Query.Merge Get Apporteur d’affaires
  • Query.Merge Get Bank Name
  • Query.Merge Get Bank Swift
  • Query.Merge Get BankAccount Description
  • Query.Merge Get BankAccount IBANNumber
  • Query.Merge Get BankAccount Name
  • Query.Merge Get BankAccount Number
  • Query.Merge Get BOD President
  • Query.Merge Get Client Company Name
  • Query.Merge Get Client Company relation manager
  • Query.Merge Get Client FileHolderEmployeeName
  • Query.Merge Get Client Legal Address
  • Query.Merge Get Client Legal Country
  • Query.Merge Get Client MemoField
  • Query.Merge Get Client Name
  • Query.Merge Get Client RCNum
  • Query.Merge Get Client relation manager
  • Query.Merge Get Commissaire aux comptes
  • Query.Merge Get Commissaire aux comptes et réviseur
  • Query.Merge Get Company Activity
  • Query.Merge Get Company Bank Country
  • Query.Merge Get Company BankAccount Manager
  • Query.Merge Get Company Capital and Currency
  • Query.Merge Get Company CompanyTypeLabel
  • Query.Merge Get Company Currency
  • Query.Merge Get Company EndDate
  • Query.Merge Get Company Entity List
  • Query.Merge Get Company Fax
  • Query.Merge Get Company Incorporation date
  • Query.Merge Get Company Issued Capital
  • Query.Merge Get Company LastAmendment
  • Query.Merge Get Company MemoField
  • Query.Merge Get Company Nationality
  • Query.Merge Get Company RCNum
  • Query.Merge Get Company SMDate
  • Query.Merge Get Company Telephone1
  • Query.Merge Get CompanyName_ReminderId
  • Query.Merge Get CompanyType Label
  • Query.Merge Get ComplianceMovement Beneficiary
  • Query.Merge Get ComplianceMovement Currency
  • Query.Merge Get ComplianceMovement CurrencyName
  • Query.Merge Get ComplianceMovement CyAmount
  • Query.Merge Get ComplianceMovement DestBank Swift
  • Query.Merge Get ComplianceMovement DestBankAccount
  • Query.Merge Get ComplianceMovement DestBankAccount IBAN
  • Query.Merge Get ComplianceMovement DestBankName
  • Query.Merge Get ComplianceMovement OrderingParty
  • Query.Merge Get ComplianceMovement OrderingParty Legal Address
  • Query.Merge Get ComplianceMovement OrgBank Address
  • Query.Merge Get ComplianceMovement OrgBankAccount
  • Query.Merge Get ComplianceMovement OrgBankAccount CompPersBankAccount Name
  • Query.Merge Get ComplianceMovement OrgBankContactName
  • Query.Merge Get ComplianceMovement OrgBankName
  • Query.Merge Get ComplianceMovement PaymentCommunication
  • Query.Merge Get CompPers FAX
  • Query.Merge Get CompPers Legal Address
  • Query.Merge Get CompPers Legal Address Enter
  • Query.Merge Get CompPers Name
  • Query.Merge Get CompPers Postal Code
  • Query.Merge Get CompPers Telephone1
  • Query.Merge Get CompPerson LegalCountry
  • Query.Merge Get CompPerson MailCountry
  • Query.Merge Get Comptable
  • Query.Merge Get Directors
  • Query.Merge Get Document Creation Date
  • Query.Merge Get Document Number
  • Query.Merge Get Document Reminder Date
  • Query.Merge Get Document Reminder Date and Time (French)
  • Query.Merge Get Document Reminder Time
  • Query.Merge Get Gérant and Enter
  • Query.Merge Get Gestionnaire
  • Query.Merge Get GLPeriod EndDate
  • Query.Merge Get GLPeriod Name (N)
  • Query.Merge Get GLPeriod Name (N-1)
  • Query.Merge Get GLPeriod StartDate
  • Query.Merge Get Job Number
  • Query.Merge Get Legal Address
  • Query.Merge Get Legal Address Licence
  • Query.Merge Get Legal Building
  • Query.Merge Get Legal Country
  • Query.Merge Get Legal COUNTRY and Rc
  • Query.Merge Get Legal CountryZip
  • Query.Merge Get Legal House and Street
  • Query.Merge Get Legal HouseNum
  • Query.Merge Get Legal Locality
  • Query.Merge Get Legal Locality of Notaire
  • Query.Merge Get Legal No Country PostalCode
  • Query.Merge Get Legal Postalcode and Country
  • Query.Merge Get Legal Street
  • Query.Merge Get Licence Company Activity
  • Query.Merge Get Licence COMPANY and COUNTRY
  • Query.Merge Get Licence Company GLPeriodEndDate
  • Query.Merge Get Licence Company GLPeriodStartDate
  • Query.Merge Get Licence Legal Address
  • Query.Merge Get Licence Legal Country
  • Query.Merge Get Licence Legal Locality
  • Query.Merge Get Licence Name
  • Query.Merge Get Login Name
  • Query.Merge Get Mail CountryZip
  • Query.Merge Get Mail House and Street
  • Query.Merge Get Mail Locality
  • Query.Merge Get Mail No Country PostalCode
  • Query.Merge Get Managers
  • Query.Merge Get Notaire
  • Query.Merge Get Organe de contrôle
  • Query.Merge Get PeriodProfit Label EN
  • Query.Merge Get PeriodProfit Label FR
  • Query.Merge Get PeriodProfit PrevYear Label EN
  • Query.Merge Get PeriodProfit PrevYear Label FR
  • Query.Merge Get Person Bank Country
  • Query.Merge Get Person BankAccount Manager
  • Query.Merge Get Person BDate
  • Query.Merge Get Person BPlace
  • Query.Merge Get Person Children FR info
  • Query.Merge Get Person CivilStatus
  • Query.Merge Get Person Entity List
  • Query.Merge Get Person FirstName
  • Query.Merge Get Person IdentityCard
  • Query.Merge Get Person IdentityCardEndDate
  • Query.Merge Get Person KYC SourceOfWealth
  • Query.Merge Get Person LastName
  • Query.Merge Get Person Legal Address
  • Query.Merge Get Person Legal Country
  • Query.Merge Get Person MemoField
  • Query.Merge Get Person Name
  • Query.Merge Get Person Nationality
  • Query.Merge Get Person Number
  • Query.Merge Get Person PassportNum
  • Query.Merge Get Person PassportNumEndDate
  • Query.Merge Get Person Profession
  • Query.Merge Get Person TaxVATNum
  • Query.Merge Get President
  • Query.Merge Get Président
  • Query.Merge Get President Locality
  • Query.Merge Get President Reminder
  • Query.Merge Get Previous Director
  • Query.Merge Get Previous Statutory Auditor
  • Query.Merge Get ProfitLossPeriod for Active Period
  • Query.Merge Get Rc
  • Query.Merge Get Reminder Currency
  • Query.Merge Get Reminder GLPeriodEndDate
  • Query.Merge Get Reminder GLPeriodStartDate
  • Query.Merge Get Reminder GLPeriodYear
  • Query.Merge Get Reminder TotShareholders
  • Query.Merge Get Reminder TotShares
  • Query.Merge Get Scrutateur
  • Query.Merge Get Scrutineer Reminder
  • Query.Merge Get Secretaire
  • Query.Merge Get Secrétaire
  • Query.Merge Get Secretary Reminder
  • Query.Merge Get Telephone1
  • Query.Merge Get the Capital Currency
  • Query.Merge Get the Version number
  • Query.Merge Get Total Expenses For Active Period
  • Query.Merge Get Total Revenues For Active Period
  • Query.MergeGetEmployeeOnJob
  • Query.MergeGetEmployeeonJobFromTask
  • Query.MergeGetJobOnTask
  • Query.MergeGetTaskLabel
  • Query.Merge Get Beneficiaire Economique
  • TAXNUMBER