Positive Pay Footer

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

Table Type: Company

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

Table Number: 1242

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 Footer can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Data Exch_ Entry No_]
   ,[Data Exch_ Detail Entry No_]
   ,[Account Number]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Positive Pay Footer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Positive Pay Footer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Exch_ Entry No_ Primary Key Searchint
3Data Exch_ Detail Entry No_ Searchint
4Account Number Searchnvarchar(60)
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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