User's Manual

Variable list of columns

Below is a list of possible variables to access column/field values from operation, production order, project etc. These are the same variables used, when you add columns through the field chooser in ROB-EX and presented in a table. As an example the order list.

The variable names listed here are useful when customizing reports to suit specific customer requirements. But also in many other places like macros and GanttSetup configuration files, it is common to reference the variables. Depending on the situation, the variable must sometimes be embraced by curly brackets. E.g. writing {opr_name} will fetch the name of the operation. The documentation will state what the required notation is.

The list is categorized into these different categories:

Each object class describes to where the variable belongs. For instance the {order_quantity} field will extract the quantity from the selected production order. If the source is an operation, then the order is found via what order the operation belongs to.

The common category contains variables which will work across all the different object types: Project, Order, Opeation. As an example {common_id} will return the id of the object. E.g. if the object/row is an operation it will be the operation id, if the object is an order it will be the order id.

Campaign

Id Name Description
campaign_color Campaign color Color of the campaign
campaign_end Campaign end End of the campaign
campaign_name Campaign name Name of the campaign
campaign_product_family Campaign product family The product family of a campaign
campaign_quantity Campaign Quantity Quantity of the campaign
campaign_start Campaign start Start of the campaign
campaign_status Campaign status Status of the campaign
campaign_unused_quantity Campaign Unused quantity The unused quantity of the campaign
campaign_used_quantity Campaign Used quantity The used quantity of the campaign
resource_reservation_capacity Reservation capacity The capacity of the resource reservation
resource_reservation_end Reservation end End of the resource reservation
resource_reservation_name Reservation name Name of the resource reservation
resource_reservation_resource Reservation resource Name of the resource of resource reservation
resource_reservation_start Reservation start Start of the resource reservation
resource_reservation_start_end_changed_strategy Reservation start/end changed strategy The strategy defines what happens when the reservation start or end changes.
resource_reservation_status Reservation status Status of the resource reservation
resource_reservation_unused_wl Reservation unused workload The unused workload of the resource reservation
resource_reservation_used_wl Reservation used workload The used workload of the resource reservation
resource_reservation_workload Reservation workload Workload of the resource reservation

Common

Id Name Description
DataLogGivenHasLogsLayoutItem Has logs Return whether or not the given object (operation, order etc) has any data logs.
DataLogGivenIndexLayoutItem Log message at index Returns the data log at the given index
DocumentNameLayoutItem Document name The name of the attached document. If multiple documents are attached, the first from the sorted order is shown. Use the ‘Visible document indexes’-property to give a semicolon separated list of indexes to be shown, starting from 0. Example: 0;1 will show the names of the first two documents from the list of sorted documents.
DocumentPathAndNameLayoutItem Document path & name The path and name of the attached document. If multiple documents are attached, the first from the sorted order is shown. Use the ‘Visible document indexes’-property to give a semicolon separated list of indexes to be shown, starting from 0. Example: 0;1 will show the paths and names of the first two documents from the list of sorted documents.
DocumentPathLayoutItem Document path The path of the attached document. If multiple documents are attached, the first from the sorted order is shown. Use the ‘Visible document indexes’-property to give a semicolon separated list of indexes to be shown, starting from 0. Example: 0;1 will show the paths of the first two documents from the list of sorted documents.
LastDataLogLayoutItem Latest log messages Returns a defined number of the latest data logs.
OperationWorkloadPerResourceTypeLayoutItem Workload per resource type (Common) Group operation workload by specified resource type name. In “Edit -> Resource” it is possible to manage resource types and assign them to the resources. In order to use it on reports specify the resource type like this:
project.LayoutItem.OperationWorkloadPerResourceTypeLayoutItem.resTypeName=Engineering”
VeryLastDataLogLayoutItem Latest log message Returns the last data log.
common_baseline_diff Baseline diff Shows the difference between planned end and actual end for operations in progress.
If behind schedule a negative number will appear.
common_baseline_end_is_late Late end (Common) Shows an exclamation mark if the actual end date is after the planned end date, and thus the operation is finished later than planned. It will also show if current day is after planned end day
common_baseline_start_is_late Late start (Common) Shows an exclamation mark if the actual start date is after the planned start date, and thus the operation is started later than planned. It will also show if current day is after planned start day
common_changed_date Changed date (Common) The date that this object was last changed.
common_description Description (Common)
common_duration Duration (Common) Shows the difference between start and end – of an operation, order or a project.
common_early Early (Common) Shows the difference between earliest operation start and start date on either an order or a project. Not applicable for an operation. Used in KPI.
common_has_violated_constraints Constraint warning (Common) Shows an exclamation mark if:
1. There’s an operation which starts earlier than the previous one in the route.
common_id Id (Common) Shows the uique id of the object, i.e. a project, order or an operation etc.
common_index_in_project Index in project For orders/projects, if they are in a project, returns their index in that project.
common_isDirty Is dirty (Common) Is this object marked as changed. Thus it will get exported next time.
common_isLate_backlog Is late backlog (common) Returns whether or not an operation is late or in cases wherethere are multiple operations e.g. orders, whether or not any operations is late.
An operation is late, if it is in state PLANNED or START POSSIBLEbut its planned start time is before now or if the operation is in state STARTED or PAUSED but its actual end is before now, otherwise it is not late.
common_late Late (Common) Shows the difference between latest operation end and delivery/end date on either an order or a project. Not applicable for an operation. Used in KPI.
common_late_hours Late in hours (Common) Shows the difference between latest operation end and delivery/end date on either an order or a project. Not applicable for an operation. Used in KPI.
common_lead Lead (Common) Shows the difference between (earliest) start and (latest) end – of an operation, order or a project. Used in KPI.
common_name Name (Common) Shows the name of the object, i.e. a project, order or an operation etc.
common_price_realised_sum Price realized, sum (Common) Shows the realized price of an operation, or the sum of an order or a project including the realized price of the order/project itself.
common_process_div_by_lead Workload / lead (Common) The workload divided by the leadtime (duration). This gives the “efficiency” of the schedule. Used in KPI.
common_quantity Quantity (Common) Shows the quantity of an operation or the quantity sum of an order or a project.
common_resource_description Resource description (Common) For an operation this returns its resource’s description. For route/order this returns a list of resource descriptions for all operations.
common_resource_id Resource id (Common) Shows the unique id of the selected resource for an operation. For orders or projects it shows a list of resource ids.
common_resource_name Resource (Common) Shows the name of the selected resource for an operation. For orders or projects it shows a list of resources.
common_setup Setup (Common) Shows the setup time of an operation or the sum for an order or a project.
common_site_id Site id (Common) Shows the site id of the site this object belongs to
common_status Status (Common) Shows the status of a project, order or an operation.
common_status_level Status level (Common) Shows the status level of a project, order or an operation.
common_switchover Switch over (Common) Shows the switch over time of an operation or the sum for an order or a project.
common_workload Workload (Common) Shows the workload for each operation or the sum of workload in a production order or a project. Notice that operations on a resource which doesn’t contribute to the workload graph will not contribute to the workload sum.
order_tree Name Special field used in project overview to show the project tree. The field has some advanced settings that can be used to specify a Viewlayout for each of the tree nodes: project, order, operation.
resource_views Resource views Show all the names of the resourceviews this object is using resources from.

