Channel Programs
The Channel Programs view object contains information that defines supplier rebate programs.
Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramHeaderExtractPVO
Primary Keys : ProgramHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Channel Program descriptive flexfield. |
| AttributeChar1 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar10 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar11 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar12 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar13 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar14 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar15 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar16 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar17 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar18 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar19 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar2 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar20 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar3 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar4 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar5 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar6 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar7 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar8 | Character segment for the Channel Program descriptive flexfield. |
| AttributeChar9 | Character segment for the Channel Program descriptive flexfield. |
| AttributeDate1 | Date segment for the Channel Program descriptive flexfield. |
| AttributeDate2 | Date segment for the Channel Program descriptive flexfield. |
| AttributeDate3 | Date segment for the Channel Program descriptive flexfield. |
| AttributeDate4 | Date segment for the Channel Program descriptive flexfield. |
| AttributeDate5 | Date segment for the Channel Program descriptive flexfield. |
| AttributeNumber1 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber10 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber2 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber3 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber4 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber5 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber6 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber7 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber8 | Number segment for the Channel Program descriptive flexfield. |
| AttributeNumber9 | Number segment for the Channel Program descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Channel Program descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Channel Program descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Channel Program descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Channel Program descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Channel Program descriptive flexfield. |
| AuthorizationNumber | Number that identifies the authorization provided by the supplier. |
| BuId | Value that uniquely identifies the business unit. |
| CalculationMethodCode | Code that identifies the calculation method used for calculating accruals for supplier annual programs. A list of accepted values is defined in the lookup type ORA_CJM_TIER_CALC_METHOD. |
| ContactId | Value that uniquely identifies the supplier contact. |
| CreatedBy | User who created the channel program. |
| CreationDate | Date and time when the channel program was created. |
| CurrencyCode | Code that identifies the currency used for the channel program. |
| DiscountAppliedToCode | Code that indicates the level at which the channel program will be qualified. A list of accepted values is defined in the lookup type ORA_CJM_DISCOUNT_APPLIED_TO. |
| InitiatedByCode | Indicates whether the program was created by the supplier contact or the internal distributor user. A list of accepted values is defined in the lookup type ORA_CJM_INITIATED_BY. |
| LastRunDate | Last run date and time for the supplier annual program. Used to retrieve the transaction data to be processed in each run. |
| LastUpdateDate | Date and time when the channel program row was last updated. |
| LastUpdateLogin | Session login associated with the user who last updated the channel program. |
| LastUpdatedBy | User who last updated the channel program row. |
| ObjectVersionNumber | Number of times the channel program row has been updated. |
| OverrideProgram | Indicates whether the channel programs that are automatically applied on sales orders can be overridden. Contains one of the following values: Y or N. If Y, then the channel programs that are automatically applied on sales orders can be overridden. If N, then the channel programs applied on sales orders can't be overridden. The value is defaulted from the channel program type. |
| OwnerId | Value that uniquely identifies the owner of the channel program. |
| PricingDateFrom | Date from when the program is applicable. |
| PricingDateTo | Date until when the program is applicable. |
| PricingDateTypeCode | Code that identifies the date type used for evaluating channel program eligibility. A list of accepted values is defined in the lookup type ORA_CJM_PRICING_APP_DATE_TYPE. |
| ProgramCode | Code that uniquely identifies the channel program. |
| ProgramHeaderId | Value that uniquely identifies the channel program. This is the primary key of the Channel Programs view object. |
| ProgramTypeCode | Code that identifies the predefined program template on which the channel program is based. A list of accepted values is defined in the lookup type ORA_CJM_PROGRAM_TYPE. |
| ProgramTypeId | Value that uniquely identifies the type of program on which the channel program is based. This is a foreign key to the Channel Program Types view object. |
| QuoteNumber | Indicates the quote number provided by the supplier. |
| RequestOnlyFlag | Indicates whether the channel program is automatically applied on sales orders. Contains one of the following value: Y or N. If Y, then the channel program isn't automatically applied on sales orders even if the eligibility criteria is met. If N, then the channel program is automatically applied on sales orders upon eligibility evaluation. The value is defaulted from the channel program type. |
| SoldBySalesMethodCode | Code that indicates whether the channel program is for direct, indirect sales, or both. A list of accepted values is defined in the lookup type ORA_CJM_SALES_METHOD. |
| StatusCode | Code that identifies the system status for the status of the channel program. A list of accepted values is defined in the lookup type ORA_CJM_PROGRAM_SYSTEM_STATUS. |
| UserStatusId | Value that uniquely identifies the status of the channel program. This is a foreign key to the Channel User Statuses view object. |
| VendorId | Value that uniquely identifies the supplier. This is a foreign key to the Supplier Details view object. |
| VendorSiteId | Value that uniquely identifies the supplier site. This is a foreign key to the Supplier Site Details view object. |