BACS Ledger Entry

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

Table Type: Company

Table Name: BACS Ledger Entry
Database Table Name: CRONUS UK Ltd_$BACS Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 BACS Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$BACS Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Bank Account No_]
   ,[Bank Account Ledger Entry No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Amount]
   ,[BACS Date]
   ,[Entry Status]
   ,[Original Entry Status]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Open]
   ,[Statement Status]
   ,[Statement No_]
   ,[Statement Line No_]
   ,[User ID]
   ,[External Document No_]
   ,[Account Type]
   ,[Account No_]
   ,[Journal Batch Name]
   ,[Register No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$BACS Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in BACS Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Bank Account No_ Searchnvarchar(40)
4Bank Account Ledger Entry No_ Searchint
5Posting Date Searchdatetime
6Document Type Searchint
7Document No_ Searchnvarchar(40)
8Description Searchnvarchar(100)
9Amount Searchdecimal(38,38)
10BACS Date Searchdatetime
11Entry Status Searchint
12Original Entry Status Searchint
13Bal_ Account Type Searchint
14Bal_ Account No_ Searchnvarchar(40)
15Open Searchtinyint
16Statement Status Searchint
17Statement No_ Searchnvarchar(40)
18Statement Line No_ Searchint
19User ID Searchnvarchar(100)
20External Document No_ Searchnvarchar(70)
21Account Type Searchint
22Account No_ Searchnvarchar(40)
23Journal Batch Name Searchnvarchar(20)
24Register No_ Searchint
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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