1. Tables and Views for SCM
  2. CJM_CUSTOMER_ACCRUALS_ALL

CJM_CUSTOMER_ACCRUALS_ALL

CJM_CUSTOMER_ACCRUALS_ALL contains all the accrual and manual adjustment records for the customer rebate flow for direct sales orders and indirect sales orders.

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CJM_CUSTOMER_ACCRUALS_ALL_PK

CUSTOMER_ACCRUAL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CUSTOMER_ACCRUAL_ID NUMBER 18 Yes Unique identifier for the CJM_CUSTOMER_ACCRUALS_ALL table.
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.
BU_ID NUMBER 18 Yes Indicates the identifier of the business unit associated with the row.
PROGRAM_HEADER_ID NUMBER 18 Unique identifier for the program header for which accruals are created. This is a foreign key from the CJM_PROGRAMS_ALL_B table.
PROGRAM_LINE_ID NUMBER 18 Unique identifier for the program line for which accruals are created. This is a foreign key from the CJM_PROGRAMS_LINES table.
CUST_ACCOUNT_ID NUMBER 18 Contains the customer account ID for the beneficiary. If there is no beneficiary defined, then this contains the customer account ID of the sales order customer.
BILL_TO_SITE_USE_ID NUMBER 18 Contains the bill to site use ID if beneficiary is BILL_TO and is undefined for other beneficiary types. If there is no beneficiary, this contains the bill to site use ID of the sales order customer.
TRX_PARTY_ID NUMBER 18 Unique identifier of the party for the selected sales order.
TRX_CUST_ACCOUNT_ID NUMBER 18 Unique identifier of the sales order customer account.
TRX_BILL_TO_SITE_USE_ID NUMBER 18 Unique identifier for the bill-to site use for the selected sales order customer account site. This column stores the bill-to business purpose that is assigned to the sales order customer account site.
TRX_SHIP_TO_PARTY_SITE_ID NUMBER 18 Unique identifier for the party site of the ship-to party site address for the sales order customer.
ITEM_LEVEL_CODE VARCHAR2 30 Identifies the item level code, such as ITEM, and ITEM_CATEGORY. Values are from the lookup code ORA_CJM_ITEM_TYPE.
ITEM_ID NUMBER 18 Unique identifier for the item level code created in the system.
TRANSACTION_CURR_AMOUNT NUMBER Unique identifier for the accrual amount in the original transaction currency, for example, the accrual amount is the sales order currency for a direct sales order.
TRANSACTION_CURR_AMOUNT_REM NUMBER Unique identifier for the accrual amount remaining in the original transaction currency, for example, the accrual amount remaining that is not yet claimed.
TRANSACTION_CURR_AMOUNT_PAID NUMBER Indicates the accrual amount claimed in the original transaction currency.
TRANSACTION_CURRENCY_CODE VARCHAR2 15 Unique identifier for the currency of the original transaction, for example, the order currency code for a direct sale order.
EXCHANGE_RATE_TYPE VARCHAR2 30 Indicates the currency exchange rate type for which accruals are created, for example Corporate.
EXCHANGE_RATE_DATE DATE Indicates the date of the exchange on which accruals were created.
EXCHANGE_RATE NUMBER Indicates the exchange rate between the transactional currency and the functional currency.
ACCTD_AMOUNT NUMBER Indicates the accrual amount functional currency.
ACCTD_AMOUNT_REMAINING NUMBER Indicates the remaining accrual amount in the functional currency.
ACCTD_AMOUNT_PAID NUMBER Indicates the claimed accrual amount in the functional currency.
PROGRAM_AMOUNT NUMBER Indicates the accrual amount in the channel program currency.
PROGRAM_AMOUNT_REMAINING NUMBER Indicates the accrual amount remaining in the channel program currency.
PROGRAM_AMOUNT_PAID NUMBER Indicates the claimed accrual amount in the channel program currency.
PROGRAM_CURRENCY_CODE VARCHAR2 15 Identifies the Channel Program Currency code in which the budget is requested.
ACCRUAL_DATE DATE Identifies the creation date of the accrual records.
GL_DATE DATE Identifies the General Ledger Posting Date.
REQUESTED_GL_DATE DATE General Ledger posting date. While posting the records to the GL, as per the sweep fix, if the period is closed, the records get posted in the next open GL period, and this column is updated with the actual GL posted date.
GL_POSTED_FLAG VARCHAR2 1 Identifies if the accrual record was posted in the GL. This column is set to Y if the record posted successfully, F if the GL posting failed due to any errors with the accrual record, and the record will then be preprocessed in the next run, and N if the accrual record is not yet posted to GL.
EARNED_ACCRUALS_EVENT VARCHAR2 30 GL posting event value for earned accruals.
YEAR_ID NUMBER 18 Identifies the calendar year for which the accruals were created.
OBJECT_TYPE VARCHAR2 30 Identifies the type of object for which accruals are created, such as invoice, third-party order, sales order, and so on.
OBJECT_ID NUMBER 18 Contains the unique identifier for the object type, for example, the order header ID for a direct sales order and document header ID for an indirect sales order.
OBJECT_LINE_ID NUMBER 18 Contains the object line ID, such as fulfillment line ID in the case of a direct sales order and document line ID in the case of an indirect sales order.
UTILIZATION_TYPE VARCHAR2 30 Identifies the type of utilization, such as Accrual, Utilized, or Adjustment record. Values are from the lookup ORA_CJM_UTILIZATION_TYPE.
ADJUSTMENT_TYPE VARCHAR2 30 Indicates the program adjustment types for example INCREASE_EARNED and DECREASE EARNED. Values are from the lookup ORA_CJM_ADJUSTMENT_TYPE.
ADJUSTMENT_TYPE_ID NUMBER 18 Identifies the adjustment type ID for different adjustment types.
MANUAL_ADJUSTMENT_ID NUMBER 18 Unique identifier for manual adjustment records. This is a foreign key from the CJM_MANUAL_ADJUSTMENTS_ALL_B table.
ADJUSTMENT_REASON_ID NUMBER 18 Contains the adjustment reason that users add while creating the manual adjustment record. This reason ID will be a reference to the unique identifier for the adjustment reason created in the system for the adjustment type.
ACCRUAL_QTY NUMBER Contains the quantity information for which the accrual record was created.
ACCRUAL_QTY_REMAINING NUMBER Contains information about the remaining quantity that can be associated.
ACCRUAL_QTY_PAID NUMBER Indicates the claimed accrual quantity.
ACCRUAL_UOM VARCHAR2 15 Contains the UOM information for which the accrual record was created.
ACCRUAL_QTY_IN_PROG_LINE_UOM NUMBER Identifies the accrual quantity in the program line UOM. Contains the converted value if the program line UOM and transaction UOM are different.
PROGRAM_LINE_UOM_CODE VARCHAR2 15 Identifies the program line UOM code for the accrual record.
REFERENCE_TYPE VARCHAR2 30 Identifies the reference type. For example, it contains the batch for an indirect sales order.
REFERENCE_ID NUMBER 18 Identifies the reference ID. For example, it contains the document batch ID for an indirect sales order.
INVOICE_DATE DATE Contains the invoice date for the sales order.
INVOICE_NUMBER VARCHAR2 50 Identifies the invoice number for the sales order.
INVOICE_LINE_NUMBER NUMBER Identifies the invoice line number for the sales order line.
ORIG_UTILIZATION_ID NUMBER 18 Identifies the original utilization ID.
DISCOUNT_TYPE VARCHAR2 30 Identifies the discount type for the customer rebate program.
DISCOUNT_AMOUNT NUMBER Identifies the discount amount for the customer rebate program.
DOCUMENT_PROGRAM_ID NUMBER 18 Contains the foreign key reference from CJM_DOCUMENT_PROGRAMS table.
ACCRUAL_TRX_TYPE VARCHAR2 30 Contains the transaction information for the accrual quantity, accrual UOM, and transaction unit price for which the accrual record is created. Possible values are invoice and order. Obsolete
TRANSACTION_UNIT_PRICE NUMBER Contains the transaction unit price for the accrual record.
SEEDED_PROGRAM_TYPE_CODE VARCHAR2 30 Contains the predefined program type values. Values are from the lookup ORA_CJM_SEEDED_PROGRAM_TYPE.
PROGRAM_TYPE_ID NUMBER 18 Contains the foreign key reference from CJM_PROGRAM_TYPES_B.PROGRAM_TYPE_ID.
PO_NUMBER VARCHAR2 30 Contains the purchase order number for the loaded sale data.
PERIOD_NAME VARCHAR2 15 Indicates the period name of the period in the customer calendar.
ADJUSTMENT_DATE DATE Indicates the date used for the adjustment. For tier adjustment records, the start date of the Create Accruals for Volume Programs job is the adjustment date. For lump sum and customer rebate programs, the adjustment date is the accrual date. For manual adjustments, the adjustment date is the date entered by the user.
SALES_AMOUNT NUMBER Indicates the total sales amount for the aggregated document lines.
ACCRUAL_BASIS_AMOUNT NUMBER Indicates the total amount for the aggregated document lines based on the accrual basis from the program type.
INVENTORY_ORGANIZATION_ID NUMBER 18 Contains the item validation identifier for the inventory organization.

