{ "ReportVersion": "2019.2.3", "ReportGuid": "1166901bc554f95a1e838f1590645e71", "ReportName": "Report", "ReportAlias": "Invoice", "ReportFile": "app/web/reports/RechnungGesamt.mrtx?n=d03c879e", "ReportDescription": "A simple invoice.", "ReportCreated": "/Date(396407565000+0200)/", "ReportChanged": "/Date(396407565000+0200)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "PreviewSettings": 268435455, "Styles": { "0": { "Ident": "StiStyle", "Name": "Title1", "Font": "Segoe UI;12;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "1": { "Ident": "StiStyle", "Name": "Title2", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "2": { "Ident": "StiStyle", "Name": "Header1", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "3": { "Ident": "StiStyle", "Name": "Header2", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "4": { "Ident": "StiStyle", "Name": "Header3", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "5": { "Ident": "StiStyle", "Name": "Header4", "Font": "Segoe UI Semibold;10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "6": { "Ident": "StiStyle", "Name": "Data1", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "7": { "Ident": "StiStyle", "Name": "Data2", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "8": { "Ident": "StiStyle", "Name": "Data3", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "9": { "Ident": "StiStyle", "Name": "Footer1", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "10": { "Ident": "StiStyle", "Name": "Footer2", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "11": { "Ident": "StiCrossTabStyle", "Name": "CrossTab", "LineColor": "Red" }, "12": { "Ident": "StiStyle", "Name": "Title1", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "13": { "Ident": "StiStyle", "Name": "Title2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "14": { "Ident": "StiStyle", "Name": "Header1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "15": { "Ident": "StiStyle", "Name": "Header2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "16": { "Ident": "StiStyle", "Name": "Header3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "17": { "Ident": "StiStyle", "Name": "Header4", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "18": { "Ident": "StiStyle", "Name": "Data1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "19": { "Ident": "StiStyle", "Name": "Data2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "20": { "Ident": "StiStyle", "Name": "Data3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "21": { "Ident": "StiStyle", "Name": "Footer1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "22": { "Ident": "StiStyle", "Name": "Footer2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "23": { "Ident": "StiCrossTabStyle", "Name": "CrossTab", "LineColor": "Red" }, "24": { "Ident": "StiStyle", "Name": "Title1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "25": { "Ident": "StiStyle", "Name": "Title2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "26": { "Ident": "StiStyle", "Name": "Header1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "27": { "Ident": "StiStyle", "Name": "Header2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "28": { "Ident": "StiStyle", "Name": "Header3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "29": { "Ident": "StiStyle", "Name": "Header4", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "30": { "Ident": "StiStyle", "Name": "Data1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "31": { "Ident": "StiStyle", "Name": "Data2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "32": { "Ident": "StiStyle", "Name": "Data3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "33": { "Ident": "StiStyle", "Name": "Footer1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "34": { "Ident": "StiStyle", "Name": "Footer2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "35": { "Ident": "StiCrossTabStyle", "Name": "CrossTab", "LineColor": "Red" }, "36": { "Ident": "StiStyle", "Name": "Title1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "37": { "Ident": "StiStyle", "Name": "Title2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "38": { "Ident": "StiStyle", "Name": "Header1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "39": { "Ident": "StiStyle", "Name": "Header2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "40": { "Ident": "StiStyle", "Name": "Header3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "41": { "Ident": "StiStyle", "Name": "Header4", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "42": { "Ident": "StiStyle", "Name": "Data1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "43": { "Ident": "StiStyle", "Name": "Data2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "44": { "Ident": "StiStyle", "Name": "Data3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "45": { "Ident": "StiStyle", "Name": "Footer1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "46": { "Ident": "StiStyle", "Name": "Footer2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "47": { "Ident": "StiCrossTabStyle", "Name": "CrossTab", "LineColor": "Red" }, "48": { "Ident": "StiStyle", "Name": "Title1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "49": { "Ident": "StiStyle", "Name": "Title2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "50": { "Ident": "StiStyle", "Name": "Header1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "51": { "Ident": "StiStyle", "Name": "Header2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "52": { "Ident": "StiStyle", "Name": "Header3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "53": { "Ident": "StiStyle", "Name": "Header4", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "54": { "Ident": "StiStyle", "Name": "Data1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "55": { "Ident": "StiStyle", "Name": "Data2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "56": { "Ident": "StiStyle", "Name": "Data3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "57": { "Ident": "StiStyle", "Name": "Footer1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "58": { "Ident": "StiStyle", "Name": "Footer2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "59": { "Ident": "StiCrossTabStyle", "Name": "CrossTab", "LineColor": "Red" }, "60": { "Ident": "StiStyle", "Name": "Title1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "61": { "Ident": "StiStyle", "Name": "Title2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "62": { "Ident": "StiStyle", "Name": "Header1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "63": { "Ident": "StiStyle", "Name": "Header2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "64": { "Ident": "StiStyle", "Name": "Header3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "65": { "Ident": "StiStyle", "Name": "Header4", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "66": { "Ident": "StiStyle", "Name": "Data1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "67": { "Ident": "StiStyle", "Name": "Data2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "68": { "Ident": "StiStyle", "Name": "Data3", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "69": { "Ident": "StiStyle", "Name": "Footer1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "70": { "Ident": "StiStyle", "Name": "Footer2", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:Red" }, "71": { "Ident": "StiCrossTabStyle", "Name": "CrossTab", "LineColor": "Red" } }, "Dictionary": { "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "guest", "Alias": "guest", "Columns": { "0": { "Name": "birthday", "Index": -1, "NameInSource": "birthday", "Alias": "birthday", "Type": "System.DateTime" }, "1": { "Name": "city", "Index": -1, "NameInSource": "city", "Alias": "city", "Type": "System.String" }, "2": { "Name": "company_id", "Index": -1, "NameInSource": "company_id", "Alias": "company_id", "Type": "System.Int32" }, "3": { "Name": "companyname", "Index": -1, "NameInSource": "companyname", "Alias": "companyname", "Type": "System.String" }, "4": { "Name": "country_id", "Index": -1, "NameInSource": "country_id", "Alias": "country_id", "Type": "System.Int32" }, "5": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "6": { "Name": "email", "Index": -1, "NameInSource": "email", "Alias": "email", "Type": "System.String" }, "7": { "Name": "email_privat", "Index": -1, "NameInSource": "email_privat", "Alias": "email_privat", "Type": "System.String" }, "8": { "Name": "facebook", "Index": -1, "NameInSource": "facebook", "Alias": "facebook", "Type": "System.String" }, "9": { "Name": "fax", "Index": -1, "NameInSource": "fax", "Alias": "fax", "Type": "System.String" }, "10": { "Name": "firstname", "Index": -1, "NameInSource": "firstname", "Alias": "firstname", "Type": "System.String" }, "11": { "Name": "google", "Index": -1, "NameInSource": "google", "Alias": "google", "Type": "System.String" }, "12": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int32" }, "13": { "Name": "lastname", "Index": -1, "NameInSource": "lastname", "Alias": "lastname", "Type": "System.String" }, "14": { "Name": "linkedin", "Index": -1, "NameInSource": "linkedin", "Alias": "linkedin", "Type": "System.String" }, "15": { "Name": "mobil", "Index": -1, "NameInSource": "mobil", "Alias": "mobil", "Type": "System.String" }, "16": { "Name": "note_guest", "Index": -1, "NameInSource": "note_guest", "Alias": "note_guest", "Type": "System.String" }, "17": { "Name": "note_intern", "Index": -1, "NameInSource": "note_intern", "Alias": "note_intern", "Type": "System.String" }, "18": { "Name": "phone", "Index": -1, "NameInSource": "phone", "Alias": "phone", "Type": "System.String" }, "19": { "Name": "plz", "Index": -1, "NameInSource": "plz", "Alias": "plz", "Type": "System.String" }, "20": { "Name": "salutation_id", "Index": -1, "NameInSource": "salutation_id", "Alias": "salutation_id", "Type": "System.String" }, "21": { "Name": "send_emails", "Index": -1, "NameInSource": "send_emails", "Alias": "send_emails", "Type": "System.String" }, "22": { "Name": "status", "Index": -1, "NameInSource": "status", "Alias": "status", "Type": "System.String" }, "23": { "Name": "street", "Index": -1, "NameInSource": "street", "Alias": "street", "Type": "System.String" }, "24": { "Name": "twitter", "Index": -1, "NameInSource": "twitter", "Alias": "twitter", "Type": "System.String" }, "25": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" }, "26": { "Name": "website", "Index": -1, "NameInSource": "website", "Alias": "website", "Type": "System.String" }, "27": { "Name": "website_privat", "Index": -1, "NameInSource": "website_privat", "Alias": "website_privat", "Type": "System.String" } }, "NameInSource": "invoice.dataguest" }, "1": { "Ident": "StiDataTableSource", "Name": "invoice", "Alias": "invoice", "Columns": { "0": { "Name": "barcode", "Index": -1, "NameInSource": "barcode", "Alias": "barcode", "Type": "System.String" }, "1": { "Name": "beleg_typ", "Index": -1, "NameInSource": "beleg_typ", "Alias": "beleg_typ", "Type": "System.String" }, "2": { "Name": "booking_id", "Index": -1, "NameInSource": "booking_id", "Alias": "booking_id", "Type": "System.String" }, "3": { "Name": "cancel_invoice_id", "Index": -1, "NameInSource": "cancel_invoice_id", "Alias": "cancel_invoice_id", "Type": "System.String" }, "4": { "Name": "cancel_text", "Index": -1, "NameInSource": "cancel_text", "Alias": "cancel_text", "Type": "System.String" }, "5": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.DateTime" }, "6": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "7": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.DateTime" }, "8": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "9": { "Name": "dep_id", "Index": -1, "NameInSource": "dep_id", "Alias": "dep_id", "Type": "System.String" }, "10": { "Name": "fo_kasse_id", "Index": -1, "NameInSource": "fo_kasse_id", "Alias": "fo_kasse_id", "Type": "System.String" }, "11": { "Name": "full_amount", "Index": -1, "NameInSource": "full_amount", "Alias": "full_amount", "Type": "System.String" }, "12": { "Name": "guest_id", "Index": -1, "NameInSource": "guest_id", "Alias": "guest_id", "Type": "System.String" }, "13": { "Name": "guest_id", "Index": -1, "NameInSource": "guest_id", "Alias": "guest_id", "Type": "System.Int32" }, "14": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "15": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int32" }, "16": { "Name": "invoicenr", "Index": -1, "NameInSource": "invoicenr", "Alias": "invoicenr", "Type": "System.String" }, "17": { "Name": "invoicenr", "Index": -1, "NameInSource": "invoicenr", "Alias": "invoicenr", "Type": "System.Int32" }, "18": { "Name": "is_payed", "Index": -1, "NameInSource": "is_payed", "Alias": "is_payed", "Type": "System.String" }, "19": { "Name": "manual_text", "Index": -1, "NameInSource": "manual_text", "Alias": "manual_text", "Type": "System.String" }, "20": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "21": { "Name": "pay", "Index": -1, "NameInSource": "pay", "Alias": "pay", "Type": "System.String" }, "22": { "Name": "payment_date", "Index": -1, "NameInSource": "payment_date", "Alias": "payment_date", "Type": "System.String" }, "23": { "Name": "payment_option_id", "Index": -1, "NameInSource": "payment_option_id", "Alias": "payment_option_id", "Type": "System.String" }, "24": { "Name": "payment_value", "Index": -1, "NameInSource": "payment_value", "Alias": "payment_value", "Type": "System.String" }, "25": { "Name": "prepaid_amount", "Index": -1, "NameInSource": "prepaid_amount", "Alias": "prepaid_amount", "Type": "System.String" }, "26": { "Name": "ready", "Index": -1, "NameInSource": "ready", "Alias": "ready", "Type": "System.String" }, "27": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.String" }, "28": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.Int32" }, "29": { "Name": "status", "Index": -1, "NameInSource": "status", "Alias": "status", "Type": "System.String" }, "30": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.Double" }, "31": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.String" }, "32": { "Name": "sum_bar", "Index": -1, "NameInSource": "sum_bar", "Alias": "sum_bar", "Type": "System.String" }, "33": { "Name": "sum_forever", "Index": -1, "NameInSource": "sum_forever", "Alias": "sum_forever", "Type": "System.String" }, "34": { "Name": "table_id", "Index": -1, "NameInSource": "table_id", "Alias": "table_id", "Type": "System.String" }, "35": { "Name": "text", "Index": -1, "NameInSource": "text", "Alias": "text", "Type": "System.String" }, "36": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" }, "37": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.String" }, "38": { "Name": "zbon_id", "Index": -1, "NameInSource": "zbon_id", "Alias": "zbon_id", "Type": "System.String" } }, "NameInSource": "invoice.datainvoice" }, "2": { "Ident": "StiDataTableSource", "Name": "invoiceitem", "Alias": "invoiceitem", "Columns": { "0": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "1": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "2": { "Name": "datetime", "Index": -1, "NameInSource": "datetime", "Alias": "datetime", "Type": "System.String" }, "3": { "Name": "extra_id", "Index": -1, "NameInSource": "extra_id", "Alias": "extra_id", "Type": "System.Int32" }, "4": { "Name": "extra_id", "Index": -1, "NameInSource": "extra_id", "Alias": "extra_id", "Type": "System.String" }, "5": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int32" }, "6": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "7": { "Name": "invoice_id", "Index": -1, "NameInSource": "invoice_id", "Alias": "invoice_id", "Type": "System.Int32" }, "8": { "Name": "invoice_id", "Index": -1, "NameInSource": "invoice_id", "Alias": "invoice_id", "Type": "System.String" }, "9": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "10": { "Name": "package_id", "Index": -1, "NameInSource": "package_id", "Alias": "package_id", "Type": "System.Int32" }, "11": { "Name": "package_id", "Index": -1, "NameInSource": "package_id", "Alias": "package_id", "Type": "System.String" }, "12": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.Int32" }, "13": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.String" }, "14": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.String" }, "15": { "Name": "rule_id", "Index": -1, "NameInSource": "rule_id", "Alias": "rule_id", "Type": "System.String" }, "16": { "Name": "single_amount", "Index": -1, "NameInSource": "single_amount", "Alias": "single_amount", "Type": "System.String" }, "17": { "Name": "single_amount", "Index": -1, "NameInSource": "single_amount", "Alias": "single_amount", "Type": "System.Decimal" }, "18": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.String" }, "19": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.Decimal" }, "20": { "Name": "sum_tax", "Index": -1, "NameInSource": "sum_tax", "Alias": "sum_tax", "Type": "System.String" }, "21": { "Name": "table_id", "Index": -1, "NameInSource": "table_id", "Alias": "table_id", "Type": "System.String" }, "22": { "Name": "tax", "Index": -1, "NameInSource": "tax", "Alias": "tax", "Type": "System.String" }, "23": { "Name": "tax", "Index": -1, "NameInSource": "tax", "Alias": "tax", "Type": "System.Int32" }, "24": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" } }, "NameInSource": "invoice.datainvoiceitem" }, "3": { "Ident": "StiDataTableSource", "Name": "payment", "Alias": "payment", "Columns": { "0": { "Name": "amount", "Index": -1, "NameInSource": "amount", "Alias": "amount", "Type": "System.Decimal" }, "1": { "Name": "amount", "Index": -1, "NameInSource": "amount", "Alias": "amount", "Type": "System.String" }, "2": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int32" }, "3": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "4": { "Name": "invoicetext", "Index": -1, "NameInSource": "invoicetext", "Alias": "invoicetext", "Type": "System.String" }, "5": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" } }, "NameInSource": "invoice.payment" }, "4": { "Ident": "StiDataTableSource", "Name": "bookingroom", "Alias": "bookingroom", "Columns": { "0": { "Name": "adults", "Index": -1, "NameInSource": "adults", "Alias": "adults", "Type": "System.Int32" }, "1": { "Name": "autoprice", "Index": -1, "NameInSource": "autoprice", "Alias": "autoprice", "Type": "System.Double" }, "2": { "Name": "booking_id", "Index": -1, "NameInSource": "booking_id", "Alias": "booking_id", "Type": "System.Int32" }, "3": { "Name": "booktype", "Index": -1, "NameInSource": "booktype", "Alias": "booktype", "Type": "System.Int32" }, "4": { "Name": "category_id", "Index": -1, "NameInSource": "category_id", "Alias": "category_id", "Type": "System.Int32" }, "5": { "Name": "checkin", "Index": -1, "NameInSource": "checkin", "Alias": "checkin", "Type": "System.Int32" }, "6": { "Name": "children", "Index": -1, "NameInSource": "children", "Alias": "children", "Type": "System.Int32" }, "7": { "Name": "comment_reserv", "Index": -1, "NameInSource": "comment_reserv", "Alias": "comment_reserv", "Type": "System.String" }, "8": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.DateTime" }, "9": { "Name": "date_from", "Index": -1, "NameInSource": "date_from", "Alias": "date_from", "Type": "System.DateTime" }, "10": { "Name": "date_to", "Index": -1, "NameInSource": "date_to", "Alias": "date_to", "Type": "System.DateTime" }, "11": { "Name": "date_wait", "Index": -1, "NameInSource": "date_wait", "Alias": "date_wait", "Type": "System.DateTime" }, "12": { "Name": "guest_id", "Index": -1, "NameInSource": "guest_id", "Alias": "guest_id", "Type": "System.Int32" }, "13": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Int32" }, "14": { "Name": "invoice_account_id", "Index": -1, "NameInSource": "invoice_account_id", "Alias": "invoice_account_id", "Type": "System.String" }, "15": { "Name": "link_id", "Index": -1, "NameInSource": "link_id", "Alias": "link_id", "Type": "System.String" }, "16": { "Name": "package_id", "Index": -1, "NameInSource": "package_id", "Alias": "package_id", "Type": "System.String" }, "17": { "Name": "payed", "Index": -1, "NameInSource": "payed", "Alias": "payed", "Type": "System.String" }, "18": { "Name": "payed_value", "Index": -1, "NameInSource": "payed_value", "Alias": "payed_value", "Type": "System.String" }, "19": { "Name": "room_id", "Index": -1, "NameInSource": "room_id", "Alias": "room_id", "Type": "System.String" }, "20": { "Name": "room_price", "Index": -1, "NameInSource": "room_price", "Alias": "room_price", "Type": "System.String" }, "21": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" } }, "NameInSource": "invoice.databooking" }, "5": { "Ident": "StiDataTableSource", "Name": "invoiceitempackage", "Alias": "invoiceitempackage", "Columns": { "0": { "Name": "adults", "Index": -1, "NameInSource": "adults", "Alias": "adults", "Type": "System.String" }, "1": { "Name": "booking_extra_id", "Index": -1, "NameInSource": "booking_extra_id", "Alias": "booking_extra_id", "Type": "System.String" }, "2": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "3": { "Name": "customer_name", "Index": -1, "NameInSource": "customer_name", "Alias": "customer_name", "Type": "System.String" }, "4": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "5": { "Name": "date_from", "Index": -1, "NameInSource": "date_from", "Alias": "date_from", "Type": "System.String" }, "6": { "Name": "date_to", "Index": -1, "NameInSource": "date_to", "Alias": "date_to", "Type": "System.String" }, "7": { "Name": "datetime", "Index": -1, "NameInSource": "datetime", "Alias": "datetime", "Type": "System.String" }, "8": { "Name": "days", "Index": -1, "NameInSource": "days", "Alias": "days", "Type": "System.String" }, "9": { "Name": "extra_id", "Index": -1, "NameInSource": "extra_id", "Alias": "extra_id", "Type": "System.String" }, "10": { "Name": "fibu_id", "Index": -1, "NameInSource": "fibu_id", "Alias": "fibu_id", "Type": "System.String" }, "11": { "Name": "firstname", "Index": -1, "NameInSource": "firstname", "Alias": "firstname", "Type": "System.String" }, "12": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "13": { "Name": "invoice_id", "Index": -1, "NameInSource": "invoice_id", "Alias": "invoice_id", "Type": "System.String" }, "14": { "Name": "isprepaid", "Index": -1, "NameInSource": "isprepaid", "Alias": "isprepaid", "Type": "System.String" }, "15": { "Name": "lastname", "Index": -1, "NameInSource": "lastname", "Alias": "lastname", "Type": "System.String" }, "16": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "17": { "Name": "package_id", "Index": -1, "NameInSource": "package_id", "Alias": "package_id", "Type": "System.String" }, "18": { "Name": "packagename", "Index": -1, "NameInSource": "packagename", "Alias": "packagename", "Type": "System.String" }, "19": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.Int32" }, "20": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.String" }, "21": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.String" }, "22": { "Name": "roomnr", "Index": -1, "NameInSource": "roomnr", "Alias": "roomnr", "Type": "System.String" }, "23": { "Name": "rule_id", "Index": -1, "NameInSource": "rule_id", "Alias": "rule_id", "Type": "System.String" }, "24": { "Name": "single_amount", "Index": -1, "NameInSource": "single_amount", "Alias": "single_amount", "Type": "System.Decimal" }, "25": { "Name": "single_amount", "Index": -1, "NameInSource": "single_amount", "Alias": "single_amount", "Type": "System.String" }, "26": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.Decimal" }, "27": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.String" }, "28": { "Name": "sum_childs", "Index": -1, "NameInSource": "sum_childs", "Alias": "sum_childs", "Type": "System.String" }, "29": { "Name": "sum_tax", "Index": -1, "NameInSource": "sum_tax", "Alias": "sum_tax", "Type": "System.String" }, "30": { "Name": "table_id", "Index": -1, "NameInSource": "table_id", "Alias": "table_id", "Type": "System.String" }, "31": { "Name": "tax", "Index": -1, "NameInSource": "tax", "Alias": "tax", "Type": "System.String" }, "32": { "Name": "tax", "Index": -1, "NameInSource": "tax", "Alias": "tax", "Type": "System.Int32" }, "33": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" }, "34": { "Name": "user_id", "Index": -1, "NameInSource": "user_id", "Alias": "user_id", "Type": "System.String" }, "35": { "Name": "zbon_id", "Index": -1, "NameInSource": "zbon_id", "Alias": "zbon_id", "Type": "System.String" } }, "NameInSource": "invoice.datainvoiceitempackageday" }, "6": { "Ident": "StiDataTableSource", "Name": "salutation", "Alias": "Datenquelle1", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "order", "Index": -1, "NameInSource": "order", "Alias": "order", "Type": "System.String" } }, "NameInSource": "invoice.dataSalutation" }, "7": { "Ident": "StiDataTableSource", "Name": "country", "Alias": "Datenquelle1", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" } }, "NameInSource": "invoice.datacountry" }, "8": { "Ident": "StiDataTableSource", "Name": "tax", "Alias": "Datenquelle1", "Columns": { "0": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "1": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "2": { "Name": "datetime", "Index": -1, "NameInSource": "datetime", "Alias": "datetime", "Type": "System.String" }, "3": { "Name": "days", "Index": -1, "NameInSource": "days", "Alias": "days", "Type": "System.String" }, "4": { "Name": "extra_id", "Index": -1, "NameInSource": "extra_id", "Alias": "extra_id", "Type": "System.String" }, "5": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "6": { "Name": "invoice_id", "Index": -1, "NameInSource": "invoice_id", "Alias": "invoice_id", "Type": "System.String" }, "7": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "8": { "Name": "package_id", "Index": -1, "NameInSource": "package_id", "Alias": "package_id", "Type": "System.String" }, "9": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.String" }, "10": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.String" }, "11": { "Name": "rule_id", "Index": -1, "NameInSource": "rule_id", "Alias": "rule_id", "Type": "System.String" }, "12": { "Name": "single_amount", "Index": -1, "NameInSource": "single_amount", "Alias": "single_amount", "Type": "System.String" }, "13": { "Name": "sum_all", "Index": -1, "NameInSource": "sum_all", "Alias": "sum_all", "Type": "System.String" }, "14": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.String" }, "15": { "Name": "sum_netto", "Index": -1, "NameInSource": "sum_netto", "Alias": "sum_netto", "Type": "System.Decimal" }, "16": { "Name": "table_id", "Index": -1, "NameInSource": "table_id", "Alias": "table_id", "Type": "System.String" }, "17": { "Name": "tax", "Index": -1, "NameInSource": "tax", "Alias": "tax", "Type": "System.String" }, "18": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" } }, "NameInSource": "invoice.invoicetax" }, "9": { "Ident": "StiDataTableSource", "Name": "invoiceitemprepaid", "Alias": "Datenquelle1", "Columns": { "0": { "Name": "bk_color", "Index": -1, "NameInSource": "bk_color", "Alias": "bk_color", "Type": "System.String" }, "1": { "Name": "calendar_id", "Index": -1, "NameInSource": "calendar_id", "Alias": "calendar_id", "Type": "System.String" }, "2": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "3": { "Name": "custom_price", "Index": -1, "NameInSource": "custom_price", "Alias": "custom_price", "Type": "System.String" }, "4": { "Name": "custom_qty", "Index": -1, "NameInSource": "custom_qty", "Alias": "custom_qty", "Type": "System.String" }, "5": { "Name": "custom_text", "Index": -1, "NameInSource": "custom_text", "Alias": "custom_text", "Type": "System.String" }, "6": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "7": { "Name": "datetime", "Index": -1, "NameInSource": "datetime", "Alias": "datetime", "Type": "System.String" }, "8": { "Name": "days", "Index": -1, "NameInSource": "days", "Alias": "days", "Type": "System.String" }, "9": { "Name": "extra_id", "Index": -1, "NameInSource": "extra_id", "Alias": "extra_id", "Type": "System.String" }, "10": { "Name": "extragroup_id", "Index": -1, "NameInSource": "extragroup_id", "Alias": "extragroup_id", "Type": "System.String" }, "11": { "Name": "font_color", "Index": -1, "NameInSource": "font_color", "Alias": "font_color", "Type": "System.String" }, "12": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "13": { "Name": "invoice_id", "Index": -1, "NameInSource": "invoice_id", "Alias": "invoice_id", "Type": "System.String" }, "14": { "Name": "is_preview_payment", "Index": -1, "NameInSource": "is_preview_payment", "Alias": "is_preview_payment", "Type": "System.String" }, "15": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "16": { "Name": "online_booking", "Index": -1, "NameInSource": "online_booking", "Alias": "online_booking", "Type": "System.String" }, "17": { "Name": "package_id", "Index": -1, "NameInSource": "package_id", "Alias": "package_id", "Type": "System.String" }, "18": { "Name": "per", "Index": -1, "NameInSource": "per", "Alias": "per", "Type": "System.String" }, "19": { "Name": "price", "Index": -1, "NameInSource": "price", "Alias": "price", "Type": "System.String" }, "20": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.String" }, "21": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.String" }, "22": { "Name": "rule_id", "Index": -1, "NameInSource": "rule_id", "Alias": "rule_id", "Type": "System.String" }, "23": { "Name": "single_amount", "Index": -1, "NameInSource": "single_amount", "Alias": "single_amount", "Type": "System.String" }, "24": { "Name": "status", "Index": -1, "NameInSource": "status", "Alias": "status", "Type": "System.String" }, "25": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.String" }, "26": { "Name": "sum_tax", "Index": -1, "NameInSource": "sum_tax", "Alias": "sum_tax", "Type": "System.String" }, "27": { "Name": "table_id", "Index": -1, "NameInSource": "table_id", "Alias": "table_id", "Type": "System.String" }, "28": { "Name": "tax", "Index": -1, "NameInSource": "tax", "Alias": "tax", "Type": "System.String" }, "29": { "Name": "tax_id", "Index": -1, "NameInSource": "tax_id", "Alias": "tax_id", "Type": "System.String" }, "30": { "Name": "thumb", "Index": -1, "NameInSource": "thumb", "Alias": "thumb", "Type": "System.String" }, "31": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" } }, "NameInSource": "invoice.datainvoiceitemprepaid" }, "10": { "Ident": "StiDataTableSource", "Name": "barcode", "Alias": "barcode", "Columns": { "0": { "Name": "barcode", "Index": -1, "NameInSource": "barcode", "Alias": "barcode", "Type": "System.String" }, "1": { "Name": "beleg_typ", "Index": -1, "NameInSource": "beleg_typ", "Alias": "beleg_typ", "Type": "System.String" }, "2": { "Name": "booking_id", "Index": -1, "NameInSource": "booking_id", "Alias": "booking_id", "Type": "System.String" }, "3": { "Name": "cancel_invoice_id", "Index": -1, "NameInSource": "cancel_invoice_id", "Alias": "cancel_invoice_id", "Type": "System.String" }, "4": { "Name": "cancel_text", "Index": -1, "NameInSource": "cancel_text", "Alias": "cancel_text", "Type": "System.String" }, "5": { "Name": "create_at", "Index": -1, "NameInSource": "create_at", "Alias": "create_at", "Type": "System.String" }, "6": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "7": { "Name": "dep_id", "Index": -1, "NameInSource": "dep_id", "Alias": "dep_id", "Type": "System.String" }, "8": { "Name": "fo_kasse_id", "Index": -1, "NameInSource": "fo_kasse_id", "Alias": "fo_kasse_id", "Type": "System.String" }, "9": { "Name": "full_amount", "Index": -1, "NameInSource": "full_amount", "Alias": "full_amount", "Type": "System.String" }, "10": { "Name": "guest_id", "Index": -1, "NameInSource": "guest_id", "Alias": "guest_id", "Type": "System.String" }, "11": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "12": { "Name": "invoicenr", "Index": -1, "NameInSource": "invoicenr", "Alias": "invoicenr", "Type": "System.String" }, "13": { "Name": "manual_text", "Index": -1, "NameInSource": "manual_text", "Alias": "manual_text", "Type": "System.String" }, "14": { "Name": "pay", "Index": -1, "NameInSource": "pay", "Alias": "pay", "Type": "System.String" }, "15": { "Name": "payment_option_id", "Index": -1, "NameInSource": "payment_option_id", "Alias": "payment_option_id", "Type": "System.String" }, "16": { "Name": "prepaid_amount", "Index": -1, "NameInSource": "prepaid_amount", "Alias": "prepaid_amount", "Type": "System.String" }, "17": { "Name": "ready", "Index": -1, "NameInSource": "ready", "Alias": "ready", "Type": "System.String" }, "18": { "Name": "reserv_id", "Index": -1, "NameInSource": "reserv_id", "Alias": "reserv_id", "Type": "System.String" }, "19": { "Name": "status", "Index": -1, "NameInSource": "status", "Alias": "status", "Type": "System.String" }, "20": { "Name": "sum_amount", "Index": -1, "NameInSource": "sum_amount", "Alias": "sum_amount", "Type": "System.String" }, "21": { "Name": "sum_bar", "Index": -1, "NameInSource": "sum_bar", "Alias": "sum_bar", "Type": "System.String" }, "22": { "Name": "sum_forever", "Index": -1, "NameInSource": "sum_forever", "Alias": "sum_forever", "Type": "System.String" }, "23": { "Name": "table_id", "Index": -1, "NameInSource": "table_id", "Alias": "table_id", "Type": "System.String" }, "24": { "Name": "update_at", "Index": -1, "NameInSource": "update_at", "Alias": "update_at", "Type": "System.String" } }, "NameInSource": "invoice.barcode" } }, "Relations": { "0": { "Name": "Beziehung1", "ChildColumns": { "0": "country_id" }, "ParentColumns": { "0": "id" }, "NameInSource": "Beziehung1", "Alias": "Beziehung1", "IsCloud": null, "ParentSource": "country", "ChildSource": "guest" }, "1": { "Name": "Beziehung2", "ChildColumns": { "0": "salutation_id" }, "ParentColumns": { "0": "id" }, "NameInSource": "Beziehung2", "Alias": "Beziehung2", "IsCloud": null, "ParentSource": "salutation", "ChildSource": "guest" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "79f72991-a3dc-9bf7-bb36-601c27898d4f", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiReportTitleBand", "Name": "ReportTitleBand2", "ClientRectangle": "0,0.4,19,4.4", "ComponentStyle": "Data1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent" }, "1": { "Ident": "StiDataBand", "Name": "DataBand5", "ClientRectangle": "0,5.6,19,3.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text18", "Guid": "f3ae944c3334d561c21aba0cb471e9a0", "ClientRectangle": "0,0,9.4,2.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{guest.Beziehung2.name}\r\n{guest.firstname} {guest.lastname}\r\n{guest.street}\r\n{guest.plz} {guest.city}\r\n{guest.Beziehung1.name}\r\n" }, "Font": "Segoe UI;12;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Margins": { "Left": 5, "Right": 0, "Top": 5, "Bottom": 0 }, "Type": "Expression" } }, "DataSourceName": "guest", "DataRelationName": "[Not Assigned]" }, "2": { "Ident": "StiDataBand", "Name": "DataBand6", "ClientRectangle": "0,9.8,19,1.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text19", "Guid": "2dfab830861519f9078620c0a3dbf11f", "ClientRectangle": "5.6,0.2,2.4,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoice.id}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI;18;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text7", "Guid": "23b44fbc25cdf6f625365b772aa4a8db", "ClientRectangle": "0,0.2,5.8,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoice.text}" }, "VertAlignment": "Center", "Font": "Segoe UI;18;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextQuality": "Wysiwyg", "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text27", "Guid": "32435539b735b7879b7f8e9214f442f6", "ClientRectangle": "14,0,4.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoice.date}" }, "HorAlignment": "Right", "Font": "Segoe UI;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text34", "Guid": "8d2d0682db768b4fa43b792342607ca5", "ClientRectangle": "14,0.4,4.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoice.create_at}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiTimeFormatService", "StringFormat": "" }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text46", "Guid": "3287b3d17d5ce5fb9cccf22975e503d7", "ClientRectangle": "0,1.2,18.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoice.manual_text}" }, "VertAlignment": "Center", "Font": "Segoe UI;14;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:237,125,49", "Type": "DataColumn" } }, "DataSourceName": "invoice", "DataRelationName": "[Not Assigned]" }, "3": { "Ident": "StiHeaderBand", "Name": "HeaderBand1", "ClientRectangle": "0,12.2,19,0.6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:191,191,191", "Components": { "0": { "Ident": "StiText", "Name": "Text10", "Guid": "d9d941de105b55812318805f53d8a001", "ClientRectangle": "0,0,7.2,0.6", "ComponentStyle": "Header4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Bezeichnung" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text2", "Guid": "bb7c850b22abbcb6e1920ebf876757b3", "ClientRectangle": "7.2,0,2,0.6", "ComponentStyle": "Header4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "MWST" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text24", "Guid": "e8989f833b6fb89565a4e15c28da0046", "ClientRectangle": "10.4,0,4,0.6", "ComponentStyle": "Header4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Einzelpreis" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text26", "Guid": "8f87a4835901b4aa2b445cf33596fc37", "ClientRectangle": "14.4,0,4.6,0.6", "ComponentStyle": "Header4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Gesamt " }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text11", "Guid": "ff7fa536c9b4113b2e5b6773fa489415", "ClientRectangle": "9.2,0,1.2,0.6", "ComponentStyle": "Header4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Menge" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" } }, "PrintIfEmpty": true }, "4": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand2", "ClientRectangle": "0,13.6,19,1.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:231,230,230", "Components": { "0": { "Ident": "StiText", "Name": "Text35", "Guid": "ebe97249ebd05d58ec07b8f556e02936", "ClientRectangle": "0,0.2,4.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Zimmer: {invoiceitempackage.roomnr}" }, "Font": "Segoe UI;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text36", "Guid": "8b24e573c56c9fbab0f79c7e91aacc2d", "ClientRectangle": "4.4,0.2,1.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.date_from}" }, "Font": "Segoe UI;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService" } }, "2": { "Ident": "StiText", "Name": "Text37", "Guid": "f9a2eb31c9f274fe9c425cca7c3a8ced", "ClientRectangle": "6.2,0.2,1.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.date_to}" }, "Font": "Segoe UI;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService" } }, "3": { "Ident": "StiText", "Name": "Text39", "Guid": "d7db1dfe6cdbead16afd1d675697d6b1", "ClientRectangle": "0,0.6,7,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.firstname} {invoiceitempackage.lastname}" }, "Font": "Segoe UI;;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text49", "Guid": "852a328ae6ef1a12cdcf9b57ce2c12ff", "ClientRectangle": "10.4,0,4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand3,invoiceitempackage.sum_amount)/Sum(DataBand3,invoiceitempackage.quantity)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 8, "DecimalSeparator": ",", "GroupSeparator": ".", "PositivePattern": 3, "Symbol": "€" }, "Type": "Totals" }, "5": { "Ident": "StiText", "Name": "Text47", "Guid": "472e3e82cb8db24c39668958c800a121", "ClientRectangle": "14.4,0,4.6,0.6", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand3,invoiceitempackage.sum_amount)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 8, "DecimalSeparator": ",", "GroupSeparator": ".", "PositivePattern": 3, "Symbol": "€" }, "Type": "Totals" }, "6": { "Ident": "StiText", "Name": "Text48", "Guid": "2abbb25c46eedefde62c6ee76077fd35", "ClientRectangle": "9.2,0,1.2,0.6", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand3,invoiceitempackage.quantity)}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Totals" }, "7": { "Ident": "StiText", "Name": "Text45", "Guid": "380b4b562f7b172a836ab5090975e0aa", "CanGrow": true, "ClientRectangle": "0,1,10,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.packagename}" }, "VertAlignment": "Center", "Font": "Segoe UI;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "DataColumn" } }, "Condition": { "Value": "{invoiceitempackage.reserv_id}" } }, "5": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand4", "ClientRectangle": "0,15.8,19,0.2", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent" }, "6": { "Ident": "StiDataBand", "Name": "DataBand3", "ClientRectangle": "0,16.8,19,0.4", "ComponentStyle": "Data1", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text31", "Guid": "4fa8bbffb9a89cae19dde8370ea92195", "ClientRectangle": "14.4,0,4.6,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.sum_amount}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text30", "Guid": "3e33b33f8befbde79c3468a07ab61fef", "ClientRectangle": "7.2,0,2,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.tax}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits, CurrencySymbol", "PositivePattern": 0, "Symbol": "%" }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text20", "Guid": "3d6f8beb7c9dc336cfc52a67a1760835", "ClientRectangle": "9.2,0,1.2,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.quantity}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0" }, "3": { "Ident": "StiText", "Name": "Text22", "Guid": "75bc6236619180b4e9bc87ace893f3eb", "ClientRectangle": "10.4,0,4,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.sum_amount}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" } }, "4": { "Ident": "StiText", "Name": "Text17", "Guid": "f707a520c5f98698990bfac598876510", "ClientRectangle": "0,0,7.2,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitempackage.name} {invoiceitempackage.tax} %" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" } }, "DataSourceName": "invoiceitempackage", "DataRelationName": "[Not Assigned]" }, "7": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand3", "ClientRectangle": "0,18,19,0.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:255,255,255", "Components": { "0": { "Ident": "StiText", "Name": "Text38", "Guid": "583675f78a88b2353367ab63a0feb2cb", "ClientRectangle": "0,0,7.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Leistungen Hotel und Restaurant" }, "VertAlignment": "Center", "Font": "Segoe UI;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" } }, "Condition": { "Value": "{invoiceitem.reserv_id}" } }, "8": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,19.4,19,0.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "Guid": "f8b3b9784e8f5efabc48e8b72300e977", "CanGrow": true, "ClientRectangle": "0,0,7.2,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitem.name}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text25", "Guid": "9b068b0cb2f5e045774107941c856791", "GrowToHeight": true, "ClientRectangle": "10.4,0,4,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitem.single_amount} " }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 5, "DecimalSeparator": ",", "GroupSeparator": " ", "PositivePattern": 1, "Symbol": "р." }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text12", "Guid": "cc6fd31dec1907358eb955f5828cd521", "GrowToHeight": true, "ClientRectangle": "14.4,0,4.6,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitem.sum_amount}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 5, "DecimalSeparator": ",", "GroupSeparator": " ", "PositivePattern": 1, "Symbol": "р." }, "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text9", "Guid": "9a2f6be26ab4ced32493f01a26e79110", "GrowToHeight": true, "ClientRectangle": "9.2,0,1.2,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitem.quantity}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": " ", "UseGroupSeparator": false, "UseLocalSetting": false }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text5", "Guid": "c819765c7d1a98314764cb99c7c395b7", "ClientRectangle": "7.2,0,2,0.4", "ComponentStyle": "Header3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitem.tax}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits, CurrencySymbol", "PositivePattern": 0, "Symbol": "%" }, "Type": "Expression" } }, "DataSourceName": "invoiceitem", "DataRelationName": "[Not Assigned]", "EvenStyle": "Data2" }, "9": { "Ident": "StiFooterBand", "Name": "FooterBand1", "ClientRectangle": "0,20.6,19,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": "Top;;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text16", "Guid": "540194aa884b48485c8d25825fa6cc64", "ClientRectangle": "9.8,0,6.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Rechnungsbetrag:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI Semibold;10;;", "Border": ";0,176,80;;Double;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text4", "Guid": "b719a56da8a455160d3d08d0140dca1f", "ClientRectangle": "16,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,invoiceitem.sum_amount)+Sum(DataBand3,invoiceitempackage.sum_amount)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI Semibold;10;;", "Border": ";0,176,80;;Double;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" }, "Type": "Expression" } }, "PrintIfEmpty": true }, "10": { "Ident": "StiDataBand", "Name": "DataBand7", "ClientRectangle": "0,22.2,19,0.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";0,176,80;;Double;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text42", "Guid": "a963b01b691ee4cfd86669443f8d77c2", "ClientRectangle": "9.6,0,6.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitemprepaid.name}" }, "HorAlignment": "Right", "Font": "Segoe UI Light;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "Text43", "Guid": "7b3c16462dba8102edd7665d1ac8485b", "ClientRectangle": "16,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{invoiceitemprepaid.sum_amount}" }, "HorAlignment": "Right", "Font": "Segoe UI Light;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" } } }, "KeepDetails": "KeepDetailsTogether", "DataSourceName": "invoiceitemprepaid", "DataRelationName": "[Not Assigned]", "KeepDetailsTogether": true }, "11": { "Ident": "StiHeaderBand", "Name": "HeaderBand3", "ClientRectangle": "0,23.6,19,1.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text41", "Guid": "06a3df24-7ea7-9b3d-bb88-1dccd7913048", "ClientRectangle": "16,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,invoiceitem.sum_amount)+Sum(DataBand3,invoiceitempackage.sum_amount)+Sum(DataBand7,invoiceitemprepaid.sum_amount)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI Semibold;10;;", "Border": ";0,176,80;;Double;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text44", "Guid": "2608dde9-0658-c410-63bd-98dc740ab8ab", "ClientRectangle": "9.4,0,6.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Zahlungsbetrag:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI Semibold;10;;", "Border": ";0,176,80;;Double;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text6", "Guid": "9af8bdf5bb679b2b4c4a16c43c29c2bc", "ClientRectangle": "0,0,3.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Mehrwertsteuer" }, "VertAlignment": "Center", "Font": "Segoe UI;;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text3", "Guid": "7c714e715c43f875afdb9f8edc73f496", "ClientRectangle": "0,0.8,1.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "MWST" }, "Font": "Segoe UI;;Bold;", "Border": "Bottom;;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text15", "Guid": "b9ee6b77-d01a-780e-b4d5-ed8850b95b2f", "ClientRectangle": "1.8,0.8,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Nettobetrag" }, "HorAlignment": "Right", "Font": "Segoe UI;;Bold;", "Border": "Bottom;;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text21", "Guid": "f9822842-afad-23ee-822c-10e70cf658d2", "ClientRectangle": "4.2,0.8,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "MwSt-Betrag" }, "HorAlignment": "Right", "Font": "Segoe UI;;Bold;", "Border": "Bottom;;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text32", "Guid": "3e860da4-ffac-3283-9d89-0ade80e35b5b", "ClientRectangle": "6.6,0.8,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Gesamt" }, "HorAlignment": "Right", "Font": "Segoe UI;;Bold;", "Border": "Bottom;;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" } }, "PrintIfEmpty": true }, "12": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "CanShrink": true, "ClientRectangle": "0,25.6,19,0.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text29", "Guid": "1bd94b55e4b04d03d80d10bdaf7d262f", "ClientRectangle": "0,0,1.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{tax.tax}" }, "VertAlignment": "Center", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits, CurrencySymbol", "PositivePattern": 0, "Symbol": "%" } }, "1": { "Ident": "StiText", "Name": "Text23", "Guid": "0727bdc0d3165ffb50a6e6cf264cfa2b", "ClientRectangle": "4.2,0,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand4,tax.sum_amount)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "State": "DecimalDigits", "PositivePattern": 0, "Symbol": "€" }, "Type": "Totals" }, "2": { "Ident": "StiText", "Name": "Text28", "Guid": "b32681ed9f7fe9d65bb0dce3915b7737", "ClientRectangle": "1.8,0,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand4,tax.sum_netto)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" }, "Type": "Totals" }, "3": { "Ident": "StiText", "Name": "Text33", "Guid": "4d4cc680-ef6e-96dd-a8bf-f90595a6bb6d", "ClientRectangle": "6.6,0,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand4,tax.sum_all)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "State": "DecimalDigits", "PositivePattern": 0, "Symbol": "€" }, "Type": "Totals" } }, "KeepGroupTogether": true, "Condition": { "Value": "{tax.tax}" } }, "13": { "Ident": "StiDataBand", "Name": "DataBand4", "ClientRectangle": "0,26.8,19,0.6", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "DataSourceName": "tax", "DataRelationName": "[Not Assigned]" }, "14": { "Ident": "StiHeaderBand", "Name": "HeaderBand2", "ClientRectangle": "0,28.2,19,0.6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text14", "Guid": "765e5cbf50b33eb4a5345b31eaa55310", "ClientRectangle": "13.2,0,2.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Zahlweg:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI;10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" } }, "PrintIfEmpty": true }, "15": { "Ident": "StiDataBand", "Name": "DataBand2", "ClientRectangle": "0,29.6,19,0.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text8", "Guid": "6c479f9ad1288047a5ab865103139d0f", "ClientRectangle": "16,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{payment.amount}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI Semibold;10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "DecimalSeparator": ",", "GroupSeparator": ",", "PositivePattern": 0, "Symbol": "€" }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text13", "Guid": "5d7eb489470a33bc9ebd55cd46ab97db", "ClientRectangle": "11.6,0,4.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{payment.name}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Segoe UI Semibold;10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text50", "Guid": "c75e6d26f88ccde1d9feaf321eccedba", "CanGrow": true, "ClientRectangle": "0.2,0,11.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{payment.invoicetext}" }, "VertAlignment": "Center", "Font": "Segoe UI;10;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true } } }, "DataSourceName": "payment", "DataRelationName": "[Not Assigned]" }, "16": { "Ident": "StiDataBand", "Name": "DataBand9", "ClientRectangle": "0,31.2,19,3.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiPanel", "Name": "Panel1", "ClientRectangle": "12,0,7,4", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiDataBand", "Name": "DataBand8", "CanShrink": true, "ClientRectangle": "0,0.4,7,3.4", "Conditions": { "0": { "Ident": "StiCondition", "Column": "invoice.barcode", "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiBarCode", "Name": "BarCode1", "ClientRectangle": "3.2,0.4,3.6,2.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "AutoScale": true, "BarCodeType": { "Ident": "StiQRCodeBarCodeType", "ImageMultipleFactor": 0 }, "Code": { "Value": "{invoice.barcode}" } } }, "DataSourceName": "invoice", "DataRelationName": "[Not Assigned]" } } }, "1": { "Ident": "StiText", "Name": "Text40", "Guid": "2cf61872220651319d3aaa30d28b7a83", "CanGrow": true, "ClientRectangle": "0.2,0.4,11.6,3.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Diese Rechnung wurde erstellt von : {invoice.name}\r\n\r\n\"Verkauf von Skikursen - verleih, Schipässen und Beauty auf\r\nfremde Rechnung und in fremden Namen\"\r\n\r\nWir bedanken uns für Ihren Besuch und freuen uns auf\r\nein Wiedersehen mit Ihnen!" }, "Font": "Segoe UI;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "Type": "Expression" } }, "DataSourceName": "invoice" } }, "PaperSize": "A4", "LargeHeight": true, "PageWidth": 21, "PageHeight": 29.7, "Watermark": { "Font": ";;Bold;", "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }