Business Services - Purchases

citydata.mesaaz.gov | Last Updated 17 Aug 2020

This dataset has document information for purchases made in the City of Mesa financial system (Advantage-FIN). Warehouse adjustments and Engineering procurement types are excluded. (Code 800 and 810 as those are Warehouse inventory adjustments; Filter out DO’s made from Master Agreements with Procurement type 11, 12, 13 or 16, Engineering Procurement Types.

Tags: award, po, do, purchase order, delivery order

This dataset has the following 24 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Award Document Codeaward_document_codetextCode that identifies the type of purchasing award document (i.e. PO, DO, CT)
Concatenated Award Document IDconcatenated_award_documenttextConcatenated field that includes the Document Code, Department Code and Document ID number of the Purchasing award document from the document header
Award Department Codeaward_department_codetextCode that identifies the department code of the purchasing award document
Award Department Nameaward_department_nametextCode that identifies the department name of the purchasing award document
Award Document IDaward_document_idtextDocument ID number of the Purchasing award document from the document header
Award Document Version Numberaward_document_version_numbertextVersion number of the purchasing award document from the document header (we only look at version 1 so the document isn’t included multiple times)
Award Document Procurement Typeaward_document_procurementtextCode for the procurement type used on the award document (we only look at Purchasing Procurement Types 1, 2, 3, 4, 5, 6, and 7)
Award Document Procurement Type Nameaward_document_procurement_1textName for the procurement type used on the award document
Award Header Reporting Codeaward_header_reporting_codetextField on the header of the purchasing award document that indicates type of purchase (we exclude code 800 and 810 as those are Warehouse inventory adjustments)
Award Header Reporting Code Nameaward_header_reporting_code_1textField on the header of the purchasing award document that indicates the name of the type of purchase
Award Header Fiscal Yearaward_header_fiscal_yeartextFiscal year on the header of the purchasing award document
Award Header Accounting Periodaward_header_accounting_periodtextAccounting period on the header of the purchasing award document
Award Header Accounting 12 Periodsaward_header_accounting_12textAccounting period on the header of the purchasing award document, with Period 13 listed as Period 12
Accounting Period Date Formataccounting_period_date_formatcalendar_dateDate format of the Award Header Fiscal Year and Accounting Period
Award Document Nameaward_document_nametextName of the purchasing award document as shown on the header
Award Header Citied Authority Codeaward_header_citied_authoritytextCode indicating how the award was authorized (Council, administratively, etc.)
Vendor Cityvendor_citytextField from vendor address record that indicated the city the vendor is in (for the vendor of record on the purchasing document)
Vendor Statevendor_statetextField from the vendor address record that indicates the state the vendor is in (for the vendor of record on the Purchasing document)
Purchase Under 25000 Flagpurchase_under_25000_flagcheckboxField which indicates if the header of the purchasing award document was greater than or equal to $25,000
Row Numberrow_numbertextField used for PM calculation to indicate the row number of the purchase over department and accounting period
Award Header Actual Amountaward_header_actual_amountnumberAmount of the award as shown on the header of the purchasing award document
Dept YTD Small Purchase Totaldept_ytd_small_purchase_totalnumberField used for PM calculation that shows the department's monthly small purchase total for the fiscal year to date
Dept YTD Small Purchase AZdept_ytd_small_purchase_aznumberField used for PM calculation that shows the department's monthly small purchase in Arizona total for the fiscal year to date
Dept YTD Small Purchase Mesadept_ytd_small_purchase_mesanumberField used for PM calculation that shows the department's monthly small purchase in Mesa total for the fiscal year to date