CMR_ACCR_RECONC_GT
This table stores each po distribution with accounted value in SLA posted by CMR and AP sub ledgers.
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 identifier and same as invoicing business unit. | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies entity in receipt accounting purchase order distributions. This value will exist for match to purchase order 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 | Indicates the 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 | Receiving accounting event identifier and references to {CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID}. For invoices it will be null. | |
| EVENT_COST_ID | NUMBER | 18 | Event Cost Identifier of the accounted transaction and references to {CMR_RCV_EVENT_COSTSS.EVENT_COST_ID}. | |
| CMR_SUB_LEDGER_ID | NUMBER | 18 | Receipt accounting distribution identifier of the accounted transaction. | |
| 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 purchase order 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 identifier - 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 purchase orders. | |
| 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. | |
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency code and it is ledger currency code of profit center business unit. | |
| LE_TIMEZONE_TRANSACTION_DATE | TIMESTAMP | Event transaction date as per the time zone code of the legal entity. | ||
| LE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the date for the transaction is expected to be in legal entity time zone. | |
| TRANSACTION_DATE_ORDER | TIMESTAMP | Indicates the transaction order for display. | ||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Indicates legal entity time zone for transaction. | |
| TXN_AMT | NUMBER | Transaction total amount includes accrual and taxes. | ||
| TXN_ACCRUAL_AMT | NUMBER | Transaction accrual amount excludes taxes. | ||
| TXN_NR_TAX_AMT | NUMBER | Transaction non-recoverable tax amount. | ||
| TXN_REC_TAX_AMT | NUMBER | Transaction recoverable tax amount. | ||
| TXN_ACCT_DATE | TIMESTAMP | Transaction accounting date derived based on transaction date. | ||
| DISTRIBUTION_STATUS | VARCHAR2 | 5 | Transaction accounting status. F - Final accounted, D - Draft accounted. |