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 uniquely identifies the basis to use when the DiscountTypeCode in the Channel Program Product Rules view object is DISCOUNT_PERCENT. 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 create and manage channel programs pages. 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 uniquely identifies the basis to use when the DiscountTypeCode in the Channel Program Product Rules view object 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. The default value is based on the predefined 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 whether the default discount tier type for channel program is amount or quantity. 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: Y or N. If Y, then the program can be overridden in Order Management. If N, 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 whether the price adjustment is associated with a one time or a recurring price type. 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: Y or N. If Y, then the program is applied in Order Management automatically. If N, then the program isn't applied in Order Management automatically. The default value is N.
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.