BusinessImportLogObject Table

The BusinessImportLogObject table stores summary data for the execution of individual object imports within a business import execution.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database 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.
Table 1. Database columns for BusinessImportLogObject table

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 BusinessImportLogSummary table.

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.