Posted Bank Deposit Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPosted Bank Deposit Line

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

Table Type: Company

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

Table Number: 1692

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0]

Show/hide an example select of all columns by name

SELECT

   [Bank Deposit No_]
   ,[Line No_]
   ,[Account Type]
   ,[Account No_]
   ,[Document Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Currency Code]
   ,[Amount]
   ,[Posting Group]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Posting Date]
   ,[Bank Account Ledger Entry No_]
   ,[Entry No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Posted Bank Deposit Line$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 Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Posted Bank Deposit Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Posted Bank Deposit Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Posted Bank Deposit Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Posted Bank Deposit Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Posted Bank Deposit Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Posted Bank Deposit Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Posted Bank Deposit Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Posted Bank Deposit Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Posted Bank Deposit Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Bank Deposit Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Bank Deposit Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Posted Bank Deposit Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Bank Deposit No.	Bank Deposit No.	Normal	Code	20	Bank Deposit No_	nvarchar(40)
	Key to join to the Posted Bank Deposit Header table. Show/hide example query SELECT [Posted Bank Deposit Line].[Bank Deposit No_] ,[Posted Bank Deposit Header].[No_] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Posted Bank Deposit Header$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Header] ON [Posted Bank Deposit Line].[Bank Deposit No_] = [Posted Bank Deposit Header].[No_]
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
3	Account Type	Account Type	Normal	Option	4	Account Type	int
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
4	Account No.	Account No.	Normal	Code	20	Account No_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Posted Bank Deposit Line].[Account No_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Posted Bank Deposit Line].[Account No_] = [G/L Account].[No_]
5	Document Date	Document Date	Normal	Date	4	Document Date	datetime
6	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
7	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
8	Description	Description	Normal	Text	100	Description	nvarchar(200)
9	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Posted Bank Deposit Line].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Posted Bank Deposit Line].[Currency Code] = [Currency].[Code]
10	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
11	Posting Group	Posting Group	Normal	Code	20	Posting Group	nvarchar(40)
	Key to join to the Customer Posting Group table. Show/hide example query SELECT [Posted Bank Deposit Line].[Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [Posted Bank Deposit Line].[Posting Group] = [Customer Posting Group].[Code]
12	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 [Posted Bank Deposit Line].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Posted Bank Deposit Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
13	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 [Posted Bank Deposit Line].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Posted Bank Deposit Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
14	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
15	Bank Account Ledger Entry No.	Bank Account Ledger Entry No.	Normal	Integer	4	Bank Account Ledger Entry No_	int
	Key to join to the Bank Account Ledger Entry table. Show/hide example query SELECT [Posted Bank Deposit Line].[Bank Account Ledger Entry No_] ,[Bank Account Ledger Entry].[Entry No_] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry] ON [Posted Bank Deposit Line].[Bank Account Ledger Entry No_] = [Bank Account Ledger Entry].[Entry No_]
16	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
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 [Posted Bank Deposit Line].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Posted Bank Deposit Line].[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 [Posted Bank Deposit Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Posted Bank Deposit Line$7a129d06-5fd6-4fb6-b82b-0bf539c779d0] AS [Posted Bank Deposit Line] LEFT JOIN [User] AS [User] ON [Posted Bank Deposit Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Posted Bank Deposit Line table

Dynamics 365 BC Table Reference Tables Company Tables PPosted Bank Deposit Line

Leave a Reply Cancel reply