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
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"
}
]
}example-2
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"
}
]
}example-3
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"
}
]
}object