Action Message Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesAAction Message Entry

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

Table Type: Company

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

Table Number: 99000849

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 Action Message Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Type]
   ,[Reservation Entry]
   ,[Quantity]
   ,[New Date]
   ,[Calculation]
   ,[Suppressed Action Msg_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Prod_ Order Line]
   ,[Source Ref_ No_]
   ,[Location Code]
   ,[Bin Code]
   ,[Variant Code]
   ,[Item No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Action Message 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_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
      ON
         [Action Message Entry].[Reservation Entry] = [Reservation Entry].[Entry No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Action Message Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Action Message Entry].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Action Message Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Action Message Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Action Message Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Action Message Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “New”
  • “Change Qty.”
  • “Reschedule”
  • “Resched. & Chg. Qty.”
  • “Cancel”
3Reservation Entry SearchReservation EntryNormalInteger4Reservation Entryint
Key to join to the Reservation Entry table.

Show/hide example query

SELECT
       [Action Message Entry].[Reservation Entry]
       ,[Reservation Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
              ON
                     [Action Message Entry].[Reservation Entry] = [Reservation Entry].[Entry No_]
4Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
5New Date SearchNew DateNormalDate4New Datedatetime
6Calculation SearchCalculationNormalOption4Calculationint
Available options are:
  • “Sum”
  • “None”
7Suppressed Action Msg. SearchSuppressed Action Msg.NormalBoolean4Suppressed Action Msg_tinyint
10Source Type SearchSource TypeNormalInteger4Source Typeint
11Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
12Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
13Source Batch Name SearchSource Batch NameNormalCode10Source Batch Namenvarchar(20)
14Source Prod. Order Line SearchSource Prod. Order LineNormalInteger4Source Prod_ Order Lineint
15Source Ref. No. SearchSource Ref. No.NormalInteger4Source Ref_ No_int
16Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Action Message Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Action Message Entry].[Location Code] = [Location].[Code]
17Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Action Message Entry].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Action Message Entry].[Bin Code] = [Bin].[Code]
18Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Action Message Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Action Message Entry].[Variant Code] = [Item Variant].[Code]
19Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Action Message Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Action Message Entry].[Item No_] = [Item].[No_]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Action Message Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Action Message Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Action Message Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Action Message Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Action Message Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Action Message Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Action Message Entry table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesAAction Message Entry

Leave a Reply

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