taxonomy().concept(ferc:ScheduleMiscellaneousItemsInIncomeAndRetainedIncomeAccountsForTheYearAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Miscellaneous Items in Income and Retained Income Accounts for the Year
|
taxonomy().concept(ferc:ScheduleMiscellaneousItemsInIncomeAndRetainedIncomeAccountsForTheYearAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
Give a detailed analysis of items in Accounts 640, Miscellaneous Income; 660, Miscellaneous Income Charges; 680, Extraordinary Items; 695 Income Taxes on Extraordinary Items; 710, Other Credits to Retained Income; and 720, Other Debits to Retained Income, for the year. The classifications should be made in accordance with the USofA.
For Accounts 640 and 660, report each item amounting to $250,000 or more; items less than $250,000 in these accounts may be combined in a single entry designated "Minor Items, each less than $250,000." Enter a total for each account.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleMiscellaneousItemsInIncomeAndRetainedIncomeAccountsForTheYearAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "337 - Schedule - Miscellaneous Items in Income and Retained Income Accounts for the Year")
$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:MiscellaneousIncome).label("http://ferc.gov/form/2020-01-01/roles/label/F6MiscellaneousItemsInIncomeAndRetainedIncome").text
Account 640, Miscellaneous Income
|
// adding a comment
$data2 = list(for $i in range(5)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousIncomeAxis=*})) > 0
list({covered @ferc:MiscellaneousIncomeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else none,
if exists({@ferc:DecreaseInMiscellaneousIncome @unit @period=$currentDuration})
first(list({@ferc:DecreaseInMiscellaneousIncome @unit @period=$currentDuration}))
else none,
if exists({@ferc:IncreaseInMiscellaneousIncome @unit @period=$currentDuration})
first(list({@ferc:IncreaseInMiscellaneousIncome @unit @period=$currentDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|
taxonomy().concept(ferc:MiscellaneousIncome).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total - Account 640, Miscellaneous Income
|
max(list([@concept=ferc:MiscellaneousIncome @period=$currentDuration]))
$2,080,500
|
taxonomy().concept(ferc:MiscellaneousIncomeCharges).label("http://ferc.gov/form/2020-01-01/roles/label/F6MiscellaneousItemsInIncomeAndRetainedIncome").text
Account 660, Miscellaneous Income Charges
|
// adding a comment
$data2 = list(for $i in range(5)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousIncomeChargesAxis=*})) > 0
list({covered @ferc:MiscellaneousIncomeChargesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseInMiscellaneousIncomeCharges @unit @period=$currentDuration})
first(list({@ferc:DecreaseInMiscellaneousIncomeCharges @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseInMiscellaneousIncomeCharges @unit @period=$currentDuration})
first(list({@ferc:IncreaseInMiscellaneousIncomeCharges @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|
taxonomy().concept(ferc:MiscellaneousIncomeCharges).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total - Account 660, Miscellaneous Income Charges
|
max(list([@concept=ferc:MiscellaneousIncomeCharges @period=$currentDuration]))
$2,080,500
|
taxonomy().concept(ferc:ExtraordinaryItemsNet).label("http://ferc.gov/form/2020-01-01/roles/label/F6MiscellaneousItemsInIncomeAndRetainedIncome").text
Account 680, Extraordinary Items
|
// adding a comment
$data2 = list(for $i in range(5)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousIncomeExtraordinaryItemsAxis=*})) > 0
list({covered @ferc:MiscellaneousIncomeExtraordinaryItemsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else none,
if exists({@ferc:DecreaseInMiscellaneousIncomeExtraordinaryItems @unit @period=$currentDuration})
first(list({@ferc:DecreaseInMiscellaneousIncomeExtraordinaryItems @unit @period=$currentDuration}))
else none,
if exists({@ferc:IncreaseInMiscellaneousIncomeExtraordinaryItems @unit @period=$currentDuration})
first(list({@ferc:IncreaseInMiscellaneousIncomeExtraordinaryItems @unit @period=$currentDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|
taxonomy().concept(ferc:ExtraordinaryItemsNet).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total - Account 660, Miscellaneous Income Charges
|
max(list([@concept=ferc:ExtraordinaryItemsNet @period=$currentDuration]))
$2,080,500
|
taxonomy().concept(ferc:IncomeTaxesOnExtraordinaryItems).label("http://ferc.gov/form/2020-01-01/roles/label/F6MiscellaneousItemsInIncomeAndRetainedIncome").text
Account 695, Income Taxes on Extraordinary Items
|
// adding a comment
$data2 = list(for $i in range(5)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousIncomeIncomeTaxesOnExtraordinaryItemsAxis=*})) > 0
list({covered @ferc:MiscellaneousIncomeIncomeTaxesOnExtraordinaryItemsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else none,
if exists({@ferc:DecreaseInMiscellaneousIncomeIncomeTaxesOnExtraordinaryItems @unit @period=$currentDuration})
first(list({@ferc:DecreaseInMiscellaneousIncomeIncomeTaxesOnExtraordinaryItems @unit @period=$currentDuration}))
else none,
if exists({@ferc:IncreaseInMiscellaneousIncomeIncomeTaxesOnExtraordinaryItems @unit @period=$currentDuration})
first(list({@ferc:IncreaseInMiscellaneousIncomeIncomeTaxesOnExtraordinaryItems @unit @period=$currentDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|
taxonomy().concept(ferc:IncomeTaxesOnExtraordinaryItems).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total - Account 695, Income Taxes on Extraordinary Items
|
max(list([@concept=ferc:IncomeTaxesOnExtraordinaryItems @period=$currentDuration]))
$2,080,500
|
taxonomy().concept(ferc:OtherCreditsToRetainedIncome).label("http://ferc.gov/form/2020-01-01/roles/label/F6MiscellaneousItemsInIncomeAndRetainedIncome").text
Account 710, Other Credits to Retained Income
|
// adding a comment
$data2 = list(for $i in range(5)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:OtherCreditsToRetainedIncomeAxis=*})) > 0
list({covered @ferc:OtherCreditsToRetainedIncomeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else none,
if exists({@ferc:DecreaseInOtherCreditsToRetainedIncome @unit @period=$currentDuration})
first(list({@ferc:DecreaseInOtherCreditsToRetainedIncome @unit @period=$currentDuration}))
else none,
if exists({@ferc:IncreaseInOtherCreditsToRetainedIncome @unit @period=$currentDuration})
first(list({@ferc:IncreaseInOtherCreditsToRetainedIncome @unit @period=$currentDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|
taxonomy().concept(ferc:OtherCreditsToRetainedIncome).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total - Account 710, Other Credits to Retained Income
|
max(list([@concept=ferc:OtherCreditsToRetainedIncome @period=$currentDuration]))
$2,080,500
|
taxonomy().concept(ferc:OtherDebitsToRetainedIncome).label("http://ferc.gov/form/2020-01-01/roles/label/F6MiscellaneousItemsInIncomeAndRetainedIncome").text
Account 720, Other Debits to Retained Income
|
// adding a comment
$data2 = list(for $i in range(5)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:OtherDebitsToRetainedIncomeAxis=*})) > 0
list({covered @ferc:OtherDebitsToRetainedIncomeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else none,
if exists({@ferc:DecreaseInOtherDebitsToRetainedIncome @unit @period=$currentDuration})
first(list({@ferc:DecreaseInOtherDebitsToRetainedIncome @unit @period=$currentDuration}))
else none,
if exists({@ferc:IncreaseInOtherDebitsToRetainedIncome @unit @period=$currentDuration})
first(list({@ferc:IncreaseInOtherDebitsToRetainedIncome @unit @period=$currentDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|
taxonomy().concept(ferc:OtherDebitsToRetainedIncome).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total - Account 720, Other Debits to Retained Income
|
max(list([@concept=ferc:OtherDebitsToRetainedIncome @period=$currentDuration]))
$2,080,500
|
$Historicalheader = list(if count(list({covered @ferc:MiscellaneousItemsInIncomeAndRetainedIncomeAxis=*})) > 0
"Historical Data"
else
skip);
for $row in $Historicalheader
$row
|
// adding a comment
$data = if count(list({covered @ferc:MiscellaneousItemsInIncomeAndRetainedIncomeAxis=*})) > 0
list({covered @ferc:MiscellaneousItemsInIncomeAndRetainedIncomeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:MiscellaneousItemsAccountNumber @unit@period=$currentDuration})
first(list({@ferc:MiscellaneousItemsAccountNumber @unit @period=$currentDuration}))
else none,
if exists({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfMiscellaneousItem @unit @period=$currentDuration}))
else none,
if exists({@ferc:DecreaseInMiscellaneousItemsInIncomeAndRetainedIncomeAccounts @unit @period=$currentDuration})
first(list({@ferc:DecreaseInMiscellaneousItemsInIncomeAndRetainedIncomeAccounts @unit @period=$currentDuration}))
else none,
if exists({@ferc:IncreaseInMiscellaneousItemsInIncomeAndRetainedIncomeAccounts @unit @period=$currentDuration})
first(list({@ferc:IncreaseInMiscellaneousItemsInIncomeAndRetainedIncomeAccounts @unit @period=$currentDuration}))
else none
)}})
else skip;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
720
|
$row[3]
Minor items each less than $250,000
|
$row[4]
$1,231,456
|
$row[5]
$1,883,166
|