FA Allocation

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

Table Type: Company

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

Table Number: 5615

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Allocation Type]
   ,[Line No_]
   ,[Description]
   ,[Account No_]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Allocation _]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$FA Allocation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in FA Allocation table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Allocation Type Primary Key Searchint
4Line No_ Primary Key Searchint
5Description Searchnvarchar(200)
6Account No_ Searchnvarchar(40)
7Global Dimension 1 Code Searchnvarchar(40)
8Global Dimension 2 Code Searchnvarchar(40)
9Allocation _ Searchdecimal(38,38)
10Dimension Set ID Searchint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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