Bank Deposit Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables BBank 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	Bank Account No.	Bank Account No.	Normal	Code	20	Bank 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_]
3	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
4	Currency Factor	Currency Factor	Normal	Decimal	12	Currency Factor	decimal(38,38)
5	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
6	Total Deposit Amount	Total Deposit Amount	Normal	Decimal	12	Total Deposit Amount	decimal(38,38)
7	Document Date	Document Date	Normal	Date	4	Document Date	datetime
8	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
9	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
10	Bank Acc. Posting Group	Bank Acc. Posting Group	Normal	Code	20	Bank Acc_ Posting Group	nvarchar(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]
11	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(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]
12	No. Printed	No. Printed	Normal	Integer	4	No_ Printed	int
13	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
14	Correction	Correction	Normal	Boolean	4	Correction	tinyint
15	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
16	Posting Description	Posting Description	Normal	Text	100	Posting Description	nvarchar(200)
17	Journal Template Name	Journal Template Name	Normal	Code	10	Journal Template Name	nvarchar(20)
18	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
21	Comment	Comment	FlowField	Boolean	4
22	Total Deposit Lines	Total Deposit Lines	FlowField	Decimal	12
23	Post as Lump Sum	Post as Lump Sum	Normal	Boolean	4	Post as Lump Sum	tinyint
24	Format Region	Format Region	Normal	Text	80	Format Region	nvarchar(160)
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Bank Deposit Header].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Bank Deposit Header table

Currency Language

Dynamics 365 BC Table Reference Tables Company Tables BBank Deposit Header

Leave a Reply Cancel reply