{ "ReportVersion": "2023.4.3.0", "ReportGuid": "3ed64e482bfb4df495259f8f8e5ad25f", "ReportName": "Cari Ekstre (Stoklu)", "ReportAlias": "Cari Ekstre (Stoklu)", "ReportCreated": "/Date(1607926811000+0300)/", "ReportChanged": "/Date(1674134816179+0300)/", "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 Cari_Hesap_Ekstresi : Stimulsoft.Report.StiReport\r\n {\r\n public Cari_Hesap_Ekstresi() {\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": { "Variables": { "0": { "Name": "S_ACTID", "Alias": "Ünvan Seçin.", "Type": "System.String", "RequestFromUser": true, "Key": "4fdb6bed92d74c32a48bc469360c50fe", "AllowUseAsSqlParameter": true, "DialogInfo": { "SortField": "Key", "ItemsInitializationType": "Columns", "KeysColumn": "QActList.ACTID", "ValuesColumn": "QActList.ACTNAME" } }, "1": { "Value": "Today.AddDays(-30) ", "Name": "S_Start_Date", "Alias": "Başlangıç Tarihi", "Type": "System.DateTime", "RequestFromUser": true, "InitBy": "Expression", "Key": "3093cdbc95274d1e91a9df35e299f672", "AllowUseAsSqlParameter": true, "DialogInfo": { "SortDirection": "None" } }, "2": { "Value": "Today.AddDays(0) ", "Name": "S_End_Date", "Alias": "Bitiş Tarihi", "Type": "System.DateTime", "RequestFromUser": true, "InitBy": "Expression", "Key": "c965b9b875f04970ba357af1cafba023", "AllowUseAsSqlParameter": true, "DialogInfo": { "SortDirection": "None" } }, "3": { "Value": "18", "Name": "D_COMPANYID", "Alias": "Şirket Id", "Type": "System.Int32" }, "4": { "Value": "20", "Name": "D_CPERIODID", "Alias": "Dönem Id", "Type": "System.Int32" }, "5": { "Value": "22", "Name": "D_DEPOTID", "Alias": "Depo Id", "Type": "System.Int32" }, "6": { "Value": "1", "Name": "D_EMPLOYEEID", "Alias": "Personel Id", "Type": "System.Int32" }, "7": { "Value": "8", "Name": "D_USERID", "Alias": "Kullanıcı Id", "Type": "System.Int32" } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "Company", "Alias": "Company", "Key": "7b1517bd33e1483aa065f1224c6699d9", "Columns": { "0": { "Name": "COMPANYID", "Index": -1, "NameInSource": "COMPANYID", "Alias": "COMPANYID", "Type": "System.Int32" }, "1": { "Name": "COMPANYTYPE", "Index": -1, "NameInSource": "COMPANYTYPE", "Alias": "COMPANYTYPE", "Type": "System.Int16" }, "2": { "Name": "COMPANYNO", "Index": -1, "NameInSource": "COMPANYNO", "Alias": "COMPANYNO", "Type": "System.String", "Key": "7de7ccb6bf7c4d678ccf71aef7d11077" }, "3": { "Name": "COMPANYNAME", "Index": -1, "NameInSource": "COMPANYNAME", "Alias": "COMPANYNAME", "Type": "System.String" }, "4": { "Name": "GROUPCODE", "Index": -1, "NameInSource": "GROUPCODE", "Alias": "GROUPCODE", "Type": "System.String" }, "5": { "Name": "SPECCODE1", "Index": -1, "NameInSource": "SPECCODE1", "Alias": "SPECCODE1", "Type": "System.String" }, "6": { "Name": "SPECCODE2", "Index": -1, "NameInSource": "SPECCODE2", "Alias": "SPECCODE2", "Type": "System.String" }, "7": { "Name": "EMPLOYEEID", "Index": -1, "NameInSource": "EMPLOYEEID", "Alias": "EMPLOYEEID", "Type": "System.Int32" }, "8": { "Name": "STATUS", "Index": -1, "NameInSource": "STATUS", "Alias": "STATUS", "Type": "System.Int16" }, "9": { "Name": "NOTEID", "Index": -1, "NameInSource": "NOTEID", "Alias": "NOTEID", "Type": "System.Int32" }, "10": { "Name": "CANCELDATE", "Index": -1, "NameInSource": "CANCELDATE", "Alias": "CANCELDATE", "Type": "System.DateTime" }, "11": { "Name": "DESCRIPTION", "Index": -1, "NameInSource": "DESCRIPTION", "Alias": "DESCRIPTION", "Type": "System.String" }, "12": { "Name": "CONTACTNAME", "Index": -1, "NameInSource": "CONTACTNAME", "Alias": "CONTACTNAME", "Type": "System.String" }, "13": { "Name": "PHONEAREACODE", "Index": -1, "NameInSource": "PHONEAREACODE", "Alias": "PHONEAREACODE", "Type": "System.String" }, "14": { "Name": "PHONE1", "Index": -1, "NameInSource": "PHONE1", "Alias": "PHONE1", "Type": "System.String" }, "15": { "Name": "PHONE2", "Index": -1, "NameInSource": "PHONE2", "Alias": "PHONE2", "Type": "System.String" }, "16": { "Name": "FAX", "Index": -1, "NameInSource": "FAX", "Alias": "FAX", "Type": "System.String" }, "17": { "Name": "GSM", "Index": -1, "NameInSource": "GSM", "Alias": "GSM", "Type": "System.String" }, "18": { "Name": "EMAIL", "Index": -1, "NameInSource": "EMAIL", "Alias": "EMAIL", "Type": "System.String" }, "19": { "Name": "WEB", "Index": -1, "NameInSource": "WEB", "Alias": "WEB", "Type": "System.String" }, "20": { "Name": "TAXOFFICE", "Index": -1, "NameInSource": "TAXOFFICE", "Alias": "TAXOFFICE", "Type": "System.String" }, "21": { "Name": "TAXOFFICECODE", "Index": -1, "NameInSource": "TAXOFFICECODE", "Alias": "TAXOFFICECODE", "Type": "System.String" }, "22": { "Name": "TAXNO", "Index": -1, "NameInSource": "TAXNO", "Alias": "TAXNO", "Type": "System.String" }, "23": { "Name": "TAXCITY", "Index": -1, "NameInSource": "TAXCITY", "Alias": "TAXCITY", "Type": "System.String" }, "24": { "Name": "TICSICILNO", "Index": -1, "NameInSource": "TICSICILNO", "Alias": "TICSICILNO", "Type": "System.String" }, "25": { "Name": "MERSISNO", "Index": -1, "NameInSource": "MERSISNO", "Alias": "MERSISNO", "Type": "System.String" }, "26": { "Name": "COMPANYLOGO", "Index": -1, "NameInSource": "COMPANYLOGO", "Alias": "COMPANYLOGO", "Type": "System.Byte[]" }, "27": { "Name": "COMPANYSIGNLOGO", "Index": -1, "NameInSource": "COMPANYSIGNLOGO", "Alias": "COMPANYSIGNLOGO", "Type": "System.Byte[]" }, "28": { "Name": "COMPANYNAME2", "Index": -1, "NameInSource": "COMPANYNAME2", "Alias": "COMPANYNAME2", "Type": "System.String" }, "29": { "Name": "CURRCODE", "Index": -1, "NameInSource": "CURRCODE", "Alias": "CURRCODE", "Type": "System.String" }, "30": { "Name": "ADRESSID", "Index": -1, "NameInSource": "ADRESSID", "Alias": "ADRESSID", "Type": "System.Int32" }, "31": { "Name": "ADRESS1", "Index": -1, "NameInSource": "ADRESS1", "Alias": "ADRESS1", "Type": "System.String" }, "32": { "Name": "ADRESS2", "Index": -1, "NameInSource": "ADRESS2", "Alias": "ADRESS2", "Type": "System.String" }, "33": { "Name": "ADRESS3", "Index": -1, "NameInSource": "ADRESS3", "Alias": "ADRESS3", "Type": "System.String" }, "34": { "Name": "CITY", "Index": -1, "NameInSource": "CITY", "Alias": "CITY", "Type": "System.String" }, "35": { "Name": "COUNTRY", "Index": -1, "NameInSource": "COUNTRY", "Alias": "COUNTRY", "Type": "System.String" }, "36": { "Name": "TOWN", "Index": -1, "NameInSource": "TOWN", "Alias": "TOWN", "Type": "System.String" }, "37": { "Name": "POSTCODE", "Index": -1, "NameInSource": "POSTCODE", "Alias": "POSTCODE", "Type": "System.String" }, "38": { "Name": "STARTDATE", "Index": -1, "NameInSource": "STARTDATE", "Alias": "STARTDATE", "Type": "System.DateTime" }, "39": { "Name": "FINISHDATE", "Index": -1, "NameInSource": "FINISHDATE", "Alias": "FINISHDATE", "Type": "System.DateTime" }, "40": { "Name": "LASTPROCESSDATE", "Index": -1, "NameInSource": "LASTPROCESSDATE", "Alias": "LASTPROCESSDATE", "Type": "System.DateTime" }, "41": { "Name": "PROCESSDATECHN1", "Index": -1, "NameInSource": "PROCESSDATECHN1", "Alias": "PROCESSDATECHN1", "Type": "System.DateTime" }, "42": { "Name": "PROCESSDATECHN2", "Index": -1, "NameInSource": "PROCESSDATECHN2", "Alias": "PROCESSDATECHN2", "Type": "System.DateTime" }, "43": { "Name": "PROCESSDATECHN3", "Index": -1, "NameInSource": "PROCESSDATECHN3", "Alias": "PROCESSDATECHN3", "Type": "System.DateTime" }, "44": { "Name": "PARENTID", "Index": -1, "NameInSource": "PARENTID", "Alias": "PARENTID", "Type": "System.Int32" }, "45": { "Name": "ADVANCESECURITY", "Index": -1, "NameInSource": "ADVANCESECURITY", "Alias": "ADVANCESECURITY", "Type": "System.Boolean" }, "46": { "Name": "PARTNERFOTO", "Index": -1, "NameInSource": "PARTNERFOTO", "Alias": "PARTNERFOTO", "Type": "System.Boolean" }, "47": { "Name": "DEPARTMENT", "Index": -1, "NameInSource": "DEPARTMENT", "Alias": "DEPARTMENT", "Type": "System.Boolean" }, "48": { "Name": "INBOX", "Index": -1, "NameInSource": "INBOX", "Alias": "INBOX", "Type": "System.String" }, "49": { "Name": "OUTBOX", "Index": -1, "NameInSource": "OUTBOX", "Alias": "OUTBOX", "Type": "System.String" }, "50": { "Name": "MAXFILENO", "Index": -1, "NameInSource": "MAXFILENO", "Alias": "MAXFILENO", "Type": "System.Int32" }, "51": { "Name": "CENTREDEPARTMENT", "Index": -1, "NameInSource": "CENTREDEPARTMENT", "Alias": "CENTREDEPARTMENT", "Type": "System.Int32" }, "52": { "Name": "INVISIBLE", "Index": -1, "NameInSource": "INVISIBLE", "Alias": "INVISIBLE", "Type": "System.Boolean" }, "53": { "Name": "LASTAPPROVEACCDATE", "Index": -1, "NameInSource": "LASTAPPROVEACCDATE", "Alias": "LASTAPPROVEACCDATE", "Type": "System.DateTime" }, "54": { "Name": "LASTAPPROVERECEIPTID", "Index": -1, "NameInSource": "LASTAPPROVERECEIPTID", "Alias": "LASTAPPROVERECEIPTID", "Type": "System.Int32" }, "55": { "Name": "LASTAPPROVEACCTOTAL", "Index": -1, "NameInSource": "LASTAPPROVEACCTOTAL", "Alias": "LASTAPPROVEACCTOTAL", "Type": "System.Double" }, "56": { "Name": "STARTID", "Index": -1, "NameInSource": "STARTID", "Alias": "STARTID", "Type": "System.Int32" }, "57": { "Name": "STOPID", "Index": -1, "NameInSource": "STOPID", "Alias": "STOPID", "Type": "System.Int32" }, "58": { "Name": "TCKIMLIKNO", "Index": -1, "NameInSource": "TCKIMLIKNO", "Alias": "TCKIMLIKNO", "Type": "System.Double" }, "59": { "Name": "SENDAPPROVESUBE", "Index": -1, "NameInSource": "SENDAPPROVESUBE", "Alias": "SENDAPPROVESUBE", "Type": "System.Boolean" }, "60": { "Name": "IMPORTRECEIPT", "Index": -1, "NameInSource": "IMPORTRECEIPT", "Alias": "IMPORTRECEIPT", "Type": "System.Boolean" }, "61": { "Name": "IMPORTPATH", "Index": -1, "NameInSource": "IMPORTPATH", "Alias": "IMPORTPATH", "Type": "System.String" }, "62": { "Name": "EDICODE", "Index": -1, "NameInSource": "EDICODE", "Alias": "EDICODE", "Type": "System.String" }, "63": { "Name": "MMVERGINO", "Index": -1, "NameInSource": "MMVERGINO", "Alias": "MMVERGINO", "Type": "System.String" }, "64": { "Name": "MMUNVANI", "Index": -1, "NameInSource": "MMUNVANI", "Alias": "MMUNVANI", "Type": "System.String" }, "65": { "Name": "MMADI", "Index": -1, "NameInSource": "MMADI", "Alias": "MMADI", "Type": "System.String" }, "66": { "Name": "MMSOYADI", "Index": -1, "NameInSource": "MMSOYADI", "Alias": "MMSOYADI", "Type": "System.String" }, "67": { "Name": "MMTCKIMLIKNO", "Index": -1, "NameInSource": "MMTCKIMLIKNO", "Alias": "MMTCKIMLIKNO", "Type": "System.String" }, "68": { "Name": "MMTICSICILINO", "Index": -1, "NameInSource": "MMTICSICILINO", "Alias": "MMTICSICILINO", "Type": "System.String" }, "69": { "Name": "MMEMAIL", "Index": -1, "NameInSource": "MMEMAIL", "Alias": "MMEMAIL", "Type": "System.String" }, "70": { "Name": "MMALANKODU", "Index": -1, "NameInSource": "MMALANKODU", "Alias": "MMALANKODU", "Type": "System.String" }, "71": { "Name": "MMTELNO", "Index": -1, "NameInSource": "MMTELNO", "Alias": "MMTELNO", "Type": "System.String" }, "72": { "Name": "YMMVERGINO", "Index": -1, "NameInSource": "YMMVERGINO", "Alias": "YMMVERGINO", "Type": "System.String" }, "73": { "Name": "YMMADI", "Index": -1, "NameInSource": "YMMADI", "Alias": "YMMADI", "Type": "System.String" }, "74": { "Name": "YMMSOYADI", "Index": -1, "NameInSource": "YMMSOYADI", "Alias": "YMMSOYADI", "Type": "System.String" }, "75": { "Name": "YMMTCKIMLIKNO", "Index": -1, "NameInSource": "YMMTCKIMLIKNO", "Alias": "YMMTCKIMLIKNO", "Type": "System.String" }, "76": { "Name": "YMMTICSICILINO", "Index": -1, "NameInSource": "YMMTICSICILINO", "Alias": "YMMTICSICILINO", "Type": "System.String" }, "77": { "Name": "YMMEMAIL", "Index": -1, "NameInSource": "YMMEMAIL", "Alias": "YMMEMAIL", "Type": "System.String" }, "78": { "Name": "YMMALANKODU", "Index": -1, "NameInSource": "YMMALANKODU", "Alias": "YMMALANKODU", "Type": "System.String" }, "79": { "Name": "YMMTELNO", "Index": -1, "NameInSource": "YMMTELNO", "Alias": "YMMTELNO", "Type": "System.String" }, "80": { "Name": "SENDDOC", "Index": -1, "NameInSource": "SENDDOC", "Alias": "SENDDOC", "Type": "System.Boolean" }, "81": { "Name": "STARTFILTER", "Index": -1, "NameInSource": "STARTFILTER", "Alias": "STARTFILTER", "Type": "System.Boolean" }, "82": { "Name": "STARTFILTERDATE", "Index": -1, "NameInSource": "STARTFILTERDATE", "Alias": "STARTFILTERDATE", "Type": "System.DateTime" }, "83": { "Name": "TYPEOFTAXID", "Index": -1, "NameInSource": "TYPEOFTAXID", "Alias": "TYPEOFTAXID", "Type": "System.Int32" }, "84": { "Name": "SECIMSIRANO", "Index": -1, "NameInSource": "SECIMSIRANO", "Alias": "SECIMSIRANO", "Type": "System.Int32" }, "85": { "Name": "BAYILOGO", "Index": -1, "NameInSource": "BAYILOGO", "Alias": "BAYILOGO", "Type": "System.Byte[]" }, "86": { "Name": "EDEFTERSIRKETI", "Index": -1, "NameInSource": "EDEFTERSIRKETI", "Alias": "EDEFTERSIRKETI", "Type": "System.Boolean" }, "87": { "Name": "NACE", "Index": -1, "NameInSource": "NACE", "Alias": "NACE", "Type": "System.String" }, "88": { "Name": "SUBEKODU", "Index": -1, "NameInSource": "SUBEKODU", "Alias": "SUBEKODU", "Type": "System.String" }, "89": { "Name": "SUBEADI", "Index": -1, "NameInSource": "SUBEADI", "Alias": "SUBEADI", "Type": "System.String" }, "90": { "Name": "TELTURU", "Index": -1, "NameInSource": "TELTURU", "Alias": "TELTURU", "Type": "System.String" }, "91": { "Name": "BINAKAPINO", "Index": -1, "NameInSource": "BINAKAPINO", "Alias": "BINAKAPINO", "Type": "System.String" }, "92": { "Name": "MMFAXNO", "Index": -1, "NameInSource": "MMFAXNO", "Alias": "MMFAXNO", "Type": "System.String" }, "93": { "Name": "MMSOZTUR", "Index": -1, "NameInSource": "MMSOZTUR", "Alias": "MMSOZTUR", "Type": "System.String" }, "94": { "Name": "MMSOZTARIHI", "Index": -1, "NameInSource": "MMSOZTARIHI", "Alias": "MMSOZTARIHI", "Type": "System.String" }, "95": { "Name": "MMSOZNO", "Index": -1, "NameInSource": "MMSOZNO", "Alias": "MMSOZNO", "Type": "System.String" }, "96": { "Name": "MMBINAKAPINO", "Index": -1, "NameInSource": "MMBINAKAPINO", "Alias": "MMBINAKAPINO", "Type": "System.String" }, "97": { "Name": "MMCADDE", "Index": -1, "NameInSource": "MMCADDE", "Alias": "MMCADDE", "Type": "System.String" }, "98": { "Name": "MMSOKAK", "Index": -1, "NameInSource": "MMSOKAK", "Alias": "MMSOKAK", "Type": "System.String" }, "99": { "Name": "MMSEHIR", "Index": -1, "NameInSource": "MMSEHIR", "Alias": "MMSEHIR", "Type": "System.String" }, "100": { "Name": "MMPOSTAKODU", "Index": -1, "NameInSource": "MMPOSTAKODU", "Alias": "MMPOSTAKODU", "Type": "System.String" }, "101": { "Name": "MMULKE", "Index": -1, "NameInSource": "MMULKE", "Alias": "MMULKE", "Type": "System.String" }, "102": { "Name": "MMTELTURU", "Index": -1, "NameInSource": "MMTELTURU", "Alias": "MMTELTURU", "Type": "System.String" }, "103": { "Name": "LATITUDE", "Index": -1, "NameInSource": "LATITUDE", "Alias": "LATITUDE", "Type": "System.Double" }, "104": { "Name": "LONGITUDE", "Index": -1, "NameInSource": "LONGITUDE", "Alias": "LONGITUDE", "Type": "System.Double" }, "105": { "Name": "TIMEOFFSET", "Index": -1, "NameInSource": "TIMEOFFSET", "Alias": "TIMEOFFSET", "Type": "System.Int32" }, "106": { "Name": "ZONENAME", "Index": -1, "NameInSource": "ZONENAME", "Alias": "ZONENAME", "Type": "System.String" }, "107": { "Name": "GOAL_OEE", "Index": -1, "NameInSource": "GOAL_OEE", "Alias": "GOAL_OEE", "Type": "System.Double" }, "108": { "Name": "LASTOEECALC", "Index": -1, "NameInSource": "LASTOEECALC", "Alias": "LASTOEECALC", "Type": "System.DateTime" }, "109": { "Name": "LASTCONTDATE", "Index": -1, "NameInSource": "LASTCONTDATE", "Alias": "LASTCONTDATE", "Type": "System.DateTime" }, "110": { "Name": "NOLOGS", "Index": -1, "NameInSource": "NOLOGS", "Alias": "NOLOGS", "Type": "System.Boolean" }, "111": { "Name": "EDEFTER_DEVAM_NO", "Index": -1, "NameInSource": "EDEFTER_DEVAM_NO", "Alias": "EDEFTER_DEVAM_NO", "Type": "System.Int32" }, "112": { "Name": "EDEFTER_DEVAM_TARIH", "Index": -1, "NameInSource": "EDEFTER_DEVAM_TARIH", "Alias": "EDEFTER_DEVAM_TARIH", "Type": "System.DateTime" }, "113": { "Name": "ERECONCILEURL", "Index": -1, "NameInSource": "ERECONCILEURL", "Alias": "ERECONCILEURL", "Type": "System.String" }, "114": { "Name": "PUSHAPIKEY", "Index": -1, "NameInSource": "PUSHAPIKEY", "Alias": "PUSHAPIKEY", "Type": "System.String" }, "115": { "Name": "PUSHAPPID", "Index": -1, "NameInSource": "PUSHAPPID", "Alias": "PUSHAPPID", "Type": "System.String" }, "116": { "Name": "INSERTUSERID", "Index": -1, "NameInSource": "INSERTUSERID", "Alias": "INSERTUSERID", "Type": "System.Int32" }, "117": { "Name": "INSERTDATE", "Index": -1, "NameInSource": "INSERTDATE", "Alias": "INSERTDATE", "Type": "System.DateTime" }, "118": { "Name": "EDITUSERID", "Index": -1, "NameInSource": "EDITUSERID", "Alias": "EDITUSERID", "Type": "System.Int32" }, "119": { "Name": "EDITDATE", "Index": -1, "NameInSource": "EDITDATE", "Alias": "EDITDATE", "Type": "System.DateTime" }, "120": { "Name": "GLBALERTID", "Index": -1, "NameInSource": "GLBALERTID", "Alias": "GLBALERTID", "Type": "System.Int32" }, "121": { "Name": "TELEGRAMBOTID", "Index": -1, "NameInSource": "TELEGRAMBOTID", "Alias": "TELEGRAMBOTID", "Type": "System.String" } }, "NameInSource": "SysmondReports.Company" }, "1": { "Ident": "StiSqlSource", "Name": "QActList", "Alias": "QActList", "Key": "2311ec8a9d2941c8aa1d54b42b435768", "Columns": { "0": { "Name": "ACTID", "Index": -1, "NameInSource": "ACTID", "Alias": "ACTID", "Type": "System.Int32", "Key": "f7c195cdf3fa44148d6123ca1e04dde4" }, "1": { "Name": "ACTNO", "Index": -1, "NameInSource": "ACTNO", "Alias": "ACTNO", "Type": "System.String" }, "2": { "Name": "ACTNAME", "Index": -1, "NameInSource": "ACTNAME", "Alias": "ACTNAME", "Type": "System.String" }, "3": { "Name": "CONTACTNAME", "Index": -1, "NameInSource": "CONTACTNAME", "Alias": "CONTACTNAME", "Type": "System.String" }, "4": { "Name": "PHONE1", "Index": -1, "NameInSource": "PHONE1", "Alias": "PHONE1", "Type": "System.String" }, "5": { "Name": "FAX", "Index": -1, "NameInSource": "FAX", "Alias": "FAX", "Type": "System.String" }, "6": { "Name": "EMAIL", "Index": -1, "NameInSource": "EMAIL", "Alias": "EMAIL", "Type": "System.String" }, "7": { "Name": "CURRCODE", "Index": -1, "NameInSource": "CURRCODE", "Alias": "CURRCODE", "Type": "System.String" } }, "NameInSource": "SysmondReports", "ReconnectOnEachRow": true, "SqlCommand": "SELECT ACTID,ACTNO,ACTNAME,CONTACTNAME,PHONE1,FAX,EMAIL,CURRCODE FROM ACT \r\nWHERE COMPANYID = {D_COMPANYID}\r\n" }, "2": { "Ident": "StiSqlSource", "Name": "QActTranss", "Alias": "QActTranss", "Key": "91b86de9a26944059afac0665a895575", "Columns": { "0": { "Name": "ROOTRECEITNO", "Index": -1, "NameInSource": "ROOTRECEITNO", "Alias": "ROOTRECEITNO", "Type": "System.String", "Key": "97b0fdc746844d2ba4886da6d020ee3c" }, "1": { "Name": "TRANSDATE", "Index": -1, "NameInSource": "TRANSDATE", "Alias": "TRANSDATE", "Type": "System.DateTime", "Key": "d47ec70f0ee945028e75d35d46724416" }, "2": { "Name": "DUEDATE", "Index": -1, "NameInSource": "DUEDATE", "Alias": "DUEDATE", "Type": "System.DateTime", "Key": "0afe63c78670475998839b6f1dbacd0e" }, "3": { "Name": "DESCRIPTION", "Index": -1, "NameInSource": "DESCRIPTION", "Alias": "DESCRIPTION", "Type": "System.String", "Key": "3d42ecbacba745f196457ada7633ec5e" }, "4": { "Name": "COMPANYID", "Index": -1, "NameInSource": "COMPANYID", "Alias": "COMPANYID", "Type": "System.Int32", "Key": "159b9c7e3300453c90fb14388d520774" }, "5": { "Name": "DEBIT", "Index": -1, "NameInSource": "DEBIT", "Alias": "DEBIT", "Type": "System.Double", "Key": "0928081a8f7b482089a97498dc47daa2" }, "6": { "Name": "CREDIT", "Index": -1, "NameInSource": "CREDIT", "Alias": "CREDIT", "Type": "System.Double", "Key": "ab4eaf15116843e280a37e095ed0ed6d" }, "7": { "Name": "TRANSTYPENAME", "Index": -1, "NameInSource": "TRANSTYPENAME", "Alias": "TRANSTYPENAME", "Type": "System.String", "Key": "1cad62e1a51545e49d54a995a7f46b2a" }, "8": { "Name": "REMTOTAL", "Index": -1, "NameInSource": "REMTOTAL", "Alias": "REMTOTAL", "Type": "System.Double", "Key": "2be015abe80d4c25b3eab13c36c94bce" }, "9": { "Name": "BA", "Index": -1, "NameInSource": "BA", "Alias": "BA", "Type": "System.String", "Key": "52c25da0f317445c82e8e2fb0abe763e" }, "10": { "Name": "ROOTID", "Index": -1, "NameInSource": "ROOTID", "Alias": "ROOTID", "Type": "System.Int32", "Key": "caa89db2f9474143bea3da4d2d893ffc" }, "11": { "Name": "TRANSTYPE", "Index": -1, "NameInSource": "TRANSTYPE", "Alias": "TRANSTYPE", "Type": "System.Int32", "Key": "d006439d41894d98a7beb6998392ea9c" }, "12": { "Name": "ROWNUMBER_", "Index": -1, "NameInSource": "ROWNUMBER_", "Alias": "ROWNUMBER_", "Type": "System.Int32", "Key": "75d189de96ec447e9eecd593ab7349da" }, "13": { "Name": "ROOT", "Index": -1, "NameInSource": "ROOT", "Alias": "ROOT", "Type": "System.Int16", "Key": "7254c7591b8a4476b48297a99d6a7ec6" } }, "NameInSource": "SysmondReports", "SqlCommand": "DECLARE @I INT\r\nDECLARE @O INT\r\nDECLARE @EDEBIT FLOAT\r\nDECLARE @ECREDIT FLOAT\r\nDECLARE @REMTOTAL FLOAT\r\nDECLARE @DEVREMTOTAL FLOAT\r\nDECLARE @STARTDATE DATETIME\r\nDECLARE @ENDDATE DATETIME\r\nDECLARE @ACTID INT;\r\nDECLARE @COMPANYID INT;\r\nSET @COMPANYID ={D_COMPANYID}-- SIRKET PARAMETRE ID GONDER\r\nSET @ACTID = '{S_ACTID}' --CARI ID PARAMETRE GONDER\r\nSET @STARTDATE = CONVERT(DATETIME,'{S_Start_Date}',104) --BASLANGIC TARIHI PARAMETRE GONDER\r\nSET @ENDDATE = CONVERT(DATETIME,'{S_End_Date}',104) --BITIS TARIHI PARAMETRE GONDER\r\n\r\n\r\n\r\n\r\nDECLARE @ACTEX TABLE (\r\nROOTRECEITNO VARCHAR(20)\r\n,TRANSDATE DATETIME\r\n,DUEDATE DATETIME\r\n,DESCRIPTION VARCHAR(150)\r\n,COMPANYID INT\r\n,DEBIT FLOAT\r\n,CREDIT FLOAT\r\n,TRANSTYPENAME VARCHAR(50)\r\n,REMTOTAL FLOAT\r\n,BA CHAR(1)\r\n,ROOTID INT\r\n,TRANSTYPE INT\r\n,ROWNUMBER_ INT\r\n,ROOT SMALLINT\r\n)\r\n\r\n\r\n\r\nSELECT @REMTOTAL = 0\r\n,@ECREDIT = 0\r\n,@EDEBIT = 0;\r\n\r\n\r\n\r\nSELECT @EDEBIT = DEBIT\r\n,@ECREDIT = CREDIT\r\nFROM (\r\nSELECT @STARTDATE TRANSDATE\r\n,@STARTDATE DUEDATE\r\n,'' DESCRIPTION\r\n,@COMPANYID COMPANYID\r\n,'0' ROOTRECEIPTNO\r\n,0 ROOTID\r\n,0 ROOT\r\n,0 TRANSTYPE\r\n,'Devir' TRANSTYPENAME\r\n,CASE WHEN sum(DEBIT-CREDIT) >0 THEN ISNULL(sum(DEBIT-CREDIT),0) END DEBIT\r\n,CASE WHEN sum(DEBIT-CREDIT) <0 THEN ISNULL(sum(DEBIT-CREDIT),0) END CREDIT\r\n,0 AS RowNumber\r\nFROM VE_ACTTRANS\r\nWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE <= @STARTDATE\r\n) AS TMP\r\n\r\n\r\n\r\n\r\nIF @EDEBIT > 0\r\nSET @REMTOTAL = (@REMTOTAL + @EDEBIT)\r\nELSE\r\nSET @REMTOTAL = @ECREDIT\r\nSET @DEVREMTOTAL=@REMTOTAL\r\nIF (@REMTOTAL<>0)\r\nBEGIN\r\nINSERT INTO @ACTEX (\r\nROOTRECEITNO\r\n,TRANSDATE\r\n,DUEDATE\r\n,DESCRIPTION\r\n,COMPANYID\r\n,DEBIT\r\n,CREDIT\r\n,TRANSTYPENAME\r\n,ROOTID\r\n,TRANSTYPE\r\n,ROWNUMBER_\r\n,REMTOTAL\r\n,BA\r\n,ROOT\r\n) (\r\nSELECT ROOTRECEIPTNO\r\n\t,TRANSDATE\r\n\t,DUEDATE\r\n\t,DESCRIPTION\r\n\t,COMPANYID\r\n\t,ABS(ISNULL(DEBIT,0)) DEBIT\r\n,ABS(ISNULL(CREDIT,0)) CREDIT\r\n,TRANSTYPENAME\r\n,ROOTID\r\n,TRANSTYPE\r\n,RowNumber\r\n,ABS(@REMTOTAL)\r\n,(\r\nCASE\r\nWHEN @REMTOTAL < 0\r\nTHEN 'A'\r\nELSE 'B'\r\nEND\r\n) AS 'BA'\r\n,ROOT FROM (\r\nSELECT @STARTDATE TRANSDATE\r\n,'0' ROOTRECEIPTNO\r\n,0 ROOTID\r\n,0 ROOT\r\n,0 TRANSTYPE\r\n,'' DESCRIPTION\r\n,@COMPANYID COMPANYID\r\n,@STARTDATE DUEDATE\r\n,'Devir' TRANSTYPENAME\r\n,CASE WHEN sum(DEBIT-CREDIT) >0 THEN ISNULL(sum(DEBIT-CREDIT),0) END DEBIT\r\n,CASE WHEN sum(DEBIT-CREDIT) <0 THEN ISNULL(sum(DEBIT-CREDIT),0) END CREDIT\r\n,0 AS RowNumber\r\nFROM VE_ACTTRANS\r\nWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE <= @STARTDATE\r\n) tmp WHERE RowNumber = 0\r\n)\r\nEND\r\n--DEVİR EKLENDİ\r\n\r\n\r\n\r\nSET @I = (\r\nSELECT COUNT(1)\r\n\tFROM VE_ACTTRANS\r\n\tWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE > @STARTDATE\r\nAND TRANSDATE <= @ENDDATE\r\n)\r\nSET @O = 0\r\n\r\n\r\n\r\nPRINT @DEVREMTOTAL\r\nSELECT @REMTOTAL = ISNULL(@DEVREMTOTAL,0)\r\n,@ECREDIT = 0\r\n,@EDEBIT = 0;\r\n\r\n\r\n\r\nWHILE @O <= @I\r\nBEGIN\r\nSELECT @EDEBIT =ISNULL( DEBIT,0)\r\n,@ECREDIT = ISNULL(CREDIT,0)\r\nFROM (\r\nSELECT TRANSDATE\r\n\t,ROOTRECEIPTNO\r\n\t,ROOTID\r\n\t,ROOT\r\n\t,TRANSTYPE\r\n\t,TRANSTYPENAME\r\n\t,DESCRIPTION\r\n\t,COMPANYID\r\n\t,DUEDATE\r\n\t,ISNULL(DEBIT,0)DEBIT\r\n,ISNULL(CREDIT,0) CREDIT\r\n,ROW_NUMBER() OVER (\r\nORDER BY TRANSDATE\r\n,DEBIT\r\n) AS RowNumber\r\nFROM VE_ACTTRANS\r\nWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE > @STARTDATE\r\nAND TRANSDATE <= @ENDDATE\r\n\r\n) tmp\r\nWHERE RowNumber = @O\r\n\r\n\r\n\r\nPRINT @REMTOTAL\r\nPRINT @EDEBIT\r\nPRINT @ECREDIT\r\n\r\n\r\n\r\nIF @EDEBIT > 0\r\nSET @REMTOTAL = ( @REMTOTAL + @EDEBIT)\r\nELSE\r\nSET @REMTOTAL = ( @REMTOTAL - @ECREDIT)\r\n\r\n\r\n\r\nINSERT INTO @ACTEX (\r\nROOTRECEITNO\r\n,TRANSDATE\r\n,DESCRIPTION\r\n,COMPANYID\r\n,DUEDATE\r\n,DEBIT\r\n,CREDIT\r\n,TRANSTYPENAME\r\n,ROOTID\r\n,TRANSTYPE\r\n,ROWNUMBER_\r\n,REMTOTAL\r\n,BA\r\n,ROOT\r\n) (\r\nSELECT ROOTRECEIPTNO\r\n\t,TRANSDATE\r\n\t,DESCRIPTION\r\n\t,COMPANYID\r\n\t,DUEDATE\r\n\t,ISNULL(DEBIT,0) DEBIT\r\n,ISNULL(CREDIT,0) CREDIT\r\n,TRANSTYPENAME\r\n,ROOTID\r\n,TRANSTYPE\r\n,RowNumber\r\n,ABS(@REMTOTAL)\r\n,(\r\nCASE\r\nWHEN @REMTOTAL < 0\r\nTHEN 'A'\r\nELSE 'B'\r\nEND\r\n) AS 'BA'\r\n,ROOT FROM (\r\nSELECT ROOTRECEIPTNO\r\n\t,TRANSDATE\r\n\t,DESCRIPTION\r\n\t,COMPANYID\r\n\t,DUEDATE\r\n\t,ISNULL(DEBIT,0) DEBIT\r\n,ISNULL(CREDIT,0) CREDIT\r\n,TRANSTYPENAME\r\n,ROOTID\r\n,ROOT\r\n,TRANSTYPE\r\n,ROW_NUMBER() OVER (\r\nORDER BY TRANSDATE\r\n,DEBIT\r\n) AS RowNumber\r\nFROM VE_ACTTRANS\r\nWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE > @STARTDATE\r\nAND TRANSDATE <= @ENDDATE\r\n) tmp WHERE RowNumber = @O\r\n)\r\nSELECT @ECREDIT = 0\r\n,@EDEBIT = 0;\r\n\r\n\r\n\r\nSET @O = @O + 1\r\nEND\r\nDELETE FROM @ACTEX WHERE DEBIT = 0 AND CREDIT = 0\r\nSELECT *\r\n\tFROM @ACTEX" }, "3": { "Ident": "StiSqlSource", "Name": "QStockTrans", "Alias": "QStockTrans", "Key": "c4bfa653e8ab457daa8b84110d01f921", "Columns": { "0": { "Name": "COMPANYID", "Index": -1, "NameInSource": "COMPANYID", "Alias": "COMPANYID", "Type": "System.Int32" }, "1": { "Name": "ROOT", "Index": -1, "NameInSource": "ROOT", "Alias": "ROOT", "Type": "System.Int16" }, "2": { "Name": "ROOTID", "Index": -1, "NameInSource": "ROOTID", "Alias": "ROOTID", "Type": "System.Int32" }, "3": { "Name": "STOCKNO", "Index": -1, "NameInSource": "STOCKNO", "Alias": "STOCKNO", "Type": "System.String" }, "4": { "Name": "STOCKNAME", "Index": -1, "NameInSource": "STOCKNAME", "Alias": "STOCKNAME", "Type": "System.String" }, "5": { "Name": "QENTRY", "Index": -1, "NameInSource": "QENTRY", "Alias": "QENTRY", "Type": "System.Double" }, "6": { "Name": "QEXIT", "Index": -1, "NameInSource": "QEXIT", "Alias": "QEXIT", "Type": "System.Double" }, "7": { "Name": "PRICE", "Index": -1, "NameInSource": "PRICE", "Alias": "PRICE", "Type": "System.Double" }, "8": { "Name": "TOTAL", "Index": -1, "NameInSource": "TOTAL", "Alias": "TOTAL", "Type": "System.Decimal" } }, "NameInSource": "SysmondReports", "SqlCommand": "DECLARE @STARTDATE DATETIME\r\nDECLARE @ENDDATE DATETIME\r\nDECLARE @ACTID INT;\r\nDECLARE @COMPANYID INT;\r\nSET @COMPANYID ={D_COMPANYID}-- SIRKET PARAMETRE ID GONDER\r\nSET @ACTID = '{S_ACTID}' --CARI ID PARAMETRE GONDER\r\nSET @STARTDATE = CONVERT(DATETIME,'{S_Start_Date}',104) --BASLANGIC TARIHI PARAMETRE GONDER\r\nSET @ENDDATE = CONVERT(DATETIME,'{S_End_Date}',104) --BITIS TARIHI PARAMETRE GONDER\r\n\r\nSELECT COMPANYID,ROOT,ROOTID,STOCKNO,STOCKNAME,QENTRY,QEXIT,PRICE,TOTAL FROM VE_STOCKTRANS\r\n\tWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE >= @STARTDATE\r\nAND TRANSDATE <= @ENDDATE\r\n\r\n\tUNION ALL\r\n\r\nSELECT COMPANYID,ROOT,ROOTID,EXPREVNO,EXPREVNAME, 0,0,0,DEBIT FROM VE_EXPREVTRANS\r\n\tWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE >= @STARTDATE\r\nAND TRANSDATE <= @ENDDATE\r\nAND DEBIT >0\r\n\r\n\tUNION ALL\r\n\r\nSELECT COMPANYID,ROOT,ROOTID,EXPREVNO,EXPREVNAME, 0,0,0,CREDIT FROM VE_EXPREVTRANS\r\n\r\n\tWHERE ACTID = @ACTID\r\nAND COMPANYID = @COMPANYID\r\nAND TRANSDATE >= @STARTDATE\r\nAND TRANSDATE <= @ENDDATE\r\nAND CREDIT >0" } }, "Databases": { "0": { "Ident": "StiSqlDatabase", "Name": "SysmondReports", "Alias": "SysmondReports", "ConnectionStringEncrypted": "9Gx9yUZ8E/HiE9UYY3xk58Ru9Q9hGJKZ6W3V9Gd4oGLUbs9PXU3TyPFp7cx6XKd/3yS7609Zexn3E9ml4fglRtdYmcvHatO8elycyWdMJSrCVr+j103ZvGhpoaV3WKoP/nS1AsVrG83saS3cYWxiE9da1QLWCXrpaUTtyelcZQ/bNGWvUGvTDfJB7dxmAOtn31T1o8YFut3jYQ==" } }, "Relations": { "0": { "Name": "StokDetay", "ChildColumns": { "0": "COMPANYID", "1": "ROOT", "2": "ROOTID" }, "ParentColumns": { "0": "COMPANYID", "1": "ROOT", "2": "ROOTID" }, "NameInSource": "İlişkisi", "Alias": "StokDetay", "Key": "47487ab847fd4d9d8e3b618c3162d7d7", "ParentSource": "QActTranss", "ChildSource": "QStockTrans" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "b1466ff9c0744628a1f2b85f339625b2", "Interaction": { "Ident": "StiInteraction" }, "Border": "Top, Left, Right;;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageFooterBand", "Name": "PageFooterBand1", "ClientRectangle": "0,27.3,20,1.4", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text29", "ClientRectangle": "18.2,0.1,1.6,0.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNofM}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";6;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:White", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "Text30", "ClientRectangle": "0,0.1,20,1.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Company.ADRESS1} {Company.ADRESS2} {Company.ADRESS3} {Company.CITY} {Company.TOWN} {Company.COUNTRY} \r\nTel: {Company.PHONE1} {Company.PHONE2} Faks : {Company.FAX} GSM : {Company.GSM} E-Mail : {Company.EMAIL}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Top;;;;;;;solid:Black", "Brush": "solid:White", "TextBrush": "solid:Black", "Type": "Expression" } } }, "1": { "Ident": "StiReportTitleBand", "Name": "ReportTitleBand1", "ClientRectangle": "0,0.4,20,4.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "ClientRectangle": "0,0,20,1.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Cari Hesap Ekstresi (Stoklu)" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";12;Bold;", "Border": "All;;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text3", "ClientRectangle": "15.8,0,4.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{(Today)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService", "StringFormat": "g" }, "Type": "Expression" }, "2": { "Ident": "StiImage", "Name": "Image1", "ShiftMode": "DecreasingSize", "ClientRectangle": "0.2,0.2,3,1.4", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Stretch": true, "DataColumn": "Company.COMPANYLOGO" }, "3": { "Ident": "StiText", "Name": "Text2", "ClientRectangle": "0,1.2,20,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Company.COMPANYNAME}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "4": { "Ident": "StiText", "Name": "Text4", "ClientRectangle": "0.2,2,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Cari No-Ünvan" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:149,55,52", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text8", "ClientRectangle": "2.4,2,8.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": ": {QActList.ACTNO} \"-\" {QActList.ACTNAME}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:149,55,52", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text12", "ClientRectangle": "15,2,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Cari Kart Dövizi" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:149,55,52", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text15", "ClientRectangle": "17.2,2,2.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": ": {QActList.CURRCODE}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:149,55,52", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text5", "ClientRectangle": "0.2,2.4,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Yetkili Adı" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text9", "ClientRectangle": "2.4,2.4,8.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": ": {QActList.CONTACTNAME}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text6", "ClientRectangle": "0.2,2.8,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Tel/Fax" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text10", "ClientRectangle": "2.4,2.8,8.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": ": {QActList.PHONE1}\"/\"{QActList.FAX}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "12": { "Ident": "StiText", "Name": "Text7", "ClientRectangle": "0.2,3.2,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "E-Mail" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "13": { "Ident": "StiText", "Name": "Text11", "ClientRectangle": "2.4,3.2,8.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": ": {QActList.EMAIL}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "14": { "Ident": "StiText", "Name": "Text21", "CanGrow": true, "ClientRectangle": "0,3.8,1.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Tarih" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "Type": "Expression" }, "15": { "Ident": "StiText", "Name": "Text22", "CanGrow": true, "ClientRectangle": "3.2,3.8,1.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "İşlem Tipi" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "Type": "Expression" }, "16": { "Ident": "StiText", "Name": "Text23", "CanGrow": true, "ClientRectangle": "5,3.8,2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Fiş No" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "Type": "Expression" }, "17": { "Ident": "StiText", "Name": "Text24", "CanGrow": true, "ClientRectangle": "13.2,3.8,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Borç" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," }, "Type": "Expression" }, "18": { "Ident": "StiText", "Name": "Text25", "CanGrow": true, "ClientRectangle": "15.4,3.8,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Alacak" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," }, "Type": "Expression" }, "19": { "Ident": "StiText", "Name": "Text26", "CanGrow": true, "ClientRectangle": "1.6,3.8,1.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Vade" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "Type": "Expression" }, "20": { "Ident": "StiText", "Name": "Text27", "CanGrow": true, "ClientRectangle": "7,3.8,6.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Açıklama" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "Type": "Expression" }, "21": { "Ident": "StiText", "Name": "Text28", "CanGrow": true, "ClientRectangle": "17.6,3.8,2.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Bakiye" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Right, Bottom;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," }, "Type": "Expression" } }, "PrintIfEmpty": false }, "2": { "Ident": "StiDataBand", "Name": "DataQActTranss", "ClientRectangle": "0,5.4,20,0.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "DataQActTranss_TRANSDATE", "CanGrow": true, "ClientRectangle": "0,0,1.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.TRANSDATE}" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "DataQActTranss_DUEDATE", "CanGrow": true, "ClientRectangle": "1.6,0,1.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.DUEDATE}" }, "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "2": { "Ident": "StiText", "Name": "DataQActTranss_TRANSTYPENAME", "CanGrow": true, "ClientRectangle": "3.2,0,1.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.TRANSTYPENAME}" }, "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "3": { "Ident": "StiText", "Name": "DataQActTranss_ROOTRECEITNO", "CanGrow": true, "ClientRectangle": "5,0,2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.ROOTRECEITNO}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "4": { "Ident": "StiText", "Name": "DataQActTranss_DESCRIPTION", "CanGrow": true, "ClientRectangle": "7,0,6.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.DESCRIPTION}" }, "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "5": { "Ident": "StiText", "Name": "DataQActTranss_DEBIT", "CanGrow": true, "ClientRectangle": "13.2,0,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.DEBIT}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," } }, "6": { "Ident": "StiText", "Name": "DataQActTranss_CREDIT", "CanGrow": true, "ClientRectangle": "15.4,0,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.CREDIT}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," } }, "7": { "Ident": "StiText", "Name": "DataQActTranss_REMTOTAL", "CanGrow": true, "ClientRectangle": "17.6,0,2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.REMTOTAL}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," } }, "8": { "Ident": "StiText", "Name": "DataQActTranss_BA", "CanGrow": true, "ClientRectangle": "19.6,0,0.4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QActTranss.BA}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": "Bottom;;;Dash;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalDigits": 2, "GroupSeparator": "," } } }, "PrintIfDetailEmpty": true, "DataSourceName": "QActTranss" }, "3": { "Ident": "StiDataBand", "Name": "DataBand1", "CanShrink": true, "ClientRectangle": "0,6.6,20,0.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text13", "ClientRectangle": "5,0,2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QStockTrans.STOCKNO}" }, "VertAlignment": "Center", "Font": ";7;Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:127,127,127" }, "1": { "Ident": "StiText", "Name": "Text14", "ClientRectangle": "7,0,6.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QStockTrans.STOCKNAME}" }, "VertAlignment": "Center", "Font": ";7;Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:127,127,127" }, "2": { "Ident": "StiText", "Name": "Text17", "ClientRectangle": "13.2,0,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QStockTrans.QENTRY+QStockTrans.QEXIT}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:127,127,127", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text18", "ClientRectangle": "15.4,0,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QStockTrans.PRICE}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:127,127,127" }, "4": { "Ident": "StiText", "Name": "Text19", "ClientRectangle": "17.6,0,2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{QStockTrans.TOTAL}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:127,127,127" } }, "DataSourceName": "QStockTrans", "DataRelationName": "İlişkisi", "MasterComponent": "DataQActTranss" } }, "PaperSize": "A4", "PageWidth": 21.0, "PageHeight": 29.7, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 0.5, "Right": 0.5, "Top": 0.5, "Bottom": 0.5 }, "MirrorMargins": true } } }