CSE_INTG_ASSETS_DEBUG
The product instances from the capture payload is persisted in this table for debugging any integration issues.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CSE_INTG_ASSETS_DEBUG_PK |
DEBUG_ASSET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEBUG_ASSET_ID | NUMBER | 18 | Yes | Debug Asset Identifier. The primary key of the table. | |
| DEBUG_TXN_ID | NUMBER | 18 | The foreign key to the debug transactions id for the integration. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number to be interfaced to product genealogy. | ||
| PRODUCT_INSTANCE_QUANTITY | NUMBER | The quantity of the product instance that is to be interfaced to product genealogy. | |||
| 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. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | The serial number to be interfaced to product genealogy. | ||
| INSTALLED_PARENT_ASSET_ID | NUMBER | The parent asset identifier to which the product instance is to be attached to. | |||
| INSTALLED_PARENT_ITEM_ID | NUMBER | The item identifier of the parent asset to which the product instance will be attached. | |||
| INSTALLED_PARENT_LOT_NUMBER | VARCHAR2 | 80 | The lot number of the parent asset to which the product instance will be attached. | ||
| INSTALLED_PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the parent asset to which the product instance will be attached. | ||
| REMOVED_PARENT_ITEM_ID | NUMBER | The item identifier of the parent asset from which the product instance will be removed. | |||
| REMOVED_PARENT_ASSET_ID | NUMBER | The identifier of the parent asset from which the product instance will be removed. | |||
| REMOVED_PARENT_LOT_NUMBER | VARCHAR2 | 80 | The lot number of the parent asset from which the product instance will be removed. | ||
| REMOVED_PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the parent asset from which the product instance will be removed. | ||
| SELF_INDEX | NUMBER | The asset identifier that is to be processed to cse_asset_b. | |||
| PARENT_INDEX | NUMBER | The parent asset identifier that is to be processed to cse_asset_b. | |||
| RELATION_INDEX | NUMBER | The relationship identifier that is to be processed to cse_asset_relationsips. | |||
| GEN_OBJECT_INDEX | NUMBER | The genealogy object identifier that is to be processed to cse_genealogy_objects. | |||
| RELATIONSHIP_ONLY_FLAG | VARCHAR2 | 1 | Flag indicating that the source system is sending this only to process the relationship info in product genealogy. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSE_INTG_ASSETS_DEBUG_U01 | Unique | Default | DEBUG_ASSET_ID |