Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1205
Table Type: Company
Table Name: Credit Transfer Register
Database Table Name: CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext
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 Credit Transfer Register can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]
Show/hide an example select of all columns by name
SELECT
[No_]
,[Identifier]
,[Created Date-Time]
,[Created by User]
,[Status]
,[From Bank Account No_]
,[Exported File]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Credit Transfer Register]
LEFT JOIN
[User] AS [User]
ON
[Credit Transfer Register].[Created By User] = [User].[User Name]
LEFT JOIN
[User] AS [User]
ON
[Credit Transfer Register].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Credit Transfer Register].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Credit Transfer Register table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | No. | No. | Normal | Integer | 4 | No_ | int |
2 | Identifier | Identifier | Normal | Code | 20 | Identifier | nvarchar(40) |
3 | Created Date-Time | Created Date-Time | Normal | DateTime | 8 | Created Date-Time | datetime |
4 | Created by User | Created by User | Normal | Code | 50 | Created by User | nvarchar(100) |
Key to join to the User table.Show/hide example querySELECT [Credit Transfer Register].[Created by User] ,[User].[User Name] FROM [CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Credit Transfer Register] LEFT JOIN [User] AS [User] ON [Credit Transfer Register].[Created by User] = [User].[User Name] | |||||||
5 | Status | Status | Normal | Option | 4 | Status | int |
Available options are:
| |||||||
6 | No. of Transfers | No. of Transfers | FlowField | Integer | 4 | ||
7 | From Bank Account No. | From Bank Account No. | Normal | Code | 20 | From Bank Account No_ | nvarchar(40) |
Key to join to the Bank Account table.Show/hide example querySELECT [Credit Transfer Register].[From Bank Account No_] ,[Bank Account].[No_] FROM [CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Credit Transfer Register] LEFT JOIN [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] ON [Credit Transfer Register].[From Bank Account No_] = [Bank Account].[No_] | |||||||
8 | From Bank Account Name | From Bank Account Name | FlowField | Text | 100 | ||
9 | Exported File | Exported File | Normal | BLOB | 8 | Exported File | image |
20100 | Data Exch. Entry No. | Data Exch. Entry No. | Normal | Integer | 4 | ||
Key to join to the Data Exch. table.Show/hide example querySELECT [Credit Transfer Register].[] ,[Data Exch.].[Entry No_] FROM [CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Credit Transfer Register] LEFT JOIN [CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.] ON [Credit Transfer Register].[] = [Data Exch.].[Entry No_] | |||||||
20101 | AMC Bank XTL Journal | XTL Journal | Normal | Text | 250 | ||
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 [Credit Transfer Register].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Credit Transfer Register$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Credit Transfer Register] LEFT JOIN [User] AS [User] ON [Credit Transfer Register].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |