Job

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

Table Type: Company

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

Table Number: 167

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 Job can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Search Description]
   ,[Description]
   ,[Description 2]
   ,[Bill-to Customer No_]
   ,[Creation Date]
   ,[Starting Date]
   ,[Ending Date]
   ,[Status]
   ,[Person Responsible]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Job Posting Group]
   ,[Blocked]
   ,[Last Date Modified]
   ,[Customer Disc_ Group]
   ,[Customer Price Group]
   ,[Language Code]
   ,[Picture]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to County]
   ,[Bill-to Post Code]
   ,[No_ Series]
   ,[Bill-to Country_Region Code]
   ,[Bill-to Name 2]
   ,[Reserve]
   ,[Image]
   ,[WIP Method]
   ,[Currency Code]
   ,[Bill-to Contact No_]
   ,[Bill-to Contact]
   ,[WIP Posting Date]
   ,[Invoice Currency Code]
   ,[Exch_ Calculation (Cost)]
   ,[Exch_ Calculation (Price)]
   ,[Allow Schedule_Contract Lines]
   ,[Complete]
   ,[Apply Usage Link]
   ,[WIP Posting Method]
   ,[Over Budget]
   ,[Project Manager]
   ,[Sell-to Customer No_]
   ,[Sell-to Customer Name]
   ,[Sell-to Customer Name 2]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Contact]
   ,[Sell-to Post Code]
   ,[Sell-to County]
   ,[Sell-to Country_Region Code]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Sell-to Contact No_]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[External Document No_]
   ,[Payment Method Code]
   ,[Payment Terms Code]
   ,[Your Reference]
   ,[Price Calculation Method]
   ,[Cost Calculation Method]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Job].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Job].[Person Responsible] = [Employee].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Job].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Job].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Job].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Job].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
      ON
         [Job].[WIP Method] = [Job WIP Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job].[Invoice Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Job].[Project Manager] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Job].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Sell-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Job].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Job].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Job].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Job].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Search Description Primary Key SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
5Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Job].[Bill-to Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Job].[Bill-to Customer No_] = [Customer].[No_]
12Creation Date SearchCreation DateNormalDate4Creation Datedatetime
13Starting Date SearchStarting DateNormalDate4Starting Datedatetime
14Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
	       [Job].[Ending Date]
	       ,[Inventory Period].[Ending Date]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
	              ON
	                     [Job].[Ending Date] = [Inventory Period].[Ending Date]
19Status SearchStatusNormalOption4Statusint
Available options are:
  • “Planning”
  • “Quote”
  • “Open”
  • “Completed”
20Person Responsible SearchPerson ResponsibleNormalCode20Person Responsiblenvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
	       [Job].[Person Responsible]
	       ,[Employee].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
	              ON
	                     [Job].[Person Responsible] = [Employee].[No_]
21Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Job].[Global Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Job].[Global Dimension 1 Code] = [Dimension].[Code]
22Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Job].[Global Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Job].[Global Dimension 2 Code] = [Dimension].[Code]
23Job Posting Group SearchJob Posting GroupNormalCode20Job Posting Groupnvarchar(40)
24Blocked SearchBlockedNormalOption4Blockedint
Available options are:
  • ” “
  • “Posting”
  • “All”
29Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
30Comment SearchCommentFlowFieldBoolean4
31Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
	       [Job].[Customer Disc_ Group]
	       ,[Customer Discount Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
	              ON
	                     [Job].[Customer Disc_ Group] = [Customer Discount Group].[Code]
32Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
	       [Job].[Customer Price Group]
	       ,[Customer Price Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
	              ON
	                     [Job].[Customer Price Group] = [Customer Price Group].[Code]
41Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
	       [Job].[Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Job].[Language Code] = [Language].[Code]
49Scheduled Res. Qty. SearchScheduled Res. Qty.FlowFieldDecimal12
50Resource Filter SearchResource FilterFlowFilterCode20
Key to join to the Resource table.

Show/hide example query

SELECT
	       [Job].[]
	       ,[Resource].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
	              ON
	                     [Job].[] = [Resource].[No_]
51Posting Date Filter SearchPosting Date FilterFlowFilterDate4
55Resource Gr. Filter SearchResource Gr. FilterFlowFilterCode20
Key to join to the Resource Group table.

Show/hide example query

SELECT
	       [Job].[]
	       ,[Resource Group].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
	              ON
	                     [Job].[] = [Resource Group].[No_]
56Scheduled Res. Gr. Qty. SearchScheduled Res. Gr. Qty.FlowFieldDecimal12
57Picture SearchPictureNormalBLOB8Pictureimage
58Bill-to Name SearchNameNormalText100Bill-to Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Job].[Bill-to Name]
	       ,[Customer].[Name]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Job].[Bill-to Name] = [Customer].[Name]
