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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Dept YTD Purchase Mesa | dept_ytd_purchase_mesa | dept_ytd_purchase_mesa | Number | Field used for PM calculation that shows the department's monthly purchase in Mesa total for the fiscal year to date |
| Dept YTD Purchase AZ | dept_ytd_purchase_az | dept_ytd_purchase_az | Number | Field used for PM calculation that shows the department's monthly purchase in Arizona total for the fiscal year to date |
| Dept YTD Purchase Total | dept_ytd_purchase_total | dept_ytd_purchase_total | Number | Field used for PM calculation that shows the department's monthly purchase total for the fiscal year to date |
| Dept YTD Small Purchase Mesa | dept_ytd_small_purchase_mesa | dept_ytd_small_purchase_mesa | Number | Field used for PM calculation that shows the department's monthly small purchase in Mesa total for the fiscal year to date |
| Award Header Actual Amount | award_header_actual_amount | award_header_actual_amount | Number | Amount of the award as shown on the header of the purchasing award document |
| Award Header Reporting Code | award_header_reporting_code | award_header_reporting_code | Text | Field 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 Type | award_document_procurement | award_document_procurement | Text | Code 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 Name | award_department_name | award_department_name | Text | Code that identifies the department name of the purchasing award document |
| Concatenated Award Document ID | concatenated_award_document | concatenated_award_document | Text | Concatenated 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 Code | award_header_citied_authority | award_header_citied_authority | Text | Code indicating how the award was authorized (Council, administratively, etc.) |
| Award Document Name | award_document_name | award_document_name | Text | Name of the purchasing award document as shown on the header |
| Award Document Code | award_document_code | award_document_code | Text | Code that identifies the type of purchasing award document (i.e. PO, DO, CT) |
| Row Number | row_number | row_number | Text | Field used for PM calculation to indicate the row number of the purchase over department and accounting period |
| Vendor State | vendor_state | vendor_state | Text | Field 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 Period | award_header_accounting_period | award_header_accounting_period | Text | Accounting period on the header of the purchasing award document |
| Accounting Period Date Format | accounting_period_date_format | accounting_period_date_format | Calendar date | Date format of the Award Header Fiscal Year and Accounting Period |
| Award Document Procurement Type Name | award_document_procurement_1 | award_document_procurement_1 | Text | Name for the procurement type used on the award document |
| Dept YTD Small Purchase AZ | dept_ytd_small_purchase_az | dept_ytd_small_purchase_az | Number | Field 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 Name | award_header_reporting_code_1 | award_header_reporting_code_1 | Text | Field on the header of the purchasing award document that indicates the name of the type of purchase |
| Vendor City | vendor_city | vendor_city | Text | Field from vendor address record that indicated the city the vendor is in (for the vendor of record on the purchasing document) |
| Award Department Code | award_department_code | award_department_code | Text | Code that identifies the department code of the purchasing award document |
| Award Header Accounting 12 Periods | award_header_accounting_12 | award_header_accounting_12 | Text | Accounting period on the header of the purchasing award document, with Period 13 listed as Period 12 |
| Purchase Under 25000 Flag | purchase_under_25000_flag | purchase_under_25000_flag | Checkbox | Field which indicates if the header of the purchasing award document was greater than or equal to $25,000 |
| Award Document Version Number | award_document_version_number | award_document_version_number | Text | Version 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 Year | award_header_fiscal_year | award_header_fiscal_year | Text | Fiscal year on the header of the purchasing award document |
| Award Document ID | award_document_id | award_document_id | Text | Document ID number of the Purchasing award document from the document header |
| Dept YTD Small Purchase Total | dept_ytd_small_purchase_total | dept_ytd_small_purchase_total | Number | Field used for PM calculation that shows the department's monthly small purchase total for the fiscal year to date |