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

Details

ImportDetailID

Type: integer. Key. Generated ID

Surrogate ID that uniquely identifies an import execution detail.

ImportID

Type: integer. Key

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

RecordNumber

Type: integer. Nullable

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

Action

Type: text (max 10 characters). Nullable

The trace action of the import execution detail.

MGSRecordKey

Type: text (max 50 characters). Nullable

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

ImportObjectID

Type: integer. Key. Nullable

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

RecordDescription

Type: text (max 255 characters). Nullable

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

Message

Type: text (max 3000 characters). Nullable

Messages related to this import execution detail.