CSE_TRANSACTED_ASSETS
Intersection table that relates the asset and the transaction entities.This represents the source and destination assets impacted by the transaction.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_TRANSACTED_ASSETS_PK |
TRANSACTED_ASSET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTED_ASSET_ID | NUMBER | 18 | Yes | The primary key of the Transacted Asset entity. | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction Identifier. Foreign key to cse_transactions. | |
| ASSET_ID | NUMBER | 18 | Asset that is transacted as part of this transaction. | ||
| TRANSACTED_QUANTITY | NUMBER | Quantity transacted as part of the asset in this transaction. This could be a +ive or -ive transaction. | |||
| TRANSACTED_UOM_CODE | VARCHAR2 | 3 | The unit of measure at which the quantity was transacted in the source application. | ||
| SECONDARY_QUANTITY | NUMBER | This is the secondary quantity captured when the item supports dual units of measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure. | ||
| LOCATION_CONTEXT | VARCHAR2 | 30 | The location context where the asset is transacted from or to. | ||
| ORGANIZATION_ID | NUMBER | 18 | Organization Identifier. Foreign key to the maintenance organization. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Secondary inventory code. The inventory warehouse location. | ||
| INVENTORY_LOCATOR_ID | NUMBER | 18 | Inventory Locator Identifier. Foreign key to the secondary inventory. | ||
| WORK_ORDER_ID | NUMBER | 18 | Work Order Identifier. Foreign key to the work order business object. | ||
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | Work Order Operation Identifier. The foreign key to the work order operation entity. | ||
| WORK_CENTER_ID | NUMBER | 18 | Work Center Identifier. Foreign key to the work center entitiy. | ||
| SPLIT_FROM_ASSET_ID | NUMBER | 18 | Asset that this Transacted Asset is splitting from. | ||
| MERGED_TO_ASSET_ID | NUMBER | 18 | Asset that this Transacted Asset is merging to. | ||
| ITEM_ID | NUMBER | 18 | Inventory item identifier of the asset that is being transacted. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the asset that is being transacted. | ||
| LOT_NUMBER | VARCHAR2 | 80 | The lot number of the asset that is being transacted. | ||
| OKC_INTERFACE_FLAG | VARCHAR2 | 1 | Flag to indicate whether service contract interface is required or not. When asset is either created from the open interface or service, user has a choice to not to interface to service contract system by setting this flag to 'N'. The user choice is captured in this table for history. | ||
| EXPLODE_BOM_FLAG | VARCHAR2 | 1 | Flag indicating whether component assets are created as a result of exploding the bills of materials of the item for which the asset is created. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 120 | The sales order number where the asset transaction is involved in. | ||
| SALES_ORDER_ID | NUMBER | 18 | The sales order identifier of the asset which is involved in the transaction. | ||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 120 | The sales order line number of the asset which is involved in the transaction. | ||
| SALES_ORDER_LINE_ID | NUMBER | 18 | The sales order line identifier of the asset that is involved in the transaction. | ||
| BUSINESS_PROCESS_CODE | VARCHAR2 | 30 | When staged transactions are created for the replacement/advance exchange processing, this process code differentiates the exchange process and the depot repair process. | ||
| TRANSACTION_ACTION_CODE | VARCHAR2 | 30 | This attribute captures the specific action associated with the asset when a transaction carries multiple assets to perform multi actions. For example, a inbound and outbound asset action while performing a replace or upgrade transaction. | ||
| SRC_TRANSACTION_DATE | TIMESTAMP | Source Transaction Date. Date when the transaction was performed in the source system. Examples are rma receipt date and shipment date. | |||
| TRANSACTION_STATUS_CODE | VARCHAR2 | 30 | When a transaction involving more than one source actions that updates the end state of the transaction, the state of the a sset invloved in the transaction is recorded here. This status is what will be looked up by the source actions to finish processing of this transaction. | ||
| FULL_SNAPSHOT_FLAG | VARCHAR2 | 1 | Indicates if the history record is created as a full snapshot. | ||
| SNAPSHOT_QUALIFIED | VARCHAR2 | 1 | Indicates whether this record is qualified to be counted for the snapshot process. | ||
| GEN_OBJECT_ID | NUMBER | 18 | Genealogy Object Identifier. A foreign key to cse_genealogy_objects record. | ||
| TXN_GROUP_CODE | VARCHAR2 | 80 | The transaction group code that we use to group two or more transactions that are inter connected. | ||
| EVENT_RAISED_FLAG | VARCHAR2 | 1 | Flag indicating whether an asset event was raised or not. | ||
| CASCADED_FROM_ASSET_ID | NUMBER | 18 | The parent asset from which the location information is cascaded from. | ||
| RETURNED_FROM_PARENT_ASSET_ID | NUMBER | 18 | The parent asset refernce is captured and is stored here when the rma receipt happens for the component. This will be used to rebuild the configuration upon shipment of the replacement. This column is used only for staged transactions. | ||
| ACTUAL_RETURNED_ASSET_ID | NUMBER | 18 | The actual asset that was returned for the staged inbound transaction. Used for component replacement functionality from service logistics. | ||
| ACTUAL_SHIPPED_ASSET_ID | NUMBER | 18 | The actual asset that was shipped for the staged outbound transaction. Used for component replacement functionality from service logistics. | ||
| 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_TRANSACTED_ASSETS_N01 | Non Unique | Default | WORK_ORDER_ID, WORK_ORDER_OPERATION_ID, LOCATION_CONTEXT |
| CSE_TRANSACTED_ASSETS_N02 | Non Unique | Default | ASSET_ID, TRANSACTION_ID |
| CSE_TRANSACTED_ASSETS_N03 | Non Unique | Default | SALES_ORDER_LINE_ID, SALES_ORDER_ID |
| CSE_TRANSACTED_ASSETS_U01 | Unique | Default | TRANSACTED_ASSET_ID |