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
   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Phys_ Inventory Ledger Entry].[Item No_] = [Item].[No_]
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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Phys_ Inventory Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Phys_ Inventory 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
       [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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Phys_ Inventory Ledger Entry].[Item No_] = [Item].[No_]
4Posting Date Searchdatetime
5Entry Type Searchint
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Location Code Searchnvarchar(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 Searchnvarchar(40)
10Quantity Searchdecimal(38,38)
11Unit Amount Searchdecimal(38,38)
12Unit Cost Searchdecimal(38,38)
13Amount Searchdecimal(38,38)
14Salespers__Purch_ Code Searchnvarchar(40)
15User ID Searchnvarchar(100)
16Source Code Searchnvarchar(20)
17Global Dimension 1 Code Searchnvarchar(40)
18Global Dimension 2 Code Searchnvarchar(40)
19Journal Batch Name Searchnvarchar(20)
20Reason Code Searchnvarchar(20)
21Qty_ (Calculated) Searchdecimal(38,38)
22Qty_ (Phys_ Inventory) Searchdecimal(38,38)
23Last Item Ledger Entry No_ Searchint
24Document Date Searchdatetime
25External Document No_ Searchnvarchar(70)
26No_ Series Searchnvarchar(40)
27Dimension Set ID Searchint
28Variant Code Searchnvarchar(20)
29Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Phys_ Inventory Ledger Entry].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys_ Inventory Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Phys_ Inventory Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
30Phys Invt Counting Period Code Searchnvarchar(20)
31Phys Invt Counting Period Type Searchint
32$systemId Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Phys_ Inventory Ledger Entry table

Leave a Reply

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