framinghamma-gov/checkbook-cqve-ehkr
Icon for Socrata external plugin
 
Readme
Updated over 2 years ago
Indexed 2 hours ago

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
ObjectobjectobjectNumber
PeriodperiodperiodNumber
Fiscal Yearfiscal_yearfiscal_yearNumber
Invoice Line Item Numberinvoice_line_item_numberinvoice_line_item_numberNumber
Invoice Totalinvoice_totalinvoice_totalNumber
Invoice Paid/Voidinvoice_paid_voidinvoice_paid_voidText
Check Datecheck_datecheck_dateCalendar date
Check Numbercheck_numbercheck_numberNumber
Invoice Numberinvoice_numberinvoice_numberNumber
Vendor Namevendor_namevendor_nameText
Vendor Numbervendor_numbervendor_numberNumber
Fund Descriptionfund_descriptionfund_descriptionText
Fund Codefund_codefund_codeNumber
Item Amountitem_amountitem_amountNumber
Project Titleproject_titleproject_titleText
Project Codeproject_codeproject_codeText
Org Descriptionorg_descriptionorg_descriptionText
OrgorgorgNumber
Object Descriptionobject_descriptionobject_descriptionText
Department Namedepartment_namedepartment_nameText
Org Dept Numberorg_dept_numberorg_dept_numberNumber
Invoice Departmentinvoice_departmentinvoice_departmentText
i_department_noi_department_noi_department_noText
Invoice Dateinvoice_dateinvoice_dateCalendar date
 
Preview
  • checkbook