Channel Program Product Rules
The Channel Program Product Rules view object contains product qualifier attributes that define the product eligibility rules and the discount details in channel programs.
Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramLineExtractPVO
Primary Keys : ProgramLineId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccrualFlag | Indicates whether the discount type is accrual or off-invoice. Contains one of the following values: Y or N. If Y, then the discount type is accrual. If N, then the discount type is off-invoice. It's blank for supplier annual programs. |
| AttributeCategory | Context name for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar1 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar10 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar11 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar12 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar13 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar14 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar15 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar16 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar17 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar18 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar19 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar2 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar20 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar3 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar4 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar5 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar6 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar7 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar8 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeChar9 | Character segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeDate1 | Date segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeDate2 | Date segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeDate3 | Date segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeDate4 | Date segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeDate5 | Date segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber1 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber10 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber2 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber3 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber4 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber5 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber6 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber7 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber8 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeNumber9 | Number segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Channel Program Product Rule descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Channel Program Product Rule descriptive flexfield. |
| CreatedBy | User who created the channel program product rule. |
| CreationDate | Date and time when the channel program product rule was created. |
| DiscountAmount | Discount amount for the product rule. |
| DiscountTypeCode | Code that identifies the type of discount. A list of accepted values is defined in the lookup type ORA_CJM_LINE_DISCOUNT_TYPE. |
| EndDate | Date when the product rule is no longer applicable. If blank, then the product rule end date is the end date for the channel program. |
| ItemId | Identifies the item, item category, or UDA based qualifier for the product rule. Value uniquely identifies the Item if the item level code is ITEM or ORA_ITEM. This is a foreign key to the Items view object. Value uniquely identifies the item category if the item level code is ORA_ITEM_CATEGORY. This is a foreign key to the Categories view object. The value is blank if the item level code is ALL_ITEMS or ORA_ALL_ITEMS. |
| ItemLevelCode | Code that identifies the level at which discounts are defined. For supplier ship and debit and supplier rebate programs, the list of accepted values is defined in the lookup type ORA_CJM_ITEM_LEVEL. For supplier annual programs, the list of accepted values is defined in the lookup type ORA_CJM_PROG_ITEM_LEVEL. The item level code also stores the UDA based qualifier names. |
| LastUpdateDate | Date and time when the channel program product rule row was last updated. |
| LastUpdateLogin | Session login associated with the user who last updated the channel program product rule. |
| LastUpdatedBy | User who last updated the channel program product rule row. |
| MaxQuantity | Maximum quantity allowed for the product rule. |
| ObjectVersionNumber | Number of times the channel program product rule row has been updated. |
| ProgramHeaderId | Value that uniquely identifies the channel program. This is a foreign key to the Channel Programs view object. |
| ProgramLineId | Value that uniquely identifies the channel program product rule. This is the primary key of the Channel Program Product Rules view object. |
| ProgramLineNumber | Line number for the product rule. |
| ProgramTierHeaderId | Value that uniquely identifies the channel program volume rule. This is a foreign key to the Channel Program Volume Rules view object. |
| StartDate | Date when the product rule becomes applicable. If blank, then the product rule start date is the start date for the channel program. |
| TpItemId | Value that uniquely identifies the supplier item. This is a foreign key to the Trading Partner Items view object. |
| UomCode | Code that identifies the unit of measure for the item on the product rule. This is a foreign key to the Units of Measure view object. |