Audit File Export Header

Dynamics 365 BC Table ReferenceTablesCompany TablesAAudit File Export Header

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

Table Type: Company

Table Name: Audit File Export Header
Database Table Name: CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada

Table Number: 5265

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 Audit File Export Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[G_L Account Mapping Code]
   ,[Audit File Export Format]
   ,[Audit File Name]
   ,[Starting Date]
   ,[Ending Date]
   ,[Header Comment]
   ,[Contact]
   ,[Split By Month]
   ,[Split By Date]
   ,[Archive to Zip]
   ,[Create Multiple Zip Files]
   ,[Parallel Processing]
   ,[Max No_ Of Jobs]
   ,[Earliest Start Date_Time]
   ,[Status]
   ,[Execution Start Date_Time]
   ,[Execution End Date_Time]
   ,[Latest Data Check Date_Time]
   ,[Data check status]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [Audit File Export Header]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Audit File Export Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [Audit File Export Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Audit File Export Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Audit File Export Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalInteger4IDint
2G/L Account Mapping Code SearchG/L Account Mapping CodeNormalCode20G_L Account Mapping Codenvarchar(40)
Key to join to the G/L Account Mapping Header table.

Show/hide example query

SELECT
       [Audit File Export Header].[G_L Account Mapping Code]
       ,[G/L Account Mapping Header].[Code]
FROM
       [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [Audit File Export Header]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header]
              ON
                     [Audit File Export Header].[G_L Account Mapping Code] = [G/L Account Mapping Header].[Code]
3Audit File Export Format SearchAudit File Export FormatNormalOption4Audit File Export Formatint
Available options are:
  • “None”
4Audit File Name SearchAudit File NameNormalText1024Audit File Namenvarchar(2048)
5Starting Date SearchStarting DateNormalDate4Starting Datedatetime
6Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Audit File Export Header].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [Audit File Export Header]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Audit File Export Header].[Ending Date] = [Inventory Period].[Ending Date]
10Header Comment SearchHeader CommentNormalText250Header Commentnvarchar(500)
11Contact SearchContactNormalText250Contactnvarchar(500)
15Split By Month SearchSplit By MonthNormalBoolean4Split By Monthtinyint
16Split By Date SearchSplit By DateNormalBoolean4Split By Datetinyint
17Archive to Zip SearchArchive to ZipNormalBoolean4Archive to Ziptinyint
18Create Multiple Zip Files SearchCreate Multiple Zip FilesNormalBoolean4Create Multiple Zip Filestinyint
30Parallel Processing SearchParallel ProcessingNormalBoolean4Parallel Processingtinyint
31Max No. Of Jobs SearchMax No. Of JobsNormalInteger4Max No_ Of Jobsint
32Earliest Start Date/Time SearchEarliest Start Date/TimeNormalDateTime8Earliest Start Date_Timedatetime
33Status SearchStatusNormalOption4Statusint
Available options are:
  • “Not Started”
  • “In Progress”
  • “Failed”
  • “Completed”
35Execution Start Date/Time SearchExecution Start Date/TimeNormalDateTime8Execution Start Date_Timedatetime
36Execution End Date/Time SearchExecution End Date/TimeNormalDateTime8Execution End Date_Timedatetime
37Latest Data Check Date/Time SearchLatest Data Check Date/TimeNormalDateTime8Latest Data Check Date_Timedatetime
38Data check status SearchData check statusNormalOption4Data check statusint
Available options are:
  • ” “
  • “Failed”
  • “Passed”
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
       [Audit File Export Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [Audit File Export Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Audit File Export Header].[$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
       [Audit File Export Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Audit File Export Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [Audit File Export Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Audit File Export Header].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesAAudit File Export Header

Leave a Reply

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