Skip to main content

Search by Report Name

Zuora

Search by Report Name

Contact Zuora Global Support to enable this feature in your tenant. This feature is currently in development and is subject to change without advance notice.

The Search by Report Name Reporting API returns a list of reports and their metadata in a JSON array for all matching reports.  Search by Report Name lets you submit a string (without spaces) as a query parameter and any matches to report names, data source names, or report descriptions returns those reports and their metadata. 

Note: Reports are not required to have unique names or descriptions and so this search will typically return many report matches because of matches from multiple fields unless you specify a unique query keyword. 

Optionally you can specify sorting on either the name or the updated_on fields.

The search is automatically limited to the first 50 results. If you want to query for the next 50, you have to set the searchStart parameter to 50 and submit another request to get the next 50 results.

Request

Environment Request
API Sandbox (US Data Center) GET https://zconnectsandbox.zuora.com/api/rest/v1/reports/search?query={string}
Production (US Data Center) GET https://zconnect.zuora.com/api/rest/v1/reports/search?query={string}
API Sandbox (EU Data Center) GET https://zconnect.sandbox.eu.zuora.com/api/rest/v1/reports/search?query={string}
Production (EU Data Center) GET https://zconnect.eu.zuora.com/api/rest/v1/reports/search?query={string}
API Sandbox(US Cloud Data Center) GET https://zconnect.sandbox.na.zuora.com/api/rest/v1/reports/search?query={string} 
Production (US Cloud Data Center) GET https://zconnect.na.zuora.com/api/rest/v1/reports/search?query={string}

Request Parameters

query

required

query

The query parameter value sets the search string used to search through all report names, data source names, and descriptions. The value {string} can be any alpha-numeric string like: MyReport1

  • Search is not case-sensitive.
  • Spaces in the query parameter must be replaced by %20.
  • Words smaller than three letters are excluded from matching.
  • Search results include matches from any position in the word. For example, if the search term is "count", the search results will include words such as "counted", "account", and "accounts".

orderBy

optional

query

Sorts the results by name or updated_on value.

The value of the orderBy statement request path parameter must match the following syntax exactly:

[{"field": "updated_on", "ascend": "true"}]

Where the value of field can be either "name" or "updated_on" and the value of ascend is either "true" or "false".

searchStart

optional

query

Skips and excludes a specified number of reports from the query.  

namespace

optional

query

Specifies whether to use Search by Report Name with Insights Analysis. Set this parameter to ADVANCED to use Search by Report Name with Insights Analysis.

Contact Zuora Global Support if you would like to use the Reporting API with Insights Analysis.

Examples

Simple HTTPS Request

Options are omitted from this example search to get all reports that contain the letter A in either the Report name, Data Source name, or description.  The search will start from row 0 and return a maximum of 50 reports.

GET https://zconnectsandbox.zuora.com/api/rest/v1/reports/search?query=A

HTTPS Request (with options)

GET https://zconnectsandbox.zuora.com/api/rest/v1/reports/search?query=Accounts&orderBy=[{"field": "name", "ascend": "true"}]&searchStart=0

JSON Response

