id |
integer |
Yes |
Yes |
nextval('vendor_t4as_id_seq'::regclass) |
Unique identifier |
vendor_id |
integer |
Yes |
No |
|
Vendor ID for this record - links to vendors.id |
year |
integer |
Yes |
No |
|
Year of the T4 |
last_name |
character varying(30) |
No |
No |
|
Vendor last name |
first_name |
character varying(30) |
No |
No |
|
Vendor first name |
initials |
character varying(5) |
No |
No |
|
Vendor initials |
sin |
character varying(9) |
No |
No |
|
Vendor Social Insurance Number |
account_no |
character varying(15) |
No |
No |
|
Vendor Business Number |
pension |
numeric(15,2) |
No |
No |
|
Pension amount |
lump_sum |
numeric(15,2) |
No |
No |
|
Lump sum amount |
commission |
numeric(15,2) |
No |
No |
|
Commission amount |
income_tax_deducted |
numeric(15,2) |
No |
No |
|
Income tax deducted amount |
annuities |
numeric(15,2) |
No |
No |
|
Annuities amount |
service_fees |
numeric(15,2) |
No |
No |
|
Service fees amount |
other_boxes |
character varying[] |
No |
No |
'{NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL}'::character varying[] |
Array for Other Boxes codes |
other_amounts |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Array for Other Boxes amounts |
suggested_pension |
numeric(15,2) |
No |
No |
|
Suggested pension amount |
suggested_lump_sum |
numeric(15,2) |
No |
No |
|
Suggested lump sum amount |
suggested_commission |
numeric(15,2) |
No |
No |
|
Suggested commission amount |
suggested_income_tax_deducted |
numeric(15,2) |
No |
No |
|
Suggested income tax amount |
suggested_annuities |
numeric(15,2) |
No |
No |
|
Suggested annuity amount |
suggested_service_fees |
numeric(15,2) |
No |
No |
|
Suggested service fees amount |
suggested_other_amounts |
numeric(15,2)[] |
No |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Array for suggested other amounts |
remitted |
date |
No |
No |
|
Remitted date |
status |
character varying(1) |
No |
No |
|
T4A status; A = Amended C = Cancelled O = Original |
_dbversion |
integer |
No |
No |
|
Program version that last modified 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 |
_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 |