taxonomy().concept(ferc:ScheduleParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccountsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Particulars Concerning Certain Income Deductions And Interest Charges Accounts
|
taxonomy().concept(ferc:ScheduleParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccountsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
Report the information specified below, in the order given, for the respective income deduction and interest charges accounts.
- Miscellaneous Amortization (Account 425)-Describe the nature of items included in this account, the contra account charged, the total of amortization charges for the year, and the period of amortization.
- Miscellaneous Income Deductions-Report the nature, payee, and amount of other income deductions for the year as required by Accounts 426.1, Donations; 426.2, Life Insurance; 426.3, Penalties; 426.4, Expenditures for Certain Civic, Political and Related Activities; and 426.5, Other Deductions, of the Uniform System of Accounts. Amounts of less than $250,000 may be grouped by classes within the above accounts.
- Interest on Debt to Associated Companies (Account 430)-For each associated company that incurred interest on debt during the year, indicate the amount and interest rate respectively for (a) advances on notes, (b) advances on open account, (c) notes payable, (d) accounts payable, and (e) other debt, and total interest. Explain the nature of other debt on which interest was incurred during the year.
- Other Interest Expense (Account 431) - Report details including the amount and interest rate for other interest charges incurred during the year.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccountsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "340 - Schedule - Particulars Concerning Certain Income Deductions and Interest Charges Accounts")
$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)
|
1 |
taxonomy().concept(ferc:MiscellaneousAmortization).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 425 - Miscellaneous Amortization
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousAmortizationAxis=*})) > 0
list({covered @ferc:MiscellaneousAmortizationAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MiscellaneousAmortization @unit @period=$currentDuration})
first(list({@ferc:MiscellaneousAmortization @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
2
2
|
$row[2]
Account 425 - Miscellaneous Amortization
|
$row[3]
$79,868
|
$misc_amort_heading = 1
$misc_amort_subtotal = 1
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$misc_amort_heading + $misc_amort + $misc_amort_subtotal
1
|
TOTAL Account 425 - Miscellaneous Amortization |
max(list([@concept=ferc:MiscellaneousAmortization @period=$currentDuration]))
$2,080,500
|
$heading = 2
$subtotal = 1
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$heading + $misc_amort + $subtotal
|
taxonomy().concept(ferc:Donations).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 426.1 - Donations
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:DonationsAxis=*})) > 0
list({covered @ferc:DonationsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:Donations @unit @period=$currentDuration})
first(list({@ferc:Donations @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 2;
$subtotal = 1;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$heading + $misc_amort + 1 + $subtotal
1
|
$row[2]
Account 426.1 - Donations
|
$row[3]
$79,868
|
$heading = 2;
$subtotal = 2;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$heading + $misc_amort + $donations + $subtotal
1
|
TOTAL Account 426.1 - Donations |
max(list([@concept=ferc:Donations @period=$currentDuration]))
$2,080,500
|
$heading = 3
$subtotal = 2
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$heading + $misc_amort + $donations + $subtotal
|
taxonomy().concept(ferc:LifeInsurance).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 426.2 - Life Insurance
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:LifeInsuranceAxis=*})) > 0
list({covered @ferc:LifeInsuranceAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:LifeInsurance @unit @period=$currentDuration})
first(list({@ferc:LifeInsurance @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 3;
$subtotal = 2;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$heading + $misc_amort + $donations + $subtotal +1
3
|
$row[2]
Account 426.2 - Life Insurance
|
$row[3]
$79,868
|
$heading = 3
$subtotal = 3
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $subtotal
3
|
TOTAL Account 426.2 - Life Insurance |
max(list([@concept=ferc:LifeInsurance @period=$currentDuration]))
$2,080,500
|
$heading = 4
$subtotal = 3
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $subtotal
|
taxonomy().concept(ferc:Penalties).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 426.3 - Penalties
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:PenaltiesAxis=*})) > 0
list({covered @ferc:PenaltiesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:Penalties @unit @period=$currentDuration})
first(list({@ferc:Penalties @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 4;
$subtotal = 3;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $subtotal +1
1
|
$row[2]
Account 426.3 - Penalties
|
$row[3]
$79,868
|
$heading = 4;
$subtotal = 4;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $subtotal
3
|
TOTAL Account 426.3 - Penalties |
max(list([@concept=ferc:Penalties @period=$currentDuration]))
$2,080,500
|
$heading = 5
$subtotal = 4
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $subtotal
|
taxonomy().concept(ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivities).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 426.4 - Expenditues for Certain Civic, Political, and Related Activities
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*})) > 0
list({covered @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivities @unit @period=$currentDuration})
first(list({@ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivities @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 5;
$subtotal = 4;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $subtotal +1
1
|
$row[2]
Account 426.4 - Expenditues for Certain Civic, Political, and Related Activities
|
$row[3]
$79,868
|
$heading = 5;
$subtotal = 5;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $subtotal
3
|
TOTAL Account 426.3 - Penalties |
max(list([@concept=ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivities @period=$currentDuration]))
$2,080,500
|
$heading = 6
$subtotal = 5
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $subtotal
|
taxonomy().concept(ferc:OtherDeductions).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 426.5 - Other Deductions
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:OtherDeductionsAxis=*})) > 0
list({covered @ferc:OtherDeductionsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherDeductions @unit @period=$currentDuration})
first(list({@ferc:OtherDeductions @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 6;
$subtotal = 5;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $subtotal +1
1
|
$row[2]
Account 426.5 - Other Deductions
|
$row[3]
$79,868
|
$heading = 6;
$subtotal = 6;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $subtotal
3
|
TOTAL Account 426.5 - Other Deductions |
max(list([@concept=ferc:OtherDeductions @period=$currentDuration]))
$2,080,500
|
$heading = 7
$subtotal = 6
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $subtotal
|
taxonomy().concept(ferc:InterestOnDebtToAssociatedCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 430 - Interest on Debt to Associated Companies
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:InterestOnDebtToAssociatedCompaniesAxis=*})) > 0
list({covered @ferc:InterestOnDebtToAssociatedCompaniesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestOnDebtToAssociatedCompanies @unit @period=$currentDuration})
first(list({@ferc:InterestOnDebtToAssociatedCompanies @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 7;
$subtotal = 6;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $subtotal +1
1
|
$row[2]
Account 430 - Interest on Debt to Associated Companies
|
$row[3]
$79,868
|
$heading = 7;
$subtotal = 7;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$interest = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $interest + $subtotal
3
|
TOTAL Account 430 - Interest on Debt to Associated Companies |
max(list([@concept=ferc:InterestOnDebtToAssociatedCompanies @period=$currentDuration]))
$2,080,500
|
$heading = 8
$subtotal = 7
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$interest = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $interest + $subtotal
|
taxonomy().concept(ferc:OtherInterestExpense).label("http://ferc.gov/form/2020-01-01/roles/label/F2DDAGP").text
Account 431 - Other Interest Expense
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none)
);
$data = if count(list({covered @ferc:OtherInterestExpenseAxis=*})) > 0
list({covered @ferc:OtherInterestExpenseAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherInterestExpense @unit @period=$currentDuration})
first(list({@ferc:OtherInterestExpense @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 8;
$subtotal = 7;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$interest = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $interest + $subtotal +1
1
|
$row[2]
Account 431 - Other Interest Expense
|
$row[3]
$79,868
|
$heading = 8;
$subtotal = 8;
$misc_amort = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:MiscellaneousAmortizationAxis=*]))
else
3;
$donations = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:DonationsAxis=*]))
else
3;
$insurance = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:LifeInsuranceAxis=*]))
else
3;
$penalties = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:PenaltiesAxis=*]))
else
3;
$expenditures = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:ExpendituresForCertainCivicPoliticalAndRelatedActivitiesAxis=*]))
else
3;
$other_deductions = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherDeductionsAxis=*]))
else
3;
$interest = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:InterestOnDebtToAssociatedCompaniesAxis=*]))
else
3;
$other_interest = if count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherInterestExpenseAxis=*])) > 0
count(list([covered @ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @ferc:OtherInterestExpenseAxis=*]))
else
3;
$heading + $misc_amort + $donations + $insurance + $penalties + $expenditures + $other_deductions + $interest + $other_interest + $subtotal
3
|
TOTAL Account 431 - Other Interest Expense |
max(list([@concept=ferc:OtherInterestExpense @period=$currentDuration]))
$2,080,500
|
// adding a comment
$data = if list({covered @ferc:ParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccountsAxis=*}).length > 0
list({covered @ferc:ParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccountsAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmountOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration})
first(list({@ferc:AmountOfParticularsConcerningCertainIncomeDeductionsAndInterestChargesAccounts @unit @period=$currentDuration}))
else
none
)}})
else skip;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
Account 421.2 - Loss On Disposal of Property
|
$row[3]
$79,868
|