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 |