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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Entry]
LEFT JOIN
   [User] AS [User]
      ON
         [Positive Pay Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Positive Pay Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Positive Pay Entry 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
       [Positive Pay Entry].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Positive Pay Entry].[Bank Account No_] = [Bank Account].[No_]
2Upload Date-Time Primary Key SearchUpload Date-TimeNormalDateTime8Upload Date-Timedatetime
5Last Upload Date SearchLast Upload DateNormalDate4Last Upload Datedatetime
6Last Upload Time SearchLast Upload TimeNormalTime4Last Upload Timedatetime
7Number of Uploads SearchNumber of UploadsNormalInteger4Number of Uploadsint
8Number of Checks SearchNumber of ChecksNormalInteger4Number of Checksint
9Number of Voids SearchNumber of VoidsNormalInteger4Number of Voidsint
10Check Amount SearchCheck AmountNormalDecimal12Check Amountdecimal(38,38)
11Void Amount SearchVoid AmountNormalDecimal12Void Amountdecimal(38,38)
12Confirmation Number SearchConfirmation NumberNormalText20Confirmation Numbernvarchar(40)
13Exported File SearchExported FileNormalBLOB8Exported Fileimage
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
       [Positive Pay Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Positive Pay Entry].[$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
       [Positive Pay Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Positive Pay Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Positive Pay Entry].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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