Dynamický dotaz - CRM - Report Pohledávky dle krajů

ID:
AGUBYKKC5Q243COJORMTTGVKG4

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 

FirmReceivableAmount('', 

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

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

{$FirmSelID}, A.ID)

)
 Tržba

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

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'

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