23.3 - Kapitaal, CAPEX (Capital Expenditures)

Concepten

• Financiële entiteit
• Grootboekpost

Relaties

• deel van
• gaat over
• heeft eigenschap of kenmerk
• heeft eigenschapswaarde

Eigenschappen

• heeft datawaarde
• heeft datum

SPARQL query

Code gekopieerd
...
Kopieer naar klembord
1# Indicator: Zorgkantoren 23.3.0
2# Parameters: $(peildatum)
3# Ontologie: 
4
5PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
6PREFIX onz-fin: <http://purl.org/ozo/onz-fin#>
7PREFIX onz-g: <http://purl.org/ozo/onz-g#>
8PREFIX time: <http://www.w3.org/2006/time#>
9
10SELECT ("CAPEX" as ?kental) (IF(SUM(?bedrag_sum_Q_IV) != 0,(SUM(?bedrag_sum_A)-SUM(?bedrag_sum_A_old))/SUM(?bedrag_sum_Q_IV),'ongedefineerd') AS ?waarde)
11
12WHERE{      
13    ?grootboek_post 
14        a onz-fin:Grootboekpost ;
15        onz-g:partOf ?rubriek ;
16        onz-g:hasDate ?datum ; 
17        onz-g:isAbout [
18            a onz-g:FinancialEntity ;
19            onz-g:hasQuality / onz-g:hasQualityValue / onz-g:hasDataValue ?geld_bedrag 
20         ] .
21    BIND($(peildatum) AS ?peildatum)
22    ?peildatum ^time:inXSDDate/time:inTemporalPosition/time:numericPosition ?peildatum_numeric .
23    BIND (?peildatum_numeric-360 as ?peildatum_numeric_old)               
24    ?peildatum_old ^time:inXSDDate/time:inTemporalPosition/time:numericPosition ?peildatum_numeric_old .
25    
26    # A Vaste activa eind
27    BIND(IF(?datum <= ?peildatum ,IF(?rubriek IN   ( 
28        onz-fin:000011, onz-fin:000012, onz-fin:000021, onz-fin:000022, onz-fin:000031, onz-fin:000032, onz-fin:000111, 
29        onz-fin:000112, onz-fin:000121, onz-fin:000122, onz-fin:000131, onz-fin:000132, onz-fin:000211, onz-fin:000212, 
30        onz-fin:000311, onz-fin:000312, onz-fin:000411, onz-fin:000412, onz-fin:000531, onz-fin:000532, onz-fin:000631, 
31        onz-fin:000632, onz-fin:000731, onz-fin:000732, onz-fin:000831, onz-fin:000832, onz-fin:000931, onz-fin:000932,
32        onz-fin:011110, onz-fin:011120, onz-fin:011130, onz-fin:011211, onz-fin:011212, onz-fin:011221, onz-fin:011222, 
33        onz-fin:011231, onz-fin:011232, onz-fin:011241, onz-fin:011242, onz-fin:011251, onz-fin:011252, onz-fin:012111, 
34        onz-fin:012112, onz-fin:012121, onz-fin:012122, onz-fin:012131, onz-fin:012132, onz-fin:012141, onz-fin:012142, 
35        onz-fin:012151, onz-fin:012152, onz-fin:012211, onz-fin:012212, onz-fin:012221, onz-fin:012222, onz-fin:012231, 
36        onz-fin:012232, onz-fin:012241, onz-fin:012242, onz-fin:012251, onz-fin:012252, onz-fin:012311, onz-fin:012312, 
37        onz-fin:012321, onz-fin:012322, onz-fin:012331, onz-fin:012332, onz-fin:012341, onz-fin:012342, onz-fin:012351, 
38        onz-fin:012352, onz-fin:012411, onz-fin:012412, onz-fin:012421, onz-fin:012422, onz-fin:012431, onz-fin:012432, 
39        onz-fin:012441, onz-fin:012442, onz-fin:012451, onz-fin:012452, onz-fin:013111, onz-fin:013112, onz-fin:013121, 
40        onz-fin:013122, onz-fin:013131, onz-fin:013132, onz-fin:013141, onz-fin:013142, onz-fin:013151, onz-fin:013152, 
41        onz-fin:014111, onz-fin:014112, onz-fin:014121, onz-fin:014122, onz-fin:014131, onz-fin:014132, onz-fin:014221, 
42        onz-fin:014222, onz-fin:014231, onz-fin:014232, onz-fin:014321, onz-fin:014322, onz-fin:014331, onz-fin:014332, 
43        onz-fin:015110, onz-fin:015120, onz-fin:015130, onz-fin:015140, onz-fin:015150, onz-fin:031110, onz-fin:031120, 
44        onz-fin:031130, onz-fin:031210, onz-fin:031220, onz-fin:031230, onz-fin:031401, onz-fin:032101, onz-fin:032210, 
45        onz-fin:032510, onz-fin:032610, onz-fin:032910), ?geld_bedrag, 0),0) AS ?bedrag_sum_A)  
46
47    
48
49
50    # A Vaste activa begin
51    BIND(IF(?datum <= ?peildatum_old ,IF(?rubriek IN (  
52        onz-fin:000011, onz-fin:000012, onz-fin:000021, onz-fin:000022, onz-fin:000031, onz-fin:000032, onz-fin:000111, 
53        onz-fin:000112, onz-fin:000121, onz-fin:000122, onz-fin:000131, onz-fin:000132, onz-fin:000211, onz-fin:000212, 
54        onz-fin:000311, onz-fin:000312, onz-fin:000411, onz-fin:000412, onz-fin:000531, onz-fin:000532, onz-fin:000631, 
55        onz-fin:000632, onz-fin:000731, onz-fin:000732, onz-fin:000831, onz-fin:000832, onz-fin:000931, onz-fin:000932,
56        onz-fin:011110, onz-fin:011120, onz-fin:011130, onz-fin:011211, onz-fin:011212, onz-fin:011221, onz-fin:011222, 
57        onz-fin:011231, onz-fin:011232, onz-fin:011241, onz-fin:011242, onz-fin:011251, onz-fin:011252, onz-fin:012111, 
58        onz-fin:012112, onz-fin:012121, onz-fin:012122, onz-fin:012131, onz-fin:012132, onz-fin:012141, onz-fin:012142, 
59        onz-fin:012151, onz-fin:012152, onz-fin:012211, onz-fin:012212, onz-fin:012221, onz-fin:012222, onz-fin:012231, 
60        onz-fin:012232, onz-fin:012241, onz-fin:012242, onz-fin:012251, onz-fin:012252, onz-fin:012311, onz-fin:012312, 
61        onz-fin:012321, onz-fin:012322, onz-fin:012331, onz-fin:012332, onz-fin:012341, onz-fin:012342, onz-fin:012351, 
62        onz-fin:012352, onz-fin:012411, onz-fin:012412, onz-fin:012421, onz-fin:012422, onz-fin:012431, onz-fin:012432, 
63        onz-fin:012441, onz-fin:012442, onz-fin:012451, onz-fin:012452, onz-fin:013111, onz-fin:013112, onz-fin:013121, 
64        onz-fin:013122, onz-fin:013131, onz-fin:013132, onz-fin:013141, onz-fin:013142, onz-fin:013151, onz-fin:013152, 
65        onz-fin:014111, onz-fin:014112, onz-fin:014121, onz-fin:014122, onz-fin:014131, onz-fin:014132, onz-fin:014221, 
66        onz-fin:014222, onz-fin:014231, onz-fin:014232, onz-fin:014321, onz-fin:014322, onz-fin:014331, onz-fin:014332, 
67        onz-fin:015110, onz-fin:015120, onz-fin:015130, onz-fin:015140, onz-fin:015150, onz-fin:031110, onz-fin:031120, 
68        onz-fin:031130, onz-fin:031210, onz-fin:031220, onz-fin:031230, onz-fin:031401, onz-fin:032101, onz-fin:032210, 
69        onz-fin:032510, onz-fin:032610, onz-fin:032910), ?geld_bedrag, 0),0) AS ?bedrag_sum_A_old)  
70    
71    
72    
73     # Q.IV Sociale lasten 
74    BIND(IF(?datum <= ?peildatum ,IF(?rubriek IN (
75        onz-fin:420000, onz-fin:420100, onz-fin:422100, onz-fin:422300, onz-fin:422400, onz-fin:422410, onz-fin:422500, onz-fin:422900
76        ), ?geld_bedrag, 0),0) AS ?bedrag_sum_Q_IV)
77
78
79}