Jobs Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesJJobs Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/315

Table Type: Company

Table Name: Jobs Setup
Database Table Name: CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 315

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Jobs Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Job Nos_]
   ,[Apply Usage Link by Default]
   ,[Default WIP Method]
   ,[Default Job Posting Group]
   ,[Default WIP Posting Method]
   ,[Allow Sched_Contract Lines Def]
   ,[Document No_ Is Job No_]
   ,[Logo Position on Documents]
   ,[Job WIP Nos_]
   ,[Automatic Update Job Item Cost]
   ,[Price List Nos_]
   ,[Default Sales Price List Code]
   ,[Default Purch Price List Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
      ON
         [Jobs Setup].[Default WIP Method] = [Job WIP Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
      ON
         [Jobs Setup].[Default Job Posting Group] = [Job Posting Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Jobs Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Jobs Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Jobs Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Job Nos. SearchJob Nos.NormalCode20Job Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Jobs Setup].[Job Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Jobs Setup].[Job Nos_] = [No. Series].[Code]
3Apply Usage Link by Default SearchApply Usage Link by DefaultNormalBoolean4Apply Usage Link by Defaulttinyint
4Default WIP Method SearchDefault WIP MethodNormalCode20Default WIP Methodnvarchar(40)
Key to join to the Job WIP Method table.

Show/hide example query

SELECT
       [Jobs Setup].[Default WIP Method]
       ,[Job WIP Method].[Code]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
              ON
                     [Jobs Setup].[Default WIP Method] = [Job WIP Method].[Code]
5Default Job Posting Group SearchDefault Job Posting GroupNormalCode20Default Job Posting Groupnvarchar(40)
Key to join to the Job Posting Group table.

Show/hide example query

SELECT
       [Jobs Setup].[Default Job Posting Group]
       ,[Job Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
              ON
                     [Jobs Setup].[Default Job Posting Group] = [Job Posting Group].[Code]
6Default WIP Posting Method SearchDefault WIP Posting MethodNormalOption4Default WIP Posting Methodint
Available options are:
  • “Per Job”
  • “Per Job Ledger Entry”
7Allow Sched/Contract Lines Def SearchAllow Sched/Contract Lines DefNormalBoolean4Allow Sched_Contract Lines Deftinyint
9Document No. Is Job No. SearchDocument No. Is Job No.NormalBoolean4Document No_ Is Job No_tinyint
31Logo Position on Documents SearchLogo Position on DocumentsNormalOption4Logo Position on Documentsint
Available options are:
  • “No Logo”
  • “Left”
  • “Center”
  • “Right”
40Job WIP Nos. SearchJob WIP Nos.NormalCode20Job WIP Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Jobs Setup].[Job WIP Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Jobs Setup].[Job WIP Nos_] = [No. Series].[Code]
1001Automatic Update Job Item Cost SearchAutomatic Update Job Item CostNormalBoolean4Automatic Update Job Item Costtinyint
7000Price List Nos. SearchPrice List Nos.NormalCode20Price List Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Jobs Setup].[Price List Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Jobs Setup].[Price List Nos_] = [No. Series].[Code]
7003Default Sales Price List Code SearchDefault Sales Price List CodeNormalCode20Default Sales Price List Codenvarchar(40)
7004Default Purch Price List Code SearchDefault Purchase Price List CodeNormalCode20Default Purch Price List Codenvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Jobs Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Jobs Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Jobs Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Jobs Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Jobs Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Jobs Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesJJobs Setup

Leave a Reply

Your email address will not be published. Required fields are marked *