Dynamický dotaz - Majetek - karty

ID:

KQG3PGGR1NEL314Z00C5PPZRR4

Datasety

MAIN

Popis:

Majetek - karty

SQL definice:

SELECT {FIELDS} FROM
  AssetCards A
  {JOIN}
  LEFT JOIN TaxDepreciationGroups TDG ON TDG.ID=A.TaxDepreciationGroup_ID
  JOIN AssetLocations AL ON AL.ID=A.AssetLocation_ID
  LEFT JOIN AccDepreciationGroups ADG ON ADG.ID=A.AccDepreciationGroup_ID
  LEFT JOIN AssetResponsibles AR ON AR.ID=A.Responsible_ID
  LEFT JOIN Persons PR ON PR.ID=AR.Person_ID
  JOIN Divisions DV ON DV.ID=A.EvidenceDivision_ID
  JOIN Divisions D2 ON D2.ID = A.ExpensesDivision_ID
  JOIN AssetTypes ATYPE ON ATYPE.ID=A.AssetType_ID
  JOIN SecurityUsers SU1 ON SU1.ID = A.CreatedBy_ID
  LEFT JOIN SecurityUsers SU2 ON SU2.ID = A.CorrectedBy_ID
  LEFT JOIN BusOrders BO ON BO.ID=A.BusOrder_ID
  LEFT JOIN BusTransactions BT ON BT.ID=A.BusTransaction_ID
  LEFT JOIN BusProjects BP ON BP.ID=A.BusProject_ID  
{WHERE}
{ORDERBY}

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	S0ODIDCD1NEL314Z00C5PPZRR4
ADG	S4AINFUSBREL314Z00C5PPZRR4	AccDeprGroup	Účetní odpisová skupina
AL	TA0TK3IYPDGONGOIUIWBJMBCI0	AssetLocation	Umístění karet majetku
ATYPE	W21AW4Z3AJEL31ME00C5PPBIWO	AType	Druh majetku
BO	K2WTYL304VD13ACL03KIU0CLP4	BusOrder	Zakázka
BP	QOKMKIQUJF34L3DUICTBWEDQJC	BusProject	Projekt
BT	KAWTYL304VD13ACL03KIU0CLP4	BusTrans	Obchodní případ
DV	O1X54EUXPZCL35CH000ILPWJF4	Division	Střediska
PR	WEC02QYERNCL35CH000ILPWJF4	Person	Evidované osoby
TDG	O4LMSVMRZJE1314Z00C5PPZRR4	TaxDeprGroup	Daňová odpisová skupina

DEPRECIATIONS

Popis:

Odpisy

SQL definice:

SELECT {FIELDS} FROM
  AssetDepreciations A
WHERE
  A.Parent_ID=:ID 
ORDER BY
  A.D_YEAR,A.D_MONTH

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	O0NU0ELKGVEL315000C5PPZRR4

ASSETCOMPONENTS

Popis:

Prvky souboru majetku

SQL definice:

SELECT {FIELDS} FROM
  AssetComponents A
WHERE
  A.Parent_ID=:ID 
ORDER BY
  A.Name

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	403Z1JD4FNEL315000C5PPZRR4

ASSETRECEIPTS

Popis:

Pořízení majetku

SQL definice:

SELECT {FIELDS} FROM
  AssetReceipts A
WHERE
  (A.AssetCard_ID=:ID) and 
  (A.AssetCard_Type = 0) 
ORDER BY
  DocDate$DATE

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	K0MJQG0A1NEL31ME00C5PPBIWO

ASSETRECEIPTS_GATHERING

Popis:

Pořízení majetku - č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
  {ANDFIELDS}
  FROM                               
    Relations A
    JOIN ReceivedInvoices RI ON RI.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1000 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
  {ANDFIELDS}
  FROM
    Relations A
    JOIN CashPaid CP ON CP.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1001 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
  {ANDFIELDS}
  FROM
    Relations A
    JOIN OtherExpenses OE ON OE.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1002 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
  {ANDFIELDS}
  FROM
    Relations A
    JOIN CustomsDeclarations CD ON CD.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1009 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
  {ANDFIELDS}
  FROM
    Relations A
    JOIN VATReceivedDInvoices VR ON VR.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1019 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	dtDate	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 faktura přijatá
VATReceivedDInvoice_ID	dtString	10		ZJYWUH5I34J4VAAIHOB0ZA1FIO	Vlastní ID daňového zálohového listu přijatého

ASSETVALUECHANGES

Popis:

Změna ceny majetku

SQL definice:

SELECT {FIELDS} FROM
  AssetValueChanges A
WHERE
  A.AssetCard_ID=:ID
ORDER BY
  DocDate$DATE

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	CBCG4OZGHFEL315000C5PPZRR4

ASSETVALUECHANGES_GATHERING

Popis:

