addons/l10n_be_hr_payroll/l10n_be_hr_payroll_data.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3     <data>
   4     <record id="hr_payroll_head_salary" model="hr.salary.rule.category">
   5         <field name="name">Gross</field>
   6         <field name="code">BRUT</field>
   7     </record>
   8     <record id="hr_payroll.COMP" model="hr.salary.rule.category">
   9         <field name="name">Company Part</field>
  10         <field name="code">COMP. PART</field>
  11     </record>
  12     <record id="hr_payroll_head_onss" model="hr.salary.rule.category">
  13         <field name="name">Worker Social Contribution</field>
  14         <field name="code">ONSS</field>
  15         <field name="parent_id" ref="hr_payroll.ALW"/>
  16     </record>
  17     <record id="hr_payroll_head_div_impos" model="hr.salary.rule.category">
  18         <field name="name">Misc. Taxable</field>
  19         <field name="code">DIV. IMPOS</field>
  20         <field name="parent_id" ref="hr_payroll.ALW"/>
  21     </record>
  22     <record id="hr_payroll_head_pp" model="hr.salary.rule.category">
  23         <field name="name">Withholding Tax Grid 2011 (Precompte Professionnel Bareme 2011)</field>
  24         <field name="code">P.P.</field>
  25         <field name="parent_id" ref="hr_payroll.DED"/>
  26     </record>
  27     <record id="hr_payroll_head_div_net" model="hr.salary.rule.category">
  28         <field name="name">Misc. Net</field>
  29         <field name="code">DIV. NET</field>
  30         <field name="parent_id" ref="hr_payroll.DED"/>
  31     </record>
  32     <record id="hr_payroll_head_child_alw" model="hr.salary.rule.category">
  33         <field name="name">Child Allowance Belgium</field>
  34         <field name="code">Ch.A</field>
  35         <field name="parent_id" ref="hr_payroll.DED"/>
  36     </record>
  37
  38 <!-- HR SALARY RULES-->
  39     <record id="hr_payroll_rules_maj" model="hr.salary.rule">
  40         <field name="category_id" ref="hr_payroll_head_salary"/>
  41         <field name="name">Worker Salary. Premium pay of 108%</field>
  42         <field name="code">SALARY</field>
  43         <field name="condition_select">none</field>
  44         <field name="amount_select">code</field>
  45         <field name="amount_python_compute">result = contract.wage * 1.08</field>
  46     </record>
  47     <record id="hr_payroll_rules_employee" model="hr.salary.rule">
  48         <field name="category_id" ref="hr_payroll_head_salary"/>
  49         <field name="name">Employee Salary</field>
  50         <field name="code">SALARY</field>
  51         <field name="condition_select">none</field>
  52         <field name="amount_select">code</field>
  53         <field name="amount_python_compute">result = contract.wage * 1</field>
  54         <field name="appears_on_payslip" eval="False"/>
  55     </record>
  56     <record id="hr_payroll_rules_onss_rule" model="hr.salary.rule">
  57         <field name="category_id" ref="hr_payroll_head_onss"/>
  58         <field name="name">Social contribution</field>
  59         <field name="code">ONSS</field>
  60         <field name="sequence">41</field>
  61         <field name="condition_select">none</field>
  62         <field name="amount_select">percentage</field>
  63         <field name="amount_percentage_base">SALARY</field>
  64         <field name="amount_percentage">-13.07</field>
  65    </record>
  66    <record id="hr_payroll_rules_p_p_b1" model="hr.salary.rule">
  67         <field name="category_id" ref="hr_payroll_head_pp"/>
  68         <field name="name">Withholding Tax Grid 2011</field>
  69         <field name="code">P.P</field>
  70         <field name="sequence">120</field>
  71         <field name="amount_select">fix</field>
  72         <field name="condition_select">none</field>
  73         <field name="appears_on_payslip" eval="False"/>
  74     </record>
  75     <record id="hr_payroll_rules_bareme" model="hr.salary.rule">
  76         <field name="category_id" ref="hr_payroll_head_pp"/>
  77         <field name="parent_rule_id" ref="hr_payroll_rules_p_p_b1"/>
  78         <field name="name">Withholding Tax</field>
  79         <field name="code">B.I.</field>
  80         <field name="amount_select">fix</field>
  81         <field name="sequence">120</field>
  82         <field name="condition_select">python</field>
  83         <field name="appears_on_payslip" eval="False"/>
  84         <field name="condition_python">result = (((employee.marital=='single') or (employee.marital=='married' and employee.spouse_fiscal_status=='with income')) and (employee.resident_bool!=True))</field>
  85     </record>
  86     <record id="hr_payroll_rules_baremeII" model="hr.salary.rule">
  87         <field name="category_id" ref="hr_payroll_head_pp"/>
  88         <field name="parent_rule_id" ref="hr_payroll_rules_p_p_b1"/>
  89         <field name="name">Withholding Tax</field>
  90         <field name="code">B.II</field>
  91         <field name="amount_select">fix</field>
  92         <field name="sequence">120</field>
  93         <field name="condition_select">python</field>
  94         <field name="appears_on_payslip" eval="False"/>
  95         <field name="condition_python">result = ((employee.marital=='married' and employee.spouse_fiscal_status=='without income') and (employee.resident_bool!=True))</field>
  96     </record>
  97     <record id="hr_payroll_rules_baremeIII" model="hr.salary.rule">
  98         <field name="category_id" ref="hr_payroll_head_pp"/>
  99         <field name="parent_rule_id" ref="hr_payroll_rules_p_p_b1"/>
 100         <field name="name">Withholding Tax</field>
 101         <field name="code">B.III</field>
 102         <field name="amount_select">fix</field>
 103         <field name="sequence">120</field>
 104         <field name="condition_select">python</field>
 105         <field name="condition_python">result = employee.resident_bool==True</field>
 106         <field name="appears_on_payslip" eval="False"/>
 107     </record>
 108     <record id="hr_payroll_rules_child_alw" model="hr.salary.rule">
 109         <field name="category_id" ref="hr_payroll.DED"/>
 110         <field name="name">Child Allowance Belgium</field>
 111         <field name="code">Child.Allowance</field>
 112         <field name="sequence">140</field>
 113         <field name="amount_select">fix</field>
 114         <field name="condition_select">python</field>
 115         <field name="condition_python">result = bool(employee.children)</field>
 116     </record>
 117     <record id="hr_payroll_rules_child" model="hr.salary.rule">
 118         <field name="category_id" ref="hr_payroll.DED"/>
 119         <field name="parent_rule_id" ref="hr_payroll_rules_child_alw"/>
 120         <field name="name">Child Allowance Belgium</field>
 121         <field name="code">Ch.A</field>
 122         <field name="amount_select">fix</field>
 123         <field name="sequence">141</field>
 124         <field name="note">The recipient of income is an isolated or spouse beneficiary's income has also
 125                                         earned income (Schedule I / II scale)
 126
 127                                         A. When the gross monthly earnings do not exceed € 7,500, the withholding tax is determined according to the Schedule I.
 128                                         The following reductions are then deducted from the payroll tax determined in accordance with this schedule:
 129
 130                                                 a) Reduction for dependent children</field>
 131         <field name="condition_select">python</field>
 132         <field name="condition_python">result = bool(employee.children)</field>
 133     </record>
 134     <record id="hr_payroll_rules_child_handicap" model="hr.salary.rule">
 135         <field name="category_id" ref="hr_payroll.DED"/>
 136         <field name="parent_rule_id" ref="hr_payroll_rules_child_alw"/>
 137         <field name="name">Child Allowance for the Disabled Belgium</field>
 138         <field name="code">Ch.Handicap</field>
 139         <field name="amount_select">fix</field>
 140         <field name="sequence">143</field>
 141         <field name="note">"Disabled child" means:
 142
 143                     the child reaches at least 66% of failure or reduced physical or mental capacity
 144                     the head of one or more conditions;
 145
 146
 147                     the child that is established, regardless of age, that due to developments and recognized
 148                     before age 65</field>
 149                 <field name="condition_select">python</field>
 150                 <field name="condition_python">result = bool(employee.disabled_children_number)</field>
 151     </record>
 152     <record id="hr_payroll_rules_spouse_handicap" model="hr.salary.rule">
 153         <field name="category_id" ref="hr_payroll_head_div_net"/>
 154         <field name="name">Disabled Spouse Allowance</field>
 155         <field name="code">Sp.handicap</field>
 156         <field name="amount_select">fix</field>
 157         <field name="sequence">145</field>
 158         <field name="amount_fix">31</field>
 159         <field name="condition_select">python</field>
 160         <field name="condition_python">result = employee.disabled_spouse_bool==True</field>
 161     </record>
 162     <record id="hr_payroll_rules_company_car_parent" model="hr.salary.rule">
 163         <field name="category_id" ref="hr_payroll_head_div_impos"/>
 164         <field name="name">Company Car</field>
 165         <field name="code">car</field>
 166         <field name="amount_select">fix</field>
 167         <field name="sequence">15</field>
 168         <field name="condition_select">none</field>
 169         <field name="appears_on_payslip" eval="False"/>
 170     </record>
 171     <record id="hr_payroll_rules_parent_company_car" model="hr.salary.rule">
 172         <field name="category_id" ref="hr_payroll_head_div_impos"/>
 173         <field name="name">Company car</field>
 174         <field name="parent_rule_id" ref="hr_payroll_rules_company_car_parent"/>
 175         <field name="code">CAR 1</field>
 176         <field name="sequence">15</field>
 177         <field name="condition_select">python</field>
 178         <field name="condition_python">result = bool(contract.car_employee_deduction)</field>
 179         <field name="amount_select">code</field>
 180         <field name="amount_python_compute">result = contract.car_employee_deduction</field>
 181     </record>
 182     <record id="hr_payroll_rules_company_car_2" model="hr.salary.rule">
 183         <field name="category_id" ref="hr_payroll_head_div_net"/>
 184         <field name="name">Retenue Company car</field>
 185         <field name="parent_rule_id" ref="hr_payroll_rules_company_car_parent"/>
 186         <field name="code">CAR 2</field>
 187         <field name="sequence">160</field>
 188         <field name="condition_select">python</field>
 189         <field name="condition_python">result = contract.car_employee_deduction</field>
 190         <field name="amount_select">code</field>
 191         <field name="amount_python_compute">result = -contract.car_employee_deduction</field>
 192     </record>
 193     <record id="hr_payroll_rules_company_car_emp" model="hr.salary.rule">
 194         <field name="category_id" ref="hr_payroll.COMP"/>
 195         <field name="name">Company car, Company part</field>
 196         <field name="parent_rule_id" ref="hr_payroll_rules_company_car_parent"/>
 197         <field name="code">CAR 3</field>
 198         <field name="sequence">160</field>
 199         <field name="condition_select">python</field>
 200         <field name="condition_python">result = bool(contract.car_company_amount)</field>
 201         <field name="amount_select">code</field>
 202         <field name="amount_python_compute">result = -contract.car_company_amount</field>
 203         <field name="appears_on_payslip" eval="False"/>
 204     </record>
 205     <record id="hr_payroll_rules_parent_ch" model="hr.salary.rule">
 206         <field name="category_id" ref="hr_payroll_head_div_net"/>
 207         <field name="name">Meal Voucher</field>
 208         <field name="code">MEAL_V</field>
 209         <field name="amount_select">fix</field>
 210         <field name="sequence">165</field>
 211         <field name="condition_select">none</field>
 212         <field name="appears_on_payslip" eval="False"/>
 213     </record>
 214     <record id="hr_payroll_rules_ch_value" model="hr.salary.rule">
 215         <field name="category_id" ref="hr_payroll.COMP"/>
 216         <field name="parent_rule_id" ref="hr_payroll_rules_parent_ch"/>
 217         <field name="name">Meal Voucher, Company Part</field>
 218         <field name="code">MEAL_V_COMP</field>
 219         <field name="amount_select">fix</field>
 220         <field name="sequence">165</field>
 221         <field name="amount_select">code</field>
 222         <field name="amount_python_compute">result = -(contract.meal_voucher_amount - contract.meal_voucher_employee_deduction) * worked_days.WORK100.number_of_days</field>
 223         <field name="condition_select">python</field>
 224         <field name="condition_python">result = bool(contract.meal_voucher_amount)</field>
 225         <field name="appears_on_payslip" eval="False"/>
 226     </record>
 227     <record id="hr_payroll_rules_ch_worker" model="hr.salary.rule">
 228         <field name="category_id" ref="hr_payroll_head_div_net"/>
 229         <field name="name">Retain on Meal Voucher</field>
 230         <field name="parent_rule_id" ref="hr_payroll_rules_parent_ch"/>
 231         <field name="code">MEAL_V_EMP</field>
 232         <field name="sequence">165</field>
 233         <field name="condition_select">python</field>
 234         <field name="condition_python">result = bool(contract.meal_voucher_employee_deduction)</field>
 235         <field name="amount_select">percentage</field>
 236         <field name="amount_percentage">-100.0</field>
 237         <field name="amount_percentage_base">contract.meal_voucher_employee_deduction</field>
 238         <field name="quantity">worked_days.WORK100.number_of_days</field>
 239         <field name="appears_on_payslip" eval="True"/>
 240     </record>
 241     <record id="hr_payroll_rules_reim_travel" model="hr.salary.rule">
 242         <field name="category_id" ref="hr_payroll.DED"/>
 243         <field name="name">Reimbursement of travel expenses</field>
 244         <field name="code">Tr.E</field>
 245         <field name="amount_select">code</field>
 246         <field name="sequence">65</field>
 247         <field name="condition_select">python</field>
 248         <field name="condition_python">result = bool(contract.travel_reimbursement_amount)</field>
 249         <field name="amount_python_compute">result = contract.travel_reimbursement_amount</field>
 250     </record>
 251     <record id="hr_payroll_rules_mis_ex_onss" model="hr.salary.rule">
 252         <field name="category_id" ref="hr_payroll.DED"/>
 253         <field name="name">Miscellaneous exempt ONSS</field>
 254         <field name="code">M.ONSS</field>
 255         <field name="amount_select">code</field>
 256         <field name="sequence">165</field>
 257         <field name="condition_select">python</field>
 258         <field name="condition_python">result = bool(contract.misc_onss_deduction)</field>
 259         <field name="amount_python_compute">result = -contract.misc_onss_deduction</field>
 260     </record>
 261     <record id="hr_payroll_rules_insurance" model="hr.salary.rule">
 262         <field name="category_id" ref="hr_payroll.DED"/>
 263         <field name="name">Insurance</field>
 264         <field name="code">Ins</field>
 265         <field name="amount_select">code</field>
 266         <field name="sequence">165</field>
 267         <field name="condition_select">python</field>
 268         <field name="condition_python">result = bool(contract.insurance_employee_deduction)</field>
 269         <field name="amount_python_compute">result = -contract.insurance_employee_deduction</field>
 270     </record>
 271     <record id="hr_payroll_rules_advantage" model="hr.salary.rule">
 272         <field name="category_id" ref="hr_payroll.ALW"/>
 273         <field name="name">Benefits of various nature</field>
 274         <field name="code">Ben</field>
 275         <field name="amount_select">code</field>
 276         <field name="sequence">10</field>
 277         <field name="condition_select">python</field>
 278         <field name="condition_python">result = bool(contract.misc_advantage_amount)</field>
 279         <field name="amount_python_compute">result = contract.misc_advantage_amount</field>
 280     </record>
 281     <record id="hr_payroll_rules_suppl_net" model="hr.salary.rule">
 282         <field name="category_id" ref="hr_payroll_head_div_net"/>
 283         <field name="name">Net Supplement</field>
 284         <field name="code">Net.S</field>
 285         <field name="amount_select">code</field>
 286         <field name="sequence">185</field>
 287         <field name="condition_select">python</field>
 288         <field name="condition_python">result = bool(contract.additional_net_amount)</field>
 289         <field name="amount_python_compute">result = contract.additional_net_amount</field>
 290     </record>
 291     <record id="hr_payroll_rules_retained_net" model="hr.salary.rule">
 292         <field name="category_id" ref="hr_payroll_head_div_net"/>
 293         <field name="name">Net retained</field>
 294         <field name="code">Net.R</field>
 295         <field name="amount_select">code</field>
 296         <field name="sequence">190</field>
 297         <field name="condition_select">python</field>
 298         <field name="condition_python">result = bool(contract.retained_net_amount)</field>
 299         <field name="amount_python_compute">result = -contract.retained_net_amount</field>
 300     </record>
 301     <record id="hr_payroll_salary_structure_employee" model="hr.payroll.structure">
 302         <field name="code">C.P.218</field>
 303         <field name="name">Belgian Employee</field>
 304         <field eval="[(6, 0, [ref('hr_payroll_rules_company_car_parent'),ref('hr_payroll_rules_onss_rule'),ref('hr_payroll_rules_employee'),ref('hr_payroll_rules_p_p_b1'),ref('hr_payroll_rules_child_alw'),ref('hr_payroll_rules_parent_ch'),ref('hr_payroll_rules_reim_travel'),ref('hr_payroll_rules_mis_ex_onss'),ref('hr_payroll_rules_insurance'),ref('hr_payroll_rules_advantage'),ref('hr_payroll_rules_suppl_net'),ref('hr_payroll_rules_retained_net')])]" name="rule_ids"/>
 305         <field name="company_id" ref="base.main_company"/>
 306         <field name="parent_id" ref="hr_payroll.structure_base"/>
 307     </record>
 308     <record id="hr_payroll_salary_structure_worker" model="hr.payroll.structure">
 309         <field name="code">C.P.219</field>
 310         <field name="name">Belgian Worker</field>
 311         <field eval="[(6, 0, [ref('hr_payroll_rules_maj'), ref('hr_payroll_rules_onss_rule'),ref('hr_payroll_rules_p_p_b1'),ref('hr_payroll_rules_child_alw'),ref('hr_payroll_rules_parent_ch'),ref('hr_payroll_rules_reim_travel'),ref('hr_payroll_rules_mis_ex_onss'),ref('hr_payroll_rules_insurance'),ref('hr_payroll_rules_advantage'),ref('hr_payroll_rules_suppl_net'),ref('hr_payroll_rules_retained_net')])]" name="rule_ids"/>
 312         <field name="company_id" ref="base.main_company"/>
 313         <field name="parent_id" ref="hr_payroll.structure_base"/>
 314         </record>
 315     </data>
 316 </openerp>