Audit File Export Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAudit 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	Integer	4	ID	int
2	G/L Account Mapping Code	G/L Account Mapping Code	Normal	Code	20	G_L Account Mapping Code	nvarchar(40)
3	Audit File Export Format	Audit File Export Format	Normal	Option	4	Audit File Export Format	int
	Available options are: “None”
4	Audit File Name	Audit File Name	Normal	Text	1024	Audit File Name	nvarchar(2048)
5	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
6	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	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]
10	Header Comment	Header Comment	Normal	Text	250	Header Comment	nvarchar(500)
11	Contact	Contact	Normal	Text	250	Contact	nvarchar(500)
15	Split By Month	Split By Month	Normal	Boolean	4	Split By Month	tinyint
16	Split By Date	Split By Date	Normal	Boolean	4	Split By Date	tinyint
17	Archive to Zip	Archive to Zip	Normal	Boolean	4	Archive to Zip	tinyint
18	Create Multiple Zip Files	Create Multiple Zip Files	Normal	Boolean	4	Create Multiple Zip Files	tinyint
30	Parallel Processing	Parallel Processing	Normal	Boolean	4	Parallel Processing	tinyint
31	Max No. Of Jobs	Max No. Of Jobs	Normal	Integer	4	Max No_ Of Jobs	int
32	Earliest Start Date/Time	Earliest Start Date/Time	Normal	DateTime	8	Earliest Start Date_Time	datetime
33	Status	Status	Normal	Option	4	Status	int
	Available options are: “Not Started” “In Progress” “Failed” “Completed”
35	Execution Start Date/Time	Execution Start Date/Time	Normal	DateTime	8	Execution Start Date_Time	datetime
36	Execution End Date/Time	Execution End Date/Time	Normal	DateTime	8	Execution End Date_Time	datetime
37	Latest Data Check Date/Time	Latest Data Check Date/Time	Normal	DateTime	8	Latest Data Check Date_Time	datetime
38	Data check status	Data check status	Normal	Option	4	Data check status	int
	Available options are: ” “ “Failed” “Passed”
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier