FA 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
   [timestamp]
   ,[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 columns in FA Posting Group table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Acquisition Cost Account Searchnvarchar(40)
4Accum_ Depreciation Account Searchnvarchar(40)
5Write-Down Account Searchnvarchar(40)
6Appreciation Account Searchnvarchar(40)
7Custom 1 Account Searchnvarchar(40)
8Custom 2 Account Searchnvarchar(40)
9Acq_ Cost Acc_ on Disposal Searchnvarchar(40)
10Accum_ Depr_ Acc_ on Disposal Searchnvarchar(40)
11Write-Down Acc_ on Disposal Searchnvarchar(40)
12Appreciation Acc_ on Disposal Searchnvarchar(40)
13Custom 1 Account on Disposal Searchnvarchar(40)
14Custom 2 Account on Disposal Searchnvarchar(40)
15Gains Acc_ on Disposal Searchnvarchar(40)
16Losses Acc_ on Disposal Searchnvarchar(40)
17Book Val_ Acc_ on Disp_ (Gain) Searchnvarchar(40)
18Sales Acc_ on Disp_ (Gain) Searchnvarchar(40)
19Write-Down Bal_ Acc_ on Disp_ Searchnvarchar(40)
20Apprec_ Bal_ Acc_ on Disp_ Searchnvarchar(40)
21Custom 1 Bal_ Acc_ on Disposal Searchnvarchar(40)
22Custom 2 Bal_ Acc_ on Disposal Searchnvarchar(40)
23Maintenance Expense Account Searchnvarchar(40)
24Maintenance Bal_ Acc_ Searchnvarchar(40)
25Acquisition Cost Bal_ Acc_ Searchnvarchar(40)
26Depreciation Expense Acc_ Searchnvarchar(40)
27Write-Down Expense Acc_ Searchnvarchar(40)
28Appreciation Bal_ Account Searchnvarchar(40)
29Custom 1 Expense Acc_ Searchnvarchar(40)
30Custom 2 Expense Acc_ Searchnvarchar(40)
31Sales Bal_ Acc_ Searchnvarchar(40)
32Sales Acc_ on Disp_ (Loss) Searchnvarchar(40)
33Book Val_ Acc_ on Disp_ (Loss) Searchnvarchar(40)
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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