Dynamický dotaz - DPH - Evidence režimu Dobrovolného zaplacení daně na vstupu

ID:

FUE1UUESHD1430PKLSZMRUGPOS

Datasety

MAIN

Popis:

DPH - Evidence režimu Dobrovolného zaplacení daně na vstupu

SQL definice:

SELECT
  DQ.DocumentType AS DocumentType,
  MAX(P.ID) AS DocID,
  MAX(P.Firm_ID) AS Firm_ID,
  F.VATIdentNumber AS VATIdentNumber,
  MAX(P.VATDate$DATE) AS VATDate$DATE,
  MAX(P.DocDate$DATE) AS DocDate$DATE,
  SUM(A.LocalTAmountWithoutVAT) AS LocalAmountWithoutVAT,
  SUM(A.LocalTAmount) AS LocalAmount,
  SUM(A.TAmountWithoutVAT) AS AmountWithoutVAT,
  SUM(A.TAmount) AS Amount,
  MAX(DQ.Code || '-' || CAST(P.OrdNumber AS VARCHAR(10)) || '/' || PE.Code) AS DocNumber,
  MAX(P.VATVoluntaryPaid) AS VATVoluntaryPaid
FROM
  ReceivedInvoices2 A
  JOIN ReceivedInvoices P ON P.ID=A.Parent_ID
  JOIN Firms F on F.ID = P.Firm_ID
  JOIN Periods PE ON PE.ID=P.Period_ID
  JOIN DocQueues DQ ON DQ.ID=P.DocQueue_ID
WHERE
  (P.VATVoluntaryPaid='A')
  and (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO})
{ANDWHERE}
GROUP BY
  F.VATIdentNumber,
  P.VATDate$DATE,
  DQ.DocumentType,
  P.ID
UNION ALL
SELECT
  DQ.DocumentType AS DocumentType,
  MAX(P.ID) AS DocID,
  MAX(P.Firm_ID) AS Firm_ID,
  F.VATIdentNumber AS VATIdentNumber,
  MAX(P.VATDate$DATE) AS VATDate$DATE,
  MAX(P.DocDate$DATE) AS DocDate$DATE,
  SUM(A.LocalTAmountWithoutVAT) AS LocalAmountWithoutVAT,
  SUM(A.LocalTAmount) AS LocalAmount,
  SUM(A.TAmountWithoutVAT) AS AmountWithoutVAT,
  SUM(A.TAmount) AS Amount,
  MAX(DQ.Code || '-' || CAST(P.OrdNumber AS VARCHAR(10)) || '/' || PE.Code) AS DocNumber,
  MAX(P.VATVoluntaryPaid) AS VATVoluntaryPaid
FROM
  VATReceivedDInvoices2 A
  JOIN VATReceivedDInvoices P ON P.ID=A.Parent_ID
  JOIN Firms F on F.ID = P.Firm_ID
  JOIN Periods PE ON PE.ID=P.Period_ID
  JOIN DocQueues DQ ON DQ.ID=P.DocQueue_ID
WHERE
  (P.VATVoluntaryPaid='A')
  and (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO})
{ANDWHERE}
GROUP BY
  F.VATIdentNumber,
  P.VATDate$DATE,
  DQ.DocumentType,
  P.ID
UNION ALL
SELECT
  DQ.DocumentType AS DocumentType,
  MAX(P.ID) AS DocID,
  MAX(P.Firm_ID) AS Firm_ID,
  F.VATIdentNumber AS VATIdentNumber,
  MAX(P.VATDate$DATE) AS VATDate$DATE,
  MAX(P.DocDate$DATE) AS DocDate$DATE,
  SUM(A.LocalTAmountWithoutVAT) AS LocalAmountWithoutVAT,
  SUM(A.LocalTAmount) AS LocalAmount,
  SUM(A.TAmountWithoutVAT) AS AmountWithoutVAT,
  SUM(A.TAmount) AS Amount,
  MAX(DQ.Code || '-' || CAST(P.OrdNumber AS VARCHAR(10)) || '/' || PE.Code) AS DocNumber,
  MAX(P.VATVoluntaryPaid) AS VATVoluntaryPaid
