Item Ledger Entry

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

Table Type: Company

Table Name: Item Ledger Entry
Database Table Name: CRONUS UK Ltd_$Item Ledger 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 Item Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Entry Type]
   ,[Source No_]
   ,[Document No_]
   ,[Description]
   ,[Location Code]
   ,[Quantity]
   ,[Remaining Quantity]
   ,[Invoiced Quantity]
   ,[Applies-to Entry]
   ,[Open]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Positive]
   ,[Shpt_ Method Code]
   ,[Source Type]
   ,[Drop Shipment]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Country_Region Code]
   ,[Entry_Exit Point]
   ,[Document Date]
   ,[External Document No_]
   ,[Area]
   ,[Transaction Specification]
   ,[No_ Series]
   ,[Document Type]
   ,[Document Line No_]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Dimension Set ID]
   ,[Assemble to Order]
   ,[Job No_]
   ,[Job Task No_]
   ,[Job Purchase]
   ,[Variant Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Derived from Blanket Order]
   ,[Cross-Reference No_]
   ,[Originally Ordered No_]
   ,[Originally Ordered Var_ Code]
   ,[Out-of-Stock Substitution]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Completely Invoiced]
   ,[Last Invoice Date]
   ,[Applied Entry to Adjust]
   ,[Correction]
   ,[Shipped Qty_ Not Returned]
   ,[Prod_ Order Comp_ Line No_]
   ,[Serial No_]
   ,[Lot No_]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Item Tracking]
   ,[Package No_]
   ,[Return Reason Code]
   ,[Shipment Method Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Ledger 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_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Item Ledger Entry].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Item Ledger Entry].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Item Ledger Entry].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Item Ledger Entry].[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
         [Item Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Item Ledger Entry].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Item Ledger Entry].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Item Ledger Entry].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Item Ledger 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
       [Item Ledger Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Ledger Entry].[Item No_] = [Item].[No_]
4Posting Date Searchdatetime
5Entry 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
       [Item Ledger Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Item Ledger Entry].[Location Code] = [Location].[Code]
10Quantity Searchdecimal(38,38)
11Remaining Quantity Searchdecimal(38,38)
12Invoiced Quantity Searchdecimal(38,38)
13Applies-to Entry Searchint
14Open Searchtinyint
15Global Dimension 1 Code Searchnvarchar(40)
16Global Dimension 2 Code Searchnvarchar(40)
17Positive Searchtinyint
18Shpt_ Method Code Searchnvarchar(20)
19Source Type Searchint
20Drop Shipment Searchtinyint
21Transaction Type Searchnvarchar(20)
22Transport Method Searchnvarchar(20)
23Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Item Ledger Entry].[Country_Region Code] = [Country_Region].[Code]
24Entry_Exit Point Searchnvarchar(20)
25Document Date Searchdatetime
26External Document No_ Searchnvarchar(70)
27Area Searchnvarchar(20)
28Transaction Specification Searchnvarchar(20)
29No_ Series Searchnvarchar(40)
30Document Type Searchint
31Document Line No_ Searchint
32Order Type Searchint
33Order No_ Searchnvarchar(40)
34Order Line No_ Searchint
35Dimension Set ID Searchint
36Assemble to Order Searchtinyint
37Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Item Ledger Entry].[Job No_] = [Job].[Job No_]
38Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Item Ledger Entry].[Job Task No_] = [Job Task].[Job Task No_]
39Job Purchase Searchtinyint
40Variant Code Searchnvarchar(20)
41Qty_ per Unit of Measure Searchdecimal(38,38)
42Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Item Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
43Derived from Blanket Order Searchtinyint
44Cross-Reference No_ Searchnvarchar(40)
45Originally Ordered No_ Searchnvarchar(40)
46Originally Ordered Var_ Code Searchnvarchar(20)
47Out-of-Stock Substitution Searchtinyint
48Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Item Ledger Entry].[Item Category Code] = [Item Category].[Code]
49Nonstock Searchtinyint
50Purchasing Code Searchnvarchar(20)
51Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Item Ledger Entry].[Product Group Code] = [Product Group].[Code]
52Item Reference No_ Searchnvarchar(100)
53Completely Invoiced Searchtinyint
54Last Invoice Date Searchdatetime
55Applied Entry to Adjust Searchtinyint
56Correction Searchtinyint
57Shipped Qty_ Not Returned Searchdecimal(38,38)
58Prod_ Order Comp_ Line No_ Searchint
59Serial No_ Searchnvarchar(100)
60Lot No_ Searchnvarchar(100)
61Warranty Date Searchdatetime
62Expiration Date Searchdatetime
63Item Tracking Searchint
64Package No_ Searchnvarchar(100)
65Return Reason Code Searchnvarchar(20)
66Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Item Ledger Entry].[Shipment Method Code] = [Shipment Method].[Code]
67$systemId Searchuniqueidentifier
68$systemCreatedAt Searchdatetime
69$systemCreatedBy Searchuniqueidentifier
70$systemModifiedAt Searchdatetime
71$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Ledger Entry table

Leave a Reply

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