The additional works order attribute from tasks overview always contains a value of zero.
Additional attributes (e.g. works order additional attributes, item additional attribute) are imported from the ERP system to Orchestrate, via data sequences within a data flow.
For example, if you want to import the Resource Capacity of units available, this information is in on the orc_Tasks table, against the tasks planned on the specific resources. The column is PrimaryResourceCapacityRequired.
To show this against the additional works order attribute called Resource Capacity, a stored procedure has to be created, that will be triggered on the Save Plan stored procedure and the value copied over into the Orchestrate database. This would be chargeable consultancy since the integration is being enhanced.