Dynamický dotaz - Majetek - Inventura majetku - výsledky

ID:
GSMURVEOSY24B441RQ0XBGHZEK

Datasety

MAIN

Popis:
Majetek - Inventura majetku - výsledky
SQL definice:
SELECT {FIELDS} FROM
  AssetInvListResults A
  {JOIN}
{WHERE}
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
A L3WORWAQM3X4D1OGY41OG1BDKK
AI XDU4SZ5ETE04J5VLNPIAUUZZWC Inv Inventura
AIC RQD11KDMGWKOP2CGDXDYTLVSIC AIC Komise
AIL 2VM0K45P5L5411NVTYKQKDXXQC InvList Seznam
AL TA0TK3IYPDGONGOIUIWBJMBCI0 AssetLocation Umístění
ALC CTY3UY5XPAEOD51WQINUFACZM4 ALC Karta v seznamu
AR 0AHQJ5OLAREL31ME00C5PPBIWO AssetResponsible Odpov.osoba
D2 O1X54EUXPZCL35CH000ILPWJF4 Division2 Nákl.středisko
DQ OFTMKVQH3ZD13ACL03KIU0CLP4 DQ Řada
DV O1X54EUXPZCL35CH000ILPWJF4 Division Evid.středisko
P CAQPAYUOXVCL3ACL03KIU0CLP4 P Období
PR WEC02QYERNCL35CH000ILPWJF4 Person Osoba
SAC2 G5YFJFW25ZF131MF00C5PPBIWO SAC2 Rozpis DrM
Fields:
Jméno Typ Velikost Výraz CLSID Popis
EAN dtString 14 
case 

when (A.AssetCard_Type = 0) then coalesce( (select EAN from AssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is null)) then coalesce( (select EAN from SmallAssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is not null)) then coalesce( (select EAN from SmallAssetCards2 where ID = A.SmallSubCard_ID), '')

else ''

end
 EAN
InventoryNr dtString 20 
case 

when (A.AssetCard_Type = 0) then coalesce( (select InventoryNr from AssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is null)) then coalesce( (select InventoryNr from SmallAssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is not null)) then coalesce( (select InventoryNr from SmallAssetCards2 where ID = A.SmallSubCard_ID), '')

else ''

end
 Invent.číslo

ASSETCOMPONENTS

Popis:
Prvky souboru majetku
SQL definice:
SELECT {FIELDS} FROM
  AssetInvListResultComps A
  {JOIN}
WHERE
  A.Parent_ID=:ID 
ORDER BY
  A.Name
Aliasy:
Alias CLSID objektu Prefix Popis
A M4GQS1FGXC04HICXSKUYDI55EK
AC 403Z1JD4FNEL315000C5PPZRR4 Component Prvek

ASSETINVLIST

Popis:
Seznam inventury majetku
SQL definice:
SELECT {FIELDS} FROM
  AssetInvLists A
WHERE
  A.ID=:Parent_ID
Aliasy:
Alias CLSID objektu Prefix Popis
A 2VM0K45P5L5411NVTYKQKDXXQC

ASSETINV

Popis:
Inventura majetku
SQL definice:
SELECT {FIELDS} FROM
  AssetInv A
WHERE
  A.ID=:AssetInv_ID
Aliasy:
Alias CLSID objektu Prefix Popis
A XDU4SZ5ETE04J5VLNPIAUUZZWC Inventura

SameAssetCards

Popis:
Majetek - Karty se stejným inventárním číslem
SQL definice:
SELECT {FIELDS} FROM
  AssetInvListResults A
  {JOIN}
WHERE
 (
 (A.AssetInv_ID = :AssetInv_ID) AND 
 (A.AssetCard_Type = :AssetCard_Type) AND 
 (A.AssetCard_ID = :AssetCard_ID) AND 
 (A.SmallSubCard_ID IS NULL OR (A.SmallSubCard_ID = :SmallSubCard_ID))
 ) OR 
 (A.ID = :ID) 
ORDER BY
  A.ApprovalStatus
Aliasy:
Alias CLSID objektu Prefix Popis
A L3WORWAQM3X4D1OGY41OG1BDKK
AI XDU4SZ5ETE04J5VLNPIAUUZZWC Inv Inventura
AIC RQD11KDMGWKOP2CGDXDYTLVSIC AIC Komise
AIL 2VM0K45P5L5411NVTYKQKDXXQC InvList Seznam
AL TA0TK3IYPDGONGOIUIWBJMBCI0 AssetLocation Umístění
ALC CTY3UY5XPAEOD51WQINUFACZM4 ALC Karta v seznamu
AR 0AHQJ5OLAREL31ME00C5PPBIWO AssetResponsible Odpov.osoba
D2 O1X54EUXPZCL35CH000ILPWJF4 Division2 Nákl.středisko
DQ OFTMKVQH3ZD13ACL03KIU0CLP4 DQ Řada
DV O1X54EUXPZCL35CH000ILPWJF4 Division Evid.středisko
P CAQPAYUOXVCL3ACL03KIU0CLP4 P Období
PR WEC02QYERNCL35CH000ILPWJF4 Person Osoba
SAC2 G5YFJFW25ZF131MF00C5PPBIWO SAC2 Rozpis DrM
Fields:
Jméno Typ Velikost Výraz CLSID Popis
EAN dtString 14 
case 

when (A.AssetCard_Type = 0) then coalesce( (select EAN from AssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is null)) then coalesce( (select EAN from SmallAssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is not null)) then coalesce( (select EAN from SmallAssetCards2 where ID = A.SmallSubCard_ID), '')

