Invoice Spend for Purchase Orders Only July 1, 2011 - Present | Last Updated 12 Jan 2020

This dataset represents all purchase orders that were invoiced from July 1, 2011 to present. It does not include other payment types. Purchase orders may be repeated in the table, which indicates that multiple invoices were created for the respective purchase order.

Tags: purchase order, purchase, order, invoice, item, vendor

This dataset has the following 9 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
PONumberponumbertextThe Purchase Order number assigned to the order.
POTypepotypetextCategory of Purchase Order. For example, the purchase order may be created for a construction contract, a professional service, or a standard purchase.
PODatepodatecalendar_dateThe date the Purchase Order was created.
POAmountpoamountnumberThe amount in U.S. dollars the PO costs.
VendorNamevendornametextThe name of the Vendor that will supply the item(s) listed on the Purchase Order.
InvoiceinvoicetextThe Vendor Invoice number for the PO Line Item.
InvoicePostDateinvoicedatecalendar_dateRepresents the date the Invoice was posted to the General Ledger.
FiscalYearfiscalyeartextThe City's 'fiscal' year runs from July 1 to June 30 each year.
InvoiceAmountinvoiceamountnumberThe amount in U.S. dollars on the invoice for the PO.