taxonomy().concept(ferc:ScheduleReceivableFromAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Receivables from Affiliated Companies
|
taxonomy().concept(ferc:ScheduleReceivableFromAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give particulars (details) of the various affiliated company debtors and the character of the transactions involved in the current asset Account No. 13, Receivables from Affiliated Companies.
- In column (a), list every item amounting to $500,000 or more. For debtors whose balances were less than $500,000, a single entry may be made under a caption "Minor accounts, less than $500,000."
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleReceivableFromAffiliatedCompaniesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "200 - Schedule - Receivables from Affiliated Companies")
$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)
|
// adding a comment
$data2 = list(for $i in range(48)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:ReceivablesFromAffiliatedCompaniesAxis=*})) > 0
list({covered @ferc:ReceivablesFromAffiliatedCompaniesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOrClassOfDebtors @unit @period=$currentDuration})
first(list({@ferc:NameOrClassOfDebtors @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DescriptionOfAssetsOrOfTransaction @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfAssetsOrOfTransaction @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReceivablesFromAffiliatedCompanies @unit @period=$currentInstant})
first(list({@ferc:ReceivablesFromAffiliatedCompanies @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
1
|
$row[2]
ABC Pipelines
|
$row[3]
Receivable for transportation services rendered
|
$row[4]
$2,755,067
|
49 |
|
taxonomy().concept(ferc:ReceivablesFromAffiliatedCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total
|
first(list([covered
@concept=ferc:ReceivablesFromAffiliatedCompanies @period = $currentInstant]))
$85,531,884
|