CJM_PROGRAMS_ALL_B

CJM_PROGRAMS_ALL_B contains the header level information for channel programs. It captures program dates, shipment dates, and order dates for which this program is valid, program status, header level beneficiary information, and so on.

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CJM_PROGRAMS_ALL_B_PK

PROGRAM_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments
PROGRAM_HEADER_ID NUMBER 18 Yes Unique Identifier for a Channel Program.
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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PROGRAM_CODE VARCHAR2 30 Yes Code for the Channel program, this can be either entered by the user or auto-generated from the system.
PROGRAM_TYPE_ID NUMBER 18 Yes Referenced from CJM_PROGRAM_TYPES_B.PROGRAM_TYPE_ID. Values are from the program type template used to create the channel program.
PROGRAM_TYPE_CODE VARCHAR2 30 Yes Contains seeded program type values. Values are from the lookup ORA_CJM_SEEDED_PROGRAM_TYPE.
OWNER_ID NUMBER 18 Yes Owner of the Channel Program.(user_id)
USER_STATUS_ID NUMBER 18 Yes User defined status for the Channel Program, Seed Data will be needed. Foreign key from CJM_USER_STATUSES_B table.
VENDOR_ID NUMBER 18 Contains the Vendor ID for Supplier Ship and Debit Program.
VENDOR_SITE_ID NUMBER 18 Contains the Vendor site ID for the Supplier Ship and Debit Program.
INITIATED_BY_CODE VARCHAR2 20 Program creation source code. Values are from the lookup ORA_CJM_INITIATED_BY.
CONTACT_ID NUMBER 18 Contact ID of the supplier for supplier ship and debit, supplier rebate, and supplier annual programs.
AUTHORIZATION_NUMBER VARCHAR2 30 Contains the Authorization Number by Vendor.
QUOTE_NUMBER VARCHAR2 30 Contains the Quote Number by vendor.
OVERRIDE_PROGRAM VARCHAR2 1 Enable override of auto selected programs in order management.
STATUS_CODE VARCHAR2 30 Yes System Status Code for the user_status_id. Value will be populated from Look up code ORA_CJM_PROGRAM_SYSTEM_STATUS.
STATUS_CHANGE_DATE DATE The date on which the status is assigned.
DISCOUNT_APPLIED_TO_CODE VARCHAR2 30 Yes Indicates the level at which the Channel Program will be qualified. Value will be populated using the look up code ORA_CJM_DISCOUNT_APPLIED_TO.
CURRENCY_CODE VARCHAR2 15 The currency code used in budget request.
COMMITTED_AMOUNT NUMBER Committed amount from the Budget.
ACCOUNT_CLOSED_FLAG VARCHAR2 1 Used for budgeting purposes, when channel program gets reconciled this Flag will be marked as Y.
VOLUME_PROGRAM_TYPE VARCHAR2 30 Type of Channnel volume program lines , if it is ACCRUAL or OFFINVOICE.
RETROACTIVE VARCHAR2 1 Applies only for programs of type Volume. Indicates if the discounts are retroactive.
CALCULATION_METHOD_CODE VARCHAR2 30 Tier calculation method supported by the program. Values are from the lookup ORA_CJM_TIER_CALC_METHOD.
ENABLE_BENEFICIARY VARCHAR2 1 Determines if the beneficiary is in the Channel Program UI.
BENEFICIARY_TYPE_CODE VARCHAR2 30 Stores beneficiary information. Possible values are like CUSTOM, BILL_TO, CUSTOMER, SHIPT_TO etc.
BENEFICIARY_VALUE_CODE NUMBER This will store the value like customer account id in case of customer, bill to site use id in case of BILL_TO etc
HEADER_DYNAMIC_MATRIX_ID NUMBER 18 This column is mapped to the DYNAMIC_MATRIX_ID of QP_MATRICES table. Channel program qualifiers which are sourced from the order header are mapped to the Header Matrix Type. DYNAMIC_MATRIX_ID is further mapped to QP_MATRIX_INHERITED_DIMENSIONS and QP_MATRIX_RULES.
COMMON_DYNAMIC_MATRIX_ID NUMBER 18 This column is mapped to the DYNAMIC_MATRIX_ID of QP_MATRICES table. Channel Program Level 0 or Level1 qualifiers which are sourced from Order Headers or Order Lines will be mapped to the Common Matrix Type and this dynamic_matrix_id will further be mapped to the QP_MATRIX_INHERITED_DIMENSIONS and QP_MATRIX_RULES.
HEADER_MATRIX_RULE_ID NUMBER 18 This column is mapped to the DYNAMIC_MATRIX_RULE_ID from QP_MATRIX_RULES table. This matrix rule will be created for the Channel Program only when user enters the Level 0 Qualifiers sourced from order header and no Level 1 qualifiers are present.
COMMON_MATRIX_RULE_ID NUMBER 18 This column is mapped to the DYNAMIC_MATRIX_RULE_ID from QP_MATRIX_RULES table. This matrix rule will be created for the Channel Program only when user enters the Level 0 Qualifiers sourced from order header or order Line and no Level 1 qualifiers are present.
SOLD_BY_SALES_METHOD_CODE VARCHAR2 1 indicates if the channel program is for direct, indirect sales or both. Value will be populated from the lookup ORA_CJM_SALES_METHOD.
BU_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
PROGRAM_ACTIVATION_DATE DATE Activation date of the Channel Program.
START_DATE DATE The date from which the Channel program is Effective.
END_DATE DATE The date till which the Channel program is Effective.
PRICING_DATE_TYPE_CODE VARCHAR2 30 Yes Pricing date type. This is the sales order date type used for evaluating channel program eligibility. This value can be the Order Date, Scheduled Shipment Date, or the Requested Ship Date and is populated using the lookup ORA_CJM_PRICING_APP_DATE_TYPE.
PRICING_DATE_FROM DATE From Date based on pricing_date_type_code. If pricing_date_type_code is the Order Date, this is the From Order Date.
PRICING_DATE_TO DATE To Date based on pricing_date_type_code. If pricing_date_type_code is the Order Date, this is the To Order Date.
DISPLAY_ON_ORDER_FLAG VARCHAR2 1 This Flag will decide if the channel program needs to be displayed in order Management screen or not.
REQUEST_ONLY_FLAG VARCHAR2 1 Indicates whether the user must ask for the channel program, e.g. quote a promotion number, to get the benefits on the list. The pricing engine ignores any lists where 'Ask For = Y' if they have not been quoted on the pricing request.
GRACE_PERIOD_IN_DAYS NUMBER 18 Indicates the number of days that the ship and debit can extend beyond the 'to date', on a ship and debit request. This field determines the end date for the underlying program. The maximum value for this field is 9999 days.
LAST_RUN_DATE DATE Last run date for the channel annual programs. Used to retrieve the invoice data to be processed in each run.
LAST_PERIOD_END_DATE DATE Last accrual Processing peiod end date of the channel program.
CUSTOMER_TYPE_CODE VARCHAR2 30 Indicates the code of the customer type for which the program is created. This column is applicable only for Lumpsum programs.
CUSTOMER_ID NUMBER 18 Indicates the identifier of the code for the customer type selected. This column is applicable only for Lumpsum programs.
LUMPSUM_AMOUNT NUMBER Indicates the amount defined for the lumpsum program.
LUMPSUM_DISTRIB_TYPE_CODE VARCHAR2 30 Indicates the distribution type of the Lumpsum program, for example, Even, Amount, and Percent. Values are from lookup ORA_CJM_DISTRIBUTION_TYPE.
ESTIMATED_AMOUNT NUMBER Indicates the amount estimated for the program. This field is mandatory when the program is submitted.
ACCOUNTED_ESTIMATED_AMOUNT NUMBER Indicates the amount estimated for the program in functional currency.
ACCOUNTED_LUMPSUM_AMOUNT NUMBER Indicates the amount defined for the lumpsum program in functional currency.
EXCHANGE_RATE_TYPE VARCHAR2 30 Identifies the exchange rate type, for example CORPORATE.
EXCHANGE_RATE_DATE DATE Indicates the date on which the exchange occurred. This is the date on which the program is submitted for approval.
EXCHANGE_RATE NUMBER Indicates the exchange rate between the program currency and the functional currency.
COMMENTS_FOR_APPROVERS VARCHAR2 4000 Comments submitted to provide additional information to the approvers.
SUBMITTED_BY NUMBER 18 Indicates the identifier for the user who has submitted the program for approval.
SUBMITTED_DATE DATE Indicates the date on which the program is submitted for approval.
APPROVED_DATE DATE Indicates the date on which the program was approved.
REJECTED_DATE DATE Indicates the date on which the program was rejected
OWNER_USER_ID NUMBER 18 Indicates the value for the OWNER_ID before data migration. This indicates the identifier for the system user who created the program.
ELIGIBLE_FOR_ALL_CUSTOMERS VARCHAR2 1 Indicates whether the program is eligible for all customers.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
CUSTOMER_ATTRIBUTE_CATEGORY VARCHAR2 30 Customer Program Descriptive Flexfield: structure definition of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR1 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR2 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR3 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR4 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR5 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR6 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR7 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR8 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR9 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR10 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR11 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR12 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR13 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR14 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR15 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR16 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR17 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR18 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR19 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR20 VARCHAR2 150 Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE1 DATE Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE2 DATE Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE3 DATE Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE4 DATE Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE5 DATE Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER1 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER2 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER3 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER4 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER5 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER6 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER7 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER8 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER9 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER10 NUMBER Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP1 TIMESTAMP Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP2 TIMESTAMP Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP3 TIMESTAMP Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP4 TIMESTAMP Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP5 TIMESTAMP Customer Program Descriptive Flexfield: segment of the Customer Program descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
cjm_program_qualifiers cjm_programs_all_b PROGRAM_HEADER_ID
cjm_program_lines cjm_programs_all_b PROGRAM_HEADER_ID
cjm_programs_all_tl cjm_programs_all_b PROGRAM_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
CJM_PROGRAMS_ALL_B_N1 Non Unique Default PROGRAM_TYPE_ID
CJM_PROGRAMS_ALL_B_N2 Non Unique Default STATUS_CODE
CJM_PROGRAMS_ALL_B_N3 Non Unique Default VENDOR_ID, VENDOR_SITE_ID
CJM_PROGRAMS_ALL_B_N4 Non Unique Default PROGRAM_CODE
CJM_PROGRAMS_ALL_B_N5 Non Unique Default VENDOR_SITE_ID
CJM_PROGRAMS_ALL_B_N6 Non Unique Default UPPER("PROGRAM_CODE")
CJM_PROGRAMS_ALL_B_N7 Non Unique Default UPPER("AUTHORIZATION_NUMBER")
CJM_PROGRAMS_ALL_B_N8 Non Unique Default OWNER_ID
CJM_PROGRAMS_ALL_B_U1 Unique Default PROGRAM_HEADER_ID