Constraint arc

Id Name Description
constraint_arc_destination_id Destination id Note: Item is not visible in field chooser! The destination id of the constraint arc
constraint_arc_destination_parent_id Destination parent id Note: Item is not visible in field chooser! The destination parent id of the constraint arc
constraint_arc_hardlink Hardlink Note: Item is not visible in field chooser! Shows whether or not the constraint arc is hardlinked
constraint_arc_instance_type_int Instance type (integer) Note: Item is not visible in field chooser! Shows the instance type of the constraint arc as an integer
constraint_arc_source_id Source id Note: Item is not visible in field chooser! The source id of the constraint arc
constraint_arc_source_parent_id Source parent id Note: Item is not visible in field chooser! The source parent id of the constraint arc

Demand line

Id Name Description
demand_line_intermediates Intermediates Intermediates for this demand

Material

Id Name Description
material_alternate_std_unit Alternate std. unit This alternate std. unit is used where no other unit is specified
material_alternate_unit_type Alternate unit type Specify an alternate unite type in order to convert between two unit types, I.E. from volume to weight. A conversion factor must be specified.
material_color Color
material_conversion_factor Conversion factor Conversion factor to convert between unit type and alternate unit type.
material_critical_procurement_date Critical procurement date The earliest possible arrival of a procurement of the given material.
material_custom_boolean_1 Boolean 1
material_custom_boolean_2 Boolean 2
material_custom_double_1 Float 1 Float 1
material_custom_double_2 Float 2 Float 2
material_custom_int_1 Integer 1 Integer 1
material_custom_int_2 Integer 2 Integer 2
material_custom_text_1 Text 1
material_custom_text_2 Text 2
material_description Description
material_join_look_ahead Join look ahead The join look ahead is the number of hours to look ahead when finding demands to join.
material_max_order_quantity Max. order quantity The maximum order quantity is the maximum value an order quantity can have for new orders.
material_min_order_quantity Min. order quantity The minimum order quantity is the minimum value an order quantity can have for new orders.
material_name Name
material_number No.
material_order_multiple Order multiple The order multiple is the multiple an order quantity must be in for new orders.
material_priority Priority The priority of this material
material_procurement_calendar Procurement calendar The calendar used in procurement of the given material.
material_procurement_leadtime Procurement leadtime (days) The time in days it will take for a procurement of the given material to be available.
material_procurement_type Procurement type Setup if the material is to be produced internally, externally or both.
material_settings Settings More settings
material_shelf_life Shelf life The standard shelf life of a material. This value can be overridden on the BOM line on an operation.
material_shelf_life_settings Shelf life settings Settings concerning shelf life
material_significant_in_pegging Use in pegging A true/false saying if the pegging macro should consider this material during pegging.
material_significant_in_planning Use in planning A true/false saying if planning rules should consider this material during scheduling with BOM as a constraint.
material_std_unit Std. unit This std. unit is used where no other unit is specified
material_type Material type Setup if the material for instance is a semifinished product or a finished product.
material_unit_type Unit type The unittype influence the set of unit’s that can be chosen
material_use_transaction_status_on_inventory_calc Use BOM line status Use BOM line status on inventory calculation. If a BOM line has status ‘Unconfirmed’ a possibly subsequent counting will be adjusted by the BOM quantity.
rawmaterialproperty Property (Material)

