Channel Claim Associations

The Channel Claim Associations view object contains information about the earned accruals and the method that's used to associate them to a claim.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ClaimAssociationExtractPVO

Primary Keys : AssociationId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
AssociationAcctdAmount Accounted amount of the earning association.
AssociationAmount Indicates the earning association amount.
AssociationCurrencyCode Code that indicates the currency used for earning association.
AssociationId Value that uniquely identifies the earning association. This is the primary key of the Channel Claim Associations view object.
AssociationNumber Indicates the earning association number.
AssociationTrxAmount Indicates the earning association amount in transaction currency.
AssociationTrxCurrCode Code that indicates the currency of the transaction.
AssociationTypeCode Indicates the level at which accrual association is performed in customer claims. A list of accepted values is defined in the lookup type ORA_CJM_CUST_CLAIM_ASSOC_TYPE.
BuId Value that uniquely identifies the business unit of the claim.
ClaimId Value that uniquely identifies the claim. This is a foreign key to the Channel Claims view object.
ClaimLineId Value that uniquely identifies the claim line. This is a foreign key to the Channel Claim Lines view object.
CreatedBy User who created the earning association.
CreationDate Date and time when the earning association was created.
ItemId Value that uniquely identifies the inventory item used for earning association. This is foreign key to the Items view object.
JobDefinitionName Name of the process that created the earning association.
LastUpdateDate Date and time when the earning association row was last updated.
LastUpdateLogin Session login associated with the user who last updated the earning association.
LastUpdatedBy User who last updated the earning association row.
ObjectVersionNumber Number of times the earning association row has been updated.
ProgramHeaderId Value that uniquely identifies the channel program. This is a foreign key to the Channel Programs view object.
RequestId Value that uniquely identifies the process that created the earning association.