Item Ledger Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem 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: 32

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

   [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]
   ,[$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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Item Ledger Entry].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Item Ledger Entry].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Item Ledger Entry].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Item Ledger Entry].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Item Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Item Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Item Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Item Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Item Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Item Ledger Entry].[Variant Code] = [Item Variant].[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_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Item Ledger Entry].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Item Ledger Entry].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Ledger 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
       [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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Item Ledger Entry].[Item No_] = [Item].[No_]
3Posting Date SearchPosting DateNormalDate4Posting Datedatetime
4Entry Type SearchEntry TypeNormalOption4Entry 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
       [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]
12Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
13Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
14Invoiced Quantity SearchInvoiced QuantityNormalDecimal12Invoiced Quantitydecimal(38,38)
28Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
29Open SearchOpenNormalBoolean4Opentinyint
33Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Item Ledger 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
       [Item Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Item Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
36Positive SearchPositiveNormalBoolean4Positivetinyint
40Shpt. Method Code SearchShpt. Method CodeNormalCode10Shpt_ Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Shpt_ 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].[Shpt_ Method Code] = [Shipment Method].[Code]
41Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Item”
47Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
50Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Item Ledger Entry].[Transaction Type] = [Transaction Type].[Code]
51Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Item Ledger Entry].[Transport Method] = [Transport Method].[Code]
52Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
59Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Entry_Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Item Ledger Entry].[Entry_Exit Point] = [Entry/Exit Point].[Code]
60Document Date SearchDocument DateNormalDate4Document Datedatetime
61External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
62Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Item Ledger Entry].[Area] = [Area].[Code]
63Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Item Ledger Entry].[Transaction Specification] = [Transaction Specification].[Code]
64No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Item Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Item Ledger Entry].[No_ Series] = [No. Series].[Code]
70Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
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
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
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Item Ledger 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
904Assemble to Order SearchAssemble to OrderNormalBoolean4Assemble to Ordertinyint
1000Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Job No_]
       ,[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].[No_]
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Purchase SearchJob PurchaseNormalBoolean4Job Purchasetinyint
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Item Ledger Entry].[Variant Code] = [Item Variant].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5408Derived from Blanket Order SearchDerived from Blanket OrderNormalBoolean4Derived from Blanket Ordertinyint
5700Cross-Reference No. SearchCross-Reference No.NormalCode20Cross-Reference No_nvarchar(40)
5701Originally Ordered No. SearchOriginally Ordered No.NormalCode20Originally Ordered No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Originally Ordered 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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Item Ledger Entry].[Originally Ordered No_] = [Item].[No_]
5702Originally Ordered Var. Code SearchOriginally Ordered Var. CodeNormalCode10Originally Ordered Var_ Codenvarchar(20)
5703Out-of-Stock Substitution SearchOut-of-Stock SubstitutionNormalBoolean4Out-of-Stock Substitutiontinyint
5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5705Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5706Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Item Ledger Entry].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Item Ledger Entry].[Purchasing Code] = [Purchasing].[Code]
5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5800Completely Invoiced SearchCompletely InvoicedNormalBoolean4Completely Invoicedtinyint
5801Last Invoice Date SearchLast Invoice DateNormalDate4Last Invoice Datedatetime
5802Applied Entry to Adjust SearchApplied Entry to AdjustNormalBoolean4Applied Entry to Adjusttinyint
5803Cost Amount (Expected) SearchCost Amount (Expected)FlowFieldDecimal12
5804Cost Amount (Actual) SearchCost Amount (Actual)FlowFieldDecimal12
5805Cost Amount (Non-Invtbl.) SearchCost Amount (Non-Invtbl.)FlowFieldDecimal12
5806Cost Amount (Expected) (ACY) SearchCost Amount (Expected) (ACY)FlowFieldDecimal12
5807Cost Amount (Actual) (ACY) SearchCost Amount (Actual) (ACY)FlowFieldDecimal12
5808Cost Amount (Non-Invtbl.)(ACY) SearchCost Amount (Non-Invtbl.)(ACY)FlowFieldDecimal12
5813Purchase Amount (Expected) SearchPurchase Amount (Expected)FlowFieldDecimal12
5814Purchase Amount (Actual) SearchPurchase Amount (Actual)FlowFieldDecimal12
5815Sales Amount (Expected) SearchSales Amount (Expected)FlowFieldDecimal12
5816Sales Amount (Actual) SearchSales Amount (Actual)FlowFieldDecimal12
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
5818Shipped Qty. Not Returned SearchShipped Qty. Not ReturnedNormalDecimal12Shipped Qty_ Not Returneddecimal(38,38)
5833Prod. Order Comp. Line No. SearchProd. Order Comp. Line No.NormalInteger4Prod_ Order Comp_ Line No_int
6500Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
6501Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6502Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
6503Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
6510Item Tracking SearchItem TrackingNormalOption4Item Trackingint
Available options are:
  • “None”
  • “Lot No.”
  • “Lot and Serial No.”
  • “Serial No.”
  • “Package No.”
  • “Lot and Package No.”
  • “Serial and Package No.”
  • “Lot and Serial and Package No.”
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
6602Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

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

Show/hide tables related from Item Ledger Entry table

Item CategoryLocationProduct GroupSales HeaderSales Header ArchiveUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Ledger Entry

Leave a Reply

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