Phys_ Inventory Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPhys_ 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 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 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_]
4	Posting Date	datetime
5	Entry Type	int
6	Document No_	nvarchar(40)
7	Description	nvarchar(200)
8	Location Code	nvarchar(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]
9	Inventory Posting Group	nvarchar(40)
10	Quantity	decimal(38,38)
11	Unit Amount	decimal(38,38)
12	Unit Cost	decimal(38,38)
13	Amount	decimal(38,38)
14	Salespers__Purch_ Code	nvarchar(40)
15	User ID	nvarchar(100)
16	Source Code	nvarchar(20)
17	Global Dimension 1 Code	nvarchar(40)
18	Global Dimension 2 Code	nvarchar(40)
19	Journal Batch Name	nvarchar(20)
20	Reason Code	nvarchar(20)
21	Qty_ (Calculated)	decimal(38,38)
22	Qty_ (Phys_ Inventory)	decimal(38,38)
23	Last Item Ledger Entry No_	int
24	Document Date	datetime
25	External Document No_	nvarchar(70)
26	No_ Series	nvarchar(40)
27	Dimension Set ID	int
28	Variant Code	nvarchar(20)
29	Unit of Measure Code	nvarchar(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]
30	Phys Invt Counting Period Code	nvarchar(20)
31	Phys Invt Counting Period Type	int
32	$systemId	uniqueidentifier
33	$systemCreatedAt	datetime
34	$systemCreatedBy	uniqueidentifier
35	$systemModifiedAt	datetime
36	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Phys_ Inventory Ledger Entry table

Item Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables PPhys_ Inventory Ledger Entry

Leave a Reply Cancel reply