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

ID:

XQC2FYQVQM2OV5X51HHU2GN0OS

Datasety

MAIN

Popis:

DPH - Evidence režimu Dobrovolného zaplacení daně na výstupu

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
  IssuedInvoices2 A
  JOIN IssuedInvoices 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 (A.RowType IN (1,2,3,4,5))
  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
  VATIssuedDInvoices2 A
  JOIN VATIssuedDInvoices 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 (A.RowType IN (1,2,3,4,5))
  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
  CashReceived2 A
  JOIN CashReceived 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 (A.RowType IN (1,2,3,4,5))
  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
  OtherIncomes2 A
  JOIN OtherIncomes 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ě

IssuedInvoices

Popis:

Faktury vydané

SQL definice:

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

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	O3BDOKTWEFD13ACM03KIU0CLP4

CashReceived

Popis:

Pokladna příjem

SQL definice:

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

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	WG02MSU3BBDL3ACR03KIU0CLP4

VATIssuedDInvoices

Popis:

Daňové zálohové listy vydané

SQL definice:

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

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	S3YFE5QQNYQORJXLJWXDL3QV0K

OtherIncomes

Popis:

Ostatní příjmy

SQL definice:

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

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	0LHHWWVMXVD13ACQ03KIU0CLP4

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

Nadřízený:

Rows

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