Dynamický dotaz - CRM - Report Tržba dle krajů

ID:
EUOPDKYLWAUOLB0ZP551MCNIRC

Datasety

MAIN

Popis:
Firmy
SQL definice:
SELECT {FIELDS}
FROM
  Firms A
  {JOIN}
Where
  A.Hidden = 'N'  and
  (
    (A.ID in (select OBJ_ID from SELDAT where SEL_ID = {$FirmSelID})) or
    ({$FirmSelID} = '' and A.Firm_ID is null)
  ) and
  (
    ({$NACESelID}
    = ''
    )
    OR  
    (A.MainNACECode_ID in
      (SELECT Bx.ID FROM NACE Bx WHERE Bx.Hidden = 'N' AND
        ( 
          (Bx.ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})) OR
          (
            ({$NACEWithChilds} in ('1', 'A')) and
            (Bx.ID in (select ID from Sys$NACE2 where Superior_ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})))
          )
        )
      )    
    )
  )     
{ANDWHERE}   
Order by
  IR.Code, IR.ID
Aliasy:
Alias CLSID objektu Prefix Popis
A 4K3EXM5PQBCL35CH000ILPWJF4 Firm Firma
AD 4C3EXM5PQBCL35CH000ILPWJF4 Address Adresa
DS 0VN14W4ZYX44DBV5T35KFDWNRS District Okres
IR OISEBIIXHOG4P5HVENWQOZT5BW Region Kraj
PO ZD3JEESMGOJOFGIH5RDMMHSN3C PostOffice Pošta
Fields:
Jméno Typ Velikost Výraz CLSID Popis
Amount dtFloat 15 
(select TotalAmount

from 

 SubscriberTurnoverWithAnc(

   {$IssInvoiceType}, {$CashRecType},

   'N', 3, 

   {$DocDateUsed},{$DocDateFrom},{$DocDateTo},   

   {$DueDateUsed},{$DueDateFrom},{$DueDateTo},

   A.ID, '',   

   {$DivisionsSelID}, {$DivisionsWithChilds},  

   {$BusOrdersSelID},{$BusOrdersWithChilds},

   {$BusTransactionsSelID},{$BusTransactionsWithChilds},

   {$BusProjectsSelID},{$BusProjectsWithChilds}

   )

)
 Tržba
AmountWithoutVAT dtFloat 15 
(select TotalAmountWithoutVAT

from 

 SubscriberTurnoverWithAnc(

   {$IssInvoiceType}, {$CashRecType},

   'N', 3, 

   {$DocDateUsed},{$DocDateFrom},{$DocDateTo},   

   {$DueDateUsed},{$DueDateFrom},{$DueDateTo},

   A.ID, '',   

   {$DivisionsSelID}, {$DivisionsWithChilds},  

   {$BusOrdersSelID},{$BusOrdersWithChilds},

   {$BusTransactionsSelID},{$BusTransactionsWithChilds},

   {$BusProjectsSelID},{$BusProjectsWithChilds}

   )

)
 Tržba bez DPH

Podmínky

ID

Šablona:
ID
Dataset:
MAIN
Speciální parametry:
CLASSID=4K3EXM5PQBCL35CH000ILPWJF4

Code

Šablona:
Code
Dataset:
MAIN
Speciální parametry:
Hidden=True

Name

Šablona:
Name
Dataset:
MAIN
Speciální parametry:
Hidden=True

NACE_ID

Šablona:
NACE_ID (Replacement link)
Dataset:
MAIN

IssInvoiceType

Popiska:
Faktury vydané
Typ/Subtyp:
ctSpecial/1
ckSingle:
<field> = {:VALUE}
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True
ReplacementLink=True
{$IssInvoiceType}=VALUE;0
Names=Snížené o dobropisy;Nesnížené o dobropisy;Nezahrnout
Values=0;1;2

CashRecType

Popiska:
Pokladní příjem
Typ/Subtyp:
ctSpecial/1
ckSingle:
<field> = {:VALUE}
ckList:
<field> IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True
ReplacementLink=True
{$CashRecType}=VALUE;0
Names=Snížené o Vrácení příjmu;Nesnížené o vrácení;Nezahrnout
Values=0;1;2

DocDate

Šablona:
DocDate
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$DocDateFrom}=VALUE;0
{$DocDateTo}=VALUEHIGH;0
{$DocDateUsed}=USED;'N'

DueDate

Šablona:
DueDate
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$DueDateFrom}=VALUE;0
{$DueDateTo}=VALUEHIGH;0
{$DueDateUsed}=USED;'N'

Division_ID

Šablona:
Division_ID (Replacement Link)
Dataset:
MAIN

BusOrder_ID

Šablona:
BusOrder_ID (Replacement Link)
Dataset:
MAIN

BusTransaction_ID

Šablona:
BusTransaction_ID (Replacement Link)
Dataset:
MAIN

BusProject_ID

Šablona:
BusProject_ID (Replacement Link)
Dataset:
MAIN

Firm_ID

Šablona:
Firm_ID (Replacement Link)
Dataset:
MAIN

Region_ID

Popiska:
Kraj
Typ/Subtyp:
ctSpecial/0
ckSingle:
IR.ID = {:VALUE}
ckList:
IR.ID IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
CLASSID=QP1AXQYG4RDOB2HKALCWGTOJOS
TextField=Code

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