Material category

Id Name Description
raw_material_category_one Category 1
raw_material_category_one_value Category 1 value
raw_material_category_three Category 3
raw_material_category_three_value Category 3 value
raw_material_category_two Category 2
raw_material_category_two_value Category 2 value

Material transaction

Id Name Description
raw_material_access_actual_consumption Actual consumption The actual consumption/production of the material access. Can be used to override the ‘expected’ consumption/production of the access.
raw_material_access_consumption_method Consumption method The method for consuming/producing a material on an access e.g. start, end or linear.
raw_material_access_effective_access Calculated amount The effective or calculated production/consumption of the access, this accounts for unit factor. For consumption this is a negative number.
raw_material_access_linked_to_operation Linked to operation If the material access is linked to (dependent of) an operation the name of that operation will be shown in this column.
raw_material_access_linked_to_order Linked to order If the material access is linked to (dependent of) an order the name of that order will be shown in this column.
raw_material_access_material_shortage Material shortage colors Show the material shortage color scheme per BOM line
raw_material_access_offset_hours Offset in hours Offset in hours compared to the host operation
raw_material_access_offset_pct Offset in pct Offset in pct compared to the host operation
raw_material_access_offset_qty Offset in qty Offset in qty compared to the host operation
raw_material_access_rate Rate The rate at which the access is consumed/produced. This is only applicable if the access strategy is not ‘Fixed’.
raw_material_access_static_quantity Static quantity The static quantity consumed/produced by this access. This is only applicable if the access strategy is ‘Fixed’.
raw_material_access_strategy Strategy The material access strategy. Fixed, per piece or units per hour.
raw_material_access_type Type The material access type, consuming or producing.
raw_material_access_unit Unit The material access unit. If the unit type is e.g. ‘Lenght’, this could be ‘cm’, ‘m ‘ or ‘inch’.
raw_material_access_warehouse Warehouse
raw_material_transaction_alternative_material_option Alternative material option Specify if this is a primary material or an alternative material. The macro “UpdateMaterialDates” can substitute a primary material by one or more alternatives if not enough in stock.
raw_material_transaction_amount Amount Amount
raw_material_transaction_begin_date Start date Start date
raw_material_transaction_custom_boolean1 Custom boolean1
raw_material_transaction_custom_boolean2 Custom boolean2
raw_material_transaction_customer Customer The customer
raw_material_transaction_description Description
raw_material_transaction_diluted_amount Diluted amount Diluted amount
raw_material_transaction_disabled Disabled If the transaction is disabled it will not influence the material graph.
raw_material_transaction_end_date End date End date
raw_material_transaction_expiration_date Expiration date Expiration date
raw_material_transaction_internal_batch_no Internal batch no.
raw_material_transaction_line_no Line no. Set the line no. on a transaction in order to control the sequence.
raw_material_transaction_material_name Name
raw_material_transaction_material_number No.
raw_material_transaction_responsible Responsible
raw_material_transaction_resulting_warehouse_inventory Resulting inventory the resulting inventory, in the warehouse and of the material of the transaction
raw_material_transaction_shelfLife Shelf life The std shelf life set on the material can be overridden on the transaction.
raw_material_transaction_state State If the state is set to ‘Unconfirmed’ a possibly subsequent counting will get adjusted by the BOM line quantity. Notice that field on master material ‘Use BOM line status’ must be enabled, or GanttSetup option ‘bom.line.confirmation.active’ must be set to ‘on’. If no state is set it is considered ‘Unconfirmed’. See the manual for more info.
raw_material_transaction_status_changed_initials Status changed by
raw_material_transaction_supplier Supplier
raw_material_transaction_supplier_batch_no Supplier batch no.
raw_material_transaction_type Transaction type Shipment/counting/purchase
raw_material_transaction_warehouse_selection_strategy Warehouse selection strategy Specify a strategy for how a warehouse should be selected. With the “Default” strategy the warehouse is selected manually from the list. Other strategies exist to update the warehouse selection automatically.
rawmaterialtransactionproperty Property (MaterialTransaction)

