Objektová akce

Kód:

6

Tělo:

SELECT
  SD2.TotalPrice as TotalPrice, 
  AC.CustomsAmount as CustomsAmount, 
  AC.CustomsIsLocal as CustomsIsLocal, 
  AC.CustomsTariff as CustomsTariff,
  AC.SpendingTaxAmount as SpendingTaxAmount, 
  AC.SpendingTaxIsLocal as SpendingTaxIsLocal, 
  AC.SpendingTaxTariff as SpendingTaxTariff,
  AC.TransportationAmount as TransportationAmount, 
  AC.TransportationIsLocal as TransportationIsLocal, 
  AC.TransportationTariff as TransportationTariff,
  AC.OtherCostAmount as OtherCostAmount, 
  AC.OtherCostIsLocal as OtherCostIsLocal, 
  AC.OtherCostTariff as OtherCostTariff
FROM
  StoreDocuments2 SD2
  JOIN AdditionalCosts AC ON SD2.AdditionalCosts_ID = AC.ID
WHERE
  (SD2.Parent_ID=:ID) AND
  (SD2.StoreCard_ID IS NOT NULL)

Generated by ABRA Software a.s. 27.10.2021 16:34:11