Value Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesVValue Entry

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

Table Type: Company

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

Table Number: 5802

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Item Ledger Entry Type]
   ,[Source No_]
   ,[Document No_]
   ,[Description]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Source Posting Group]
   ,[Item Ledger Entry No_]
   ,[Valued Quantity]
   ,[Item Ledger Entry Quantity]
   ,[Invoiced Quantity]
   ,[Cost per Unit]
   ,[Sales Amount (Actual)]
   ,[Salespers__Purch_ Code]
   ,[Discount Amount]
   ,[User ID]
   ,[Source Code]
   ,[Applies-to Entry]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Source Type]
   ,[Cost Amount (Actual)]
   ,[Cost Posted to G_L]
   ,[Reason Code]
   ,[Drop Shipment]
   ,[Journal Batch Name]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Document Date]
   ,[External Document No_]
   ,[Cost Amount (Actual) (ACY)]
   ,[Cost Posted to G_L (ACY)]
   ,[Cost per Unit (ACY)]
   ,[Document Type]
   ,[Document Line No_]
   ,[VAT Reporting Date]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Expected Cost]
   ,[Item Charge No_]
   ,[Valued By Average Cost]
   ,[Partial Revaluation]
   ,[Inventoriable]
   ,[Valuation Date]
   ,[Entry Type]
   ,[Variance Type]
   ,[Purchase Amount (Actual)]
   ,[Purchase Amount (Expected)]
   ,[Sales Amount (Expected)]
   ,[Cost Amount (Expected)]
   ,[Cost Amount (Non-Invtbl_)]
   ,[Cost Amount (Expected) (ACY)]
   ,[Cost Amount (Non-Invtbl_)(ACY)]
   ,[Expected Cost Posted to G_L]
   ,[Exp_ Cost Posted to G_L (ACY)]
   ,[Dimension Set ID]
   ,[Job No_]
   ,[Job Task No_]
   ,[Job Ledger Entry No_]
   ,[Variant Code]
   ,[Adjustment]
   ,[Average Cost Exception]
   ,[Capacity Ledger Entry No_]
   ,[Type]
   ,[No_]
   ,[Return Reason Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Value Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Value Entry].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Value Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Value Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Value Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Value Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Value Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Value Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Value Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Value Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Value Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Value Entry].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Value Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Value Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Value Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Value Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Value Entry].[Item No_] = [Item].[No_]
3Posting Date SearchPosting DateNormalDate4Posting Datedatetime
4Item Ledger Entry Type SearchItem Ledger Entry TypeNormalOption4Item Ledger Entry Typeint
Available options are:
  • “Purchase”
  • “Sale”
  • “Positive Adjmt.”
  • “Negative Adjmt.”
  • “Transfer”
  • “Consumption”
  • “Output”
  • ” “
  • “Assembly Consumption”
  • “Assembly Output”
5Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Value Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Value Entry].[Location Code] = [Location].[Code]
9Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Value Entry].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Value Entry].[Inventory Posting Group] = [Inventory Posting Group].[Code]
10Source Posting Group SearchSource Posting GroupNormalCode20Source Posting Groupnvarchar(40)
11Item Ledger Entry No. SearchItem Ledger Entry No.NormalInteger4Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
       [Value Entry].[Item Ledger Entry No_]
       ,[Item Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
              ON
                     [Value Entry].[Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
12Valued Quantity SearchValued QuantityNormalDecimal12Valued Quantitydecimal(38,38)
13Item Ledger Entry Quantity SearchItem Ledger Entry QuantityNormalDecimal12Item Ledger Entry Quantitydecimal(38,38)
14Invoiced Quantity SearchInvoiced QuantityNormalDecimal12Invoiced Quantitydecimal(38,38)
15Cost per Unit SearchCost per UnitNormalDecimal12Cost per Unitdecimal(38,38)
17Sales Amount (Actual) SearchSales Amount (Actual)NormalDecimal12Sales Amount (Actual)decimal(38,38)
22Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Value Entry].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Value Entry].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
23Discount Amount SearchDiscount AmountNormalDecimal12Discount Amountdecimal(38,38)
24User ID SearchUser IDNormalCode50User IDnvarchar(100)
25Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Value Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Value Entry].[Source Code] = [Source Code].[Code]
28Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
33Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Value Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Value Entry].[Global Dimension 2 Code] = [Dimension].[Code]
41Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Item”
43Cost Amount (Actual) SearchCost Amount (Actual)NormalDecimal12Cost Amount (Actual)decimal(38,38)
45Cost Posted to G/L SearchCost Posted to G/LNormalDecimal12Cost Posted to G_Ldecimal(38,38)
46Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Value Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Value Entry].[Reason Code] = [Reason Code].[Code]
47Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
48Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
57Gen. 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
       [Value Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Value Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
58Gen. 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
       [Value Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Value Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
60Document Date SearchDocument DateNormalDate4Document Datedatetime
61External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
68Cost Amount (Actual) (ACY) SearchCost Amount (Actual) (ACY)NormalDecimal12Cost Amount (Actual) (ACY)decimal(38,38)
70Cost Posted to G/L (ACY) SearchCost Posted to G/L (ACY)NormalDecimal12Cost Posted to G_L (ACY)decimal(38,38)
72Cost per Unit (ACY) SearchCost per Unit (ACY)NormalDecimal12Cost per Unit (ACY)decimal(38,38)
79Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Sales Shipment”
  • “Sales Invoice”
  • “Sales Return Receipt”
  • “Sales Credit Memo”
  • “Purchase Receipt”
  • “Purchase Invoice”
  • “Purchase Return Shipment”
  • “Purchase Credit Memo”
  • “Transfer Shipment”
  • “Transfer Receipt”
  • “Service Shipment”
  • “Service Invoice”
  • “Service Credit Memo”
  • “Posted Assembly”
  • “Inventory Receipt”
  • “Inventory Shipment”
  • “Direct Transfer”
80Document Line No. SearchDocument Line No.NormalInteger4Document Line No_int
86VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
90Order Type SearchOrder TypeNormalOption4Order Typeint
Available options are:
  • ” “
  • “Production”
  • “Transfer”
  • “Service”
  • “Assembly”
91Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
92Order Line No. SearchOrder Line No.NormalInteger4Order Line No_int
98Expected Cost SearchExpected CostNormalBoolean4Expected Costtinyint
99Item Charge No. SearchItem Charge No.NormalCode20Item Charge No_nvarchar(40)
Key to join to the Item Charge table.

Show/hide example query

SELECT
       [Value Entry].[Item Charge No_]
       ,[Item Charge].[No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Charge$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge]
              ON
                     [Value Entry].[Item Charge No_] = [Item Charge].[No_]
100Valued By Average Cost SearchValued By Average CostNormalBoolean4Valued By Average Costtinyint
102Partial Revaluation SearchPartial RevaluationNormalBoolean4Partial Revaluationtinyint
103Inventoriable SearchInventoriableNormalBoolean4Inventoriabletinyint
104Valuation Date SearchValuation DateNormalDate4Valuation Datedatetime
105Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Direct Cost”
  • “Revaluation”
  • “Rounding”
  • “Indirect Cost”
  • “Variance”
  • “Total”
106Variance Type SearchVariance TypeNormalOption4Variance Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Material”
  • “Capacity”
  • “Capacity Overhead”
  • “Manufacturing Overhead”
  • “Subcontracted”
148Purchase Amount (Actual) SearchPurchase Amount (Actual)NormalDecimal12Purchase Amount (Actual)decimal(38,38)
149Purchase Amount (Expected) SearchPurchase Amount (Expected)NormalDecimal12Purchase Amount (Expected)decimal(38,38)
150Sales Amount (Expected) SearchSales Amount (Expected)NormalDecimal12Sales Amount (Expected)decimal(38,38)
151Cost Amount (Expected) SearchCost Amount (Expected)NormalDecimal12Cost Amount (Expected)decimal(38,38)
152Cost Amount (Non-Invtbl.) SearchCost Amount (Non-Invtbl.)NormalDecimal12Cost Amount (Non-Invtbl_)decimal(38,38)
156Cost Amount (Expected) (ACY) SearchCost Amount (Expected) (ACY)NormalDecimal12Cost Amount (Expected) (ACY)decimal(38,38)
157Cost Amount (Non-Invtbl.)(ACY) SearchCost Amount (Non-Invtbl.)(ACY)NormalDecimal12Cost Amount (Non-Invtbl_)(ACY)decimal(38,38)
158Expected Cost Posted to G/L SearchExpected Cost Posted to G/LNormalDecimal12Expected Cost Posted to G_Ldecimal(38,38)
159Exp. Cost Posted to G/L (ACY) SearchExp. Cost Posted to G/L (ACY)NormalDecimal12Exp_ Cost Posted to G_L (ACY)decimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Value Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Value Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
1000Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Value Entry].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Value Entry].[Job No_] = [Job].[No_]
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job 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
       [Value Entry].[Job Ledger Entry No_]
       ,[Job Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
              ON
                     [Value Entry].[Job Ledger Entry No_] = [Job Ledger Entry].[Entry No_]
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Value Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Value Entry].[Variant Code] = [Item Variant].[Code]
5818Adjustment SearchAdjustmentNormalBoolean4Adjustmenttinyint
5819Average Cost Exception SearchAverage Cost ExceptionNormalBoolean4Average Cost Exceptiontinyint
5831Capacity Ledger Entry No. SearchCapacity Ledger Entry No.NormalInteger4Capacity Ledger Entry No_int
Key to join to the Capacity Ledger Entry table.

Show/hide example query

SELECT
       [Value Entry].[Capacity Ledger Entry No_]
       ,[Capacity Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry]
              ON
                     [Value Entry].[Capacity Ledger Entry No_] = [Capacity Ledger Entry].[Entry No_]
5832Type SearchTypeNormalOption4Typeint
Available options are:
  • “Work Center”
  • “Machine Center”
  • ” “
  • “Resource”
5834No. SearchNo.NormalCode20No_nvarchar(40)
6602Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
       [Value Entry].[Return Reason Code]
       ,[Return Reason].[Code]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
              ON
                     [Value Entry].[Return Reason Code] = [Return Reason].[Code]
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
       [Value Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Value Entry].[$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
       [Value Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Value Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Value Entry table

LocationSales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesVValue Entry

Leave a Reply

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