Name: TilmData

Display Field: TilmID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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: N/A

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TilmID ( type: esriFieldTypeString, alias: TilmID, length: 16 )
• PurchaseDate ( type: esriFieldTypeDate, alias: PurchaseDate, length: 8 )
• POrder ( type: esriFieldTypeString, alias: POrder, length: 20 )
• PurchaseCost ( type: esriFieldTypeDouble, alias: PurchaseCost )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 16 )
• Model ( type: esriFieldTypeString, alias: Model, length: 20 )
• SerialNo ( type: esriFieldTypeString, alias: SerialNo, length: 20 )
• StockNo ( type: esriFieldTypeString, alias: StockNo, length: 16 )
• Status ( type: esriFieldTypeString, alias: Status, length: 32 )
• StatusLocate ( type: esriFieldTypeString, alias: StatusLocate, length: 16 )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• RetireDate ( type: esriFieldTypeDate, alias: RetireDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Type, length: 32 )
• SubType ( type: esriFieldTypeString, alias: SubType, length: 32 )
• Class ( type: esriFieldTypeString, alias: Class, length: 32 )
• KVA ( type: esriFieldTypeDouble, alias: Kva )
• HighSide ( type: esriFieldTypeDouble, alias: HighSideKv )
• LowSide ( type: esriFieldTypeString, alias: LowSideV, length: 12 )
• Impedance ( type: esriFieldTypeDouble, alias: Impedance )
• ConnectCode ( type: esriFieldTypeString, alias: Connect, length: 50 )
• Customers ( type: esriFieldTypeDouble, alias: Customers )
• LifeSupport ( type: esriFieldTypeString, alias: LifeSupport, length: 3 )
• WorkSketch ( type: esriFieldTypeString, alias: WOrder, length: 12 )
• LocateID ( type: esriFieldTypeString, alias: LocateID, length: 12 )
• Situs ( type: esriFieldTypeString, alias: Situs, length: 120 )
• remarks ( type: esriFieldTypeString, alias: Remarks, length: 50 )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, length: 252 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 20 )
• BankID ( type: esriFieldTypeString, alias: BankID, length: 12 )

Relationships:

• TilmHistory (55) -- Related To: TilmHistory (96)
• WSketchLink (43) -- Related To: WSketch link (88)
• Transformer (4) -- Related To: Transformer (1)
• SubTransformer (36) -- Related To: Substation Transformer (19)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata