CJM_PROGRAM_TYPES_B
CJM_PROGRAM_TYPES_B contains the records for the custom setup for channel rebate programs. User will have the option of creating the Custom Program type for the rebate programs which will contain the default values for some of the program attributes. These will be defaulted in the UI when user creates a new rebate program. Some seeded program types will be inserted in this table.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CJM_PROGRAM_TYPES_B_PK |
PROGRAM_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROGRAM_TYPE_ID | NUMBER | 18 | Yes | Unique identifier for the Program type created in the system. | |
| PROGRAM_TYPE_GUID | VARCHAR2 | 64 | This is a unique identifier generated for the program types. | ||
| PROGRAM_TYPE_CODE | VARCHAR2 | 30 | A unique identifier for the program type that is specified by the user. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEEDED_FLAG | VARCHAR2 | 1 | Indicates whether this program type is seeded. Values are from the lookup ORA_CJM_YES_NO. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the program type is enabled or disabled. Values are from the lookup ORA_CJM_YES_NO. | ||
| COST_PRICE_BASIS_ID | NUMBER | 18 | Cost Basis Value for the DISCOUNT TYPE as NEW COST. This value will be fetched from qp_pricing_basis_vl. | ||
| INCLUDE_ACCRUAL_IN_MARGIN | VARCHAR2 | 1 | Determines if the Accrual records created for the Program needs to be considered In Margin Calculation by Pricing or not. | ||
| CUSTOMER_PROGRAM | VARCHAR2 | 1 | Yes | Determines if this is customer program or supplier program. Should be defaulted based on the Program Template selected. | |
| PARENT_PROGRAM_TYPE_ID | NUMBER | 18 | Parent program Type Identifier from where this Program type is copied. | ||
| SEEDED_PROGRAM_TYPE_CODE | VARCHAR2 | 30 | Yes | Program type. Values are from the lookup ORA_CJM_PROGRAM_TYPE. | |
| PROGRAM_CODE_PREFIX | VARCHAR2 | 5 | Yes | Prefix needed for the Channel Program Code. | |
| OVERRIDE_PROGRAM | VARCHAR2 | 1 | This flag is used in defaulting the program type value in channel program. | ||
| SOLD_BY_SALES_METHOD_CODE | VARCHAR2 | 1 | Indicates whether the channel program is applicable to Direct orders, Indirect orders, or Both. If value is not set, channel program is applicable to direct as well as indirect orders. Values are from the lookup ORA_CJM_SALES_METHOD. | ||
| DEFAULT_CURRENCY_CODE | VARCHAR2 | 15 | Default currency for channel program. | ||
| APPROVAL_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if approval is enabled for this program type. | ||
| PRICING_DATE_TYPE_CODE | VARCHAR2 | 30 | The order is qualified based on the value selected in this field. Values are from the lookup code ORA_CJM_PRICING_APP_DATE_TYPE. | ||
| DEFAULT_BUDGET_ID | NUMBER | 18 | Default budget for the Channel Program. | ||
| ENFORCE_BUDGET_FUNDING | VARCHAR2 | 1 | This field value determines whether the committed amount can be zero or not. This field value determines whether the committed amount can be zero or not. | ||
| DEFAULT_CUSTOMER_TYPE_CODE | VARCHAR2 | 30 | Default customer type in the channel program, Create UI, and Manage UI. Values are from lookup ORA_CJM_QUALIFIER_TYPE. | ||
| DEFAULT_BENEF_TYPE_CODE | VARCHAR2 | 30 | Default beneficiary type in channel program Manage UI. Values are from Lookup ORA_CJM_BENEFICIARY_TYPE. | ||
| DISCOUNT_APPLIED_TO_CODE | VARCHAR2 | 30 | Contains discount level information. Values are from the lookup code ORA_CJM_DISCOUNT_APPLIED_TO. | ||
| DEFAULT_PROD_CONTEXT_CODE | VARCHAR2 | 30 | Default product context in the channel program Create UI and Manage UI. Values are from Lookup ORA_CJM_ITEM_LEVELS. | ||
| ENABLE_OFFINVOICE_FLAG | VARCHAR2 | 1 | Indicates whether off-invoice related fields are displayed. | ||
| OFFINVOICE_BASIS_ID | NUMBER | 18 | Default adjustment basis for the off-invoice programs. | ||
| OFFINVOICE_DISC_TYPE_CODE | VARCHAR2 | 30 | Default off-invoice discount type in the channel program Create UI and Manage UI. Values are from lookup ORA_CJM_LINE_DISCOUNT_TYPE. | ||
| ENABLE_ACCRUAL_FLAG | VARCHAR2 | 1 | Indicates whether accruals related fields are displayed. | ||
| ACCRUAL_BASIS_ID | NUMBER | 18 | Adjustment basis value for the Rebate and Volume Rebate programs. | ||
| ACCRUAL_BASIS_CODE | VARCHAR2 | 30 | Adjustment basis value for Customer programs. Values are from the lookup ORA_CJM_CUST_REB_PERCENT_BASIS. | ||
| ACCRUAL_DISCOUNT_TYPE_CODE | VARCHAR2 | 30 | Default accrual discount type for the channel program Create UI and Manage UI. Values are from lookup ORA_CJM_LINE_DISCOUNT_TYPE. | ||
| PRICE_TYPE_CODE | VARCHAR2 | 30 | Indicates if the price adjustment is associated with a one time or recurring price type. Based on the lookup type QP_PRICE_TYPES. | ||
| CHARGE_TYPE_CODE | VARCHAR2 | 30 | Indicates the charge type the Pricing term is for. This is not applicable for the benefit types Price List and Accrual. | ||
| CHARGE_SUBTYPE_CODE | VARCHAR2 | 30 | Indicates the charge subtype the Pricing term is for. This is not applicable for benefit types Price List and Accrual. | ||
| DISPLAY_ON_FOM_FLAG | VARCHAR2 | 1 | Select to enable Order Management users to view these programs. | ||
| REQUEST_ONLY_FLAG | VARCHAR2 | 1 | Select to support request-only programs in Order Management. | ||
| USER_STATUS_ID | NUMBER | 18 | User defined status for the Channel Program Type, Seed Data will be needed. Foreign key from CJM_USER_STATUSES_B table. | ||
| STATUS_CODE | VARCHAR2 | 30 | Status code of the program type. Values are from the lookup ORA_CJM_PROGRAM_TYPE_STATUS. | ||
| ENABLE_BENEFICIARY_FLAG | VARCHAR2 | 1 | Indicator to identify whether the header-level beneficiary for the program is enabled or not. | ||
| DEFAULT_PROD_DISTRIB_TYPE_CODE | VARCHAR2 | 30 | Indicates the default product distribution type code for customer lump sum programs. Values are from lookup ORA_CJM_DISTRIBUTION_TYPE. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| DEFAULT_CALC_METHOD_CODE | VARCHAR2 | 30 | Indicates the default rate tier calculation method for annual or volume programs. Values are from the lookup ORA_CJM_TIER_CALC_METHOD. | ||
| DEFAULT_TIER_TYPE_CODE | VARCHAR2 | 30 | Indicates the default discount tier type for channel program is Amount or Quantity. Values are from the lookup ORA_CJM_TIER_TYPE. | ||
| DIFF_RATES_ON_PROD_TIERS_FLAG | VARCHAR2 | 1 | Indicates whether the rate exception region on the product table must be displayed by default or not. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cjm_program_type_qualifiers | cjm_program_types_b | PROGRAM_TYPE_ID |
| cjm_program_types_tl | cjm_program_types_b | PROGRAM_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_PROGRAM_TYPES_B_U1 | Unique | Default | PROGRAM_TYPE_ID, ORA_SEED_SET1 |
| CJM_PROGRAM_TYPES_B_U11 | Unique | Default | PROGRAM_TYPE_ID, ORA_SEED_SET2 |