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.
This dataset has the following 24 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Fiscal Year | fiscal_year | number | 2020 view top 100 |
Period | period | number | 4 7 6 3 5 view top 100 |
Invoice Date | invoice_date | calendar_date | 2019-08-01T00:00:00.000 2019-10-02T00:00:00.000 2019-12-31T00:00:00.000 2019-07-31T00:00:00.000 2019-12-03T00:00:00.000 view top 100 |
i_department_no | i_department_no | text | 145 429 S972 192 610 view top 100 |
Invoice Department | invoice_department | text | Treasurer Collector Fleet Services Building Services Library Parks & Recreation view top 100 |
Org Dept Number | org_dept_number | number | 500 1 450 192 610 view top 100 |
Department Name | department_name | text | Water Enterprise Building Services Library Fleet Services Sewer Enterprise view top 100 |
Object | object | number | 54800 635050 636140 55300 54240 view top 100 |
Object Description | object_description | text | Supplies - Vehicular Exp, Supplies, Instr Exp, Other Public Works Supplies Supplies - Buildings view top 100 |
Org | org | number | 1 4290021 95003010 6100121 95003022 view top 100 |
Org Description | org_description | text | General Fund DPW-Fleet Services(Garage)-OP School FoodSvcs, Exp, FHS Lib-Collect&Circltn-Op Exp School FoodSvcs, Exp, Walsh view top 100 |
Project Code | project_code | text | EM003 20804 19804 20305 32646 view top 100 |
Project Title | project_title | text | Condo Trash Pick-up 5/10 ATM A25A N Concord St Wtr Main Mark Out Lines Street Opening Permit Fee Program Trench Excavation Management Fees view top 100 |
Item Amount | item_amount | number | 150 75 100 50 60 view top 100 |
Fund Code | fund_code | number | 1 6500 8000 8400 8100 view top 100 |
Fund Description | fund_description | text | General Fund Rev-School Food Service Water Enterprise Fund Sewer Enterprise Fund Water Infrastruture view top 100 |
Vendor Number | vendor_number | number | 2625 1032 326 387 50172 view top 100 |
Vendor Name | vendor_name | text | W B MASON CO INC INGRAM INDUSTRIES IN NSTAR ELECTRIC CO GARELICK FARMS LLC AMAZON CAPITAL SERVI view top 100 |
Invoice Number | invoice_number | number | 601104 593109 616231 607606 597823 view top 100 |
Invoice Line Item Number | invoice_line_item_number | number | 1 2 3 4 5 view top 100 |
Invoice Paid/Void | invoice_paid_void | text | P view top 100 |
Check Number | check_number | number | 361025 364542 366512 367438 373856 view top 100 |
Check Date | check_date | calendar_date | 2019-10-15T00:00:00.000 2019-12-16T00:00:00.000 2019-10-28T00:00:00.000 2019-09-16T00:00:00.000 2020-02-18T00:00:00.000 view top 100 |
Invoice Total | invoice_total | number | 150 75 50 100 60 view top 100 |