taxonomy().concept(ferc:ScheduleCurrentAndAccruedLiabilitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60ScheduleTitle").text
Charges for Outside Professional and Other Consultative Services
|
taxonomy().concept(ferc:ScheduleCurrentAndAccruedLiabilitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60Instructions").text
- Provide the balance of notes and accounts payable to each associate company (Accounts 233 and 234).
- Give description and amount of miscellaneous current and accrued liabilities (Account 242). Items less than $50,000 may be grouped, showing the number of items in each group.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleCurrentAndAccruedLiabilitiesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "013 - Schedule - Current and Accrued Liabilities")
$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]
Title of Account
$row
(a)
|
1 |
taxonomy().concept(ferc:NotesPayableToAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text
233
|
taxonomy().concept(ferc:NotesPayableToAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60CurrentAndAccruedLiabilities").text
Notes Payable to Associate Companies
|
|
|
2 |
|
taxonomy().concept(ferc:AssociateCompanyName).label("http://ferc.gov/form/2020-01-01/roles/label/F60CurrentAndAccruedLiabilities").text
Associate Company:
|
|
|
// adding a comment
$data2 = list(for $i in range(19)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:NotesPayableToAssociateCompaniesAxis=*})) > 0
list({covered @ferc:NotesPayableToAssociateCompaniesAxis=* {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:NotesPayableToAssociateCompanies @unit @period=$priorInstant})
first(list({@ferc:NotesPayableToAssociateCompanies @unit @period=$priorInstant}))
else
none,
if exists({@ferc:NotesPayableToAssociateCompanies @unit @period=$currentInstant})
first(list({@ferc:NotesPayableToAssociateCompanies @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
3
|
|
$row[2]
XYZ Energy Carolinas, LLC
|
$row[3]
$2,472,456
|
$row[4]
$3,472,555
|
23 |
|
taxonomy().concept(ferc:NotesPayableToAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Subtotal (Total of Lines 3-22)
|
max(list([covered @concept=ferc:NotesPayableToAssociateCompanies @period = $priorInstant]))
$1,600,000
|
max(list([covered @concept=ferc:NotesPayableToAssociateCompanies @period = $currentInstant]))
$3,600,000
|
24 |
taxonomy().concept(ferc:AccountsPayableToAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text
234
|
taxonomy().concept(ferc:AccountsPayableToAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60CurrentAndAccruedLiabilities").text
Accounts Payable to Associate Companies
|
|
|
25 |
|
taxonomy().concept(ferc:AssociateCompanyName).label("http://ferc.gov/form/2020-01-01/roles/label/F60CurrentAndAccruedLiabilities").text
Associate Company:
|
|
|
// adding a comment
$data2 = list(for $i in range(24,39)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:AccountsPayableToAssociateCompaniesAxis=*})) > 0
list({covered @ferc:AccountsPayableToAssociateCompaniesAxis=* {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:AccountsPayableToAssociateCompanies @unit @period=$priorInstant})
first(list({@ferc:AccountsPayableToAssociateCompanies @unit @period=$priorInstant}))
else
none,
if exists({@ferc:AccountsPayableToAssociateCompanies @unit @period=$currentInstant})
first(list({@ferc:AccountsPayableToAssociateCompanies @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
26
|
|
$row[2]
ABC Transmission Company
|
$row[3]
$3,000,000
|
$row[4]
$4,000,000
|
40 |
|
taxonomy().concept(ferc:AccountsPayableToAssociateCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Total
|
max(list([covered @concept=ferc:AccountsPayableToAssociateCompanies @period = $priorInstant]))
$6,800,000
|
max(list([covered @concept=ferc:AccountsPayableToAssociateCompanies @period = $currentInstant]))
$6,800,000
|
41 |
taxonomy().concept(ferc:MiscellaneousCurrentAndAccruedLiabilities).label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text
242
|
taxonomy().concept(ferc:MiscellaneousCurrentAndAccruedLiabilities).label("http://ferc.gov/form/2020-01-01/roles/label/F60CurrentAndAccruedLiabilities").text
Miscellaneous Current and Accrued Liabilities
|
|
|
42 |
|
Items List: |
|
|
// adding a comment
$data2 = list(for $i in range(43,48)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousCurrentAndAccruedLiabilitiesAxis=*})) > 0
list({covered @ferc:MiscellaneousCurrentAndAccruedLiabilitiesAxis=* {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:MiscellaneousCurrentAndAccruedLiabilities @unit @period=$priorInstant})
first(list({@ferc:MiscellaneousCurrentAndAccruedLiabilities @unit @period=$priorInstant}))
else
none,
if exists({@ferc:MiscellaneousCurrentAndAccruedLiabilities @unit @period=$currentInstant})
first(list({@ferc:MiscellaneousCurrentAndAccruedLiabilities @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
43
|
|
$row[2]
DEF Transmission Company
|
$row[3]
$6,000,000
|
$row[4]
$7,000,000
|
49 |
|
taxonomy().concept(ferc:MiscellaneousCurrentAndAccruedLiabilities).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Total
|
max(list([covered @concept=ferc:MiscellaneousCurrentAndAccruedLiabilities @period = $priorInstant]))
$9,800,000
|
max(list([covered @concept=ferc:MiscellaneousCurrentAndAccruedLiabilities @period = $currentInstant]))
$99,800,000
|
50 |
|
taxonomy().concept(ferc:NotesPayableAccountsPayableAndMiscellaneousCurrentAndAccruedLiabilitiesToAssociatedCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total2").text
Grand Total
|
max(list([covered @concept=ferc:NotesPayableAccountsPayableAndMiscellaneousCurrentAndAccruedLiabilitiesToAssociatedCompanies @period = $priorInstant]))
$9,800,000
|
max(list([covered @concept=ferc:NotesPayableAccountsPayableAndMiscellaneousCurrentAndAccruedLiabilitiesToAssociatedCompanies @period = $currentInstant]))
$99,800,000
|