|
Field Name
|
Data Type
|
|---|---|
|
Custom Relationship Fields
|
|
|
PM Plan
|
MASTER-DETAIL
|
|
PM Coverage
|
LOOKUP
|
|
Work Order Purpose
|
LOOKUP
|
|
Other Fields
|
|
|
Adjusted Units
|
PICKLIST
|
|
Adjusted Value
|
NUMBER(16,2)
|
|
Adjustment Type
|
PICKLIST
|
|
Attr Data type
|
STRING
|
|
Attribute Field
|
STRING
|
|
Attribute Type
|
PICKLIST
|
|
Frequency
|
NUMBER(16,2)
|
|
Frequency Unit
|
PICKLIST
|
|
Max Activity Changed
|
NUMBER(16,2)
|
|
Min Activity Changed
|
NUMBER(16,2)
|
|
Operator
|
STRING
|
|
Processed
|
CHECKBOX
|
|
Record Number
|
NUMBER(18,0)
|
|
Recurring
|
CHECKBOX
|
|
Schedule Type
|
PICKLIST
|
|
Sequence
|
NUMBER(18,0)
|
|
Sort Order
|
NUMBER(9,0)
|
|
Start At
|
STRING
|
|
Stop At
|
STRING
|
|
Threshold
|
NUMBER(18,0)
|
|
Threshold Type
|
PICKLIST
|
|
Value
|
STRING
|
|
Visit Description
|
STRING
|