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
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 ID | Column Name | Data Type | ||||
---|---|---|---|---|---|---|
1 | timestamp ![]() | timestamp | ||||
2 | Entry No_ ![]() ![]() | int | ||||
3 | Item No_ ![]() | nvarchar(40) | ||||
Key to join to the Item table.Show/hide example querySELECT
[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_] | ||||||
4 | Posting Date ![]() | datetime | ||||
5 | Item Ledger Entry Type ![]() | int | ||||
6 | Source No_ ![]() | nvarchar(40) | ||||
7 | Document No_ ![]() | nvarchar(40) | ||||
8 | Description ![]() | nvarchar(200) | ||||
9 | Location Code ![]() | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[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] | ||||||
10 | Inventory Posting Group ![]() | nvarchar(40) | ||||
11 | Source Posting Group ![]() | nvarchar(40) | ||||
12 | Item Ledger Entry No_ ![]() | int | ||||
13 | Valued Quantity ![]() | decimal(38,38) | ||||
14 | Item Ledger Entry Quantity ![]() | decimal(38,38) | ||||
15 | Invoiced Quantity ![]() | decimal(38,38) | ||||
16 | Cost per Unit ![]() | decimal(38,38) | ||||
17 | Sales Amount (Actual) ![]() | decimal(38,38) | ||||
18 | Salespers__Purch_ Code ![]() | nvarchar(40) | ||||
19 | Discount Amount ![]() | decimal(38,38) | ||||
20 | User ID ![]() | nvarchar(100) | ||||
21 | Source Code ![]() | nvarchar(20) | ||||
22 | Applies-to Entry ![]() | int | ||||
23 | Global Dimension 1 Code ![]() | nvarchar(40) | ||||
24 | Global Dimension 2 Code ![]() | nvarchar(40) | ||||
25 | Source Type ![]() | int | ||||
26 | Cost Amount (Actual) ![]() | decimal(38,38) | ||||
27 | Cost Posted to G_L ![]() | decimal(38,38) | ||||
28 | Reason Code ![]() | nvarchar(20) | ||||
29 | Drop Shipment ![]() | tinyint | ||||
30 | Journal Batch Name ![]() | nvarchar(20) | ||||
31 | Gen_ Bus_ Posting Group ![]() | nvarchar(40) | ||||
32 | Gen_ Prod_ Posting Group ![]() | nvarchar(40) | ||||
33 | Document Date ![]() | datetime | ||||
34 | External Document No_ ![]() | nvarchar(70) | ||||
35 | Cost Amount (Actual) (ACY) ![]() | decimal(38,38) | ||||
36 | Cost Posted to G_L (ACY) ![]() | decimal(38,38) | ||||
37 | Cost per Unit (ACY) ![]() | decimal(38,38) | ||||
38 | Document Type ![]() | int | ||||
39 | Document Line No_ ![]() | int | ||||
40 | Order Type ![]() | int | ||||
41 | Order No_ ![]() | nvarchar(40) | ||||
42 | Order Line No_ ![]() | int | ||||
43 | Expected Cost ![]() | tinyint | ||||
44 | Item Charge No_ ![]() | nvarchar(40) | ||||
45 | Valued By Average Cost ![]() | tinyint | ||||
46 | Partial Revaluation ![]() | tinyint | ||||
47 | Inventoriable ![]() | tinyint | ||||
48 | Valuation Date ![]() | datetime | ||||
49 | Entry Type ![]() | int | ||||
50 | Variance Type ![]() | int | ||||
51 | Purchase Amount (Actual) ![]() | decimal(38,38) | ||||
52 | Purchase Amount (Expected) ![]() | decimal(38,38) | ||||
53 | Sales Amount (Expected) ![]() | decimal(38,38) | ||||
54 | Cost Amount (Expected) ![]() | decimal(38,38) | ||||
55 | Cost Amount (Non-Invtbl_) ![]() | decimal(38,38) | ||||
56 | Cost Amount (Expected) (ACY) ![]() | decimal(38,38) | ||||
57 | Cost Amount (Non-Invtbl_)(ACY) ![]() | decimal(38,38) | ||||
58 | Expected Cost Posted to G_L ![]() | decimal(38,38) | ||||
59 | Exp_ Cost Posted to G_L (ACY) ![]() | decimal(38,38) | ||||
60 | Dimension Set ID ![]() | int | ||||
61 | Job No_ ![]() | nvarchar(40) | ||||
Key to join to the Job table.Show/hide example querySELECT
[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_] | ||||||
62 | Job Task No_ ![]() | nvarchar(40) | ||||
Key to join to the Job Task table.Show/hide example querySELECT
[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_] | ||||||
63 | Job Ledger Entry No_ ![]() | int | ||||
64 | Variant Code ![]() | nvarchar(20) | ||||
65 | Adjustment ![]() | tinyint | ||||
66 | Average Cost Exception ![]() | tinyint | ||||
67 | Capacity Ledger Entry No_ ![]() | int | ||||
68 | Type ![]() | int | ||||
69 | No_ ![]() | nvarchar(40) | ||||
70 | Return Reason Code ![]() | nvarchar(20) | ||||
71 | $systemId ![]() | uniqueidentifier | ||||
72 | $systemCreatedAt ![]() | datetime | ||||
73 | $systemCreatedBy ![]() | uniqueidentifier | ||||
74 | $systemModifiedAt ![]() | datetime | ||||
75 | $systemModifiedBy ![]() | uniqueidentifier |