Channel Program Conditions

The Channel Program Conditions view object contains additional qualifier attributes that are attached to channel program qualifiers.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramQualifierConditionExtractPVO

Primary Keys : QualifierConditionId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ComparisonOperatorCode	Code that identifies the comparison operator used in the market rule. A list of accepted values is defined in the lookup type ORA_CJM_QUALIFIER_OPERATOR.
CreatedBy	User who created the channel program condition.
CreationDate	Date and time when the channel program condition was created.
LastUpdateDate	Date and time when the channel program condition row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the channel program condition.
LastUpdatedBy	User who last updated the channel program condition row.
ObjectVersionNumber	Number of times the channel program condition row has been updated.
ProgramQualifierId	Value that uniquely identifies the channel program qualifier. This is the foreign key to the Channel Program Qualifiers view object.
QualifierConditionId	Value that uniquely identifies the channel program condition. This is the primary key of the Channel Program Conditions view object.
QualifierTypeCode	Code that identifies the type of qualifier used to define the eligibility of the channel program. For supplier ship and debit programs, the list of accepted values is defined in the lookup type ORA_CJM_QUALIFIER_TYPE. For supplier rebate programs, the list of accepted values is defined in the lookup type ORA_CJM_SUP_REBATE_QUAL.
QualifierValueCode	Qualifier value used in channel program qualification.