Operation

Id Name Description
operation_end_on_time_state Operation on-time end state The Operation’s on-time end state. The state depends on the relative distance between the planned end and actual end of the operation.
operation_end_on_time_state_color Operation on-time end state color The color of the Operation’s on-time end state.
operation_end_on_time_state_color_hex Operation on-time end state hex color The hex color representation of the Operation’s on-time end state.
operation_end_on_time_state_level Operation on-time end state level The level representation of the Operation’s on-time end state.
operation_start_on_time_state Operation on-time start state The Operation’s on-time start state. The state depends on the relative distance between the planned start and actual start of the operation.
operation_start_on_time_state_color Operation on-time start state color The color of the Operation’s on-time start state.
operation_start_on_time_state_color_hex Operation on-time start state hex color The hex color representation of the Operation’s on-time start state.
operation_start_on_time_state_level Operation on-time start state level The level representation of the Operation’s on-time start state.
operationdelivery Deliverytime
operationproperty Property (Operation)
opr_actual_end_time Actual End Shows the actual end time for operations in progress (started or higher).
opr_actual_start_time Actual start Shows the actual start time for operations in progress (started or higher).
opr_baseline1_end Baseline 1 end The baseline 1 end time
opr_baseline1_start Baseline 1 start The baseline 1 start time
opr_capacity Capacity The capacity of the operation, i.e. units per hour.
opr_custom_boolean1 Boolean 1 Free boolean field
opr_custom_boolean2 Boolean 2 Free boolean field
opr_custom_double1 Float 1 Free float field.
opr_custom_int1 Integer 1 Free integer field.
opr_custom_int2 Integer 2 Free integer field.
opr_custom_text1 Text 1 Free text field.
opr_custom_text2 Text 2 Free text field.
opr_custom_text3 Text 3 Free text field.
opr_custom_text4 Text 4 Free text field.
opr_cycle_time_hours Cycle time (hours) Average cycle time in hours. Workload in hours divided by quantity.
opr_cycle_time_minutes Cycle time (minutes) Average cycle time in minutes. Workload in minutes divided by quantity.
opr_delivery_datetime_isOverwritten Delivery date overwritten Returns true if the operation has its own delivery date, false otherwise.
opr_dep_on Depends on The operation numbers this operation depends on. Operation networks can be edited here by specifying a comma separated list of operations numbers the operation must depend on.
opr_description Description
opr_disabled Disabled Is the operation disabled (If disabled it will act as if it does not exist)
opr_duration Duration The difference between start -and end time. If the operation respects a resource calendar, the duration will normally be different from the workload.
opr_efficiency Efficiency If 50% the operation will take twice the time to finish.
opr_end_time End The end time of the operation. If the operation is in progress (started or higher) this will show the actual end time.
opr_end_time_readable End (Readable) The end time of the operation in a readable format.
opr_first_access First material in list The name of the first material which the operation consumes or produces.
opr_flow_master Flow master TankSplit: When using flow scheduling this operation will be a flow master
opr_flow_slave Flow slave TankSplit: When using flow scheduling this operation will be a flow slave (updated according to flow masters)
opr_gross_quantity Gross quantity Quantity * quantity factor
opr_group Group The operationgroup this operation belongs to.
opr_id Opr. id The unique id of an operation. Generated by the system and cannot be changed by the user.
opr_label Opr no.
opr_last_progress_report Last progress report
opr_level Level The level of the operation in the sequence (network)
opr_locked Operation locked Shows if the operation is locked. If it’s locked it can not be moved in time.
opr_material_calendar Material The expected time where the raw material is in stock.
opr_material_datetime_isOverwritten Material date overwritten Returns true if the operation has its own material date, false otherwise.
opr_name Name The name of an operation. It’s normally inherited from the template operation.
opr_next_resource Prev. res. The name of the resources of connected operations before this resource.
opr_num

