Phys. Invt. Count Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPhys. Invt. Count Buffer

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

Table Type: Company

Table Name: Phys. Invt. Count Buffer
Database Table Name: CRONUS UK Ltd_$Phys_ Invt_ Count Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5888

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. Invt. Count Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Phys_ Invt_ Count Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Line No_]
   ,[Exp_ Serial No_]
   ,[Exp_ Lot No_]
   ,[Exp_ Qty_ (Base)]
   ,[Rec_ No_]
   ,[Rec_ Line No_]
   ,[Rec_ Serial No_]
   ,[Rec_ Lot No_]
   ,[Rec_ Qty_ (Base)]
   ,[Track_ Serial No_]
   ,[Track_ Lot No_]
   ,[Track_ Qty_ Neg_ (Base)]
   ,[Track_ Qty_ Pos_ (Base)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Phys_ Invt_ Count Buffer$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_ Invt_ Count Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Count Buffer]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Count Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Count Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Phys. Invt. Count Buffer table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Line No.	Line No.	Normal	Integer	4	Line No_	int
10	Exp. Serial No.	Exp. Serial No.	Normal	Code	50	Exp_ Serial No_	nvarchar(100)
11	Exp. Lot No.	Exp. Lot No.	Normal	Code	50	Exp_ Lot No_	nvarchar(100)
12	Exp. Qty. (Base)	Exp. Qty. (Base)	Normal	Decimal	12	Exp_ Qty_ (Base)	decimal(38,38)
20	Rec. No.	Rec. No.	Normal	Integer	4	Rec_ No_	int
21	Rec. Line No.	Rec. Line No.	Normal	Integer	4	Rec_ Line No_	int
22	Rec. Serial No.	Rec. Serial No.	Normal	Code	50	Rec_ Serial No_	nvarchar(100)
23	Rec. Lot No.	Rec. Lot No.	Normal	Code	50	Rec_ Lot No_	nvarchar(100)
24	Rec. Qty. (Base)	Rec. Qty. (Base)	Normal	Decimal	12	Rec_ Qty_ (Base)	decimal(38,38)
30	Track. Serial No.	Track. Serial No.	Normal	Code	50	Track_ Serial No_	nvarchar(100)
31	Track. Lot No.	Track. Lot No.	Normal	Code	50	Track_ Lot No_	nvarchar(100)
32	Track. Qty. Neg. (Base)	Track. Qty. Neg. (Base)	Normal	Decimal	12	Track_ Qty_ Neg_ (Base)	decimal(38,38)
33	Track. Qty. Pos. (Base)	Track. Qty. Pos. (Base)	Normal	Decimal	12	Track_ Qty_ Pos_ (Base)	decimal(38,38)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Phys. Invt. Count Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Phys_ Invt_ Count Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Count Buffer] LEFT JOIN [User] AS [User] ON [Phys. Invt. Count Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Phys. Invt. Count Buffer].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Phys_ Invt_ Count Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Count Buffer] LEFT JOIN [User] AS [User] ON [Phys. Invt. Count Buffer].[$systemModifiedBy] = [User].[User Security ID]