CMR_ACCR_RECONC_GT
This table stores each po distribution with accounted value in SLA posted by CMR and AP subledgers.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SOLD_TO_BUSINESS_UNIT_ID | NUMBER | 18 | business unit identifier where invoice is created and accrual is accounted | |
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Bill to business unit id and same as invoicing business unit | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | 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 | Chart of accounts Identifier of accounts and Key flexfield structure instance defining column. | |
| EVENT_TRANSACTION_DATE | TIMESTAMP | event transaction date on which date this event is accounted and posted to SLA | ||
| EVENT_ACCOUNTED_AMT | NUMBER | source event transaction accounted amount in functional currency | ||
| EVENT_TYPE_CODE | VARCHAR2 | 25 | Single column FK: Identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES. | |
| EVENT_ENTERED_AMT | NUMBER | source event transaction entered amount in user specified currency. This will be different if user performs non functional currency | ||
| EVENT_UOM_CODE | VARCHAR2 | 3 | event unit of measure for the quantity | |
| CURRENCY_CODE | VARCHAR2 | 15 | identifies currency of the event | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | |
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion | ||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | accounting event id - this is unique which is sent to SLA while creating events from CMR. Use this column to derive the cmr_rcv_transaction_id or cmr_accrual_clr_id. For invoices it will be null | |
| EVENT_COST_ID | NUMBER | 18 | store event cost identifier of accounted transaction. | |
| CMR_SUB_LEDGER_ID | NUMBER | 18 | Receipt accounting distribution identifier | |
| SLA_EVENT_ID | NUMBER | 18 | Event Identifier generated by SLA API call for all receipt accounting transactions. This is unique identifier to identify the transaction. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Inventory organization where the items are delivered. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}. | |
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | identifies the type of destination for material - INVENTORY or EXPENSE | |
| EVENT_COST_SOURCE | VARCHAR2 | 30 | Event cost source - it is PO price or Non-Recoverable tax | |
| EVENT_DISTRIBUTION_TYPE | VARCHAR2 | 50 | Event distribution type identifier | |
| EVENT_TRANSACTION_NUMBER | VARCHAR2 | 50 | Event transaction number on purchase order distributions. Either receipt number or purchase order number based on transaction type. | |
| INVOICE_DISTRIBUTION_ID | NUMBER | 18 | invoice distribution id - populated only If invoice transaction from Account Payables | |
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Single Column FK: Identifies the receiving transaction. | |
| ACCRUAL_CLR_ID | NUMBER | 18 | Accrual clearing line identifier - this is populated when event is ACCRUAL CLEARING or ACCRUAL REVERSAL. For other events it is null | |
| EVENT_QTY | NUMBER | source event transaction accounted quantity | ||
| TRADE_EVENT_ID | NUMBER | 18 | Trade event for supplier facing global POs. | |
| SLA_AE_HEADER_ID | NUMBER | 18 | sla header id - foreign key relationship with XLA_AE_HEADERS | |
| SLA_AE_LINE_NUM | NUMBER | 18 | sla line number - foreign key relationship with XLA_AE_LINES |