Interpretation MS SQL 9DK1SERLQ8hDTJyByUzgXtFUt4lFTbsZYlropWEtNT/R8vcJS2hxmX9GudzqbHVj5VbPL04FqZB/W7ls6QCkbsM6+YxnA6P1QxroqfvY43vTVOHrRlnT8OEf9a1nXLRe4xrNwmdrMflGBimY8mysp9F+Uw== 600898cb0f834a3985b6c412ecdc7c01 MS SQL v_tab_r006 ORIGINAL,ContractID,ContractID,ContractID,System.Int32,_x0036_2a7040fedfa44b3aa5c50406c603038 ORIGINAL,SapBudgetRef,SapBudgetRef,SapBudgetRef,System.String,_x0033_cf06a6cbb0941d793a4e84c88b819aa ORIGINAL,ContractName,ContractName,ContractName,System.String,_x0033_8f6b1e6d934431592e60a24e85004a6 ORIGINAL,ContractCatName,ContractCatName,ContractCatName,System.String,_x0038_a6375362cb14a85859009d70fe237b9 ORIGINAL,PeriodIDx,PeriodIDx,PeriodIDx,System.Int32,_x0032_58138f6ad694bfa95ee494f360c4fcc ORIGINAL,FiscalYear,FiscalYear,FiscalYear,System.Int32,e963fea1a02a4c4e94a3cda67ccdfe6f ORIGINAL,FiscalMonth,FiscalMonth,FiscalMonth,System.Int32,_x0035_9d71843e690441498240b2c49c2fbef ORIGINAL,TransDate,TransDate,TransDate,System.DateTime,_x0032_f2ec8d259fb4cc58fdf39473e836c07 ORIGINAL,DocType,DocType,DocType,System.String,_x0034_1cfc9f3b27f4fdd9d7bc98ffe0bbe4b ORIGINAL,CurrencyName,CurrencyName,CurrencyName,System.String,b3817659723b4269a74093917c52815c ORIGINAL,TransAmt,TransAmt,TransAmt,System.Decimal,_x0033_cbe59e7cff84cbf8b30b336d39616af ORIGINAL,FxContract,FxContract,FxContract,System.Decimal,_x0038_9e15f66d8f240138eb10265d7c7f43f ORIGINAL,ContractStart,ContractStart,ContractStart,System.DateTime,_x0033_0e4d18d670b4b09ab0da436be61c67f ORIGINAL,ContractProjectStatusName,ContractProjectStatusName,ContractProjectStatusName,System.String,e81b797e1a6a4bc5aba3fef61dcebbf2 ORIGINAL,WorkGroupName,WorkGroupName,WorkGroupName,System.String,a9b1c6781b3644eb82d0d49f937afb95 ORIGINAL,AmtContract,AmtContract,AmtContract,System.Decimal,e5304e8c06384a5b82df90164f63fae2 ORIGINAL,ContractEnd,ContractEnd,ContractEnd,System.DateTime,_x0032_0da63aedcef49e8bbecaed6d23a85b4 ORIGINAL,OrgUnitIDx,OrgUnitIDx,OrgUnitIDx,System.String,fb9310f1095d4c0788a3817e9e8ab9a7 ORIGINAL,OrgUnitName,OrgUnitName,OrgUnitName,System.String,e9edc1f08ef14f67a30c7e1269f86082 ORIGINAL,OrgPartCode,OrgPartCode,OrgPartCode,System.String,_x0038_e13b6e3e2dc472996624f2783ab6561 ORIGINAL,OrgPartName,OrgPartName,OrgPartName,System.String,f8231823fe4d4c48a1bd32d25e5a258f ORIGINAL,TaxID,TaxID,TaxID,System.String,_x0035_dd8755baa1d4c24a911e19e37e7da57 ORIGINAL,Name,Name,Name,System.String,_x0031_85d514f2d7141ce8380331c59d92010 ORIGINAL,CustomerCatName,CustomerCatName,CustomerCatName,System.String,_x0039_68185cba088472ab42b92be10a70bc0 ORIGINAL,TransactionTypeName,TransactionTypeName,TransactionTypeName,System.String,a1f2e0363f084167a6558c46a60b0077 ORIGINAL,Resp_Person,Resp_Person,Resp_Person,System.String,b8c099193a724702b4b665b6106632f3 ORIGINAL,งวด,งวด,งวด,System.Int32,cc0bc5beb3234847adddbf98d59e9d7a ORIGINAL,ContractProjectStatusID,ContractProjectStatusID,ContractProjectStatusID,System.Int32,_x0033_3a7071932804168bb17dd8b83fda8ce ORIGINAL,PlanPeriod,PlanPeriod,PlanPeriod,System.Int32,_x0037_586212887e845b0a302592f94ec5efd ORIGINAL,PlanPeriodType,PlanPeriodType,PlanPeriodType,System.String,bbc6c2cc89d1465d829e2078159e2beb ORIGINAL,ContractIDx,ContractIDx,ContractIDx,System.String,_x0039_2245d5d3caf45d282658e1d0673f633 ORIGINAL,CustomerIDx,CustomerIDx,CustomerIDx,System.String,_x0032_bbf3d973e9c4e09a4180462f794070e ORIGINAL,CustomerAttribute01Name,CustomerAttribute01Name,CustomerAttribute01Name,System.String,aa27076c0c6e451c8c0c561963e87b69 ORIGINAL,CustomerAttribute04Name,CustomerAttribute04Name,CustomerAttribute04Name,System.String,bc447b0f09f547fca63556abd5b78c69 ORIGINAL,ContractAttribute01Name,ContractAttribute01Name,ContractAttribute01Name,System.String,_x0034_c27917c86434945b56403aa813f19df ORIGINAL,Contract_Att01_Desc,Contract_Att01_Desc,Contract_Att01_Desc,System.String,_x0031_a9d681df7d3412fa3e9b11a5407efc6 ORIGINAL,ContractAttribute02Name,ContractAttribute02Name,ContractAttribute02Name,System.String,b41672ada6154020b5abfbe54b7ceb99 ORIGINAL,Contract_Att02_Desc,Contract_Att02_Desc,Contract_Att02_Desc,System.String,c00d6f6d541048da9a3e462d3717a6ea ORIGINAL,BudgetUsedIVAT,BudgetUsedIVAT,BudgetUsedIVAT,System.Decimal,_x0032_ac1fbcb24a3419a865814bc14f7d3ab CALC,THB_AMT,THB_AMT,System.Decimal,IIF_x0028_v_tab_r006.CurrencyName_x0020__x003D__x003D__x0020__x0022_Thai_x0020_Baht_x0022__x002C_v_tab_r006.TransAmt_x002C__x000D__x000A_v_tab_r006.TransAmt_x0020__x002A__x0020_v_tab_r006.FxContract_x0029_,fa3c0cf51d8148faaa6eeef291bb179e CALC,L_WG,กลุ่มงาน,System.String,IIF_x0028_v_tab_r006.WorkGroupName_x0020__x003D__x003D__x0020__x0022__x0022__x002C__x0022_อื่นๆ_x0022__x002C_Replace_x0028_Replace_x0028_Right_x0028_v_tab_r006.WorkGroupName_x002C_5_x0029__x002C__x0022__x0028__x0022__x002C__x0022__x0022__x0029__x002C__x0022__x0029__x0022__x002C__x0022__x0022__x0029__x0029_,_x0030_1edef00f39d4e7886b62da5e9f214b6 CALC,L_TQUART,ไตรมาส,System.String,IIF_x0028_v_tab_r006.TransDate_x003D__x003D__x0022__x0022__x002C__x0022_Q1_x0022__x002C_Switch_x0028_Month_x0028_v_tab_r006.TransDate_x0029__x003C_4_x002C__x0022_Q2_x0022__x002C_Month_x0028_v_tab_r006.TransDate_x0029__x003C_7_x002C__x0022_Q3_x0022__x002C_Month_x0028_v_tab_r006.TransDate_x0029__x003C_10_x002C__x0022_Q4_x0022__x002C_Month_x0028_v_tab_r006.TransDate_x0029__x003C_13_x002C__x0022_Q1_x0022__x0029__x0029_,c286c5691f974b4193df2077bf009d72 CALC,L_TYEAR,ปีงบประมาณ,System.Int32,IIF_x0028_Month_x0028_v_tab_r006.TransDate_x0029__x003E_9_x002C_Year_x0028_v_tab_r006.TransDate_x0029__x002B_544_x002C_Year_x0028_v_tab_r006.TransDate_x0029__x002B_543_x0029_,c75185000c1b4f2580e4bbecbbcde6a4 CALC,L_LPLNAMT,แผน,System.Decimal,IIF_x0028_v_tab_r006.DocType_x0020__x003D__x003D__x0020__x0022_P_x0022__x002C_v_tab_r006.THB_AMT_x002C_0_x0029_,_x0030_9a0d3a2ad8b4bb6a16982e7406a7780 CALC,L_LACTAMT,ผล,System.Decimal,IIF_x0028_v_tab_r006.DocType_x0020__x0021__x003D__x0020__x0022_P_x0022__x002C_v_tab_r006.THB_AMT_x002C_0_x0029_,_x0037_297bc4de69f4d17a4bd83f94b5e2a0c CALC,L_LRMNAMT,คงเหลือ,System.Decimal,v_tab_r006.L_LPLNAMT_x0020_-_x0020_v_tab_r006.L_LACTAMT,_x0034_42bdcbf87dc415ab49b6c5dcd5686b3 30 3dd2254400b04219bfc1813f640ec75d v_tab_r006 MS SQL SELECT * FROM v_tab_r006 WHERE v_tab_r006.TransDate <> '' ศูนย์สำนัก ORIGINAL,OrgUnitID,OrgUnitID,OrgUnitID,System.Int32,f7f47068a51c4f9596951e00eaf4dcbd ORIGINAL,OrgUnitName,OrgUnitName,OrgUnitName,System.String,e57c3f83d18446428f505f44c95ceb45 ORIGINAL,OrgUnitIDx,OrgUnitIDx,OrgUnitIDx,System.String,df5e269865b846a5b10ad99ca0fcde32 ORIGINAL,OrgUnitName2,OrgUnitName2,OrgUnitName2,System.String,_x0035_2e036101fd54f41971eaf8da0c91e2e 30 622c0fe21c5349238c28168f51ccfa18 OrgUnits MS SQL select OrgUnitID, OrgUnitName, OrgUnitIDx, OrgUnitName2 from OrgUnits True ศูนย์ฯและสำนักฯ OrgUnitIDx a4b965a95ca14f63b44aeb2af027523d R_ORGUNT R_ORGUNT OrgUnitIDx ,PFISCYR,เลือกปีงบประมาณ,,System.String,Year_x0028_Today_x0029__x002B_543,False,True,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_SortField_x003E_Key_x003C__x002F_SortField_x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_v_tab_r006.L_TYEAR_x003C__x002F_KeysColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_CheckedStates_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,efb794afb361461f9c8180ecf2473263 EngineV2 388ab11fca344a628374b2b03ddd6654 เก็บรายได้ Transparent 0,0,0,0 Transparent 0,0,600,900 ภาพรวม วว 0,0,0,0 Transparent Transparent Transparent Arial,8 Transparent Arial,8 v_tab_r006.L_TQUART 0ae2fd32caea4e9588f9f6a623d1a7aa ไตรมาส Transparent 20,20,560,260 False None True 67b6e92a19cd44f68e48020bd4bf8105 v_tab_r006.L_TYEAR PFISCYR 0 6497694028cd4a198350397dbbd73d0a Arial,8 Transparent

