FA Posting Group – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables FFA 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Acquisition Cost Account	Acquisition Cost Account	Normal	Code	20	Acquisition Cost Account	nvarchar(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_]
3	Accum. Depreciation Account	Accum. Depreciation Account	Normal	Code	20	Accum_ Depreciation Account	nvarchar(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_]
4	Write-Down Account	Write-Down Account	Normal	Code	20	Write-Down Account	nvarchar(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_]
5	Appreciation Account	Appreciation Account	Normal	Code	20	Appreciation Account	nvarchar(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_]
6	Custom 1 Account	Custom 1 Account	Normal	Code	20	Custom 1 Account	nvarchar(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_]
7	Custom 2 Account	Custom 2 Account	Normal	Code	20	Custom 2 Account	nvarchar(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_]
8	Acq. Cost Acc. on Disposal	Acq. Cost Acc. on Disposal	Normal	Code	20	Acq_ Cost Acc_ on Disposal	nvarchar(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_]
9	Accum. Depr. Acc. on Disposal	Accum. Depr. Acc. on Disposal	Normal	Code	20	Accum_ Depr_ Acc_ on Disposal	nvarchar(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_]
10	Write-Down Acc. on Disposal	Write-Down Acc. on Disposal	Normal	Code	20	Write-Down Acc_ on Disposal	nvarchar(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_]
11	Appreciation Acc. on Disposal	Appreciation Acc. on Disposal	Normal	Code	20	Appreciation Acc_ on Disposal	nvarchar(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_]
12	Custom 1 Account on Disposal	Custom 1 Account on Disposal	Normal	Code	20	Custom 1 Account on Disposal	nvarchar(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_]
13	Custom 2 Account on Disposal	Custom 2 Account on Disposal	Normal	Code	20	Custom 2 Account on Disposal	nvarchar(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_]
14	Gains Acc. on Disposal	Gains Acc. on Disposal	Normal	Code	20	Gains Acc_ on Disposal	nvarchar(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_]
15	Losses Acc. on Disposal	Losses Acc. on Disposal	Normal	Code	20	Losses Acc_ on Disposal	nvarchar(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_]
16	Book Val. Acc. on Disp. (Gain)	Book Val. Acc. on Disp. (Gain)	Normal	Code	20	Book 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_]
17	Sales Acc. on Disp. (Gain)	Sales Acc. on Disp. (Gain)	Normal	Code	20	Sales 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_]
18	Write-Down Bal. Acc. on Disp.	Write-Down Bal. Acc. on Disp.	Normal	Code	20	Write-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_]
19	Apprec. Bal. Acc. on Disp.	Apprec. Bal. Acc. on Disp.	Normal	Code	20	Apprec_ 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_]
20	Custom 1 Bal. Acc. on Disposal	Custom 1 Bal. Acc. on Disposal	Normal	Code	20	Custom 1 Bal_ Acc_ on Disposal	nvarchar(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_]
21	Custom 2 Bal. Acc. on Disposal	Custom 2 Bal. Acc. on Disposal	Normal	Code	20	Custom 2 Bal_ Acc_ on Disposal	nvarchar(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_]
22	Maintenance Expense Account	Maintenance Expense Account	Normal	Code	20	Maintenance Expense Account	nvarchar(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_]
23	Maintenance Bal. Acc.	Maintenance Bal. Acc.	Normal	Code	20	Maintenance 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_]
24	Acquisition Cost Bal. Acc.	Acquisition Cost Bal. Acc.	Normal	Code	20	Acquisition 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_]
25	Depreciation Expense Acc.	Depreciation Expense Acc.	Normal	Code	20	Depreciation 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_]
26	Write-Down Expense Acc.	Write-Down Expense Acc.	Normal	Code	20	Write-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_]
27	Appreciation Bal. Account	Appreciation Bal. Account	Normal	Code	20	Appreciation Bal_ Account	nvarchar(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_]
28	Custom 1 Expense Acc.	Custom 1 Expense Acc.	Normal	Code	20	Custom 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_]
29	Custom 2 Expense Acc.	Custom 2 Expense Acc.	Normal	Code	20	Custom 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_]
30	Sales Bal. Acc.	Sales Bal. Acc.	Normal	Code	20	Sales 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_]
31	Allocated Acquisition Cost %	Allocated Acquisition Cost %	FlowField	Decimal	12
32	Allocated Depreciation %	Allocated Depreciation %	FlowField	Decimal	12
33	Allocated Write-Down %	Allocated Write-Down %	FlowField	Decimal	12
34	Allocated Appreciation %	Allocated Appreciation %	FlowField	Decimal	12
35	Allocated Custom 1 %	Allocated Custom 1 %	FlowField	Decimal	12
36	Allocated Custom 2 %	Allocated Custom 2 %	FlowField	Decimal	12
37	Allocated Sales Price %	Allocated Sales Price %	FlowField	Decimal	12
38	Allocated Maintenance %	Allocated Maintenance %	FlowField	Decimal	12
39	Allocated Gain %	Allocated Gain %	FlowField	Decimal	12
40	Allocated Loss %	Allocated Loss %	FlowField	Decimal	12
41	Allocated Book Value % (Gain)	Allocated Book Value % (Gain)	FlowField	Decimal	12
42	Allocated Book Value % (Loss)	Allocated Book Value % (Loss)	FlowField	Decimal	12
43	Sales Acc. on Disp. (Loss)	Sales Acc. on Disp. (Loss)	Normal	Code	20	Sales 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_]
44	Book Val. Acc. on Disp. (Loss)	Book Val. Acc. on Disp. (Loss)	Normal	Code	20	Book 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	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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables FFA Posting Group

Leave a Reply Cancel reply