The operations number in this sequence
opr_overall_progress_hours Progress in hours Progress in hours of the total workload (including setup, switch over etc.). I.e. if there’re two hours of setup time and there’re reported four hours, the setup time will get finished and there will be reported two hours of the workload. If hours has been reported in workload then setup is assumed to be done and is then not included.
opr_overall_progress_hours_left Progress left in hours Remaining hours – including setup, switch over etc.
opr_overall_progress_pct Progress % Progress in percent of the total workload (including setup, switch over etc.). I.e. if there’re two hours of setup time and there’re reported four hours, the setup time will get finished and there will be reported two hours of the workload.
opr_overall_progress_pct_left Progress left %
opr_overlap Overlap Shows the overlap in hours set on the operation.
opr_pause_process Pause process TankSplit: When using tank split the “PAUSE_PROCESS” option indicates that the processing equipment can pause (splits not hardlinked to each other)
opr_planned_end_time Planned end Shows the planned end time for an operation. This might be different from actual end time for an operation in progress.
opr_planned_start_time Planned start Shows the planned start time for an operation. This might be different from actual start time for an operation in progress.
opr_planning_factor Planning factor If the calendar factor on a resource is 6 and an operation has planning factor of 2 then 3 operations can run in parallel on the resource.
opr_post_queue Post queue time The post queue time is after the switch over time and do not respect the resource calendar.
opr_pre_queue Prev. queue time Pre queue time is before setup time and do not respect the resource calendar.
opr_previous_resource Prev. res. The name of the resources of connected operations before this resource.
opr_price_realised Price realized The price of this operation. This can be fixed or calculated from an hour rate on the resource.
opr_progress_quantity Progress quantity
opr_progress_quantity_left Progress left in quantity
opr_progress_quantity_scrap Scrap quantity The quantity of bad pieces produced. This will not influence the progress left.
opr_progress_setup_hours_left Setup progress left in hours Remaining setup hours.
opr_progress_switchover_hours_left Switchover progress left in hours Remaining switchover hours.
opr_progress_workload_hours Progress, wl in hours Progress of just the workload. When entering in this field a possibly planned setup time will be completed as well (provided nothing is already reported there).
opr_progress_workload_hours_extra Progress wl in hours, extra If the work performed on the operation exceeds the planned workload, the exceeding part can be specified on this field.
opr_progress_workload_hours_left Workload progress left in hours Remaining workload hours.
opr_quantity Quantity The quantity of the operation. Specify 0 to use the order quantity.
opr_quantity_factor Quantityfactor A factor which the quantity is multiplied by.
opr_quantity_in Quantity In When using waste, it’s possible to specify either the ingoing or outgoing quantity and get the “other” calculated from a waste factor.
opr_quantity_out Quantity Out When using waste, it’s possible to specify either the ingoing or outgoing quantity and get the “other” calculated from a waste factor.
opr_quantity_prod/rem Opr qty prod. / qty rem. Quantity produced / quantity remaining. Displays the amount of quantity before and after now.
opr_resource Resource The name of the selected resource.
opr_resource_reservation Resource reservation The resource reservation this operation belongs to
opr_setup Setup time The setup is performed before the workload.
opr_setup_decimal Setup time (decimal) The amount of setup required for the operation, in hours. Shown as a decimal number.
opr_setup_progress_pct Progress setup % Progress of just the setup time.
opr_splitMember Split member Shows “Yes” if the operation is a split member. Otherwise “No”.
opr_split_as_next Split as next TankSplit: If next operation is a tank split operation and splitted during scheduling this operation will be split in the same amounts
opr_split_as_previous Split as prev. TankSplit: If previous operation is a tank split operation and splitted during scheduling this operation will be split in the same amounts
opr_start_time Start The start time of the operation. If the operation is in progress (started or higher) this will show the actual start time.
opr_start_time_readable Start (Readable) The start time of the operation in a readable format.
opr_state Status The status of the operation, i.e. planned, started etc.
opr_state_level Status level The status of the operation, i.e. planned, started, represented as an integer
opr_sub_operations Sub-oprs. Number of sub-operations attached to this operation.
opr_subop Is sub-op. Is this operation an sub-operation.
opr_subop_link_step Sub-op. link The step this sub operation is linked to it’s main operation with.
opr_subop_parent Sub-op. parent The parent of this sub-operation
opr_subop_update_type Sub-op. update The field which is updated when the main operation changes
opr_switchover Switch over time The switch over is peformed after the workload.
opr_switchover_decimal Switchover time (decimal) The amount of switchover time required for the operation, in hours. Shown as a decimal number.
opr_switchover_progress_pct Progress switch over % Progress of just the switch over time.
opr_tags Tags Comma separated list of tags associated with the operation
opr_tank_split_op Tank Split TankSplit: Use special tank split planning for this operation
opr_target_workload Target workload Target workload. Operation workload is copied to this field as long as the operation state is below or equal to the statusSetpoint setting (operation.targetWorkload.statusSetpoint in GanttSetup.properties). Default statusSetpoint is 20 (PLANNED)
opr_transport Transport time The transport time is after post queue time and respects the resource calendar.
opr_waste_factor Waste factor When using waste, it’s possible to specify either the ingoing or outgoing quantity and get the “other” calculated from a waste factor.
opr_workload Workload The amount of work in the operation, in hours.
opr_workload_decimal Workload (decimal) The amount of work in the operation, in hours. Show as a decimal number.
opr_workload_factor Workloadfactor When calculating workload, the workload is multiplied by this factor. This can for instance be used as an conversion factor – i.e. converting from minutes to hours.
opr_workload_progress_pct Progress wl % Progress of just the workload. When entering in this field a possibly planned setup time will be completed as well (provided nothing is already reported there)
opr_workload_type_int Workload type The workload type represented as integer (fixed=0, capacity=1).

