Home Forums The XBRL API Duplicate information in instance document

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
    • #182635
      Bhupesh Harchandani
      Participant

      I am trying to parse the 10k filing for Amazon Inc. and I see duplicate information in the instance document. The information about Net Income Fact is repeated 5 times with only the ‘ID’ attribute value being distinct. I am trying to figure out if the ‘id’ attribute has any information or is it just a serial number. Below are the snippets I am looking at:

      <us-gaap:NetIncomeLoss
      contextRef=”FD2017Q4YTD”
      decimals=”-6″
      id=”d83343256e749-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
      unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss>

      <us-gaap:NetIncomeLoss
      contextRef=”FD2017Q4YTD”
      decimals=”-6″
      id=”d83340331e1774-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
      unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss>

      <us-gaap:NetIncomeLoss
      contextRef=”FD2017Q4YTD”
      decimals=”-6″
      id=”d83344299e636-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
      unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss>

      <us-gaap:NetIncomeLoss
      contextRef=”FD2017Q4YTD”
      decimals=”-6″
      id=”d83354346e1194-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
      unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss>

      <us-gaap:NetIncomeLoss
      contextRef=”FD2017Q4YTD”
      decimals=”-6″
      id=”d83380285e1820-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
      unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss>

      Can anyone please help me in finding a solution to this issue?
      Thanks in advance.

    • #182716
      David Tauriello
      Keymaster

      Hi Bhupesh – thanks for writing – the five times you have noted 2017 NetIncomeLoss is returned in Amazon’s 2019 10-K are the same fact. In short, the contextref is identical for each of these occurrences of the concept in the inline XBRL documenthttps://www.sec.gov/ix?doc=/Archives/edgar/data/1018724/000101872420000004/amzn-20191231x10k.htm. If you parse 2018 or 2017 10-K reports for Amazon (not inline XBRL), you will only see two entries for NetIncomeLoss.

      If you use the fact.ultimus filter set as true on the XBRL API, the query below returns two instances of 2017 NetIncomeLoss for Amazon across all reports (entity.id=241) – one dimensionalized as part of RetainedEarnings and the other non-dimensionalized.

      https://api.xbrl.us/api/v1/fact/search?entity.id=241&
      concept.local-name=NetIncomeLoss&period.fiscal-year=2017&
      period.fiscal-period=Y&fact.ultimus=TRUE&fields=entity.name,
      report.filing-date,report.type,fact.value,dimensions,
      fact.xml-id,report.sec-url
Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment