Channel Program Types

The Channel Program Types view object contains information about user-created program types based on various predefined program templates.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramTypeExtractPVO

Primary Keys : ProgramTypeId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AccrualBasisId	Value that identifies the pricing basis that Oracle Pricing Cloud uses to calculate accruals when DISCOUNT TYPE in the program is PERCENTAGE. This is a foreign key to QP_PRICING_BASIS_B.PRICING_BASIS_ID. It's used in supplier ship and debit programs.
AccrualDiscountTypeCode	Code that identifies the default accrual discount type for the channel programs. A list of accepted values is defined in the lookup type ORA_CJM_LINE_DISCOUNT_TYPE.
ChargeSubtypeCode	Code that identifies the Pricing charge subtype that's considered for channel program application.
ChargeTypeCode	Code that identifies the pricing charge type that's considered for channel program application.
CostPriceBasisId	Value that identifies the pricing basis that Oracle Pricing Cloud uses to calculate accruals when DISCOUNT TYPE in the program is NEW COST. This is a foreign key to QP_PRICING_BASIS_B.PRICING_BASIS_ID. It's used in supplier ship and debit programs.
CreatedBy	User who created the program type.
CreationDate	Date and time when the program type was created.
CustomerProgram	Value that determines whether the program is a customer program or a supplier program. Contains one of the following values: true or false. If true, then the channel program created based on this program type tracks sell-side accruals. If false, then the channel program tracks buy-side accruals. The default value for this attribute is from program template.
DefaultCalcMethodCode	Code that identifies the default tier-calculation method for annual or volume programs. A list of accepted values is defined in the lookup type ORA_CJM_TIER_CALC_METHOD.
DefaultCurrencyCode	Code that identifies the default currency for the channel program.
DefaultProdContextCode	Code that identifies the default product context in the create and manage channel programs pages. A list of accepted values is defined in the lookup type ORA_CJM_ITEM_LEVELS.
DefaultTierTypeCode	Code that identifies the default discount tier type when creating a channel program. A list of accepted values is defined in the lookup type ORA_CJM_TIER_TYPE.
DiscountAppliedToCode	Code that identifies the grouping option used when applying the channel program. A list of accepted values is defined in the lookup type ORA_CJM_DISCOUNT_APPLIED_TO
LastUpdateDate	Date and time when the program type row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the program type.
LastUpdatedBy	User who last updated the program type.
ObjectVersionNumber	Number of times the program type has been updated.
OverrideProgram	Indicates whether the program can be overridden in Order Management. Contains one of the following values: true or false. If true, then the program can be overridden in Order Management. If false, then the program can't be overridden in Order Management.
ParentProgramTypeId	Value that uniquely identifies the predefined program template, based on which the program type is created.
PriceTypeCode	Code that indicates the price type for the pricing charge. A list of accepted values is defined in the lookup type QP_PRICE_TYPES.
PricingDateTypeCode	Code that identifies the date qualifier used for evaluating channel program eligibility. For supplier ship and debit program, a list of accepted values is defined in the lookup type ORA_CJM_PRICING_APP_DATE_TYPE. For supplier rebate program, a list of accepted values is defined in the lookup type ORA_CJM_SUP_REBATE_DATE_QUALFR. For customer rebate program, a list of accepted values is defined in the lookup type ORA_CJM_CUST_REBATE_DATE_QUAL.
ProgramCodePrefix	Prefix used while creating channel program code.
ProgramTypeCode	Code that identifies the program type.
ProgramTypeId	Value that uniquely identifies the program type. This is the primary key of the Channel Program Type view object.
RequestOnlyFlag	Indicates whether the program is applied in Order Management automatically. Contains one of the following values: true or false. If true, then the program is applied in Order Management automatically. If false, then the program isn't applied in Order Management automatically. The default value is false.
SeededFlag	Indicates whether the program type is predefined. Contains one of the following values: Y or N. If Y, then the program type is predefined. If N, then the program type isn't predefined.
SeededProgramTypeCode	Code that uniquely identifies the predefined program template based on which the program type is created. A list of accepted values is defined in the lookup type ORA_CJM_PROGRAM_TYPE.
SoldBySalesMethodCode	Indicates whether the channel program is applicable to direct orders, indirect orders, or both. A list of accepted values is defined in the lookup type ORA_CJM_SALES_METHOD.
StatusCode	Code that identifies the status of the program type.