Document Sending Profile

Dynamics 365 BC Table ReferenceTablesCompany TablesDDocument Sending Profile

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

Table Type: Company

Table Name: Document Sending Profile
Database Table Name: CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 60

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 Document Sending Profile can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[Printer]
   ,[E-Mail]
   ,[E-Mail Attachment]
   ,[E-Mail Format]
   ,[Disk]
   ,[Disk Format]
   ,[Electronic Document]
   ,[Electronic Format]
   ,[Default]
   ,[Send To]
   ,[Usage]
   ,[One Related Party Selected]
   ,[Combine Email Documents]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
LEFT JOIN
   [CRONUS UK Ltd_$Electronic Document Format$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Electronic Document Format]
      ON
         [Document Sending Profile].[E-Mail Format] = [Electronic Document Format].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Electronic Document Format$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Electronic Document Format]
      ON
         [Document Sending Profile].[Disk Format] = [Electronic Document Format].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Electronic Document Format$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Electronic Document Format]
      ON
         [Document Sending Profile].[Electronic Format] = [Electronic Document Format].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Document Sending Profile].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Document Sending Profile].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Document Sending Profile table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10Printer SearchPrinterNormalOption4Printerint
Available options are:
  • “No”
  • “Yes (Prompt for Settings)”
  • “Yes (Use Default Settings)”
11E-Mail SearchEmailNormalOption4E-Mailint
Available options are:
  • “No”
  • “Yes (Prompt for Settings)”
  • “Yes (Use Default Settings)”
12E-Mail Attachment SearchEmail AttachmentNormalOption4E-Mail Attachmentint
Available options are:
  • “PDF”
  • “Electronic Document”
  • “PDF & Electronic Document”
13E-Mail Format SearchEmail FormatNormalCode20E-Mail Formatnvarchar(40)
Key to join to the Electronic Document Format table.

Show/hide example query

SELECT
       [Document Sending Profile].[E-Mail Format]
       ,[Electronic Document Format].[Code]
FROM
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Electronic Document Format$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Electronic Document Format]
              ON
                     [Document Sending Profile].[E-Mail Format] = [Electronic Document Format].[Code]
15Disk SearchDiskNormalOption4Diskint
Available options are:
  • “No”
  • “PDF”
  • “Electronic Document”
  • “PDF & Electronic Document”
16Disk Format SearchDisk FormatNormalCode20Disk Formatnvarchar(40)
Key to join to the Electronic Document Format table.

Show/hide example query

SELECT
       [Document Sending Profile].[Disk Format]
       ,[Electronic Document Format].[Code]
FROM
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Electronic Document Format$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Electronic Document Format]
              ON
                     [Document Sending Profile].[Disk Format] = [Electronic Document Format].[Code]
20Electronic Document SearchElectronic DocumentNormalOption4Electronic Documentint
Available options are:
  • “No”
  • “Through Document Exchange Service”
21Electronic Format SearchElectronic FormatNormalCode20Electronic Formatnvarchar(40)
Key to join to the Electronic Document Format table.

Show/hide example query

SELECT
       [Document Sending Profile].[Electronic Format]
       ,[Electronic Document Format].[Code]
FROM
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Electronic Document Format$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Electronic Document Format]
              ON
                     [Document Sending Profile].[Electronic Format] = [Electronic Document Format].[Code]
30Default SearchDefaultNormalBoolean4Defaulttinyint
50Send To SearchSend ToNormalOption4Send Toint
Available options are:
  • “Disk”
  • “Email”
  • “Print”
  • “Electronic Document”
51Usage SearchUsageNormalOption4Usageint
Available options are:
  • “Sales Invoice”
  • “Sales Credit Memo”
  • “Service Invoice”
  • “Service Credit Memo”
  • “Job Quote”
52One Related Party Selected SearchOne Related Party SelectedNormalBoolean4One Related Party Selectedtinyint
60Combine Email Documents SearchCombine Email DocumentsNormalBoolean4Combine Email Documentstinyint
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
       [Document Sending Profile].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
LEFT JOIN
       [User] AS [User]
              ON
                     [Document Sending Profile].[$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
       [Document Sending Profile].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
LEFT JOIN
       [User] AS [User]
              ON
                     [Document Sending Profile].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesDDocument Sending Profile

Leave a Reply

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