Retrieve AR Invoice Memo Log By Code
    • 06 Jan 2025
    • 1 Minute to read
    • Dark
      Light

    Retrieve AR Invoice Memo Log By Code

    • Dark
      Light

    Article summary

    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.

    ParameterDescriptionSample
    compCodeCompany Code001
    bchNumBatch Number233595
    invNumInvoice Number14001.W1552

    Find By Date

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

    ParameterDescriptionSample
    AuditDateCreate or Update Date Time Filter2022-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

    OK

    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