{ "ReportVersion": "2019.3.1.0", "ReportGuid": "59cd2a7b90c74d8590c140b10d32ac5f", "ReportName": "TestSR", "ReportAlias": "TestSR", "ReportCreated": "/Date(1556525364000+0200)/", "ReportChanged": "/Date(1559744449493+0200)/", "EngineVersion": "EngineV2", "Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class TestSR : Stimulsoft.Report.StiReport\r\n {\r\n public TestSR() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "ReferencedAssemblies": { "0": "System.Dll", "1": "System.Drawing.Dll", "2": "System.Windows.Forms.Dll", "3": "System.Data.Dll", "4": "System.Xml.Dll", "5": "Stimulsoft.Controls.Dll", "6": "Stimulsoft.Base.Dll", "7": "Stimulsoft.Report.Dll" }, "Dictionary": { "DataSources": { "0": { "Ident": "StiPostgreSQLSource", "Name": "anrede", "Alias": "anrede", "Key": "1b7587d109504a42889530aaee30dcb8", "Columns": { "0": { "Name": "anrede", "Index": -1, "NameInSource": "anrede", "Alias": "anrede", "Type": "System.String" }, "1": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "4": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "5": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "6": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from anrede" }, "1": { "Ident": "StiPostgreSQLSource", "Name": "anruf_auswertung", "Alias": "anruf_auswertung", "Key": "b29622cde8134070bb2a677d6fe87d9c", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "anrufe_id", "Index": -1, "NameInSource": "anrufe_id", "Alias": "anrufe_id", "Type": "System.Int64" }, "2": { "Name": "verifiziert", "Index": -1, "NameInSource": "verifiziert", "Alias": "verifiziert", "Type": "System.String" }, "3": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "4": { "Name": "ansprechpartner_id", "Index": -1, "NameInSource": "ansprechpartner_id", "Alias": "ansprechpartner_id", "Type": "System.Int64" }, "5": { "Name": "anschrift_id", "Index": -1, "NameInSource": "anschrift_id", "Alias": "anschrift_id", "Type": "System.Int64" }, "6": { "Name": "adresse_id", "Index": -1, "NameInSource": "adresse_id", "Alias": "adresse_id", "Type": "System.Int64" }, "7": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "8": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "9": { "Name": "nummer", "Index": -1, "NameInSource": "nummer", "Alias": "nummer", "Type": "System.String" }, "10": { "Name": "vorname", "Index": -1, "NameInSource": "vorname", "Alias": "vorname", "Type": "System.String" }, "11": { "Name": "nachname", "Index": -1, "NameInSource": "nachname", "Alias": "nachname", "Type": "System.String" }, "12": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from anruf_auswertung" }, "2": { "Ident": "StiPostgreSQLSource", "Name": "anrufe", "Alias": "anrufe", "Key": "337b6052d82843bf86b981b9ac6b208a", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "anrufer", "Index": -1, "NameInSource": "anrufer", "Alias": "anrufer", "Type": "System.String" }, "2": { "Name": "angerufener", "Index": -1, "NameInSource": "angerufener", "Alias": "angerufener", "Type": "System.String" }, "3": { "Name": "verbunden", "Index": -1, "NameInSource": "verbunden", "Alias": "verbunden", "Type": "System.String" }, "4": { "Name": "dauer", "Index": -1, "NameInSource": "dauer", "Alias": "dauer", "Type": "System.Int64" }, "5": { "Name": "startzeit", "Index": -1, "NameInSource": "startzeit", "Alias": "startzeit", "Type": "System.DateTime" }, "6": { "Name": "endzeit", "Index": -1, "NameInSource": "endzeit", "Alias": "endzeit", "Type": "System.DateTime" }, "7": { "Name": "status", "Index": -1, "NameInSource": "status", "Alias": "status", "Type": "System.String" }, "8": { "Name": "gesamtdauer", "Index": -1, "NameInSource": "gesamtdauer", "Alias": "gesamtdauer", "Type": "System.Int64" }, "9": { "Name": "anrufbeantworter", "Index": -1, "NameInSource": "anrufbeantworter", "Alias": "anrufbeantworter", "Type": "System.String" }, "10": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "11": { "Name": "ticket_position_id", "Index": -1, "NameInSource": "ticket_position_id", "Alias": "ticket_position_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from anrufe" }, "3": { "Ident": "StiPostgreSQLSource", "Name": "calendar_sync_log", "Alias": "calendar_sync_log", "Key": "ba7ec0a8ffc04f33a90c8986ba0281f8", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "2": { "Name": "lastrun", "Index": -1, "NameInSource": "lastrun", "Alias": "lastrun", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from calendar_sync_log" }, "4": { "Ident": "StiPostgreSQLSource", "Name": "changelog", "Alias": "changelog", "Key": "8af9cf8ac98a463f8effe5ac8b0c7003", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "programmname", "Index": -1, "NameInSource": "programmname", "Alias": "programmname", "Type": "System.String" }, "2": { "Name": "version", "Index": -1, "NameInSource": "version", "Alias": "version", "Type": "System.String" }, "3": { "Name": "aenderung", "Index": -1, "NameInSource": "aenderung", "Alias": "aenderung", "Type": "System.String" }, "4": { "Name": "zeit", "Index": -1, "NameInSource": "zeit", "Alias": "zeit", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from changelog" }, "5": { "Ident": "StiPostgreSQLSource", "Name": "dokumente", "Alias": "dokumente", "Key": "320c150ea0924e4eb771bf5a21335458", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "datei_name", "Index": -1, "NameInSource": "datei_name", "Alias": "datei_name", "Type": "System.String" }, "2": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "3": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "4": { "Name": "wiedervorlage", "Index": -1, "NameInSource": "wiedervorlage", "Alias": "wiedervorlage", "Type": "System.DateTime" }, "5": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "6": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "7": { "Name": "version", "Index": -1, "NameInSource": "version", "Alias": "version", "Type": "System.Int64" }, "8": { "Name": "suchfeld", "Index": -1, "NameInSource": "suchfeld", "Alias": "suchfeld", "Type": "System.String" }, "9": { "Name": "wiederholung_tage", "Index": -1, "NameInSource": "wiederholung_tage", "Alias": "wiederholung_tage", "Type": "System.Int64" }, "10": { "Name": "wiederholung_monate", "Index": -1, "NameInSource": "wiederholung_monate", "Alias": "wiederholung_monate", "Type": "System.Int64" }, "11": { "Name": "wiederholung_jahre", "Index": -1, "NameInSource": "wiederholung_jahre", "Alias": "wiederholung_jahre", "Type": "System.Int64" }, "12": { "Name": "wiedervorlage_aktiv", "Index": -1, "NameInSource": "wiedervorlage_aktiv", "Alias": "wiedervorlage_aktiv", "Type": "System.String" }, "13": { "Name": "locked", "Index": -1, "NameInSource": "locked", "Alias": "locked", "Type": "System.Int64" }, "14": { "Name": "tmp_file", "Index": -1, "NameInSource": "tmp_file", "Alias": "tmp_file", "Type": "System.String" }, "15": { "Name": "convertto", "Index": -1, "NameInSource": "convertto", "Alias": "convertto", "Type": "System.String" }, "16": { "Name": "programme_id", "Index": -1, "NameInSource": "programme_id", "Alias": "programme_id", "Type": "System.Int64" }, "17": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from dokumente" }, "6": { "Ident": "StiPostgreSQLSource", "Name": "dokumente_access", "Alias": "dokumente_access", "Key": "f397800d150448f5b6262eeb170130b4", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "did", "Index": -1, "NameInSource": "did", "Alias": "did", "Type": "System.Int64" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "gid", "Index": -1, "NameInSource": "gid", "Alias": "gid", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from dokumente_access" }, "7": { "Ident": "StiPostgreSQLSource", "Name": "dokumente_daten", "Alias": "dokumente_daten", "Key": "c749ebc7c5e54b559889060dfcf3b339", "Columns": { "0": { "Name": "did", "Index": -1, "NameInSource": "did", "Alias": "did", "Type": "System.Int64" }, "1": { "Name": "vorschau_size", "Index": -1, "NameInSource": "vorschau_size", "Alias": "vorschau_size", "Type": "System.Int64" }, "2": { "Name": "vorschau", "Index": -1, "NameInSource": "vorschau", "Alias": "vorschau", "Type": "System.String" }, "3": { "Name": "file_size", "Index": -1, "NameInSource": "file_size", "Alias": "file_size", "Type": "System.Int64" }, "4": { "Name": "file", "Index": -1, "NameInSource": "file", "Alias": "file", "Type": "System.String" }, "5": { "Name": "version", "Index": -1, "NameInSource": "version", "Alias": "version", "Type": "System.Int64" }, "6": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "7": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "8": { "Name": "grund", "Index": -1, "NameInSource": "grund", "Alias": "grund", "Type": "System.String" }, "9": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from dokumente_daten" }, "8": { "Ident": "StiPostgreSQLSource", "Name": "dokumente_suchbegriff", "Alias": "dokumente_suchbegriff", "Key": "70d32385bcfe4962a1c4ea5771e11c01", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "suchbegriff", "Index": -1, "NameInSource": "suchbegriff", "Alias": "suchbegriff", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "4": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "5": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "6": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from dokumente_suchbegriff" }, "9": { "Ident": "StiPostgreSQLSource", "Name": "ereignisse", "Alias": "ereignisse", "Key": "d47f6bdbdbe044faa1c4fe347a189169", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "bezeichnung", "Index": -1, "NameInSource": "bezeichnung", "Alias": "bezeichnung", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "4": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "5": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "6": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from ereignisse" }, "10": { "Ident": "StiPostgreSQLSource", "Name": "erp_adresse", "Alias": "erp_adresse", "Key": "f35130b3c4b94e51abdfda2408c7ba16", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "7": { "Name": "suchbeg", "Index": -1, "NameInSource": "suchbeg", "Alias": "suchbeg", "Type": "System.String" }, "8": { "Name": "status", "Index": -1, "NameInSource": "status", "Alias": "status", "Type": "System.String" }, "9": { "Name": "branche", "Index": -1, "NameInSource": "branche", "Alias": "branche", "Type": "System.String" }, "10": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "11": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "12": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "13": { "Name": "info", "Index": -1, "NameInSource": "info", "Alias": "info", "Type": "System.String" }, "14": { "Name": "gspkz", "Index": -1, "NameInSource": "gspkz", "Alias": "gspkz", "Type": "System.String" }, "15": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_adresse" }, "11": { "Ident": "StiPostgreSQLSource", "Name": "erp_anschrift", "Alias": "erp_anschrift", "Key": "64aba2921492479b9d37a6b8c39d542c", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "ansnr", "Index": -1, "NameInSource": "ansnr", "Alias": "ansnr", "Type": "System.Int64" }, "8": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.Int64" }, "9": { "Name": "anrede", "Index": -1, "NameInSource": "anrede", "Alias": "anrede", "Type": "System.String" }, "10": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "11": { "Name": "landbez", "Index": -1, "NameInSource": "landbez", "Alias": "landbez", "Type": "System.String" }, "12": { "Name": "landkennz", "Index": -1, "NameInSource": "landkennz", "Alias": "landkennz", "Type": "System.String" }, "13": { "Name": "plz", "Index": -1, "NameInSource": "plz", "Alias": "plz", "Type": "System.String" }, "14": { "Name": "ort", "Index": -1, "NameInSource": "ort", "Alias": "ort", "Type": "System.String" }, "15": { "Name": "str", "Index": -1, "NameInSource": "str", "Alias": "str", "Type": "System.String" }, "16": { "Name": "postf", "Index": -1, "NameInSource": "postf", "Alias": "postf", "Type": "System.String" }, "17": { "Name": "pfort", "Index": -1, "NameInSource": "pfort", "Alias": "pfort", "Type": "System.String" }, "18": { "Name": "pfplz", "Index": -1, "NameInSource": "pfplz", "Alias": "pfplz", "Type": "System.String" }, "19": { "Name": "tel", "Index": -1, "NameInSource": "tel", "Alias": "tel", "Type": "System.String" }, "20": { "Name": "website", "Index": -1, "NameInSource": "website", "Alias": "website", "Type": "System.String" }, "21": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "22": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "23": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_anschrift" }, "12": { "Ident": "StiPostgreSQLSource", "Name": "erp_ansprechpartner", "Alias": "erp_ansprechpartner", "Key": "96388fb4c1314bf6adbd1100ecc872a7", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "id_str", "Index": -1, "NameInSource": "id_str", "Alias": "id_str", "Type": "System.String" }, "8": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "9": { "Name": "anr", "Index": -1, "NameInSource": "anr", "Alias": "anr", "Type": "System.String" }, "10": { "Name": "vorname", "Index": -1, "NameInSource": "vorname", "Alias": "vorname", "Type": "System.String" }, "11": { "Name": "nachname", "Index": -1, "NameInSource": "nachname", "Alias": "nachname", "Type": "System.String" }, "12": { "Name": "tel1", "Index": -1, "NameInSource": "tel1", "Alias": "tel1", "Type": "System.String" }, "13": { "Name": "tel2", "Index": -1, "NameInSource": "tel2", "Alias": "tel2", "Type": "System.String" }, "14": { "Name": "mtel", "Index": -1, "NameInSource": "mtel", "Alias": "mtel", "Type": "System.String" }, "15": { "Name": "fax", "Index": -1, "NameInSource": "fax", "Alias": "fax", "Type": "System.String" }, "16": { "Name": "email1", "Index": -1, "NameInSource": "email1", "Alias": "email1", "Type": "System.String" }, "17": { "Name": "email2", "Index": -1, "NameInSource": "email2", "Alias": "email2", "Type": "System.String" }, "18": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "19": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "20": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_ansprechpartner" }, "13": { "Ident": "StiPostgreSQLSource", "Name": "erp_artikel", "Alias": "erp_artikel", "Key": "1d1bccf27c8243e29b2a9b732cba6426", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "8": { "Name": "artart", "Index": -1, "NameInSource": "artart", "Alias": "artart", "Type": "System.String" }, "9": { "Name": "katalog", "Index": -1, "NameInSource": "katalog", "Alias": "katalog", "Type": "System.Int64" }, "10": { "Name": "suchbeg", "Index": -1, "NameInSource": "suchbeg", "Alias": "suchbeg", "Type": "System.String" }, "11": { "Name": "wgrnr", "Index": -1, "NameInSource": "wgrnr", "Alias": "wgrnr", "Type": "System.String" }, "12": { "Name": "wgrinfo", "Index": -1, "NameInSource": "wgrinfo", "Alias": "wgrinfo", "Type": "System.String" }, "13": { "Name": "kubez1", "Index": -1, "NameInSource": "kubez1", "Alias": "kubez1", "Type": "System.String" }, "14": { "Name": "bez1", "Index": -1, "NameInSource": "bez1", "Alias": "bez1", "Type": "System.String" }, "15": { "Name": "kubez2", "Index": -1, "NameInSource": "kubez2", "Alias": "kubez2", "Type": "System.String" }, "16": { "Name": "bez2", "Index": -1, "NameInSource": "bez2", "Alias": "bez2", "Type": "System.String" }, "17": { "Name": "kubez3", "Index": -1, "NameInSource": "kubez3", "Alias": "kubez3", "Type": "System.String" }, "18": { "Name": "bez3", "Index": -1, "NameInSource": "bez3", "Alias": "bez3", "Type": "System.String" }, "19": { "Name": "kubez4", "Index": -1, "NameInSource": "kubez4", "Alias": "kubez4", "Type": "System.String" }, "20": { "Name": "bez4", "Index": -1, "NameInSource": "bez4", "Alias": "bez4", "Type": "System.String" }, "21": { "Name": "vkanzahl", "Index": -1, "NameInSource": "vkanzahl", "Alias": "vkanzahl", "Type": "System.String" }, "22": { "Name": "vkeinheit", "Index": -1, "NameInSource": "vkeinheit", "Alias": "vkeinheit", "Type": "System.String" }, "23": { "Name": "stdpreis", "Index": -1, "NameInSource": "stdpreis", "Alias": "stdpreis", "Type": "System.String" }, "24": { "Name": "stdzuschlag", "Index": -1, "NameInSource": "stdzuschlag", "Alias": "stdzuschlag", "Type": "System.String" }, "25": { "Name": "stdpreis_nt", "Index": -1, "NameInSource": "stdpreis_nt", "Alias": "stdpreis_nt", "Type": "System.String" }, "26": { "Name": "stdpreis_bt", "Index": -1, "NameInSource": "stdpreis_bt", "Alias": "stdpreis_bt", "Type": "System.String" }, "27": { "Name": "stdpreis_l2", "Index": -1, "NameInSource": "stdpreis_l2", "Alias": "stdpreis_l2", "Type": "System.String" }, "28": { "Name": "preis_ltzaend", "Index": -1, "NameInSource": "preis_ltzaend", "Alias": "preis_ltzaend", "Type": "System.DateTime" }, "29": { "Name": "lagmge", "Index": -1, "NameInSource": "lagmge", "Alias": "lagmge", "Type": "System.String" }, "30": { "Name": "verfmge", "Index": -1, "NameInSource": "verfmge", "Alias": "verfmge", "Type": "System.String" }, "31": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "32": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "33": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_artikel" }, "14": { "Ident": "StiPostgreSQLSource", "Name": "erp_artikel_lieferanten", "Alias": "erp_artikel_lieferanten", "Key": "e510ea458b754d40be6963ebdd72afe7", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "2": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "3": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "4": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "5": { "Name": "ek0_bstnr", "Index": -1, "NameInSource": "ek0_bstnr", "Alias": "ek0_bstnr", "Type": "System.String" }, "6": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "7": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "8": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "9": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "10": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_artikel_lieferanten" }, "15": { "Ident": "StiPostgreSQLSource", "Name": "erp_artikel_stueckliste", "Alias": "erp_artikel_stueckliste", "Key": "ba9c49f2a9d54e6fab66798c15eacb56", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "2": { "Name": "slartnr", "Index": -1, "NameInSource": "slartnr", "Alias": "slartnr", "Type": "System.String" }, "3": { "Name": "zeilennr", "Index": -1, "NameInSource": "zeilennr", "Alias": "zeilennr", "Type": "System.Int64" }, "4": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "5": { "Name": "mge", "Index": -1, "NameInSource": "mge", "Alias": "mge", "Type": "System.String" }, "6": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "7": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "8": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_artikel_stueckliste" }, "16": { "Ident": "StiPostgreSQLSource", "Name": "erp_importer_log", "Alias": "erp_importer_log", "Key": "0420377d6594498b82e3d6a1e4090575", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "2": { "Name": "lastrun", "Index": -1, "NameInSource": "lastrun", "Alias": "lastrun", "Type": "System.DateTime" }, "3": { "Name": "projekte", "Index": -1, "NameInSource": "projekte", "Alias": "projekte", "Type": "System.DateTime" }, "4": { "Name": "adressen", "Index": -1, "NameInSource": "adressen", "Alias": "adressen", "Type": "System.DateTime" }, "5": { "Name": "anschriften", "Index": -1, "NameInSource": "anschriften", "Alias": "anschriften", "Type": "System.DateTime" }, "6": { "Name": "ansprechpartner", "Index": -1, "NameInSource": "ansprechpartner", "Alias": "ansprechpartner", "Type": "System.DateTime" }, "7": { "Name": "artikel", "Index": -1, "NameInSource": "artikel", "Alias": "artikel", "Type": "System.DateTime" }, "8": { "Name": "servicevertraege", "Index": -1, "NameInSource": "servicevertraege", "Alias": "servicevertraege", "Type": "System.DateTime" }, "9": { "Name": "telefonindex", "Index": -1, "NameInSource": "telefonindex", "Alias": "telefonindex", "Type": "System.DateTime" }, "10": { "Name": "vorgaenge", "Index": -1, "NameInSource": "vorgaenge", "Alias": "vorgaenge", "Type": "System.DateTime" }, "11": { "Name": "vorgangspositionen", "Index": -1, "NameInSource": "vorgangspositionen", "Alias": "vorgangspositionen", "Type": "System.DateTime" }, "12": { "Name": "lagerbuch", "Index": -1, "NameInSource": "lagerbuch", "Alias": "lagerbuch", "Type": "System.DateTime" }, "13": { "Name": "kalender", "Index": -1, "NameInSource": "kalender", "Alias": "kalender", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_importer_log" }, "17": { "Ident": "StiPostgreSQLSource", "Name": "erp_lagerbuch", "Alias": "erp_lagerbuch", "Key": "d4076d06f292444b947044e5431cd9c8", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "4": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "5": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "6": { "Name": "dat", "Index": -1, "NameInSource": "dat", "Alias": "dat", "Type": "System.DateTime" }, "7": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "8": { "Name": "serialnr", "Index": -1, "NameInSource": "serialnr", "Alias": "serialnr", "Type": "System.String" }, "9": { "Name": "belegnr", "Index": -1, "NameInSource": "belegnr", "Alias": "belegnr", "Type": "System.String" }, "10": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "11": { "Name": "prjnr", "Index": -1, "NameInSource": "prjnr", "Alias": "prjnr", "Type": "System.String" }, "12": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "13": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "14": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_lagerbuch" }, "18": { "Ident": "StiPostgreSQLSource", "Name": "erp_mastertelefonindex", "Alias": "erp_mastertelefonindex", "Key": "5052263f48c14a72b5df339aea00add3", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "2": { "Name": "vorname", "Index": -1, "NameInSource": "vorname", "Alias": "vorname", "Type": "System.String" }, "3": { "Name": "nachname", "Index": -1, "NameInSource": "nachname", "Alias": "nachname", "Type": "System.String" }, "4": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "5": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "6": { "Name": "nummer", "Index": -1, "NameInSource": "nummer", "Alias": "nummer", "Type": "System.String" }, "7": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "8": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_mastertelefonindex" }, "19": { "Ident": "StiPostgreSQLSource", "Name": "erp_projekte", "Alias": "erp_projekte", "Key": "b04f5a238a3d49f4a389fb55e457a1ad", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "prjnr", "Index": -1, "NameInSource": "prjnr", "Alias": "prjnr", "Type": "System.String" }, "8": { "Name": "bez", "Index": -1, "NameInSource": "bez", "Alias": "bez", "Type": "System.String" }, "9": { "Name": "info", "Index": -1, "NameInSource": "info", "Alias": "info", "Type": "System.String" }, "10": { "Name": "suchbeg", "Index": -1, "NameInSource": "suchbeg", "Alias": "suchbeg", "Type": "System.String" }, "11": { "Name": "prjsts", "Index": -1, "NameInSource": "prjsts", "Alias": "prjsts", "Type": "System.Int64" }, "12": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "13": { "Name": "erledigtkz", "Index": -1, "NameInSource": "erledigtkz", "Alias": "erledigtkz", "Type": "System.String" }, "14": { "Name": "wichtig", "Index": -1, "NameInSource": "wichtig", "Alias": "wichtig", "Type": "System.Int64" }, "15": { "Name": "prio", "Index": -1, "NameInSource": "prio", "Alias": "prio", "Type": "System.Int64" }, "16": { "Name": "gspkz", "Index": -1, "NameInSource": "gspkz", "Alias": "gspkz", "Type": "System.String" }, "17": { "Name": "gspinfo", "Index": -1, "NameInSource": "gspinfo", "Alias": "gspinfo", "Type": "System.String" }, "18": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "19": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "20": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_projekte" }, "20": { "Ident": "StiPostgreSQLSource", "Name": "erp_servicevertrag", "Alias": "erp_servicevertrag", "Key": "baf20896a6394c0a97230a442098cfe2", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.Int64" }, "8": { "Name": "prjnr", "Index": -1, "NameInSource": "prjnr", "Alias": "prjnr", "Type": "System.String" }, "9": { "Name": "bez", "Index": -1, "NameInSource": "bez", "Alias": "bez", "Type": "System.String" }, "10": { "Name": "standort", "Index": -1, "NameInSource": "standort", "Alias": "standort", "Type": "System.String" }, "11": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "12": { "Name": "artinfo", "Index": -1, "NameInSource": "artinfo", "Alias": "artinfo", "Type": "System.String" }, "13": { "Name": "startdat", "Index": -1, "NameInSource": "startdat", "Alias": "startdat", "Type": "System.DateTime" }, "14": { "Name": "enddat", "Index": -1, "NameInSource": "enddat", "Alias": "enddat", "Type": "System.DateTime" }, "15": { "Name": "vorenddat", "Index": -1, "NameInSource": "vorenddat", "Alias": "vorenddat", "Type": "System.DateTime" }, "16": { "Name": "istgek", "Index": -1, "NameInSource": "istgek", "Alias": "istgek", "Type": "System.String" }, "17": { "Name": "istaktiv", "Index": -1, "NameInSource": "istaktiv", "Alias": "istaktiv", "Type": "System.String" }, "18": { "Name": "info", "Index": -1, "NameInSource": "info", "Alias": "info", "Type": "System.String" }, "19": { "Name": "seriennr", "Index": -1, "NameInSource": "seriennr", "Alias": "seriennr", "Type": "System.String" }, "20": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "21": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "22": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_servicevertrag" }, "21": { "Ident": "StiPostgreSQLSource", "Name": "erp_telefonindex", "Alias": "erp_telefonindex", "Key": "526c93788fec4f188f1e538bb28495f3", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "nummer", "Index": -1, "NameInSource": "nummer", "Alias": "nummer", "Type": "System.String" }, "2": { "Name": "ansprechpartner_id", "Index": -1, "NameInSource": "ansprechpartner_id", "Alias": "ansprechpartner_id", "Type": "System.Int64" }, "3": { "Name": "anschrift_id", "Index": -1, "NameInSource": "anschrift_id", "Alias": "anschrift_id", "Type": "System.Int64" }, "4": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "5": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_telefonindex" }, "22": { "Ident": "StiPostgreSQLSource", "Name": "erp_vorgang", "Alias": "erp_vorgang", "Key": "6aa8721e88544baf9cd796527b80e553", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "art", "Index": -1, "NameInSource": "art", "Alias": "art", "Type": "System.Int64" }, "8": { "Name": "belegnr", "Index": -1, "NameInSource": "belegnr", "Alias": "belegnr", "Type": "System.String" }, "9": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "10": { "Name": "prjnr", "Index": -1, "NameInSource": "prjnr", "Alias": "prjnr", "Type": "System.String" }, "11": { "Name": "bez", "Index": -1, "NameInSource": "bez", "Alias": "bez", "Type": "System.String" }, "12": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "13": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "14": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_vorgang" }, "23": { "Ident": "StiPostgreSQLSource", "Name": "erp_vorgang_position", "Alias": "erp_vorgang_position", "Key": "ffd2b179716b4dc29b5e730ab3d418ac", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "superid", "Index": -1, "NameInSource": "superid", "Alias": "superid", "Type": "System.Int64" }, "7": { "Name": "servicevertrag_id", "Index": -1, "NameInSource": "servicevertrag_id", "Alias": "servicevertrag_id", "Type": "System.Int64" }, "8": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "9": { "Name": "mge", "Index": -1, "NameInSource": "mge", "Alias": "mge", "Type": "System.String" }, "10": { "Name": "unit", "Index": -1, "NameInSource": "unit", "Alias": "unit", "Type": "System.String" }, "11": { "Name": "posnr", "Index": -1, "NameInSource": "posnr", "Alias": "posnr", "Type": "System.Int64" }, "12": { "Name": "belegnr", "Index": -1, "NameInSource": "belegnr", "Alias": "belegnr", "Type": "System.String" }, "13": { "Name": "bez", "Index": -1, "NameInSource": "bez", "Alias": "bez", "Type": "System.String" }, "14": { "Name": "selektion", "Index": -1, "NameInSource": "selektion", "Alias": "selektion", "Type": "System.String" }, "15": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "16": { "Name": "clear_flag", "Index": -1, "NameInSource": "clear_flag", "Alias": "clear_flag", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from erp_vorgang_position" }, "24": { "Ident": "StiPostgreSQLSource", "Name": "faq", "Alias": "faq", "Key": "6749616cc9884c5fa0a89cb95a51f051", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "2": { "Name": "question", "Index": -1, "NameInSource": "question", "Alias": "question", "Type": "System.String" }, "3": { "Name": "answer", "Index": -1, "NameInSource": "answer", "Alias": "answer", "Type": "System.String" }, "4": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "5": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "6": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "7": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "8": { "Name": "question_short", "Index": -1, "NameInSource": "question_short", "Alias": "question_short", "Type": "System.String" }, "9": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "10": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from faq" }, "25": { "Ident": "StiPostgreSQLSource", "Name": "fernwartung", "Alias": "fernwartung", "Key": "63c0209c30be4cda873552f3d94f0c96", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "2": { "Name": "ticket_position_id", "Index": -1, "NameInSource": "ticket_position_id", "Alias": "ticket_position_id", "Type": "System.Int64" }, "3": { "Name": "supporter", "Index": -1, "NameInSource": "supporter", "Alias": "supporter", "Type": "System.String" }, "4": { "Name": "client", "Index": -1, "NameInSource": "client", "Alias": "client", "Type": "System.String" }, "5": { "Name": "startzeit", "Index": -1, "NameInSource": "startzeit", "Alias": "startzeit", "Type": "System.DateTime" }, "6": { "Name": "dauer", "Index": -1, "NameInSource": "dauer", "Alias": "dauer", "Type": "System.Int64" }, "7": { "Name": "beschreibung", "Index": -1, "NameInSource": "beschreibung", "Alias": "beschreibung", "Type": "System.String" }, "8": { "Name": "sessionid", "Index": -1, "NameInSource": "sessionid", "Alias": "sessionid", "Type": "System.String" }, "9": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "10": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "11": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "12": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "13": { "Name": "parameter", "Index": -1, "NameInSource": "parameter", "Alias": "parameter", "Type": "System.String" }, "14": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "15": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "16": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "17": { "Name": "fuid", "Index": -1, "NameInSource": "fuid", "Alias": "fuid", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from fernwartung" }, "26": { "Ident": "StiPostgreSQLSource", "Name": "gruppe", "Alias": "gruppe", "Key": "f6ea7fe3d23a491a8d28f640bade931a", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "gruppe", "Index": -1, "NameInSource": "gruppe", "Alias": "gruppe", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "4": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "5": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "6": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from gruppe" }, "27": { "Ident": "StiPostgreSQLSource", "Name": "gruppenmitglieder", "Alias": "gruppenmitglieder", "Key": "1bbaefc611e44a05812c5d1d8903d7c4", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "gid", "Index": -1, "NameInSource": "gid", "Alias": "gid", "Type": "System.Int64" }, "2": { "Name": "users_id", "Index": -1, "NameInSource": "users_id", "Alias": "users_id", "Type": "System.Int64" }, "3": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "4": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "5": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "6": { "Name": "aenderungsdatum", "Index": -1, "NameInSource": "aenderungsdatum", "Alias": "aenderungsdatum", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from gruppenmitglieder" }, "28": { "Ident": "StiPostgreSQLSource", "Name": "kategorie", "Alias": "kategorie", "Key": "a1df2a778e30497ca1602106ab31de53", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from kategorie" }, "29": { "Ident": "StiPostgreSQLSource", "Name": "keepalive_programme", "Alias": "keepalive_programme", "Key": "9fbd75996d5144048586ea568ca1c5a6", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "programm", "Index": -1, "NameInSource": "programm", "Alias": "programm", "Type": "System.String" }, "2": { "Name": "port", "Index": -1, "NameInSource": "port", "Alias": "port", "Type": "System.Int64" }, "3": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "4": { "Name": "machine", "Index": -1, "NameInSource": "machine", "Alias": "machine", "Type": "System.String" }, "5": { "Name": "update", "Index": -1, "NameInSource": "update", "Alias": "update", "Type": "System.DateTime" }, "6": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "7": { "Name": "instanz", "Index": -1, "NameInSource": "instanz", "Alias": "instanz", "Type": "System.Int64" }, "8": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "9": { "Name": "parameter", "Index": -1, "NameInSource": "parameter", "Alias": "parameter", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from keepalive_programme" }, "30": { "Ident": "StiPostgreSQLSource", "Name": "logging", "Alias": "logging", "Key": "e05ead89d4e14c84978ead139e313db0", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "ereignis_id", "Index": -1, "NameInSource": "ereignis_id", "Alias": "ereignis_id", "Type": "System.Int64" }, "2": { "Name": "bezeichnung", "Index": -1, "NameInSource": "bezeichnung", "Alias": "bezeichnung", "Type": "System.String" }, "3": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "4": { "Name": "timestamp", "Index": -1, "NameInSource": "timestamp", "Alias": "timestamp", "Type": "System.DateTime" }, "5": { "Name": "ip", "Index": -1, "NameInSource": "ip", "Alias": "ip", "Type": "System.String" }, "6": { "Name": "programm", "Index": -1, "NameInSource": "programm", "Alias": "programm", "Type": "System.String" }, "7": { "Name": "datei", "Index": -1, "NameInSource": "datei", "Alias": "datei", "Type": "System.String" }, "8": { "Name": "version", "Index": -1, "NameInSource": "version", "Alias": "version", "Type": "System.String" }, "9": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "10": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "11": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "12": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "13": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from logging" }, "31": { "Ident": "StiPostgreSQLSource", "Name": "mandant", "Alias": "mandant", "Key": "30ff144dcc6c42de93ce59e1cc2c5172", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "bezeichnung", "Index": -1, "NameInSource": "bezeichnung", "Alias": "bezeichnung", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "4": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "5": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "6": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "7": { "Name": "zeitpunkt", "Index": -1, "NameInSource": "zeitpunkt", "Alias": "zeitpunkt", "Type": "System.DateTime" }, "8": { "Name": "farbe", "Index": -1, "NameInSource": "farbe", "Alias": "farbe", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from mandant" }, "32": { "Ident": "StiPostgreSQLSource", "Name": "mandant_config", "Alias": "mandant_config", "Key": "64abe6b1afa444e6b4efcc89fcf35478", "Columns": { "0": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "1": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "4": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "5": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "6": { "Name": "microtech_id", "Index": -1, "NameInSource": "microtech_id", "Alias": "microtech_id", "Type": "System.String" }, "7": { "Name": "costumer_roundings_column", "Index": -1, "NameInSource": "costumer_roundings_column", "Alias": "costumer_roundings_column", "Type": "System.String" }, "8": { "Name": "sync_with_microtech", "Index": -1, "NameInSource": "sync_with_microtech", "Alias": "sync_with_microtech", "Type": "System.String" }, "9": { "Name": "token", "Index": -1, "NameInSource": "token", "Alias": "token", "Type": "System.String" }, "10": { "Name": "default_time_article", "Index": -1, "NameInSource": "default_time_article", "Alias": "default_time_article", "Type": "System.String" }, "11": { "Name": "sync_calendar_with_microtech", "Index": -1, "NameInSource": "sync_calendar_with_microtech", "Alias": "sync_calendar_with_microtech", "Type": "System.String" }, "12": { "Name": "kostenstelle_nr", "Index": -1, "NameInSource": "kostenstelle_nr", "Alias": "kostenstelle_nr", "Type": "System.String" }, "13": { "Name": "ist_abrechnungsfaehig", "Index": -1, "NameInSource": "ist_abrechnungsfaehig", "Alias": "ist_abrechnungsfaehig", "Type": "System.String" }, "14": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "15": { "Name": "ist_entwicklung", "Index": -1, "NameInSource": "ist_entwicklung", "Alias": "ist_entwicklung", "Type": "System.String" }, "16": { "Name": "microtech_name", "Index": -1, "NameInSource": "microtech_name", "Alias": "microtech_name", "Type": "System.String" }, "17": { "Name": "microtech_username", "Index": -1, "NameInSource": "microtech_username", "Alias": "microtech_username", "Type": "System.String" }, "18": { "Name": "microtech_password", "Index": -1, "NameInSource": "microtech_password", "Alias": "microtech_password", "Type": "System.String" }, "19": { "Name": "rounding_guideline", "Index": -1, "NameInSource": "rounding_guideline", "Alias": "rounding_guideline", "Type": "System.Int64" }, "20": { "Name": "windows_login", "Index": -1, "NameInSource": "windows_login", "Alias": "windows_login", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from mandant_config" }, "33": { "Ident": "StiPostgreSQLSource", "Name": "mandant_config_map", "Alias": "mandant_config_map", "Key": "dec05632e2804f699c645742c9f2b8f8", "Columns": { "0": { "Name": "mandant_src", "Index": -1, "NameInSource": "mandant_src", "Alias": "mandant_src", "Type": "System.Int64" }, "1": { "Name": "mandant_dest", "Index": -1, "NameInSource": "mandant_dest", "Alias": "mandant_dest", "Type": "System.Int64" }, "2": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from mandant_config_map" }, "34": { "Ident": "StiPostgreSQLSource", "Name": "message_channel", "Alias": "message_channel", "Key": "29f9340204984084a0838df40b8551ae", "Columns": { "0": { "Name": "template", "Index": -1, "NameInSource": "template", "Alias": "template", "Type": "System.String" }, "1": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "2": { "Name": "is_enabled", "Index": -1, "NameInSource": "is_enabled", "Alias": "is_enabled", "Type": "System.String" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "type", "Index": -1, "NameInSource": "type", "Alias": "type", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from message_channel" }, "35": { "Ident": "StiPostgreSQLSource", "Name": "message_content_template", "Alias": "message_content_template", "Key": "be515ce2966c4bfdaaf8e502c697a3ea", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "2": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "3": { "Name": "template", "Index": -1, "NameInSource": "template", "Alias": "template", "Type": "System.String" }, "4": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from message_content_template" }, "36": { "Ident": "StiPostgreSQLSource", "Name": "message_log", "Alias": "message_log", "Key": "1bc82a0139f044eb89addc85fd95c425", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "message_id", "Index": -1, "NameInSource": "message_id", "Alias": "message_id", "Type": "System.Int64" }, "2": { "Name": "successful", "Index": -1, "NameInSource": "successful", "Alias": "successful", "Type": "System.String" }, "3": { "Name": "error_info", "Index": -1, "NameInSource": "error_info", "Alias": "error_info", "Type": "System.String" }, "4": { "Name": "timestamp", "Index": -1, "NameInSource": "timestamp", "Alias": "timestamp", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from message_log" }, "37": { "Ident": "StiPostgreSQLSource", "Name": "message_queue", "Alias": "message_queue", "Key": "26011aeff3fd47d09f5084509d7dd523", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "template_id", "Index": -1, "NameInSource": "template_id", "Alias": "template_id", "Type": "System.Int64" }, "2": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "3": { "Name": "receiver_info", "Index": -1, "NameInSource": "receiver_info", "Alias": "receiver_info", "Type": "System.String" }, "4": { "Name": "content", "Index": -1, "NameInSource": "content", "Alias": "content", "Type": "System.String" }, "5": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "6": { "Name": "is_handled", "Index": -1, "NameInSource": "is_handled", "Alias": "is_handled", "Type": "System.String" }, "7": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "8": { "Name": "timestamp", "Index": -1, "NameInSource": "timestamp", "Alias": "timestamp", "Type": "System.DateTime" }, "9": { "Name": "channel_type", "Index": -1, "NameInSource": "channel_type", "Alias": "channel_type", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from message_queue" }, "38": { "Ident": "StiPostgreSQLSource", "Name": "notification_queue", "Alias": "notification_queue", "Key": "dc7144304fbb4d1d8f7e15ad7382db5d", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "notification_type_id", "Index": -1, "NameInSource": "notification_type_id", "Alias": "notification_type_id", "Type": "System.Int64" }, "2": { "Name": "fields", "Index": -1, "NameInSource": "fields", "Alias": "fields", "Type": "System.String" }, "3": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "4": { "Name": "timestamp", "Index": -1, "NameInSource": "timestamp", "Alias": "timestamp", "Type": "System.DateTime" }, "5": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "6": { "Name": "is_intern", "Index": -1, "NameInSource": "is_intern", "Alias": "is_intern", "Type": "System.String" }, "7": { "Name": "reciever_id", "Index": -1, "NameInSource": "reciever_id", "Alias": "reciever_id", "Type": "System.Int64" }, "8": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "9": { "Name": "is_sent", "Index": -1, "NameInSource": "is_sent", "Alias": "is_sent", "Type": "System.String" }, "10": { "Name": "is_failed", "Index": -1, "NameInSource": "is_failed", "Alias": "is_failed", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from notification_queue" }, "39": { "Ident": "StiPostgreSQLSource", "Name": "notification_type", "Alias": "notification_type", "Key": "947ced4b1cca4515bf46078fd2c2e666", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "title", "Index": -1, "NameInSource": "title", "Alias": "title", "Type": "System.String" }, "2": { "Name": "body", "Index": -1, "NameInSource": "body", "Alias": "body", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from notification_type" }, "40": { "Ident": "StiPostgreSQLSource", "Name": "preference_audit", "Alias": "preference_audit", "Key": "a683d19bd1d94dd6baed22f266f2274e", "Columns": { "0": { "Name": "operation", "Index": -1, "NameInSource": "operation", "Alias": "operation", "Type": "System.String" }, "1": { "Name": "stamp", "Index": -1, "NameInSource": "stamp", "Alias": "stamp", "Type": "System.DateTime" }, "2": { "Name": "userid", "Index": -1, "NameInSource": "userid", "Alias": "userid", "Type": "System.String" }, "3": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "4": { "Name": "data", "Index": -1, "NameInSource": "data", "Alias": "data", "Type": "System.String" }, "5": { "Name": "client", "Index": -1, "NameInSource": "client", "Alias": "client", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from preference_audit" }, "41": { "Ident": "StiPostgreSQLSource", "Name": "preferences", "Alias": "preferences", "Key": "562940628aa04a398ffc11ee23ddb2cf", "Columns": { "0": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "1": { "Name": "data", "Index": -1, "NameInSource": "data", "Alias": "data", "Type": "System.String" }, "2": { "Name": "zeit", "Index": -1, "NameInSource": "zeit", "Alias": "zeit", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from preferences" }, "42": { "Ident": "StiPostgreSQLSource", "Name": "private_dictionary", "Alias": "private_dictionary", "Key": "62e431993ea24a378d75e9fc27b55cf2", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "2": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "wort", "Index": -1, "NameInSource": "wort", "Alias": "wort", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from private_dictionary" }, "43": { "Ident": "StiPostgreSQLSource", "Name": "programme", "Alias": "programme", "Key": "9ff45b32ff90480a992c26ef35d5efa1", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "programm", "Index": -1, "NameInSource": "programm", "Alias": "programm", "Type": "System.String" }, "2": { "Name": "bezeichnung", "Index": -1, "NameInSource": "bezeichnung", "Alias": "bezeichnung", "Type": "System.String" }, "3": { "Name": "parameter", "Index": -1, "NameInSource": "parameter", "Alias": "parameter", "Type": "System.String" }, "4": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "5": { "Name": "ebene", "Index": -1, "NameInSource": "ebene", "Alias": "ebene", "Type": "System.Int64" }, "6": { "Name": "ausfuehrbar", "Index": -1, "NameInSource": "ausfuehrbar", "Alias": "ausfuehrbar", "Type": "System.String" }, "7": { "Name": "funktion", "Index": -1, "NameInSource": "funktion", "Alias": "funktion", "Type": "System.String" }, "8": { "Name": "sichtbar", "Index": -1, "NameInSource": "sichtbar", "Alias": "sichtbar", "Type": "System.String" }, "9": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "10": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "11": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "12": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from programme" }, "44": { "Ident": "StiPostgreSQLSource", "Name": "report", "Alias": "report", "Key": "9e2f98d14c944f6d8d1d4dacb94f8d54", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "data", "Index": -1, "NameInSource": "data", "Alias": "data", "Type": "System.String" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "5": { "Name": "category_id", "Index": -1, "NameInSource": "category_id", "Alias": "category_id", "Type": "System.Int64" }, "6": { "Name": "enabled", "Index": -1, "NameInSource": "enabled", "Alias": "enabled", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from report" }, "45": { "Ident": "StiPostgreSQLSource", "Name": "report_category", "Alias": "report_category", "Key": "6cdc55a7f7714a9f954fadeebc09bcb2", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "parent_id", "Index": -1, "NameInSource": "parent_id", "Alias": "parent_id", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "5": { "Name": "is_default", "Index": -1, "NameInSource": "is_default", "Alias": "is_default", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from report_category" }, "46": { "Ident": "StiPostgreSQLSource", "Name": "report_generic", "Alias": "report_generic", "Key": "70b83d593b914e2eae8e0cfa3dea9240", "Columns": { "0": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "1": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "4": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "5": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "6": { "Name": "suchbegriff", "Index": -1, "NameInSource": "suchbegriff", "Alias": "suchbegriff", "Type": "System.String" }, "7": { "Name": "beschreibung", "Index": -1, "NameInSource": "beschreibung", "Alias": "beschreibung", "Type": "System.String" }, "8": { "Name": "sql_1", "Index": -1, "NameInSource": "sql_1", "Alias": "sql_1", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from report_generic" }, "47": { "Ident": "StiPostgreSQLSource", "Name": "report_permission", "Alias": "report_permission", "Key": "7f70ad965e264e6d9d4d57655ae16e80", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "report_id", "Index": -1, "NameInSource": "report_id", "Alias": "report_id", "Type": "System.Int64" }, "2": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "3": { "Name": "group_id", "Index": -1, "NameInSource": "group_id", "Alias": "group_id", "Type": "System.Int64" }, "4": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from report_permission" }, "48": { "Ident": "StiPostgreSQLSource", "Name": "sessions", "Alias": "sessions", "Key": "436f429888624448b35b51ef4615265a", "Columns": { "0": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "1": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "2": { "Name": "time", "Index": -1, "NameInSource": "time", "Alias": "time", "Type": "System.DateTime" }, "3": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "4": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "5": { "Name": "ip", "Index": -1, "NameInSource": "ip", "Alias": "ip", "Type": "System.String" }, "6": { "Name": "inifile", "Index": -1, "NameInSource": "inifile", "Alias": "inifile", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from sessions" }, "49": { "Ident": "StiPostgreSQLSource", "Name": "stopwatch_presets", "Alias": "stopwatch_presets", "Key": "af0713368c0246dfb86dd91b51334eaa", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "2": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "3": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "4": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "5": { "Name": "header", "Index": -1, "NameInSource": "header", "Alias": "header", "Type": "System.String" }, "6": { "Name": "body", "Index": -1, "NameInSource": "body", "Alias": "body", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from stopwatch_presets" }, "50": { "Ident": "StiPostgreSQLSource", "Name": "systeme", "Alias": "systeme", "Key": "64f3e0bc95ea40a79aecaa5e3e7f54b9", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "1": { "Name": "computername", "Index": -1, "NameInSource": "computername", "Alias": "computername", "Type": "System.String" }, "2": { "Name": "adrnr", "Index": -1, "NameInSource": "adrnr", "Alias": "adrnr", "Type": "System.String" }, "3": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "4": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "5": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "6": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "7": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "8": { "Name": "pcvisit_id", "Index": -1, "NameInSource": "pcvisit_id", "Alias": "pcvisit_id", "Type": "System.String" }, "9": { "Name": "machinename", "Index": -1, "NameInSource": "machinename", "Alias": "machinename", "Type": "System.String" }, "10": { "Name": "osname", "Index": -1, "NameInSource": "osname", "Alias": "osname", "Type": "System.String" }, "11": { "Name": "osversion", "Index": -1, "NameInSource": "osversion", "Alias": "osversion", "Type": "System.String" }, "12": { "Name": "isserver", "Index": -1, "NameInSource": "isserver", "Alias": "isserver", "Type": "System.String" }, "13": { "Name": "isvm", "Index": -1, "NameInSource": "isvm", "Alias": "isvm", "Type": "System.String" }, "14": { "Name": "domain", "Index": -1, "NameInSource": "domain", "Alias": "domain", "Type": "System.String" }, "15": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "16": { "Name": "billing_artnr", "Index": -1, "NameInSource": "billing_artnr", "Alias": "billing_artnr", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from systeme" }, "51": { "Ident": "StiPostgreSQLSource", "Name": "systeme_agent", "Alias": "systeme_agent", "Key": "fd78cc2d4d0b483fa20247bed4c5f787", "Columns": { "0": { "Name": "systeme_id", "Index": -1, "NameInSource": "systeme_id", "Alias": "systeme_id", "Type": "System.String" }, "1": { "Name": "agent_id", "Index": -1, "NameInSource": "agent_id", "Alias": "agent_id", "Type": "System.String" }, "2": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "3": { "Name": "agent_type_id", "Index": -1, "NameInSource": "agent_type_id", "Alias": "agent_type_id", "Type": "System.String" }, "4": { "Name": "note", "Index": -1, "NameInSource": "note", "Alias": "note", "Type": "System.String" }, "5": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "6": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "7": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "8": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "9": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "10": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "11": { "Name": "ts_servicevertrag_superid", "Index": -1, "NameInSource": "ts_servicevertrag_superid", "Alias": "ts_servicevertrag_superid", "Type": "System.Int64" }, "12": { "Name": "ts_artikel_artnr", "Index": -1, "NameInSource": "ts_artikel_artnr", "Alias": "ts_artikel_artnr", "Type": "System.String" }, "13": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from systeme_agent" }, "52": { "Ident": "StiPostgreSQLSource", "Name": "systeme_agent_type", "Alias": "systeme_agent_type", "Key": "10ed6bda398a42318704b1c0a5cecccc", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "1": { "Name": "defaultname", "Index": -1, "NameInSource": "defaultname", "Alias": "defaultname", "Type": "System.String" }, "2": { "Name": "category", "Index": -1, "NameInSource": "category", "Alias": "category", "Type": "System.String" }, "3": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "4": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "7": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "8": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from systeme_agent_type" }, "53": { "Ident": "StiPostgreSQLSource", "Name": "textbaustein", "Alias": "textbaustein", "Key": "7922df516dfe4adb8046263d0a7ff9a2", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "titel", "Index": -1, "NameInSource": "titel", "Alias": "titel", "Type": "System.String" }, "5": { "Name": "inhalt", "Index": -1, "NameInSource": "inhalt", "Alias": "inhalt", "Type": "System.String" }, "6": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from textbaustein" }, "54": { "Ident": "StiPostgreSQLSource", "Name": "textbaustein_program_enabled", "Alias": "textbaustein_program_enabled", "Key": "e0b6505d06194c2baa95fd65f5d14a2f", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "programm_id", "Index": -1, "NameInSource": "programm_id", "Alias": "programm_id", "Type": "System.Int64" }, "5": { "Name": "enabled", "Index": -1, "NameInSource": "enabled", "Alias": "enabled", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from textbaustein_program_enabled" }, "55": { "Ident": "StiPostgreSQLSource", "Name": "textbaustein_programm", "Alias": "textbaustein_programm", "Key": "93d45025c8e245e1b5a5251c2f475f99", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "textbaustein_id", "Index": -1, "NameInSource": "textbaustein_id", "Alias": "textbaustein_id", "Type": "System.Int64" }, "5": { "Name": "programm_id", "Index": -1, "NameInSource": "programm_id", "Alias": "programm_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from textbaustein_programm" }, "56": { "Ident": "StiPostgreSQLSource", "Name": "textbaustein_variable", "Alias": "textbaustein_variable", "Key": "09b7b4408e554b2ebb5cc5b3992d2d5d", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "programm_id", "Index": -1, "NameInSource": "programm_id", "Alias": "programm_id", "Type": "System.Int64" }, "5": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "6": { "Name": "is_common", "Index": -1, "NameInSource": "is_common", "Alias": "is_common", "Type": "System.String" }, "7": { "Name": "beschreibung", "Index": -1, "NameInSource": "beschreibung", "Alias": "beschreibung", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from textbaustein_variable" }, "57": { "Ident": "StiPostgreSQLSource", "Name": "ticket", "Alias": "ticket", "Key": "93cb2065ea17461ca3177bde5e624d1a", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "2": { "Name": "anfrage", "Index": -1, "NameInSource": "anfrage", "Alias": "anfrage", "Type": "System.String" }, "3": { "Name": "taetigkeit", "Index": -1, "NameInSource": "taetigkeit", "Alias": "taetigkeit", "Type": "System.String" }, "4": { "Name": "kategorie_id", "Index": -1, "NameInSource": "kategorie_id", "Alias": "kategorie_id", "Type": "System.Int64" }, "5": { "Name": "input_type_id", "Index": -1, "NameInSource": "input_type_id", "Alias": "input_type_id", "Type": "System.Int64" }, "6": { "Name": "betreff", "Index": -1, "NameInSource": "betreff", "Alias": "betreff", "Type": "System.String" }, "7": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "8": { "Name": "state", "Index": -1, "NameInSource": "state", "Alias": "state", "Type": "System.Int64" }, "9": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "10": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "11": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "12": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "13": { "Name": "group_id", "Index": -1, "NameInSource": "group_id", "Alias": "group_id", "Type": "System.Int64" }, "14": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "15": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "16": { "Name": "kunde_id", "Index": -1, "NameInSource": "kunde_id", "Alias": "kunde_id", "Type": "System.String" }, "17": { "Name": "ansprechpartner_id", "Index": -1, "NameInSource": "ansprechpartner_id", "Alias": "ansprechpartner_id", "Type": "System.Int64" }, "18": { "Name": "projekt_id", "Index": -1, "NameInSource": "projekt_id", "Alias": "projekt_id", "Type": "System.String" }, "19": { "Name": "service_contract_id", "Index": -1, "NameInSource": "service_contract_id", "Alias": "service_contract_id", "Type": "System.Int64" }, "20": { "Name": "dauer", "Index": -1, "NameInSource": "dauer", "Alias": "dauer", "Type": "System.String" }, "21": { "Name": "kosten", "Index": -1, "NameInSource": "kosten", "Alias": "kosten", "Type": "System.String" }, "22": { "Name": "plan_starttermin", "Index": -1, "NameInSource": "plan_starttermin", "Alias": "plan_starttermin", "Type": "System.DateTime" }, "23": { "Name": "serialnr", "Index": -1, "NameInSource": "serialnr", "Alias": "serialnr", "Type": "System.String" }, "24": { "Name": "artikel_id", "Index": -1, "NameInSource": "artikel_id", "Alias": "artikel_id", "Type": "System.String" }, "25": { "Name": "bom_artnr", "Index": -1, "NameInSource": "bom_artnr", "Alias": "bom_artnr", "Type": "System.String" }, "26": { "Name": "bom_count", "Index": -1, "NameInSource": "bom_count", "Alias": "bom_count", "Type": "System.Int64" }, "27": { "Name": "vorgang_belegnr", "Index": -1, "NameInSource": "vorgang_belegnr", "Alias": "vorgang_belegnr", "Type": "System.String" }, "28": { "Name": "vorgang_posnr", "Index": -1, "NameInSource": "vorgang_posnr", "Alias": "vorgang_posnr", "Type": "System.Int64" }, "29": { "Name": "deadline", "Index": -1, "NameInSource": "deadline", "Alias": "deadline", "Type": "System.DateTime" }, "30": { "Name": "hat_deadline", "Index": -1, "NameInSource": "hat_deadline", "Alias": "hat_deadline", "Type": "System.String" }, "31": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "32": { "Name": "prioritaet", "Index": -1, "NameInSource": "prioritaet", "Alias": "prioritaet", "Type": "System.Int64" }, "33": { "Name": "abrechnung_freigabe", "Index": -1, "NameInSource": "abrechnung_freigabe", "Alias": "abrechnung_freigabe", "Type": "System.String" }, "34": { "Name": "notification_to_contact", "Index": -1, "NameInSource": "notification_to_contact", "Alias": "notification_to_contact", "Type": "System.String" }, "35": { "Name": "message_email_1", "Index": -1, "NameInSource": "message_email_1", "Alias": "message_email_1", "Type": "System.String" }, "36": { "Name": "notification_to_creator", "Index": -1, "NameInSource": "notification_to_creator", "Alias": "notification_to_creator", "Type": "System.String" }, "37": { "Name": "message_email_1_cc", "Index": -1, "NameInSource": "message_email_1_cc", "Alias": "message_email_1_cc", "Type": "System.String" }, "38": { "Name": "message_email_1_bcc", "Index": -1, "NameInSource": "message_email_1_bcc", "Alias": "message_email_1_bcc", "Type": "System.String" }, "39": { "Name": "message_email_1_letzteaenderung", "Index": -1, "NameInSource": "message_email_1_letzteaenderung", "Alias": "message_email_1_letzteaenderung", "Type": "System.Int64" }, "40": { "Name": "message_status_ersteller_letzeaenderung", "Index": -1, "NameInSource": "message_status_ersteller_letzeaenderung", "Alias": "message_status_ersteller_letzeaenderung", "Type": "System.DateTime" }, "41": { "Name": "message_email_status_letzteaenderung", "Index": -1, "NameInSource": "message_email_status_letzteaenderung", "Alias": "message_email_status_letzteaenderung", "Type": "System.Int64" }, "42": { "Name": "scheduling_type", "Index": -1, "NameInSource": "scheduling_type", "Alias": "scheduling_type", "Type": "System.Int64" }, "43": { "Name": "erp_kalender_aenderungszeit", "Index": -1, "NameInSource": "erp_kalender_aenderungszeit", "Alias": "erp_kalender_aenderungszeit", "Type": "System.DateTime" }, "44": { "Name": "server_eye_container", "Index": -1, "NameInSource": "server_eye_container", "Alias": "server_eye_container", "Type": "System.String" }, "45": { "Name": "server_eye_agent", "Index": -1, "NameInSource": "server_eye_agent", "Alias": "server_eye_agent", "Type": "System.String" }, "46": { "Name": "server_eye_agent_hint", "Index": -1, "NameInSource": "server_eye_agent_hint", "Alias": "server_eye_agent_hint", "Type": "System.String" }, "47": { "Name": "server_eye_state_id", "Index": -1, "NameInSource": "server_eye_state_id", "Alias": "server_eye_state_id", "Type": "System.String" }, "48": { "Name": "device", "Index": -1, "NameInSource": "device", "Alias": "device", "Type": "System.String" }, "49": { "Name": "abrechnung_freigabe_abgeschlossen", "Index": -1, "NameInSource": "abrechnung_freigabe_abgeschlossen", "Alias": "abrechnung_freigabe_abgeschlossen", "Type": "System.String" }, "50": { "Name": "planned_length", "Index": -1, "NameInSource": "planned_length", "Alias": "planned_length", "Type": "System.String" }, "51": { "Name": "ist_gesperrt", "Index": -1, "NameInSource": "ist_gesperrt", "Alias": "ist_gesperrt", "Type": "System.String" }, "52": { "Name": "gesperrt_info", "Index": -1, "NameInSource": "gesperrt_info", "Alias": "gesperrt_info", "Type": "System.String" }, "53": { "Name": "gesperrt_benutzer", "Index": -1, "NameInSource": "gesperrt_benutzer", "Alias": "gesperrt_benutzer", "Type": "System.Int64" }, "54": { "Name": "gesperrt_zeitpunkt", "Index": -1, "NameInSource": "gesperrt_zeitpunkt", "Alias": "gesperrt_zeitpunkt", "Type": "System.DateTime" }, "55": { "Name": "priority", "Index": -1, "NameInSource": "priority", "Alias": "priority", "Type": "System.Int64" }, "56": { "Name": "in_creation", "Index": -1, "NameInSource": "in_creation", "Alias": "in_creation", "Type": "System.String" }, "57": { "Name": "pcvisitid", "Index": -1, "NameInSource": "pcvisitid", "Alias": "pcvisitid", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket" }, "58": { "Ident": "StiPostgreSQLSource", "Name": "ticket_access", "Alias": "ticket_access", "Key": "a772aaa8d7dc4bea945e9984670c7757", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "2": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "3": { "Name": "group_id", "Index": -1, "NameInSource": "group_id", "Alias": "group_id", "Type": "System.Int64" }, "4": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "5": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "6": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "7": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "8": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "9": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "10": { "Name": "creator_id", "Index": -1, "NameInSource": "creator_id", "Alias": "creator_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_access" }, "59": { "Ident": "StiPostgreSQLSource", "Name": "ticket_input_type", "Alias": "ticket_input_type", "Key": "bd64b6e56fdd4ed7b3d38ab5b484d11a", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_input_type" }, "60": { "Ident": "StiPostgreSQLSource", "Name": "ticket_length", "Alias": "ticket_length", "Key": "084f8a222b174d2d964d3c8760878d23", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "1": { "Name": "minutes", "Index": -1, "NameInSource": "minutes", "Alias": "minutes", "Type": "System.Int64" }, "2": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_length" }, "61": { "Ident": "StiPostgreSQLSource", "Name": "ticket_position", "Alias": "ticket_position", "Key": "0b88d0af4aaa43b78bb90616fb85aaec", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "5": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "6": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "7": { "Name": "begin_time", "Index": -1, "NameInSource": "begin_time", "Alias": "begin_time", "Type": "System.DateTime" }, "8": { "Name": "end_time", "Index": -1, "NameInSource": "end_time", "Alias": "end_time", "Type": "System.DateTime" }, "9": { "Name": "artnr", "Index": -1, "NameInSource": "artnr", "Alias": "artnr", "Type": "System.String" }, "10": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" }, "11": { "Name": "amount", "Index": -1, "NameInSource": "amount", "Alias": "amount", "Type": "System.String" }, "12": { "Name": "unit", "Index": -1, "NameInSource": "unit", "Alias": "unit", "Type": "System.String" }, "13": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "14": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "15": { "Name": "client_id", "Index": -1, "NameInSource": "client_id", "Alias": "client_id", "Type": "System.Int64" }, "16": { "Name": "rechnung_ist_abgerechnet", "Index": -1, "NameInSource": "rechnung_ist_abgerechnet", "Alias": "rechnung_ist_abgerechnet", "Type": "System.String" }, "17": { "Name": "rechnung_nr", "Index": -1, "NameInSource": "rechnung_nr", "Alias": "rechnung_nr", "Type": "System.String" }, "18": { "Name": "rechnung_position", "Index": -1, "NameInSource": "rechnung_position", "Alias": "rechnung_position", "Type": "System.Int64" }, "19": { "Name": "rechnung_intern_ist_abgerechnet", "Index": -1, "NameInSource": "rechnung_intern_ist_abgerechnet", "Alias": "rechnung_intern_ist_abgerechnet", "Type": "System.String" }, "20": { "Name": "rechnung_intern_nr", "Index": -1, "NameInSource": "rechnung_intern_nr", "Alias": "rechnung_intern_nr", "Type": "System.String" }, "21": { "Name": "rechnung_intern_position", "Index": -1, "NameInSource": "rechnung_intern_position", "Alias": "rechnung_intern_position", "Type": "System.Int64" }, "22": { "Name": "is_intern", "Index": -1, "NameInSource": "is_intern", "Alias": "is_intern", "Type": "System.String" }, "23": { "Name": "intern_source", "Index": -1, "NameInSource": "intern_source", "Alias": "intern_source", "Type": "System.Int64" }, "24": { "Name": "ersteller", "Index": -1, "NameInSource": "ersteller", "Alias": "ersteller", "Type": "System.String" }, "25": { "Name": "nicht_abrechnen", "Index": -1, "NameInSource": "nicht_abrechnen", "Alias": "nicht_abrechnen", "Type": "System.String" }, "26": { "Name": "textblock_id", "Index": -1, "NameInSource": "textblock_id", "Alias": "textblock_id", "Type": "System.Int64" }, "27": { "Name": "invoice_text", "Index": -1, "NameInSource": "invoice_text", "Alias": "invoice_text", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_position" }, "62": { "Ident": "StiPostgreSQLSource", "Name": "ticket_state", "Alias": "ticket_state", "Key": "939cdba670c642d6ab6c650282a9067d", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "4": { "Name": "needs_category", "Index": -1, "NameInSource": "needs_category", "Alias": "needs_category", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_state" }, "63": { "Ident": "StiPostgreSQLSource", "Name": "ticket_state_category", "Alias": "ticket_state_category", "Key": "e317aff3b5fd46b9923755742132a78c", "Columns": { "0": { "Name": "kategorie", "Index": -1, "NameInSource": "kategorie", "Alias": "kategorie", "Type": "System.String" }, "1": { "Name": "state_id", "Index": -1, "NameInSource": "state_id", "Alias": "state_id", "Type": "System.Int64" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_state_category" }, "64": { "Ident": "StiPostgreSQLSource", "Name": "ticket_state_history", "Alias": "ticket_state_history", "Key": "5852dac2a4d742da803a68bc5d3b8a95", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "2": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "5": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "6": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "7": { "Name": "ticket_id", "Index": -1, "NameInSource": "ticket_id", "Alias": "ticket_id", "Type": "System.Int64" }, "8": { "Name": "ticket_state_id", "Index": -1, "NameInSource": "ticket_state_id", "Alias": "ticket_state_id", "Type": "System.Int64" }, "9": { "Name": "beschreibung", "Index": -1, "NameInSource": "beschreibung", "Alias": "beschreibung", "Type": "System.String" }, "10": { "Name": "ticketaenderung", "Index": -1, "NameInSource": "ticketaenderung", "Alias": "ticketaenderung", "Type": "System.DateTime" }, "11": { "Name": "category_id", "Index": -1, "NameInSource": "category_id", "Alias": "category_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from ticket_state_history" }, "65": { "Ident": "StiPostgreSQLSource", "Name": "time_entry", "Alias": "time_entry", "Key": "c3b06b9254714818b392c25a2932a641", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" }, "2": { "Name": "type", "Index": -1, "NameInSource": "type", "Alias": "type", "Type": "System.Int64" }, "3": { "Name": "message", "Index": -1, "NameInSource": "message", "Alias": "message", "Type": "System.String" }, "4": { "Name": "terminal_id", "Index": -1, "NameInSource": "terminal_id", "Alias": "terminal_id", "Type": "System.Int64" }, "5": { "Name": "timestamp", "Index": -1, "NameInSource": "timestamp", "Alias": "timestamp", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from time_entry" }, "66": { "Ident": "StiPostgreSQLSource", "Name": "titel", "Alias": "titel", "Key": "1cd5f12f776a40c9bcc1f83e91d83fba", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "titel", "Index": -1, "NameInSource": "titel", "Alias": "titel", "Type": "System.String" }, "2": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "3": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "4": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "5": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "6": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from titel" }, "67": { "Ident": "StiPostgreSQLSource", "Name": "user_config", "Alias": "user_config", "Key": "ec5f405675fb40e9848297f38652c812", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "users_id", "Index": -1, "NameInSource": "users_id", "Alias": "users_id", "Type": "System.Int64" }, "2": { "Name": "tapicallviewer", "Index": -1, "NameInSource": "tapicallviewer", "Alias": "tapicallviewer", "Type": "System.String" }, "3": { "Name": "amtskennziffer_ort", "Index": -1, "NameInSource": "amtskennziffer_ort", "Alias": "amtskennziffer_ort", "Type": "System.String" }, "4": { "Name": "amtskennziffer_fern", "Index": -1, "NameInSource": "amtskennziffer_fern", "Alias": "amtskennziffer_fern", "Type": "System.String" }, "5": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "6": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "7": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "8": { "Name": "udp_eingangsdispo", "Index": -1, "NameInSource": "udp_eingangsdispo", "Alias": "udp_eingangsdispo", "Type": "System.String" }, "9": { "Name": "udp_adressen", "Index": -1, "NameInSource": "udp_adressen", "Alias": "udp_adressen", "Type": "System.String" }, "10": { "Name": "scheduling_mode", "Index": -1, "NameInSource": "scheduling_mode", "Alias": "scheduling_mode", "Type": "System.String" }, "11": { "Name": "list_font_size", "Index": -1, "NameInSource": "list_font_size", "Alias": "list_font_size", "Type": "System.Int64" }, "12": { "Name": "microtech_user_id", "Index": -1, "NameInSource": "microtech_user_id", "Alias": "microtech_user_id", "Type": "System.Int64" }, "13": { "Name": "ssl", "Index": -1, "NameInSource": "ssl", "Alias": "ssl", "Type": "System.String" }, "14": { "Name": "syspass_username", "Index": -1, "NameInSource": "syspass_username", "Alias": "syspass_username", "Type": "System.String" }, "15": { "Name": "syspass_api_key", "Index": -1, "NameInSource": "syspass_api_key", "Alias": "syspass_api_key", "Type": "System.String" }, "16": { "Name": "timemaster_user_id", "Index": -1, "NameInSource": "timemaster_user_id", "Alias": "timemaster_user_id", "Type": "System.Int64" }, "17": { "Name": "last_opened_version", "Index": -1, "NameInSource": "last_opened_version", "Alias": "last_opened_version", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from user_config" }, "68": { "Ident": "StiPostgreSQLSource", "Name": "user_mandant", "Alias": "user_mandant", "Key": "feccf927c1844be491c69a07a114ef43", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "2": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "3": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "4": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "5": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.Int64" } }, "NameInSource": "TTS", "SqlCommand": "select * from user_mandant" }, "69": { "Ident": "StiPostgreSQLSource", "Name": "users", "Alias": "users", "Key": "9aaca1d850d84d5dab4e487acb985b91", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "password", "Index": -1, "NameInSource": "password", "Alias": "password", "Type": "System.String" }, "3": { "Name": "vorname", "Index": -1, "NameInSource": "vorname", "Alias": "vorname", "Type": "System.String" }, "4": { "Name": "nachname", "Index": -1, "NameInSource": "nachname", "Alias": "nachname", "Type": "System.String" }, "5": { "Name": "anrede", "Index": -1, "NameInSource": "anrede", "Alias": "anrede", "Type": "System.String" }, "6": { "Name": "titel", "Index": -1, "NameInSource": "titel", "Alias": "titel", "Type": "System.String" }, "7": { "Name": "strasse", "Index": -1, "NameInSource": "strasse", "Alias": "strasse", "Type": "System.String" }, "8": { "Name": "land", "Index": -1, "NameInSource": "land", "Alias": "land", "Type": "System.String" }, "9": { "Name": "plz", "Index": -1, "NameInSource": "plz", "Alias": "plz", "Type": "System.String" }, "10": { "Name": "ort", "Index": -1, "NameInSource": "ort", "Alias": "ort", "Type": "System.String" }, "11": { "Name": "telefon1", "Index": -1, "NameInSource": "telefon1", "Alias": "telefon1", "Type": "System.String" }, "12": { "Name": "telefon2", "Index": -1, "NameInSource": "telefon2", "Alias": "telefon2", "Type": "System.String" }, "13": { "Name": "telefon3", "Index": -1, "NameInSource": "telefon3", "Alias": "telefon3", "Type": "System.String" }, "14": { "Name": "telefonmobil", "Index": -1, "NameInSource": "telefonmobil", "Alias": "telefonmobil", "Type": "System.String" }, "15": { "Name": "telefax", "Index": -1, "NameInSource": "telefax", "Alias": "telefax", "Type": "System.String" }, "16": { "Name": "email1", "Index": -1, "NameInSource": "email1", "Alias": "email1", "Type": "System.String" }, "17": { "Name": "email2", "Index": -1, "NameInSource": "email2", "Alias": "email2", "Type": "System.String" }, "18": { "Name": "memo", "Index": -1, "NameInSource": "memo", "Alias": "memo", "Type": "System.String" }, "19": { "Name": "zugriff_erlaubt", "Index": -1, "NameInSource": "zugriff_erlaubt", "Alias": "zugriff_erlaubt", "Type": "System.String" }, "20": { "Name": "geschlecht", "Index": -1, "NameInSource": "geschlecht", "Alias": "geschlecht", "Type": "System.String" }, "21": { "Name": "staat", "Index": -1, "NameInSource": "staat", "Alias": "staat", "Type": "System.String" }, "22": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "23": { "Name": "primary_gid", "Index": -1, "NameInSource": "primary_gid", "Alias": "primary_gid", "Type": "System.Int64" }, "24": { "Name": "mobil_pin", "Index": -1, "NameInSource": "mobil_pin", "Alias": "mobil_pin", "Type": "System.String" }, "25": { "Name": "caldav_url", "Index": -1, "NameInSource": "caldav_url", "Alias": "caldav_url", "Type": "System.String" }, "26": { "Name": "carddav_url", "Index": -1, "NameInSource": "carddav_url", "Alias": "carddav_url", "Type": "System.String" }, "27": { "Name": "cal_user", "Index": -1, "NameInSource": "cal_user", "Alias": "cal_user", "Type": "System.String" }, "28": { "Name": "cal_pw", "Index": -1, "NameInSource": "cal_pw", "Alias": "cal_pw", "Type": "System.String" }, "29": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "30": { "Name": "defaultvalue", "Index": -1, "NameInSource": "defaultvalue", "Alias": "defaultvalue", "Type": "System.String" }, "31": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "32": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "33": { "Name": "durchwahl", "Index": -1, "NameInSource": "durchwahl", "Alias": "durchwahl", "Type": "System.String" }, "34": { "Name": "warteschlange", "Index": -1, "NameInSource": "warteschlange", "Alias": "warteschlange", "Type": "System.String" }, "35": { "Name": "mandant_default", "Index": -1, "NameInSource": "mandant_default", "Alias": "mandant_default", "Type": "System.Int64" }, "36": { "Name": "work_seconds_per_day_1", "Index": -1, "NameInSource": "work_seconds_per_day_1", "Alias": "work_seconds_per_day_1", "Type": "System.Int64" }, "37": { "Name": "work_seconds_per_day_2", "Index": -1, "NameInSource": "work_seconds_per_day_2", "Alias": "work_seconds_per_day_2", "Type": "System.Int64" }, "38": { "Name": "work_seconds_per_day_3", "Index": -1, "NameInSource": "work_seconds_per_day_3", "Alias": "work_seconds_per_day_3", "Type": "System.Int64" }, "39": { "Name": "work_seconds_per_day_4", "Index": -1, "NameInSource": "work_seconds_per_day_4", "Alias": "work_seconds_per_day_4", "Type": "System.Int64" }, "40": { "Name": "work_seconds_per_day_5", "Index": -1, "NameInSource": "work_seconds_per_day_5", "Alias": "work_seconds_per_day_5", "Type": "System.Int64" }, "41": { "Name": "work_seconds_per_day_6", "Index": -1, "NameInSource": "work_seconds_per_day_6", "Alias": "work_seconds_per_day_6", "Type": "System.Int64" }, "42": { "Name": "work_seconds_per_day_7", "Index": -1, "NameInSource": "work_seconds_per_day_7", "Alias": "work_seconds_per_day_7", "Type": "System.Int64" }, "43": { "Name": "kd_adr_nr", "Index": -1, "NameInSource": "kd_adr_nr", "Alias": "kd_adr_nr", "Type": "System.String" }, "44": { "Name": "kunde", "Index": -1, "NameInSource": "kunde", "Alias": "kunde", "Type": "System.String" }, "45": { "Name": "personalnr", "Index": -1, "NameInSource": "personalnr", "Alias": "personalnr", "Type": "System.Int64" }, "46": { "Name": "typ", "Index": -1, "NameInSource": "typ", "Alias": "typ", "Type": "System.String" }, "47": { "Name": "is_superuser", "Index": -1, "NameInSource": "is_superuser", "Alias": "is_superuser", "Type": "System.String" } }, "NameInSource": "TTS", "SqlCommand": "select * from users" }, "70": { "Ident": "StiPostgreSQLSource", "Name": "users_report", "Alias": "users_report", "Key": "d45680c68fe04a29a712968a3fc65ed8", "Columns": { "0": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.String" }, "1": { "Name": "report_id", "Index": -1, "NameInSource": "report_id", "Alias": "report_id", "Type": "System.Int64" }, "2": { "Name": "users_id", "Index": -1, "NameInSource": "users_id", "Alias": "users_id", "Type": "System.Int64" }, "3": { "Name": "cron", "Index": -1, "NameInSource": "cron", "Alias": "cron", "Type": "System.String" }, "4": { "Name": "deleted", "Index": -1, "NameInSource": "deleted", "Alias": "deleted", "Type": "System.String" }, "5": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "6": { "Name": "letzteaenderung", "Index": -1, "NameInSource": "letzteaenderung", "Alias": "letzteaenderung", "Type": "System.DateTime" }, "7": { "Name": "erstelldatum", "Index": -1, "NameInSource": "erstelldatum", "Alias": "erstelldatum", "Type": "System.DateTime" }, "8": { "Name": "report_zuletzt_versendet", "Index": -1, "NameInSource": "report_zuletzt_versendet", "Alias": "report_zuletzt_versendet", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from users_report" }, "71": { "Ident": "StiPostgreSQLSource", "Name": "zugriffsrechte", "Alias": "zugriffsrechte", "Key": "7d35ae6bcd3f4910ac2b8edf01acf11a", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int64" }, "1": { "Name": "benutzer_id", "Index": -1, "NameInSource": "benutzer_id", "Alias": "benutzer_id", "Type": "System.Int64" }, "2": { "Name": "programm_id", "Index": -1, "NameInSource": "programm_id", "Alias": "programm_id", "Type": "System.Int64" }, "3": { "Name": "mandant_id", "Index": -1, "NameInSource": "mandant_id", "Alias": "mandant_id", "Type": "System.Int64" }, "4": { "Name": "sort", "Index": -1, "NameInSource": "sort", "Alias": "sort", "Type": "System.Int64" }, "5": { "Name": "ebene", "Index": -1, "NameInSource": "ebene", "Alias": "ebene", "Type": "System.Int64" }, "6": { "Name": "erlaubt", "Index": -1, "NameInSource": "erlaubt", "Alias": "erlaubt", "Type": "System.String" }, "7": { "Name": "uid", "Index": -1, "NameInSource": "uid", "Alias": "uid", "Type": "System.Int64" }, "8": { "Name": "echeck", "Index": -1, "NameInSource": "echeck", "Alias": "echeck", "Type": "System.String" }, "9": { "Name": "aenderungsdatum", "Index": -1, "NameInSource": "aenderungsdatum", "Alias": "aenderungsdatum", "Type": "System.DateTime" } }, "NameInSource": "TTS", "SqlCommand": "select * from zugriffsrechte" } }, "Databases": { "0": { "Ident": "StiPostgreSQLDatabase", "Name": "TTS", "Alias": "TTS", "ConnectionStringEncrypted": "+Gz1CcZU84HiTb2E4Rykf8NYm+zNXQqt6ku5CGcEpHPeFrXCSF1rmWJrFYDpAKR7xBbbK00O87zoW7nEagzhY9FU2etNbQHNdE3tmGUYIl7pNvXCyl3zgfFd0UzqADJejVz3SGIDS21rE7Hc6Wxlv4FU/ytWUaPZa01dpf9s5E/WEosJxUuj8GlNnJh6WPY7xGjZAktxQw==" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "8cc9e8db8dc1462e8e80ea5b2b18c72c", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;True;;solid:255,192,0", "Brush": "solid:242,220,219", "Components": { "0": { "Ident": "StiReportTitleBand", "Name": "Kopf", "ClientRectangle": "0,0.4,19,2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14.2,0.4,4,1.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Test - Text" }, "Font": "Segoe UI Symbol;20;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:0,176,80", "Type": "Expression" }, "1": { "Ident": "StiMap", "Name": "Map1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0.2,0.2,3.8,1.4", "Border": ";;;;;;;solid:Black", "Brush": "solid:" } } }, "1": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,3.2,19,3.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text2", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1,0.4,8.4,1.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{report_category.name}" }, "Font": "Segoe UI Symbol;20;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:0,176,80" } }, "DataSourceName": "report_category" } }, "PageWidth": 21.0, "PageHeight": 29.7, "Watermark": { "TextBrush": "solid:50,0,0,0", "Text": "Test" }, "Margins": { "Left": 1.0, "Right": 1.0, "Top": 1.0, "Bottom": 1.0 } } } }