isiweb:selects_-_customers

L'envoi a échoué. Les autorisations sont-elles correctes ?

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

isiweb:selects_-_customers [2019/08/28 09:10] (Version actuelle)
Ligne 1: Ligne 1:
 +==== MySql ====
  
 +SELECT
 +  AuthGroup.name AS A,
 +  AuthGroup.name AS B,
 +  Abstractcompany.Businessid AS C,
 +  'nl' AS D,
 +  Company.Companynumber AS E,
 +  'BE' AS F,
 +  Convention.tvaCode AS G,
 +  BusinessEntityCompany.Name AS H,
 +  AbstractCompany.mainContactMedias_Address_Street AS I,
 +  AbstractCompany.mainContactMedias_Address_Number AS J,
 +  AbstractCompany.mainContactMedias_Address_Box AS K,
 +  City.ZipCode AS L,
 +  City_Translations.Label AS M,
 +  AbstractCompany.mainContactmedias_phone AS N,
 +  AbstractCompany.mainContactmedias_fax   AS O,
 +  '' AS P,
 +  CONCAT(LPAD(payment_term.daysCount,2,'0'), " ", payment_term.paymenttermtype) as Q,
 +  payment_term.paymenttermtype,
 +  convention.paymenttermid,
 +  AbstractCompany.mainContactMedias_Address_CityId,
 +  Invoice.Convention,
 +  Invoice.Businessid,
 +  Convention.Companyid,
 +  BusinessEntityCompany.Defaultgroupid
 +FROM
 +  Invoice,
 +  Convention,
 +  businessentitycompany,
 +  authgroup,
 +  abstractcompany,
 +  city,
 +  city_translations,
 +  payment_term,
 +company
 +WHERE
 +  Convention.id = Invoice.convention
 +  AND  Businessentitycompany.id = convention.companyid
 +  AND  AuthGroup.id = Businessentitycompany.defaultgroupid
 +  AND  AbstractCompany.AbstractCompanyId = convention.companyid
 +  AND  convention.paymentTermId = payment_term.id
 +  AND  company.companyid = convention.companyid
 +  AND  City.Id = AbstractCompany.mainContactMedias_Address_CityId
 +  AND  City_Translations.id = City.Id
 +  AND  City_Translations.locale = 'nl'
 +  AND  Invoice.AccountingExportBatchid = 1;
  • isiweb/selects_-_customers.txt
  • Dernière modification: 2019/08/28 09:10
  • (modification externe)