Workflow query

The column ‘WorkflowFilter’ can be used to filter by workflow type, which makes the overview more simple. Without this column it is difficult to get a concise overview as many fields blank will be blank.

You can download the workflow data using the default ‘Workflows’ report.

Contents:

Filters

There are no required filters for this query.

Data provider settings

There are no data provider settings for this query.

Columns

Column

Description

Example

Column

Description

Example

NextState

Next workflow state’s name. See 'Full name' field for workflow state.

If the next state is a different workflow, the workflow name is also shown. Format: WorkflowName | NextState

Sent

NextStateDescription

Next workflow state’s description. See 'Description' field for workflow state.

Sent invoice(s)

NextStateDisplayName

Next workflow state’s display name. See 'To' field for workflow state transitions.

Format: WorkflowName | NextState

Invoice | Sent

NextStateID

Next workflow state’s unique ID in GUID format.

If there is no next state, then ID '00000000-0000-0000-0000-000000000000' is shown.

0c5805ce-675d-4872-bfdd-4bc1b7750449

NextStateName

Next workflow state’s display name see ‘Full name’ for workflow sate.

Sent

NextStateShortName

Next workflow state’s short name. See ‘Short name' field for workflow state. Applicable to order workflows only, otherwise is 'Full name’ field.

Sent

NextStateWorkflowName

Next workflow state's name. See 'Name' field for workflow.

Invoice

StateAddOrderLine

Indicates if the workflow state allows adding of services (orderlines). See 'Allow adding, deleting and moving order lines' field in workflow state.

Applicable to Order workflows only.

FALSE

StateCanDelete

This column is no longer used and is for backward compatibility only.

 

StateCanEdit

This column is no longer used and is for backward compatibility only.

 

StateColor

The background state color used in workflow state OPS Planboard columns. See 'Background color' field in workflow state.

Applicable to Order workflows only.

#FFFFFF

StateDescription

Workflow state’s description. See 'Description' field for workflow state.

Invoice Created

StateDisplayName

Workflow state’s display name.

Format: WorkflowName | NextState

Invoice | Created

StateEditOrderLine

Indicates if the workflow state allows services changes (orderlines). See 'Allow order line changes' field in workflow state.

Applicable to Order workflows only.

FALSE

StateForeColor

The foreground (text) state color used in state OPS Planboard columns. See 'Foreground color' field in workflow state.

Applicable to Order workflows only.

#000000

StateID

The workflow state’s unique ID in GUID format.

If there is a start transition state, then ID '00000000-0000-0000-0000-000000000000' is shown.

0bbd1382-c3d1-4378-9a17-a04839aac8c8

StateInboundFlightEditable

Indicates if the workflow state allows arrival flight changes. See 'Allow arrival changes' in workflow state.

Applicable to Order workflows only.

TRUE

StateIsCancelled

Indicates if the workflow state is a cancelled state. See 'Is order or service cancelled' field in workflow state.

FALSE

StateIsEndState

Indicates if the workflow state is the end of workflow state. See 'Is end of front office workflow' field in workflow state.

TRUE

StateName

Workflow state’s name. See 'Full name' field in workflow state.

For start transitions ‘>> start transition:’ is shown.

Cancelled

StateOrderEditable

Indicates if the workflow state allows order header changes. See 'Allow order header changes' field in workflow state.

Applicable to Order workflows only.

TRUE

StateOutboundFlightEditable

Indicates if the workflow state allows arrival flight changes. See 'Allow departure changes' in workflow state.

Applicable to Order workflows only.

TRUE

StateShortName

Workflow state’s short name. See 'Short name' field in workflow state.

Canx

StateSortIndex

Workflow state’s sort index. See ‘Sort index' field in workflow state.

100

StateSortOnETA

Indicates if the workflow state is sorted by arrival then departure. See 'Sort orders on arrival time in plan board' field in workflow state.

TRUE

StateVisibleForOps

This column is known to not work and will stop report generation.

 

StateVisibleForBackoffice

This column is known to not work and will stop report generation.

 

StateVisibleForRamp

Indicates if the workflow state is shown in the Classic Ramp screen. See 'Show fuel service in ramp screen' field in workflow state.

Applicable to Service, Stock mutation, Stock taking workflows only.

FALSE

StateVisibleInDFP

Indicates if the workflow state is included in the daily flight program report. See 'Include on daily handling order report' field in workflow state.

Applicable to Order workflows only.

TRUE

TransitionAction

Workflow state transition’s action. See 'Transition action screen' field in workflow state transitions. See also Transition actions.

SendToDebtor

TransitionActionConfigString

Workflow state transition’s config string. See 'Configuration string' field in workflow state transition.

ShowQuantity=true

TransitionActionDescription

Workflow state transition’s action description.

Send by email

TransitionActionType

Workflow state transition’s action workflow table type.

Invoice

TransitionDescription

Workflow state transition’s description. See 'Description' field in workflow state transition.

Send invoice(s) by email

TransitionID

The workflow state transition’s unique ID in GUID format.

6b35b08c-e062-4101-a9cf-064af575e71d

TransitionName

Workflow state transition’s name. See 'Name' field in workflow state transition.

Send by email or upload

TransitionRemarksRequired

Indicates if audit remarks are required for the workflow transition. See 'Require audit log remark' field in workflow state transition.

FALSE

TransitionRestrictedToFboLocationGroup

Indicates if the workflow state transition is restricted to a FBO location group. If blank, the workflow state transition is available to all locations. See 'Restricted to FBO location group' field in workflow state transition.

None

TransitionSortIndex

Workflow state transition’s sort index. See 'Sort index' field in workflow state transition.

10

WorkflowArrivalBeforeDeparture

Indicates if the workflow checks that the arrival should be before departure. See 'Arrival before departure check' field in workflow. Possible values:

  • ArrivalBeforeDeparture: TRUE

  • DepartureBeforeArrival: FALSE

  • EitherWay: FALSE

Applicable to Order workflows only.

TRUE

WorkflowDescription

Workflow’s description. See 'Description' field in workflow.

Flight handling orders

WorkflowDisplayName

Workflow’s display name. See 'Name' field in workflow.

HandlingOrder

WorkflowFilter

Workflow’s names uniquely numbered to allow easier filtering and sorting in excel.

Format: UniqueNumber WorkflowName

004    Invoice

WorkflowID

The workflow’s unique ID in GUID format.

45d61971-e5de-4172-a388-ba46ae9fb200

WorkflowName

Workflow’s name. See 'Name' field in workflow.

HandlingOrder

WorkflowSortIndex

Workflow’s sort index. See ‘Sort index’ field in workflow.

100

WorkflowToBeCancelledWorkflowState

Workflow’s to be cancelled state when cancelled by the handling importer. See 'To be cancelled' field in workflow.

HandlingOrder | To be cancelled

WorkflowType

The workflow’s type. Possible options:

  • Order

  • Service

  • Invoice

  • Entry

  • EntryPeriod

  • StockTaking

  • StockMutation

  • BulletinBoardMsg

  • OnlinePayment

  • PriceAgreement

  • All

  • Screen

  • RecurringOrder

Invoice