Accounting Period – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAccounting Period

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

Table Type: Company

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

Table Number: 50

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 Accounting Period can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Accounting Period$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Starting Date]
   ,[Name]
   ,[New Fiscal Year]
   ,[Closed]
   ,[Date Locked]
   ,[Average Cost Calc_ Type]
   ,[Average Cost Period]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Accounting Period$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Accounting Period table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
2	Name	Name	Normal	Text	10	Name	nvarchar(20)
3	New Fiscal Year	New Fiscal Year	Normal	Boolean	4	New Fiscal Year	tinyint
4	Closed	Closed	Normal	Boolean	4	Closed	tinyint
5	Date Locked	Date Locked	Normal	Boolean	4	Date Locked	tinyint
5804	Average Cost Calc. Type	Average Cost Calc. Type	Normal	Option	4	Average Cost Calc_ Type	int
	Available options are: ” “ “Item” “Item & Location & Variant”
5805	Average Cost Period	Average Cost Period	Normal	Option	4	Average Cost Period	int
	Available options are: ” “ “Day” “Week” “Month” “Quarter” “Year” “Accounting Period”
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 [Accounting Period].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Accounting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Accounting Period] LEFT JOIN [User] AS [User] ON [Accounting Period].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Accounting Period].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Accounting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Accounting Period] LEFT JOIN [User] AS [User] ON [Accounting Period].[$systemModifiedBy] = [User].[User Security ID]