Where to find "Shift Duration" from Settings in Exact Online?

Questions
1

I am looking for ‘duur ploeg’ (shift duration) in Exact Online. In which table can I find it?

See also screenshot:

Duur ploeg
Duur ploeg1846×739 32.9 KB

2

Normally, I would expect the contents of the Settings of an Exact Online company to appear from

select * from exactonlinexml..settings where description like '%hift%'

but there is no information for shift duration. As an alternative, I always look at ManufacturingSettings:

select * from manufacturingsettings

But still no result. Does anyone else know where to find Shift Duration in the APIs?

3

Not sure, but check LaborHours here:

https://documentation.invantive.com/2017R2/exact-online-data-model/webhelp/invantive-exact-online-connector-exactonlinerest-manufacturing-timedtimetransactions.html

https://documentation.invantive.com/2017R2/exact-online-data-model/webhelp/invantive-exact-online-connector-exactonlinerest-manufacturing-mfgtimetransactions.html

Edit: not sure if still needed, was on top of the board but I see it’s 16 days old.

1 like
4

It seems that DefaultShiftDuration is not yet available through the Exact Online APIs.

It might be added to:

select * from manufacturingsettings

When you desire so, please visit https://support.exactonline.com/ and leave an Idea in the Webservice/API section.