FROM
  CashPaid2 A
  JOIN CashPaid P ON P.ID=A.Parent_ID
  JOIN Firms F on F.ID = P.Firm_ID
  JOIN Periods PE ON PE.ID=P.Period_ID
  JOIN DocQueues DQ ON DQ.ID=P.DocQueue_ID
WHERE
  (P.VATVoluntaryPaid='A')
  and (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO})
{ANDWHERE}
GROUP BY
  F.VATIdentNumber,
  P.VATDate$DATE,
  DQ.DocumentType,
  P.ID
UNION ALL
SELECT
  DQ.DocumentType AS DocumentType,
  MAX(P.ID) AS DocID,
  MAX(P.Firm_ID) AS Firm_ID,
  F.VATIdentNumber AS VATIdentNumber,
  MAX(P.VATDate$DATE) AS VATDate$DATE,
  MAX(P.DocDate$DATE) AS DocDate$DATE,
  SUM(A.LocalTAmountWithoutVAT) AS LocalAmountWithoutVAT,
  SUM(A.LocalTAmount) AS LocalAmount,
  SUM(A.TAmountWithoutVAT) AS AmountWithoutVAT,
  SUM(A.TAmount) AS Amount,
  MAX(DQ.Code || '-' || CAST(P.OrdNumber AS VARCHAR(10)) || '/' || PE.Code) AS DocNumber,
  MAX(P.VATVoluntaryPaid) AS VATVoluntaryPaid
FROM
  OtherExpenses2 A
  JOIN OtherExpenses P ON P.ID=A.Parent_ID
  JOIN Firms F on F.ID = P.Firm_ID
  JOIN Periods PE ON PE.ID=P.Period_ID
  JOIN DocQueues DQ ON DQ.ID=P.DocQueue_ID
WHERE
  (P.VATVoluntaryPaid='A')
  and (P.VATDate$Date >= {$DATE_FROM} and P.VATDate$Date < {$DATE_TO})
{ANDWHERE}
GROUP BY
  F.VATIdentNumber,
  P.VATDate$DATE,
  DQ.DocumentType,
  P.ID
ORDER BY 4,5,1,2

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
Amount	dtFloat	15			Částka
AmountWithoutVAT	dtString	5			Částka bez daně
DocDate$DATE	dtDateTime	10			Datum dokladu
DocID	dtString	10			ID dokladu
DocNumber	dtString	16			Číslo dokladu
DocumentType	dtString	2			Typ dokladu
Firm_ID	dtString	10		4K3EXM5PQBCL35CH000ILPWJF4	Firma
LocalAmount	dtFloat	15			Částka lokální
LocalAmountWithoutVAT	dtFloat	10			Částka bez daně lokální
VATDate$DATE	dtDateTime	10			Datum plnění
VATIdentNumber	dtString	15			DIČ
VATVoluntaryPaid	dtString	10			Dobrovolné zapl. daně

ReceivedInvoices

Popis:

Faktury přijaté

SQL definice:

SELECT {FIELDS} 
FROM
  ReceivedInvoices A 
WHERE
  (:DocumentType='04')
  and A.ID=:DocID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	42HE04FZGJD13ACM03KIU0CLP4

CashPaid

Popis:

Pokladna výdej

SQL definice:

SELECT {FIELDS} 
FROM
  CashPaid A 
WHERE
  (:DocumentType='06')
  and A.ID=:DocID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	0RXJZGDLBBDL3ACR03KIU0CLP4

VATReceivedDInvoices

Popis:

Daňové zálohové listy přijaté

SQL definice:

SELECT {FIELDS} 
FROM
  VATReceivedDInvoices A 
WHERE
  (:DocumentType='63')
  and A.ID=:DocID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	ZJYWUH5I34J4VAAIHOB0ZA1FIO

OtherExpenses

Popis:

Ostatní výdaje

SQL definice:

SELECT {FIELDS} 
FROM
  OtherExpenses A 
WHERE
  (:DocumentType='02')
  and A.ID=:DocID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	1DHHWWVMXVD13ACQ03KIU0CLP4

Podmínky

VATDate

Popiska:

Datum

Typ/Subtyp:

ctDateTime/0

ckRange:

P.VATDate$DATE >= {:LOW} and
P.VATDate$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

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