Order

Id Name Description
operationtime Operationtime
oprseq_description Route desc. The route description
oprseq_name Route name The route name
order_alternate_name Alternate name Alternate name or number
order_campaign Campaign The campaign of an order
order_color Color A different color can be defined on each order. Among others this is used to color the Gantt chart by order colors.
order_custom_boolean1 Boolean 1 Free boolean field (true/false)
order_custom_boolean2 Boolean 2 Free boolean field (true/false)
order_custom_boolean3 Boolean 3 Free boolean field (true/false)
order_custom_calendar1 Calendar 1 Free calendar field
order_custom_calendar2 Calendar 2 Free calendar field
order_custom_calendar3 Calendar 3 Free calendar field
order_custom_calendar4 Calendar 4 Free calendar field
order_custom_int1 Integer 1 Free integer field
order_custom_int2 Integer 2 Free integer field
order_custom_text1 Text 1 Free text field
order_custom_text2 Text 2 Free text field
order_custom_text3 Text 3 Free text field
order_custom_text4 Text 4 Free text field
order_custom_text5 Text 5 Free text field
order_custom_text6 Text 6 Free text field
order_custom_text7 Text 7 Free text field
order_custom_text8 Text 8 Free text field
order_customer_name Customer The customer name
order_delivery_calendar Delivery The promised delivery calendar. It’s possible to schedule backward from delivery (due date).
order_delivery_calendar_readable Delivery (Readable) Note: Item is not visible in field chooser! The promised delivery calendar in a readable format.
order_delivery_color_today Color delivery today If delivery is today color yellow. If delivery is in the past color red. If start is today color green.
order_delivery_exceeded Delivery exceeded This will show a warning if the last operation ends after the delivery date.
order_delivery_on_time_state Order on-time delivery state The order’s on-time delivery state. The state depends on the relative distance between the order’s last operation end and its delivery date. The different breakpoints can be configured. Look for ‘onTimeDeliveryState’ in the GanttSetup.properties topic.
order_delivery_on_time_state_color Order on-time delivery state color The color of the order’s on-time delivery state
order_delivery_on_time_state_color_hex Order on-time delivery state hex color The hex color representation of the order’s on-time delivery state
order_delivery_on_time_state_level Order on-time delivery state level The level representation of the order’s on-time delivery state
order_description Description Description of the order.
order_first_operation_resource Resource on 1. opr The name of the resource on the first operation in the order.
order_first_operation_start Start This is the start time of the first opration in the order.
order_id Order id The unique ID of the production order. This is generated by the system and cannot be changed by the user.
order_integration_locked Integration locked This is used in XAL DB Sync. If true the order is skipped (not updated) when integrating.
order_last_operation_end Last operation end This is the end time of the last operation in the order.
order_latest_progress_calendar Latest progress calendar The latest progress calendar of the operations in the order
order_locked Order locked The operations in the order can not be moved in time.
order_lot_no Lot no. An integer field allowing user to specify lot or batch number. If using route networks this will get specified automatically.
order_material_calendar Material The expected time where the raw material is in stock. This is relevant if an operation in an order consumes a raw material and thus it can not start before the raw material is available. It’s possible to schedule forward from material calendar.
order_material_calendar_readable Material (Readable) Note: Item is not visible in field chooser! The material calendar in a readable format.
order_name Order no. The order number. Generated by the system, but can be changed. This can also contain text.
order_order_type Order type Shows the order type of the order. Default order type is ‘default’. More types can be added from a plugin. On the New order dialog the order types can be selected if more than the ‘default’ exist.
order_ordered_name Ordered by, name A reference to the person who ordered this order.
order_ordered_phone Ordered by, phone no. A reference to the person who ordered this order.
order_precondition Precondition This must be checked before the state can be changed from released to start possible.
order_priority Priority The priority is used when scheduling orders. The orders can be sorted by priority and thus the ones with the highest priority are scheduled first.
order_product_id Item name The product this order produces.
order_quantity Quantity The quantity of the order
order_quantity_in Quantity In When using waste the ingoing and outgoing quantity will be different.
order_quantity_out Quantity Out When using waste the ingoing and outgoing quantity will be different.
order_series_id Series id The id of the operation serie of an order.
order_series_name Series name The name of the operation serie of an order.
order_state Status Shows the state of the order, i.e. planned, released or started etc.
order_state_level Status level Shows the state of the order, i.e. planned, released or started etc, represented as an Integer.
order_waste_factor Acc. waste factor A possible waste factor. When using waste the ingoing and outgoing quantity will be different.
order_will_be_exported Will be exported If this object is an order: If dirty (is changed) is true or one of the operations in the order is dirty, the order will get exported next time.
productionorderproperty Property (Order)
suborder_links_in Sub-order links in A comma separated list of all orders having sub-order links pointing to the order
suborder_links_out Sub-order links out A comma separated list of all orders this order has sub-order links to

