Dynamický dotaz - Účetní deník - souvztažně - párovací znaky

ID:

UL1RBYNJE31OH3L5O2GVHRV004

Datasety

MAIN

Popis:

Účetní zápisy

SQL definice:

SELECT {FIELDS}
FROM (
  SELECT 
    A.ID,
    B.AccGroup_ID, 
    MAX(A.AccDate$DATE) OVER (PARTITION BY B.AccGroup_ID) AS AccDate$DATE,
    FIRST_VALUE(A.Firm_ID) OVER (PARTITION BY B.AccGroup_ID ORDER BY A.AccDate$DATE DESC) AS GroupFirm_ID
  FROM ( 
##QREXPRBEGIN#
  IF(({$ShowGroups} = 1) OR ({$ShowGroups} = 2), 
    '    SELECT B.AccGroup_ID FROM (', '')##QREXPREND#
      SELECT
        A.AccGroupCredit_ID AS AccGroup_ID
      FROM GENERALLEDGER A
##QREXPRBEGIN#
  IF({$GL3Used} = 'A',
        '      LEFT JOIN GeneralLedger3 GL3 ON GL3.ID = A.AccGroupCredit_ID', '')##QREXPREND#        
      {JOIN}
      WHERE
        A.IsRequest = 'N' AND A.CreditAccount_ID IN ({$AccountSelIDLIST})
##QREXPRBEGIN#
  IF({$IDUsed} = 'N',
          '        AND A.AccDate$DATE >= {$AccDateFrom} AND A.AccDate$DATE < {$AccDateTo}' + IF({$DivisionUsed} = 'A', ' AND A.CreditDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.CreditBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.CreditBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.CreditBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '')##QREXPREND# {ANDWHERE}
      UNION
      SELECT
        A.AccGroupDebit_ID AS AccGroup_ID
      FROM GENERALLEDGER A
##QREXPRBEGIN#
  IF({$GL3Used} = 'A',
        '      LEFT JOIN GeneralLedger3 GL3 ON GL3.ID = A.AccGroupCredit_ID', '')##QREXPREND#        
      {JOIN}  
      WHERE
        A.IsRequest = 'N' AND A.DebitAccount_ID IN ({$AccountSelIDLIST}) 
##QREXPRBEGIN#
  IF({$IDUsed} = 'N',
          '        AND A.AccDate$DATE >= {$AccDateFrom} AND A.AccDate$DATE < {$AccDateTo}' + IF({$DivisionUsed} = 'A', ' AND A.DebitDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.DebitBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.DebitBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.DebitBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '')##QREXPREND# {ANDWHERE}
##QREXPRBEGIN#
  IF(({$ShowGroups} = 1) OR ({$ShowGroups} = 2), 
    '    ) B' + NxCRLF +
    '    JOIN GENERALLEDGER A ON (B.ACCGROUP_ID = A.AccGroupCredit_ID OR B.ACCGROUP_ID = A.AccGroupDebit_ID)' + NxCRLF +
  IF({$GL3Used} = 'A',
    '    LEFT JOIN GeneralLedger3 GL3 ON GL3.ID = B.ACCGROUP_ID' + NxCRLF, '') +         
    '    {JOIN}' + NxCRLF +
    '    WHERE ' + NxCRLF +
    '      A.IsRequest = 'N' AND' + NxCRLF +
    '      (' + NxCRLF +
    '        (B.ACCGROUP_ID = A.AccGroupCredit_ID AND A.CreditAccount_ID IN ({$AccountSelIDLIST})' + IF({$WholeGroups} = 3, IF({$DivisionUsed} = 'A', ' AND A.CreditDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.CreditBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.CreditBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.CreditBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') + ') OR' + NxCRLF +
    '        (B.ACCGROUP_ID = A.AccGroupDebit_ID AND A.DebitAccount_ID IN ({$AccountSelIDLIST})' + IF({$WholeGroups} = 3, IF({$DivisionUsed} = 'A', ' AND A.DebitDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.DebitBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.DebitBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.DebitBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') + ')' + NxCRLF +
    ')' + NxCRLF +
  NxCase({$WholeGroups}, '', 
    '', '',  
    '      AND A.AccDate$DATE >= {$AccDateFrom} AND A.AccDate$DATE < {$AccDateTo}' + NxCRLF, 
    '      AND A.AccDate$DATE >= {$AccDateFrom} AND A.AccDate$DATE < {$AccDateTo} <<<ANDWHERE>>>'+ NxCRLF) +
    '    GROUP BY B.AccGroup_ID' + NxCRLF +
    '    HAVING SUM(' + NxCRLF +
    '      CASE WHEN (A.AccGroupCredit_ID = B.AccGroup_ID AND A.CreditAccount_ID IN ({$AccountSelIDLIST})' + IF({$WholeGroups} = 3, IF({$DivisionUsed} = 'A', ' AND A.CreditDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.CreditBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.CreditBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.CreditBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') + ') THEN A.Amount ELSE 0 END' + NxCRLF +
    '      ) - SUM(' + NxCRLF +
    '      CASE WHEN (A.AccGroupDebit_ID = B.AccGroup_ID AND A.DebitAccount_ID IN ({$AccountSelIDLIST})' + IF({$WholeGroups} = 3, IF({$DivisionUsed} = 'A', ' AND A.DebitDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.DebitBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.DebitBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.DebitBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') + ') THEN A.Amount ELSE 0 END' + NxCRLF +        
    '      )' + NxCase({$ShowGroups}, '', '', ' <> 0', ' = 0')    
  , '')##QREXPREND#
  ) B
  JOIN GENERALLEDGER A ON (B.ACCGROUP_ID = A.AccGroupCredit_ID OR B.ACCGROUP_ID = A.AccGroupDebit_ID) 
##QREXPRBEGIN#
  IF({$GL3Used} = 'A',
    '  LEFT JOIN GeneralLedger3 GL3 ON GL3.ID = B.ACCGROUP_ID' + NxCRLF, '') +         
  IF(({$WholeGroups} = 3) OR ({$IDUsed} = 'A'), 
    '  {JOIN}' + NxCRLF, 
    '')##QREXPREND#
  WHERE
    A.IsRequest = 'N'
##QREXPRBEGIN#
  IF({$IDUsed} = 'A', '    <<<ANDWHERE>>>',  
    NxCase({$WholeGroups}, '', 
      '', '',  
      '    AND A.AccDate$DATE >= {$AccDateFrom} AND A.AccDate$DATE < {$AccDateTo}', 
      '    AND A.AccDate$DATE >= {$AccDateFrom} AND A.AccDate$DATE < {$AccDateTo} AND ' + NxCRLF +
      '    (' + NxCRLF +
      '      (B.ACCGROUP_ID = A.AccGroupCredit_ID AND A.CreditAccount_ID IN (<<<$AccountSelIDLIST>>>)' + IF({$DivisionUsed} = 'A', ' AND A.CreditDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.CreditBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.CreditBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.CreditBusProject_ID IN ({$BusProjectSelIDLIST})', '') + ') OR' + NxCRLF + 
      '      (B.ACCGROUP_ID = A.AccGroupDebit_ID AND A.DebitAccount_ID IN (<<<$AccountSelIDLIST>>>)' + IF({$DivisionUsed} = 'A', ' AND A.DebitDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.DebitBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.DebitBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.DebitBusProject_ID IN ({$BusProjectSelIDLIST})', '') + ')' + NxCRLF +
      '    ) <<<ANDWHERE>>>'))##QREXPREND#
) B
JOIN GENERALLEDGER A ON A.ID = B.ID
LEFT JOIN Firms GF ON GF.ID = B.GroupFirm_ID
{JOIN}
ORDER BY {BEGINORDERBY}(SELECT CustGroup FROM GeneralLedger3 WHERE ID = B.AccGroup_ID) || '@' || B.AccGroup_ID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	ONYTJQ1YK3FORGAAJYMYF2FOEG
ADQ	OBTMKVQH3ZD13ACL03KIU0CLP4	AccDocQueue	Účetní řada dokladů
C	4R5FINKNYNDL3C5P00CA141B44	Currency	Měna
CA	S4JQL5BH1ND13ACL03KIU0CLP4	Account	Účet D
CBO	K2WTYL304VD13ACL03KIU0CLP4	CRBusOrder	Zakázka D
CBP	QOKMKIQUJF34L3DUICTBWEDQJC	CRBusProject	Projekt D
CBT	KAWTYL304VD13ACL03KIU0CLP4	CRBusTransaction	Obch. případ D
CD	O1X54EUXPZCL35CH000ILPWJF4	CRDivision	Středisko D
DA	S4JQL5BH1ND13ACL03KIU0CLP4	DEAccount	Účet MD
DBO	K2WTYL304VD13ACL03KIU0CLP4	DBBusOrder	Zakázka MD
DBP	QOKMKIQUJF34L3DUICTBWEDQJC	DBBusProject	Projekt MD
DBT	KAWTYL304VD13ACL03KIU0CLP4	DBBusTransaction	Obch. případ MD
DD	O1X54EUXPZCL35CH000ILPWJF4	DBDivision	Středisko MD
F	4K3EXM5PQBCL35CH000ILPWJF4	Firm	Firma
GF	4K3EXM5PQBCL35CH000ILPWJF4	GrpFirm	Firma pro skupinu
P	CAQPAYUOXVCL3ACL03KIU0CLP4	Period	Období

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
CustomGroup	dtString	71	(SELECT CustGroup FROM GeneralLedger3 WHERE ID = B.AccGroup_ID) || '@' || B.AccGroup_ID		Skupina
GroupAmount	dtFloat	10	CASE WHEN (A.AccGroupDebit_ID = B.AccGroup_ID AND A.DebitAccount_ID IN ({$AccountSelIDLIST}))##QREXPRBEGIN# IF({$WholeGroups}=3, IF({$DivisionUsed} = 'A', ' AND A.DebitDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.DebitBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.DebitBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.DebitBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') ##QREXPREND# THEN A.Amount ELSE 0 END - CASE WHEN (A.AccGroupCredit_ID = B.AccGroup_ID AND A.CreditAccount_ID IN ({$AccountSelIDLIST}))##QREXPRBEGIN# IF({$WholeGroups}=3, IF({$DivisionUsed} = 'A', ' AND A.CreditDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.CreditBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.CreditBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.CreditBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') ##QREXPREND# THEN A.Amount ELSE 0 END		Částka skupiny
GroupCreditAmount	dtFloat	10	CASE WHEN (A.AccGroupCredit_ID = B.AccGroup_ID AND A.CreditAccount_ID IN ({$AccountSelIDLIST}))##QREXPRBEGIN# IF({$WholeGroups}=3, IF({$DivisionUsed} = 'A', ' AND A.CreditDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.CreditBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.CreditBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.CreditBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') ##QREXPREND# THEN A.Amount ELSE 0 END		Částka D
GroupDate$DATE	dtDateTime	10	B.AccDate$DATE		Datum skupiny
GroupDebitAmount	dtFloat	10	CASE WHEN (A.AccGroupDebit_ID = B.AccGroup_ID AND A.DebitAccount_ID IN ({$AccountSelIDLIST}))##QREXPRBEGIN# IF({$WholeGroups}=3, IF({$DivisionUsed} = 'A', ' AND A.DebitDivision_ID IN ({$DivisionSelIDLIST})', '') + IF({$BusOrderUsed} = 'A', ' AND A.DebitBusOrder_ID IN ({$BusOrderSelIDLIST})', '') + IF({$BusTransactionUsed} = 'A', ' AND A.DebitBusTransaction_ID IN ({$BusTransactionSelIDLIST})', '') + IF({$BusProjectUsed} = 'A', ' AND A.DebitBusProject_ID IN ({$BusProjectSelIDLIST})', ''), '') ##QREXPREND# THEN A.Amount ELSE 0 END		Částka MD
GroupFirmID	dtString	10	B.GroupFirm_ID		ID Firmy pro skupinu
GroupFirmName	dtString	80	GF.Name		Název firmy pro skupinu
GroupID	dtString	10	B.AccGroup_ID		ID skupiny
GroupSymbol	dtString	60	(SELECT CustGroup FROM GeneralLedger3 WHERE ID = B.AccGroup_ID)		Znak skupiny

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=C3S1BMBT4RD13ACL03KIU0CLP4
{$IDUsed}=USED;'N'

Account_ID

Popiska:

Účet MD nebo D

Typ/Subtyp:

ctSpecial/0

ckSingle:

<field> = {:VALUE}

ckList:

<field> IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=K0TL1BKM1RD13ACL03KIU0CLP4
TextField=Code
ReplacementLink=True
AlwaysUsed=True
{$AccountSelIDLIST}=VALUE;

AccDate

Šablona:

AccDate

Dataset:

MAIN

Speciální parametry:

AlwaysUsed=True
ReplacementLink=True
{$AccDateFrom}=VALUE;0
{$AccDateTo}=VALUEHIGH;0

WholeGroups

Šablona:

WholeGroups

Dataset:

MAIN

Speciální parametry:

AlwaysUsed=True
ReplacementLink=True
{$WholeGroups}=VALUE;1

ShowGroups

Šablona:

ShowGroups

Dataset:

MAIN

Speciální parametry:

AlwaysUsed=True
ReplacementLink=True
{$ShowGroups}=VALUE;1

CustGroup

Popiska:

Párovací znak

Typ/Subtyp:

ctString/0

ckSingle:

(GL3.CustGroup LIKE {:VALUE} ESCAPE '~')

Dataset:

MAIN

Speciální parametry:

ConvertWildChars=True
{$GL3Used}=USED;'N'

Period_ID

Šablona:

Period_ID

Dataset:

MAIN

DocumentType

Popiska:

Typ dokladu

Typ/Subtyp:

ctSpecial/0

ckSingle:

ADQ.DocumentType = {:VALUE}

ckList:

ADQ.DocumentType IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=WBFHFPM0V3CL33N2010DELDFKK
DisplayField=Name
@ToAccount=A

AccDocQueue_ID

Šablona:

AccDocQueue_ID

Dataset:

MAIN

OrdNumber

Šablona:

OrdNumber

Dataset:

MAIN

Firm_ID

Šablona:

Firm_ID (joined)

Dataset:

MAIN

Currency_ID

Šablona:

Currency_ID

Dataset:

MAIN

Amount

Popiska:

Částka v lokální měně

Typ/Subtyp:

ctExtended/0

ckRange:

A.Amount BETWEEN {:LOW} and {:HIGH}

Dataset:

MAIN

AmountInCurrency

Popiska:

Částka v měně dokladu

Typ/Subtyp:

ctExtended/0

ckRange:

A.AmountInCurrency BETWEEN {:LOW} and {:HIGH}

Dataset:

MAIN

Text

Šablona:

Text

Dataset:

MAIN

CreatedBy_ID

Šablona:

CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID

Šablona:

CorrectedBy_ID

Dataset:

MAIN

Division_ID

Popiska:

Středisko MD nebo D

Typ/Subtyp:

ctSpecial/0

ckSingle:

<field> = {:VALUE}

ckList:

<field> IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=OA5JMX4J2FD135CH000ILPWJF4
TextField=Code
ReplacementLink=True
{$DivisionUsed}=USED;'N'
{$DivisionSelIDLIST}=VALUE;

BusOrder_ID

Popiska:

Zakázka MD nebo D

Typ/Subtyp:

ctSpecial/0

ckNull:

ckList:

<field> IN ({:LIST})

ckSingle:

<field> = {:VALUE}

Dataset:

MAIN

Speciální parametry:

CLASSID=03OXHKRF4VD13ACL03KIU0CLP4
TextField=Code
ReplacementLink=True
{$BusOrderUsed}=USED;'N'
{$BusOrderSelIDLIST}=VALUE;

BusTransaction_ID

Popiska:

Obchodní případ MD nebo D

Typ/Subtyp:

ctSpecial/0

ckSingle:

<field> = {:VALUE}

ckList:

<field> IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=0BOXHKRF4VD13ACL03KIU0CLP4
TextField=Code
ReplacementLink=True
{$BusTransactionUsed}=USED;'N'
{$BusTransactionSelIDLIST}=VALUE;

BusProject_ID

Popiska:

Projekt MD nebo D

Typ/Subtyp:

ctSpecial/0

ckNull:

ckList:

<field> IN ({:LIST})

ckSingle:

<field> = {:VALUE}

Dataset:

MAIN

Speciální parametry:

CLASSID=ZX20VMNR1NV4N30K2MRDAXLRN4
TextField=Code
ReplacementLink=True
{$BusProjectUsed}=USED;'N'
{$BusProjectSelIDLIST}=VALUE;

Audited

Popiska:

Audit

Typ/Subtyp:

ctBoolean/0

ckSingle:

A.Audited = {:VALUE}

Dataset:

MAIN

Klíče

CustomGroup

Popiska:

Skupina

SQL:

%GroupSymbol% {DIR},B.AccGroup_ID {DIR},A.AccDate$DATE  

Dataset:

MAIN

GroupFirmID

Popiska:

ID firmy pro skupinu

SQL:

B.GroupFirm_ID

Dataset:

MAIN

GroupSymbol

Popiska:

Znak skupiny

SQL:

%GroupSymbol% {DIR},B.AccGroup_ID {DIR},A.AccDate$DATE 

Dataset:

MAIN

AccDate$DATE

Popiska:

Datum účtování

SQL:

A.AccDate$DATE

Dataset:

MAIN

DisplayName

Popiska:

Číslo dokladu

SQL:

P.Code {DIR}, A.Period_ID {DIR}, ADQ.Code {DIR}, A.AccDocQueue_ID {DIR}, A.OrdNumber

Dataset:

MAIN

Text

Popiska:

Text

SQL:

A.Text

Dataset:

MAIN

AmountInCurrency

Popiska:

Částka v měně dokladu

SQL:

A.AmountInCurrency

Dataset:

MAIN

Amount

Popiska:

Částka

SQL:

A.Amount

Dataset:

MAIN

Firm

Popiska:

Název firmy

SQL:

F.Name {DIR}, A.Firm_ID

Dataset:

MAIN

GroupFirmName

Popiska:

Firma pro skupinu

SQL:

GF.Name {DIR}, B.GroupFirm_ID

Dataset:

MAIN

DebitAccount_ID.Code

Popiska:

Účet MD

SQL:

DA.Code {DIR},A.DebitAccount_ID

Dataset:

MAIN

CreditAccount_ID.Code

Popiska:

Účet D

SQL:

CA.Code {DIR},A.CreditAccount_ID

Dataset:

MAIN

DebitDivision_ID.Code

Popiska:

Středisko MD

SQL:

DD.Code {DIR},A.DebitDivision_ID

Dataset:

MAIN

CreditDivision_ID.Code

Popiska:

Středisko D

SQL:

CD.Code {DIR},A.CreditDivision_ID

Dataset:

MAIN

DebitBusOrder_ID.Code

Popiska:

Zakázka MD

SQL:

DBO.Code {DIR},A.DebitBusOrder_ID

Dataset:

MAIN

CreditBusOrder_ID.Code

Popiska:

Zakázka D

SQL:

CBO.Code {DIR},A.CreditBusOrder_ID

Dataset:

MAIN

DebitBusTransaction_ID.Code

Popiska:

Obchodní případ MD

SQL:

DBT.Code {DIR},A.DebitBusTransaction_ID

Dataset:

MAIN

CreditBusTransaction_ID.Code

Popiska:

Obchodní případ D

SQL:

CBT.Code {DIR},A.CreditBusTransaction_ID

Dataset:

MAIN

DebitBusProject_ID.Code

Popiska:

Projekt MD

SQL:

DBP.Code {DIR},A.DebitBusProject_ID

Dataset:

MAIN

CreditBusProject_ID.Code

Popiska:

Projekt D

SQL:

CBP.Code {DIR},A.CreditBusProject_ID

Dataset:

MAIN

GroupAmount

Popiska:

Částka skupiny

SQL:

%GroupAmount%

Dataset:

MAIN

OnlyGroupSymbol

Popiska:

Znak skupiny (bez data účtování)

SQL:

%GroupSymbol% {DIR},B.AccGroup_ID

Dataset:

MAIN

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