BusinessImportLogDetail Table

The BusinessImportLogDetail table stores per record import execution details for 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 BusinessImportLogDetail table

Database Column



Type: integer. Key. Generated ID

Surrogate ID that uniquely identifies an import execution detail.


Type: integer. Key

Business import ID this execution detail relates to, foreign key to BusinessImportLogSummary table.


Type: integer. Nullable

Row number of source data in staging table that this execution detail related to.


Type: text (max 10 characters). Nullable

The trace action of the import execution detail.


Type: text (max 50 characters). Nullable

ID of matching FNMS table record the Record Number is matched against.


Type: integer. Key. Nullable

Import object that this execution detail is related to, foreign key to BusinessImportLogObject table.


Type: text (max 255 characters). Nullable

Value of the trace field specified in the import element of business adapter xml if any.


Type: text (max 3000 characters). Nullable

Messages related to this import execution detail.