Name: miamidade_procurement_data_informs_2021

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• PO_NUMBER (type: esriFieldTypeInteger, alias: PO_NUMBER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PO_DATE (type: esriFieldTypeDate, alias: PO_DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• PO_AMOUNT (type: esriFieldTypeDouble, alias: PO_AMOUNT, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PO_LINE_NUMBER (type: esriFieldTypeInteger, alias: PO_LINE_NUMBER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• INVOICE_ITEM_ID (type: esriFieldTypeString, alias: INVOICE_ITEM_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PO_QUANTITY (type: esriFieldTypeString, alias: PO_QUANTITY, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• UOM_SIZE (type: esriFieldTypeString, alias: UOM_SIZE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• UNIT_COST (type: esriFieldTypeDouble, alias: UNIT_COST, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PHONE_AREA_INTL_CODE (type: esriFieldTypeInteger, alias: PHONE_AREA_INTL_CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PHONE_NUMBER (type: esriFieldTypeString, alias: PHONE_NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PHONE_EXTENSION (type: esriFieldTypeString, alias: PHONE_EXTENSION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SUPPLIER_ADDRESS (type: esriFieldTypeString, alias: SUPPLIER_ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POSTAL (type: esriFieldTypeString, alias: POSTAL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• COUNTRY (type: esriFieldTypeString, alias: COUNTRY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SUPPLIER_NAME (type: esriFieldTypeString, alias: SUPPLIER_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ITEM_DESCRIPTION (type: esriFieldTypeString, alias: ITEM_DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LONG_ITEM_DESCRIPTION (type: esriFieldTypeString, alias: LONG_ITEM_DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SUPPLIER_SHORT_NAME (type: esriFieldTypeString, alias: SUPPLIER_SHORT_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SUPPLIER_ADDRESS2 (type: esriFieldTypeString, alias: SUPPLIER_ADDRESS2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SUPPLIER_PHONE_TYPE (type: esriFieldTypeString, alias: SUPPLIER_PHONE_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BUSINESS_UNIT (type: esriFieldTypeString, alias: BUSINESS_UNIT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SUPPLIER_CONTRACT_ID (type: esriFieldTypeString, alias: SUPPLIER_CONTRACT_ID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ITEM_PHYSICAL_NATURE (type: esriFieldTypeString, alias: ITEM_PHYSICAL_NATURE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ITEM_CATEGORY (type: esriFieldTypeInteger, alias: ITEM_CATEGORY, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SUPPLIER_PO_TYPE (type: esriFieldTypeString, alias: SUPPLIER_PO_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PO_YEAR (type: esriFieldTypeInteger, alias: PO_YEAR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TICKET_YEAR (type: esriFieldTypeInteger, alias: TICKET_YEAR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/30/2025 12:35:57 PM

Schema Last Edit Date: 7/30/2025 12:35:57 PM

Data Last Edit Date: 7/30/2025 12:35:57 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat