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
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
[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 an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Positive Pay Footer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Footer]
LEFT JOIN
[User] AS [User]
ON
[Positive Pay Footer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Positive Pay Footer].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Positive Pay Footer table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Data Exch. Entry No.   | Data Exch. Entry No. | Normal | Integer | 4 | Data Exch_ Entry No_ | int |
Key to join to the Data Exch. table.Show/hide example querySELECT
[Positive Pay Footer].[Data Exch_ Entry No_]
,[Data Exch.].[Entry No_]
FROM
[CRONUS UK Ltd_$Positive Pay Footer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Footer]
LEFT JOIN
[CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.]
ON
[Positive Pay Footer].[Data Exch_ Entry No_] = [Data Exch.].[Entry No_] | |||||||
| 2 | Data Exch. Detail Entry No. | Data Exch. Detail Entry No. | Normal | Integer | 4 | Data Exch_ Detail Entry No_ | int |
Key to join to the Positive Pay Detail table.Show/hide example querySELECT
[Positive Pay Footer].[Data Exch_ Detail Entry No_]
,[Positive Pay Detail].[Data Exch_ Entry No_]
FROM
[CRONUS UK Ltd_$Positive Pay Footer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Footer]
LEFT JOIN
[CRONUS UK Ltd_$Positive Pay Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Detail]
ON
[Positive Pay Footer].[Data Exch_ Detail Entry No_] = [Positive Pay Detail].[Data Exch_ Entry No_] | |||||||
| 3 | Account Number | Account Number | Normal | Text | 30 | Account Number | nvarchar(60) |
| 4 | Check Count | Check Count | FlowField | Integer | 4 | ||
| 5 | Check Total | Check Total | FlowField | Decimal | 12 | ||
| 6 | Void Count | Void Count | FlowField | Integer | 4 | ||
| 7 | Void Total | Void Total | FlowField | Decimal | 12 | ||
| 8 | Total Count | Total Count | FlowField | Integer | 4 | ||
| 9 | Grand Total | Grand Total | FlowField | Decimal | 12 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Positive Pay Footer].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Positive Pay Footer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Footer]
LEFT JOIN
[User] AS [User]
ON
[Positive Pay Footer].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Positive Pay Footer].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Positive Pay Footer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Positive Pay Footer]
LEFT JOIN
[User] AS [User]
ON
[Positive Pay Footer].[$systemModifiedBy] = [User].[User Security ID] | |||||||