Transparent Arial,8 False

3,3,3,3 Chart1 5,5,5,5 True 0 , 1 DecimalDigits, Abbreviation Sum(v_tab_r006.L_LPLNAMT) 8bda2b8d3ab648f484625282a2127f5f แผน Sum(v_tab_r006.L_LACTAMT) c20db97787ea41748bad36f24a07a533 ผล สรุปตามกลุ่มงาน 0,0,0,0 Transparent 20,320,560,300 v_tab_r006.L_TQUART Right 545cdeef37cd4b12b4aa2bb4a4462714 ไตรมาส False TISTR_CT01 True b77dfab5a4ba461db8978303794d930e v_tab_r006.L_TYEAR PFISCYR 0 d6e2bfaa837344fc8f7c26a3aaa3a722 3,3,3,3 PivotTable1 5,5,5,5 Transparent NotEqualTo TH Sarabun New,10,Bold Maroon 545cdeef37cd4b12b4aa2bb4a4462714 Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor Black 0 Transparent NotEqualTo TH Sarabun New,10,Bold Maroon c85f804cabce40cdbdcc0c5557bfd0d1 Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor Black 0 242, 242, 242 NotEqualTo TH Sarabun New,10 Maroon 66e4a68501c14d7287952140021854fb Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor Black 0 Transparent NotEqualTo TH Sarabun New,10 Maroon bcd6381d8e8a419ea0e09b02550727d3 Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor Black 0 v_tab_r006.L_WG Right c85f804cabce40cdbdcc0c5557bfd0d1 กลุ่มงาน False Sum(v_tab_r006.L_LPLNAMT) Center bcd6381d8e8a419ea0e09b02550727d3 แผน 2 , 1 Sum(v_tab_r006.L_LACTAMT) Center 66e4a68501c14d7287952140021854fb ผล 2 , 1 0,0,0,0 Transparent 20,280,560,40 127, 127, 127 2cfabfce2fdb4f2d9ef301065c7861e7 3,3,3,3 Text1 0,0,0,0 <font face="TH Sarabun New" size="14"><text-align="Left">รายได้ตามกลุ่มงาน (แผน/ผล)</text-align></font> 57b080bb05b5468a9e4b08dfbb3f4412 3,3,3,3 Panel1 0,0,0,0 0,0,0,0 Transparent 600,0,680,900 0,0,0,0 Transparent 20,340,660,180 ApplyFilter OrgUnits.OrgUnitName Transparent 80ca4a981bd24534a571a955a635fc38 ศูนย์ฯและสำนักฯ Sum(v_tab_r006.L_LPLNAMT) Transparent Right e9dcf7dc26374569874dbc6f4d967247 แผน True 2 , 1 Sum(v_tab_r006.L_LACTAMT) Transparent Right 8c81d51fdefd4c79979e7d323b78ed43 ผล True Sum(v_tab_r006.L_LRMNAMT) Transparent Right 7927b4bccf5c49119dd8dcbc27684a85 คงเหลือ True DistinctCount(v_tab_r006.ContractID) Transparent Right f36ddd779e574815837014e22664a584 จำนวน True 0 , 1 False True False True False True 2095b33b6905420ab3e064f6681b7474 v_tab_r006.L_TYEAR PFISCYR 0 TH Sarabun New,10 TH Sarabun New,10,Bold Transparent Transparent 33f3c094783d4e7cac25038440e20187 TH Sarabun New,10,Bold Transparent 3,3,3,3 Table1 5,5,5,5 0,0,0,0 Transparent Transparent Transparent Arial,8 Transparent Arial,8 OrgUnits.OrgUnitName 17a0c0a269c84b7397ee54206368dcb2 ศูนย์ฯ/สำนักฯ Transparent 20,40,660,300 None True 2e5179b3750e40ca8d4eaf0c14383018 v_tab_r006.L_TYEAR PFISCYR 0 eb35d2b0def3495b8402893174af26d7 TH Sarabun New,8 Transparent

