taxonomy().concept(ferc:ScheduleInvestmentsInCommonStocksOfAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Invest in Com Stocks of Affiliated Co / Co Controlled Directly by Resp Other than Through Title to Securities
|
taxonomy().concept(ferc:ScheduleInvestmentsInCommonStocksOfAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Report below the particulars (details) of all investments in common stocks included in Account No. 20, Investments in Affiliated Companies, which qualify for the equity method under instruction 2-2 of the USofA.
- Enter in column (c) the amount necessary to retroactively adjust those investments qualifying for the equity method of accounting in accordance with instruction 2-2 (c) (11) of the USofA.
- Enter in column (d) the share of undistributed earnings (i.e., less dividends) or losses.
- Enter in column (e) the amortization for the year of the excess of cost over equity in net assets (equity over cost) at date of acquisition. See instruction 2-2 (c) (4) of the USofA.
- The cumulative total of column (g) must agree with column (c), line 20, Schedule 110.
GENERAL INSTRUCTIONS CONCERNING SCHEDULES 202 THRU 205
- In Schedules 202 thru 205, give particulars (details) of stocks, bonds, notes, advances, and miscellaneous securities of affiliated and nonaffiliated companies held by respondent at end of year specifically as investments; investments made or disposed of during the year; and dividends and interest credited to income. Exclude securities issued or assumed by respondent.
- Classify the investments in the following order by accounts. Show a total for each group.
- Stocks
- Bonds (Including U.S. Government Bonds)
- Other Secured Obligations
- Unsecured Notes
- Investment Advances
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleInvestmentsInCommonStocksOfAffiliatedCompaniesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "204 - Schedule - Investments in Common Stocks of Affiliated 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],taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
|
taxonomy().concept(ferc:CarrierMember).label("http://ferc.gov/form/2020-01-01/roles/label/F6InvestCommonStock").text
Carriers (List specifics for each company)
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(12)
list($i,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestInCommonStocksOfAffiliatedCompaniesOrCompaniesControlledDirectlyByRespondentOtherThanThroughTitleToSecuritiesAxis=*})) > 0
list({covered @ferc:InvestInCommonStocksOfAffiliatedCompaniesOrCompaniesControlledDirectlyByRespondentOtherThanThroughTitleToSecuritiesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$priorInstant})
first(list({@ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$priorInstant}))
else
none,
if exists({@ferc:AdjustmentForInvestmentsQualifyingForEquityMethod @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration})
first(list({@ferc:AdjustmentForInvestmentsQualifyingForEquityMethod @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:EquityInUndistributedEarningsLosses @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration})
first(list({@ferc:EquityInUndistributedEarningsLosses @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmortizationForInvestmentInCommonStocksOfAffiliatedCompanies @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration})
first(list({@ferc:AmortizationForInvestmentInCommonStocksOfAffiliatedCompanies @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdjustmentForInvestmentsInCommonStocksOfAffiliatedCompaniesDisposedOfOrWrittenDown @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration})
first(list({@ferc:AdjustmentForInvestmentsInCommonStocksOfAffiliatedCompaniesDisposedOfOrWrittenDown @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentInstant})
first(list({@ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:CarrierMember @unit @period=$currentInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Pipeline
|
$row[3]
$100,000
|
$row[4]
$120,000
|
$row[5]
$140,000
|
$row[6]
if $row[6].name in list(ferc:AmortizationForInvestmentInCommonStocksOfAffiliatedCompanies) "-" else none
$920,000
|
$row[7]
if $row[7].name in list(ferc:AdjustmentForInvestmentsInCommonStocksOfAffiliatedCompaniesDisposedOfOrWrittenDown) "-" else none
$820,000
|
$row[8]
$420,000
|
13 |
Carriers Total |
first(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:CarrierMember @period = $priorInstant]))
$27,666,233
|
first(list([covered @concept=ferc:AdjustmentForInvestmentsQualifyingForEquityMethod @ferc:CarrierTypeAxis=ferc:CarrierMember @period = $currentDuration]))
$81,982,726
|
first(list([covered @concept=ferc:EquityInUndistributedEarningsLosses @ferc:CarrierTypeAxis=ferc:CarrierMember @period = $currentDuration]))
$25,200,177
|
first(list([covered @concept=ferc:AmortizationForInvestmentInCommonStocksOfAffiliatedCompanies @ferc:CarrierTypeAxis=ferc:CarrierMember @period = $currentDuration]))
$428,165,099
|
first(list([covered @concept=ferc:AdjustmentForInvestmentsInCommonStocksOfAffiliatedCompaniesDisposedOfOrWrittenDown @ferc:CarrierTypeAxis=ferc:CarrierMember @period = $currentDuration]))
$187,091,726
|
first(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:CarrierMember @period = $currentInstant]))
$109,837,144
|
14 |
taxonomy().concept(ferc:NoncarrierMember).label("http://ferc.gov/form/2020-01-01/roles/label/F6InvestCommonStock").text
Noncarriers (Show totals only for each column)
|
first(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:NoncarrierMember @period = $priorInstant]))
$36,254,888
|
first(list([covered @concept=ferc:AdjustmentForInvestmentsQualifyingForEquityMethod @ferc:CarrierTypeAxis=ferc:NoncarrierMember @period = $currentDuration]))
$37,765,726
|
first(list([covered @concept=ferc:EquityInUndistributedEarningsLosses @ferc:CarrierTypeAxis=ferc:NoncarrierMember @period = $currentDuration]))
$16,837,177
|
first(list([covered @concept=ferc:AmortizationForInvestmentInCommonStocksOfAffiliatedCompanies @ferc:CarrierTypeAxis=ferc:NoncarrierMember @period = $currentDuration]))
$123,542,998
|
first(list([covered @concept=ferc:AdjustmentForInvestmentsInCommonStocksOfAffiliatedCompaniesDisposedOfOrWrittenDown @ferc:CarrierTypeAxis=ferc:NoncarrierMember @period = $currentDuration]))
$172,827,666
|
first(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @ferc:CarrierTypeAxis=ferc:NoncarrierMember @period = $currentInstant]))
$999,111,726
|
15 |
taxonomy().concept(ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL
|
first(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @period = $priorInstant]))
$36,254,888
|
first(list([covered @concept=ferc:AdjustmentForInvestmentsQualifyingForEquityMethod @period = $currentDuration]))
$37,765,726
|
first(list([covered @concept=ferc:EquityInUndistributedEarningsLosses @period = $currentDuration]))
$16,837,177
|
first(list([covered @concept=ferc:AmortizationForInvestmentInCommonStocksOfAffiliatedCompanies @period = $currentDuration]))
$123,542,998
|
first(list([covered @concept=ferc:AdjustmentForInvestmentsInCommonStocksOfAffiliatedCompaniesDisposedOfOrWrittenDown @period = $currentDuration]))
$172,827,666
|
first(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUndistributedEarningsFromCertainInvestments @period = $currentInstant]))
$999,111,726
|