CSE_COST_TRANSACTIONS
This entity gathers all the transactions whose value is to be processed either as entitlement cost to be claimed from supplier or to pass it over to fixed assets or to do cost analysis on falure of assets where work is performed to correct them.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_COST_TRANSACTIONS_PK |
COST_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_TRANSACTION_ID | NUMBER | 18 | Yes | The cost transaction dentifier. This is the primary key of the entity. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | The source systems where transactions are gathered. The various source systems are Inventory, Manufacturing, Receiving and Accounts Payable. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | The type of transactions that are gathered. The various types come from the source systems Inventory, Manufacturing, Receiving and Accounts Payable. | |
| SOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | The transaction identifier for which the cost is gathered. | |
| PARENT_TRANSACTION_ID | NUMBER | 18 | The parent transaction identifier of the source transaction. This would be the receipt transaction identifier for a delivery transaction. | ||
| ORGANIZATION_ID | NUMBER | 18 | The organization where the source transaction is performed. | ||
| FA_BOOK_TYPE_CODE | VARCHAR2 | 30 | The fixed asset book that is associated with the inventory org where the operational assets are received. | ||
| COSTING_SOURCE_CODE | VARCHAR2 | 3 | The source system that will process this transaction for costing.It could be CMR for receipt accounting, WIP for work order transaction costing, and CST for inventory transaction costing. | ||
| TRANSACTION_QUANTITY | NUMBER | Yes | The quantity transacted in the transaction. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code for the transaction quantity. | |
| PRIMARY_QUANTITY | NUMBER | The quantity in primary unit of measure transacted in receiving. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | The primary unit of measure of the item transacted in receiving. | ||
| WORK_ORDER_ID | NUMBER | 18 | The work order identifier. The work order on which this transaction was performed. | ||
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | The work order operation identifier. The work order operation on which this transaction was performed. | ||
| PO_HEADER_ID | NUMBER | 18 | The purchase order header identifier. | ||
| PO_LINE_ID | NUMBER | 18 | The purchase order line identifier. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | The purchase order line location identifier. | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | The purchase order distribution identifier. | ||
| DELIVER_TO_PERSON_ID | NUMBER | 18 | The end user where the receipt is delivered to. This will become the assigned to in the fixed asset. | ||
| TRANSACTION_VALUE | NUMBER | The value of the transaction as processed. | |||
| UNIT_COST | NUMBER | The transaction value of the unit. | |||
| CURRENCY_CODE | VARCHAR2 | 20 | The currency in which the transaction is costed. | ||
| COST_COLLECTED_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether cost has been collected from either receipt accounting or costing module. | |
| INVOICE_COLLECTED_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether cost has been collected from the accounts payable invoice. | |
| ENTITLEMENT_PROCESSED_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether this transaction has been processed as entitlement for supplier warranty. | |
| FA_INTERFACED_FLAG | VARCHAR2 | 1 | Yes | Flag Indicating whether the fixed assets have been interfaced or not for this transaction. | |
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | The interface status code that identifies the various stage of the the interface process. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSE_COST_TRANSACTIONS_N01 | Non Unique | Default | SOURCE_TRANSACTION_ID, PO_HEADER_ID |
| CSE_COST_TRANSACTIONS_U01 | Unique | Default | COST_TRANSACTION_ID |