Pegging

Id Name Description
material_is_pegged Pegged Shows whether or not the operations are pegged based on their material production and/or consumption.
material_pegging_amounts Pegging amounts Show the amount produced and remaining on source operation (‘S:’), and show the demand and unfulfilled amounts on destination operation (‘D:’). Example on source operation: If it produces 1000 pieces and 300 is consumed from it, following text should appear: “S:1000/+700” (S=Source, 1000=Produced quantity, +700=remaing, unconsumed quantity). Example on consuming operation: An operation has a demand on 1500 pieces and have got fulfilled 900. Following text should appear: “D:1500/-600” (D=Destination, 1500=The demand, -600=the unfulfilled part).
material_pegging_duration Pegging duration The duration between the pegged orders. If a destination order is pegged to multiple source orders, the longest duration is displayed.
material_pegging_pegged_materials Pegged Materials Shows the pegged materials used.
material_pegging_pegged_materials_number Pegged Materials (number) Shows the pegged material numbers used.
material_pegging_source Pegging source If the current order is a destination order this will show the source resource(s).
material_pegging_source_type Pegging source type If the current transaction is a destination transaction this will show the source type (Operation, Counting or Purchase).

Product family

Id Name Description
product_family_color Color Color of the productfamily
product_family_custom_boolean_1 Custom boolean 1 Custom boolean 1 of the productfamily
product_family_custom_boolean_2 Custom boolean 2 Custom boolean 2 of the productfamily
product_family_custom_double_1 Custom double 1 Free float field
product_family_custom_double_2 Custom double 2 Free float field
product_family_custom_int_1 Custom int 1 Custom int 1 of the productfamily
product_family_custom_int_2 Custom int 2 Custom int 2 of the productfamily
product_family_custom_text_1 Custom text 1 Custom text 1 of the productfamily
product_family_custom_text_2 Custom text 2 Custom text 2 of the productfamily
product_family_description Description Description of the productfamily
product_family_id Id
product_family_name Name Name of the productfamily

Project

Id Name Description
ProjectNumberGivenLevelLayoutItem Project no. (level) null
project_account_name Account name Used for economy. Available accounts can be selected from a list in this column.
project_account_no Account no. Shows the account number of the selected account.
project_chosen_order_count Production order count The quantity of orders in the project.
project_chosen_orders Chosen production order Shows a list of the orders in the project.
project_color Color
project_custom_date_time_1 Calendar 1 Free calendar field.
project_custom_date_time_2 Calendar 2 Free calendar field.
project_custom_date_time_3 Calendar 3 Free calendar field.
project_custom_date_time_4 Calendar 4 Free calendar field.
project_custom_double_1 Float 1 Free float field.
project_custom_double_2 Float 2 Free float field.
project_custom_double_3 Float 3 Free float field.
project_custom_double_4 Float 4 Free float field.
project_custom_int_1 Integer 1 Free integer field.
project_custom_int_2 Integer 2 Free integer field.
project_custom_int_3 Integer 3 Free integer field.
project_custom_int_4 Integer 4 Free integer field.
project_customer Customer
project_customtext1 Text 1 Free text field.
project_customtext2 Text 2 Free text field.
project_customtext3 Text 3 Free text field.
project_customtext4 Text 4 Free text field.
project_customtext5 Text 5 Free text field.
project_customtext6 Text 6 Free text field.
project_customtext7 Text 7 Free text field.
project_customtext8 Text 8 Free text field.
project_delivery_on_time_state Project on-time delivery state The Project’s on-time delivery state. The state depends on the relative distance between the last operation end over all the orders and the project’s delivery date. The different breakpoints can be configured. Look for ‘onTimeDeliveryState’ in the GanttSetup.properties topic.
project_delivery_on_time_state_color Project on-time delivery state color The color of the Project’s on-time delivery state.
project_delivery_on_time_state_color_hex Project on-time delivery state hex color The hex color representation of the Project’s on-time delivery state.
project_delivery_on_time_state_level Project on-time delivery state level The level representation of the Project’s on-time delivery state.
project_earliest_start_time Actual start The start time of the first (earliest) operation in the project.
project_email E-mail
project_end_time Due date The planned delivery date of a project.
project_latest_end_time Actual end The end time of the last (latest) operation in the project.
project_level Level Shows the level of a project in the project hierarchy.
project_lot_size Lot size Used in route networks. If the quantity of the project is 10 and lot size is 5, 2 orders will be generated with quantity of 5 each.
project_manager Project mgr.
project_name Project name
project_no Project no. The project number. Generated by the system, but can be changed. Can also contain text.
project_no_in_hierarchy Project no. (hierarchy) Same content as ‘Project no.’ column, but sorts according to hierarchy of sub and parent projects. Level 1 projects are sorted alphabetically.
project_parent_id Parent project no.
project_phone Phone no.
project_priority Priority Integer field. Set the priority of a project. Can be used when scheduling several projects – if projects are sorted by priority.
project_quantity Quantity Project quantity. Used with route networks.
project_responsible1 Responsible 1
project_responsible2 Responsible 2
project_routeNetwork Route network The route network attached to the project. This is automatically set if orders in a project are generated from button “Create a project from a route network”.
project_start_time Start The expected or planned start time of a project.
project_sub_projects Sub projects Shows a list of sub projects below this project.
project_top_level_parent_id Root project No. The ID No. for the project at the root of the hierachy.
projectproperty Property (Project)

