citydata-mesaaz-gov/business-services-purchases-u5x3-dvhs

  • award
  • delivery order
  • purchase order

Business Services - Purchases

Business Services - Purchases

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Dept YTD Purchase Mesadept_ytd_purchase_mesadept_ytd_purchase_mesaNumberField used for PM calculation that shows the department's monthly purchase in Mesa total for the fiscal year to date
Dept YTD Purchase AZdept_ytd_purchase_azdept_ytd_purchase_azNumberField used for PM calculation that shows the department's monthly purchase in Arizona total for the fiscal year to date
Dept YTD Purchase Totaldept_ytd_purchase_totaldept_ytd_purchase_totalNumberField used for PM calculation that shows the department's monthly purchase total for the fiscal year to date
Dept YTD Small Purchase Mesadept_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
Award Header Actual Amountaward_header_actual_amountaward_header_actual_amountNumberAmount of the award as shown on the header of the purchasing award document
Award Header Reporting Codeaward_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 Document Procurement Typeaward_document_procurementaward_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 Department Nameaward_department_nameaward_department_nameTextCode that identifies the department name of the purchasing award document
Concatenated Award Document IDconcatenated_award_documentconcatenated_award_documentTextConcatenated field that includes the Document Code, Department Code and Document ID number of the Purchasing award document from the document header
Award Header Citied Authority Codeaward_header_citied_authorityaward_header_citied_authorityTextCode indicating how the award was authorized (Council, administratively, etc.)
Award Document Nameaward_document_nameaward_document_nameTextName of the purchasing award document as shown on the header
Award Document Codeaward_document_codeaward_document_codeTextCode that identifies the type of purchasing award document (i.e. PO, DO, CT)
Row Numberrow_numberrow_numberTextField used for PM calculation to indicate the row number of the purchase over department and accounting period
Vendor Statevendor_statevendor_stateTextField from the vendor address record that indicates the state the vendor is in (for the vendor of record on the Purchasing document)
Award Header Accounting Periodaward_header_accounting_periodaward_header_accounting_periodTextAccounting period on the header of the purchasing award document
Accounting Period Date Formataccounting_period_date_formataccounting_period_date_formatCalendar dateDate format of the Award Header Fiscal Year and Accounting Period
Award Document Procurement Type Nameaward_document_procurement_1award_document_procurement_1TextName for the procurement type used on the award document
Dept YTD Small Purchase AZdept_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
Award Header Reporting Code Nameaward_header_reporting_code_1award_header_reporting_code_1TextField on the header of the purchasing award document that indicates the name of the type of purchase
Vendor Cityvendor_cityvendor_cityTextField from vendor address record that indicated the city the vendor is in (for the vendor of record on the purchasing document)
Award Department Codeaward_department_codeaward_department_codeTextCode that identifies the department code of the purchasing award document
Award Header Accounting 12 Periodsaward_header_accounting_12award_header_accounting_12TextAccounting period on the header of the purchasing award document, with Period 13 listed as Period 12
Purchase Under 25000 Flagpurchase_under_25000_flagpurchase_under_25000_flagCheckboxField which indicates if the header of the purchasing award document was greater than or equal to $25,000
Award Document Version Numberaward_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 Header Fiscal Yearaward_header_fiscal_yearaward_header_fiscal_yearTextFiscal year on the header of the purchasing award document
Award Document IDaward_document_idaward_document_idTextDocument ID number of the Purchasing award document from the document header
Dept YTD Small Purchase Totaldept_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

Upstream Metadata