Debt Structure
Returns a company's debt at the individual-borrowing level, straight from the debt footnote of 10-K / 10-Q filings: every note, bond, term loan, and debenture the filer tagged on the XBRL debt-instrument axis, with face amount, carrying amount, stated and effective interest rate, variable-rate spread, fair value, conversion price, and more, data that never appears on the face of the balance sheet.
Each period entry carries two arrays:
- instruments: one entry per tranche (e.g. "Fixed Rate Senior Notes Due August 2028"). When the filer crossed the tranche with a debt-type axis, debtType names it (e.g. us-gaap:SeniorNotesMember). Sorted by face amount descending.
- types: aggregates by debt type (Senior Notes total, Commercial Paper, Term Loans). These are rollups across tranches and must never be summed together with instruments.
Monetary values default to US dollars. Pass the currency parameter to receive any supported ISO 4217 currency instead: values not already in that currency (e.g. EUR-denominated notes) are converted at the period-end spot rate, and the per-period fx block records the exact rate(s) applied so each conversion is reproducible. Pass currency=original for as-filed values. Interest rates are fractions of 1 (0.048 = 4.8%) and are never converted.
What this data can tell you:
- Refinancing needs per year, from face amounts and due years.
- Coupons on maturing tranches vs current market rates.
- Fixed vs floating rate exposure.
- Potential dilution from convertibles (conversion price vs share price).
- Market pricing of the debt (fair value vs carrying amount).
Data honesty notes:
- dueYear is derived from the member name ("…Due2030…", "…DueApril2025…"), not from a tagged maturity date; it is null when the name carries no year token.
- A minority of filers mis-tag rates as whole percents (4.8 instead of 0.048); such values are re-scaled to fractions and the entry is flagged normalized: true.
- Coverage is US-GAAP filers (10-K/10-Q); the debt-instrument axis does not exist in the IFRS taxonomy, so pure-IFRS 20-F filers are typically not covered.
- Values are point-in-time snapshots at the fiscal period end. In the quarterly view the fiscal-year-end snapshot appears as Q4.
Query parameters
Stock ticker symbol. Identify the entity by exactly one of: symbol, cik, cusip, composite_figi, or share_class_figi. At least one is required.
SEC Central Index Key (CIK).
CUSIP identifier (9 characters).
Composite OpenFIGI identifier.
Share-class OpenFIGI identifier.
Currency to return all monetary values in (default USD).
Pass any ISO 4217 code from the table below, or original to disable conversion and receive every figure in its own as-reported currency. With a target currency, any line item not already in it is converted on the fly at the period-appropriate rate (spot for balance-sheet instants, period-average for income/cash-flow flows); values already in the target pass through untouched (no round-trip), and the per-period fx block records the rate(s) applied. A currency that cannot be priced for a given period leaves those facts native and flags them under fx.unconverted.
Accepted values
| Code | Currency |
|---|---|
| original | Return every value in its original as-reported currency (no conversion) |
| USD | US Dollar, default |
| AED | United Arab Emirates Dirham |
| AFN | Afghan Afghani |
| ALL | Albanian Lek |
| AMD | Armenian Dram |
| ANG | Netherlands Antillean Guilder |
| AOA | Angolan Kwanza |
| ARS | Argentine Peso |
| AUD | Australian Dollar |
| AWG | Aruban Florin |
| AZN | Azerbaijani Manat |
| BAM | Bosnia-Herzegovina Convertible Mark |
| BBD | Barbadian Dollar |
| BDT | Bangladeshi Taka |
| BGN | Bulgarian Lev |
| BHD | Bahraini Dinar |
| BIF | Burundian Franc |
| BMD | Bermudan Dollar |
| BND | Brunei Dollar |
| BOB | Bolivian Boliviano |
| BRL | Brazilian Real |
| BSD | Bahamian Dollar |
| BTN | Bhutanese Ngultrum |
| BWP | Botswanan Pula |
| BYN | Belarusian Ruble |
| BZD | Belize Dollar |
| CAD | Canadian Dollar |
| CDF | Congolese Franc |
| CHF | Swiss Franc |
| CLP | Chilean Peso |
| CNY | Chinese Yuan |
| COP | Colombian Peso |
| CRC | Costa Rican Colón |
| CUP | Cuban Peso |
| CVE | Cape Verdean Escudo |
| CZK | Czech Koruna |
| DJF | Djiboutian Franc |
| DKK | Danish Krone |
| DOP | Dominican Peso |
| DZD | Algerian Dinar |
| EGP | Egyptian Pound |
| ERN | Eritrean Nakfa |
| ETB | Ethiopian Birr |
| EUR | Euro |
| FJD | Fijian Dollar |
| FKP | Falkland Islands Pound |
| GBP | British Pound |
| GEL | Georgian Lari |
| GHS | Ghanaian Cedi |
| GIP | Gibraltar Pound |
| GMD | Gambian Dalasi |
| GNF | Guinean Franc |
| GTQ | Guatemalan Quetzal |
| GYD | Guyanaese Dollar |
| HKD | Hong Kong Dollar |
| HNL | Honduran Lempira |
| HTG | Haitian Gourde |
| HUF | Hungarian Forint |
| IDR | Indonesian Rupiah |
| ILS | Israeli New Shekel |
| INR | Indian Rupee |
| IQD | Iraqi Dinar |
| IRR | Iranian Rial |
| ISK | Icelandic Króna |
| JMD | Jamaican Dollar |
| JOD | Jordanian Dinar |
| JPY | Japanese Yen |
| KES | Kenyan Shilling |
| KGS | Kyrgyz Som |
| KHR | Cambodian Riel |
| KMF | Comorian Franc |
| KPW | North Korean Won |
| KRW | South Korean Won |
| KWD | Kuwaiti Dinar |
| KYD | Cayman Islands Dollar |
| KZT | Kazakhstani Tenge |
| LAK | Laotian Kip |
| LBP | Lebanese Pound |
| LKR | Sri Lankan Rupee |
| LRD | Liberian Dollar |
| LSL | Lesotho Loti |
| LYD | Libyan Dinar |
| MAD | Moroccan Dirham |
| MDL | Moldovan Leu |
| MGA | Malagasy Ariary |
| MKD | Macedonian Denar |
| MMK | Myanmar Kyat |
| MNT | Mongolian Tugrik |
| MOP | Macanese Pataca |
| MRU | Mauritanian Ouguiya |
| MUR | Mauritian Rupee |
| MVR | Maldivian Rufiyaa |
| MWK | Malawian Kwacha |
| MXN | Mexican Peso |
| MYR | Malaysian Ringgit |
| MZN | Mozambican Metical |
| NAD | Namibian Dollar |
| NGN | Nigerian Naira |
| NIO | Nicaraguan Córdoba |
| NOK | Norwegian Krone |
| NPR | Nepalese Rupee |
| NZD | New Zealand Dollar |
| OMR | Omani Rial |
| PAB | Panamanian Balboa |
| PEN | Peruvian Sol |
| PGK | Papua New Guinean Kina |
| PHP | Philippine Peso |
| PKR | Pakistani Rupee |
| PLN | Polish Zloty |
| PYG | Paraguayan Guarani |
| QAR | Qatari Riyal |
| RON | Romanian Leu |
| RSD | Serbian Dinar |
| RUB | Russian Ruble |
| RWF | Rwandan Franc |
| SAR | Saudi Riyal |
| SBD | Solomon Islands Dollar |
| SCR | Seychellois Rupee |
| SDG | Sudanese Pound |
| SEK | Swedish Krona |
| SGD | Singapore Dollar |
| SHP | St. Helena Pound |
| SLE | Sierra Leonean Leone |
| SOS | Somali Shilling |
| SRD | Surinamese Dollar |
| SSP | South Sudanese Pound |
| STN | São Tomé & Príncipe Dobra |
| SVC | Salvadoran Colón |
| SYP | Syrian Pound |
| SZL | Swazi Lilangeni |
| THB | Thai Baht |
| TJS | Tajikistani Somoni |
| TMT | Turkmenistani Manat |
| TND | Tunisian Dinar |
| TOP | Tongan Paʻanga |
| TRY | Turkish Lira |
| TTD | Trinidad & Tobago Dollar |
| TWD | New Taiwan Dollar |
| TZS | Tanzanian Shilling |
| UAH | Ukrainian Hryvnia |
| UGX | Ugandan Shilling |
| UYU | Uruguayan Peso |
| UZS | Uzbekistani Som |
| VES | Venezuelan Bolívar |
| VND | Vietnamese Dong |
| VUV | Vanuatu Vatu |
| WST | Samoan Tala |
| XAF | Central African CFA Franc |
| XCD | East Caribbean Dollar |
| XDR | Special Drawing Rights |
| XOF | West African CFA Franc |
| XPF | CFP Franc |
| YER | Yemeni Rial |
| ZAR | South African Rand |
| ZMW | Zambian Kwacha |
| ZWG | Zimbabwean Gold |
Base reporting period: annual or quarter (the periods companies actually report, without the derived ttm rollup).
The reporting period: annual returns fiscal-year-end snapshots; quarter returns the snapshot at each quarter end (Q4 = the fiscal-year-end snapshot).
Maximum number of periods to return (may be clamped by subscription tier).
Response
Per-tranche and per-type debt detail, organized by period
Example response
[
{
"period": "2025-05-31",
"fiscalYear": 2025,
"fiscalPeriod": "FY",
"instruments": [
{
"member": "orcl:Fixed-RateSeniorNotesDueAugust2028Member",
"name": "Fixed Rate Senior Notes Due August 2028",
"debtType": "us-gaap:SeniorNotesMember",
"debtTypeName": "Senior Notes",
"dueYear": 2028,
"currency": "USD",
"faceAmount": 1500000000,
"carryingAmount": 1500000000,
"longTermDebt": 1500000000,
"fairValue": 1430000000,
"unamortizedDiscount": 4000000,
"conversionPrice": 71.25,
"statedRate": 0.048,
"effectiveRate": 0.0494,
"variableSpread": 0.011,
"weightedAverageRate": 0.0435,
"redemptionPrice": 1
}
],
"types": [
{
"member": "us-gaap:CommercialPaperMember",
"name": "Commercial Paper",
"currency": "USD",
"faceAmount": 2300000000,
"carryingAmount": 2300000000,
"longTermDebt": 92355000000,
"fairValue": 88000000000,
"unamortizedDiscount": 350000000,
"conversionPrice": 71.25,
"statedRate": 0.048,
"effectiveRate": 0.0494,
"variableSpread": 0.011,
"weightedAverageRate": 0.0435,
"redemptionPrice": 1
}
],
"dateFiled": "2025-06-24",
"fx": {
"targetCurrency": "USD",
"originalCurrencies": [
"USD",
"EUR",
"VEF"
],
"rates": [
{
"from": "EUR",
"method": "average",
"rate": 1.0824,
"start": "2024-01-01",
"end": "2024-12-31"
},
{
"from": "EUR",
"method": "spot",
"rate": 1.0389,
"effectiveDate": "2024-12-31"
}
],
"unconverted": {
"VEF": [
"otherIncomeExpense"
]
}
}
}
]