59Bill-to Address SearchAddressNormalText100Bill-to Addressnvarchar(200)
60Bill-to Address 2 SearchAddress 2NormalText50Bill-to Address 2nvarchar(100)
61Bill-to City SearchCityNormalText30Bill-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Job].[Bill-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Job].[Bill-to City] = [Post Code].[City]
63Bill-to County SearchStateNormalText30Bill-to Countynvarchar(60)
64Bill-to Post Code SearchZIP CodeNormalCode20Bill-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Job].[Bill-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Job].[Bill-to Post Code] = [Post Code].[Code]
66No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Job].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Job].[No_ Series] = [No. Series].[Code]
67Bill-to Country/Region Code SearchCountry/Region CodeNormalCode10Bill-to Country_Region Codenvarchar(20)
68Bill-to Name 2 SearchName 2NormalText50Bill-to Name 2nvarchar(100)
117Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
140Image SearchImageNormalMedia16Imageuniqueidentifier
1000WIP Method SearchWIP MethodNormalCode20WIP Methodnvarchar(40)
Key to join to the Job WIP Method table.

Show/hide example query

SELECT
	       [Job].[WIP Method]
	       ,[Job WIP Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
	              ON
	                     [Job].[WIP Method] = [Job WIP Method].[Code]
1001Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Job].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Job].[Currency Code] = [Currency].[Code]
1002Bill-to Contact No. SearchBill-to Contact No.NormalCode20Bill-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
	       [Job].[Bill-to Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Job].[Bill-to Contact No_] = [Contact].[No_]
1003Bill-to Contact SearchContactNormalText100Bill-to Contactnvarchar(200)
1004Planning Date Filter SearchPlanning Date FilterFlowFilterDate4
1005Total WIP Cost Amount SearchTotal WIP Cost AmountFlowFieldDecimal12
1006Total WIP Cost G/L Amount SearchTotal WIP Cost G/L AmountFlowFieldDecimal12
1007WIP Entries Exist SearchWIP Entries ExistFlowFieldBoolean4
1008WIP Posting Date SearchWIP Posting DateNormalDate4WIP Posting Datedatetime
1009WIP G/L Posting Date SearchWIP G/L Posting DateFlowFieldDate4
1011Invoice Currency Code SearchInvoice Currency CodeNormalCode10Invoice Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Job].[Invoice Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Job].[Invoice Currency Code] = [Currency].[Code]
1012Exch. Calculation (Cost) SearchExch. Calculation (Cost)NormalOption4Exch_ Calculation (Cost)int
Available options are:
  • “Fixed FCY”
  • “Fixed LCY”
1013Exch. Calculation (Price) SearchExch. Calculation (Price)NormalOption4Exch_ Calculation (Price)int
Available options are:
  • “Fixed FCY”
  • “Fixed LCY”
1014Allow Schedule/Contract Lines SearchAllow Budget/Billable LinesNormalBoolean4Allow Schedule_Contract Linestinyint
1015Complete SearchCompleteNormalBoolean4Completetinyint
1017Recog. Sales Amount SearchRecog. Sales AmountFlowFieldDecimal12
1018Recog. Sales G/L Amount SearchRecog. Sales G/L AmountFlowFieldDecimal12
1019Recog. Costs Amount SearchRecog. Costs AmountFlowFieldDecimal12
1020Recog. Costs G/L Amount SearchRecog. Costs G/L AmountFlowFieldDecimal12
1021Total WIP Sales Amount SearchTotal WIP Sales AmountFlowFieldDecimal12
1022Total WIP Sales G/L Amount SearchTotal WIP Sales G/L AmountFlowFieldDecimal12
1023WIP Completion Calculated SearchWIP Completion CalculatedFlowFieldBoolean4
1024Next Invoice Date SearchNext Invoice DateFlowFieldDate4
1025Apply Usage Link SearchApply Usage LinkNormalBoolean4Apply Usage Linktinyint
1026WIP Warnings SearchWIP WarningsFlowFieldBoolean4
1027WIP Posting Method SearchWIP Posting MethodNormalOption4WIP Posting Methodint
Available options are:
  • “Per Job”
  • “Per Job Ledger Entry”
