Custom Report Selection

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

Table Type: Company

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

Table Number: 9657

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Source Type]
   ,[Source No_]
   ,[Usage]
   ,[Sequence]
   ,[Report ID]
   ,[Custom Report Layout Code]
   ,[Send To Email]
   ,[Use for Email Attachment]
   ,[Use for Email Body]
   ,[Email Body Layout Code]
   ,[Use Email from Contact]
   ,[Selected Contacts Filter]
   ,[Email Attachment Layout Name]
   ,[Email Attachment Layout AppID]
   ,[Email Body Layout Name]
   ,[Email Body Layout AppID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Custom Report Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Custom Report Selection table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Source Type Primary Key SearchSource TypeNormalInteger4Source Typeint
2Source No. Primary Key SearchSource No.NormalCode20Source No_nvarchar(40)
3Usage 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”
4Sequence Primary Key SearchSequenceNormalInteger4Sequenceint
5Report ID SearchReport IDNormalInteger4Report IDint
6Report Caption SearchReport CaptionFlowFieldText250
7Custom Report Layout Code SearchCustom Report Layout CodeNormalCode20Custom Report Layout Codenvarchar(40)
8Custom Report Description SearchCustom Report DescriptionFlowFieldText250
9Send To Email SearchSend To EmailNormalText200Send To Emailnvarchar(400)
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 Layout CodeNormalCode20Email Body Layout Codenvarchar(40)
22Email Body Layout Description SearchEmail Body Layout DescriptionFlowFieldText250
23Use Email from Contact SearchUse Email from ContactsNormalBoolean4Use Email from Contacttinyint
24Selected Contacts Filter SearchSelected Contacts FilterNormalBLOB8Selected Contacts Filterimage
25Email Attachment Layout Name SearchEmail attachment layout nameNormalText250Email Attachment Layout Namenvarchar(500)
26Email Attachment Layout AppID SearchEmail attachment layout App IDNormalGUID16Email Attachment Layout AppIDuniqueidentifier
27Email Body Layout Name SearchEmail body layout nameNormalText250Email Body Layout Namenvarchar(500)
28Email Body Layout AppID SearchEmail body layout App IDNormalGUID16Email Body Layout AppIDuniqueidentifier
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
       [Custom Report Selection].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Custom Report Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Custom Report Selection]
LEFT JOIN
       [User] AS [User]
              ON
                     [Custom Report Selection].[$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
       [Custom Report Selection].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Custom Report Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Custom Report Selection]
LEFT JOIN
       [User] AS [User]
              ON
                     [Custom Report Selection].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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