| id |
integer |
Yes |
Yes |
nextval('vendor_t5018s_id_seq'::regclass) |
Unique identifier |
| vendor_id |
integer |
Yes |
No |
|
Vendor ID for this record - links to vendors.id |
| period_ending |
date |
Yes |
No |
|
End date for reporting period |
| 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 |
| account_no |
character varying(15) |
No |
No |
|
Vendor Business Number |
| payments |
numeric(15,2) |
No |
No |
|
Total payments for the reporting period |
| suggested_payments |
numeric(15,2) |
No |
No |
|
Sugested total payments for the reporting period |
| 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 |