Posted 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Bank Deposit No. Primary Key SearchBank Deposit No.NormalCode20Bank 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_]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Account Type SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
4Account No. SearchAccount No.NormalCode20Account 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_]
5Document Date SearchDocument DateNormalDate4Document Datedatetime
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
10Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
11Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(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]
12Shortcut 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 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]
13Shortcut 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 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]
14Posting Date SearchPosting DateNormalDate4Posting Datedatetime
15Bank Account Ledger Entry No. SearchBank Account Ledger Entry No.NormalInteger4Bank 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_]
16Entry No. SearchEntry No.NormalInteger4Entry No_int
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 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 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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Bank Deposit Line].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Posted Bank Deposit Line table

Leave a Reply

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