Dynamický dotaz - Mzdy - Daňové tabulky

ID:

SGAICWMZZJE13JB301C0C2VN0K

Datasety

MAIN

Popis:

Mzdy - Daňové tabulky

SQL definice:

SELECT {LIMIT} {FIELDS} FROM WageTaxTable A
{JOIN}
{WHERE}
{ORDERBY}

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	S4AICWMZZJE13JB301C0C2VN0K

ROWS

Popis:

Řádky

SQL definice:

SELECT {FIELDS} FROM
  WageTaxTable2 A
WHERE
  A.Parent_ID=:ID
ORDER BY
  A.WageBase

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	0IDN00EOZNE13JB401C0C2VN0K

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=S4AICWMZZJE13JB301C0C2VN0K

Code

Šablona:

Code

Dataset:

MAIN

Name

Šablona:

Name

Dataset:

MAIN

ValidFrom

Popiska:

Platí od

Typ/Subtyp:

ctDateTime/0

ckRange:

(A.ValidFrom$DATE NOT IN
  (SELECT Z.ValidFrom$DATE FROM WageTaxTable Z
  WHERE Z.ValidFrom$DATE <
  (SELECT MAX(X.ValidFrom$DATE) FROM WageTaxTable X
  WHERE X.ValidFrom$DATE <= {:LOW})))
and
(A.ValidFrom$DATE <= (SELECT MAX(Y.ValidFrom$DATE)
  FROM WageTaxTable Y
  WHERE Y.ValidFrom$DATE <= {:HIGH}))

Dataset:

MAIN

TableType

Popiska:

Typ tabulky

Typ/Subtyp:

ctSpecial/1

ckSingle:

A.TableType = {:VALUE}

Dataset:

MAIN

System

Popiska:

Systémová definice

Typ/Subtyp:

ctBoolean/0

ckSingle:

A.System = {:VALUE}

Dataset:

MAIN

Klíče

Code

Popiska:

Kód

SQL:

A.Code

Dataset:

MAIN

Name

Popiska:

Název

SQL:

A.Name

Dataset:

MAIN

ValidFrom$DATE

Popiska:

Platí od

SQL:

A.ValidFrom$DATE

Dataset:

MAIN

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