> ## Documentation Index > Fetch the complete documentation index at: https://developers.cmicglobal.com/llms.txt > Use this file to discover all available pages before exploring further. # Retrieve AR Outstanding Invoices By Code > ## 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 | ## OpenAPI ````json GET /ar-rest-api/rest/1/arinvoutstanding { "openapi": "3.0.0", "info": { "title": "API Catalog", "description": "", "version": "1.0.0" }, "servers": [ { "url": "https://mobtest.cmiccloudr12.com/cmictestrti", "description": "CMIC API Server" } ], "security": [ { "cmicBasicAuth": [] } ], "tags": [ { "name": "Highlights" }, { "name": "Asset Management | Equipment" }, { "name": "Asset Management | Fixed Assets" }, { "name": "Asset Management | Purchase Order" }, { "name": "Asset Management | Inventory" }, { "name": "Asset Management | Requisition" }, { "name": "Asset Management | Purchase Change Order" }, { "name": "Bim Model" }, { "name": "Bim Model Revision" }, { "name": "Bim Tag Model" }, { "name": "Bim Tags" }, { "name": "Bim FileUpload Jersey" }, { "name": "Core System | Business Partners" }, { "name": "Core System | Business Partner Addresses" }, { "name": "Core System | Bank" }, { "name": "Core System | Currency" }, { "name": "Core System | Exchange Rates" }, { "name": "Core System | Global Table Text Codes" }, { "name": "Core System | Global Table Regions" }, { "name": "Core System | Terms" }, { "name": "Core System | System Contact" }, { "name": "Core System | Weight Measures" }, { "name": "Core System | Field User Defined Classifiers" }, { "name": "Core System | User Defined Classifiers by Object" }, { "name": "Core System | User Extension Definitions by Object" }, { "name": "Core System | User Extention Field Data Value" }, { "name": "Core System | User Extension Values by Object" }, { "name": "Core System | User System Role" }, { "name": "Core System | User Project Role" }, { "name": "Core System | Documents by Object" }, { "name": "Core System | Audit Status Log by Object" }, { "name": "Core System | Licensed Users" }, { "name": "Core System | Company Access" }, { "name": "Core System | Copy User Settings" }, { "name": "Core System | User Maintenance" }, { "name": "Core System | User Roles" }, { "name": "Core System | Security Groups" }, { "name": "Core System | Job/Project Security" }, { "name": "Core System | Weight Measure with Conversions Code" }, { "name": "Core System | Weight Measure Conversions Code" }, { "name": "Core System | User-defined-fields" }, { "name": "Core System | User-extension" }, { "name": "ECM and Workflow | Image Manager" }, { "name": "Financials | General Ledger" }, { "name": "Financials | Accounts Payable" }, { "name": "Financials | Accounts Receivable" }, { "name": "Preventative Maintenance | Issue Work Orders" }, { "name": "Preventative Maintenance | Issue Work Items" }, { "name": "Preventative Maintenance | Issue Work Budgets" }, { "name": "Preventative Maintenance | Issue Priorities" }, { "name": "Preventative Maintenance | Issue Status" }, { "name": "Preventative Maintenance | Issue Types" }, { "name": "Preventative Maintenance | Accumulative Equipment" }, { "name": "Preventative Maintenance | Work Orders" }, { "name": "Preventative Maintenance | Work Items" }, { "name": "Preventative Maintenance | Work Budgets" }, { "name": "Preventative Maintenance | Priorities" }, { "name": "Preventative Maintenance | Tasks" }, { "name": "HCM | UKG Pay Deductions" }, { "name": "HCM | UKG Pay Earnings" }, { "name": "HCM | UKG Pay Headers" }, { "name": "HCM | UKG Pay Taxes" }, { "name": "HCM | Payroll Geographical States" }, { "name": "HCM | Payroll Trades" }, { "name": "HCM | Payroll Union" }, { "name": "HCM | Payroll Pay Runs" }, { "name": "HCM | Payroll Pay Groups" }, { "name": "HCM | Payroll Tax" }, { "name": "HCM | Payroll Worker Compensation" }, { "name": "HCM | Payroll Work Locations" }, { "name": "HCM | Payroll Trade Pay Rates" }, { "name": "HCM | Payroll Union Pay Rates" }, { "name": "HCM | Payroll Job Pay Rates" }, { "name": "HCM | Payroll Master Benefits" }, { "name": "HCM | Payroll Master Deductions" }, { "name": "HCM | Payroll Ben/Ded/Leave Base Codes" }, { "name": "HCM | Payroll Ben/Ded Plans" }, { "name": "HCM | Payroll Ben/Ded Plan Options" }, { "name": "HCM | Payroll Company Benefits" }, { "name": "HCM | Payroll Company Deductions" }, { "name": "HCM | Payroll Vertex Geographic Locations" }, { "name": "HCM | Payroll Checks" }, { "name": "HCM | Payroll Timesheets" }, { "name": "HCM | Employee" }, { "name": "HCM | Employee (Minimum payload)" }, { "name": "HCM | Employee History" }, { "name": "HCM | Tax Exemptions" }, { "name": "HCM | Employee Tax Overrides" }, { "name": "HCM | Employee Pay Splits" }, { "name": "HCM | Employee Benefits" }, { "name": "HCM | Employee Clock In and Out" }, { "name": "HCM | Employee Deductions" }, { "name": "HCM | Employee Leaves" }, { "name": "HCM | Employee Leave History" }, { "name": "HCM | Employee Hour Types" }, { "name": "HCM | Employee Pay History" }, { "name": "HCM | Employee Work Statuses" }, { "name": "HCM | Employee Security Group" }, { "name": "HCM | Crewtime Crew" }, { "name": "HCM | Crewtime Employee Timesheet" }, { "name": "HCM | Crewtime Equipment Timesheet" }, { "name": "HCM | Crew Maintenance Activity Assignment" }, { "name": "HCM | Crew Maintenance Member Assignment" }, { "name": "HCM | Crew Maintenance Member Trade and Union Assignment" }, { "name": "HCM | Crew Maintenance Equipment Assignment" }, { "name": "HCM | Crew Maintenance Equipment Detail Assignment" }, { "name": "HCM | HR Requisitions" }, { "name": "HCM | HR Relations" }, { "name": "HCM | HR Employee Skills" }, { "name": "HCM | HR Incident" }, { "name": "HCM | HR Employee Relatives / Dependents" }, { "name": "HCM | HR Employee Positions" }, { "name": "HCM | HR Applicants" }, { "name": "HCM | HR Applications" }, { "name": "HCM | Vertex Location City" }, { "name": "HCM | HR Application History" }, { "name": "HCM | HR Dependent Benefits" }, { "name": "HCM | HR Dependent Deductions" }, { "name": "HCM | HR Employee Elected Plans" }, { "name": "HCM | HR Employee Training Certifications" }, { "name": "HCM | HR Trainings" }, { "name": "HCM | E-Timesheets" }, { "name": "HCM | System Contacts" }, { "name": "HCM | System User Payroll Security Group" }, { "name": "HCM | Payroll Timesheet Posting" }, { "name": "HCM | CrewTimesheet Posting" }, { "name": "HCM | HR Positions Master" }, { "name": "HCM | Payroll Pay Periods" }, { "name": "HCM | Payroll Rate Codes" }, { "name": "HCM | Payroll Overhead Codes and Rates" }, { "name": "HCM | Payroll Assigned Overhead to Jobs" }, { "name": "Materials Management | Material Sale Orders" }, { "name": "Materials Management | Material Sale Orders Details" }, { "name": "Materials Management | Truck Rate Detail" }, { "name": "Opportunity Management | Competitors" }, { "name": "Opportunity Management | Opportunities" }, { "name": "Opportunity Management | Revenue Details" }, { "name": "Opportunity Management | Opportunity History" }, { "name": "Opportunity Management | Organization" }, { "name": "Project Controls | Job Billing" }, { "name": "Project Controls | Job Cost" }, { "name": "Project Controls | PCI Details" }, { "name": "Project Controls | Unposted PCI Details" }, { "name": "Project Controls | PCI Headers" }, { "name": "Project Controls | Owner Change Orders" }, { "name": "Project Controls | CM Statuses" }, { "name": "Project Controls | CM Types" }, { "name": "Project Controls | CM Vendor Details" }, { "name": "Project Controls | Post PCI" }, { "name": "Project Management | Uploading Documents" }, { "name": "Project Management | Downloading Documents" }, { "name": "Project Management | Foreign Bid Item Imports" }, { "name": "Project Management | Communications" }, { "name": "Project Management | Daily Journals" }, { "name": "Project Management | Communications Types" }, { "name": "Project Management | Daily Journal Daily Work Plans" }, { "name": "Project Management | Daily Journal Field Forces" }, { "name": "Project Management | Daily Journal Labour" }, { "name": "Project Management | Daily Journal Materials" }, { "name": "Project Management | Daily Journal Owner Equipment" }, { "name": "Project Management | Daily Journal Quality Control" }, { "name": "Project Management | Daily Journal Tasks" }, { "name": "Project Management | Daily Journal Trade Equipment" }, { "name": "Project Management | Daily Journal Transactions" }, { "name": "Project Management | Daily Journal User Defined Data" }, { "name": "Project Management | Daily Journal Visitors" }, { "name": "Project Management | Daily Journal Bill Details" }, { "name": "Project Management | Field Work Directives" }, { "name": "Project Management | Contract Types" }, { "name": "Project Management | Company Contacts" }, { "name": "Project Management | Distribution BCC" }, { "name": "Project Management | Distribution CC" }, { "name": "Project Management | Field Work Directive Statuses" }, { "name": "Project Management | Issues" }, { "name": "Project Management | Key Players" }, { "name": "Project Management | Meetings" }, { "name": "Project Management | Meeting Attendees" }, { "name": "Project Management | Meeting Item Statuses" }, { "name": "Project Management | Meeting Tracks" }, { "name": "Project Management | Notes" }, { "name": "Project Management | Projects" }, { "name": "Project Management | Project Items" }, { "name": "Project Management | Project Item Phase Segment Sums" }, { "name": "Project Management | Project Partners" }, { "name": "Project Management | Notices" }, { "name": "Project Management | Notice Statuses" }, { "name": "Project Management | Owner JS Query" }, { "name": "Project Management | PCI Real Locations" }, { "name": "Project Management | Project Contacts" }, { "name": "Project Management | RFIs (Requests for Information)" }, { "name": "Project Management | RFI Statuses" }, { "name": "Project Management | Submittal Packages" }, { "name": "Project Management | Submittal Package Details" }, { "name": "Project Management | Submittal Package Status" }, { "name": "Project Management | Submittals" }, { "name": "Project Management | Submittal Status" }, { "name": "Project Management | Transmittals" }, { "name": "Project Management | Subcontract Headers" }, { "name": "Project Management | Subcontract Schedules" }, { "name": "Project Management | Subcontract Sechedule Phase Segment Sums" }, { "name": "Project Management | User Roles" }, { "name": "Project Management | Punchlists" }, { "name": "Project Management | Punchlist Details" }, { "name": "Project Management | Punchlist Statuses" }, { "name": "Project Management | Meeting Items" }, { "name": "Project Management | Self Perform Vendor" }, { "name": "Project Management | Submittal Types" }, { "name": "Project Management | Assign contact and partner to project" }, { "name": "Project Management | Subcontract Prequal" }, { "name": "Project Management | Bid Item Package" } ], "paths": { "/ar-rest-api/rest/1/arinvoutstanding": { "get": { "tags": [ "Financials | Accounts Receivable" ], "summary": "Retrieve AR Outstanding Invoices By Code", "description": "## Query Standards\n\n\n### Finder\n\nFollowing row finders are available for data filtering and optimizing request performance.\n\n- Select Invoices\n- Select By Date\n- Primary Key\n \n\n#### Select Invoices\n\nRecommended finder parameters. Refer to Query Parameters for example.\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| FromInvoiceDateVar | Start of the Invoice Date Range | 2016-01-01 |\n| ToInvoiceDateVar | End of the Invoice Date Range | 2016-01-30 |\n| FromDueDateVar | Start of the Due Date Range | 2016-02-01 |\n| ToDueDateVar | End of the Due Date Range | 2016-02-21 |\n| InvCodeVar | Invoice Code | 04201.0021 |\n| CustomerCodeVar | Customer Code | 11-0588 |\n| CompCodeVar | Company Code | 001 |\n\n#### Select By Date\n\nThis is the optional finder for querying Outstanding Invoices by Audit Date.\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| AuditDate | Create or Update Date Time Filter | 2023-12-27 |\n\n#### Primary Key\n\nThis is an optional finder for querying a specific Outstanding Invoice by the Primary Key (combination of Invoice Code and Company Code)\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| InvCodeVar | Invoice Code | 04201.0021 |\n| CompCodeVar | Company Code | 001 |", "parameters": [ { "name": "finder", "in": "query", "schema": { "type": "string" }, "example": "selectInvoices; FromInvoiceDateVar=2016-01-01, ToDueDateVar=2020-01-01, ToInvoiceDateVar=2020-01-01, FromDueDateVar=2016-01-01, InvCodeVar=04201.0021, CustomerCodeVar=11-0588, CompCodeVar=001" }, { "name": "limit", "in": "query", "schema": { "type": "integer" }, "example": "500" }, { "name": "offset", "in": "query", "schema": { "type": "integer" }, "example": "0" }, { "name": "totalResults", "in": "query", "schema": { "type": "boolean" }, "example": "true" }, { "name": "orderBy", "in": "query", "schema": { "type": "string" }, "example": "InvoiceCode:desc" } ], "responses": { "200": { "description": "OK", "headers": { "Content-Type": { "schema": { "type": "string", "example": "application/vnd.oracle.adf.resourcecollection+json" } } }, "content": { "application/json": { "schema": { "type": "object" }, "examples": { "example-0": { "summary": "Successful Response - Finder - selectByDate", "value": { "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:44+00:00", "InvIuUpdateDate": "2018-01-03T19:07:44+00:00", "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": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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:03+00:00", "InvIuUpdateDate": "2018-01-03T19:08:03+00:00", "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": "11-0588", "InvoiceCode": "05-20.0007", "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:25+00:00", "InvIuUpdateDate": "2018-01-03T19:13:25+00:00", "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:25+00:00", "InvIuUpdateDate": "2018-03-21T15:58:25+00:00", "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:50+00:00", "InvIuUpdateDate": "2020-02-02T19:59:50+00:00", "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": "11-0588", "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:06+00:00", "InvIuUpdateDate": "2020-08-11T16:07:06+00:00", "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:50+00:00", "InvIuUpdateDate": "2020-08-24T14:46:50+00:00", "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": { "summary": "Successful Response - Finder - selectInvoices", "value": { "items": [ { "CompanyCode": "001", "CustomerCode": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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": "11-0588", "InvoiceCode": "05-20.0007", "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:25+00:00", "InvIuUpdateDate": "2018-01-03T19:13:25+00:00", "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" } ] } }, "example-2": { "summary": "Successful Response - Finder - selectByDate", "value": { "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:44+00:00", "InvIuUpdateDate": "2018-01-03T19:07:44+00:00", "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": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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:03+00:00", "InvIuUpdateDate": "2018-01-03T19:08:03+00:00", "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": "11-0588", "InvoiceCode": "05-20.0007", "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:25+00:00", "InvIuUpdateDate": "2018-01-03T19:13:25+00:00", "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:25+00:00", "InvIuUpdateDate": "2018-03-21T15:58:25+00:00", "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:50+00:00", "InvIuUpdateDate": "2020-02-02T19:59:50+00:00", "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": "11-0588", "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:06+00:00", "InvIuUpdateDate": "2020-08-11T16:07:06+00:00", "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:50+00:00", "InvIuUpdateDate": "2020-08-24T14:46:50+00:00", "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-3": { "summary": "Successful Response - Finder - selectInvoices", "value": { "items": [ { "CompanyCode": "001", "CustomerCode": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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": "11-0588", "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:56+00:00", "InvIuUpdateDate": "2018-01-03T19:07:56+00:00", "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": "11-0588", "InvoiceCode": "05-20.0007", "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:25+00:00", "InvIuUpdateDate": "2018-01-03T19:13:25+00:00", "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" } ] } } } } } } } } } }, "components": { "securitySchemes": { "cmicBasicAuth": { "type": "http", "scheme": "basic", "description": "Basic authentication" } } } } ````