1028Applied Costs G/L Amount SearchApplied Costs G/L AmountFlowFieldDecimal12
1029Applied Sales G/L Amount SearchApplied Sales G/L AmountFlowFieldDecimal12
1030Calc. Recog. Sales Amount SearchCalc. Recog. Sales AmountFlowFieldDecimal12
1031Calc. Recog. Costs Amount SearchCalc. Recog. Costs AmountFlowFieldDecimal12
1032Calc. Recog. Sales G/L Amount SearchCalc. Recog. Sales G/L AmountFlowFieldDecimal12
1033Calc. Recog. Costs G/L Amount SearchCalc. Recog. Costs G/L AmountFlowFieldDecimal12
1034WIP Completion Posted SearchWIP Completion PostedFlowFieldBoolean4
1035Over Budget SearchOver BudgetNormalBoolean4Over Budgettinyint
1036Project Manager SearchProject ManagerNormalCode50Project Managernvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
	       [Job].[Project Manager]
	       ,[User Setup].[User ID]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	              ON
	                     [Job].[Project Manager] = [User Setup].[User ID]
2000Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Job].[Sell-to Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Job].[Sell-to Customer No_] = [Customer].[No_]
2001Sell-to Customer Name SearchSell-to Customer NameNormalText100Sell-to Customer Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Job].[Sell-to Customer Name]
	       ,[Customer].[Name]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Job].[Sell-to Customer Name] = [Customer].[Name]
2002Sell-to Customer Name 2 SearchSell-to Customer Name 2NormalText50Sell-to Customer Name 2nvarchar(100)
2003Sell-to Address SearchSell-to AddressNormalText100Sell-to Addressnvarchar(200)
2004Sell-to Address 2 SearchSell-to Address 2NormalText50Sell-to Address 2nvarchar(100)
2005Sell-to City SearchSell-to CityNormalText30Sell-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Job].[Sell-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Job].[Sell-to City] = [Post Code].[City]
2006Sell-to Contact SearchSell-to ContactNormalText100Sell-to Contactnvarchar(200)
2007Sell-to Post Code SearchSell-to ZIP CodeNormalCode20Sell-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Job].[Sell-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Job].[Sell-to Post Code] = [Post Code].[Code]
2008Sell-to County SearchSell-to StateNormalText30Sell-to Countynvarchar(60)
2009Sell-to Country/Region Code SearchSell-to Country/Region CodeNormalCode10Sell-to Country_Region Codenvarchar(20)
2010Sell-to Phone No. SearchSell-to Phone No.NormalText30Sell-to Phone No_nvarchar(60)
2011Sell-to E-Mail SearchEmailNormalText80Sell-to E-Mailnvarchar(160)
2012Sell-to Contact No. SearchSell-to Contact No.NormalCode20Sell-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
	       [Job].[Sell-to Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Job].[Sell-to Contact No_] = [Contact].[No_]
3000Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
	       [Job].[Ship-to Code]
	       ,[Ship-to Address].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
	              ON
	                     [Job].[Ship-to Code] = [Ship-to Address].[Code]
3001Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
3002Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
3003Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
3004Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
3005Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Job].[Ship-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Job].[Ship-to City] = [Post Code].[City]
3006Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
3007Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Job].[Ship-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Job].[Ship-to Post Code] = [Post Code].[Code]
3008Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
3009Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
4000External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
4001Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
	       [Job].[Payment Method Code]
	       ,[Payment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
	              ON
	                     [Job].[Payment Method Code] = [Payment Method].[Code]
4002Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [Job].[Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Job].[Payment Terms Code] = [Payment Terms].[Code]
4003Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Cost Calculation Method SearchCost Calculation MethodNormalOption4Cost Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7300Completely Picked SearchCompletely PickedFlowFieldBoolean4
8000Id SearchIdNormalGUID16Iduniqueidentifier
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
	       [Job].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Job].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Job table

Leave a Reply

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