Job Planning Line

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Job No_]
   ,[Job Task No_]
   ,[Line No_]
   ,[Planning Date]
   ,[Document No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Quantity]
   ,[Direct Unit Cost (LCY)]
   ,[Unit Cost (LCY)]
   ,[Total Cost (LCY)]
   ,[Unit Price (LCY)]
   ,[Total Price (LCY)]
   ,[Resource Group No_]
   ,[Unit of Measure Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Location Code]
   ,[Last Date Modified]
   ,[User ID]
   ,[Work Type Code]
   ,[Customer Price Group]
   ,[Country_Region Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Document Date]
   ,[Planning Due Date]
   ,[Line Amount (LCY)]
   ,[Unit Cost]
   ,[Total Cost]
   ,[Unit Price]
   ,[Total Price]
   ,[Line Amount]
   ,[Line Discount Amount]
   ,[Line Discount Amount (LCY)]
   ,[Cost Factor]
   ,[Serial No_]
   ,[Lot No_]
   ,[Line Discount _]
   ,[Line Type]
   ,[Currency Code]
   ,[Currency Date]
   ,[Currency Factor]
   ,[Schedule Line]
   ,[Contract Line]
   ,[Job Contract Entry No_]
   ,[VAT Unit Price]
   ,[VAT Line Discount Amount]
   ,[VAT Line Amount]
   ,[VAT _]
   ,[Description 2]
   ,[Job Ledger Entry No_]
   ,[Status]
   ,[Ledger Entry Type]
   ,[Ledger Entry No_]
   ,[System-Created Entry]
   ,[Usage Link]
   ,[Remaining Qty_]
   ,[Remaining Qty_ (Base)]
   ,[Remaining Total Cost]
   ,[Remaining Total Cost (LCY)]
   ,[Remaining Line Amount]
   ,[Remaining Line Amount (LCY)]
   ,[Qty_ Posted]
   ,[Qty_ to Transfer to Journal]
   ,[Posted Total Cost]
   ,[Posted Total Cost (LCY)]
   ,[Posted Line Amount]
   ,[Posted Line Amount (LCY)]
   ,[Qty_ to Transfer to Invoice]
   ,[Qty_ to Invoice]
   ,[Reserve]
   ,[Planned]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Quantity (Base)]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Planned Delivery Date]
   ,[Service Order No_]
   ,[Package No_]
   ,[Price Calculation Method]
   ,[Cost Calculation Method]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[Completely Picked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Planning Line$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 Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Job Planning Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Job Planning Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Job Planning Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Job Planning Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Job Planning Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Job Planning Line].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Planning Line].[Currency Code] = [Currency].[Code]

Show/hide columns in Job Planning Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Job No_ Primary Key Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Job Planning Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job Planning Line].[Job No_] = [Job].[Job No_]
3Job Task No_ Primary Key Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Job Planning Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Job Planning Line].[Job Task No_] = [Job Task].[Job Task No_]
4Line No_ Primary Key Searchint
5Planning Date Searchdatetime
6Document No_ Searchnvarchar(40)
7Type Searchint
8No_ Searchnvarchar(40)
9Description Searchnvarchar(200)
10Quantity Searchdecimal(38,38)
11Direct Unit Cost (LCY) Searchdecimal(38,38)
12Unit Cost (LCY) Searchdecimal(38,38)
13Total Cost (LCY) Searchdecimal(38,38)
14Unit Price (LCY) Searchdecimal(38,38)
15Total Price (LCY) Searchdecimal(38,38)
16Resource Group No_ Searchnvarchar(40)
17Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Job Planning Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Job Planning Line].[Unit of Measure Code] = [Unit of Measure].[Code]
18Qty_ Rounding Precision Searchdecimal(38,38)
19Qty_ Rounding Precision (Base) Searchdecimal(38,38)
20Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Job Planning Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Job Planning Line].[Location Code] = [Location].[Code]
21Last Date Modified Searchdatetime
22User ID Searchnvarchar(100)
23Work Type Code Searchnvarchar(20)
24Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Job Planning Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Job Planning Line].[Customer Price Group] = [Customer Price Group].[Code]
25Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Job Planning Line].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Job Planning Line].[Country_Region Code] = [Country_Region].[Code]
26Gen_ Bus_ Posting Group Searchnvarchar(40)
27Gen_ Prod_ Posting Group Searchnvarchar(40)
28Document Date Searchdatetime
29Planning Due Date Searchdatetime
30Line Amount (LCY) Searchdecimal(38,38)
31Unit Cost Searchdecimal(38,38)
32Total Cost Searchdecimal(38,38)
33Unit Price Searchdecimal(38,38)
34Total Price Searchdecimal(38,38)
35Line Amount Searchdecimal(38,38)
36Line Discount Amount Searchdecimal(38,38)
37Line Discount Amount (LCY) Searchdecimal(38,38)
38Cost Factor Searchdecimal(38,38)
39Serial No_ Searchnvarchar(100)
40Lot No_ Searchnvarchar(100)
41Line Discount _ Searchdecimal(38,38)
42Line Type Searchint
43Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Job Planning Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Job Planning Line].[Currency Code] = [Currency].[Code]
44Currency Date Searchdatetime
45Currency Factor Searchdecimal(38,38)
46Schedule Line Searchtinyint
47Contract Line Searchtinyint
48Job Contract Entry No_ Searchint
49VAT Unit Price Searchdecimal(38,38)
50VAT Line Discount Amount Searchdecimal(38,38)
51VAT Line Amount Searchdecimal(38,38)
52VAT _ Searchdecimal(38,38)
53Description 2 Searchnvarchar(100)
54Job Ledger Entry No_ Searchint
55Status Searchint
56Ledger Entry Type Searchint
57Ledger Entry No_ Searchint
58System-Created Entry Searchtinyint
59Usage Link Searchtinyint
60Remaining Qty_ Searchdecimal(38,38)
61Remaining Qty_ (Base) Searchdecimal(38,38)
62Remaining Total Cost Searchdecimal(38,38)
63Remaining Total Cost (LCY) Searchdecimal(38,38)
64Remaining Line Amount Searchdecimal(38,38)
65Remaining Line Amount (LCY) Searchdecimal(38,38)
66Qty_ Posted Searchdecimal(38,38)
67Qty_ to Transfer to Journal Searchdecimal(38,38)
68Posted Total Cost Searchdecimal(38,38)
69Posted Total Cost (LCY) Searchdecimal(38,38)
70Posted Line Amount Searchdecimal(38,38)
71Posted Line Amount (LCY) Searchdecimal(38,38)
72Qty_ to Transfer to Invoice Searchdecimal(38,38)
73Qty_ to Invoice Searchdecimal(38,38)
74Reserve Searchint
75Planned Searchtinyint
76Variant Code Searchnvarchar(20)
77Bin Code Searchnvarchar(40)
78Qty_ per Unit of Measure Searchdecimal(38,38)
79Quantity (Base) Searchdecimal(38,38)
80Requested Delivery Date Searchdatetime
81Promised Delivery Date Searchdatetime
82Planned Delivery Date Searchdatetime
83Service Order No_ Searchnvarchar(40)
84Package No_ Searchnvarchar(100)
85Price Calculation Method Searchint
86Cost Calculation Method Searchint
87Qty_ Picked Searchdecimal(38,38)
88Qty_ Picked (Base) Searchdecimal(38,38)
89Completely Picked Searchtinyint
90$systemId Searchuniqueidentifier
91$systemCreatedAt Searchdatetime
92$systemCreatedBy Searchuniqueidentifier
93$systemModifiedAt Searchdatetime
94$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job Planning Line table

Leave a Reply

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