Value 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: 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 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
   [timestamp]
   ,[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_]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Value Entry].[Item No_] = [Item].[No_]
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_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Value Entry].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Value Entry].[Job Task No_] = [Job Task].[Job Task No_]

Show/hide columns in Value Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Value Entry].[Item No_] = [Item].[No_]
4Posting Date Searchdatetime
5Item Ledger Entry Type Searchint
6Source No_ Searchnvarchar(40)
7Document No_ Searchnvarchar(40)
8Description Searchnvarchar(200)
9Location Code Searchnvarchar(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]
10Inventory Posting Group Searchnvarchar(40)
11Source Posting Group Searchnvarchar(40)
12Item Ledger Entry No_ Searchint
13Valued Quantity Searchdecimal(38,38)
14Item Ledger Entry Quantity Searchdecimal(38,38)
15Invoiced Quantity Searchdecimal(38,38)
16Cost per Unit Searchdecimal(38,38)
17Sales Amount (Actual) Searchdecimal(38,38)
18Salespers__Purch_ Code Searchnvarchar(40)
19Discount Amount Searchdecimal(38,38)
20User ID Searchnvarchar(100)
21Source Code Searchnvarchar(20)
22Applies-to Entry Searchint
23Global Dimension 1 Code Searchnvarchar(40)
24Global Dimension 2 Code Searchnvarchar(40)
25Source Type Searchint
26Cost Amount (Actual) Searchdecimal(38,38)
27Cost Posted to G_L Searchdecimal(38,38)
28Reason Code Searchnvarchar(20)
29Drop Shipment Searchtinyint
30Journal Batch Name Searchnvarchar(20)
31Gen_ Bus_ Posting Group Searchnvarchar(40)
32Gen_ Prod_ Posting Group Searchnvarchar(40)
33Document Date Searchdatetime
34External Document No_ Searchnvarchar(70)
35Cost Amount (Actual) (ACY) Searchdecimal(38,38)
36Cost Posted to G_L (ACY) Searchdecimal(38,38)
37Cost per Unit (ACY) Searchdecimal(38,38)
38Document Type Searchint
39Document Line No_ Searchint
40Order Type Searchint
41Order No_ Searchnvarchar(40)
42Order Line No_ Searchint
43Expected Cost Searchtinyint
44Item Charge No_ Searchnvarchar(40)
45Valued By Average Cost Searchtinyint
46Partial Revaluation Searchtinyint
47Inventoriable Searchtinyint
48Valuation Date Searchdatetime
49Entry Type Searchint
50Variance Type Searchint
51Purchase Amount (Actual) Searchdecimal(38,38)
52Purchase Amount (Expected) Searchdecimal(38,38)
53Sales Amount (Expected) Searchdecimal(38,38)
54Cost Amount (Expected) Searchdecimal(38,38)
55Cost Amount (Non-Invtbl_) Searchdecimal(38,38)
56Cost Amount (Expected) (ACY) Searchdecimal(38,38)
57Cost Amount (Non-Invtbl_)(ACY) Searchdecimal(38,38)
58Expected Cost Posted to G_L Searchdecimal(38,38)
59Exp_ Cost Posted to G_L (ACY) Searchdecimal(38,38)
60Dimension Set ID Searchint
61Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Value Entry].[Job No_]
       ,[Job].[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].[Job No_]
62Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Value Entry].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Value Entry].[Job Task No_] = [Job Task].[Job Task No_]
63Job Ledger Entry No_ Searchint
64Variant Code Searchnvarchar(20)
65Adjustment Searchtinyint
66Average Cost Exception Searchtinyint
67Capacity Ledger Entry No_ Searchint
68Type Searchint
69No_ Searchnvarchar(40)
70Return Reason Code Searchnvarchar(20)
71$systemId Searchuniqueidentifier
72$systemCreatedAt Searchdatetime
73$systemCreatedBy Searchuniqueidentifier
74$systemModifiedAt Searchdatetime
75$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Value Entry table

Leave a Reply

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