Manage Channel Lookups
Here you can view, manage, and edit the lookups for Channel Revenue Management.
-
In the Setup and Maintenance work area, go to:
-
Offering: Order Management/Procurement
-
Functional Area: Channel Revenue Management/Supplier Incentives
-
Task: Manage Channel Lookups
-
-
You can search for and manage the Channel Revenue Management lookups from the Manage Channel Lookups page.
List of Channel Lookups
This table lists the lookups and their codes available for Channel Revenue Management.
|
Lookup Type |
Meaning |
Description |
Lookup Configuration Level |
Lookup Codes |
|---|---|---|---|---|
|
ORA_CJM_ACCRUAL_ADJ_FOR |
Accrual Adjustment For |
Indicates that the accrual adjustment is done for the supplier. |
System |
SUPPLIER CUSTOMER PARTY |
|
ORA_CJM_ACCRUAL_STATUS |
Accrual Status for Eligible Line |
Indicates whether accrual has been computed for the eligible line. |
System |
ORA_CJM_ACCRUAL_PENDING ORA_CJM_ACCRUED ORA_CJM_ERROR |
|
ORA_CJM_ACCRUAL_TYPE |
Accrual Type |
Indicates that the accrual is created for the supplier. |
System |
SUPPLIER |
|
ORA_CJM_ADJUSTMENT_TYPE |
Manual Adjustment Type |
List of manual adjustment types supported in the channel. For example, Increase Earned, or Decrease Earned. |
System |
DECREASE_EARNED INCREASE_EARNED TIER_INCREASE_EARNED TIER_DECREASE_EARNED |
|
ORA_CJM_ANP_CHECKBOOK_GROUP_BY |
Grouping Criteria for Accruals for Annual Program |
Indicates the attribute used to summarize the accruals in the annual program checkbook. |
System |
ORA_CJM_CATEGORY_OR_ITEM ORA_CJM_ITEM_IN_CATEGORY ORA_CJM_PERIOD |
|
ORA_CJM_ASSOCIATION_TYPE |
Claim Association Type |
Indicates the level at which association is performed. For example, Program, Order, Product or Invoice. |
System |
PROGRAM |
|
ORA_CJM_BATCH_DATA_SOURCE |
Batch Data Source Type |
Indicates the transaction type used to categorize the transaction data in the batch. |
System |
ORA_RECEIVING_TRX ORA_SALES_ORDER ORA_SUPPLIER_INVOICE_CSV ORA_SALES_ORDER_CSV |
|
ORA_CJM_BATCH_LINE_STATUS |
Batch Line Status |
List of statuses supported in the channel batch line. |
System |
ORA_VALIDATED ORA_PROCESSED |
|
ORA_CJM_BATCH_SOURCE_TYPE |
Source for Load Transactions |
Indicates the source used in the Load Transactions scheduled process. |
System |
RECEIVING_TRX |
|
ORA_CJM_BATCH_STATUS |
Batch Status |
List of statuses supported in the channel batch. |
System |
ORA_OPEN ORA_VALIDATED ORA_PROCESSED |
| ORA_CJM_BENEFICIARY_TYPE | Channel Program Beneficiary Type | List of beneficiary types supported in the channel. For example, Bill To, Ship To, Customer, or Custom. | System | ORA_CJM_BILL_TO_CUSTOMER_ID |
| ORA_CJM_BUDGET_CATEGORY | Channel Budget Category | List of Budget categories. | User |
SALES VENDOR_REBATE |
| ORA_CJM_CHANL_CUST_QUAL | Qualifier for Customer Programs | List of qualifiers supported in customer annual programs. | System | ORA_HEADER_BILL_TO_CUSTOMER_ID |
|
ORA_CJM_CHECKBOOK_GROUP_BY |
Grouping Criteria for Accruals |
Indicates the attribute used to summarize the accruals in the supplier program checkbook. |
System |
ORA_CJM_ITEM ORA_CJM_PO ORA_CJM_BILL_TO_LOCATION ORA_CJM_SHIP_TO_LOCATION |
|
ORA_CJM_CLAIM_ACCOUNTING_FOR |
Claim Accounting For |
Indicates whether the claim accounting is for Payables or Receivables. |
System |
PAYABLES RECEIVABLES |
|
ORA_CJM_CLAIM_CLASS |
Channel Claim Class |
List of claim classes supported in the channel. |
System |
CLAIM DEBIT_CLAIM DEDUCTION OVERPAYMENT |
|
ORA_CJM_CLAIM_FOR |
Claim For |
Indicates that the claim is created for the supplier. |
System |
SUPPLIER |
|
ORA_CJM_CLAIM_LINE_TYPE |
Claim Line Type |
List of claim line types supported in the channel. |
System |
ITEM MEMO_LINE TAX FREIGHT ORA_DESCRIPTION |
| ORA_CJM_CLAIM_PAY_OVER_EARNING | Pay Over Earnings | Indicates whether the pay over earning is allowed or not. | System |
ORA_ALLOW ORA_DISALLOW |
|
ORA_CJM_CLAIM_SOURCE |
Channel Claim Source |
List of claim sources supported in the channel claim. |
System |
CLAIM CLAIM_INVESTIGATION_DED CLAIM_INVESTIGATION_OPM INVOICE_DEDUCTION INVOICE_OVERPAYMENT SA_CLAIM SA_DEBIT_CLAIM SSD_CLAIM SSD_DEBIT_CLAIM SR_CLAIM SR_DEBIT_CLAIM |
|
ORA_CJM_CLAIM_STATUS |
Channel Claim Status |
List of statuses supported in the channel claim. |
System |
APPROVAL_PENDING APPROVAL_REJECTED CANCELLED NETTING_IN_PROG OPEN UPDATE_IN_PROGRESS SETTLED SETTLEMENT_PENDING |
| ORA_CJM_CLM_PAY_OVER_THLD_TYPE | Pay Over Earnings Threshold Type | List of the threshold types used for pay over earnings. | System |
ORA_AMOUNT ORA_PERCENTAGE ORA_UNCONDITIONAL |
|
ORA_CJM_CODE_MAPPING_TYPE |
Channel Code Mapping Type |
Indicates the mapping types for customer mappings. |
System |
ORA_CLAIM_REASON |
| ORA_CJM_CUST_CHKBK_TYPE | Type of Data Shown in Customer Checkbook | Indicates whether to show customer balances, program balances, or total balances. | System |
ORA_CUSTOMER_BAL ORA_PROGRAM_BAL ORA_TOTAL_BAL |
| ORA_CJM_CUST_CLAIM_ASSOC_TYPE | Association Type for Customer Claims | Indicates the level at which accrual association is performed in customer claims. | System | ORA_PROGRAM |
| ORA_CJM_CUST_CLAIM_RESOL_TYPE | Resolution Type for Customer Claims | Indicates the resolution types supported in customer claims. | System |
ORA_PROMOTIONAL ORA_NON_PROMOTIONAL |
| ORA_CJM_CUST_REB_PERCENT_BASIS | Percent Basis for Customer Rebates | List of pricing bases for percent supported in customer rebate programs. | System |
ORA_UNIT_LIST_PRICE ORA_UNIT_SELLING_PRICE |
| ORA_CJM_CUST_REBATE_DATE_QUAL | Date Qualifier for Customer Rebates | Indicates the date qualifiers supported in customer rebates. | System |
ACTUAL_SHIP_DATE SALES_INVOICE_DATE ORDERED_DATE REQ_ARRIVAL_DATE REQ_SHIP_DATE |
| ORA_CJM_CUST_REBATE_QUAL | Qualifier for Customer Rebates | List of qualifiers supported in customer rebate programs. | Extensible |
ORA_HEADER_BILL_TO_CUSTOMER_ID ORA_HEADER_BILL_TO_SITE_USE_ID ORA_ORDER_LINE_TYPE ORDER_TYPE SALESPERSON_ID SHIP_TO_PARTY_SITE_ID ORA_WAREHOUSE |
| ORA_CJM_CUST_CLM_ACCRUE_TO_LVL | Level of Accrue To for Customer Claim Associations | Indicates the level of accrue to supported in customer claim associations. | System |
ORA_ALL_ACCT_RELATIONSHIP ORA_BILL_TO_RELATIONSHIP ORA_RECIPROCAL_RELATIONSHIP |
| ORA_CJM_CUST_CLM_CALENDAR_YEAR | Calendar Year for Customer Claim Associations | Indicates the calendar years supported in customer claims associations. | System |
ORA_CURRENT_YEAR ORA_LAST_YEAR |
| ORA_CJM_CUST_PROG_ITEM_LEVEL | Item Level for Product Rules in Customer Programs | Item levels supported in product rules for customer programs. | Extensible |
ORA_ITEM ORA_ALL_ITEMS |
| ORA_CJM_CUSTOMER_OR_SUPPLIER | Generic Customer or Supplier List of Values | Generic list of values used to select either the customer or supplier option. | System |
ORA_SUPPLIER ORA_CUSTOMER |
|
ORA_CJM_DISCOUNT_APPLIED_TO |
Discount Applied To |
Choices to indicate the grouping option used when applying the channel program. For example, Single line or Group of lines. |
System |
LINE - Single line |
|
ORA_CJM_DISP_TYPE_STATUS |
Filter Records by Status |
Filter used to sort records based on one of the following statuses: enabled, disabled or all statuses. |
System |
Y N ALL |
| ORA_CJM_DISTRIBUTION_TYPE | Product Distribution Type | List of product distribution types supported in the lump sum program. | System |
ORA_EVEN ORA_AMOUNT ORA_PERCENT |
|
ORA_CJM_DOCUMENT_TYPE |
Channel Document Type |
Indicates the document type. |
System |
ORA_RECEIVING_TRX |
|
ORA_CJM_ESS_PARAM_PROCESS_MODE |
Program Process Mode |
Indicates whether the program runs in preview mode or update mode. |
System |
PREVIEW - In preview mode, the program reports the accounting exceptions. UPDATE - In update mode, the program sweeps the unaccounted channel transactions. |
|
ORA_CJM_GEN_SUP_CLM_DATE_TYPE |
Date Type for Generate Supplier Claims |
Indicates the date type used for identifying eligible accruals in the Generate Supplier Claims scheduled process. |
System |
ACCT_DATE REQ_ACCT_DATE |
| ORA_CJM_INITIATED_BY | Initiated By | Indicates whether the program is created by an internal or external user. | System |
ORA_CJM_INTERNAL ORA_CJM_EXTERNAL |
|
ORA_CJM_ITEM_LEVEL |
Channel Program Item Level |
List of item levels supported in the channel program. For example, Item or All Items. |
Extensible |
ALL_ITEMS ITEM |
| ORA_CJM_ITEM_VAL_ORG_SETUP_IN | Applications with the item validation organization setting | List of applications from where channel retrieves the item validation organization setting. | System |
ORA_RECEIVABLES ORA_PRICING |
|
ORA_CJM_LINE_DISCOUNT_TYPE |
Line Discount Type |
Discount types supported in the channel program. For example, amount, percent, or new cost. |
System |
DISCOUNT_AMOUNT DISCOUNT_PERCENT NEW_COST NEW_PRICE |
|
ORA_CJM_LINE_SOURCE_TYPE |
Claim Line Source Type |
List of line source types supported in the channel. |
System |
PROGRAM |
| ORA_CJM_LS_QUALIFIER | Lump Sum Program Qualifier | List of qualifiers supported in Lump Sum programs. | System |
ORA_BILL_TO_CUSTOMER_ACCOUNT |
|
ORA_CJM_MANUAL_ADJ_STATUS |
Manual Adjustment Status |
List of statuses supported in the manual adjustment. |
System |
APPROVAL_PENDING APPROVAL_REJECTED APPROVED OPEN SUCCESSFUL |
| ORA_CJM_MASS_SETTLEMENT_METHOD | Channel Claim Mass Settlement Method | List of settlement methods supported in the mass settle page. | Extensible |
ORA_CJM_CREDIT_MEMO ORA_CJM_WRITE_OFF |
|
ORA_CJM_ORDER_GL_POST_PHASE |
Order Line Phase to Create GL Entries |
Order line phase at which GL entries are created. |
System |
INVOICED |
| ORA_CJM_PGM_CHKBK_TYPE | Type of Data Shown in Program Checkbook | Indicates whether to show customer balances, bill to balances, or total balances. | System |
ORA_CUSTOMER_BAL ORA_BILL_TO_BAL ORA_TOTAL_BAL |
|
ORA_CJM_PRICING_APP_DATE_TYPE |
Channel Program Application Date Type |
Sales order date type used for evaluating channel program eligibility. |
System |
ORDERED_DATE REQ_SHIP_DATE |
|
ORA_CJM_PROG_ITEM_LEVEL |
Item Level for Product Rules |
Item levels supported in product rules evaluated in Channel Revenue Management. |
System |
ORA_ALL_ITEMS ORA_ITEM ORA_ITEM_CATEGORY |
|
ORA_CJM_PROGRAM_STATUS |
Channel Program Statuses |
List of statuses supported in the channel program. |
System |
ACTIVE APPROVAL_PENDING APPROVAL_REJECTED DRAFT TERMINATED SUPPLIER_DRAFT DECLINED |
|
ORA_CJM_PROGRAM_TYPE |
Channel Program Template |
List of program templates supported in Channel Revenue Management. |
System |
SUPPLIER_ANNUAL_PROGRAM SUPPLIER_SHIP_AND_DEBIT SUPPLIER_REBATE CUSTOMER_REBATE CUSTOMER_LUMP_SUM CUSTOMER_ANNUAL_VOLUME CUSTOMER_ANNUAL_COOP CUSTOMER_VOLUME |
|
ORA_CJM_PROGRAM_TYPE_STATUS |
Channel Program Type Statuses |
List of statuses supported in the channel program type. |
System |
ACTIVE CLOSED DRAFT PREDEFINED |
|
ORA_CJM_QUALIFIER_ OPERATOR |
Qualifier Operator |
List of operators supported while adding qualifiers in channel. |
System |
E (=) NE (<>) |
|
ORA_CJM_QUALIFIER_TYPE |
Channel Program Qualifier |
List of qualifiers supported in Channel Revenue Management. |
Extensible |
BILL_TO_CUSTOMER_ID ORDER_TYPE SALESPERSON_ID SOLD_TO_PARTY_ID SHIP_TO_PARTY_SITE_ID SALESPERSON_ID ORA_WAREHOUSE |
|
ORA_CJM_SALES_METHOD |
Sales Method |
Source of sales for which a rebate program is applicable. For example, Direct or Indirect. |
System |
B - Both D - Direct |
|
ORA_CJM_SETTLEMENT_DOC_TYPE |
Settlement Document Type |
Indicates whether the settlement document line is a transaction or instrument. |
System |
TRANSACTION INSTRUMENT |
|
ORA_CJM_SETTLEMENT_METHOD |
Channel Claim Settlement Method |
List of settlement methods supported in channel claims. |
Extensible |
AP_DEBIT AP_DEFAULT CM_ON_ACCOUNT CM_ON_INVOICE PRE_OPEN_CREDIT ON_ACCOUNT_INV OPEN_DED OPEN_OPM WRITE_OFF ORA_CHARGEBACK |
|
ORA_CJM_SUP_RBT_DISC_TYPE |
Discount Type for Supplier Rebates |
Discount types supported in supplier rebate programs. |
System |
ORA_DISCOUNT_PERCENT ORA_DISCOUNT_AMOUNT ORA_NEW_PRICE |
|
ORA_CJM_SUP_RBT_EARN_ACCR_EVT |
Event for Triggering Earned Accrual for Supplier Rebate |
Indicates the event for triggering supplier rebate accrual. |
System |
ORA_CJM_ACCR_EVT_RECEIPT ORA_CJM_ACCR_EVT_SUPPL_INVOICE |
|
ORA_CJM_SUP_RBT_NEW_PRIC_BASIS |
New Price Basis for Supplier Rebates |
List of pricing bases for new price supported in supplier rebate programs. |
Extensible |
ORA_PO_LINE_UNIT_PRICE |
|
ORA_CJM_SUP_RBT_PERCENT_BASIS |
Percent Basis for Supplier Rebates |
List of pricing bases for percent supported in supplier rebate programs. |
Extensible |
ORA_PO_LINE_UNIT_PRICE |
|
ORA_CJM_SUP_REBATE_DATE_QUALFR |
Date Qualifier for Supplier Rebates |
Indicates the date qualifiers supported in supplier rebates. |
System |
PO_DATE RECEIPT_TRX_DATE REQ_DELIVERY_DATE REQ_SHIP_DATE SHIPPED_DATE SUPPLIER_INVOICE_DATE |
|
ORA_CJM_SUP_REBATE_QUAL |
Qualifier Type for Supplier Rebates |
List of qualifiers supported in supplier rebate programs. |
Extensible |
ORA_BILL_TO_LOCATION ORA_SHIP_TO_LOCATION ORA_TRANSACTION_REASON |
|
ORA_CJM_SUPPLIER_INV_REASON |
Reason for Supplier Invoice Correction |
List of reasons for correcting an invoice. |
Extensible |
- |
| ORA_CJM_TIER_CALC_METHOD | Tier Calculation Method | List of tier calculation methods supported in programs. | System |
ORA_RETROSPECTIVE ORA_STEPPED |
|
ORA_CJM_TIER_TYPE |
Channel Program Tier Type |
Tier types supported in the channel program. |
System |
ORA_QUANTITY ORA_AMOUNT ORA_SALES |
|
ORA_CJM_TRANSACTION_TYPE |
Channel Transaction Type |
List of transaction types supported in channel. For example, Accrual or Adjustment. |
System |
ACCRUAL ADJUSTMENT |
|
ORA_CJM_USER_STATUS_FOR |
User Status For |
Indicates channel object type for which the user status is created. |
System |
CLAIM PROGRAM PROGRAM_TYPE |
|
ORA_CJM_YES_NO |
Generic Yes or No List of Values |
Generic Yes or No list of values. |
System |
Y - Yes N - No |