Name: Signs_InOfficeReport

Display Field: SignName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e9604ac2766342629ccc357432441607

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SignNumber ( type: esriFieldTypeString, alias: SignNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignNumber , Coded Values: [R1-130/2A7A: R1-130/2A7A] , [R1-130 (FACES): R1-130 (FACES)] , [R1-148/3B7A: R1-148/3B7A] , ...130 more... )
• SignName ( type: esriFieldTypeString, alias: SignName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignName , Coded Values: [STOP 30X30 (12/18 newman): STOP 30X30 (12/18 newman)] , [STOP 30X30 FACES (newman 12/15): STOP 30X30 FACES (newman 12/15)] , [STOP-Newman: STOP-Newman] , ...176 more... )
• PriceEach ( type: esriFieldTypeDouble, alias: PriceEach, editable: true, nullable: true, defaultValue: null, modelName: PriceEach )
• SAUsed_Num ( type: esriFieldTypeSmallInteger, alias: SAUsed_Num, editable: true, nullable: true, defaultValue: null, modelName: SAUsed_Num )
• SAUsed_Cost ( type: esriFieldTypeDouble, alias: SAUsed_Cost, editable: true, nullable: true, defaultValue: null, modelName: SAUsed_Cost )
• CRUsed_Num ( type: esriFieldTypeSmallInteger, alias: CRUsed_Num, editable: true, nullable: true, defaultValue: null, modelName: CRUsed_Num )
• CRUsed_Cost ( type: esriFieldTypeDouble, alias: CRUsed_Cost, editable: true, nullable: true, defaultValue: null, modelName: CRUsed_Cost )
• Sold_Num ( type: esriFieldTypeSmallInteger, alias: Sold_Num, editable: true, nullable: true, defaultValue: null, modelName: Sold_Num )
• Sold_Cost ( type: esriFieldTypeDouble, alias: Sold_Cost, editable: true, nullable: true, defaultValue: null, modelName: Sold_Cost )
• Trans_Num ( type: esriFieldTypeSmallInteger, alias: Trans_Num, editable: true, nullable: true, defaultValue: null, modelName: Trans_Num )
• Trans_Cost ( type: esriFieldTypeDouble, alias: Trans_Cost, editable: true, nullable: true, defaultValue: null, modelName: Trans_Cost )
• Obsolete_Num ( type: esriFieldTypeSmallInteger, alias: Obsolete_Num, editable: true, nullable: true, defaultValue: null, modelName: Obsolete_Num )
• Obsolete_Cost ( type: esriFieldTypeDouble, alias: Obsolete_Cost, editable: true, nullable: true, defaultValue: null, modelName: Obsolete_Cost )
• SignBalance ( type: esriFieldTypeSmallInteger, alias: SignBalance, editable: true, nullable: true, defaultValue: null, modelName: SignBalance )
• DateEntered ( type: esriFieldTypeDate, alias: DateEntered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateEntered )
• Quantity ( type: esriFieldTypeSmallInteger, alias: Quantity, editable: true, nullable: true, defaultValue: null, modelName: Quantity )
• WorkOrder ( type: esriFieldTypeString, alias: WorkOrder, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkOrder )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: DBO.Signs_InOfficeReport
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata