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
   [timestamp]
   ,[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 columns in Posted Payment Recon_ Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Bank Account No_ Primary Key Searchnvarchar(40)
3Statement No_ Primary Key Searchnvarchar(40)
4Statement Line No_ Primary Key Searchint
5Document No_ Searchnvarchar(40)
6Transaction Date Searchdatetime
7Description Searchnvarchar(200)
8Statement Amount Searchdecimal(38,38)
9Difference Searchdecimal(38,38)
10Applied Amount Searchdecimal(38,38)
11Type Searchint
12Applied Entries Searchint
13Value Date Searchdatetime
14Check No_ Searchnvarchar(40)
15Related-Party Name Searchnvarchar(500)
16Additional Transaction Info Searchnvarchar(200)
17Data Exch_ Entry No_ Searchint
18Data Exch_ Line No_ Searchint
19Account Type Searchint
20Account No_ Searchnvarchar(40)
21Applied Document No_ Searchnvarchar(500)
22Applied Entry No_ Searchnvarchar(500)
23Transaction ID Searchnvarchar(500)
24Reconciled Searchtinyint
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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