taxonomy().concept(ferc:ScheduleCapitalStockSubscribedLiabilityForConversionPremiumOnAndInstallmentsReceivedOnAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Capital Stock: Subscribed, Liability for Conversion, Premium on, and Installments Recieved on (Accts 202, 203, 205, 206, 207, and 212)
|
taxonomy().concept(ferc:ScheduleCapitalStockSubscribedLiabilityForConversionPremiumOnAndInstallmentsReceivedOnAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Show for each of the above accounts the amounts applying to each class and series of capital stock.
- For Account 202, Common Stock Subscribed, and Account 205, Preferred Stock Subscribed, show the subscription price and the alance due on each class at the end of year.
- Describe in a footnote the agreement and transactions under which a conversion liability existed under Account 203, Common tock Liability for Conversion, or Account 206, Preferred Stock Liability for Conversion, at the end of year.
- For Premium on Account 207, Capital Stock, designate with an asterisk in column (b), any amounts representing the excess of onsideration received over stated values of stocks without par value.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleCapitalStockSubscribedLiabilityForConversionPremiumOnAndInstallmentsReceivedOnAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "252 - Schedule - Capital Stock - Common Stock Subscribed (Account 202)")
$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 No.
$row
(a)
|
1 |
taxonomy().concept(ferc:CaptalAccountCommonStockSubscribedAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Common Stock, Subscribed
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:CommonStockSubscribedAxis=*})) > 0
list({covered @ferc:CommonStockSubscribedAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration})
first(list({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration}))
else none,
if exists({@ferc:CommonStockSubscribedShares @unit @period=$currentInstant})
first(list({@ferc:CommonStockSubscribedShares @unit @period=$currentInstant}))
else none,
if exists({@ferc:CommonStockSubscribed @unit @period=$currentInstant})
first(list({@ferc:CommonStockSubscribed @unit @period=$currentInstant}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
2
1
|
$row[2]
Capital Stock
|
|
$row[3]
400 shares
|
$row[4]
$4,000,000
|
$heading = 1
$total = 1
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $total
1 |
taxonomy().concept(ferc:CommonStockSubscribed).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:CommonStockSubscribedShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:CommonStockSubscribed @period = $currentInstant]))
$4,080,200,000
|
$heading = 2
$total = 1
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $total
1
|
taxonomy().concept(ferc:CaptalAccountLiabilityToConvertToCommonStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Common Stock, Converted to Liability
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:LiabilityToCommonStockConversionAxis=*})) > 0
list({covered @ferc:LiabilityToCommonStockConversionAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration})
first(list({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration}))
else none,
if exists({@ferc:CommonStockLiabilityForConversionShares @unit @period=$currentInstant})
first(list({@ferc:CommonStockLiabilityForConversionShares @unit @period=$currentInstant}))
else none,
if exists({@ferc:CommonStockLiabilityForConversion @unit @period=$currentInstant})
first(list({@ferc:CommonStockLiabilityForConversion @unit @period=$currentInstant}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 2
$total = 1
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $total +1
1
|
$row[2]
Capital Stock
|
|
$row[3]
400 shares
|
$row[4]
$4,000,000
|
$heading = 2
$total = 2
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$heading + $group1 + $group2 + $total
1
|
taxonomy().concept(ferc:CommonStockLiabilityForConversion).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:CommonStockLiabilityForConversionShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:CommonStockLiabilityForConversion @period = $currentInstant]))
$4,080,200,000
|
$heading = 3
$total = 2
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$heading + $group1 + $group2 + $total
1
|
taxonomy().concept(ferc:CaptalAccountPreferredStockSubscribedAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Preferred Stock, Subscribed
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:PreferredStockSubscribedAxis=*})) > 0
list({covered @ferc:PreferredStockSubscribedAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration})
first(list({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration}))
else none,
if exists({@ferc:PreferredStockSubscribedShares @unit @period=$currentInstant})
first(list({@ferc:PreferredStockSubscribedShares @unit @period=$currentInstant}))
else none,
if exists({@ferc:PreferredStockSubscribed @unit @period=$currentInstant})
first(list({@ferc:PreferredStockSubscribed @unit @period=$currentInstant}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 3
$total = 2
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$heading + $group1 + $group2 + $total +1
1
|
$row[2]
Capital Stock
|
|
$row[3]
400 shares
|
$row[4]
$4,000,000
|
$heading = 3
$total = 3
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $total
1
|
taxonomy().concept(ferc:PreferredStockSubscribed).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:PreferredStockSubscribedShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:PreferredStockSubscribed @period = $currentInstant]))
$4,080,200,000
|
$heading = 4
$total = 3
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $total
1
|
taxonomy().concept(ferc:CaptalAccountLiabilityToConvertToPreferredStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Preferred Stock Liability for Conversion
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:PreferredStockLiabilityForConversionAxis=*})) > 0
list({covered @ferc:PreferredStockLiabilityForConversionAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration})
first(list({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PreferredStockLiabilityForConversionShares @unit @period=$currentInstant})
first(list({@ferc:PreferredStockLiabilityForConversionShares @unit @period=$currentInstant}))
else
none,
if exists({@ferc:PreferredStockLiabilityForConversion @unit @period=$currentInstant})
first(list({@ferc:PreferredStockLiabilityForConversion @unit @period=$currentInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 4;
$total = 3;
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $total +1
1
|
$row[2]
Preferred Stock
|
|
$row[3]
400 shares
|
$row[4]
$4,000,000
|
$heading = 4;
$total = 4;
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $total
1
|
taxonomy().concept(ferc:PreferredStockLiabilityForConversion).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:PreferredStockLiabilityForConversionShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:PreferredStockLiabilityForConversion @period = $currentInstant]))
$4,080,200,000
|
$heading = 5;
$total = 4;
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $total
1
|
taxonomy().concept(ferc:CaptalAccountPremiumOnCapitalStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Premium on Capital Stock
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:PremiumCapitalStockAxis=*})) > 0
list({covered @ferc:PremiumCapitalStockAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration})
first(list({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IndicationOfPremiumOnCapitalStock @unit @period=$currentDuration})
if first(list({@ferc:IndicationOfPremiumOnCapitalStock @unit @period=$currentDuration}))
"*"
else
none
else
none,
if exists({@ferc:PremiumOnCapitalStockShares @unit=* @period=$currentInstant})
first(list({@ferc:PremiumOnCapitalStockShares @unit=* @period=$currentInstant}))
else
none,
if exists({@ferc:PremiumOnCapitalStock @unit=* @period=$currentInstant})
first(list({@ferc:PremiumOnCapitalStock @unit=* @period=$currentInstant}))
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
$heading = 5;
$total = 4;
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $total +1
1
|
$row[2]
300
|
$row[3]
*
|
$row[4]
400 shares
|
$row[5]
$4,000,000
|
$heading = 5;
$total = 5;
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*]))
else
3;
$group5 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $group5 + $total
1
|
taxonomy().concept(ferc:PremiumOnCapitalStock).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:PremiumOnCapitalStockShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:PremiumOnCapitalStock @period = $currentInstant]))
$4,080,200,000
|
$heading = 6
$total = 5
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*]))
else
3;
$group5 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $group5 + $total
1
|
taxonomy().concept(ferc:CaptalAccountInstallmentsOnCapitalStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Installments on Capital Stock (Account 212)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none)
);
$data = if list({covered @ferc:InstallmentCapitalStockAxis=*}).length > 0
list({covered @ferc:InstallmentCapitalStockAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration})
first(list({@ferc:NameOfAccountAndDescriptionOfCapitalStockItems @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InstallmentsReceivedOnCapitalStockShares @unit @period=$currentInstant})
first(list({@ferc:InstallmentsReceivedOnCapitalStockShares @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InstallmentsReceivedOnCapitalStock @unit @period=$currentInstant})
first(list({@ferc:InstallmentsReceivedOnCapitalStock @unit @period=$currentInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 6
$total = 5
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*]))
else
3;
$group5 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $group5 + $total +1
1
|
$row[2]
Capital Stock
|
|
$row[3]
400 shares
|
$row[4]
$4,000,000
|
$heading = 6
$total = 6
$group1 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:CommonStockSubscribedAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:LiabilityToCommonStockConversionAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockSubscribedAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PreferredStockLiabilityForConversionAxis=*]))
else
3;
$group5 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:PremiumCapitalStockAxis=*]))
else
3;
$group6 = if count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:InstallmentCapitalStockAxis=*])) > 0
count(list([covered @ferc:NameOfAccountAndDescriptionOfCapitalStockItems @ferc:InstallmentCapitalStockAxis=*]))
else
3;
$heading + $group1 + $group2 + $group3 + $group4 + $group5 + $group6 + $total
1
|
taxonomy().concept(ferc:InstallmentsReceivedOnCapitalStock).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:InstallmentsReceivedOnCapitalStockShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:InstallmentsReceivedOnCapitalStock @period = $currentInstant]))
$4,080,200,000
|
$Historicalheader = list(if count(list({covered @ferc:CapitalStockByUsagesAxis=*})) > 0
"Historical Data"
else
skip);
for $row in $Historicalheader
$row
|
// adding a comment
$data = if count(list({covered @ferc:CapitalStockByUsagesAxis=*})) > 0
list({covered @ferc:CapitalStockByUsagesAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:CapitalStockDescription @unit @period=$currentDuration})
first(list({@ferc:CapitalStockDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IndicationOfPremiumOnCapitalStock @unit @period=$currentDuration})
if first(list({@ferc:IndicationOfPremiumOnCapitalStock @unit @period=$currentDuration}))
"*"
else
none
else
none,
if exists({@ferc:NumberOfCapitalStockShares @unit @period=$currentInstant})
first(list({@ferc:NumberOfCapitalStockShares @unit @period=$currentInstant}))
else
none,
if exists({@ferc:CapitalStock @unit @period=$currentInstant})
first(list({@ferc:CapitalStock @unit @period=$currentInstant}))
else
none
)}})
else skip;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
1
|
$row[2]
Capital Stock
|
$row[3]
*
|
$row[4]
400 shares
|
$row[5]
$4,000,000
|
40
1
|
taxonomy().concept(ferc:CapitalStock).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
max(list([covered @concept=ferc:NumberOfCapitalStockShares @period = $currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:CapitalStock @period = $currentInstant]))
$4,080,200,000
|