| id |
integer |
Yes |
Yes |
nextval('payroll_depts_id_seq'::regclass) |
Unique identifier |
| gl_division |
character varying(3) |
Yes |
No |
|
General Ledger Division for this payroll department |
| wages |
character varying(24) |
No |
No |
|
General Ledger account to use for Wages expense |
| ei_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for Empoyment Insurance Expense |
| cpp_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for CPP expense |
| wcb_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for WCB expense |
| advances_receivable |
character varying(24) |
No |
No |
|
General Ledger account to use for Advances paid to employees |
| ei_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for Employement Insurance payable |
| cpp_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for CPP payable |
| wcb_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for WCB payable |
| income_tax_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for Income Tax payable |
| pension_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for Pension payable |
| union_dues_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for Union dues payable |
| vacation_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for Vacation payable |
| clearing |
character varying(24) |
No |
No |
|
General Ledger account to use for Payroll clearing or bank account |
| qpp_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for QPP expense |
| csst_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for CSST expense |
| qhip_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for QHIP payable |
| qpp_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for QPP payable |
| csst_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for CSST payable |
| qhip_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for QHIP payable |
| qc_tax_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for QC tax payable |
| ppip_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for PPIP expense |
| ppip_payable |
character varying(24) |
No |
No |
|
General Ledger account to use for PPIP payable |
| benefits |
character varying(8)[] |
No |
No |
'{}'::character varying[] |
The 10 available benefits for this department |
| deduction_names |
character varying(8)[] |
No |
No |
'{}'::character varying[] |
The 10 available deductions for this department |
| deduction_accounts |
character varying(24)[] |
No |
No |
'{}'::character varying[] |
The General Ledger accounts for the 10 deductions |
| code |
character varying(10) |
No |
No |
|
User set code for this department |
| description |
character varying(30) |
No |
No |
|
User set description for this department |