FA Posting Group

Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Posting Group

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

Table Type: Company

Table Name: FA Posting Group
Database Table Name: CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5606

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 FA Posting Group can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Acquisition Cost Account]
   ,[Accum_ Depreciation Account]
   ,[Write-Down Account]
   ,[Appreciation Account]
   ,[Custom 1 Account]
   ,[Custom 2 Account]
   ,[Acq_ Cost Acc_ on Disposal]
   ,[Accum_ Depr_ Acc_ on Disposal]
   ,[Write-Down Acc_ on Disposal]
   ,[Appreciation Acc_ on Disposal]
   ,[Custom 1 Account on Disposal]
   ,[Custom 2 Account on Disposal]
   ,[Gains Acc_ on Disposal]
   ,[Losses Acc_ on Disposal]
   ,[Book Val_ Acc_ on Disp_ (Gain)]
   ,[Sales Acc_ on Disp_ (Gain)]
   ,[Write-Down Bal_ Acc_ on Disp_]
   ,[Apprec_ Bal_ Acc_ on Disp_]
   ,[Custom 1 Bal_ Acc_ on Disposal]
   ,[Custom 2 Bal_ Acc_ on Disposal]
   ,[Maintenance Expense Account]
   ,[Maintenance Bal_ Acc_]
   ,[Acquisition Cost Bal_ Acc_]
   ,[Depreciation Expense Acc_]
   ,[Write-Down Expense Acc_]
   ,[Appreciation Bal_ Account]
   ,[Custom 1 Expense Acc_]
   ,[Custom 2 Expense Acc_]
   ,[Sales Bal_ Acc_]
   ,[Sales Acc_ on Disp_ (Loss)]
   ,[Book Val_ Acc_ on Disp_ (Loss)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Acquisition Cost Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Write-Down Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Appreciation Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Custom 1 Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Custom 2 Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Custom 1 Account on Disposal] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Custom 2 Account on Disposal] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [FA Posting Group].[Maintenance Expense Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Posting Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Posting Group].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in FA Posting Group table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2Acquisition Cost Account Primary Key SearchAcquisition Cost AccountNormalCode20Acquisition Cost Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Acquisition Cost Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Acquisition Cost Account] = [G/L Account].[No_]
