| View Name: | MARISysImportDef |
| Based on table: | MPSysImportDef |
| Group: | |
| Description: | System Table: Text Field Mapping for data import |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ImportDefinition | ImportDefID INT Primary |
||
| ClassID | ClassID INT Index |
ClassID | |
| Company | Mandant INT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| ImportType | ImportTyp NVARCHAR (50) |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| Title | Titel SMALLINT (0=false,-1=true) |
||
| SeparationChar | Trennzeichen INT |
||
| TextLimit | Textbegrenzung INT |
||
| DecimalFormat | DecimalFormat INT |
||
| DateFormat | DateFormat INT |
||
| ImportMethod | ImportMethode INT |
||
| TextAnsiMode | TextAnsiMode INT |
||
| SyncMode | SyncMode INT |
||
| DBServerType | DBServerType INT |
||
| DBServer | DBServer NVARCHAR (50) |
||
| DBDatabase | DBDatabase NVARCHAR (100) |
||
| DBUID | DBUID NTEXT |
||
| DBPWD | DBPWD NTEXT |
||
| SourceSQL | SourceSQL NTEXT |
||
| DefaultFilePath | DefaultDateiPfad NVARCHAR (200) |
||
| SupportedFieldsVersion | SupportedFiedsVersion INT |
||
| UserTableID | UserTableID INT Index |
||
| ClassKey | ClassKey NVARCHAR (20) Index |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARISysImportDefColumns | System Table: Text Field Mapping for data import by col |
| MARISysImportDefColumnsRules | System Table: Text Field Mapping for data import Extra rules |
| MARISysImportDefLog | System Table: Stores date and file with result |