Customer & Vendor List

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
  }
}