Checkbook

data.framinghamma.gov | Last Updated 16 Jan 2020

Details of expenses (Accounts Payable) from fiscal year 2014 through 2019 including vendor, check, and amounts. See dataset Checkbook - Fiscal YTD for expenses in the current fiscal year.

Tags: checks, vendors, accounts payable, expenses

This dataset has the following 24 columns:

Column NameAPI Column NameData TypeSample Values
Fiscal Yearfiscal_yearnumber
Periodperiodnumber
Invoice Dateinvoice_datecalendar_date
i_department_noi_department_notext
Invoice Departmentinvoice_departmenttext
Org Dept Numberorg_dept_numbernumber
Department Namedepartment_nametext
Objectobjectnumber
Object Descriptionobject_descriptiontext
Orgorgnumber
Org Descriptionorg_descriptiontext
Project Codeproject_codetext
Project Titleproject_titletext
Item Amountitem_amountnumber
Fund Codefund_codenumber
Fund Descriptionfund_descriptiontext
Vendor Numbervendor_numbernumber
Vendor Namevendor_nametext
Invoice Numberinvoice_numbernumber
Invoice Line Item Numberinvoice_line_item_numbernumber
Invoice Paid/Voidinvoice_paid_voidtext
Check Numbercheck_numbernumber
Check Datecheck_datecalendar_date
Invoice Totalinvoice_totalnumber