taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Long-Term Debt
|
taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give particulars (details) of the various unmatured bonds and other evidence of long-term debt of the respondent included in Account Nos. 57, Long-Term Debt Payable Within One Year, and 60, Long-Term Debt Payable After One Year.
- In column (a) enter the name of each bond or other obligations as it is designated in the records of the respondent.
- In case obligations of the same designation mature serially or otherwise at various dates, enter in column (c) the latest date of maturity and explain the matter in a footnote.
- If respondent has had to obtain final authority for the amount of debt to be incurred, provide in a footnote the name of such officer or board and the date when assent was given.
- Refer to the definitions of "nominally issued," "actually issued," etc.
- If interest accrued during the year (as entered in columns (k) and (l)) does not aggregate the total accrual for the year on any security, explain the discrepancy in a footnote. Entries in these columns should include interest accrued on long-term debt reacquired or retired during the year, although no portion of the issue is actually outstanding at the end of the year.
- In determining the entries for column (m), do not treat any interest as paid unless the interest is actually paid to the respondent. Do not report deposits of cash with banks and other fiscal agents for the payment of interest coupons as payments of such interest until actually paid to coupon holders or others under such circumstances as to relieve the respondent from further liability.
|
|
|
|
|
TOTAL PAR VALUE |
INTR.PROV |
|
|
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "226 - Schedule - Long Term Debt - Mortgage Bonds")
$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]
Account
$row
(a)
|
|
taxonomy().concept(ferc:MortgageBondsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6LongTermDebt").text
MORTGAGE BONDS
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(10)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MortgageBondsLongTermDebtAxis=*})) > 0
list({covered @ferc:MortgageBondsLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration})
first(list({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant})
first(list({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant})
first(list({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:MortgageBondsPayableWithinOneYear @unit @period=$currentInstant})
first(list({@ferc:MortgageBondsPayableWithinOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:MortgageBondsPayableAfterOneYear @unit @period=$currentInstant})
first(list({@ferc:MortgageBondsPayableAfterOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant})
first(list( {@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccruedInterestMortgageBonds @unit @period=$currentInstant})
first(list({@ferc:AccruedInterestMortgageBonds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountMortgageBonds @unit @period=$currentDuration})
first(list({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountMortgageBonds @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestPaidMortgageBonds @unit @period=$currentDuration})
first(list({@ferc:InterestPaidMortgageBonds @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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Mortgage Bond
|
$row[3]
01/02/2016
|
$row[4]
01/02/2026
|
$row[5]
$8,520
|
$row[6]
$11,457
|
$row[7]
$45,000
|
$row[8]
$2,000,000
|
$row[9]
$11,000,000
|
$row[10]
3.75%
|
$row[11]
03/18/2020
|
$row[12]
$2,000,000
|
$row[13]
$2,000,000
|
$row[14]
$2,000,000
|
11 |
taxonomy().concept(ferc:MortgageBondsPayableWithinOneYear).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL for Mortgage Bonds
|
|
|
|
|
|
max(list([covered @concept=ferc:MortgageBondsPayableWithinOneYear @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:MortgageBondsPayableAfterOneYear @period=$currentInstant]))
$4,080,200
|
|
|
max(list([covered @concept=ferc:AccruedInterestMortgageBonds @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InterestChargedToConstructionOrOtherInvestmentAccountMortgageBonds @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InterestPaidMortgageBonds @period=$currentDuration]))
$4,080,200
|
|
taxonomy().concept(ferc:CollateralTrustBondsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6LongTermDebt").text
COLLATERAL TRUST BONDS
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(12,16)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:CollateralTrustBondsLongTermDebtAxis=*})) > 0
list({covered @ferc:CollateralTrustBondsLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration})
first(list({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant})
first(list({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant})
first(list({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:CollateralTrustBondsPayableWithinOneYear @unit @period=$currentInstant})
first(list({@ferc:CollateralTrustBondsPayableWithinOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:CollateralTrustBondsPayableAfterOneYear @unit @period=$currentInstant})
first(list({@ferc:CollateralTrustBondsPayableAfterOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant})
first(list({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccruedInterestCollateralTrustBonds @unit @period=$currentInstant})
first(list({@ferc:AccruedInterestCollateralTrustBonds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountCollateralTrustBonds @unit @period=$currentDuration})
first(list({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountCollateralTrustBonds @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestPaidCollateralTrustBonds @unit @period=$currentDuration})
first(list({@ferc:InterestPaidCollateralTrustBonds @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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
12
|
$row[2]
DEF Collateral Trust Bond
|
$row[3]
01/02/2016
|
$row[4]
01/02/2026
|
$row[5]
$8,520
|
$row[6]
$11,457
|
$row[7]
$45,000
|
$row[8]
$2,000,000
|
$row[9]
$11,000,000
|
$row[10]
3.75%
|
$row[11]
03/18/2020
|
$row[12]
$2,000,000
|
$row[13]
$2,000,000
|
$row[14]
$2,000,000
|
17 |
taxonomy().concept(ferc:CollateralTrustBondsPayableWithinOneYear).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL for Collateral Trust Bonds
|
|
|
|
|
|
max(list([covered @concept=ferc:CollateralTrustBondsPayableWithinOneYear @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:CollateralTrustBondsPayableAfterOneYear @period=$currentInstant]))
$4,080,200
|
|
|
max(list([covered @concept=ferc:AccruedInterestCollateralTrustBonds @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InterestChargedToConstructionOrOtherInvestmentAccountCollateralTrustBonds @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InterestPaidCollateralTrustBonds @period=$currentDuration]))
$4,080,200
|
|
taxonomy().concept(ferc:IncomeBondsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6LongTermDebt").text
INCOME BONDS
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(18,20)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:IncomeBondsLongTermDebtAxis=*})) > 0
list({covered @ferc:IncomeBondsLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration})
first(list({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant})
first(list({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant})
first(list({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:IncomeBondsPayableWithinOneYear @unit @period=$currentInstant})
first(list({@ferc:IncomeBondsPayableWithinOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:IncomeBondsPayableAfterOneYear @unit @period=$currentInstant})
first(list({@ferc:IncomeBondsPayableAfterOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant})
first(list({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccruedInterestIncomeBonds @unit @period=$currentInstant})
first(list({@ferc:AccruedInterestIncomeBonds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountIncomeBonds @unit @period=$currentDuration})
first(list({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountIncomeBonds @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestPaidIncomeBonds @unit @period=$currentDuration})
first(list({@ferc:InterestPaidIncomeBonds @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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
18
|
$row[2]
GHI Income Bond
|
$row[3]
01/02/2016
|
$row[4]
01/02/2026
|
$row[5]
$8,520
|
$row[6]
$11,457
|
$row[7]
$45,000
|
$row[8]
$2,000,000
|
$row[9]
$11,000,000
|
$row[10]
3.75%
|
$row[11]
03/19/2020
|
$row[12]
$2,000,000
|
$row[13]
$2,000,000
|
$row[14]
$2,000,000
|
21 |
taxonomy().concept(ferc:IncomeBondsPayableWithinOneYear).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL for Income Bonds
|
|
|
|
|
|
max(list([covered @concept=ferc:IncomeBondsPayableWithinOneYear @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:IncomeBondsPayableAfterOneYear @period=$currentInstant]))
$4,080,200
|
|
|
max(list([covered @concept=ferc:AccruedInterestIncomeBonds @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InterestChargedToConstructionOrOtherInvestmentAccountIncomeBonds @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InterestPaidIncomeBonds @period=$currentDuration]))
$4,080,200
|
|
taxonomy().concept(ferc:MiscellaneousObligationsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6LongTermDebt").text
MISCELLANEOUS OBLIGATIONS
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(22,29)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousObligationsLongTermDebtAxis=*})) > 0
list({covered @ferc:MiscellaneousObligationsLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration})
first(list({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant})
first(list({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant})
first(list({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:MiscellaneousObligationsPayableWithinOneYear @unit @period=$currentInstant})
first(list({@ferc:MiscellaneousObligationsPayableWithinOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:MiscellaneousObligationsPayableAfterOneYear @unit @period=$currentInstant})
first(list({@ferc:MiscellaneousObligationsPayableAfterOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant})
first(list({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccruedInterestMiscellaneousObligations @unit @period=$currentInstant})
first(list({@ferc:AccruedInterestMiscellaneousObligations @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountMiscellaneousObligations @unit @period=$currentDuration})
first(list({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountMiscellaneousObligations @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestPaidMiscellaneousObligations @unit @period=$currentDuration})
first(list({@ferc:InterestPaidMiscellaneousObligations @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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
22
|
$row[2]
JKL Miscellaneous Obligation
|
$row[3]
01/02/2016
|
$row[4]
01/02/2026
|
$row[5]
$8,520
|
$row[6]
$11,457
|
$row[7]
$45,000
|
$row[8]
$2,000,000
|
$row[9]
$11,000,000
|
$row[10]
3.75%
|
$row[11]
03/18/2020
|
$row[12]
$2,000,000
|
$row[13]
$2,000,000
|
$row[14]
$2,000,000
|
30 |
taxonomy().concept(ferc:MiscellaneousObligationsPayableWithinOneYear).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL for Miscellaneous Obligations
|
|
|
|
|
|
max(list([covered @concept=ferc:MiscellaneousObligationsPayableWithinOneYear @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:MiscellaneousObligationsPayableAfterOneYear @period=$currentInstant]))
$4,080,200
|
|
|
max(list([covered @concept=ferc:AccruedInterestMiscellaneousObligations @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InterestChargedToConstructionOrOtherInvestmentAccountMiscellaneousObligations @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InterestPaidMiscellaneousObligations @period=$currentDuration]))
$4,080,200
|
|
taxonomy().concept(ferc:NonnegotiableDebtToAffiliatedCompanyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6LongTermDebt").text
NONNEGOTIABLE DEBT TO AFFILLIATED CO.
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(31,39)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:DebtToAffiliatedCompaniesLongTermDebtAxis=*})) > 0
list({covered @ferc:DebtToAffiliatedCompaniesLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration})
first(list({@ferc:NameAndDescriptionOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssueLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturityLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant})
first(list({@ferc:TreasuryObligationsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant})
first(list({@ferc:SinkingAndOtherFundsParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtPledgedAsCollateralParValue @unit @period=$currentInstant}))
else
none,
if exists({@ferc:DebtToAffiliatedCompaniesPayableWithinOneYear @unit @period=$currentInstant})
first(list({@ferc:DebtToAffiliatedCompaniesPayableWithinOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:DebtToAffiliatedCompaniesPayableAfterOneYear @unit @period=$currentInstant})
first(list({@ferc:DebtToAffiliatedCompaniesPayableAfterOneYear @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant})
first(list({@ferc:InterestProvisionRateForLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestProvisionDueDateForLongTermDebt @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccruedInterestDebtToAffiliatedCompanies @unit @period=$currentInstant})
first(list({@ferc:AccruedInterestDebtToAffiliatedCompanies @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountDebtToAffiliatedCompanies @unit @period=$currentDuration})
first(list({@ferc:InterestChargedToConstructionOrOtherInvestmentAccountDebtToAffiliatedCompanies @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestPaidDebtToAffiliatedCompanies @unit @period=$currentDuration})
first(list({@ferc:InterestPaidDebtToAffiliatedCompanies @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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
31
|
$row[2]
Debt to MNO Company
|
$row[3]
01/02/2016
|
$row[4]
01/02/2026
|
$row[5]
$8,520
|
$row[6]
$11,457
|
$row[7]
$45,000
|
$row[8]
$2,000,000
|
$row[9]
$11,000,000
|
$row[10]
3.75%
|
$row[11]
03/18/2020
|
$row[12]
$2,000,000
|
$row[13]
$2,000,000
|
$row[14]
$2,000,000
|
40 |
taxonomy().concept(ferc:DebtToAffiliatedCompaniesPayableWithinOneYear).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL for Nonnegotiable Debt to Affil. Co.
|
|
|
|
|
|
max(list([covered @concept=ferc:DebtToAffiliatedCompaniesPayableWithinOneYear @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:DebtToAffiliatedCompaniesPayableAfterOneYear @period=$currentInstant]))
$4,080,200
|
|
|
max(list([covered @concept=ferc:AccruedInterestDebtToAffiliatedCompanies @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InterestChargedToConstructionOrOtherInvestmentAccountDebtToAffiliatedCompanies @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InterestPaidDebtToAffiliatedCompanies @period=$currentDuration]))
$4,080,200
|
41 |
taxonomy().concept(ferc:LongTermDebtPayableWithinOneYear).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL for Nonnegotiable Debt to Affil. Co.
|
|
|
|
|
|
max(list([covered @concept=ferc:LongTermDebtPayableWithinOneYear @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:LongTermDebtPayableAfterOneYear @period=$currentInstant]))
$4,080,200
|
|
|
max(list([covered @concept=ferc:AccruedInterestLongTermDebt @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InterestChargedToConstructionOrOtherInvestmentAccountLongTermDebt @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InterestPaidLongTermDebt @period=$currentDuration]))
$4,080,200
|