Job Planning Line

Dynamics 365 BC Table ReferenceTablesCompany TablesJJob 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: 1003

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

   [Line No_]
   ,[Job 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]
   ,[Job Task No_]
   ,[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_]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Job Planning Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
      ON
         [Job Planning Line].[Work Type Code] = [Work Type].[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Planning Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Job Planning Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Job Planning Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Planning Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Planning Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job Planning Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Line No. SearchLine No.NormalInteger4Line No_int
2Job No. Primary Key SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
	       [Job Planning Line].[Job No_]
	       ,[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].[No_]
3Planning Date Primary Key SearchPlanning DateNormalDate4Planning Datedatetime
4Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
5Type SearchTypeNormalOption4Typeint
Available options are:
  • “Resource”
  • “Item”
  • “G/L Account”
  • “Text”
7No. SearchNo.NormalCode20No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
11Direct Unit Cost (LCY) SearchDirect Unit Cost ($)NormalDecimal12Direct Unit Cost (LCY)decimal(38,38)
12Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
13Total Cost (LCY) SearchTotal Cost ($)NormalDecimal12Total Cost (LCY)decimal(38,38)
14Unit Price (LCY) SearchUnit Price ($)NormalDecimal12Unit Price (LCY)decimal(38,38)
15Total Price (LCY) SearchTotal Price ($)NormalDecimal12Total Price (LCY)decimal(38,38)
16Resource Group No. SearchResource Group No.NormalCode20Resource Group No_nvarchar(40)
Key to join to the Resource Group table.

Show/hide example query

SELECT
	       [Job Planning Line].[Resource Group No_]
	       ,[Resource Group].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
	              ON
	                     [Job Planning Line].[Resource Group No_] = [Resource Group].[No_]
17Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
18Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
19Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
29Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
30User ID SearchUser IDNormalCode50User IDnvarchar(100)
32Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

SELECT
	       [Job Planning Line].[Work Type Code]
	       ,[Work Type].[Code]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
	              ON
	                     [Job Planning Line].[Work Type Code] = [Work Type].[Code]
33Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
79Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
80Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
	       [Job Planning Line].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Job Planning Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
81Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
	       [Job Planning Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [Job Planning Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
83Document Date SearchDocument DateNormalDate4Document Datedatetime
84Planning Due Date SearchPlanning Due DateNormalDate4Planning Due Datedatetime
1000Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1001Line Amount (LCY) Primary Key SearchLine Amount ($)NormalDecimal12Line Amount (LCY)decimal(38,38)
1002Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
1003Total Cost SearchTotal CostNormalDecimal12Total Costdecimal(38,38)
1004Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
1005Total Price SearchTotal PriceNormalDecimal12Total Pricedecimal(38,38)
1006Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
1007Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
1008Line Discount Amount (LCY) SearchLine Discount Amount ($)NormalDecimal12Line Discount Amount (LCY)decimal(38,38)
1015Cost Factor SearchCost FactorNormalDecimal12Cost Factordecimal(38,38)
1019Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
1020Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
1021Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
1022Line Type SearchLine TypeNormalOption4Line Typeint
Available options are:
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
1023Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
1024Currency Date SearchCurrency DateNormalDate4Currency Datedatetime
1025Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
1026Schedule Line SearchBudget LineNormalBoolean4Schedule Linetinyint
1027Contract Line SearchBillable LineNormalBoolean4Contract Linetinyint
1030Job Contract Entry No. SearchJob Contract Entry No.NormalInteger4Job Contract Entry No_int
1035Invoiced Amount (LCY) SearchInvoiced Amount ($)FlowFieldDecimal12
1036Invoiced Cost Amount (LCY) SearchInvoiced Cost Amount ($)FlowFieldDecimal12
1037VAT Unit Price SearchTax Unit PriceNormalDecimal12VAT Unit Pricedecimal(38,38)
1038VAT Line Discount Amount SearchVAT Line Discount AmountNormalDecimal12VAT Line Discount Amountdecimal(38,38)
1039VAT Line Amount SearchVAT Line AmountNormalDecimal12VAT Line Amountdecimal(38,38)
1041VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
1042Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
1043Job Ledger Entry No. SearchJob Ledger Entry No.NormalInteger4Job Ledger Entry No_int
Key to join to the Job Ledger Entry table.

Show/hide example query

SELECT
	       [Job Planning Line].[Job Ledger Entry No_]
	       ,[Job Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
	              ON
	                     [Job Planning Line].[Job Ledger Entry No_] = [Job Ledger Entry].[Entry No_]
1048Status SearchStatusNormalOption4Statusint
Available options are:
  • “Planning”
  • “Quote”
  • “Order”
  • “Completed”
1050Ledger Entry Type SearchLedger Entry TypeNormalOption4Ledger Entry Typeint
Available options are:
  • ” “
  • “Resource”
  • “Item”
  • “G/L Account”
1051Ledger Entry No. SearchLedger Entry No.NormalInteger4Ledger Entry No_int
Key to join to the G/L Entry table.

Show/hide example query

SELECT
	       [Job Planning Line].[Ledger Entry No_]
	       ,[G/L Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
	              ON
	                     [Job Planning Line].[Ledger Entry No_] = [G/L Entry].[Entry No_]
1052System-Created Entry SearchSystem-Created EntryNormalBoolean4
1053Usage Link SearchUsage LinkNormalBoolean4Usage Linktinyint
1060Remaining Qty. SearchRemaining Qty.NormalDecimal12Remaining Qty_decimal(38,38)
1061Remaining Qty. (Base) SearchRemaining Qty. (Base)NormalDecimal12Remaining Qty_ (Base)decimal(38,38)
1062Remaining Total Cost SearchRemaining Total CostNormalDecimal12Remaining Total Costdecimal(38,38)
1063Remaining Total Cost (LCY) SearchRemaining Total Cost ($)NormalDecimal12Remaining Total Cost (LCY)decimal(38,38)
1064Remaining Line Amount SearchRemaining Line AmountNormalDecimal12Remaining Line Amountdecimal(38,38)
1065Remaining Line Amount (LCY) SearchRemaining Line Amount ($)NormalDecimal12Remaining Line Amount (LCY)decimal(38,38)
1070Qty. Posted SearchQty. PostedNormalDecimal12Qty_ Posteddecimal(38,38)
1071Qty. to Transfer to Journal SearchQty. to Transfer to JournalNormalDecimal12Qty_ to Transfer to Journaldecimal(38,38)
1072Posted Total Cost SearchPosted Total CostNormalDecimal12Posted Total Costdecimal(38,38)
1073Posted Total Cost (LCY) SearchPosted Total Cost ($)NormalDecimal12Posted Total Cost (LCY)decimal(38,38)
1074Posted Line Amount SearchPosted Line AmountNormalDecimal12Posted Line Amountdecimal(38,38)
1075Posted Line Amount (LCY) SearchPosted Line Amount ($)NormalDecimal12Posted Line Amount (LCY)decimal(38,38)
1080Qty. Transferred to Invoice SearchQty. Transferred to InvoiceFlowFieldDecimal12
1081Qty. to Transfer to Invoice SearchQty. to Transfer to InvoiceNormalDecimal12Qty_ to Transfer to Invoicedecimal(38,38)
1090Qty. Invoiced SearchQty. InvoicedFlowFieldDecimal12
1091Qty. to Invoice SearchQty. to InvoiceNormalDecimal12Qty_ to Invoicedecimal(38,38)
1100Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
1101Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
1102Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
1103Planned SearchPlannedNormalBoolean4Plannedtinyint
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Job Planning Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Job Planning Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
	       [Job Planning Line].[Bin Code]
	       ,[Bin].[Code]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Job Planning Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5410Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5790Requested Delivery Date SearchRequested Delivery DateNormalDate4Requested Delivery Datedatetime
5791Promised Delivery Date SearchPromised Delivery DateNormalDate4Promised Delivery Datedatetime
5794Planned Delivery Date SearchPlanned Delivery DateNormalDate4Planned Delivery Datedatetime
5900Service Order No. SearchService Order No.NormalCode20Service Order No_nvarchar(40)
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
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”
7300Pick Qty. SearchPick Qty.FlowFieldDecimal12
7301Qty. Picked SearchQty. PickedNormalDecimal12Qty_ Pickeddecimal(38,38)
7302Qty. Picked (Base) SearchQty. Picked (Base)NormalDecimal12Qty_ Picked (Base)decimal(38,38)
7303Completely Picked SearchCompletely PickedNormalBoolean4Completely Pickedtinyint
7304Pick Qty. (Base) SearchPick Qty. (Base)FlowFieldDecimal12
7305Qty. on Journal SearchQty. on JournalFlowFieldDecimal12
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 Planning Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Job Planning Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Job Planning Line table

CurrencyCustomer Price GroupLocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesJJob Planning Line

Leave a Reply

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