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
|
orderBy |
optional |
query |
Sorts the results by The value of the
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. |