Codat Get Accounting Aged Debtors Report Example is an example object payload from Codat, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.
Top-level fields
operationIdmethodpathsummaryrequestExamplesresponseExamples
Example Payload
{
"operationId": "get-accounting-aged-debtors-report",
"method": "GET",
"path": "/companies/{companyId}/reports/agedDebtor",
"summary": "Aged debtors report",
"requestExamples": [],
"responseExamples": [
{
"status": "200",
"contentType": "application/json",
"name": "Clear Books",
"example": {
"generated": "2023-05-02T16:05:21.4959955Z",
"reportDate": "2023-05-02T16:05:21.4459444Z",
"data": [
{
"customerId": "c8180244-74ac-40cf-a5df-6d83661c44d7",
"customerName": "Arjun Kuvalis",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -3367.71,
"details": [
{
"name": "CreditNotes",
"amount": -3367.71
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "6d162ee4-47b4-46c6-a2e6-aa9edd0fe6b0",
"customerName": "Breitenberg, Emard and Schiller",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -4299.26,
"details": [
{
"name": "Invoices",
"amount": 0
},
{
"name": "CreditNotes",
"amount": -4299.26
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "981d56a7-cf63-4ed2-b8db-2eba2c0aeb5a",
"customerName": "Collins - Anderson",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -14959.84,
"details": [
{
"name": "CreditNotes",
"amount": -14959.84
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 773.94,
"details": [
{
"name": "Invoices",
"amount": 773.94
}
]
}
]
}
]
},
{
"customerId": "d3739e0f-5a70-465b-9dfe-deb8efac0cd3",
"customerName": "Damien Schneider",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -2817.59,
"details": [
{
"name": "CreditNotes",
"amount": -2817.59
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "10652b76-2a9a-43ba-a892-fb4f369fe1ef",
"customerName": "Franco Labadie",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -1541.52,
"details": [
{
"name": "CreditNotes",
"amount": -1541.52
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "03b7f9fd-40e0-4c71-9f93-58e867233bcb",
"customerName": "Harvey Predovic",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -14312.59,
"details": [
{
"name": "CreditNotes",
"amount": -14312.59
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 158.76,
"details": [
{
"name": "Invoices",
"amount": 158.76
}
]
}
]
}
]
},
{
"customerId": "bbea9634-7a60-4c3f-97cd-70e481ec2cce",
"customerName": "Jenkins Inc",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -32818.36,
"details": [
{
"name": "CreditNotes",
"amount": -32818.36
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 431.71,
"details": [
{
"name": "Invoices",
"amount": 431.71
}
]
}
]
}
]
},
{
"customerId": "d65ac505-072c-49ec-be3c-3cb74228966d",
"customerName": "Jensen Steuber",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -9766.18,
"details": [
{
"name": "Invoices",
"amount": 0
},
{
"name": "CreditNotes",
"amount": -9766.18
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 1273.16,
"details": [
{
"name": "Invoices",
"amount": 1273.16
}
]
}
]
}
]
},
{
"customerId": "a82042f1-a005-4ca5-bfd3-5bc237123aa5",
"customerName": "Keara Leffler",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -2595.66,
"details": [
{
"name": "CreditNotes",
"amount": -2595.66
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 1397.98,
"details": [
{
"name": "Invoices",
"amount": 1397.98
}
]
}
]
}
]
},
{
"customerId": "f67eab14-12f1-432f-af73-81ebf6ec8ddc",
"customerName": "Neoma Kreiger",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -3047.62,
"details": [
{
"name": "CreditNotes",
"amount": -3047.62
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "2d6a5c2d-80dc-4aac-8909-ddfb3cb24437",
"customerName": "Newton Zieme",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -225.44,
"details": [
{
"name": "CreditNotes",
"amount": -225.44
},
{
"name": "Invoices",
"amount": 0
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "976a2402-0908-46d9-9121-a93005d29c01",
"customerName": "Norbert Tillman",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -537.61,
"details": [
{
"name": "CreditNotes",
"amount": -537.61
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "453ddfc0-49ce-4f66-a815-dae734be885c",
"customerName": "Ralph Wilderman",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -2538.49,
"details": [
{
"name": "CreditNotes",
"amount": -2538.49
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
},
{
"customerId": "51f03576-f6b0-40d5-9fba-81a490411c03",
"customerName": "Raul Johns",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -4403.5,
"details": [
{
"name": "CreditNotes",
"amount": -4403.5
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 3477.81,
"details": [
{
"name": "Invoices",
"amount": 3477.81
}
]
}
]
}
]
},
{
"customerId": "84539fde-118f-48ed-978d-0aa50c7ec223",
"customerName": "Rodger Feest",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -1456.66,
"details": [
{
"name": "CreditNotes",
"amount": -1456.66
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 7366.21,
"details": [
{
"name": "Invoices",
"amount": 7366.21
}
]
}
]
}
]
},
{
"customerId": "dc75136b-b504-49c5-be35-04e1d2771e1e",
"customerName": "Vincenzo Wolff",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -80.97,
"details": [
{
"name": "CreditNotes",
"amount": -80.97
},
{
"name": "Invoices",
"amount": 0
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Invoices",
"amount": 0
}
]
}
]
}
]
}
]
}
},
{
"status": "200",
"contentType": "application/json",
"name": "Dynamics 365 Business Central",
"example": {
"generated": "2023-05-02T16:05:20.8918448Z",
"reportDate": "2023-05-02T16:05:20.8411594Z",
"data": [
{
"customerId": "8ddfa6bf-0c60-eb11-89fa-00224800af18",
"customerName": "Abdi Company",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -80,
"details": [
{
"name": "CreditNotes",
"amount": -80
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": -257.28,
"details": [
{
"name": "Payments",
"amount": -300
},
{
"name": "Invoices",
"amount": 42.72
}
]
}
]
}
]
},
{
"customerId": "b41217b3-89d1-ea11-bbaa-000d3a2b9185",
"customerName": "Adatum Corporation",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -1558.56,
"details": [
{
"name": "CreditNotes",
"amount": -1558.56
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 33200.76,
"details": [
{
"name": "Invoices",
"amount": 34782.32
},
{
"name": "Payments",
"amount": -1581.56
}
]
}
]
},
{
"currency": "HKD",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 8554.46,
"details": [
{
"name": "Invoices",
"amount": 8554.46
}
]
}
]
}
]
},
{
"customerId": "ba1217b3-89d1-ea11-bbaa-000d3a2b9185",
"customerName": "Alpine Ski House",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 7503.08,
"details": [
{
"name": "Invoices",
"amount": 7503.08
}
]
}
]
}
]
},
{
"customerId": "f5860a8e-4b5a-eb11-89fa-00224800af18",
"customerName": "CustomerQA",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 349.68,
"details": [
{
"name": "Invoices",
"amount": 349.68
}
]
}
]
}
]
},
{
"customerId": "feef29a2-1d59-ed11-8c36-002248c5e6c0",
"customerName": "DP Test Customer",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 332.2,
"details": [
{
"name": "Invoices",
"amount": 427.2
},
{
"name": "Payments",
"amount": -95
}
]
}
]
}
]
},
{
"customerId": "264d74d4-3218-ed11-90eb-000d3a873415",
"customerName": "Eliana",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -779.28,
"details": [
{
"name": "CreditNotes",
"amount": -779.28
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 1905,
"details": [
{
"name": "Invoices",
"amount": 1905
}
]
}
]
}
]
},
{
"customerId": "99faf6fb-5209-eb11-bbf6-0022481ad2e8",
"customerName": "QA Customer",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 4923.48,
"details": [
{
"name": "Invoices",
"amount": 4923.48
}
]
}
]
}
]
},
{
"customerId": "bc1217b3-89d1-ea11-bbaa-000d3a2b9185",
"customerName": "Relecloud",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 10559.04,
"details": [
{
"name": "Invoices",
"amount": 10559.04
}
]
}
]
}
]
},
{
"customerId": "b81217b3-89d1-ea11-bbaa-000d3a2b9185",
"customerName": "School of Fine Art",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 33438.88,
"details": [
{
"name": "Invoices",
"amount": 34811.2
},
{
"name": "Payments",
"amount": -1372.32
}
]
}
]
}
]
},
{
"customerId": "dc3f4f1b-3c54-ed11-9470-002248c5e18c",
"customerName": "Test no payment terms",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 10,
"details": [
{
"name": "Invoices",
"amount": 10
}
]
}
]
}
]
},
{
"customerId": "9e55a119-064e-ed11-946f-0022481b84d7",
"customerName": "Test Push",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 126,
"details": [
{
"name": "Invoices",
"amount": 126
}
]
}
]
}
]
},
{
"customerId": "b30ca600-074e-ed11-946f-0022481b84d7",
"customerName": "Test Push",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 116,
"details": [
{
"name": "Invoices",
"amount": 116
}
]
}
]
}
]
},
{
"customerId": "b61217b3-89d1-ea11-bbaa-000d3a2b9185",
"customerName": "Trey Researches",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -24,
"details": [
{
"name": "CreditNotes",
"amount": -24
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-
# --- truncated at 32 KB (225 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/codat/refs/heads/main/examples/codat-get-accounting-aged-debtors-report-example.json