Table Data dictionary report - vendor_t4as

Generated: 2019-01-21 1:54:19 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public
Notes:

Table for Vendor T4A records

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
vendor_t4as_pkey Primary key (id)
vendor_t4as_vendor_id_fkey Foreign key (vendor_id) REFERENCES public.vendors (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION

Report generated by pgAdmin3 LTS by BigSQL