Dynamický dotaz - INTRASTAT - Export - Použité měny s nezadaným kurzem k prvnímu měsíci tištěného období v kurzovním lístku INTRASTAT

ID:

GMG4ZPP5SKUON5JWSNJWKMSCAO

Datasety

MAIN

Popis:

INTRASTAT - Export - Použité měny s nezadaným kurzem k prvnímu měsíci tištěného období v kurzovním lístku INTRASTAT

SQL definice:

SELECT
  P.Currency_ID as ID
FROM
  IssuedInvoices2 A
  JOIN IssuedInvoices P ON P.ID=A.Parent_ID
  LEFT JOIN IntrastatExchangeRates IEX on IEX.Currency_ID = P.Currency_ID
  JOIN Firms F on F.ID=P.Firm_ID
WHERE
  A.RowType=3 and
  A.ToIntrastat = 'A' and
  P.TradeType in (2, 4, 5, 6, 7, 8) and
  (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO}) and
  P.VATDocument = 'A' and
  (Select count(*) From IntrastatExchangeRates2 IEX2 where IEX2.Parent_ID=IEX.ID and IEX2.Date$DATE={$IntrastatExchangeRatesDate})=0 and
  P.Currency_ID <> {$LocalCurrency}
{ANDWHERE}
union
SELECT
  P.Currency_ID as ID
FROM
  CashReceived2 A
  JOIN CashReceived P ON P.ID=A.Parent_ID
  LEFT JOIN IntrastatExchangeRates IEX on IEX.Currency_ID = P.Currency_ID
  JOIN Firms F on F.ID=P.Firm_ID
WHERE
  A.RowType=3 and
  A.ToIntrastat = 'A' and
  P.TradeType in (2, 4, 5, 6, 7, 8) and
  (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO}) and
  P.VATDocument = 'A' and
  (Select count(*) From IntrastatExchangeRates2 IEX2 where IEX2.Parent_ID=IEX.ID and IEX2.Date$DATE={$IntrastatExchangeRatesDate})=0 and
  P.Currency_ID <> {$LocalCurrency}
{ANDWHERE}
union
SELECT
  P.Currency_ID as ID
FROM
  IssuedCreditNotes2 A
  JOIN IssuedCreditNotes P ON P.ID=A.Parent_ID
  LEFT JOIN IntrastatExchangeRates IEX on IEX.Currency_ID = P.Currency_ID
  JOIN Firms F on F.ID=P.Firm_ID
WHERE
  A.RowType=3 and
  A.ToIntrastat = 'A' and
  P.TradeType in (2, 4, 5, 6, 7, 8) and
  (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO}) and
  P.VATDocument = 'A' and
  (Select count(*) From IntrastatExchangeRates2 IEX2 where IEX2.Parent_ID=IEX.ID and IEX2.Date$DATE={$IntrastatExchangeRatesDate})=0 and
  P.Currency_ID <> {$LocalCurrency}
{ANDWHERE}
union
SELECT
  P.Currency_ID as ID
FROM
  RefundedCashReceived2 A
  JOIN RefundedCashReceived P ON P.ID=A.Parent_ID
  LEFT JOIN IntrastatExchangeRates IEX on IEX.Currency_ID = P.Currency_ID
  JOIN Firms F on F.ID=P.Firm_ID
WHERE
  A.RowType=3 and
  A.ToIntrastat = 'A' and
  P.TradeType in (2, 4, 5, 6, 7, 8) and
  (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO}) and
  P.VATDocument = 'A' and
  (Select count(*) From IntrastatExchangeRates2 IEX2 where IEX2.Parent_ID=IEX.ID and IEX2.Date$DATE={$IntrastatExchangeRatesDate})=0 and
  P.Currency_ID <> {$LocalCurrency}
{ANDWHERE}
union
SELECT
  P.Currency_ID as ID
FROM
  StoreDocuments2 A
  JOIN PMStates PMS ON A.PMState_ID=PMS.ID
  JOIN StoreDocuments P ON P.ID=A.Parent_ID
  LEFT JOIN IntrastatExchangeRates IEX on IEX.Currency_ID = P.Currency_ID
  JOIN Firms F on F.ID=P.Firm_ID
WHERE
  PMS.SystemState=3 AND 
  A.RowType=3 and
  A.ToIntrastat = 'A' and
  P.TradeType in (2, 4, 5, 6) and P.DocumentType IN ('20', '30') and
  (P.IntrastatDate$Date >= {$DATE_FROM} and P.IntrastatDate$Date < {$DATE_TO}) and
  (Select count(*) From IntrastatExchangeRates2 IEX2 where IEX2.Parent_ID=IEX.ID and IEX2.Date$DATE={$IntrastatExchangeRatesDate})=0 and
  P.Currency_ID <> {$LocalCurrency}
{ANDWHERE}
group by P.Currency_ID

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
ID	dtString	10		4R5FINKNYNDL3C5P00CA141B44	Měna

Podmínky

Date

Popiska:

Datum

Typ/Subtyp:

ctDateTime/0

ckRange:

P.DocDate$DATE >= {:LOW} and
P.DocDate$DATE < {:HIGH}

Dataset:

MAIN

Speciální parametry:

AlwaysUsed=True
ReplacementLink=True
{$DATE_FROM}=VALUE;0
{$DATE_TO}=VALUEHIGH;0

Division_ID

Šablona:

Division_ID

Dataset:

MAIN

Firm_ID

Šablona:

Firm_ID (joined)

Dataset:

MAIN

BusOrder_ID

Šablona:

BusOrder_ID

Dataset:

MAIN

BusTransaction_ID

Šablona:

BusTransaction_ID

Dataset:

MAIN

BusProject_ID

Šablona:

BusProject_ID

Dataset:

MAIN

CreatedBy_ID

Šablona:

CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID

Šablona:

CorrectedBy_ID

Dataset:

MAIN

Currency_ID

Šablona:

Currency_ID

Dataset:

MAIN

Country_ID

Šablona:

Country_ID - Target

Dataset:

MAIN

Store_ID

Šablona:

Store_ID

Dataset:

MAIN

StoreCard_ID

Šablona:

StoreCard_ID

Dataset:

MAIN

SmallArticles

Šablona:

SmallArticles

Dataset:

MAIN

Generated by ABRA Software a.s. 27.10.2021 16:36