CMR_ACCRUAL_SUMMARY
This table stores all the accrual balances at purchase order distribution level.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
CMR_ACCRUAL_SUMMARY_PK |
CMR_PO_DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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. | |
| PO_LINE_LOCATION_ID | NUMBER | 18 | Yes | Purchase order shipment schedule identifier. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Indicates the receipt accounting purchase order schedule identifier. | ||
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Business unit that will create the invoice for the purchase. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier defined on purchase order line. | ||
| ORGANIZATION_ID | NUMBER | 18 | Inventory organization identifier of the transaction. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | Identifies the inventory organization code. | ||
| PROFIT_CENTER_BU_ID | NUMBER | 18 | Profit center business unit where accounting entry will be created. | ||
| 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. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. Especially needed for purchase orders involving non inventory items. | ||
| 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}. | ||
| STATUS | VARCHAR2 | 40 | Identifies accrual status. Possible values are Open, Marked for clearing, Cleared, Marked for Reversal. | ||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. | |||
| RECEIPT_TXN_DATE | TIMESTAMP | The date when the latest receipt transaction happened. | |||
| INVOICE_ACCT_DATE | TIMESTAMP | The date when the latest invoice transaction happened. | |||
| ACCOUNTED_DATE | TIMESTAMP | The date when the transaction was accounted. | |||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Accounting event identifier of purchase order transactions and foreign key column to table {CMR_RCV_EVENTS}. | ||
| CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Internal accounts payable invoice distribution identifier. | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity. | ||
| RECEIVED_QTY | NUMBER | Net received quantity as reported by receipt accounting. | |||
| INVOICE_QTY | NUMBER | Invoice quantity as reported by accounts payable. | |||
| QTY_DIFFERENCE | NUMBER | Difference between net received quantity and net invoiced quantity. | |||
| RECEIVED_AMT | NUMBER | Net posted accrual amount by CMR to SLA. | |||
| RECEIVED_ACCRUAL_AMT | NUMBER | Net posted accrual amount for accrual by CMR to SLA. | |||
| RECEIVED_NONRECTAX_AMT | NUMBER | Net posted accrual amount for non-recoverable tax by CMR to SLA. | |||
| RECEIVED_RECTAX_AMT | NUMBER | Net posted accrual amount for recoverable tax by CMR to SLA. | |||
| INVOICE_AMT | NUMBER | Net posted accrual amount by account payables to SLA. | |||
| INVOICE_ACCRUAL_AMT | NUMBER | Net posted accrual amount accrued by account payables to SLA. | |||
| INVOICE_NONRECTAX_AMT | NUMBER | Net posted accrual amount for non-recoverable tax by account payables to SLA. | |||
| INVOICE_RECTAX_AMT | NUMBER | Net posted accrual amount for recoverable tax by account payables to SLA. | |||
| AMT_DIFFERENCE | NUMBER | Difference between net received amount and net invoiced amount. | |||
| 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. | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Identifies currency code specified at the ledger. | ||
| MARKED_FOR_REVIEW | VARCHAR2 | 1 | Identifies if the current accrual record is marked for review. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_ACCRUAL_SUMMARY_N1 | Non Unique | DEFAULT | INVENTORY_ITEM_ID |
| CMR_ACCRUAL_SUMMARY_N2 | Non Unique | DEFAULT | VENDOR_ID |
| CMR_ACCRUAL_SUMMARY_N3 | Non Unique | DEFAULT | PO_NUMBER |
| CMR_ACCRUAL_SUMMARY_N4 | Non Unique | DEFAULT | ITEM_DESCRIPTION |
| CMR_ACCRUAL_SUMMARY_N5 | Non Unique | DEFAULT | STATUS, BILL_TO_BUSINESS_UNIT_ID |
| CMR_ACCRUAL_SUMMARY_U1 | Unique | DEFAULT | CMR_PO_DISTRIBUTION_ID |