Name: Work Order Info.
Display Field: craft_name
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:
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
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: null
Fields:
-
wo_no
(
type: esriFieldTypeString, alias: wo_no, length: 10
)
-
issued
(
type: esriFieldTypeDate, alias: issued, length: 8
)
-
target
(
type: esriFieldTypeDate, alias: target, length: 8
)
-
closed
(
type: esriFieldTypeDate, alias: closed, length: 8
)
-
wo_status
(
type: esriFieldTypeString, alias: wo_status, length: 1
)
-
system_id
(
type: esriFieldTypeString, alias: system_id, length: 25
)
-
wo_task
(
type: esriFieldTypeString, alias: wo_task, length: 4000
)
-
wo_type
(
type: esriFieldTypeString, alias: wo_type, length: 10
)
-
problem
(
type: esriFieldTypeString, alias: problem, length: 500
)
-
reason
(
type: esriFieldTypeString, alias: reason, length: 500
)
-
wo_udf1
(
type: esriFieldTypeString, alias: wo_udf1, length: 50
)
-
wo_udf2
(
type: esriFieldTypeString, alias: wo_udf2, length: 50
)
-
wo_udf3
(
type: esriFieldTypeString, alias: wo_udf3, length: 50
)
-
wo_udf4
(
type: esriFieldTypeString, alias: wo_udf4, length: 50
)
-
wo_udf5
(
type: esriFieldTypeString, alias: wo_udf5, length: 50
)
-
elapsed_hr
(
type: esriFieldTypeDouble, alias: elapsed_hr
)
-
wo_udf6
(
type: esriFieldTypeString, alias: wo_udf6, length: 50
)
-
wo_udf7
(
type: esriFieldTypeString, alias: wo_udf7, length: 50
)
-
wo_udf8
(
type: esriFieldTypeString, alias: wo_udf8, length: 50
)
-
wo_udf9
(
type: esriFieldTypeString, alias: wo_udf9, length: 50
)
-
wo_acct
(
type: esriFieldTypeString, alias: wo_acct, length: 21
)
-
project_no
(
type: esriFieldTypeString, alias: project_no, length: 50
)
-
sup_notes
(
type: esriFieldTypeString, alias: sup_notes, length: 500
)
-
county_prob
(
type: esriFieldTypeString, alias: county_prob, length: 20
)
-
claim_filed
(
type: esriFieldTypeString, alias: claim_filed, length: 20
)
-
cust_prob
(
type: esriFieldTypeString, alias: cust_prob, length: 20
)
-
action_next
(
type: esriFieldTypeString, alias: action_next, length: 20
)
-
work_code
(
type: esriFieldTypeString, alias: work_code, length: 20
)
-
priority_cd
(
type: esriFieldTypeString, alias: priority_cd, length: 10
)
-
maint_code
(
type: esriFieldTypeString, alias: maint_code, length: 12
)
-
wk_code
(
type: esriFieldTypeString, alias: wk_code, length: 10
)
-
wo_udf10
(
type: esriFieldTypeString, alias: wo_udf10, length: 50
)
-
wo_udf11
(
type: esriFieldTypeString, alias: wo_udf11, length: 50
)
-
w_in_progress
(
type: esriFieldTypeString, alias: w_in_progress, length: 10
)
-
work_request_no
(
type: esriFieldTypeString, alias: work_request_no, length: 10
)
-
approved_by
(
type: esriFieldTypeString, alias: approved_by, length: 25
)
-
approved_by_descr
(
type: esriFieldTypeString, alias: approved_by_descr, length: 20
)
-
assign_to
(
type: esriFieldTypeString, alias: assign_to, length: 25
)
-
assign_to_descr
(
type: esriFieldTypeString, alias: assign_to_descr, length: 20
)
-
loc_id
(
type: esriFieldTypeString, alias: loc_id, length: 10
)
-
loc_desc
(
type: esriFieldTypeString, alias: loc_desc, length: 500
)
-
craft_name
(
type: esriFieldTypeString, alias: craft_name, length: 20
)
-
ttl_hrs
(
type: esriFieldTypeDouble, alias: ttl_hrs
)
-
ttl_cost
(
type: esriFieldTypeDouble, alias: ttl_cost
)
-
ttl_qty
(
type: esriFieldTypeDouble, alias: ttl_qty
)
-
labor_cost
(
type: esriFieldTypeDouble, alias: labor_cost
)
-
parts_cost
(
type: esriFieldTypeDouble, alias: parts_cost
)
-
misc_cost
(
type: esriFieldTypeDouble, alias: misc_cost
)
-
contractor_cost
(
type: esriFieldTypeDouble, alias: contractor_cost
)
-
wrkqty_cost
(
type: esriFieldTypeDouble, alias: wrkqty_cost
)
-
equipment_cost
(
type: esriFieldTypeDouble, alias: equipment_cost
)
-
wo_cost
(
type: esriFieldTypeDouble, alias: wo_cost
)
-
crew_cost
(
type: esriFieldTypeDouble, alias: crew_cost
)
-
crew_ctr
(
type: esriFieldTypeDouble, alias: crew_ctr
)
-
misc_ctr
(
type: esriFieldTypeDouble, alias: misc_ctr
)
-
contractor_ctr
(
type: esriFieldTypeDouble, alias: contractor_ctr
)
-
wrkqty_ctr
(
type: esriFieldTypeDouble, alias: wrkqty_ctr
)
-
equipment_ctr
(
type: esriFieldTypeDouble, alias: equipment_ctr
)
-
first_name
(
type: esriFieldTypeString, alias: first_name, length: 15
)
-
last_name
(
type: esriFieldTypeString, alias: last_name, length: 15
)
-
phone1
(
type: esriFieldTypeString, alias: phone1, length: 16
)
-
phone2
(
type: esriFieldTypeString, alias: phone2, length: 16
)
-
email
(
type: esriFieldTypeString, alias: email, length: 99
)
-
street_number
(
type: esriFieldTypeString, alias: street_number, length: 10
)
-
street_name
(
type: esriFieldTypeString, alias: street_name, length: 30
)
-
cross_street
(
type: esriFieldTypeString, alias: cross_street, length: 30
)
-
city
(
type: esriFieldTypeString, alias: city, length: 30
)
-
state
(
type: esriFieldTypeString, alias: state, length: 30
)
-
zip_code
(
type: esriFieldTypeString, alias: zip_code, length: 10
)
-
loc_desc2
(
type: esriFieldTypeString, alias: loc_desc2, length: 500
)
-
complaint
(
type: esriFieldTypeString, alias: complaint, length: 500
)
-
comments
(
type: esriFieldTypeString, alias: comments, length: 500
)
-
problem_street_number
(
type: esriFieldTypeString, alias: problem_street_number, length: 10
)
-
problem_street_name
(
type: esriFieldTypeString, alias: problem_street_name, length: 30
)
-
problem_cross_street
(
type: esriFieldTypeString, alias: problem_cross_street, length: 30
)
-
problem_city
(
type: esriFieldTypeString, alias: problem_city, length: 30
)
-
problem_state
(
type: esriFieldTypeString, alias: problem_state, length: 30
)
-
problem_zip_code
(
type: esriFieldTypeString, alias: problem_zip_code, length: 10
)
-
notes
(
type: esriFieldTypeString, alias: notes, length: 500
)
-
use_cust_address
(
type: esriFieldTypeString, alias: use_cust_address, length: 1
)
-
rating
(
type: esriFieldTypeDouble, alias: rating
)
-
unit_id
(
type: esriFieldTypeString, alias: unit_id, length: 25
)
-
unit_type
(
type: esriFieldTypeString, alias: unit_type, length: 20
)
-
sub_type
(
type: esriFieldTypeString, alias: sub_type, length: 30
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
Relationships:
-
Channels (0) -- Related To:
Channels (1)
Supported Operations:
Query
Query Attachments
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata