> ## 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 Outstanding Invoice By Code > ## Query Standards ### Finder Following row finders are available for data filtering and optimizing request performance. - selectInvoices - selectByDate - By UUID #### Select Invoices Recommended finder parameters. Refer to Query Parameters for example. ##### Parameters | Parameter | Description | Example | | --- | --- | --- | | FromInvoiceDateVar | From Date | 2022-02-19 | | ToInvoiceDateVar | To Date | 2022-09-10 | | InvCodeVar | Invoice Code | YFKUJYHF-01 | | VendorCodeVar | Vendor Code | HOLMES | | CompanyCodeVar | Company Code | 001 | #### Select by Audit Date This is an optional finder for querying Outstanding Invoices by Audit Date. | Parameter | Description | Sample | | --- | --- | --- | | AuditDate | Create or Update Date Time Filter | 2022-12-20 | #### By UUID This is an optional finder for querying a specific Outstanding Invoice by row ID. | Parameter | Description | Sample | | --- | --- | --- | | /VUUID | The VUuid attribute is the Unique row ID | /ap-rest-api/rest/1/apinvoutstanding/:83166994 | ## OpenAPI ````json GET /ap-rest-api/rest/1/apinvoutstanding { "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": { "/ap-rest-api/rest/1/apinvoutstanding": { "get": { "tags": [ "Financials | Accounts Payable" ], "summary": "Retrieve Outstanding Invoice By Code", "description": "## Query Standards\n\n### Finder\n\nFollowing row finders are available for data filtering and optimizing request performance.\n\n- selectInvoices\n- selectByDate\n- By UUID\n \n\n#### Select Invoices\n\nRecommended finder parameters. Refer to Query Parameters for example.\n\n##### Parameters\n\n| Parameter | Description | Example |\n| --- | --- | --- |\n| FromInvoiceDateVar | From Date | 2022-02-19 |\n| ToInvoiceDateVar | To Date | 2022-09-10 |\n| InvCodeVar | Invoice Code | YFKUJYHF-01 |\n| VendorCodeVar | Vendor Code | HOLMES |\n| CompanyCodeVar | Company Code | 001 |\n\n#### Select by Audit Date\n\nThis is an optional finder for querying Outstanding Invoices by Audit Date.\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| AuditDate | Create or Update Date Time Filter | 2022-12-20 |\n\n#### By UUID\n\nThis is an optional finder for querying a specific Outstanding Invoice by row ID.\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| /VUUID | The VUuid attribute is the Unique row ID | /ap-rest-api/rest/1/apinvoutstanding/:83166994 |", "parameters": [ { "name": "finder", "in": "query", "schema": { "type": "string" }, "example": "selectInvoices; FromInvoiceDateVar= 2022-02-19, ToInvoiceDateVar=2022-09-10, InvCodeVar=YFKUJYHF-01, VendorCodeVar=HOLMES, CompanyCodeVar=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", "VendorCode": "HOLMES", "InvoiceCode": "001", "InvoiceVoucherNum": 82637199, "InvoiceDate": "2019-02-05T05:00:00+00:00", "DueDate": "2019-03-07T05:00:00+00:00", "PostedDate": "2020-09-22T04:00:00+00:00", "OutstandingAmount": 201814.44, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 201814.44, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 201814.44, "AmountOverDue": 201814.44, "AmountOverDueOver30Days": 201814.44, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2019-02-05T16:06:30+00:00", "RecordCreatedUser": "CHET", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/82637199", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/82637199", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "YFKUJYHF-01", "InvoiceVoucherNum": 2021262722, "InvoiceDate": "2022-08-24T04:00:00+00:00", "DueDate": "2022-08-24T04:00:00+00:00", "PostedDate": "2022-08-24T04:00:00+00:00", "OutstandingAmount": 45000, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 45000, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 45000, "AmountOverDue": 45000, "AmountOverDueOver30Days": 45000, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2022-08-25T01:19:57+00:00", "RecordCreatedUser": "RYVIT", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "TEST", "InvoiceVoucherNum": 2021262298, "InvoiceDate": "2021-06-17T04:00:00+00:00", "DueDate": "2021-07-17T04:00:00+00:00", "PostedDate": "2022-12-09T05:00:00+00:00", "OutstandingAmount": 13, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 13, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 13, "AmountOverDue": 13, "AmountOverDueOver30Days": 13, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2022-12-09T19:38:56+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2021-06-18T16:26:37+00:00", "RecordCreatedUser": "FLASHTRACTUSER", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262298", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262298", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "0345.001-1", "InvoiceVoucherNum": 2021262945, "InvoiceDate": "2022-12-31T05:00:00+00:00", "DueDate": "2022-12-23T05:00:00+00:00", "PostedDate": "2022-12-09T05:00:00+00:00", "OutstandingAmount": 1049.75, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 1049.75, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 1049.75, "AmountOverDue": 1049.75, "AmountOverDueOver30Days": 1049.75, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2022-12-09T19:02:28+00:00", "RecordCreatedUser": "GCPAY", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262945", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262945", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "90223", "InvoiceCode": "20200805", "InvoiceVoucherNum": 200797915, "InvoiceDate": "2020-08-05T04:00:00+00:00", "DueDate": "2020-09-04T04:00:00+00:00", "PostedDate": "2022-12-09T05:00:00+00:00", "OutstandingAmount": 9000, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 9000, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 9000, "AmountOverDue": 9000, "AmountOverDueOver30Days": 9000, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2022-12-09T19:38:56+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2020-08-05T13:15:29+00:00", "RecordCreatedUser": "BILL", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/200797915", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/200797915", "name": "apinvoutstanding", "kind": "item" } ] } ], "count": 5, "hasMore": true, "limit": 5, "offset": 0, "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding", "name": "apinvoutstanding", "kind": "collection" } ] } }, "example-1": { "summary": "Successful Response - Finder - selectInvoices", "value": { "items": [ { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "YFKUJYHF-01", "InvoiceVoucherNum": 2021262722, "InvoiceDate": "2022-08-24T04:00:00+00:00", "DueDate": "2022-08-24T04:00:00+00:00", "PostedDate": "2022-08-24T04:00:00+00:00", "OutstandingAmount": 45000, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 45000, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 45000, "AmountOverDue": 45000, "AmountOverDueOver30Days": 45000, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2022-08-25T01:19:57+00:00", "RecordCreatedUser": "RYVIT", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" } ] } ], "count": 1, "hasMore": false, "limit": 5, "offset": 0, "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding", "name": "apinvoutstanding", "kind": "collection" } ] } }, "example-2": { "summary": "Successful Response - Finder - selectInvoices", "value": { "items": [ { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "YFKUJYHF-01", "InvoiceVoucherNum": 2021262722, "InvoiceDate": "2022-08-24T04:00:00+00:00", "DueDate": "2022-08-24T04:00:00+00:00", "PostedDate": "2022-08-24T04:00:00+00:00", "OutstandingAmount": 45000, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 45000, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 45000, "AmountOverDue": 45000, "AmountOverDueOver30Days": 45000, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2022-08-25T01:19:57+00:00", "RecordCreatedUser": "RYVIT", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" } ] } ], "count": 1, "hasMore": false, "limit": 5, "offset": 0, "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding", "name": "apinvoutstanding", "kind": "collection" } ] } }, "example-3": { "summary": "Successful Response - Finder - selectByDate", "value": { "items": [ { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "001", "InvoiceVoucherNum": 82637199, "InvoiceDate": "2019-02-05T05:00:00+00:00", "DueDate": "2019-03-07T05:00:00+00:00", "PostedDate": "2020-09-22T04:00:00+00:00", "OutstandingAmount": 201814.44, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 201814.44, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 201814.44, "AmountOverDue": 201814.44, "AmountOverDueOver30Days": 201814.44, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2019-02-05T16:06:30+00:00", "RecordCreatedUser": "CHET", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/82637199", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/82637199", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "YFKUJYHF-01", "InvoiceVoucherNum": 2021262722, "InvoiceDate": "2022-08-24T04:00:00+00:00", "DueDate": "2022-08-24T04:00:00+00:00", "PostedDate": "2022-08-24T04:00:00+00:00", "OutstandingAmount": 45000, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 45000, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 45000, "AmountOverDue": 45000, "AmountOverDueOver30Days": 45000, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2022-08-25T01:19:57+00:00", "RecordCreatedUser": "RYVIT", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262722", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "TEST", "InvoiceVoucherNum": 2021262298, "InvoiceDate": "2021-06-17T04:00:00+00:00", "DueDate": "2021-07-17T04:00:00+00:00", "PostedDate": "2022-12-09T05:00:00+00:00", "OutstandingAmount": 13, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 13, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 13, "AmountOverDue": 13, "AmountOverDueOver30Days": 13, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2022-12-09T19:38:56+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2021-06-18T16:26:37+00:00", "RecordCreatedUser": "FLASHTRACTUSER", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262298", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262298", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "HOLMES", "InvoiceCode": "0345.001-1", "InvoiceVoucherNum": 2021262945, "InvoiceDate": "2022-12-31T05:00:00+00:00", "DueDate": "2022-12-23T05:00:00+00:00", "PostedDate": "2022-12-09T05:00:00+00:00", "OutstandingAmount": 1049.75, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 1049.75, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 1049.75, "AmountOverDue": 1049.75, "AmountOverDueOver30Days": 1049.75, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2023-02-07T02:51:07+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2022-12-09T19:02:28+00:00", "RecordCreatedUser": "GCPAY", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262945", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/2021262945", "name": "apinvoutstanding", "kind": "item" } ] }, { "CompanyCode": "001", "VendorCode": "90223", "InvoiceCode": "20200805", "InvoiceVoucherNum": 200797915, "InvoiceDate": "2020-08-05T04:00:00+00:00", "DueDate": "2020-09-04T04:00:00+00:00", "PostedDate": "2022-12-09T05:00:00+00:00", "OutstandingAmount": 9000, "OutstandingBucketName": "Over 120 days", "OutstandingBucketName4": "Over 90 days", "OutstandingBucketLabel": "Over 120", "OutstandingBucketLabel4": "Over 90", "OutstandingAmountCurrent": null, "OutstandingAmount31To60": null, "OutstandingAmount61To90": null, "OutstandingAmountOver90": 9000, "OutstandingAmount91To120": null, "OutstandingAmountOver120": 9000, "AmountOverDue": 9000, "AmountOverDueOver30Days": 9000, "AmountOverDue15To30Days": null, "AmountOverDue8To14Days": null, "AmountOverDue1To7Days": null, "AmountDueToday": null, "AmountDue1To7Days": null, "AmountDue8To14Days": null, "AmountDue15To30Days": null, "AmountDue31To60Days": null, "AmountDue61To90Days": null, "AmountDueOver90Days": null, "LastUpdatedDate": "2022-12-09T19:38:56+00:00", "LastUpdatedUser": "GCPAY", "RecordCreatedDate": "2020-08-05T13:15:29+00:00", "RecordCreatedUser": "BILL", "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/200797915", "name": "apinvoutstanding", "kind": "item" }, { "rel": "canonical", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding/200797915", "name": "apinvoutstanding", "kind": "item" } ] } ], "count": 5, "hasMore": true, "limit": 5, "offset": 0, "links": [ { "rel": "self", "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ap-rest-api/rest/1/apinvoutstanding", "name": "apinvoutstanding", "kind": "collection" } ] } } } } } } } } } }, "components": { "securitySchemes": { "cmicBasicAuth": { "type": "http", "scheme": "basic", "description": "Basic authentication" } } } } ````