Dynamický dotaz - Majetek - změna vstupní ceny

ID:

G1QG23BIKBEL31ME00C5PPBIWO

Datasety

MAIN

Popis:

Majetek - změna vstupní ceny

SQL definice:

SELECT {FIELDS} FROM
  AssetValueChanges A
  {JOIN}
{WHERE}
{ORDERBY}

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	CBCG4OZGHFEL315000C5PPZRR4
AC	S0ODIDCD1NEL314Z00C5PPZRR4	AC	Karta majetku
DQ	OFTMKVQH3ZD13ACL03KIU0CLP4	DocQueue	Řada dokladů
P	CAQPAYUOXVCL3ACL03KIU0CLP4	Period	Období
SU2	22AHIVDVAVE13C5S00CA141B44	SUCorrectedBy	Uživatel
SU1	22AHIVDVAVE13C5S00CA141B44	SUCreatedBy	Uživatel

ASSETVALUECHANGES_GATHERING

Popis:

Rozpis dokladu - čerpání

SQL definice:

SELECT
  RI.DocDate$DATE as DocDate$DATE,
  RI.Firm_ID, RI.ID as ReceivedInvoice_ID,
  'AAAAAAAAAA' as CashPaid_ID,
  'AAAAAAAAAA' as OtherExpense_ID,
  'AAAAAAAAAA' as CustomsDeclaration_ID,
  'AAAAAAAAAA' as VATReceivedDInvoice_ID,
  'AAAAAAAAAA' as ReverseChargeDeclarations_ID
  {ANDFIELDS}
  FROM                               
    Relations A
    JOIN ReceivedInvoices RI ON RI.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1003 and A.RightSide_ID=:ID
UNION ALL
SELECT
  CP.DocDate$DATE as DocDate$DATE,
  CP.Firm_ID,
  'AAAAAAAAAA' as ReceivedInvoice_ID,
  CP.ID as CashPaid_ID,
  'AAAAAAAAAA' as OtherExpense_ID,
  'AAAAAAAAAA' as CustomsDeclaration_ID,
  'AAAAAAAAAA' as VATReceivedDInvoice_ID,
  'AAAAAAAAAA' as ReverseChargeDeclarations_ID
  {ANDFIELDS}
  FROM
    Relations A
    JOIN CashPaid CP ON CP.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1004 and A.RightSide_ID=:ID
UNION ALL
SELECT
  OE.DocDate$DATE as DocDate$DATE,
  OE.Firm_ID,
  'AAAAAAAAAA' as ReceivedInvoice_ID,
  'AAAAAAAAAA' as CashPaid_ID,
  OE.ID as OtherExpense_ID,
  'AAAAAAAAAA' as CustomsDeclaration_ID,
  'AAAAAAAAAA' as VATReceivedDInvoice_ID,
  'AAAAAAAAAA' as ReverseChargeDeclarations_ID
  {ANDFIELDS}
  FROM
    Relations A
    JOIN OtherExpenses OE ON OE.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1005 and A.RightSide_ID=:ID
UNION ALL
SELECT
  CD.DocDate$DATE as DocDate$DATE,
  CD.Firm_ID,
  'AAAAAAAAAA' as ReceivedInvoice_ID,
  'AAAAAAAAAA' as CashPaid_ID,
  'AAAAAAAAAA' as OtherExpense_ID,
  CD.ID as CustomsDeclaration_ID,
  'AAAAAAAAAA' as VATReceivedDInvoice_ID,
  'AAAAAAAAAA' as ReverseChargeDeclarations_ID
  {ANDFIELDS}
  FROM
    Relations A
    JOIN CustomsDeclarations CD ON CD.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1010 and A.RightSide_ID=:ID
UNION ALL
SELECT
  VR.DocDate$DATE as DocDate$DATE,
  VR.Firm_ID,
  'AAAAAAAAAA' as ReceivedInvoice_ID,
  'AAAAAAAAAA' as CashPaid_ID,
  'AAAAAAAAAA' as OtherExpense_ID,
  'AAAAAAAAAA' as CustomsDeclaration_ID,
  VR.ID as VATReceivedDInvoice_ID,
  'AAAAAAAAAA' as ReverseChargeDeclarations_ID
  {ANDFIELDS}
  FROM
    Relations A
    JOIN VATReceivedDInvoices VR ON VR.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1020 and A.RightSide_ID=:ID
UNION ALL
SELECT
  RCD.DocDate$DATE as DocDate$DATE,
  RCD.Firm_ID,
  'AAAAAAAAAA' as ReceivedInvoice_ID,
  'AAAAAAAAAA' as CashPaid_ID,
  'AAAAAAAAAA' as OtherExpense_ID,
  'AAAAAAAAAA' as CustomsDeclaration_ID,
  'AAAAAAAAAA' as VATReceivedDInvoice_ID,
  RCD.ID as ReverseChargeDeclarations_ID
  {ANDFIELDS}
  FROM
    Relations A
    JOIN ReverseChargeDeclarations RCD ON RCD.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1007 and A.RightSide_ID=:ID
