ChannelCustomerAvailableAccruals
Get channel customer available accruals.
Columns
| Name | Type | SupportedFinders | Description |
| AccrualCurrency | String | Value that indicates the accrual currency. | |
| AccrualCurrencyCode | String | Abbreviation that uniquely identifies the accrual currency. | |
| AccrueToLevel | String | Level of accrual required. | |
| AccrueToLevelCode | String | Abbreviation that uniquely identifies the level of accrual. | |
| AssociationType | String | Name of the type of association. | |
| AssociationTypeCode | String | Abbreviation that uniquely identifies the association type. | |
| AvailableAmountInTransactionCurrency | Decimal | Available amount in the transaction currency. | |
| BillToAccountId | Long | Value that uniquely identifies the bill-to customer account. | |
| BillToAccountNumber | String | Number of the bill-to customer account. | |
| BillToCustomer | String | Name of the bill-to customer. | |
| CalendarYear | Integer | Calendar year of the accrual based on the accounting date. | |
| EarnedAmountInTransactionCurrency | Decimal | Earned amount in the transaction currency. | |
| InvoiceNumber | String | Number that indicates the invoice. | |
| Item | String | Name of the item in the inventory. | |
| ItemDescription | String | Description of the item. | |
| ItemId | Double | Value that uniquely identifies the item. | |
| Program | String | Name of the customer program. | |
| ProgramId | Long | Value that uniquely identifies the customer program. | |
| ProgramType | String | Name of the program type. | |
| ProgramTypeId | Long | Value that uniquely identifies the program type. | |
| ProgramUOM | String | Unit of measure of the item in the program. | |
| PromotionCode | String | Abbreviation that uniquely identifies the customer program. | |
| Quantity | Double | Transaction quantity in program UOM. |
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 |
| AccrualsBeforeDate | Date | Date used in conjunction with the year context to filter the accruals. |
| BusinessUnit | String | Name of the business unit. |
| BusinessUnitId | Double | Value that uniquely identifies the business unit. |
| ExcludeZeroBalancesFlag | Boolean | Contains one of the following values: true or false. If true, programs with zero available accruals won't be listed. If false, all the programs will be listed. The default value for this attribute is false. |
| RelatedCustomerAccountId | Double | Value that uniquely identifies the related customer account. |
| RelatedCustomerAccountNumber | String | Account number of the related customer. |
| ShowActiveProgramsFlag | Boolean | Contains one of the following values: true or false. If true, then only programs that can still accrue funds or have a balance will be listed. If false, all the programs will be listed. The default value for this attribute is true. |