taxonomy().concept(ferc:ScheduleInvestmentsInSubsidiaryCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
Gas Property And Capacity Leased From Others
|
taxonomy().concept(ferc:ScheduleInvestmentsInSubsidiaryCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report below investments in Account 123.1, Investments in Subsidiary Companies.
- Provide a subheading for each company and list thereunder the information called for below. Sub-TOTAL by company and give a TOTAL in columns (e), (f), (g) and (h).
(a) Investment in Securities - List and describe each security owned. For bonds give also principal amount, date of issue, maturity, and interest rate.
(b) Investment Advances - Report separately the amounts of loans or investment advances which are subject to repayment, but which are not subject to current settlement. With respect to each advance show whether the advance is a note or open account. List each note giving date of issuance, maturity date, and specifying whether note is a renewal.
- Report separately the equity in undistributed subsidiary earnings since acquisition. The TOTAL in column (e) should equal the amount entered for Account 418.1.
- For any securities, notes, or accounts that were pledged designate such securities, notes, or accounts in a footnote, and state the name of pledgee and purpose of the pledge.
- If Commission approval was required for any advance made or security acquired, designate such fact in a footnote and give name of Commission, date of authorization, and case or docket number.
- Report column (f) interest and dividend revenues form investments, including such revenues form securities disposed of during the year.
- In column (h) report for each investment disposed of during the year, the gain or loss represented by the difference between cost of the investment (or the other amount at which carried in the books of account if difference from cost) and the selling price thereof, not including interest adjustment includible in column (f).
- Report on Line 42, column (a) the TOTAL cost of Account 123.1.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleInvestmentsInSubsidiaryCompaniesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "224 - Schedule - Investments In Subsidiary Companies")
$heading = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value))
$heading_dict = dict(for $row in $heading
list("("+$row[1]+")",list($row[2],
if $row[3] == none
""
else
taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(41)
list($i,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:SubsidiaryCompanyAxis=*})) > 0
list({covered @ferc:SubsidiaryCompanyAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfInvestmentsInSubsidiaryCompanies @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfInvestmentsInSubsidiaryCompanies @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfAcquisitionInvestmentsInSubsidiaryCompanies @unit @period=$currentDuration})
first(list({@ferc:DateOfAcquisitionInvestmentsInSubsidiaryCompanies @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturityInvestmentsInSubsidiaryCompanies @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturityInvestmentsInSubsidiaryCompanies @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentInSubsidiaryCompanies @unit @period=$priorInstant})
first(list({@ferc:InvestmentInSubsidiaryCompanies @unit @period=$priorInstant}))
else
none,
if exists({@ferc:EquityInEarningsOfSubsidiaryCompanies @unit @period=$currentDuration})
first(list({@ferc:EquityInEarningsOfSubsidiaryCompanies @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestAndDividendRevenueFromInvestments @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendRevenueFromInvestments @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentInSubsidiaryCompanies @unit @period=$currentInstant})
first(list({@ferc:InvestmentInSubsidiaryCompanies @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InvestmentGainLossOnDisplosal @unit @period=$currentDuration})
first(list({@ferc:InvestmentGainLossOnDisplosal @unit @period=$currentDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Company Common Stock
|
$row[3]
3/13/1989
|
$row[4]
N/A
|
$row[5]
$1000
|
$row[6]
$0
|
$row[7]
$0
|
$row[8]
$1000
|
$row[9]
$0
|
42 |
taxonomy().concept(ferc:CostOfInvestmentsInSubsidiaryCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F1Total").text
Total
[@ferc:CostOfInvestmentsInSubsidiaryCompanies @period=$currentDuration]
$123,456
|
|
Total
|
max(list([covered @concept=ferc:InvestmentInSubsidiaryCompanies @period = $priorInstant]))
$4,600,000
|
max(list([covered @concept=ferc:EquityInEarningsOfSubsidiaryCompanies @period=$currentDuration]))
$1,420,000
|
max(list([covered @concept=ferc:InterestAndDividendRevenueFromInvestments @period=$currentDuration]))
$111,000
|
max(list([covered @concept=ferc:InvestmentInSubsidiaryCompanies @period=$currentInstant]))
$11,000
|
max(list([covered @concept=ferc:InvestmentGainLossOnDisplosal @period=$currentDuration]))
$3,900
|