FA G_L Posting Buffer

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

Table Type: Company

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

Table Number: 5637

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 G_L Posting Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$FA G_L Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Account No_]
   ,[Amount]
   ,[Correction]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[FA Entry Type]
   ,[FA Entry No_]
   ,[Automatic Entry]
   ,[FA Posting Group]
   ,[FA Allocation Type]
   ,[FA Allocation Line No_]
   ,[Original General Journal Line]
   ,[Net Disposal]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$FA G_L Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in FA G_L Posting Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Account No_ Searchnvarchar(40)
4Amount Searchdecimal(38,38)
5Correction Searchtinyint
6Global Dimension 1 Code Searchnvarchar(40)
7Global Dimension 2 Code Searchnvarchar(40)
8FA Entry Type Searchint
9FA Entry No_ Searchint
10Automatic Entry Searchtinyint
11FA Posting Group Searchnvarchar(40)
12FA Allocation Type Searchint
13FA Allocation Line No_ Searchint
14Original General Journal Line Searchtinyint
15Net Disposal Searchtinyint
16Dimension Set ID Searchint
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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