Bank Deposit Header

Dynamics 365 BC Table ReferenceTablesCompany TablesBBank Deposit Header

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

Table Type: Company

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

Table Number: 1690

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$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]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[Post as Lump Sum]
   ,[Format Region]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Bank Deposit Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Bank 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 Deposit Header].[Bank Account No_]
	       ,[Bank Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
	              ON
	                     [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
	       [Bank Deposit Header].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [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
	       [Bank Deposit Header].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [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
	       [Bank Deposit Header].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [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
	       [Bank Deposit Header].[Bank Acc_ Posting Group]
	       ,[Bank Account Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Account Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Posting Group]
	              ON
	                     [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
	       [Bank Deposit Header].[Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [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
	       [Bank Deposit Header].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [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
	       [Bank Deposit Header].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Bank Deposit Header].[No_ Series] = [No. Series].[Code]
16Posting Description SearchPosting DescriptionNormalText100Posting Descriptionnvarchar(200)
17Journal Template Name SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
18Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
21Comment SearchCommentFlowFieldBoolean4
22Total Deposit Lines SearchTotal Deposit LinesFlowFieldDecimal12
23Post as Lump Sum SearchPost as Lump SumNormalBoolean4Post as Lump Sumtinyint
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
	       [Bank Deposit Header].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [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
	       [Bank Deposit Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Bank Deposit Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Bank Deposit Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Bank Deposit Header table

CurrencyLanguage
Dynamics 365 BC Table ReferenceTablesCompany TablesBBank Deposit Header

Leave a Reply

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