Transparent TH Sarabun New,10

3,3,3,3 Chart2 5,5,5,5 True 0 , 1 DecimalDigits, Abbreviation Sum(v_tab_r006.L_LPLNAMT) f5e3418d00fa4f47b7ca9e20d43d51c0 แผน Sum(v_tab_r006.L_LACTAMT) 7cd4d0d0d0374953a687199452b6c35f ผล Sum(v_tab_r006.L_LRMNAMT) 4f415a4e79e24cb9b4bd84c4d6bfd3c3 คงเหลือ DistinctCount(v_tab_r006.ContractID) aaa5086a931e4742a8fa4deb18068e9e จำนวน 0,0,0,0 Transparent 20,0,480,40 Transparent d3ab5017d10d4db3a53d323bea96f12d 3,3,3,3 Text2 0,0,0,0 <font face="TH Sarabun New" size="14"><text-align="Left">ข้อมูลประมาณการเรียกเก็บรายได้ตามศูนย์ฯและสำนักฯ (แผน/ผล)</text-align></font> 0,0,0,0 Transparent 20,520,660,260 OrgUnits.OrgUnitName a5c0dd42a97b47adbfcd45570d7d277c ศูนย์ฯและสำนักฯ False แผน False IsNotBlank d5278053219c4e0490e610c2773eb357 v_tab_r006.L_TQUART True 001dcd1f36d8474f8289a88bf1d6d60a v_tab_r006.L_TYEAR PFISCYR 0 3bfeadaebe72488eaa03984cf597762c 3,3,3,3 PivotTable2 5,5,5,5 242, 242, 242 NotEqualTo TH Sarabun New,10 Maroon 51be97bd2a2845cda95995c1babb2837 Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor Black 0 Transparent NotEqualTo TH Sarabun New,10 Maroon 5ea03cd925b448bca602bda53c44eeae Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor Black 0 v_tab_r006.L_TQUART 72f2cca5331443a88601a9557cc84798 ไตรมาส False Sum(v_tab_r006.L_LPLNAMT) Center 5ea03cd925b448bca602bda53c44eeae แผน 2 , 1 Sum(v_tab_r006.L_LACTAMT) Center 51be97bd2a2845cda95995c1babb2837 ผล 2 , 1 โครงการปิดในปี 0,0,0,0 Transparent 20,780,660,80 OrgUnits.OrgUnitName c87b337acb0e4946b46c72b184fb6ebe โครงการปิดแล้ว ในปี False 118d73816fe146d180c2683c111e6b46 v_tab_r006.ContractProjectStatusName ปิดโครงการ 8fafdd44035d4cffa4cf00e02de00fa3 v_tab_r006.ContractProjectStatusName ยกเลิกโครงการ True 8e873e3d32354df688b3f767257e1324 v_tab_r006.L_TYEAR PFISCYR 0 2d7f41fe241744e28c2367f391085cd3 3,3,3,3 PivotTable3 5,5,5,5 Sum(v_tab_r006.L_LACTAMT) Center 906f7e71f81943b781f50847a663d95d รับชำระ 2 , 1 DistinctCount(v_tab_r006.ContractID) Center 7ba90fb1aea143298579dfbeeb4aa2d4 จำนวน e9c8dbc92315476394b509bf36f71bc5 3,3,3,3 Panel2 0,0,0,0 933a054971a345a295f99ef66897d58d 900 DT01 1300 คู่สัญญาแหล่งทุน Transparent 586f541c14ee44ecb440efb566651946 DT02 MOU Transparent f7633ae3e742477ab1fb12e815e1396b DT03 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll TISTR_DASHBOARD 10/4/2021 8:12:46 AM 10/3/2021 10:17:21 AM C:\Users\lee_v\OneDrive\SFIT\1-Project Documents\TISTR\2021 ระบบบริหารสัญญา ส่วนขยาย\D02-เอกสารส่งมอบ\TISTR_MAIN.mrt e6d5c4938ff74070adcc3d795fa185c0 Report Inches 2021.3.7.0 CSharp 238, 238, 238 34, 34, 34 White White 50, 58, 69 54, 96, 146 White CrossTab GroupHeader ComponentType, Placement Style based on formating of 'PivotTable1' component 22, 122, 189 22, 122, 189 Gainsboro TISTR_CT01 127, 127, 127 238, 238, 238 82, 182, 249 White