taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60ScheduleTitle").text
Schedule XII - Long Term Debt
|
taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60Instructions").text
- For the advances from associate companies (Account 223), describe in a footnote the advances on notes and advances on open accounts. Names of associate companies from which advances were received shall be shown under the class and series of obligation in Column (c).
- For the deductions in Column (h), please give an explanation in a footnote.
- For other long-term debt (Account 224), list the name of the creditor company or organization in Column (b).
|
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 == "012 - Schedule - Long Term Debt")
$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 Number
$row
(a)
|
1 |
taxonomy().concept(ferc:AdvancesFromAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text
223
|
taxonomy().concept(ferc:AdvancesFromAssociateCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60LongTermDebt").text
Advances from Associate Companies
|
|
|
|
|
|
|
|
|
2 |
|
taxonomy().concept(ferc:AssociateCompanyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60LongTermDebt").text
Associate Company:
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3,12)
list($i,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:AdvancesFromAssociateCompaniesAxis=*})) > 0
list({covered @ferc:AdvancesFromAssociateCompaniesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AssociateCompanyName @unit @period=$currentDuration})
first(list({@ferc:AssociateCompanyName @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompaniesTermOfObligation @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociateCompaniesTermOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompaniesClassAndSeriesOfObligation @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociateCompaniesClassAndSeriesOfObligation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompaniesDateOfMaturity @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociateCompaniesDateOfMaturity @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompaniesInterestRate @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociateCompaniesInterestRate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompaniesAmountAuthorized @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociateCompaniesAmountAuthorized @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompanies @unit @period=$priorInstant})
first(list({@ferc:AdvancesFromAssociateCompanies @unit @period=$priorInstant}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompaniesAdjustments @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociateCompaniesAdjustments @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociateCompanies @unit @period=$currentInstant})
first(list({@ferc:AdvancesFromAssociateCompanies @unit @period=$currentInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
3
|
|
$row[2]
XYZ senior note
|
$row[3]
Three Years
|
$row[4]
Three Years
|
$row[5]
12011952
|
$row[6]
100 %
|
$row[7]
$3,472,555
|
$row[8]
$3,472,555
|
$row[9]
$3,472,555
|
$row[10]
$3,472,555
|
13 |
|
taxonomy().concept(ferc:AdvancesFromAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Total
|
|
|
|
|
|
max(list([covered @concept=ferc:AdvancesFromAssociateCompanies @period = $priorInstant]))
$1,600,000
|
max(list([covered @concept=ferc:AdvancesFromAssociateCompaniesAdjustments @period = $currentDuration]))
$2,600,000
|
max(list([covered @concept=ferc:AdvancesFromAssociateCompanies @period = $currentInstant]))
$4,200,000
|
14 |
taxonomy().concept(ferc:OtherLongTermDebt).label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text
224
|
taxonomy().concept(ferc:OtherLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60LongTermDebt").text
Other Long-Term Debt
|
|
|
|
|
|
|
|
|
15 |
|
taxonomy().concept(ferc:ListCreditorAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60LongTermDebt").text
List Creditor:
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(16,27)
list($i,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:OtherLongTermDebtAxis=*})) > 0
list({covered @ferc:OtherLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
{@ferc:OrderNumber @unit=* @period=$currentDuration}
else
0,
if exists({@ferc:CreditorName @unit @period=$currentDuration})
{@ferc:CreditorName @unit @period=$currentDuration}
else
none,
if exists({@ferc:OtherLongTermDebtTermOfObligation @unit @period=$currentDuration})
{@ferc:OtherLongTermDebtTermOfObligation @unit @period=$currentDuration}
else
none,
if exists({@ferc:OtherLongTermDebtClassAndSeriesOfObligation @unit @period=$currentDuration})
{@ferc:OtherLongTermDebtClassAndSeriesOfObligation @unit @period=$currentDuration}
else
none,
if exists({@ferc:OtherLongTermDebtDateOfMaturity @unit @period=$currentDuration})
{@ferc:OtherLongTermDebtDateOfMaturity @unit @period=$currentDuration}
else
none,
if exists({@ferc:LongTermDebtInterestRate @unit @period=$currentDuration})
{@ferc:LongTermDebtInterestRate @unit @period=$currentDuration}
else
none,
if exists({@ferc:OtherLongTermDebtAmountAuthorized @unit @period=$currentDuration})
{@ferc:OtherLongTermDebtAmountAuthorized @unit @period=$currentDuration}
else
none,
if exists({@ferc:OtherLongTermDebt @unit @period=$priorInstant})
{@ferc:OtherLongTermDebt @unit @period=$priorInstant}
else
none,
if exists({@ferc:OtherLongTermDebtAdjustments @unit @period=$currentDuration})
{@ferc:OtherLongTermDebtAdjustments @unit @period=$currentDuration}
else
none,
if exists({@ferc:OtherLongTermDebt @unit @period=$currentInstant})
{@ferc:OtherLongTermDebt @unit @period=$currentInstant}
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
16
|
|
$row[2]
XYZ Other debt
|
$row[3]
Four Years
|
$row[4]
Four Years
|
$row[5]
09/15/2019
|
$row[6]
100%
|
$row[7]
$4,472,555
|
$row[8]
$5,472,555
|
$row[9]
$6,472,555
|
$row[10]
$7,472,555
|
28 |
|
taxonomy().concept(ferc:OtherLongTermDebt).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Total
|
|
|
|
|
|
max(list([covered @concept=ferc:OtherLongTermDebt @period = $priorInstant]))
$1,000,000
|
max(list([covered @concept=ferc:OtherLongTermDebtAdjustments @period = $currentDuration]))
$2,000,000
|
max(list([covered @concept=ferc:OtherLongTermDebt @period = $currentInstant]))
$3,000,000
|