BusinessImportLogObject Table
The BusinessImportLogObject
table stores summary data for the execution of individual object imports
within a business import execution.
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
ImportObjectID
|
Type: integer. Key. Generated ID Surrogate ID that uniquely identifies an object in a business import execution. |
ImportID
|
Type: integer. Key Business import ID this object belongs, foreign key to |
ObjectName
|
Type: text (max 50 characters). Nullable Name of the business import object. |
ObjectType
|
Type: text (max 50 characters). Nullable Type of the business import object. |
StartDate
|
Type: datetime. Nullable Date and time when the object began to be imported on FNMS server. |
EndDate
|
Type: datetime. Nullable Date and time when import of the object is completed on FNMS server. |
Status
|
Type: integer. Nullable Status of object import: 0 - Not completed, 1 - Completed. |
Processed
|
Type: integer. Nullable Number of rows from data source that are processed for the object import. |
Matched
|
Type: integer. Nullable Number of rows in the staging table that match records in the corresponding FNMS table for the object. |
Rejected
|
Type: integer. Nullable Number of rows in the staging table that are rejected for the object import. |
Updated
|
Type: integer. Nullable Number of rows in the staging table that are updated for the object import. |
Created
|
Type: integer. Nullable Number of rows in the staging table that are created for the object import. |
Deleted
|
Type: integer. Nullable Number of rows in the staging table that are deleted for the object import. |
FlexNet Manager Suite (On-Premises)
2020 R1