Bank Account Statement

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

Table Type: Company

Table Name: Bank Account Statement
Database Table Name: CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 275

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 Bank Account Statement can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Bank Account No_]
   ,[Statement No_]
   ,[Statement Ending Balance]
   ,[Statement Date]
   ,[Balance Last Statement]
   ,[G_L Balance at Posting Date]
   ,[Outstd_ Payments at Posting]
   ,[Outstd_ Transact_ at Posting]
   ,[Total Pos_ Diff_ at Posting]
   ,[Total Neg_ Diff_ at Posting]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Statement]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Account Statement].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Account Statement].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Bank Account Statement table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Bank Account No. Primary Key SearchBank Account No.NormalCode20Bank Account No_nvarchar(40)
Key to join to the Bank Account table.

Show/hide example query

SELECT
       [Bank Account Statement].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Statement]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Bank Account Statement].[Bank Account No_] = [Bank Account].[No_]
2Statement No. Primary Key SearchStatement No.NormalCode20Statement No_nvarchar(40)
3Statement Ending Balance SearchStatement Ending BalanceNormalDecimal12Statement Ending Balancedecimal(38,38)
4Statement Date SearchStatement DateNormalDate4Statement Datedatetime
5Balance Last Statement SearchBalance Last StatementNormalDecimal12Balance Last Statementdecimal(38,38)
50Bank Account Name SearchBank Account NameFlowFieldText100
100G/L Balance at Posting Date SearchG/L Balance at Posting DateNormalDecimal12G_L Balance at Posting Datedecimal(38,38)
101Outstd. Payments at Posting SearchOutstanding Payments at Posting DateNormalDecimal12Outstd_ Payments at Postingdecimal(38,38)
102Outstd. Transact. at Posting SearchOutstading Bank Transactions at Posting DateNormalDecimal12Outstd_ Transact_ at Postingdecimal(38,38)
103Total Pos. Diff. at Posting SearchTotal Positive Difference at Posting DateNormalDecimal12Total Pos_ Diff_ at Postingdecimal(38,38)
104Total Neg. Diff. at Posting SearchTotal Negative Difference at Posting DateNormalDecimal12Total Neg_ Diff_ at Postingdecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Bank Account Statement].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Statement]
LEFT JOIN
       [User] AS [User]
              ON
                     [Bank Account Statement].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Bank Account Statement].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Bank Account Statement$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Statement]
LEFT JOIN
       [User] AS [User]
              ON
                     [Bank Account Statement].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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