Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/270
Table Type: Company
Table Name: Bank Account
Database Table Name: CRONUS UK Ltd_$Bank Account$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 Bank Account can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[No_]
,[Name]
,[Search Name]
,[Name 2]
,[Address]
,[Address 2]
,[City]
,[Contact]
,[Phone No_]
,[Telex No_]
,[Bank Account No_]
,[Transit No_]
,[Territory Code]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Chain Name]
,[Min_ Balance]
,[Bank Acc_ Posting Group]
,[Currency Code]
,[Language Code]
,[Format Region]
,[Statistics Group]
,[Our Contact Code]
,[Country_Region Code]
,[Amount]
,[Blocked]
,[Last Statement No_]
,[Last Payment Statement No_]
,[Pmt_ Rec_ No_ Series]
,[Last Date Modified]
,[Use as Default for Currency]
,[Fax No_]
,[Telex Answer Back]
,[Picture]
,[Post Code]
,[County]
,[Last Check No_]
,[Balance Last Statement]
,[Bank Branch No_]
,[E-Mail]
,[Home Page]
,[No_ Series]
,[Check Report ID]
,[IBAN]
,[SWIFT Code]
,[Bank Statement Import Format]
,[Credit Transfer Msg_ Nos_]
,[Direct Debit Msg_ Nos_]
,[SEPA Direct Debit Exp_ Format]
,[Bank Stmt_ Service Record ID]
,[Transaction Import Timespan]
,[Automatic Stmt_ Import Enabled]
,[IntercompanyEnable]
,[Image]
,[Creditor No_]
,[Payment Export Format]
,[Bank Clearing Code]
,[Bank Clearing Standard]
,[Bank Name - Data Conversion]
,[Match Tolerance Type]
,[Match Tolerance Value]
,[Disable Automatic Pmt Matching]
,[Positive Pay Export Code]
,[Mobile Phone No_]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Bank Account].[City] = [Post Code].[City]
LEFT JOIN
[CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
ON
[Bank Account].[Territory Code] = [Territory].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Bank Account].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Bank Account].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Bank Account].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Bank Account].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
ON
[Bank Account].[Our Contact Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Bank Account].[Post Code] = [Post Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
ON
[Bank Account].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Export/Import Setup]
ON
[Bank Account].[Payment Export Format] = [Bank Export/Import Setup].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
ON
[Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
LEFT JOIN
[User] AS [User]
ON
[Bank Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Bank Account].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Bank Account table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
2 | Name | Name | Normal | Text | 100 | Name | nvarchar(200) |
3 | Search Name | Search Name | Normal | Code | 100 | Search Name | nvarchar(200) |
4 | Name 2 | Name 2 | Normal | Text | 50 | Name 2 | nvarchar(100) |
5 | Address | Address | Normal | Text | 100 | Address | nvarchar(200) |
6 | Address 2 | Address 2 | Normal | Text | 50 | Address 2 | nvarchar(100) |
7 | City | City | Normal | Text | 30 | City | nvarchar(60) |
Key to join to the Post Code table.Show/hide example querySELECT [Bank Account].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Bank Account].[City] = [Post Code].[City] | |||||||
8 | Contact | Contact | Normal | Text | 100 | Contact | nvarchar(200) |
9 | Phone No. | Phone No. | Normal | Text | 30 | Phone No_ | nvarchar(60) |
10 | Telex No. | Telex No. | Normal | Text | 20 | Telex No_ | nvarchar(40) |
13 | Bank Account No. | Bank Account No. | Normal | Text | 30 | Bank Account No_ | nvarchar(60) |
14 | Transit No. | Transit No. | Normal | Text | 20 | Transit No_ | nvarchar(40) |
15 | Territory Code | Territory Code | Normal | Code | 10 | Territory Code | nvarchar(20) |
Key to join to the Territory table.Show/hide example querySELECT [Bank Account].[Territory Code] ,[Territory].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory] ON [Bank Account].[Territory Code] = [Territory].[Code] | |||||||
16 | Global Dimension 1 Code | Global Dimension 1 Code | Normal | Code | 20 | Global Dimension 1 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example querySELECT [Bank Account].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Bank Account].[Global Dimension 1 Code] = [Dimension].[Code] | |||||||
17 | Global Dimension 2 Code | Global Dimension 2 Code | Normal | Code | 20 | Global Dimension 2 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example querySELECT [Bank Account].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Bank Account].[Global Dimension 2 Code] = [Dimension].[Code] | |||||||
18 | Chain Name | Chain Name | Normal | Code | 10 | Chain Name | nvarchar(20) |
20 | Min. Balance | Min. Balance | Normal | Decimal | 12 | Min_ Balance | decimal(38,38) |
21 | Bank Acc. Posting Group | Bank Acc. Posting Group | Normal | Code | 20 | Bank Acc_ Posting Group | nvarchar(40) |
Key to join to the Bank Account Posting Group table.Show/hide example querySELECT [Bank Account].[Bank Acc_ Posting Group] ,[Bank Account Posting Group].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Bank Account Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Posting Group] ON [Bank Account].[Bank Acc_ Posting Group] = [Bank Account Posting Group].[Code] | |||||||
22 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example querySELECT [Bank Account].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Bank Account].[Currency Code] = [Currency].[Code] | |||||||
24 | Language Code | Language Code | Normal | Code | 10 | Language Code | nvarchar(20) |
Key to join to the Language table.Show/hide example querySELECT [Bank Account].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Bank Account].[Language Code] = [Language].[Code] | |||||||
25 | Format Region | Format Region | Normal | Text | 80 | Format Region | nvarchar(160) |
26 | Statistics Group | Statistics Group | Normal | Integer | 4 | Statistics Group | int |
29 | Our Contact Code | Our Contact Code | Normal | Code | 20 | Our Contact Code | nvarchar(40) |
Key to join to the Salesperson/Purchaser table.Show/hide example querySELECT [Bank Account].[Our Contact Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Bank Account].[Our Contact Code] = [Salesperson/Purchaser].[Code] | |||||||
35 | Country/Region Code | Country/Region Code | Normal | Code | 10 | Country_Region Code | nvarchar(20) |
37 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
38 | Comment | Comment | FlowField | Boolean | 4 | ||
39 | Blocked | Blocked | Normal | Boolean | 4 | Blocked | tinyint |
41 | Last Statement No. | Last Statement No. | Normal | Code | 20 | Last Statement No_ | nvarchar(40) |
42 | Last Payment Statement No. | Last Payment Statement No. | Normal | Code | 20 | Last Payment Statement No_ | nvarchar(40) |
43 | Pmt. Rec. No. Series | Payment Reconciliation No. Series | Normal | Code | 20 | Pmt_ Rec_ No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT [Bank Account].[Pmt_ Rec_ No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[Pmt_ Rec_ No_ Series] = [No. Series].[Code] | |||||||
54 | Last Date Modified | Last Date Modified | Normal | Date | 4 | Last Date Modified | datetime |
55 | Date Filter | Date Filter | FlowFilter | Date | 4 | ||
56 | Global Dimension 1 Filter | Global Dimension 1 Filter | FlowFilter | Code | 20 | ||
57 | Global Dimension 2 Filter | Global Dimension 2 Filter | FlowFilter | Code | 20 | ||
58 | Balance | Balance | FlowField | Decimal | 12 | ||
59 | Balance (LCY) | Balance ($) | FlowField | Decimal | 12 | ||
60 | Net Change | Net Change | FlowField | Decimal | 12 | ||
61 | Net Change (LCY) | Net Change ($) | FlowField | Decimal | 12 | ||
62 | Total on Checks | Total on Checks | FlowField | Decimal | 12 | ||
70 | Use as Default for Currency | Use as Default for Currency | Normal | Boolean | 4 | Use as Default for Currency | tinyint |
84 | Fax No. | Fax No. | Normal | Text | 30 | Fax No_ | nvarchar(60) |
85 | Telex Answer Back | Telex Answer Back | Normal | Text | 20 | Telex Answer Back | nvarchar(40) |
89 | Picture | Picture | Normal | BLOB | 8 | Picture | image |
91 | Post Code | ZIP Code | Normal | Code | 20 | Post Code | nvarchar(40) |
Key to join to the Post Code table.Show/hide example querySELECT [Bank Account].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Bank Account].[Post Code] = [Post Code].[Code] | |||||||
92 | County | State | Normal | Text | 30 | County | nvarchar(60) |
93 | Last Check No. | Last Check No. | Normal | Code | 20 | Last Check No_ | nvarchar(40) |
94 | Balance Last Statement | Balance Last Statement | Normal | Decimal | 12 | Balance Last Statement | decimal(38,38) |
95 | Balance at Date | Balance at Date | FlowField | Decimal | 12 | ||
96 | Balance at Date (LCY) | Balance at Date ($) | FlowField | Decimal | 12 | ||
97 | Debit Amount | Debit Amount | FlowField | Decimal | 12 | ||
98 | Credit Amount | Credit Amount | FlowField | Decimal | 12 | ||
99 | Debit Amount (LCY) | Debit Amount ($) | FlowField | Decimal | 12 | ||
100 | Credit Amount (LCY) | Credit Amount ($) | FlowField | Decimal | 12 | ||
101 | Bank Branch No. | Bank Branch No. | Normal | Text | 20 | Bank Branch No_ | nvarchar(40) |
102 | Normal | Text | 80 | nvarchar(160) | |||
103 | Home Page | Home Page | Normal | Text | 80 | Home Page | nvarchar(160) |
107 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT [Bank Account].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[No_ Series] = [No. Series].[Code] | |||||||
108 | Check Report ID | Check Report ID | Normal | Integer | 4 | Check Report ID | int |
109 | Check Report Name | Check Report Name | FlowField | Text | 250 | ||
110 | IBAN | IBAN | Normal | Code | 50 | IBAN | nvarchar(100) |
111 | SWIFT Code | SWIFT Code | Normal | Code | 20 | SWIFT Code | nvarchar(40) |
Key to join to the SWIFT Code table.Show/hide example querySELECT [Bank Account].[SWIFT Code] ,[SWIFT Code].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code] ON [Bank Account].[SWIFT Code] = [SWIFT Code].[Code] | |||||||
113 | Bank Statement Import Format | Bank Statement Import Format | Normal | Code | 20 | Bank Statement Import Format | nvarchar(40) |
115 | Credit Transfer Msg. Nos. | Credit Transfer Msg. Nos. | Normal | Code | 20 | Credit Transfer Msg_ Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT [Bank Account].[Credit Transfer Msg_ Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[Credit Transfer Msg_ Nos_] = [No. Series].[Code] | |||||||
116 | Direct Debit Msg. Nos. | Direct Debit Msg. Nos. | Normal | Code | 20 | Direct Debit Msg_ Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT [Bank Account].[Direct Debit Msg_ Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[Direct Debit Msg_ Nos_] = [No. Series].[Code] | |||||||
117 | SEPA Direct Debit Exp. Format | SEPA Direct Debit Exp. Format | Normal | Code | 20 | SEPA Direct Debit Exp_ Format | nvarchar(40) |
121 | Bank Stmt. Service Record ID | Bank Stmt. Service Record ID | Normal | RecordID | 448 | Bank Stmt_ Service Record ID | varbinary(448) |
123 | Transaction Import Timespan | Transaction Import Timespan | Normal | Integer | 4 | Transaction Import Timespan | int |
124 | Automatic Stmt. Import Enabled | Automatic Stmt. Import Enabled | Normal | Boolean | 4 | Automatic Stmt_ Import Enabled | tinyint |
130 | IntercompanyEnable | Enable for Intercompany transactions | Normal | Boolean | 4 | IntercompanyEnable | tinyint |
140 | Image | Image | Normal | Media | 16 | Image | uniqueidentifier |
170 | Creditor No. | Creditor No. | Normal | Code | 35 | Creditor No_ | nvarchar(70) |
1210 | Payment Export Format | Payment Export Format | Normal | Code | 20 | Payment Export Format | nvarchar(40) |
Key to join to the Bank Export/Import Setup table.Show/hide example querySELECT [Bank Account].[Payment Export Format] ,[Bank Export/Import Setup].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Export/Import Setup] ON [Bank Account].[Payment Export Format] = [Bank Export/Import Setup].[Code] | |||||||
1211 | Bank Clearing Code | Bank Clearing Code | Normal | Text | 50 | Bank Clearing Code | nvarchar(100) |
1212 | Bank Clearing Standard | Bank Clearing Standard | Normal | Text | 50 | Bank Clearing Standard | nvarchar(100) |
Key to join to the Bank Clearing Standard table.Show/hide example querySELECT [Bank Account].[Bank Clearing Standard] ,[Bank Clearing Standard].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard] ON [Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code] | |||||||
1213 | Bank Name – Data Conversion | Bank Name – Data Conversion | Normal | Text | 50 | Bank Name – Data Conversion | nvarchar(100) |
1250 | Match Tolerance Type | Match Tolerance Type | Normal | Option | 4 | Match Tolerance Type | int |
Available options are:
| |||||||
1251 | Match Tolerance Value | Match Tolerance Value | Normal | Decimal | 12 | Match Tolerance Value | decimal(38,38) |
1252 | Disable Automatic Pmt Matching | Disable Automatic Payment Matching | Normal | Boolean | 4 | Disable Automatic Pmt Matching | tinyint |
1260 | Positive Pay Export Code | Positive Pay Export Code | Normal | Code | 20 | Positive Pay Export Code | nvarchar(40) |
5061 | Mobile Phone No. | Mobile Phone No. | Normal | Text | 30 | Mobile Phone No_ | nvarchar(60) |
10005 | E-Pay Export File Path | E-Pay Export File Path | Normal | Text | 250 | ||
10006 | Last E-Pay Export File Name | Last E-Pay Export File Name | Normal | Text | 30 | ||
10007 | E-Pay Trans. Program Path | E-Pay Trans. Program Path | Normal | Text | 250 | ||
10008 | E-Pay Trans. Program Command | E-Pay Trans. Program Command | Normal | Text | 80 | ||
10009 | Last ACH File ID Modifier | Last ACH File ID Modifier | Normal | Code | 1 | ||
10010 | Last Remittance Advice No. | Last Remittance Advice No. | Normal | Code | 20 | ||
10011 | Export Format | Export Format | Normal | Option | 4 | ||
10012 | Last E-Pay File Creation No. | Last E-Pay File Creation No. | Normal | Integer | 4 | ||
10013 | Client No. | Client No. | Normal | Code | 10 | ||
10014 | Client Name | Client Name | Normal | Code | 30 | ||
10015 | Input Qualifier | Input Qualifier | Normal | Code | 30 | ||
10017 | Bank Communication | Bank Communication | Normal | Option | 4 | ||
10018 | Check Date Format | Check Date Format | Normal | Option | 4 | ||
10019 | Check Date Separator | Check Date Separator | Normal | Option | 4 | ||
10020 | EFT Export Code | EFT IAT Export Format | Normal | Code | 20 | ||
20100 | AMC Bank Name | Bank Name | Normal | Text | 50 | ||
20101 | AMC Bank File Name | Bank file Name | Normal | Text | 250 | ||
27000 | Bank Code | Bank Code | Normal | Code | 3 | ||
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 [Bank Account].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [User] AS [User] ON [Bank Account].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |