Posted Payment Recon. Line

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

Table Type: Company

Table Name: Posted Payment Recon. Line
Database Table Name: CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1296

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Bank Account No_]
   ,[Statement No_]
   ,[Statement Line No_]
   ,[Document No_]
   ,[Transaction Date]
   ,[Description]
   ,[Statement Amount]
   ,[Difference]
   ,[Applied Amount]
   ,[Type]
   ,[Applied Entries]
   ,[Value Date]
   ,[Check No_]
   ,[Related-Party Name]
   ,[Additional Transaction Info]
   ,[Data Exch_ Entry No_]
   ,[Data Exch_ Line No_]
   ,[Account Type]
   ,[Account No_]
   ,[Applied Document No_]
   ,[Applied Entry No_]
   ,[Transaction ID]
   ,[Reconciled]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Payment Recon. Line]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Payment Recon. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Payment Recon. Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Posted Payment Recon. Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Bank 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
       [Posted Payment Recon. Line].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Payment Recon. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Posted Payment Recon. Line].[Bank Account No_] = [Bank Account].[No_]
2Statement No. Primary Key SearchStatement No.NormalCode20Statement No_nvarchar(40)
3Statement Line No. Primary Key SearchStatement Line No.NormalInteger4Statement Line No_int
4Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
5Transaction Date SearchTransaction DateNormalDate4Transaction Datedatetime
6Description SearchDescriptionNormalText100Descriptionnvarchar(200)
7Statement Amount SearchStatement AmountNormalDecimal12Statement Amountdecimal(38,38)
8Difference SearchDifferenceNormalDecimal12Differencedecimal(38,38)
9Applied Amount SearchApplied AmountNormalDecimal12Applied Amountdecimal(38,38)
10Type SearchTypeNormalOption4Typeint
Available options are:
  • “Bank Account Ledger Entry”
  • “Check Ledger Entry”
  • “Difference”
11Applied Entries SearchApplied EntriesNormalInteger4Applied Entriesint
12Value Date SearchValue DateNormalDate4Value Datedatetime
14Check No. SearchCheck No.NormalCode20Check No_nvarchar(40)
15Related-Party Name SearchRelated-Party NameNormalText250Related-Party Namenvarchar(500)
16Additional Transaction Info SearchAdditional Transaction InfoNormalText100Additional Transaction Infonvarchar(200)
17Data Exch. Entry No. SearchData Exch. Entry No.NormalInteger4Data Exch_ Entry No_int
Key to join to the Data Exch. table.

Show/hide example query

SELECT
       [Posted Payment Recon. Line].[Data Exch_ Entry No_]
       ,[Data Exch.].[Entry No_]
FROM
       [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Payment Recon. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.]
              ON
                     [Posted Payment Recon. Line].[Data Exch_ Entry No_] = [Data Exch.].[Entry No_]
18Data Exch. Line No. SearchData Exch. Line No.NormalInteger4Data Exch_ Line No_int
21Account Type SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
22Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Posted Payment Recon. Line].[Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Payment Recon. Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Posted Payment Recon. Line].[Account No_] = [G/L Account].[No_]
23Applied Document No. SearchApplied Document No.NormalText250Applied Document No_nvarchar(500)
24Applied Entry No. SearchApplied Entry No.NormalText250Applied Entry No_nvarchar(500)
70Transaction ID SearchTransaction IDNormalText250Transaction IDnvarchar(500)
71Reconciled SearchReconciledNormalBoolean4Reconciledtinyint
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 Payment Recon. Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Payment Recon. Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Payment Recon. 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 Payment Recon. Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Payment Recon_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Payment Recon. Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Payment Recon. Line].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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