taxonomy().concept(ferc:ScheduleNaturalGasCompanyGasRevenuesAndDekathermsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2QScheduleTitle").text
Natural Gas Company- Gas Revenues and Dekatherms
|
taxonomy().concept(ferc:ScheduleNaturalGasCompanyGasRevenuesAndDekathermsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report below in columns (b), (d) and (f) natural gas operating revenues for each prescribed account year to date.
- In column (f) report the quantity of Dekatherms sold of natural gas year to date.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleNaturalGasCompanyGasRevenuesAndDekathermsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "F2Q - 309 - Schedule - Natural Gas Company- Gas Revenues and Dekatherms")
$headings = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value))
$heading_dict = dict(for $row in $headings
list("("+$row[1]+")",$row[2])
);
for $row in $heading_dict.keys.sort
$heading_dict[$row]
Title of Account
$row
(a)
|
$dataHead = navigate parent-child descendants from ferc:GasRevenuesAndDekathermsLineItems stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2Q/NaturalGasCompanyGasRevenuesAndDekatherms" returns list (target-name, preferred-label, order);
$rollforwardSection = list(for $x in $dataHead
$abstractConcept = taxonomy().concept($x[1]);
$is-heading = if ($x[2].role.uri != "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader")
true
else
false;
$abstractLabel = list($x[1], $abstractConcept.label($x[2].role.uri).text);
$data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2Q/NaturalGasCompanyGasRevenuesAndDekatherms" returns list(target, preferred-label, order);
$dataRow2 = list(none, none);
$dataLength = $data.length;
$difference = 2 - $dataLength;
$dataRow1 = list(for $z in $data
list(
if exists([covered @concept = $z[1].name @period = $currentDuration])
first(list([covered @concept = $z[1].name @period = $currentDuration]))
else
none)
);
$dataRow4 = if $difference > 0
$fill = list(for $j in range($difference)
list(none)
);
$dataRow1 + $fill
else
$dataRow1
if $x[2].role.uri != "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader"
$abstractLabel + $dataRow2 + list($difference)
else
$abstractLabel + sum($dataRow4) + list($difference)
)
for $rowl in $rollforwardSection
1
1
|
$rowl[1].local-name
$rowl[2]
|
$rowl[3]
|
$rowl[4]
if $rowl[5] > 0 "gray-out" else ""
|