1. Tables and Views for SCM
  2. CMR_ACCRUAL_CLR_AMTS

CMR_ACCRUAL_CLR_AMTS

This table stores manual/auto accrual clearing events.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMR_ACCRUAL_CLR_AMTS_PK

ACCRUAL_CLR_ID

Columns

Name Datatype Length Precision Not-null Comments
ACCRUAL_CLR_ID NUMBER 18 Yes Surrogate key: Uniquely identifies the accrual clearing event.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Yes Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
ACCRUAL_ACCOUNT_ID NUMBER 18 Accrual account identifier - this account is from SLA table where user posted accrual against this account.
CHART_OF_ACCOUNTS_ID NUMBER 18 Key flexfield structure instance defining column, foreign key to GL_CODE_COMBINATIONS table.
SOLD_TO_BUSINESS_UNIT_ID NUMBER 18 Business unit identifier where invoice is created and accrual is accounted.
ACCRUAL_PROCESSED_FLAG VARCHAR2 1 Indicates whether an accounting event was generated for accrual clearing transaction.
DELIVERY_PROCESSED_FLAG VARCHAR2 1 Indicates whether an accounting event was generated for the expense adjustment transaction due to accrual clearing.
CMR_ACCRUAL_AMT NUMBER Net posted Accrual amount by CMR in functional currency.
AP_ACCRUAL_AMT NUMBER Net posted Accrual Amount by AP in functional currency.
ACCRUAL_CLR_AMT NUMBER Accrual clearing amount in functional currency which is manual or Auto cleared by user.
ENTERED_AMOUNT NUMBER Entered amount in user entered transaction currency.
LATEST_TXN_DATE TIMESTAMP Yes Maximum transaction date from Receiving transactions, invoices and retro prices events.
EVENT_TYPE_CODE VARCHAR2 25 Yes Single column FK: Identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES.
TRANSACTION_TYPE_CODE VARCHAR2 40 Receipt accounting transaction type code.
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Identifier defined on purchase order line.
INVENTORY_ORGANIZATION_ID NUMBER 18 Inventory organization identifier.
DESTINATION_TYPE_CODE VARCHAR2 25 Identifies the destination type for material - INVENTORY or EXPENSE.
CMR_PO_LINE_LOCATION_ID NUMBER 18 Identifies the Purchase Order Line Location.
ACCRUAL_CLR_MODE VARCHAR2 30 Indicates accrual clearing mode. It is auto accrual clearing or manual clearing.
REVERSAL_ACCRUAL_CLR_ID NUMBER 18 Reversal accrual clearing identifier - This is populated for accrual reversal events. This column refers to accrual_clr_id.
ACCRUAL_CLR_RULE_NAME VARCHAR2 25 Auto accrual clearing rule name - it will be populated with Rule Name when it is Auto Clearing.
ACCRUAL_CLR_REASON_DESC VARCHAR2 100 Yes Reason description - user entered reason while performing accrual clearing and reversal transactions.
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.
RECEIVED_QTY NUMBER Net received quantity as reported in receipt accounting.
INVOICE_QTY NUMBER Invoice quantity as reported by accounts payable.
CMR_ACCRUAL_AMT_ACCRUAL NUMBER Net posted Accrual amount for accrual by CMR in functional currency.
CMR_ACCRUAL_AMT_NONRECTAX NUMBER Net posted Accrual amount for non recoverable tax by CMR in functional currency.
AP_ACCRUAL_AMT_ACCRUAL NUMBER Net posted Accrual Amount for accrual by AP in functional currency.
AP_ACCRUAL_AMT_NONRECTAX NUMBER Net posted Accrual Amount for non recoverable tax by AP in functional currency.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to business unit identifier. Indicates the Invoicing business unit for supplier facing nodes in Purchase order flows.
CURRENCY_CONVERSION_RATE NUMBER Currency conversion Rate for accrual clearing transactions.
CURRENCY_CONVERSION_DATE TIMESTAMP Currency conversion Date for accrual clearing transactions.
ENTERED_CMR_ACCRUAL_AMT NUMBER Accrual amount in purchase order currency.
ENTERED_CMR_NONRECTAX_AMT NUMBER Entered Non Recoverable Tax Amount.
ENTERED_AP_ACCRUAL_AMT NUMBER Invoice Accrual amount in purchase order currency.
ENTERED_AP_NONRECTAX_AMT NUMBER Entered Invoice Non recoverable Tax Amount.
LATEST_ACCOUNTING_EVENT_ID NUMBER 18 Stores latest accounting event Identifier. This is FK to {CMR_RCV_EVENTS}.
LATEST_CMR_AP_INVOICE_DIST_ID NUMBER 18 Latest receipt accounting invoice distribution identifier.
ACCRUAL_CLR_GROUP_ID NUMBER 18 Accrual Clearing Group identifier used while performing accrual clearing.
LE_TIMEZONE_CODE VARCHAR2 50 Represents the Timezone code of the Legal Entity.
CMR_ACCRUAL_AMT_RECTAX NUMBER Net posted Accrual amount for recoverable tax by CMR in functional currency.
AP_ACCRUAL_AMT_RECTAX NUMBER Net posted Accrual Amount for recoverable tax by AP in functional currency.

Foreign Keys

Table Foreign Table Foreign Key Column
cmr_accrual_clr_amt_dtls cmr_accrual_clr_amts ACCRUAL_CLR_ID

Indexes

Index Uniqueness Tablespace Columns
CMR_ACCRUAL_CLR_AMTS_N1 Non Unique FUSION_TS_TX_DATA SOLD_TO_BUSINESS_UNIT_ID, ACCRUAL_ACCOUNT_ID, CMR_PO_DISTRIBUTION_ID
CMR_ACCRUAL_CLR_AMTS_N2 Non Unique Default CMR_PO_DISTRIBUTION_ID
CMR_ACCRUAL_CLR_AMTS_N3 Non Unique Default REVERSAL_ACCRUAL_CLR_ID
CMR_ACCRUAL_CLR_AMTS_PK Unique FUSION_TS_TX_DATA ACCRUAL_CLR_ID