Inventory Period Entry

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

Table Type: Company

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

Table Number: 5815

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Period Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Ending Date]
   ,[Entry No_]
   ,[User ID]
   ,[Creation Date]
   ,[Creation Time]
   ,[Closing Item Register No_]
   ,[Entry Type]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Inventory Period Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Inventory Period Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Ending Date Primary Key Searchdatetime
3Entry No_ Primary Key Searchint
4User ID Searchnvarchar(100)
5Creation Date Searchdatetime
6Creation Time Searchdatetime
7Closing Item Register No_ Searchint
8Entry Type Searchint
9Description Searchnvarchar(200)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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