Report Selections

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

Table Type: Company

Table Name: Report Selections
Database Table Name: CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 77

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 Report Selections can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Usage]
   ,[Sequence]
   ,[Report ID]
   ,[Custom Report Layout Code]
   ,[Use for Email Attachment]
   ,[Use for Email Body]
   ,[Email Body Layout Code]
   ,[Email Body Layout Type]
   ,[Email Body Layout Name]
   ,[Email Body Layout AppID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Report Selections]
LEFT JOIN
   [User] AS [User]
      ON
         [Report Selections].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Report Selections].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Report Selections table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Usage Primary Key SearchUsageNormalOption4Usageint
Available options are:
  • “S.Quote”
  • “S.Order”
  • “S.Invoice”
  • “S.Cr.Memo”
  • “S.Test”
  • “P.Quote”
  • “P.Order”
  • “P.Invoice”
  • “P.Cr.Memo”
  • “P.Receipt”
  • “P.Ret.Shpt.”
  • “P.Test”
  • “B.Stmt”
  • “B.Recon.Test”
  • “B.Check”
  • “Reminder”
  • “Fin.Charge”
  • “Rem.Test”
  • “F.C.Test”
  • “Prod.Order”
  • “S.Blanket”
  • “P.Blanket”
  • “M1”
  • “M2”
  • “M3”
  • “M4”
  • “Inv1”
  • “Inv2”
  • “Inv3”
  • “SM.Quote”
  • “SM.Order”
  • “SM.Invoice”
  • “SM.Credit Memo”
  • “SM.Contract Quote”
  • “SM.Contract”
  • “SM.Test”
  • “S.Return”
  • “P.Return”
  • “S.Shipment”
  • “S.Ret.Rcpt.”
  • “S.Work Order”
  • “Invt.Period Test”
  • “SM.Shipment”
  • “S.Test Prepmt.”
  • “P.Test Prepmt.”
  • “S.Arch.Quote”
  • “S.Arch.Order”
  • “P.Arch.Quote”
  • “P.Arch.Order”
  • “S.Arch.Return”
  • “P.Arch.Return”
  • “Asm.Order”
  • “P.Asm.Order”
  • “S.Order Pick Instruction”
  • “Posted Payment Reconciliation”
  • “P.V.Remit.”
  • “C.Statement”
  • “V.Remittance”
  • “JQ”
  • “S.Invoice Draft”
  • “Pro Forma S. Invoice”
  • “S.Arch.Blanket”
  • “P.Arch.Blanket”
  • “Phys.Invt.Order Test”
  • “Phys.Invt.Order”
  • “P.Phys.Invt.Order”
  • “Phys.Invt.Rec.”
  • “P.Phys.Invt.Rec.”
  • “Inventory Shipment”
  • “Inventory Receipt”
  • “P.Inventory Shipment”
  • “P.Inventory Receipt”
  • “P.Direct Transfer”
  • “Bank Deposit”
  • “Bank Deposit Test”
2Sequence Primary Key SearchSequenceNormalCode10Sequencenvarchar(20)
3Report ID SearchReport IDNormalInteger4Report IDint
4Report Caption SearchReport CaptionFlowFieldText250
7Custom Report Layout Code SearchCustom Report Layout CodeNormalCode20Custom Report Layout Codenvarchar(40)
19Use for Email Attachment SearchUse for Email AttachmentNormalBoolean4Use for Email Attachmenttinyint
20Use for Email Body SearchUse for Email BodyNormalBoolean4Use for Email Bodytinyint
21Email Body Layout Code SearchEmail Body Custom Layout CodeNormalCode20Email Body Layout Codenvarchar(40)
22Email Body Layout Description SearchEmail Body Custom Layout DescriptionFlowFieldText250
25Email Body Layout Type SearchEmail Body Layout TypeNormalOption4Email Body Layout Typeint
Available options are:
  • “Custom Report Layout”
  • “HTML Layout”
26Email Body Layout Name SearchEmail Body Layout NameNormalText250Email Body Layout Namenvarchar(500)
27Email Body Layout AppID SearchEmail Body Layout AppIDNormalGUID16Email Body Layout AppIDuniqueidentifier
28Email Body Layout Publisher SearchEmail Body Layout PublisherFlowFieldText250
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
       [Report Selections].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Report Selections]
LEFT JOIN
       [User] AS [User]
              ON
                     [Report Selections].[$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
       [Report Selections].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Report Selections]
LEFT JOIN
       [User] AS [User]
              ON
                     [Report Selections].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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