FA Ledg_ Entry w_ Issue

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

Table Type: Company

Table Name: FA Ledg_ Entry w_ Issue
Database Table Name: CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8

Table Number: 6090

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 Ledg_ Entry w_ Issue can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[G_L Entry No_]
   ,[FA No_]
   ,[FA Posting Date]
   ,[Posting Date]
   ,[Document Type]
   ,[Document Date]
   ,[Document No_]
   ,[Description]
   ,[FA Posting Type]
   ,[Amount]
   ,[Corrected]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$FA Ledg_ Entry w_ Issue$7961e9dc-a8e5-49b1-839b-3a78803a4cb8]

Show/hide columns in FA Ledg_ Entry w_ Issue table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3G_L Entry No_ Searchint
4FA No_ Searchnvarchar(40)
5FA Posting Date Searchdatetime
6Posting Date Searchdatetime
7Document Type Searchint
8Document Date Searchdatetime
9Document No_ Searchnvarchar(40)
10Description Searchnvarchar(200)
11FA Posting Type Searchint
12Amount Searchdecimal(38,38)
13Corrected Searchtinyint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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