API Catalog

Retrieve AR Outstanding Invoices By Code

06 Jan 2025
5 Minutes to read

Print
Dark
Light

Retrieve AR Outstanding Invoices By Code

Updated on 06 Jan 2025
5 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/ar-rest-api/rest/1/arinvoutstanding

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select Invoices
Select By Date
Primary Key

Select Invoices

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
FromInvoiceDateVar	Start of the Invoice Date Range	2016-01-01
ToInvoiceDateVar	End of the Invoice Date Range	2016-01-30
FromDueDateVar	Start of the Due Date Range	2016-02-01
ToDueDateVar	End of the Due Date Range	2016-02-21
InvCodeVar	Invoice Code	04201.0021
CustomerCodeVar	Customer Code	11-0588
CompCodeVar	Company Code	001

Select By Date

This is the optional finder for querying Outstanding Invoices by Audit Date.

Parameter	Description	Sample
AuditDate	Create or Update Date Time Filter	2023-12-27

Primary Key

This is an optional finder for querying a specific Outstanding Invoice by the Primary Key (combination of Invoice Code and Company Code)

Parameter	Description	Sample
InvCodeVar	Invoice Code	04201.0021
CompCodeVar	Company Code	001

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectInvoices; FromInvoiceDateVar=2016-01-01, ToDueDateVar=2020-01-01, ToInvoiceDateVar=2020-01-01, FromDueDateVar=2016-01-01, InvCodeVar=04201.0021, CustomerCodeVar=11-0588, CompCodeVar=001

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

ExampleTrue

orderBy

string

ExampleInvoiceCode:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

example-0

Successful Response - Finder - selectByDate

{
  "items": [
    {
      "CompanyCode": "001",
      "CustomerCode": "46001",
      "InvoiceCode": "04201.0021",
      "InvoiceDate": "2017-12-31",
      "InvDueDate": "2018-01-30",
      "OutstandingAmount": 22114.3,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 22114.3,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 22114.3,
      "InvIuCreateDate": "2018-01-03T19:07:44Z",
      "InvIuUpdateDate": "2018-01-03T19:07:44Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30343230312E30303231",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30343230312E30303231",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "05118.0029",
      "InvoiceDate": "2017-12-31",
      "InvDueDate": "2018-01-30",
      "OutstandingAmount": 3600,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 3600,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 3600,
      "InvIuCreateDate": "2018-01-03T19:07:56Z",
      "InvIuUpdateDate": "2018-01-03T19:07:56Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303239",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303239",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "05118.0027",
      "InvoiceDate": "2017-12-31",
      "InvDueDate": "2018-01-30",
      "OutstandingAmount": 82406.87,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 82406.87,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 82406.87,
      "InvIuCreateDate": "2018-01-03T19:07:56Z",
      "InvIuUpdateDate": "2018-01-03T19:07:56Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303237",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303237",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "1020",
      "InvoiceCode": "06201.0010",
      "InvoiceDate": "2017-12-31",
      "InvDueDate": "2018-01-30",
      "OutstandingAmount": 34961.69,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 34961.69,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 34961.69,
      "InvIuCreateDate": "2018-01-03T19:08:03Z",
      "InvIuUpdateDate": "2018-01-03T19:08:03Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30363230312E30303130",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30363230312E30303130",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "0007-05-20T00:00:00Z",
      "InvoiceDate": "2017-12-15",
      "InvDueDate": "2018-01-14",
      "OutstandingAmount": 93532.38,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 93532.38,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 93532.38,
      "InvIuCreateDate": "2018-01-03T19:13:25Z",
      "InvIuUpdateDate": "2018-01-03T19:13:25Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30352D32302E30303037",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30352D32302E30303037",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "ULV",
      "InvoiceCode": "1580.0001",
      "InvoiceDate": "2018-03-21",
      "InvDueDate": "2018-04-20",
      "OutstandingAmount": 173.25,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 173.25,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 173.25,
      "InvIuCreateDate": "2018-03-21T15:58:25Z",
      "InvIuUpdateDate": "2018-03-21T15:58:25Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/00020000000330303100000009313538302E30303031",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/00020000000330303100000009313538302E30303031",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "CITYOFED",
      "InvoiceCode": "WO20..0001",
      "InvoiceDate": "2020-02-07",
      "InvDueDate": "2020-03-08",
      "OutstandingAmount": 266.88,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 266.88,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 266.88,
      "InvIuCreateDate": "2020-02-02T19:59:50Z",
      "InvIuUpdateDate": "2020-02-02T19:59:50Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A574F32302E2E30303031",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A574F32302E2E30303031",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "WOYY..0001",
      "InvoiceDate": "2020-08-11",
      "InvDueDate": "2020-09-10",
      "OutstandingAmount": 1625.63,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 1625.63,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 1625.63,
      "InvIuCreateDate": "2020-08-11T16:07:06Z",
      "InvIuUpdateDate": "2020-08-11T16:07:06Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A574F59592E2E30303031",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A574F59592E2E30303031",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "22222",
      "InvoiceCode": "WOYY..0003",
      "InvoiceDate": "2020-08-24",
      "InvDueDate": "2020-09-23",
      "OutstandingAmount": 1750,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 1750,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 1750,
      "InvIuCreateDate": "2020-08-24T14:46:50Z",
      "InvIuUpdateDate": "2020-08-24T14:46:50Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A574F59592E2E30303033",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A574F59592E2E30303033",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 9,
  "hasMore": false,
  "limit": 100,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding",
      "name": "arinvoutstanding",
      "kind": "collection"
    }
  ]
}