{
  "success": true,
  "response": {
    "reports": [
      {
        "createdBy": "8a90e082800251b0018002db7a31168b",
        "updatedBy": "8a90e082800251b0018002db7a31168b",
        "createdOn": "2022-11-03T12:01:46+0000",
        "updatedOn": "2023-01-18T09:00:27+0000",
        "id": "2c9180838436fb5d01843d5e5e4500f0",
        "deleted": false,
        "name": "test1",
        "number": "REP0000013",
        "type": "Common",
        "datasource": "Account",
        "dsName": "Account",
        "namespace": "BASIC",
        "definition": "{\"rowFields\":[{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0,\"subtotals\":true},{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true},{\"name\":\"AccountNumber\",\"id\":\"Account.AccountNumber\",\"label\":\"Account Number\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":1,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Number\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true}],\"colFields\":[],\"valFields\":[{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\"}],\"selectedFields\":[{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"NONE\",\"sortPriority\":-1}],\"detailFilters\":[],\"summaryFilters\":[],\"advanced\":false,\"rollingTotals\":false,\"shareAsReadOnly\":false}",
        "userId": "8a90e082800251b0018002db7a31168b",
        "creator": "frank",
        "updater": "frank",
        "favorite": false,
        "shared": false,
        "zuora": false,
        "hidden": false
      },
      {
        "createdBy": "8a90e082800251b0018002db7a31168b",
        "updatedBy": "8a90e082800251b0018002db7a31168b",
        "createdOn": "2022-11-25T05:41:13+0000",
        "updatedOn": "2022-11-25T05:41:13+0000",
        "id": "2c91808984a2758b0184ad4de29a02f1",
        "deleted": false,
        "name": "test",
        "number": "REP0000023",
        "type": "Common",
        "datasource": "Account",
        "dsName": "Account",
        "namespace": "BASIC",
        "definition": "{\"rowFields\":[{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0,\"subtotals\":true},{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true}],\"colFields\":[],\"valFields\":[{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\"}],\"selectedFields\":[{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"NONE\",\"sortPriority\":-1}],\"detailFilters\":[],\"summaryFilters\":[],\"advanced\":false,\"rollingTotals\":false,\"shareAsReadOnly\":false}",
        "userId": "8a90e082800251b0018002db7a31168b",
        "creator": "frank",
        "updater": "frank",
        "favorite": false,
        "shared": true,
        "zuora": false,
        "hidden": false
      },
      {
        "createdBy": "8a90e082800251b0018002db7a31168b",
        "updatedBy": "8a90e082800251b0018002db7a31168b",
        "createdOn": "2022-11-25T05:41:50+0000",
        "updatedOn": "2023-01-18T09:01:21+0000",
        "id": "2c91808984a2758b0184ad4e6f8802f2",
        "deleted": false,
        "name": "test2",
        "number": "REP0000024",
        "type": "Common",
        "datasource": "Invoice",
        "dsName": "Invoice",
        "namespace": "BASIC",
        "definition": "{\"rowFields\":[{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0,\"subtotals\":true},{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true}],\"colFields\":[{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"dateOptions\":{\"groupBy\":\"CM\",\"cohortAnalysis\":false}}],\"valFields\":[{\"name\":\"Amount\",\"id\":\"Invoice.Amount\",\"label\":\"Amount\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":2,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Amount\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\"}],\"selectedFields\":[{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"NONE\",\"sortPriority\":0},{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\",\"sortDir\":\"NONE\",\"sortPriority\":0},{\"name\":\"Amount\",\"id\":\"Invoice.Amount\",\"label\":\"Amount\",\"type\":\"decimal\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":2,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Amount\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"sortDir\":\"NONE\",\"sortPriority\":0},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0},{\"name\":\"Status\",\"id\":\"Invoice.Status\",\"label\":\"Status\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":23,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Status\",\"options\":[{\"value\":\"Draft\",\"label\":\"Draft\"},{\"value\":\"Posted\",\"label\":\"Posted\"},{\"value\":\"Canceled\",\"label\":\"Canceled\"},{\"value\":\"Error\",\"label\":\"Error\"},{\"value\":\"PendingForTax\",\"label\":\"PendingForTax\"},{\"value\":\"Generating\",\"label\":\"Generating\"},{\"value\":\"CancelInProgress\",\"label\":\"CancelInProgress\"}],\"sortDir\":\"NONE\",\"sortPriority\":0}],\"detailFilters\":[{\"field\":{\"name\":\"Status\",\"id\":\"Invoice.Status\",\"label\":\"Status\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":23,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Status\",\"options\":[{\"value\":\"Draft\",\"label\":\"Draft\"},{\"value\":\"Posted\",\"label\":\"Posted\"},{\"value\":\"Canceled\",\"label\":\"Canceled\"},{\"value\":\"Error\",\"label\":\"Error\"},{\"value\":\"PendingForTax\",\"label\":\"PendingForTax\"},{\"value\":\"Generating\",\"label\":\"Generating\"},{\"value\":\"CancelInProgress\",\"label\":\"CancelInProgress\"}]},\"value\":\"Posted\",\"operator\":{\"name\":\"is equal to\",\"value\":\"=\"}},{\"field\":{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\"},\"value\":\"CURRENTPREVIOUS_N_MONTHS:3\",\"operator\":{\"name\":\"is during\",\"value\":\"is during\"}}],\"summaryFilters\":[{\"field\":{\"name\":\"Status\",\"id\":\"Invoice.Status\",\"label\":\"Status\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":23,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Status\",\"options\":[{\"value\":\"Draft\",\"label\":\"Draft\"},{\"value\":\"Posted\",\"label\":\"Posted\"},{\"value\":\"Canceled\",\"label\":\"Canceled\"},{\"value\":\"Error\",\"label\":\"Error\"},{\"value\":\"PendingForTax\",\"label\":\"PendingForTax\"},{\"value\":\"Generating\",\"label\":\"Generating\"},{\"value\":\"CancelInProgress\",\"label\":\"CancelInProgress\"}]},\"value\":\"Posted\",\"operator\":{\"name\":\"is equal to\",\"value\":\"=\"}},{\"field\":{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\"},\"value\":\"CURRENTPREVIOUS_N_MONTHS:3\",\"operator\":{\"name\":\"is during\",\"value\":\"is during\"}}],\"advanced\":false,\"rollingTotals\":false,\"shareAsReadOnly\":false}",
        "userId": "8a90e082800251b0018002db7a31168b",
        "creator": "frank",
        "updater": "frank",
        "favorite": false,
        "shared": false,
        "zuora": false,
        "hidden": false
      },
      {
        "createdBy": "2c92c8fe7b85b8b5017b86b47e131cf4",
        "updatedBy": "2c92c8fe7b85b8b5017b86b47e131cf4",
        "createdOn": "2022-11-28T06:35:11+0000",
        "updatedOn": "2022-11-28T06:35:11+0000",
        "id": "2c91808984a2758b0184bcf25e5605ec",
        "deleted": false,
        "name": "fxtest1128",
        "number": "REP0000029",
        "type": "Common",
        "datasource": "Account",
        "dsName": "Account",
        "namespace": "BASIC",
        "definition": "{\"rowFields\":[{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0,\"subtotals\":true},{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true}],\"colFields\":[],\"valFields\":[{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\"}],\"selectedFields\":[{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"NONE\",\"sortPriority\":-1}],\"detailFilters\":[],\"summaryFilters\":[],\"advanced\":false,\"rollingTotals\":false,\"shareAsReadOnly\":false}",
        "userId": "2c92c8fe7b85b8b5017b86b47e131cf4",
        "creator": "xfan2",
        "updater": "xfan2",
        "favorite": false,
        "shared": true,
        "zuora": false,
        "hidden": false
      },
      {
        "createdBy": "8a90e082800251b0018002db7a31168b",
        "updatedBy": "8a90e082800251b0018002db7a31168b",
        "createdOn": "2023-01-06T09:32:29+0000",
        "updatedOn": "2023-01-06T09:32:29+0000",
        "id": "2c91808985865d2d0185866cb4a80005",
        "deleted": false,
        "name": "testInv",
        "number": "REP0000034",
        "type": "Common",
        "datasource": "Invoice",
        "dsName": "Invoice",
        "namespace": "BASIC",
        "definition": "{\"rowFields\":[{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0,\"subtotals\":true},{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true}],\"colFields\":[{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"dateOptions\":{\"groupBy\":\"CM\",\"cohortAnalysis\":false}}],\"valFields\":[{\"name\":\"Amount\",\"id\":\"Invoice.Amount\",\"label\":\"Amount\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":2,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Amount\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\"}],\"selectedFields\":[{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"NONE\",\"sortPriority\":0},{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\",\"sortDir\":\"NONE\",\"sortPriority\":0},{\"name\":\"Amount\",\"id\":\"Invoice.Amount\",\"label\":\"Amount\",\"type\":\"decimal\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":2,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Amount\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"sortDir\":\"NONE\",\"sortPriority\":0},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0},{\"name\":\"Status\",\"id\":\"Invoice.Status\",\"label\":\"Status\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":23,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Status\",\"options\":[{\"value\":\"Draft\",\"label\":\"Draft\"},{\"value\":\"Posted\",\"label\":\"Posted\"},{\"value\":\"Canceled\",\"label\":\"Canceled\"},{\"value\":\"Error\",\"label\":\"Error\"},{\"value\":\"PendingForTax\",\"label\":\"PendingForTax\"},{\"value\":\"Generating\",\"label\":\"Generating\"},{\"value\":\"CancelInProgress\",\"label\":\"CancelInProgress\"}],\"sortDir\":\"NONE\",\"sortPriority\":0}],\"detailFilters\":[{\"field\":{\"name\":\"Status\",\"id\":\"Invoice.Status\",\"label\":\"Status\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":23,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Status\",\"options\":[{\"value\":\"Draft\",\"label\":\"Draft\"},{\"value\":\"Posted\",\"label\":\"Posted\"},{\"value\":\"Canceled\",\"label\":\"Canceled\"},{\"value\":\"Error\",\"label\":\"Error\"},{\"value\":\"PendingForTax\",\"label\":\"PendingForTax\"},{\"value\":\"Generating\",\"label\":\"Generating\"},{\"value\":\"CancelInProgress\",\"label\":\"CancelInProgress\"}]},\"value\":\"Posted\",\"operator\":{\"name\":\"is equal to\",\"value\":\"=\"}},{\"field\":{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\"},\"value\":\"CURRENTPREVIOUS_N_MONTHS:3\",\"operator\":{\"name\":\"is during\",\"value\":\"is during\"}}],\"summaryFilters\":[{\"field\":{\"name\":\"Status\",\"id\":\"Invoice.Status\",\"label\":\"Status\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":23,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Status\",\"options\":[{\"value\":\"Draft\",\"label\":\"Draft\"},{\"value\":\"Posted\",\"label\":\"Posted\"},{\"value\":\"Canceled\",\"label\":\"Canceled\"},{\"value\":\"Error\",\"label\":\"Error\"},{\"value\":\"PendingForTax\",\"label\":\"PendingForTax\"},{\"value\":\"Generating\",\"label\":\"Generating\"},{\"value\":\"CancelInProgress\",\"label\":\"CancelInProgress\"}]},\"value\":\"Posted\",\"operator\":{\"name\":\"is equal to\",\"value\":\"=\"}},{\"field\":{\"name\":\"InvoiceDate\",\"id\":\"Invoice.InvoiceDate\",\"label\":\"Invoice Date\",\"type\":\"date\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Invoice\",\"dataSourceLabel\":\"Invoice\",\"dataSourceType\":\"Invoice\",\"searchKey\":\"Invoice Invoice Date\"},\"value\":\"CURRENTPREVIOUS_N_MONTHS:3\",\"operator\":{\"name\":\"is during\",\"value\":\"is during\"}}],\"advanced\":false,\"rollingTotals\":false,\"shareAsReadOnly\":false}",
        "userId": "8a90e082800251b0018002db7a31168b",
        "creator": "frank",
        "updater": "frank",
        "favorite": false,
        "shared": false,
        "zuora": false,
        "hidden": false
      },
      {
        "createdBy": "8a90e082800251b0018002db7a31168b",
        "updatedBy": "8a90e082800251b0018002db7a31168b",
        "createdOn": "2022-11-08T09:53:10+0000",
        "updatedOn": "2023-01-15T11:39:13+0000",
        "id": "2c9180938446fc8d018456a86f2c02c3",
        "deleted": false,
        "name": "Untitledtest",
        "number": "REP0000018",
        "type": "Common",
        "datasource": "Account",
        "dsName": "Account",
        "namespace": "BASIC",
        "definition": "{\"rowFields\":[{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"ASC\",\"sortPriority\":0,\"subtotals\":true},{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"ASC\",\"sortPriority\":-1,\"subtotals\":true}],\"colFields\":[],\"valFields\":[{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\"}],\"selectedFields\":[{\"name\":\"Name\",\"id\":\"Account.Name\",\"label\":\"Name\",\"type\":\"text\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":22,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Name\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Balance\",\"id\":\"Account.Balance\",\"label\":\"Account Balance\",\"type\":\"decimal\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":5,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Account Balance\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"sortDir\":\"NONE\",\"sortPriority\":-1},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"picklist\",\"custom\":false,\"virtual\":false,\"filterable\":true,\"sortable\":true,\"groupable\":true,\"fxEnabled\":false,\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[{\"value\":\"AED\",\"label\":\"AED\"},{\"value\":\"AFN\",\"label\":\"AFN\"},{\"value\":\"ALL\",\"label\":\"ALL\"},{\"value\":\"AMD\",\"label\":\"AMD\"},{\"value\":\"ANG\",\"label\":\"ANG\"},{\"value\":\"AOA\",\"label\":\"AOA\"},{\"value\":\"ARS\",\"label\":\"ARS\"},{\"value\":\"AUD\",\"label\":\"AUD\"},{\"value\":\"AWG\",\"label\":\"AWG\"},{\"value\":\"AZN\",\"label\":\"AZN\"},{\"value\":\"BAM\",\"label\":\"BAM\"},{\"value\":\"BBD\",\"label\":\"BBD\"},{\"value\":\"BDT\",\"label\":\"BDT\"},{\"value\":\"BGN\",\"label\":\"BGN\"},{\"value\":\"BHD\",\"label\":\"BHD\"},{\"value\":\"BIF\",\"label\":\"BIF\"},{\"value\":\"BMD\",\"label\":\"BMD\"},{\"value\":\"BND\",\"label\":\"BND\"},{\"value\":\"BOB\",\"label\":\"BOB\"},{\"value\":\"BRL\",\"label\":\"BRL\"},{\"value\":\"BSD\",\"label\":\"BSD\"},{\"value\":\"BTN\",\"label\":\"BTN\"},{\"value\":\"BWP\",\"label\":\"BWP\"},{\"value\":\"BYR\",\"label\":\"BYR\"},{\"value\":\"BZD\",\"label\":\"BZD\"},{\"value\":\"CAD\",\"label\":\"CAD\"},{\"value\":\"CDF\",\"label\":\"CDF\"},{\"value\":\"CHF\",\"label\":\"CHF\"},{\"value\":\"CLP\",\"label\":\"CLP\"},{\"value\":\"CNY\",\"label\":\"CNY\"},{\"value\":\"COP\",\"label\":\"COP\"},{\"value\":\"CRC\",\"label\":\"CRC\"},{\"value\":\"CUP\",\"label\":\"CUP\"},{\"value\":\"CVE\",\"label\":\"CVE\"},{\"value\":\"CZK\",\"label\":\"CZK\"},{\"value\":\"DJF\",\"label\":\"DJF\"},{\"value\":\"DKK\",\"label\":\"DKK\"},{\"value\":\"DOP\",\"label\":\"DOP\"},{\"value\":\"DZD\",\"label\":\"DZD\"},{\"value\":\"EEK\",\"label\":\"EEK\"},{\"value\":\"EGP\",\"label\":\"EGP\"},{\"value\":\"ERN\",\"label\":\"ERN\"},{\"value\":\"ETB\",\"label\":\"ETB\"},{\"value\":\"EUR\",\"label\":\"EUR\"},{\"value\":\"FJD\",\"label\":\"FJD\"},{\"value\":\"FKP\",\"label\":\"FKP\"},{\"value\":\"GBP\",\"label\":\"GBP\"},{\"value\":\"GEL\",\"label\":\"GEL\"},{\"value\":\"GHS\",\"label\":\"GHS\"},{\"value\":\"GIP\",\"label\":\"GIP\"},{\"value\":\"GMD\",\"label\":\"GMD\"},{\"value\":\"GNF\",\"label\":\"GNF\"},{\"value\":\"GTQ\",\"label\":\"GTQ\"},{\"value\":\"GYD\",\"label\":\"GYD\"},{\"value\":\"HKD\",\"label\":\"HKD\"},{\"value\":\"HNL\",\"label\":\"HNL\"},{\"value\":\"HRK\",\"label\":\"HRK\"},{\"value\":\"HTG\",\"label\":\"HTG\"},{\"value\":\"HUF\",\"label\":\"HUF\"},{\"value\":\"IDR\",\"label\":\"IDR\"},{\"value\":\"ILS\",\"label\":\"ILS\"},{\"value\":\"INR\",\"label\":\"INR\"},{\"value\":\"IQD\",\"label\":\"IQD\"},{\"value\":\"IRR\",\"label\":\"IRR\"},{\"value\":\"ISK\",\"label\":\"ISK\"},{\"value\":\"JMD\",\"label\":\"JMD\"},{\"value\":\"JOD\",\"label\":\"JOD\"},{\"value\":\"JPY\",\"label\":\"JPY\"},{\"value\":\"KES\",\"label\":\"KES\"},{\"value\":\"KGS\",\"label\":\"KGS\"},{\"value\":\"KHR\",\"label\":\"KHR\"},{\"value\":\"KMF\",\"label\":\"KMF\"},{\"value\":\"KPW\",\"label\":\"KPW\"},{\"value\":\"KRW\",\"label\":\"KRW\"},{\"value\":\"KWD\",\"label\":\"KWD\"},{\"value\":\"KYD\",\"label\":\"KYD\"},{\"value\":\"KZT\",\"label\":\"KZT\"},{\"value\":\"LAK\",\"label\":\"LAK\"},{\"value\":\"LBP\",\"label\":\"LBP\"},{\"value\":\"LKR\",\"label\":\"LKR\"},{\"value\":\"LRD\",\"label\":\"LRD\"},{\"value\":\"LSL\",\"label\":\"LSL\"},{\"value\":\"LTL\",\"label\":\"LTL\"},{\"value\":\"LVL\",\"label\":\"LVL\"},{\"value\":\"LYD\",\"label\":\"LYD\"},{\"value\":\"MAD\",\"label\":\"MAD\"},{\"value\":\"MDL\",\"label\":\"MDL\"},{\"value\":\"MGA\",\"label\":\"MGA\"},{\"value\":\"MKD\",\"label\":\"MKD\"},{\"value\":\"MMK\",\"label\":\"MMK\"},{\"value\":\"MNT\",\"label\":\"MNT\"},{\"value\":\"MOP\",\"label\":\"MOP\"},{\"value\":\"MRO\",\"label\":\"MRO\"},{\"value\":\"MUR\",\"label\":\"MUR\"},{\"value\":\"MVR\",\"label\":\"MVR\"},{\"value\":\"MWK\",\"label\":\"MWK\"},{\"value\":\"MXN\",\"label\":\"MXN\"},{\"value\":\"MYR\",\"label\":\"MYR\"},{\"value\":\"MZN\",\"label\":\"MZN\"},{\"value\":\"NAD\",\"label\":\"NAD\"},{\"value\":\"NGN\",\"label\":\"NGN\"},{\"value\":\"NIO\",\"label\":\"NIO\"},{\"value\":\"NOK\",\"label\":\"NOK\"},{\"value\":\"NPR\",\"label\":\"NPR\"},{\"value\":\"NZD\",\"label\":\"NZD\"},{\"value\":\"OMR\",\"label\":\"OMR\"},{\"value\":\"PAB\",\"label\":\"PAB\"},{\"value\":\"PEN\",\"label\":\"PEN\"},{\"value\":\"PGK\",\"label\":\"PGK\"},{\"value\":\"PHP\",\"label\":\"PHP\"},{\"value\":\"PKR\",\"label\":\"PKR\"},{\"value\":\"PLN\",\"label\":\"PLN\"},{\"value\":\"PYG\",\"label\":\"PYG\"},{\"value\":\"QAR\",\"label\":\"QAR\"},{\"value\":\"RON\",\"label\":\"RON\"},{\"value\":\"RSD\",\"label\":\"RSD\"},{\"value\":\"RUB\",\"label\":\"RUB\"},{\"value\":\"RWF\",\"label\":\"RWF\"},{\"value\":\"SAR\",\"label\":\"SAR\"},{\"value\":\"SBD\",\"label\":\"SBD\"},{\"value\":\"SCR\",\"label\":\"SCR\"},{\"value\":\"SDG\",\"label\":\"SDG\"},{\"value\":\"SEK\",\"label\":\"SEK\"},{\"value\":\"SGD\",\"label\":\"SGD\"},{\"value\":\"SHP\",\"label\":\"SHP\"},{\"value\":\"SLL\",\"label\":\"SLL\"},{\"value\":\"SOS\",\"label\":\"SOS\"},{\"value\":\"SRD\",\"label\":\"SRD\"},{\"value\":\"STD\",\"label\":\"STD\"},{\"value\":\"SVC\",\"label\":\"SVC\"},{\"value\":\"SYP\",\"label\":\"SYP\"},{\"value\":\"SZL\",\"label\":\"SZL\"},{\"value\":\"THB\",\"label\":\"THB\"},{\"value\":\"TJS\",\"label\":\"TJS\"},{\"value\":\"TND\",\"label\":\"TND\"},{\"value\":\"TOP\",\"label\":\"TOP\"},{\"value\":\"TRY\",\"label\":\"TRY\"},{\"value\":\"TTD\",\"label\":\"TTD\"},{\"value\":\"TWD\",\"label\":\"TWD\"},{\"value\":\"TZS\",\"label\":\"TZS\"},{\"value\":\"UAH\",\"label\":\"UAH\"},{\"value\":\"UGX\",\"label\":\"UGX\"},{\"value\":\"USD\",\"label\":\"USD\"},{\"value\":\"UYU\",\"label\":\"UYU\"},{\"value\":\"UZS\",\"label\":\"UZS\"},{\"value\":\"VEF\",\"label\":\"VEF\"},{\"value\":\"VND\",\"label\":\"VND\"},{\"value\":\"VUV\",\"label\":\"VUV\"},{\"value\":\"WST\",\"label\":\"WST\"},{\"value\":\"XAF\",\"label\":\"XAF\"},{\"value\":\"XCD\",\"label\":\"XCD\"},{\"value\":\"XOF\",\"label\":\"XOF\"},{\"value\":\"XPF\",\"label\":\"XPF\"},{\"value\":\"YER\",\"label\":\"YER\"},{\"value\":\"ZAR\",\"label\":\"ZAR\"},{\"value\":\"ZMK\",\"label\":\"ZMK\"},{\"value\":\"ZWD\",\"label\":\"ZWD\"}],\"sortDir\":\"NONE\",\"sortPriority\":-1}],\"detailFilters\":[],\"summaryFilters\":[],\"advanced\":false,\"rollingTotals\":false,\"shareAsReadOnly\":false}",
        "userId": "8a90e082800251b0018002db7a31168b",
        "creator": "frank",
        "updater": "frank",
        "favorite": false,
        "shared": false,
        "zuora": false,
        "hidden": false
      }
    ],
    "count": 6
  }
}

Insights Analysis

To use "Search by Report Name" with Insights Analysis, you must set the namespace query parameter. For example:

GET https://zconnectsandbox.zuora.com/api/rest/v1/reports/search?query=Current%20CMRR&namespace=ADVANCED

Exceptions 

   
"success": true
Not really an exception. Your invocation was correct, but your query string was not found.
Required String parameter 'query' is not present.  "errorCode" : "ZAN-REST-ERROR" Query request parameter must be present to invoke this method.
Token time was {timeStamp}.
"errorCode" : "loginFailed"
Authentication failed.  Check the values of apiAccessKeyId and apiSecretAccessKey.
Unexpected character ('f' (code 102)): was expecting double-quote to start field name\n at [Source: java.io.StringReader@a3c8680; line: 1, column: 4]",
  "errorCode" : "ZAN-REST-ERROR"
The field path parameter must be enclosed by double-quotes.