Posted Bank Deposit Header

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

Table Type: Company

Table Name: Posted Bank Deposit Header
Database Table Name: CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0

Table Number: 1691

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 Posted Bank Deposit Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Bank Account No_]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Posting Date]
   ,[Total Deposit Amount]
   ,[Document Date]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Bank Acc_ Posting Group]
   ,[Language Code]
   ,[No_ Printed]
   ,[Reason Code]
   ,[Correction]
   ,[No_ Series]
   ,[Posting Description]
   ,[Format Region]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Posted Bank Deposit Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Posted Bank Deposit Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Posted Bank Deposit Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Posted Bank Deposit Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Posted Bank Deposit Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Posted Bank Deposit Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Bank Deposit Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Bank Deposit Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Posted Bank Deposit Header table

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

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Posted Bank Deposit Header].[Bank Account No_] = [Bank Account].[No_]
3Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Posted Bank Deposit Header].[Currency Code] = [Currency].[Code]
4Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
6Total Deposit Amount SearchTotal Deposit AmountNormalDecimal12Total Deposit Amountdecimal(38,38)
7Document Date SearchDocument DateNormalDate4Document Datedatetime
8Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Posted Bank Deposit Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
9Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Posted Bank Deposit Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
10Bank Acc. Posting Group SearchBank Acc. Posting GroupNormalCode20Bank Acc_ Posting Groupnvarchar(40)
Key to join to the Bank Account Posting Group table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Bank Acc_ Posting Group]
       ,[Bank Account Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Posting Group]
              ON
                     [Posted Bank Deposit Header].[Bank Acc_ Posting Group] = [Bank Account Posting Group].[Code]
11Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Posted Bank Deposit Header].[Language Code] = [Language].[Code]
12No. Printed SearchNo. PrintedNormalInteger4No_ Printedint
13Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Posted Bank Deposit Header].[Reason Code] = [Reason Code].[Code]
14Correction SearchCorrectionNormalBoolean4Correctiontinyint
15No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Posted Bank Deposit Header].[No_ Series] = [No. Series].[Code]
16Posting Description SearchPosting DescriptionNormalText100Posting Descriptionnvarchar(200)
21Comment SearchCommentFlowFieldBoolean4
22Total Deposit Lines SearchTotal Deposit LinesFlowFieldDecimal12
24Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Posted Bank Deposit Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Posted Bank Deposit Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
       [Posted Bank Deposit Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Bank Deposit Header].[$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
       [Posted Bank Deposit Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Bank Deposit Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Posted Bank Deposit Header table

Leave a Reply

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