FA Setup

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

Table Type: Company

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

Table Number: 5603

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Allow Posting to Main Assets]
   ,[LastEntryNo]
   ,[Last time scanned]
   ,[Default Depr_ Book]
   ,[Allow FA Posting From]
   ,[Allow FA Posting To]
   ,[Insurance Depr_ Book]
   ,[Automatic Insurance Posting]
   ,[Fixed Asset Nos_]
   ,[Insurance Nos_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in FA Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Allow Posting to Main Assets Searchtinyint
3LastEntryNo Searchint
4Default Depr_ Book Searchnvarchar(20)
4Last time scanned Searchdatetime
5Allow FA Posting From Searchdatetime
6Allow FA Posting To Searchdatetime
7Insurance Depr_ Book Searchnvarchar(20)
8Automatic Insurance Posting Searchtinyint
9Fixed Asset Nos_ Searchnvarchar(40)
10Insurance Nos_ Searchnvarchar(40)
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 *