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 |