Resource

Id Name Description
resource_capacity Capacity The capacity of the resource, i.e. units per hour. The operations on the resource can inherit this value.
resource_description Description
resource_efficiency Efficiency The efficiency of the resource. If set to 50% an operation with a workload on 10 hours will take 20 hours to finish (on a 24 hours open calendar, otherwise longer).
resource_id Id The unique ID of the resource, generated by the system. Cannot be changed by the user.
resource_name Name
resource_resourcetype_name ResourceType name The name of the ResourceType
resourceproperty Property (Resource)

Resource transition rule

Id Name Description
resource_transition_rule_desc Description The description of the resource transition rule
resource_transition_rule_destination_resource_ids Destination resource ids The ids of the destination resources
resource_transition_rule_destination_resource_names Destination resources The names of the destination resources
resource_transition_rule_extra_constraints Extra constraints The extra constraints of the resource transition rule
resource_transition_rule_id Id The id of the resource transition rule
resource_transition_rule_path Path ids The ids of the resources in the path of the resource transition rule
resource_transition_rule_path_names Path names The names of the resources in the path of the resource transition rule
resource_transition_rule_product Product The product of the resource transition rule
resource_transition_rule_properties Properties The properties of the resource transition rule
resource_transition_rule_source_resource_id Source resource id The id of the source resource

Route

Id Name Description
operation_sequence_alternate_route Alternate Route Used to differentiate routes with the same name.
operation_sequence_alternate_route_desc Alternate Route Description The description og the Alternate Route.
operation_sequence_color Color The color of the route.
operation_sequence_custom_boolean_1 Boolean 1 Free boolean field (true/false):
operation_sequence_custom_boolean_2 Boolean 2 Free boolean field (true/false):
operation_sequence_custom_calendar_1 Calendar 1 Free calendar field.
operation_sequence_custom_calendar_2 Calendar 2 Free calendar field.
operation_sequence_custom_double_1 Float 1 Free float field.
operation_sequence_custom_double_2 Float 2 Free float field.
operation_sequence_custom_string_1 Text 1 Free text field.
operation_sequence_custom_string_2 Text 2 Free text field.
operation_sequence_custom_string_3 Text 3 Free text field.
operation_sequence_custom_string_4 Text 4 Free text field.
operation_sequence_description Description The description of the route.
operation_sequence_id Id Unique id of the route. Generated by the system and cannot be changed by the user.
operation_sequence_is_cip CIP (Clean In Place). If enabled this route can be selected in Edit resource dialog in order to have a CIP order generated.
operation_sequence_lotsize Lotsize Used in route networks. If a route has a quantity on 10 and a lot size of 5, two orders will be generated with a quantity of 5 each.
operation_sequence_name Route Shows the name of the route.
operation_sequence_quantity Quantity Used in route networks. Orders generated from the route can inherit the quantity of the route.
operationsequenceproperty Property (Route)

Time registration

Id Name Description
timereg_creation_time Creation time The time when the time registration was created
timereg_description Description The description of the time registration
timereg_id Id The id of the time registration
timereg_quantity Quantity The quantity for the time registration
timereg_quantity_bad Quantity bad The bad quantity for the time registration
timereg_registration_time Registration time The time the time registration is registered to
timereg_setup Setup The setup time in hours for the time registration
timereg_switchover Switchover The switchover time in hours for the time registration
timereg_type Type The type of the time registration
timereg_user_id User The id of the user who created the time registration
timereg_workload Workload The workload time in hours for the time registration

Other

Id Name Description
pallet_scheduling_is_valid Is pallet scheduling valid Indicates whether or not the pallet scheduling is valid for the operation.
plan_name Plan name Note: Item is not visible in field chooser! The name of the active plan
manpowerActualStaffing Actual manpower
user_name User name Note: Item is not visible in field chooser! The name of the user which is currently logged in (operating system user)
current_time Current time Note: Item is not visible in field chooser! The current date and time according with the ISO 8601 standard. Format is “YYYY-MM-DDThh:mm:ssZ”
manpowstaffing Base manpower The manpower value set on the operation

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment