DOO_ASSET_TRANSACTION_DETAILS
This table captures the asset transaction details related to the upgrade and replace flows.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
DOO_ASSET_TRANSACTION_DET_PK |
ASSET_TRANSACTION_DETAIL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ASSET_TRANSACTION_DETAIL_ID | NUMBER | 18 | Yes | Unique identifier of the Asset Transaction Detail. | |
FULFILL_LINE_ID | NUMBER | 18 | Yes | Unique Identifier for a fulfillment line. | |
ASSET_ID | NUMBER | 18 | Yes | Value that uniquely identifies the asset. It is the primary key for the asset. | |
QUANTITY | NUMBER | Yes | Quantity of the asset that Installed Base Assets will transact. | ||
UOM_CODE | VARCHAR2 | 3 | Yes | Abbreviation that identifies the unit of measure for the asset quantity. For example, Ea is an abbreviation for the Each unit of measure. | |
STATUS_ID | NUMBER | 18 | Yes | Value that uniquely identifies the status of the asset after Installed Base Assets does the transaction on the asset. | |
TRANSACTION_ACTION_CODE | VARCHAR2 | 30 | Yes | Abbreviation that identifies the transaction that Installed Base Assets does on the asset. | |
CUSTOMER_ASSET_END_DATE | TIMESTAMP | Date and time when the customer asset ends in Installed Base Assets. Order Management Cloud captures the end date for the asset, then sends it to Installed Base Assets. Installed Base Assets uses the end date when it updates the customer asset e.g. Migrate. | |||
REF_ASSET_TRANSACTION_DTL_ID | NUMBER | 18 | Used by change management to associate the change order line's Asset Detail Id with the original. | ||
MODIFIED_FLAG | VARCHAR2 | 1 | Indicates that the row has been modified in the version currently submitted. | ||
SOURCE_ASSET_TXN_DETAIL_ID | VARCHAR2 | 50 | Original Asset information in external system. | ||
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. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
DOO_ASSET_TRANSACTION_DETAILS | doo_fulfill_lines_all | FULFILL_LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
DOO_ASSET_TRANSACTION_DET_U1 | Unique | Default | ASSET_TRANSACTION_DETAIL_ID |
DOO_ASSET_TRANSACTION_DET_U2 | Unique | Default | FULFILL_LINE_ID, ASSET_ID |