Name: Location

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IPID (type: esriFieldTypeGUID, alias: Item of Plant ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• IPIDFKEY (type: esriFieldTypeGUID, alias: IPID of Related Asset (fk), SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ADDRESSNUMBER (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STREETNAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• PREFIX (type: esriFieldTypeString, alias: Prefix, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUFFIX (type: esriFieldTypeString, alias: Suffix, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FLOORNUMBER (type: esriFieldTypeSmallInteger, alias: Floor Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• APTNUMBER (type: esriFieldTypeString, alias: Apartment Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PLACENAME (type: esriFieldTypeString, alias: Place Name, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• NAME (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Relationships:

• TerminalHasLocation (37) -- Related To: Terminal (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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