Phys. Inventory Ledger Entry

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

Table Type: Company

Table Name: Phys. Inventory Ledger Entry
Database Table Name: CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 281

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 Phys. Inventory Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Phys_ Inventory 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]
   ,[Document No_]
   ,[Description]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Quantity]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[Amount]
   ,[Salespers__Purch_ Code]
   ,[User ID]
   ,[Source Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Qty_ (Calculated)]
   ,[Qty_ (Phys_ Inventory)]
   ,[Last Item Ledger Entry No_]
   ,[Document Date]
   ,[External Document No_]
   ,[No_ Series]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Phys Invt Counting Period Code]
   ,[Phys Invt Counting Period Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Phys_ Inventory 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_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Phys. Inventory Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Phys. Inventory Ledger Entry].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Phys. Inventory Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Phys. Inventory Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Phys. Inventory 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
         [Phys. Inventory Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Inventory Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Phys. Inventory Ledger Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Phys. Inventory Ledger Entry].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Inventory Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Inventory Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Phys. Inventory 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
       [Phys. Inventory Ledger Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Phys. Inventory 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”
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
       [Phys. Inventory Ledger Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Phys. Inventory Ledger 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
       [Phys. Inventory Ledger Entry].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Phys. Inventory Ledger Entry].[Inventory Posting Group] = [Inventory Posting Group].[Code]
12Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
15Unit Amount SearchUnit AmountNormalDecimal12Unit Amountdecimal(38,38)
16Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
17Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
22Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Phys. Inventory Ledger Entry].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
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
       [Phys. Inventory Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Phys. Inventory Ledger Entry].[Source Code] = [Source Code].[Code]
33Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Phys. Inventory 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
       [Phys. Inventory Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Phys. Inventory Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
45Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
46Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Phys. Inventory Ledger Entry].[Reason Code] = [Reason Code].[Code]
54Qty. (Calculated) SearchQty. (Calculated)NormalDecimal12Qty_ (Calculated)decimal(38,38)
55Qty. (Phys. Inventory) SearchQty. (Phys. Inventory)NormalDecimal12Qty_ (Phys_ Inventory)decimal(38,38)
56Last Item Ledger Entry No. SearchLast Item Ledger Entry No.NormalInteger4Last Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Last Item Ledger Entry No_]
       ,[Item Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
              ON
                     [Phys. Inventory Ledger Entry].[Last Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
60Document Date SearchDocument DateNormalDate4Document Datedatetime
61External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
64No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Phys. Inventory Ledger Entry].[No_ Series] = [No. Series].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Phys. Inventory 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
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Phys. Inventory Ledger Entry].[Variant Code] = [Item Variant].[Code]
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
7380Phys Invt Counting Period Code SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(20)
Key to join to the Phys. Invt. Counting Period table.

Show/hide example query

SELECT
       [Phys. Inventory Ledger Entry].[Phys Invt Counting Period Code]
       ,[Phys. Invt. Counting Period].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
              ON
                     [Phys. Inventory Ledger Entry].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7381Phys Invt Counting Period Type SearchPhys Invt Counting Period TypeNormalOption4Phys Invt Counting Period Typeint
Available options are:
  • ” “
  • “Item”
  • “SKU”
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
       [Phys. Inventory Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Inventory 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
       [Phys. Inventory Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Inventory Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Phys. Inventory Ledger Entry table

Leave a Reply

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