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 expense |
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 |
code |
character varying(10) |
No |
No |
|
User set code for this department |
description |
character varying(30) |
No |
No |
|
User set description for this department |
vacation_expense |
character varying(24) |
No |
No |
|
General Ledger account to use for Vacation pay expense |
_dbversion |
integer |
No |
No |
|
Program version that last modified this record |
_created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
_created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
_modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
_modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |