| View Name: | MARISysImportDefLog |
| Based on table: | MPSysImportDefLog |
| Group: | |
| Description: | System Table: Stores date and file with result |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ImportDefLogID | ImportDefLogID INT Primary |
||
| ImportDefinition | ImportDefID INT Index |
MARISysImportDef.ImportDefinition | |
| ImportDate | ImportDate Datetime |
||
| ImportDocumentID | ImportDocumentID INT |
||
| ImportValueDocumentID | ImportValueDocumentID INT Index |
||
| ImportDescription | ImportDescription NVARCHAR (100) |
||
| PathName | PathName NTEXT |
||
| FileName | FileName NVARCHAR (255) |
||
| FileDate | FileDate Datetime |
||
| ExcelRegister | ExcelRegister NVARCHAR (50) |
||
| ImportResult | ImportResult INT |
||
| LinesTotal | LinesTotal INT |
||
| LinesInserted | LinesInserted INT |
||
| LinesUpdated | LinesUpdated INT |
||
| LinesIgnored | LinesIgnored INT |
||
| ErrorDetails | ErrorDetails NTEXT |
||
| DefinitionSettings | DefinitionSettings NTEXT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |