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