Name: MicroMainWOLabor

Display Field: WO

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• WO (type: esriFieldTypeString, alias: WO, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• Labor (type: esriFieldTypeString, alias: Labor, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• LaborID (type: esriFieldTypeString, alias: LaborID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EstimatedTimeLabor (type: esriFieldTypeSingle, alias: EstimatedTimeLabor, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DateWork (type: esriFieldTypeDate, alias: DateWork, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• HoursRegular (type: esriFieldTypeSingle, alias: HoursRegular, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HoursOvertime (type: esriFieldTypeSingle, alias: HoursOvertime, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HoursDouble (type: esriFieldTypeSingle, alias: HoursDouble, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HoursOther (type: esriFieldTypeSingle, alias: HoursOther, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HoursExtended (type: esriFieldTypeSingle, alias: HoursExtended, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostRegular (type: esriFieldTypeDouble, alias: CostRegular, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostOvertime (type: esriFieldTypeDouble, alias: CostOvertime, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostDouble (type: esriFieldTypeDouble, alias: CostDouble, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostOther (type: esriFieldTypeDouble, alias: CostOther, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostExtendedEstimated (type: esriFieldTypeDouble, alias: CostExtendedEstimated, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostExtendedActual (type: esriFieldTypeDouble, alias: CostExtendedActual, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ChargeAuto (type: esriFieldTypeInteger, alias: ChargeAuto, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Charge (type: esriFieldTypeDouble, alias: Charge, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ChargePercentage (type: esriFieldTypeSingle, alias: ChargePercentage, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ChargeExtended (type: esriFieldTypeDouble, alias: ChargeExtended, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MaintenanceCategory (type: esriFieldTypeString, alias: MaintenanceCategory, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• Account (type: esriFieldTypeString, alias: Account, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
• CostAuto (type: esriFieldTypeInteger, alias: CostAuto, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TimeStamp (type: esriFieldTypeBlob, alias: TimeStamp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeIn (type: esriFieldTypeDate, alias: TimeIn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Timeout (type: esriFieldTypeDate, alias: Timeout, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shop (type: esriFieldTypeString, alias: Shop, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ShopSub (type: esriFieldTypeString, alias: ShopSub, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Done (type: esriFieldTypeDate, alias: Done, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: MicroMainWOLabor
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• WO:
• Labor:
• EstimatedTimeLabor: 0
• DateWork: -2209161600000
• HoursRegular: 0
• HoursOvertime: 0
• HoursDouble: 0
• HoursOther: 0
• HoursExtended: 0
• CostRegular: 0
• CostOvertime: 0
• CostDouble: 0
• CostOther: 0
• CostExtendedEstimated: 0
• CostExtendedActual: 0
• ChargeAuto: 0
• Charge: 0
• ChargePercentage: 0
• ChargeExtended: 0
• MaintenanceCategory:
• Account:
• CostAuto: 0

Relationships:

• MicroMainWO_Layer (0) -- Related To: MicroMainWO_Layer (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/5/2026 12:54:39 AM

Schema Last Edit Date: 4/5/2026 12:54:39 AM

Data Last Edit Date: 4/5/2026 12:54:39 AM

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