<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Sybase_eDataWindow>
<Sybase_eDataWindow>
	<Release>9</Release>
	<BaseDefinition>
		<units>1</units>
		<timer_interval>0</timer_interval>
		<color>79741120</color>
		<processing>1</processing>
		<HTMLDW>no</HTMLDW>
		<print>
			<documentname></documentname>
			<printername></printername>
			<orientation>0</orientation>
			<margin>
				<left>24</left>
				<right>24</right>
				<top>24</top>
				<bottom>24</bottom>
			</margin>
			<paper>
				<source>0</source>
				<size>0</size>
			</paper>
			<prompt>no</prompt>
			<canusedefaultprinter>yes</canusedefaultprinter>
			<buttons>no</buttons>
			<preview.buttons>no</preview.buttons>
			<cliptext>no</cliptext>
			<overrideprintjob>no</overrideprintjob>
		</print>
		<grid.lines>0</grid.lines>
	</BaseDefinition>
	<Header>
		<height>22</height>
		<color>536870912</color>
	</Header>
	<Summary>
		<height>0</height>
		<color>536870912</color>
	</Summary>
	<Footer>
		<height>0</height>
		<color>536870912</color>
	</Footer>
	<Detail>
		<height>21</height>
		<color>536870912</color>
	</Detail>
	<TableDefinition>
		<table_column>
			<type size="6">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>acct_prd</name>
			<dbname>it_calchdr.acct_prd</dbname>
		</table_column>
		<table_column>
			<type size="10">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_code</name>
			<dbname>employee.emp_code</dbname>
		</table_column>
		<table_column>
			<type size="47">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_name</name>
			<dbname>emp_name</dbname>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>site_code</name>
			<dbname>employee.site_code</dbname>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>proc_group</name>
			<dbname>employee.proc_group</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>itax</name>
			<dbname>itax</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>taxpaid</name>
			<dbname>taxpaid</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>itpayable</name>
			<dbname>itpayable</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>itrefundable</name>
			<dbname>itrefundable</dbname>
		</table_column>
		<retrieve>PBSELECT( VERSION(400) TABLE(NAME=&quot;it_calchdr&quot; )  TABLE(NAME=&quot;employee&quot; )  TABLE(NAME=&quot;it_calcdet&quot; ALIAS=&quot;a&quot; )  TABLE(NAME=&quot;it_calcdet&quot; ALIAS=&quot;b&quot; ) COLUMN(NAME=&quot;it_calchdr.acct_prd&quot;) COLUMN(NAME=&quot;employee.emp_code&quot;) COMPUTE(NAME=&quot;employee.emp_fname || &apos; &apos; || employee.emp_mname || &apos; &apos; || employee.emp_lname as emp_name&quot;) COMPUTE(NAME=&quot;employee.pay_site as site_code&quot;) COMPUTE(NAME=&quot;employee.proc_group as proc_group&quot;) COMPUTE(NAME=&quot;nvl(a.amount,0) as itax&quot;) COMPUTE(NAME=&quot;(nvl(a.amount,0) -nvl(b.amount,0)) as taxpaid&quot;) COMPUTE(NAME=&quot;nvl(b.amount,0) as itpayable&quot;) COMPUTE(NAME=&quot;case when ddf_get_itrefund_amt(employee.emp_code,:as_prdcode,:as_it_ad_refund1,:as_it_ad_refund2,:ad_start_date,:ad_end_date) is null then 0 else ddf_get_itrefund_amt(employee.emp_code,:as_prdcode,:as_it_ad_refund1,:as_it_ad_refund2,:ad_start_date,:ad_end_date) end as itrefundable&quot;)    JOIN (LEFT=&quot;it_calchdr.emp_code&quot;    OP =&quot;=&quot;RIGHT=&quot;employee.emp_code&quot; )WHERE(    EXP1 =&quot;( it_calchdr.acct_prd&quot;   OP =&quot;=&quot;    EXP2 =&quot;:as_prdcode )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;nvl( it_calchdr.confirmed , &apos;N&apos; )&quot;   OP =&quot;=&quot;    EXP2 =&quot;&apos;Y&apos;&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;employee.emp_code&quot;   OP =&quot;between&quot;    EXP2 =&quot;:as_emp_fr and :as_emp_to&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;employee.pay_site&quot;   OP =&quot;between&quot;    EXP2 =&quot;:as_site_fr and :as_site_to&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;employee.proc_group&quot;   OP =&quot;between&quot;    EXP2 =&quot;:as_procgrp_fr and :as_procgrp_to&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;a.acct_prd&quot;   OP =&quot;=&quot;    EXP2 =&quot;:as_prdcode &quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;a.emp_code&quot;   OP =&quot;=&quot;    EXP2 =&quot;employee.emp_code&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;a.ad_code&quot;   OP =&quot;=&quot;    EXP2 =&quot;:as_it_ad_tottax&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;b.acct_prd&quot;   OP =&quot;=&quot;    EXP2 =&quot;:as_prdcode&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;b.emp_code&quot;   OP =&quot;=&quot;    EXP2 =&quot;employee.emp_code&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;b.ad_code&quot;   OP =&quot;=&quot;    EXP2 =&quot;:as_it_ad_payable&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;case when ddf_get_itrefund_amt(employee.emp_code,:as_prdcode,:as_it_ad_refund1,:as_it_ad_refund2,:ad_start_date,:ad_end_date) is null then 0 else ddf_get_itrefund_amt(employee.emp_code,:as_prdcode,:as_it_ad_refund1,:as_it_ad_refund2,:ad_start_date,:ad_end_date) end&quot;   OP =&quot;&lt;&gt;&quot;    EXP2 =&quot;0&quot; ) ) ARG(NAME = &quot;as_prdcode&quot; TYPE = string)  ARG(NAME = &quot;as_emp_fr&quot; TYPE = string)  ARG(NAME = &quot;as_emp_to&quot; TYPE = string)  ARG(NAME = &quot;as_site_fr&quot; TYPE = string)  ARG(NAME = &quot;as_site_to&quot; TYPE = string)  ARG(NAME = &quot;as_procgrp_fr&quot; TYPE = string)  ARG(NAME = &quot;as_procgrp_to&quot; TYPE = string)  ARG(NAME = &quot;as_it_ad_tottax&quot; TYPE = string)  ARG(NAME = &quot;as_it_ad_payable&quot; TYPE = string)  ARG(NAME = &quot;as_it_ad_refund1&quot; TYPE = string)  ARG(NAME = &quot;as_it_ad_refund2&quot; TYPE = string)  ARG(NAME = &quot;ad_start_date&quot; TYPE = date)  ARG(NAME = &quot;ad_end_date&quot; TYPE = date) </retrieve>
		<argument>
			<name>as_prdcode</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_emp_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_emp_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_site_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_site_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_procgrp_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_procgrp_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_it_ad_tottax</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_it_ad_payable</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_it_ad_refund1</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_it_ad_refund2</name>
			<type>string</type>
		</argument>
		<argument>
			<name>ad_start_date</name>
			<type>date</type>
		</argument>
		<argument>
			<name>ad_end_date</name>
			<type>date</type>
		</argument>
		<sort>
			<expression>emp_code A</expression>
		</sort>
	</TableDefinition>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>A/c Period</text>
		<border>6</border>
		<color>0</color>
		<x>2</x>
		<y>2</y>
		<height>16</height>
		<width>85</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>acct_prd_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Employee Code</text>
		<border>6</border>
		<color>0</color>
		<x>89</x>
		<y>2</y>
		<height>16</height>
		<width>99</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_code_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Employee Name</text>
		<border>6</border>
		<color>0</color>
		<x>190</x>
		<y>2</y>
		<height>16</height>
		<width>214</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_name_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Site Code</text>
		<border>6</border>
		<color>0</color>
		<x>406</x>
		<y>2</y>
		<height>16</height>
		<width>63</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>site_code_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Process Group</text>
		<border>6</border>
		<color>0</color>
		<x>471</x>
		<y>2</y>
		<height>16</height>
		<width>96</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>proc_group_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>1</alignment>
		<text>Total Income Tax</text>
		<border>6</border>
		<color>0</color>
		<x>569</x>
		<y>2</y>
		<height>16</height>
		<width>103</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>itax_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>1</alignment>
		<text>Tax Deducted</text>
		<border>6</border>
		<color>0</color>
		<x>674</x>
		<y>2</y>
		<height>16</height>
		<width>100</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>taxpaid_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>1</alignment>
		<text>Tax Payable</text>
		<border>6</border>
		<color>0</color>
		<x>776</x>
		<y>2</y>
		<height>16</height>
		<width>102</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>itpayable_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>1</alignment>
		<text>Tax Refunded</text>
		<border>6</border>
		<color>0</color>
		<x>880</x>
		<y>2</y>
		<height>16</height>
		<width>84</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>itrefundable_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<ColumnObject>
		<band>Detail</band>
		<id>1</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>2</x>
		<y>2</y>
		<height>16</height>
		<width>85</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>acct_prd</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>2</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>89</x>
		<y>2</y>
		<height>16</height>
		<width>99</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_code</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>3</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>190</x>
		<y>2</y>
		<height>16</height>
		<width>214</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_name</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>4</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>406</x>
		<y>2</y>
		<height>16</height>
		<width>63</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>site_code</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>5</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>471</x>
		<y>2</y>
		<height>16</height>
		<width>96</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>proc_group</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>6</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>569</x>
		<y>2</y>
		<height>16</height>
		<width>103</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>itax</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>7</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>674</x>
		<y>2</y>
		<height>16</height>
		<width>100</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>taxpaid</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>8</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>776</x>
		<y>2</y>
		<height>16</height>
		<width>102</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>itpayable</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>9</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>255</color>
		<x>880</x>
		<y>2</y>
		<height>16</height>
		<width>84</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>itrefundable</name>
		<visible>1</visible>
		<EditStyle style="editmask">
			<mask>#####0.00</mask>
			<imemode>0</imemode>
			<focusrectangle>no</focusrectangle>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</ColumnObject>
	<HtmlTable>
		<border>1</border>
	</HtmlTable>
	<HtmlGen>
		<clientevents>1</clientevents>
		<clientvalidation>1</clientvalidation>
		<clientcomputedfields>1</clientcomputedfields>
		<clientformatting>0</clientformatting>
		<clientscriptable>0</clientscriptable>
		<generatejavascript>1</generatejavascript>
		<encodeselflinkargs>1</encodeselflinkargs>
		<netscapelayers>0</netscapelayers>
	</HtmlGen>
	<Export.XML>
		<headgroups>1</headgroups>
		<includewhitespace>0</includewhitespace>
		<metadatatype>0</metadatatype>
		<savemetadata>0</savemetadata>
	</Export.XML>
	<Import.XML>
	</Import.XML>
	<Export.PDF>
		<method>0</method>
		<distill.custompostscript>0</distill.custompostscript>
		<xslfop.print>0</xslfop.print>
	</Export.PDF>
</Sybase_eDataWindow>