3Accum. Depreciation Account SearchAccum. Depreciation AccountNormalCode20Accum_ Depreciation Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Accum_ Depreciation Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Accum_ Depreciation Account] = [G/L Account].[No_]
4Write-Down Account SearchWrite-Down AccountNormalCode20Write-Down Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Write-Down Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Write-Down Account] = [G/L Account].[No_]
5Appreciation Account SearchAppreciation AccountNormalCode20Appreciation Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Appreciation Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Appreciation Account] = [G/L Account].[No_]
6Custom 1 Account SearchCustom 1 AccountNormalCode20Custom 1 Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 1 Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 1 Account] = [G/L Account].[No_]
7Custom 2 Account SearchCustom 2 AccountNormalCode20Custom 2 Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 2 Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 2 Account] = [G/L Account].[No_]
8Acq. Cost Acc. on Disposal SearchAcq. Cost Acc. on DisposalNormalCode20Acq_ Cost Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Acq_ Cost Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Acq_ Cost Acc_ on Disposal] = [G/L Account].[No_]
9Accum. Depr. Acc. on Disposal SearchAccum. Depr. Acc. on DisposalNormalCode20Accum_ Depr_ Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Accum_ Depr_ Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Accum_ Depr_ Acc_ on Disposal] = [G/L Account].[No_]
10Write-Down Acc. on Disposal SearchWrite-Down Acc. on DisposalNormalCode20Write-Down Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Write-Down Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Write-Down Acc_ on Disposal] = [G/L Account].[No_]
11Appreciation Acc. on Disposal SearchAppreciation Acc. on DisposalNormalCode20Appreciation Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Appreciation Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Appreciation Acc_ on Disposal] = [G/L Account].[No_]
12Custom 1 Account on Disposal SearchCustom 1 Account on DisposalNormalCode20Custom 1 Account on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 1 Account on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 1 Account on Disposal] = [G/L Account].[No_]
13Custom 2 Account on Disposal SearchCustom 2 Account on DisposalNormalCode20Custom 2 Account on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 2 Account on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 2 Account on Disposal] = [G/L Account].[No_]
14Gains Acc. on Disposal SearchGains Acc. on DisposalNormalCode20Gains Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Gains Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Gains Acc_ on Disposal] = [G/L Account].[No_]
15Losses Acc. on Disposal SearchLosses Acc. on DisposalNormalCode20Losses Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Losses Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Losses Acc_ on Disposal] = [G/L Account].[No_]
16Book Val. Acc. on Disp. (Gain) SearchBook Val. Acc. on Disp. (Gain)NormalCode20Book Val_ Acc_ on Disp_ (Gain)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Book Val_ Acc_ on Disp_ (Gain)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Book Val_ Acc_ on Disp_ (Gain)] = [G/L Account].[No_]
17Sales Acc. on Disp. (Gain) SearchSales Acc. on Disp. (Gain)NormalCode20Sales Acc_ on Disp_ (Gain)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Sales Acc_ on Disp_ (Gain)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Sales Acc_ on Disp_ (Gain)] = [G/L Account].[No_]
18Write-Down Bal. Acc. on Disp. SearchWrite-Down Bal. Acc. on Disp.NormalCode20Write-Down Bal_ Acc_ on Disp_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Write-Down Bal_ Acc_ on Disp_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Write-Down Bal_ Acc_ on Disp_] = [G/L Account].[No_]
19Apprec. Bal. Acc. on Disp. SearchApprec. Bal. Acc. on Disp.NormalCode20Apprec_ Bal_ Acc_ on Disp_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Apprec_ Bal_ Acc_ on Disp_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Apprec_ Bal_ Acc_ on Disp_] = [G/L Account].[No_]
20Custom 1 Bal. Acc. on Disposal SearchCustom 1 Bal. Acc. on DisposalNormalCode20Custom 1 Bal_ Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 1 Bal_ Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 1 Bal_ Acc_ on Disposal] = [G/L Account].[No_]
21Custom 2 Bal. Acc. on Disposal SearchCustom 2 Bal. Acc. on DisposalNormalCode20Custom 2 Bal_ Acc_ on Disposalnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 2 Bal_ Acc_ on Disposal]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 2 Bal_ Acc_ on Disposal] = [G/L Account].[No_]
22Maintenance Expense Account SearchMaintenance Expense AccountNormalCode20Maintenance Expense Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Maintenance Expense Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Maintenance Expense Account] = [G/L Account].[No_]
23Maintenance Bal. Acc. SearchMaintenance Bal. Acc.NormalCode20Maintenance Bal_ Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Maintenance Bal_ Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Maintenance Bal_ Acc_] = [G/L Account].[No_]
24Acquisition Cost Bal. Acc. SearchAcquisition Cost Bal. Acc.NormalCode20Acquisition Cost Bal_ Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Acquisition Cost Bal_ Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Acquisition Cost Bal_ Acc_] = [G/L Account].[No_]
25Depreciation Expense Acc. SearchDepreciation Expense Acc.NormalCode20Depreciation Expense Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Depreciation Expense Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Depreciation Expense Acc_] = [G/L Account].[No_]
26Write-Down Expense Acc. SearchWrite-Down Expense Acc.NormalCode20Write-Down Expense Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Write-Down Expense Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Write-Down Expense Acc_] = [G/L Account].[No_]
27Appreciation Bal. Account SearchAppreciation Bal. AccountNormalCode20Appreciation Bal_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Appreciation Bal_ Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Appreciation Bal_ Account] = [G/L Account].[No_]
28Custom 1 Expense Acc. SearchCustom 1 Expense Acc.NormalCode20Custom 1 Expense Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 1 Expense Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 1 Expense Acc_] = [G/L Account].[No_]
29Custom 2 Expense Acc. SearchCustom 2 Expense Acc.NormalCode20Custom 2 Expense Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Custom 2 Expense Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Custom 2 Expense Acc_] = [G/L Account].[No_]
30Sales Bal. Acc. SearchSales Bal. Acc.NormalCode20Sales Bal_ Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Sales Bal_ Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Sales Bal_ Acc_] = [G/L Account].[No_]
31Allocated Acquisition Cost % SearchAllocated Acquisition Cost %FlowFieldDecimal12
32Allocated Depreciation % SearchAllocated Depreciation %FlowFieldDecimal12
33Allocated Write-Down % SearchAllocated Write-Down %FlowFieldDecimal12
34Allocated Appreciation % SearchAllocated Appreciation %FlowFieldDecimal12
35Allocated Custom 1 % SearchAllocated Custom 1 %FlowFieldDecimal12
36Allocated Custom 2 % SearchAllocated Custom 2 %FlowFieldDecimal12
37Allocated Sales Price % SearchAllocated Sales Price %FlowFieldDecimal12
38Allocated Maintenance % SearchAllocated Maintenance %FlowFieldDecimal12
39Allocated Gain % SearchAllocated Gain %FlowFieldDecimal12
40Allocated Loss % SearchAllocated Loss %FlowFieldDecimal12
41Allocated Book Value % (Gain) SearchAllocated Book Value % (Gain)FlowFieldDecimal12
42Allocated Book Value % (Loss) SearchAllocated Book Value % (Loss)FlowFieldDecimal12
43Sales Acc. on Disp. (Loss) SearchSales Acc. on Disp. (Loss)NormalCode20Sales Acc_ on Disp_ (Loss)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Sales Acc_ on Disp_ (Loss)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Sales Acc_ on Disp_ (Loss)] = [G/L Account].[No_]
44Book Val. Acc. on Disp. (Loss) SearchBook Val. Acc. on Disp. (Loss)NormalCode20Book Val_ Acc_ on Disp_ (Loss)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [FA Posting Group].[Book Val_ Acc_ on Disp_ (Loss)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [FA Posting Group].[Book Val_ Acc_ on Disp_ (Loss)] = [G/L Account].[No_]
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
	       [FA Posting Group].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [FA Posting Group].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Posting Group

Leave a Reply

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