framinghamma-gov/checkbook-fiscal-ytd-erww-baxn
Icon for Socrata external plugin
 
Readme
Updated almost 2 years ago
Indexed 5 hours ago

Checkbook - Fiscal YTD

Details of expenses (Accounts Payable) from the beginning of the most recent Fiscal Year, 2020. Includes vendor, checks, and amounts to Jun 30, 2020.

See also dataset Checkbook, which contains historical data starting in Fiscal Year 2014 (July 1, 2013) though Fiscal 2019.

Columns

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