Job Planning Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables JJob 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Job No_	nvarchar(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_]
3	Job Task No_	nvarchar(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_]
4	Line No_	int
5	Planning Date	datetime
6	Document No_	nvarchar(40)
7	Type	int
8	No_	nvarchar(40)
9	Description	nvarchar(200)
10	Quantity	decimal(38,38)
11	Direct Unit Cost (LCY)	decimal(38,38)
12	Unit Cost (LCY)	decimal(38,38)
13	Total Cost (LCY)	decimal(38,38)
14	Unit Price (LCY)	decimal(38,38)
15	Total Price (LCY)	decimal(38,38)
16	Resource Group No_	nvarchar(40)
17	Unit of Measure Code	nvarchar(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]
18	Qty_ Rounding Precision	decimal(38,38)
19	Qty_ Rounding Precision (Base)	decimal(38,38)
20	Location Code	nvarchar(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]
21	Last Date Modified	datetime
22	User ID	nvarchar(100)
23	Work Type Code	nvarchar(20)
24	Customer Price Group	nvarchar(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]
25	Country_Region Code	nvarchar(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]
26	Gen_ Bus_ Posting Group	nvarchar(40)
27	Gen_ Prod_ Posting Group	nvarchar(40)
28	Document Date	datetime
29	Planning Due Date	datetime
30	Line Amount (LCY)	decimal(38,38)
31	Unit Cost	decimal(38,38)
32	Total Cost	decimal(38,38)
33	Unit Price	decimal(38,38)
34	Total Price	decimal(38,38)
35	Line Amount	decimal(38,38)
36	Line Discount Amount	decimal(38,38)
37	Line Discount Amount (LCY)	decimal(38,38)
38	Cost Factor	decimal(38,38)
39	Serial No_	nvarchar(100)
40	Lot No_	nvarchar(100)
41	Line Discount _	decimal(38,38)
42	Line Type	int
43	Currency Code	nvarchar(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]
44	Currency Date	datetime
45	Currency Factor	decimal(38,38)
46	Schedule Line	tinyint
47	Contract Line	tinyint
48	Job Contract Entry No_	int
49	VAT Unit Price	decimal(38,38)
50	VAT Line Discount Amount	decimal(38,38)
51	VAT Line Amount	decimal(38,38)
52	VAT _	decimal(38,38)
53	Description 2	nvarchar(100)
54	Job Ledger Entry No_	int
55	Status	int
56	Ledger Entry Type	int
57	Ledger Entry No_	int
58	System-Created Entry	tinyint
59	Usage Link	tinyint
60	Remaining Qty_	decimal(38,38)
61	Remaining Qty_ (Base)	decimal(38,38)
62	Remaining Total Cost	decimal(38,38)
63	Remaining Total Cost (LCY)	decimal(38,38)
64	Remaining Line Amount	decimal(38,38)
65	Remaining Line Amount (LCY)	decimal(38,38)
66	Qty_ Posted	decimal(38,38)
67	Qty_ to Transfer to Journal	decimal(38,38)
68	Posted Total Cost	decimal(38,38)
69	Posted Total Cost (LCY)	decimal(38,38)
70	Posted Line Amount	decimal(38,38)
71	Posted Line Amount (LCY)	decimal(38,38)
72	Qty_ to Transfer to Invoice	decimal(38,38)
73	Qty_ to Invoice	decimal(38,38)
74	Reserve	int
75	Planned	tinyint
76	Variant Code	nvarchar(20)
77	Bin Code	nvarchar(40)
78	Qty_ per Unit of Measure	decimal(38,38)
79	Quantity (Base)	decimal(38,38)
80	Requested Delivery Date	datetime
81	Promised Delivery Date	datetime
82	Planned Delivery Date	datetime
83	Service Order No_	nvarchar(40)
84	Package No_	nvarchar(100)
85	Price Calculation Method	int
86	Cost Calculation Method	int
87	Qty_ Picked	decimal(38,38)
88	Qty_ Picked (Base)	decimal(38,38)
89	Completely Picked	tinyint
90	$systemId	uniqueidentifier
91	$systemCreatedAt	datetime
92	$systemCreatedBy	uniqueidentifier
93	$systemModifiedAt	datetime
94	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Job Planning Line table

Country_Region Currency Customer Price Group Job Job Task Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables JJob Planning Line

Leave a Reply Cancel reply