Channel Aggregated Accruals

The Channel Aggregated Accruals view object contains information about the aggregated accrual totals such as open, earned, in progress, and paid. Totals are aggregated using various group-by combinations to support the checkbook.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramBudgetSummaryExtractPVO

Primary Keys : ProgBudgetSumId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
BuId	Value that uniquely identifies the business unit of the accrual.
CreatedBy	User who created the supplier accrual.
CreationDate	Date and time when the supplier accrual was created.
EarnedAcctdAmt	Amount that identifies the accounted earned amount summed for the aggregated accruals row.
InProgressAcctdAmt	Amount that identifies the accounted in progress amount summed for the aggregated accruals row.
JobDefinitionName	Name of the scheduled process that created or last updated the supplier accrual row. This is populated through Enterprise Service Scheduler.
LastUpdateDate	Date and time when the supplier accrual row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the supplier accrual.
LastUpdatedBy	User who last updated the supplier accrual row.
ObjectVersionNumber	Number of times the aggregated accruals row has been updated.
PaidAcctdAmt	Amount that identifies the accounted paid amount summed for the aggregated accruals row.
ProgBudgetSumId	Value that uniquely identifies the aggregated accruals row. This is the primary key of the Channel Aggregated Accruals view object.
ProgramCurrencyCode	Code that identifies the currency of the program or budget used to group aggregated accruals.
ProgramEarnedAmt	Amount that identifies the earned amount in the program currency summed for the aggregated accruals row.
ProgramHeaderId	Value that uniquely identifies the program used to group the aggregated accruals. This is the foreign key to the Channel Programs view object.
ProgramInProgressAmt	Amount that identifies the in progress amount in the program currency summed for the aggregated accruals row.
ProgramPaidAmt	Amount that identifies the paid amount in the program currency summed for the aggregated accruals row.
ProgramUtilizedAmt	Amount that identifies the utilized amount in the program currency summed for the aggregated accruals row. Applicable to supplier rebate programs configured to be utilized on receiving transactions.
RequestId	Value that uniquely identifies the instance of the scheduled process that created or last updated the row.
SourceTrxAmt	Amount that identifies the source transaction amount in the transaction currency summed for the aggregated accruals row.
UtilizedAcctdAmt	Amount that identifies the accounted utilized amount in the ledger currency summed for the aggregated accruals row. Applicable to supplier rebate programs configured to be utilized on receiving transactions.
YearId	Value that uniquely identifies the calendar year of the aggregated accruals row.