ORDER BY
  %DocDate$DATE%

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	01ZXNDSYDVD135SA02K2CQM5AW

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
CashPaid_ID	dtString	10		0RXJZGDLBBDL3ACR03KIU0CLP4	Vlastní ID pokladna výdej
CustomsDeclaration_ID	dtString	10		CVBIFJVTHJDL3BLX00C5OG4NF4	Vlastní ID JCD
DocDate$DATE	dtDateTime	10			Datum čerpaného dokladu
Firm_ID	dtString	10		4K3EXM5PQBCL35CH000ILPWJF4	Firma na čerpaném dokladu
OtherExpense_ID	dtString	10		1DHHWWVMXVD13ACQ03KIU0CLP4	Vlastní ID ostatní výdaj
ReceivedInvoice_ID	dtString	10		42HE04FZGJD13ACM03KIU0CLP4	Vlastní ID faktury přijaté
ReverseChargeDeclarations_ID	dtString	10		XCBZKJFXQOR4B41FSW0E3SIGNO	Vlastní ID DRC
VATReceivedDInvoice_ID	dtString	10		ZJYWUH5I34J4VAAIHOB0ZA1FIO	Vlastní ID daňového zálohového listu přijatého

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=02AUOZEUHBEL315000C5PPZRR4

DocQueue_ID

Šablona:

DocQueue_ID

Dataset:

MAIN

Speciální parametry:

FilterDocumentType=73

Period_ID

Šablona:

Period_ID

Dataset:

MAIN

Ordnumber

Šablona:

OrdNumber

Dataset:

MAIN

DocDate

Šablona:

DocDate

Dataset:

MAIN

Description

Šablona:

Description

Dataset:

MAIN

CreatedBy_ID

Šablona:

CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID

Šablona:

CorrectedBy_ID

Dataset:

MAIN

BasePrice

Popiska:

Vstupní cena (daňová)

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

IsValorisation

Popiska:

Technické zhodnocení

Typ/Subtyp:

ctBoolean/0

ckSingle:

A.IsValorisation = {:VALUE}

Dataset:

MAIN

IsApplyInCard

Popiska:

Doklad byl promítnut do karty

Typ/Subtyp:

ctBoolean/0

ckSingle:

((({:VALUE} = 'A') and (((A.IsValorisation = 'A') and (A.IsApplyInCard = 'A'))
or (A.IsValorisation = 'N'))) or
(({:VALUE} = 'N') and (A.IsValorisation = 'A') and (A.IsApplyInCard = 'N')))

Dataset:

MAIN

AssetCard_ID

Šablona:

AssetCard_ID

Dataset:

MAIN

Division_ID

Šablona:

Division_ID

Dataset:

MAIN

BusOrder_ID

Šablona:

BusOrder_ID

Dataset:

MAIN

BusTransaction_ID

Šablona:

BusTransaction_ID

Dataset:

MAIN

BusProject_ID

Šablona:

BusProject_ID

Dataset:

MAIN

Gathering

Šablona:

Gathering_IN

Dataset:

MAIN

Speciální parametry:

{$RelDefList}=1003, 1004, 1005, 1007, 1010, 1020
{$RelDefFullGathering}=A.TaxBasePriceAmount

Klíče

DisplayName

Popiska:

Číslo dokladu (složené)

SQL:

P.Code Collate PXW_CSY {DIR}, DQ.Code Collate PXW_CSY {DIR}, A.OrdNumber

Dataset:

MAIN

DocDate$DATE

Popiska:

Datum vystavení dokladu

SQL:

A.DocDate$DATE

Dataset:

MAIN

TaxBasePriceAmount

Popiska:

Vstupní cena daňová

SQL:

A.TaxBasePriceAmount

Dataset:

MAIN

IsValorisationAsText

Popiska:

Tech. zhodn.

SQL:

A.IsValorisation

Dataset:

MAIN

AssetCard_ID.Name

Popiska:

Název karty

SQL:

AC.Name Collate PXW_CSY {DIR}, A.AssetCard_ID

Dataset:

MAIN

Description

Popiska:

Popis

SQL:

A.Description Collate PXW_CSY

Dataset:

MAIN

OrdNumber

Popiska:

Číslo dokladu

SQL:

A.OrdNumber

Dataset:

MAIN

Period

Popiska:

Období

SQL:

P.Code Collate PXW_CSY {DIR},A.Period_ID

Dataset:

MAIN

DocQueue

Popiska:

Řada dokladů

SQL:

DQ.Code Collate PXW_CSY {DIR},A.DocQueue_ID

Dataset:

MAIN

CreatedBy_ID.Name

Popiska:

Vytvořil

SQL:

SU1.Name Collate PXW_CSY {DIR}, A.CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID.Name

Popiska:

Opravil

SQL:

SU2.Name Collate PXW_CSY {DIR}, A.CorrectedBy_ID

Dataset:

MAIN

RemainderPrice

Popiska:

Zůstatková cena daňová

SQL:

A.TaxRemainderPriceAmount

Dataset:

MAIN

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