Positive Pay Entry

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

Table Type: Company

Table Name: Positive Pay Entry
Database Table Name: CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1231

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 Positive Pay Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Bank Account No_]
   ,[Upload Date-Time]
   ,[Last Upload Date]
   ,[Last Upload Time]
   ,[Number of Uploads]
   ,[Number of Checks]
   ,[Number of Voids]
   ,[Check Amount]
   ,[Void Amount]
   ,[Confirmation Number]
   ,[Exported File]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Positive Pay Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Bank Account No_ Primary Key Searchnvarchar(40)
3Upload Date-Time Primary Key Searchdatetime
4Last Upload Date Searchdatetime
5Last Upload Time Searchdatetime
6Number of Uploads Searchint
7Number of Checks Searchint
8Number of Voids Searchint
9Check Amount Searchdecimal(38,38)
10Void Amount Searchdecimal(38,38)
11Confirmation Number Searchnvarchar(40)
12Exported File Searchimage
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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