ChannelCustomerCheckbookBalances
The Channel Customer Checkbook Balances resource queries total balances for a business unit, calendar year, and customer. It also queries customer balances for a business unit, calendar year, and customer. This resource also queries program balances for a customer.
Columns
| Name | Type | SupportedFinders | Description |
| AccrueToAccountId | Long | Value that uniquely identifies the accrue-to customer account. | |
| AccrueToAccountNumber | String | Number of the accrue-to customer account. | |
| AccrueToCustomer | String | Name of the accrue-to customer. | |
| BalanceAmountInFunctionalCurrency | Decimal | Balance amount in the functional currency. | |
| BalanceAmountInProgramCurrency | Decimal | Balance amount in the program currency. | |
| BusinessUnit | String | Name of the business unit. | |
| BusinessUnitId | Double | Value that uniquely identifies the business unit. | |
| CalendarYear | Integer | Value that indicates the 4-digit calendar year of the accrual based on the requested accounting date. | |
| DataFor | String | Value that indicates whether the customer balances, program balances, or total balances are retrieved. | |
| DataForCode | String | Abbreviation that indicates whether the customer balances, program balances, or total balances are retrieved. | |
| EarnedAmountInFunctionalCurrency | Decimal | Earned amount in the functional currency. | |
| EarnedAmountInProgramCurrency | Decimal | Earned amount in the program currency. | |
| FunctionalCurrency | String | Value that indicates the functional currency. | |
| FunctionalCurrencyCode | String | Abbreviation that identifies the functional currency. | |
| GLCalendarYear | Integer | The GL calendar year. | |
| InProgressAmountInFunctionalCurrency | Decimal | In-progress amount in the functional currency. | |
| InProgressAmountInProgramCurrency | Decimal | In-progress amount in the program currency. | |
| PaidAmountInFunctionalCurrency | Decimal | Paid amount in the functional currency. | |
| PaidAmountInProgramCurrency | Decimal | Paid amount in the program currency. | |
| ProgramCurrency | String | Value that indicates the program currency. | |
| ProgramCurrencyCode | String | Abbreviation that identifies the program currency. | |
| ProgramId | Long | Value that uniquely identifies the customer program. | |
| ProgramName | String | Name of the customer program. | |
| ProgramTemplateCode | String | Value of the Program Template Code. | |
| ProgramType | String | Type of program on which the customer program is based. | |
| ProgramTypeId | Long | Value that uniquely identifies the type of program on which the customer program is based. | |
| PromotionCode | String | Abbreviation that uniquely identifies the customer program. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| MyProgramFlag | Boolean | Contains one of the following values: true or false. If true, then the query is filtered based on the program owner. If false, then the query isn't filtered by the program owner. If not specified, it defaults to true. |