naperville-il-us/expenditures-2018-current-year-cgxw-6gsg

  • checks
  • expenditures
  • finance
  • payments

Expenditures (2018 - Current Year)

Expenditures (2018 - Current Year)

Spending by City departments on goods and services. Dataset is used in Open Checkbook to create highly-interactive charts, graphs and tables how the City allocates public funds. Open Checkbook is part of the City's commitment to open data.

Open Budget will be released later in 2018.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Object Descriptionobject_descriptionobject_descriptionTextThe object section of the account number
Organization Codeorg_codeorg_codeNumberA unique ID number assigned to the organization section of the account number
Vendor Namevendor_namevendor_nameTextThe name of the vendor
Vendor IDvendor_idvendor_idNumberA unique ID number assigned to the vendor
Purchase Order Numberpurch_order_nopurch_order_noTextA unique ID number assigned to the purchase order
DepartmentdepartmentdepartmentTextThe department that received the good or service
FunctionfunctionfunctionTextDescribes the use of the good or service
Fiscal Periodfiscal_periodfiscal_periodNumberThe month in which the payment occurred
Division Codedivision_codedivision_codeNumberA unique ID number assigned to the division
Object Codeobject_codeobject_codeNumberA unique ID number assigned to the object section of the account number
Check Datecheck_datecheck_dateCalendar dateThe date the check was issued
DivisiondivisiondivisionTextThe division that received the good or service
Fund Codefund_codefund_codeNumberA unique ID number assigned to the fund
Check Numbercheck_numbercheck_numberNumberA unique ID number assigned to the check
Organization Code Descriptionorg_descriptionorg_descriptionTextThe organization section of the account number
Payment IDpayment_idpayment_idNumberA unique ID number assigned to the payment
Invoice Dateinvoice_dateinvoice_dateCalendar dateThe date given on the invoice
Invoice Numberinvoice_numberinvoice_numberTextA unique ID number assigned to the invoice
Invoice Statusinvoice_statusinvoice_statusTextWhether the invoice has been paid or not
Payment Statuspayment_statuspayment_statusTextWhether the payment has cleared or not
Department Numberdepartment_nodepartment_noNumberA unique ID number assigned to the department
Fiscal Yearfiscal_yearfiscal_yearNumberThe year in which the payment occurred
Function Codefunction_codefunction_codeNumberA unique ID number assigned to the function
Line Item Descriptionline_item_descriptionline_item_descriptionTextA description of the goods or services purchased
Payment Amountpayment_amountpayment_amountNumberThe amount remitted for goods or services
Department Codedepartment_codedepartment_codeNumberA unique ID number assigned to the department
FundfundfundTextThe mechanism which paid for the good or service
Department Descriptiondepartment_descriptiondepartment_descriptionTextThe department that received the good or service
Payment Typepayment_typepayment_typeTextThe manner of payment (ACI, check, wire)

Upstream Metadata