CMR_ACCRUAL_TXNS
This table stores all the accrual transactions against purchase order distributions including invoices.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
CMR_ACCRUAL_TXNS_PK |
INVOICE_DISTRIBUTION_ID, CMR_SUB_LEDGER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_DISTRIBUTION_ID | NUMBER | 18 | Yes | Invoice distribution identifier - populated only if invoice transaction from account payables. | |
| CMR_SUB_LEDGER_ID | NUMBER | 18 | Yes | Distribution line identifier and foreign key column to table {CMR_RCV_DISTRIBUTIONS} | |
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Yes | Accounting event identifier of purchase order transactions and foreign key column to table {CMR_RCV_EVENTS}. | |
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Business unit that will create the invoice for the purchase. | ||
| PROFIT_CENTER_BU_ID | NUMBER | 18 | Profit center business unit where accounting entry will be created. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifies an entity in receipt accounting purchase order distributions. This value will exist for match to purchase order as well as match to receipt cases. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Indicates the receipt accounting purchase order schedule identifier. | ||
| PO_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order. | ||
| LINE_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order line. | ||
| SHIPMENT_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order shipment. | ||
| DISTRIBUTION_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order distribution. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier defined on purchase order line. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. Especially needed for purchase orders involving non inventory items. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the inventory organization identifier. | ||
| TRANSACTION_TYPE | VARCHAR2 | 240 | Receipt accounting transaction type. | ||
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Transaction number holds receipt number/invoice number depending on the transaction type. | ||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. | |||
| ACCOUNTED_DATE | TIMESTAMP | The date when the transaction was accounted. | |||
| EVENT_UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the event. | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Yes | Identifies type of destination for the material: Inventory, Expense. | |
| VENDOR_ID | NUMBER | 18 | Identifies the supplier and references {POZ_SUPPLIERS.vendor_id}. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Identifies the supplier site and references {POZ_SUPPLIER_SITES_V.vendor_site_id}. | ||
| TRANSACTION_QTY | NUMBER | Net received quantity/invoiced quantity as reported by receipt accounting/accounts payable depending on the transaction type. | |||
| TRANSACTION_AMT | NUMBER | Net posted accrual amount by CMR/accounts payable to SLA depending on the transaction type. | |||
| TRANSACTION_NONRECTAX_AMT | NUMBER | Net posted accrual amount for non-recoverable tax by CMR to SLA. | |||
| 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. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who 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. | ||
| TRANSACTION_RECTAX_AMT | NUMBER | Net posted Accrual Amount for recoverable tax by CMR to SLA. | |||
| TRANSACTION_ACCRUAL_AMT | NUMBER | Net posted accrual amount for accrual by CMR to SLA. | |||
| EVENT_TYPE_CODE | VARCHAR2 | 25 | Identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES. | ||
| EVENT_COST_ID | NUMBER | 18 | Yes | Event Cost Identifier and foreign key column to table {CMR_RCV_EVENT_COSTS} | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies currency code specified at the ledger. | ||
| LE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the date for the transaction is expected to be in legal entity time zone. | ||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Indicates legal entity time zone for transaction. | ||
| TRANSACTION_DATE_ORDER | TIMESTAMP | Indicates the transaction order. | |||
| DISTRIBUTION_STATUS | VARCHAR2 | 5 | Indicates if the distribution is processed or not. | ||
| EVENT_DISTRIBUTION_TYPE | VARCHAR2 | 50 | Event distribution type identifier. | ||
| SUMMARIZED_FLAG | VARCHAR2 | 1 | Indicates if the transaction data is summarized into cmr_accrual_summary. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_ACCRUAL_TXNS_N1 | Non Unique | DEFAULT | SUMMARIZED_FLAG, BILL_TO_BUSINESS_UNIT_ID |
| CMR_ACCRUAL_TXNS_N2 | Non Unique | DEFAULT | CMR_PO_DISTRIBUTION_ID, CMR_SUB_LEDGER_ID |
| CMR_ACCRUAL_TXNS_U1 | Unique | DEFAULT | INVOICE_DISTRIBUTION_ID, CMR_SUB_LEDGER_ID |