Změna ceny majetku - č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
  {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
  {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
  {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
  {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
  {ANDFIELDS}
  FROM
    Relations A
    JOIN VATReceivedDInvoices VR ON VR.ID=A.LeftSide_ID
WHERE
  A.Rel_Def=1020 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 faktura přijatá
VATReceivedDInvoice_ID	dtString	10		ZJYWUH5I34J4VAAIHOB0ZA1FIO	Vlastní ID daňového zálohového listu přijatého

ASSETDSCARDS

Popis:

Vyřazení majetku z evidence

SQL definice:

SELECT {FIELDS} FROM
  AssetDiscards A
WHERE
  A.AssetCard_ID=:ID
ORDER BY
  DocDate$DATE

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	C3CG4OZGHFEL315000C5PPZRR4

INTERRUPTIONS

Popis:

Přerušení odpisů

SQL definice:

SELECT {FIELDS} FROM AssetInterruptions A
WHERE A.PARENT_ID = :ID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	G3E4EMOJJFEL315000C5PPZRR4

PUTTOEVIDENCE

Popis:

Zařazení do evidence

SQL definice:

SELECT {FIELDS} FROM AssetPutToEvidence A
WHERE A.ASSETCARD_ID = :ID

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	02AUOZEUHBEL315000C5PPZRR4

ACCOUNTING

Popis:

Účtování odpisů

SQL definice:

SELECT {FIELDS}
FROM GeneralLedger A
{JOIN}
WHERE
  RL.LEFTSIDE_ID = :ID AND
  RL.REL_DEF = 34

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	C3S1BMBT4RD13ACL03KIU0CLP4
RL	01ZXNDSYDVD135SA02K2CQM5AW	Relation	Vazba mezi doklady

PICTURES

Popis:

Majetek - obrázky

SQL definice:

SELECT {FIELDS} FROM 
  AssetCardPictures Pic
{JOIN}
WHERE
  Pic.Parent_ID=:ID 
ORDER BY
  Pic.PosIndex

Aliasy:

Alias	CLSID objektu	Prefix	Popis
P	S1AUUMOM3REL3C5V00CA141B44	Picture	Obrázek
Pic	NGOWGYNU5ZRORFQTINW0O5BW1G	Pic	Obrázky karet majetku

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=S0ODIDCD1NEL314Z00C5PPZRR4

Name

Šablona:

Name

Dataset:

MAIN

Code

Šablona:

Code

Dataset:

MAIN

InventoryNr

Šablona:

InventoryNr

Dataset:

MAIN

ProductNumber

Šablona:

ProductNumber

Dataset:

MAIN

Speciální parametry:

AssetType_ID

Šablona:

AssetType_ID

Dataset:

MAIN

Speciální parametry:

AssetLocation_ID

Šablona:

AssetLocation_ID

Dataset:

MAIN

Speciální parametry:

Responsible_ID

Šablona:

Responsible_ID

Dataset:

MAIN

YearOfProduction

Popiska:

Rok výroby

Typ/Subtyp:

ctInteger/0

ckRange:

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

Dataset:

MAIN

EvidenceDivision_ID

Šablona:

EvidenceDivision_ID

Dataset:

MAIN

Speciální parametry:

ExpensesDivision_ID

Šablona:

ExpensesDivision_ID

Dataset:

MAIN

Speciální parametry:

BusOrder_ID

Šablona:

BusOrder_ID

Dataset:

MAIN

BusTransaction_ID

Šablona:

BusTransaction_ID

Dataset:

MAIN

BusProject_ID

Šablona:

BusProject_ID

Dataset:

MAIN

AccDepreciationGroup_ID

Popiska:

Účetní odpisová skupina

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.AccDepreciationGroup_ID = {:VALUE}

ckList:

A.AccDepreciationGroup_ID IN ({:LIST})

ckNull:

A.AccDepreciationGroup_ID IS NULL

Dataset:

MAIN

Speciální parametry:

CLASSID=S3JD4U4CBREL314Z00C5PPZRR4
DisplayField=Code

TaxDepreciationGroup_ID

Popiska:

Daňová odpisová skupina

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.TaxDepreciationGroup_ID = {:VALUE}

ckList:

A.TaxDepreciationGroup_ID IN ({:LIST})

ckNull:

A.TaxDepreciationGroup_ID IS NULL

Dataset:

MAIN

Speciální parametry:

CLASSID=OOLMSVMRZJE1314Z00C5PPZRR4
DisplayField=Code

FileInDate$DATE

Popiska:

Datum zařazení

Typ/Subtyp:

ctDateTime/0

ckRange:

(FileInDate$DATE >= {:LOW}) and (FileInDate$DATE < {:HIGH})

Dataset:

MAIN

Status

Popiska:

Stav karty

Typ/Subtyp:

ctSpecial/1

ckSingle:

A.Status = {:VALUE}

Dataset:

MAIN

Speciální parametry:

Values=0;1;2
Names=V pořízení;V evidenci;Vyřazená

DiscardDate$DATE

Popiska:

Datum vyřazení

Typ/Subtyp:

ctDateTime/0

ckRange:

(A.DiscardDate$DATE >= {:LOW}) and (A.DiscardDate$DATE < {:HIGH})

Dataset:

MAIN

AccBasePriceActual

Popiska:

Akt.vstupní cena účetní

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

TaxBasePriceActual

Popiska:

Akt.vstupní cena daňová

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

AccRemainderPriceActual

Popiska:

Akt.zůstatková cena účetní

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

TaxRemainderPriceActual

Popiska:

Akt.zůstatková cena daňová

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

CreatedBy_ID

Šablona:

CreatedBy_ID

Dataset:

MAIN

AccDepreciationType

Šablona:

AccDepreciationType

Dataset:

MAIN

TaxDepreciationType

Šablona:

TaxDepreciationType

Dataset:

MAIN

Speciální parametry:

IncomeTaxDeductionRate

Popiska:

Procento odpočtu DZP

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

PercentsInShortPeriod

Popiska:

Procento odpisu ve zkráceném období

Typ/Subtyp:

ctExtended/0

ckRange:

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

Dataset:

MAIN

Klíče

Name

Popiska:

Název karty

SQL:

A.Name Collate PXW_CSY

Dataset:

MAIN

InventoryNr

Popiska:

Inventární číslo

SQL:

A.InventoryNr

Dataset:

MAIN

Code

Popiska:

Kód SKP

SQL:

A.Code Collate PXW_CSY

Dataset:

MAIN

ProductNr

Popiska:

Výrobní číslo

SQL:

A.ProductNr

Dataset:

MAIN

StatusAsText

Popiska:

Stav karty

SQL:

A.Status

Dataset:

MAIN

AssetLocation_ID

Popiska:

Umístění

SQL:

AL.Name Collate PXW_CSY {DIR},A.AssetLocation_ID

Dataset:

MAIN

FileInDate$DATE

Popiska:

Datum zařazení

SQL:

A.FileInDate$DATE

Dataset:

MAIN

EvidenceDivision_ID.Code

Popiska:

Evidenční středisko

SQL:

DV.Code Collate PXW_CSY {DIR}, A.EvidenceDivision_ID

Dataset:

MAIN

ExpensesDivision_ID.Code

Popiska:

Nákl. středisko

SQL:

D2.Code Collate PXW_CSY {DIR}, A.ExpensesDivision_ID

Dataset:

MAIN

BusOrder_ID.Code

Popiska:

Zakázka - kód

SQL:

BO.Code Collate PXW_CSY {DIR},A.BusOrder_ID

Dataset:

MAIN

BusTransaction_ID.Code

Popiska:

Obchodní případ - kód

SQL:

BT.Code Collate PXW_CSY {DIR},A.BusTransaction_ID

Dataset:

MAIN

BusProject_ID.Code

Popiska:

Projekt - kód

SQL:

BP.Code Collate PXW_CSY {DIR},A.BusProject_ID

Dataset:

MAIN

Responsible_ID.DisplayName

Popiska:

Odpovědná osoba

SQL:

PR.LastName Collate PXW_CSY {DIR}, PR.FirstName Collate PXW_CSY {DIR}, PR.Title {DIR}, A.Responsible_ID

Dataset:

MAIN

PurchasePrice

Popiska:

Pořizovací cena

SQL:

A.PurchasePrice

Dataset:

MAIN

TaxBasepriceActual

Popiska:

Akt. daň. vstup. cena

SQL:

A.TaxBasePriceActual

Dataset:

MAIN

AccDepreciationGroup_ID.Code

Popiska:

Účetní odpisová skupina - kód

SQL:

ADG.Code Collate PXW_CSY {DIR}, A.AccDepreciationGroup_ID

Dataset:

MAIN

TaxDepreciationGroup_ID.Code

Popiska:

Daňová odpisová skupina - kód

SQL:

TDG.Code Collate PXW_CSY {DIR}, A.TaxDepreciationGroup_ID

Dataset:

MAIN

AccRemainderPriceActual

Popiska:

Akt. účet. zůst. cena

SQL:

A.AccRemainderPriceActual

Dataset:

MAIN

TaxRemainderPriceActual

Popiska:

Akt. daň. zůst. cena

SQL:

A.TaxRemainderPriceActual

Dataset:

MAIN

DiscardDate$DATE

Popiska:

Datum vyřazení

SQL:

A.DiscardDate$DATE

Dataset:

MAIN

AssetType_ID.Name

Popiska:

Druh majetku

SQL:

ATYPE.Name Collate PXW_CSY {DIR}, A.AssetType_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

TaxDepreciationType

Popiska:

Způsob daňového odpisování

SQL:

A.TaxDepreciationType

Dataset:

MAIN

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