example-1

Successful Response - Finder - selectInvoices

{
  "items": [
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "05118.0029",
      "InvoiceDate": "2017-12-31",
      "InvDueDate": "2018-01-30",
      "OutstandingAmount": 3600,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 3600,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 3600,
      "InvIuCreateDate": "2018-01-03T19:07:56Z",
      "InvIuUpdateDate": "2018-01-03T19:07:56Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303239",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303239",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "05118.0027",
      "InvoiceDate": "2017-12-31",
      "InvDueDate": "2018-01-30",
      "OutstandingAmount": 82406.87,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 82406.87,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 82406.87,
      "InvIuCreateDate": "2018-01-03T19:07:56Z",
      "InvIuUpdateDate": "2018-01-03T19:07:56Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303237",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30353131382E30303237",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    },
    {
      "CompanyCode": "001",
      "CustomerCode": "0588-11-01T00:00:00Z",
      "InvoiceCode": "0007-05-20T00:00:00Z",
      "InvoiceDate": "2017-12-15",
      "InvDueDate": "2018-01-14",
      "OutstandingAmount": 93532.38,
      "OutstandingBucketName": "Over 120 days",
      "OutstandingBucketName4": "Over 90 days",
      "OutstandingBucketLabel": "Over 120",
      "OutstandingBucketLabel4": "Over 90",
      "OutstandingAmountCurrent": null,
      "OutstandingAmount31To60": null,
      "OutstandingAmount61To90": null,
      "OutstandingAmountOver90": 93532.38,
      "OutstandingAmount91To120": null,
      "OutstandingAmountOver120": 93532.38,
      "InvIuCreateDate": "2018-01-03T19:13:25Z",
      "InvIuUpdateDate": "2018-01-03T19:13:25Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30352D32302E30303037",
          "name": "arinvoutstanding",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding/0002000000033030310000000A30352D32302E30303037",
          "name": "arinvoutstanding",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 3,
  "hasMore": false,
  "limit": 100,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoutstanding",
      "name": "arinvoutstanding",
      "kind": "collection"
    }
  ]
}

object

What's Next

Retrieve a specific AR Tax Item By VUUID

Retrieve AR Outstanding Invoices By Code

Query Standards

Finder

Select Invoices

Select By Date

Primary Key

What's Next

Contact Us