Power BI Connector for Oracle Fusion Cloud SCM

Build 26.0.9770

ChannelCustomerProgramCheckbookBalances

The Channel Customer Program Checkbook Balances resource queries total balances for a program, accrue to customer and the associated bill-tos who made the purchases. It also queries customer balances for a program, accrue to customer and the associated bill-tos. This resource also queries bill-to balances for an accrue to 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 account.
BalanceAmountInFunctionalCurrency Decimal Balance amount in the functional currency.
BalanceAmountInProgramCurrency Decimal Balance amount in the program 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.
BillToSite String Name of the bill-to customer account site.
BillToSiteAddress String Address of the bill-to customer account site.
BillToSiteUseId Long Value that uniquely identifies the bill-to customer account site.
DataFor String Value that indicates whether the customer balances, bill-to balances, or total balances are retrieved.
DataForCode String Abbreviation that indicates whether the customer balances, bill-to 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.
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.
PromotionCode String Abbreviation that uniquely identifies the customer program.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770