Phys_ 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
   [timestamp]
   ,[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 columns in Phys_ Invt_ Count Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Exp_ Serial No_ Searchnvarchar(100)
4Exp_ Lot No_ Searchnvarchar(100)
5Exp_ Qty_ (Base) Searchdecimal(38,38)
6Rec_ No_ Searchint
7Rec_ Line No_ Searchint
8Rec_ Serial No_ Searchnvarchar(100)
9Rec_ Lot No_ Searchnvarchar(100)
10Rec_ Qty_ (Base) Searchdecimal(38,38)
11Track_ Serial No_ Searchnvarchar(100)
12Track_ Lot No_ Searchnvarchar(100)
13Track_ Qty_ Neg_ (Base) Searchdecimal(38,38)
14Track_ Qty_ Pos_ (Base) Searchdecimal(38,38)
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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