---
editLink: false
lastUpdated: false
---

[@salesforce/b2c-tooling-sdk](../../../modules.md) / [operations/cip](../index.md) / CipReportDefinition

# Interface: CipReportDefinition

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:45](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L45)

Curated CIP report definition.

## Properties

### buildSql()

> **buildSql**: (`params`) => `string`

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:50](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L50)

#### Parameters

##### params

`Record`\<`string`, `string`\>

#### Returns

`string`

***

### category

> **category**: `string`

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:48](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L48)

***

### description

> **description**: `string`

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:47](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L47)

***

### name

> **name**: `string`

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:46](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L46)

***

### parameters

> **parameters**: [`CipReportParamDefinition`](CipReportParamDefinition.md)[]

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:49](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L49)

***

### resultNotes?

> `optional` **resultNotes**: `string`[]

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:57](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L57)

Concise definitions and interpretation limits for the report's results.

***

### tablesUsed?

> `optional` **tablesUsed**: `string`[]

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/types.ts:55](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/1dedfc1ffefa01c3d5bff62c8f7e7e682a1a91cd/packages/b2c-tooling-sdk/src/operations/cip/types.ts#L55)

Warehouse dependencies for discovery, including conditionally joined tables.
Does not affect SQL.