framinghamma-gov/checkbook-cqve-ehkr

  • accounts payable
  • checks
  • expenses
  • vendors

Checkbook

Checkbook

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
i_department_noi_department_noi_department_noText
Invoice Paid/Voidinvoice_paid_voidinvoice_paid_voidText
ObjectobjectobjectNumber
Invoice Line Item Numberinvoice_line_item_numberinvoice_line_item_numberNumber
Org Descriptionorg_descriptionorg_descriptionText
Project Codeproject_codeproject_codeText
Project Titleproject_titleproject_titleText
Item Amountitem_amountitem_amountNumber
Fund Descriptionfund_descriptionfund_descriptionText
Vendor Numbervendor_numbervendor_numberNumber
Check Numbercheck_numbercheck_numberNumber
Check Datecheck_datecheck_dateCalendar date
Invoice Dateinvoice_dateinvoice_dateCalendar date
Org Dept Numberorg_dept_numberorg_dept_numberNumber
Object Descriptionobject_descriptionobject_descriptionText
Department Namedepartment_namedepartment_nameText
Invoice Numberinvoice_numberinvoice_numberNumber
OrgorgorgNumber
Invoice Totalinvoice_totalinvoice_totalNumber
Invoice Departmentinvoice_departmentinvoice_departmentText
Vendor Namevendor_namevendor_nameText
Fund Codefund_codefund_codeNumber
Fiscal Yearfiscal_yearfiscal_yearNumber
PeriodperiodperiodNumber