This section provides a brief overview of possible tables for use by Business Intelligence - such as Power BI.
The JobManager installation includes ready to use examples.
This section discusses how to make your own BI.
For OnPremise installations, best performance is achieved by direct SQL access. Some hints for search and delimitation are listed in the following, since SQL uses numerical values for option fields.
Most common tables and fields for use by BI (press the fields to see Caption and further information):
JobManJob JobManager Jobs
- JobNo
- RefType
- JobType
- RefNo
- RefSubNo
- ResourceGroupNo
- ResourceNo
- WorkCenterNo
- MaskinCenterNo
- Description
- StartDate
- StartTime
- StopDate
- StopTime
- WokTypeCode
- ReportedFinished
- CalculatedTimeDecimal
- ProdStatus
- See here for other fields on the table. Note that some of them may be calculated fields that are not in the database.
JobManStampJournalLine Stamp Journal Line
See also
Reference
This help includes both Dynamics NAV and Dynamics Business Central (BC). All references to NAV applies to both.