Indexes

Index Uniqueness Tablespace Columns Status
CJM_CUSTOMER_ACCRUALS_ALL_N1 Non Unique DEFAULT BU_ID, CUST_ACCOUNT_ID, TRANSACTION_CURRENCY_CODE, PROGRAM_HEADER_ID, YEAR_ID
CJM_CUSTOMER_ACCRUALS_ALL_N2 Non Unique DEFAULT INVOICE_NUMBER, ITEM_ID
CJM_CUSTOMER_ACCRUALS_ALL_N3 Non Unique DEFAULT BU_ID, CUST_ACCOUNT_ID, TRANSACTION_CURRENCY_CODE, ITEM_ID, YEAR_ID
CJM_CUSTOMER_ACCRUALS_ALL_N4 Non Unique DEFAULT CUST_ACCOUNT_ID Obsolete
CJM_CUSTOMER_ACCRUALS_ALL_N5 Non Unique DEFAULT CUST_ACCOUNT_ID, PROGRAM_HEADER_ID, PROGRAM_TYPE_ID, GL_POSTED_FLAG
CJM_CUSTOMER_ACCRUALS_ALL_N6 Non Unique DEFAULT UPPER("INVOICE_NUMBER")
CJM_CUSTOMER_ACCRUALS_ALL_N7 Non Unique DEFAULT BU_ID, CUST_ACCOUNT_ID, PROGRAM_HEADER_ID, ITEM_ID, ACCRUAL_UOM
CJM_CUSTOMER_ACCRUALS_ALL_N8 Non Unique CJM_CUSTOMER_ACCRUALS_ALL_N8 REFERENCE_ID, PROGRAM_TYPE_ID
CJM_CUSTOMER_ACCRUALS_ALL_U1 Unique DEFAULT CUSTOMER_ACCRUAL_ID