Name: CMIUTIL.PWMAIN.miu_Tools

Display Field: DESCRIPTION

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EQUIP_OID ( type: esriFieldTypeString, alias: EQUIP_OID, length: 255 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 255 )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Type Of Tool )
• EQUIPMENTUID ( type: esriFieldTypeString, alias: EQUIPMENTUID, length: 255 )
• COST ( type: esriFieldTypeDouble, alias: COST )
• QTY ( type: esriFieldTypeDouble, alias: QTY )
• DEPT ( type: esriFieldTypeString, alias: DEPT, length: 255 )
• PUR_DATE ( type: esriFieldTypeDate, alias: PUR_DATE, length: 8 )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: ASSIGNED_TO, length: 255 )
• DIV ( type: esriFieldTypeString, alias: DIV, length: 255 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• HYPER_LINK ( type: esriFieldTypeString, alias: HYPER_LINK, length: 255 )
• PROP_FAC_ID ( type: esriFieldTypeString, alias: PROP_FAC_ID, length: 255 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 30 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 30 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 30 )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )

Types:

ID: 0
Name: Unknown
Domains:

---

ID: 9
Name: Headlamp
Domains:

---

ID: 10
Name: Caulk Gun
Domains:

---

ID: 11
Name: Electric Drill
Domains:

---

ID: 1
Name: Batteries
Domains:

---

ID: 2
Name: Broom & Rakes
Domains:

---

ID: 3
Name: Caulk Gun
Domains:

---

ID: 4
Name: Chisels, Files & Bars
Domains:

---

ID: 5
Name: Drill-Drill Bits
Domains:

---

ID: 6
Name: Drill-Electric
Domains:

---

ID: 7
Name: Extension Cord
Domains:

---

ID: 12
Name: Electric Powered Equip (Large)
Domains:

---

ID: 13
Name: Gas Powered Equip (Large)
Domains:

---

ID: 14
Name: Grinder
Domains:

---

ID: 15
Name: Hammer-Hand
Domains:

---

ID: 16
Name: Jacking Equip
Domains:

---

ID: 17
Name: Knives, Cutter, Sissors
Domains:

---

ID: 18
Name: Levels
Domains:

---

ID: 19
Name: Lights (Lamps, Flashlights)
Domains:

---

ID: 20
Name: Measure-Tape Measure
Domains:

---

ID: 21
Name: Pliers
Domains:

---

ID: 22
Name: Pliers Locking-Vise Grips
Domains:

---

ID: 23
Name: Saw-Electric
Domains:

---

ID: 24
Name: Saw-Hand Saw
Domains:

---

ID: 25
Name: Screwdriver
Domains:

---

ID: 26
Name: Wrench
Domains:

---

ID: 27
Name: Misc Equip
Domains:

---

ID: 28
Name: Electric Meters, Strippers, GFIs
Domains:

---

Relationships:

• CMIUTIL.PWMAIN.City_Prop (1) -- Related To: City Property (2)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata