Shows all phone numbers, emails, and addresses for all customers and vendors. This report should be exported to Excel since it has too many columns and is too wide to fit a PDF page.
{
"name": "Customer & vendor list",
"group": "##other",
"type": "report/pivotTable",
"params": {
"dataSet": "partyGroup",
"filters": [],
"rowDimensions": [
{ "dimension": "organizationName", "width": 0.0508 },
{ "dimension": "organizationRole", "width": 0.0254 }
],
"metrics": [
{ "metric": "organizationPhoneNumber0Consolidate", "width": 0.0254 },
{ "metric": "organizationPhoneNumber1Consolidate", "width": 0.0254 },
{ "metric": "organizationPhoneNumber2Consolidate", "width": 0.0254 },
{ "metric": "organizationPhoneNumber3Consolidate", "width": 0.0254 },
{ "metric": "organizationEmailAddress0Consolidate", "width": 0.0254 },
{ "metric": "organizationEmailAddress1Consolidate", "width": 0.0254 },
{ "metric": "organizationEmailAddress2Consolidate", "width": 0.0254 },
{ "metric": "organizationEmailAddress3Consolidate", "width": 0.0254 },
{ "metric": "organizationAddress0StreetAddressConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress0CityConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress0StateRegionConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress0PostalCodeConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress0AdditionalLinesConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress0DirectionsConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress1StreetAddressConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress1CityConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress1StateRegionConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress1PostalCodeConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress1AdditionalLinesConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress1DirectionsConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress2StreetAddressConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress2CityConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress2StateRegionConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress2PostalCodeConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress2AdditionalLinesConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress2DirectionsConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress3StreetAddressConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress3CityConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress3StateRegionConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress3PostalCodeConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress3AdditionalLinesConsolidate", "width": 0.0254 },
{ "metric": "organizationAddress3DirectionsConsolidate", "width": 0.0254 },
{ "metric": "organizationNotesConsolidate", "width": 0.0254, "label": ""}
],
"pageTemplate": null
}
}