| Table Name: | MPSysImportDef |
| View Name: | MARISysImportDef |
| Group: | |
| Description: | System Table: Text Field Mapping for data import |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ImportDefID | ImportDefinition INT Primary |
||
| ClassID | ClassID INT Index |
ClassID | |
| Mandant | Company INT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| ImportTyp | ImportType NVARCHAR (50) |
||
| Bezeichnung | Description NVARCHAR (50) |
||
| Titel | Title SMALLINT (0=false,-1=true) |
||
| Trennzeichen | SeparationChar INT |
||
| Textbegrenzung | TextLimit INT |
||
| DecimalFormat | DecimalFormat INT |
||
| DateFormat | DateFormat INT |
||
| ImportMethode | ImportMethod 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 |
||
| DefaultDateiPfad | DefaultFilePath NVARCHAR (200) |
||
| SupportedFiedsVersion | SupportedFieldsVersion INT |
||
| UserTableID | UserTableID INT Index |
||
| ClassKey | ClassKey NVARCHAR (20) Index |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPSysImportDefLog | System Table: Stores date and file with result |
| MPSysImportDefSpalten | System Table: Text Field Mapping for data import by col |
| MPSysImportDefSpaltenRegeln | System Table: Text Field Mapping for data import Extra rules |