API Catalog

Retrieve AR Invoice Memo Log By Code

13 Jun 2025
1 Minute to read

Print
Dark
Light

Retrieve AR Invoice Memo Log By Code

Updated on 13 Jun 2025
1 Minute to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Get

/ar-rest-api/rest/1/arinvmemolog

Query Standards

Finder

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

select Memo Log
Select By Date
By UUID

Select Memo Log

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
compCode	Company Code	001
bchNum	Batch Number	233595
invNum	Invoice Number	14001.W1552

Find By Date

This is the recommended finder for querying Memo Logs by Audit Date.

Parameter	Description	Sample
AuditDate	Create or Update Date Time Filter	2022-12-20

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectMemoLog;compCode=001,bchNum=233595,invNum=14001.W1552

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleArinvmemoInvNum:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

example-0

Successful Response - Finder - selectMemoLog

{
  "items": [
    {
      "ArinvmemoApplyNum": "14001.0010",
      "ArinvmemoArAmt": -238088.77,
      "ArinvmemoBchNum": 233595,
      "ArinvmemoCompCode": "001",
      "ArinvmemoCurrCode": "USD",
      "ArinvmemoCustCode": "ULV",
      "ArinvmemoDate": "2016-01-01",
      "ArinvmemoDesc": "Void JB Draw 10 Revision 0 - ",
      "ArinvmemoDetTaxAmt": null,
      "ArinvmemoDiscAmt": 0,
      "ArinvmemoFrtAmt": null,
      "ArinvmemoHldbkAmt": -23803.15,
      "ArinvmemoInsAmt": null,
      "ArinvmemoInvNum": "14001.W1552",
      "ArinvmemoMemoAmt": -238088.77,
      "ArinvmemoMiscAmt": null,
      "ArinvmemoNodiscAmt": 23803.15,
      "ArinvmemoOePrtCode": null,
      "ArinvmemoOrdNum": "14001",
      "ArinvmemoOrigArAmt": 238088.77,
      "ArinvmemoOrigDiscAmt": 0,
      "ArinvmemoOrigHldbkAmt": 23803.15,
      "ArinvmemoOrigInvNum": "14001.0010",
      "ArinvmemoOrigMemoAmt": 238088.77,
      "ArinvmemoOrigOsAmt": 214285.62,
      "ArinvmemoOrigSalesAmt": 238088.77,
      "ArinvmemoOsAmt": 0,
      "ArinvmemoPostDate": "2016-01-31",
      "ArinvmemoSalesAmt": -238088.77,
      "ArinvmemoSdiscAmt": 0,
      "ArinvmemoSman1CommAmt": null,
      "ArinvmemoSman2CommAmt": null,
      "ArinvmemoSman3CommAmt": null,
      "ArinvmemoTax1Amt": 0,
      "ArinvmemoTax1Code": null,
      "ArinvmemoTax1HldbkAmt": 0,
      "ArinvmemoTax1TaxableFlag": "Y",
      "ArinvmemoTax2Amt": 0,
      "ArinvmemoTax2Code": null,
      "ArinvmemoTax2TaxableFlag": "Y",
      "ArinvmemoTax3Amt": 0,
      "ArinvmemoTax3Code": null,
      "ArinvmemoTax3TaxableFlag": "Y",
      "ArinvmemoIuCreateDate": "2016-05-06T20:31:06Z",
      "ArinvmemoIuUpdateDate": "2016-05-06T20:31:07Z",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvmemolog/000300000004C3182460000000033030310000000B31343030312E5731353532",
          "name": "arinvmemolog",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvmemolog/000300000004C3182460000000033030310000000B31343030312E5731353532",
          "name": "arinvmemolog",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvmemolog",
      "name": "arinvmemolog",
      "kind": "collection"
    }
  ]
}

example-1

Successful Response - Finder - selectByDate

{
  "items": [],
  "count": 0,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvmemolog",
      "name": "arinvmemolog",
      "kind": "collection"
    }
  ]
}

object

What's Next

Retrieve AR Payments by Code

Retrieve AR Invoice Memo Log By Code

Query Standards

Finder

Select Memo Log

Find By Date

What's Next

Contact Us