else ''

end
 EAN
InventoryNr dtString 20 
case 

when (A.AssetCard_Type = 0) then coalesce( (select InventoryNr from AssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is null)) then coalesce( (select InventoryNr from SmallAssetCards where ID = A.AssetCard_ID), '')

when ((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is not null)) then coalesce( (select InventoryNr from SmallAssetCards2 where ID = A.SmallSubCard_ID), '')

else ''

end
 Invent.číslo

Podmínky

ID

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

AssetInv_ID

Popiska:
Inventura majetku
Typ/Subtyp:
ctSpecial/13
ckSingle:
A.AssetInv_ID = {:VALUE}
Dataset:
MAIN
Speciální parametry:
CLASSID=XDU4SZ5ETE04J5VLNPIAUUZZWC
SITECLASSID=CVEKSJFIL15O3AVYBS32EL0ZEC
DisplayField=DisplayName
SingleSetupOnly=True
AlwaysUsed=True
CheckLinkValue=True
ForceSupportNegation=False

Committee_ID

Popiska:
Inventarizační komise
Typ/Subtyp:
ctSpecial/0
ckSingle:
AIL.Committee_ID = {:VALUE}
ckList:
AIL.Committee_ID IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
CLASSID=BBZFKWOVAVKOJDAC3UO4V1YOPK
DisplayField=DisplayName
TextField=DisplayName

AssetCard_Type

Popiska:
Typ majetku
Typ/Subtyp:
ctSpecial/1
ckSingle:
A.AssetCard_Type = {:VALUE}
Dataset:
MAIN
Speciální parametry:
Values=0;1
Names=Dlouhodobý majetek;Drobný majetek

InventoryNr

Popiska:
Inventární číslo
Typ/Subtyp:
ctString/0
ckSingle:
( 
((A.AssetCard_Type = 0) and coalesce( (select upper(InventoryNr) from AssetCards where ID = A.AssetCard_ID), '') LIKE upper({:VALUE}) ESCAPE '~')
or
(((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is null)) and coalesce( (select upper(InventoryNr) from SmallAssetCards where ID = A.AssetCard_ID), '') LIKE upper({:VALUE}) ESCAPE '~')
or
(((A.AssetCard_Type = 1) and (A.SmallSubcard_ID is not null)) and coalesce( (select upper(InventoryNr) from SmallAssetCards2 where ID = A.SmallSubCard_ID), '') LIKE upper({:VALUE}) ESCAPE '~')
)
Dataset:
MAIN
Speciální parametry:
ConvertWildChars=True

Name

Šablona:
Name
Dataset:
MAIN

Responsible_ID

Šablona:
Responsible_ID
Dataset:
MAIN

AssetLocation_ID

Šablona:
AssetLocation_ID
Dataset:
MAIN
Speciální parametry:

EvidenceDivision_ID

Šablona:
EvidenceDivision_ID
Dataset:
MAIN
Speciální parametry:
SecurityWithNull=True
SecurityMask=0
SkipSourceBOSpecification=True

ExpensesDivision_ID

Šablona:
ExpensesDivision_ID
Dataset:
MAIN
Speciální parametry:
SecurityWithNull=True
SecurityMask=0
SkipSourceBOSpecification=True

AssetCardStatus

Popiska:
Stav majetku
Typ/Subtyp:
ctSpecial/14
ckSingle:
##CASEOR {:VALUE} #
##1#A.AssetCardStatus = 0
##2#A.AssetCardStatus = 1
##3#A.AssetCardStatus = 2
##4#A.AssetCardStatus = 3
##END#
Dataset:
MAIN
Speciální parametry:
Values=1;2;3;4
Names=V pořádku;Změněný;Nenalezen;Nový

ApprovalStatus

Popiska:
Stav schválení
Typ/Subtyp:
ctSpecial/14
ckSingle:
##CASEOR {:VALUE} #
##1#A.ApprovalStatus = 0
##2#A.ApprovalStatus = 1
##3#A.ApprovalStatus = 2
##END#
Dataset:
MAIN
Speciální parametry:
Values=1;2;3
Names=Neurčeno;Schváleno;Odmítnuto

AppliedInCard

Popiska:
Přeneseno
Typ/Subtyp:
ctBoolean/0
ckSingle:
A.AppliedInCard = {:VALUE}
Dataset:
MAIN

Klíče

InventoryNr

Popiska:
Inventární číslo
SQL:
%InventoryNr% Collate PXW_CSY
Dataset:
MAIN

Name

Popiska:
Název karty
SQL:
A.Name Collate PXW_CSY
Dataset:
MAIN

EAN

Popiska:
EAN
SQL:
%EAN% Collate PXW_CSY
Dataset:
MAIN

AssetLocation_ID.Name

Popiska:
Umístění
SQL:
AL.Name Collate PXW_CSY {DIR},A.AssetLocation_ID
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ákladové středisko
SQL:
D2.Code Collate PXW_CSY {DIR}, A.ExpensesDivision_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

Parent_ID.DisplayName

Popiska:
Inv. seznam
SQL:
DQ.Code Collate PXW_CSY {DIR}, 

P.Code Collate PXW_CSY {DIR},

AI.OrdNumber {DIR}, 

AIC.Code
Dataset:
MAIN

AssetCard_TypeAsText

Popiska:
Typ majetku
SQL:
A.AssetCard_Type
Dataset:
MAIN

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