Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1053
Table Type: Company
Table Name: Line Fee Note on Report Hist.
Database Table Name: CRONUS UK Ltd_$Line Fee Note on Report Hist_$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 Line Fee Note on Report Hist. can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Cust_ Ledger Entry No]
,[Due Date]
,[Language Code]
,[Reminder Terms Code]
,[Reminder Level No]
,[ReportText]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Line Fee Note on Report Hist.]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Line Fee Note on Report Hist.].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Line Fee Note on Report Hist.].[Reminder Terms Code] = [Reminder Terms].[Code]
LEFT JOIN
[User] AS [User]
ON
[Line Fee Note on Report Hist.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Line Fee Note on Report Hist.].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Line Fee Note on Report Hist. table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Cust. Ledger Entry No   | Cust. Ledger Entry No | Normal | Integer | 4 | Cust_ Ledger Entry No | int |
| 2 | Due Date | Due Date | Normal | Date | 4 | Due Date | datetime |
| 3 | Language Code | Language Code | Normal | Code | 10 | Language Code | nvarchar(20) |
Key to join to the Language table.Show/hide example querySELECT
[Line Fee Note on Report Hist.].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Line Fee Note on Report Hist.]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Line Fee Note on Report Hist.].[Language Code] = [Language].[Code] | |||||||
| 4 | Reminder Terms Code | Reminder Terms Code | Normal | Code | 10 | Reminder Terms Code | nvarchar(20) |
Key to join to the Reminder Terms table.Show/hide example querySELECT
[Line Fee Note on Report Hist.].[Reminder Terms Code]
,[Reminder Terms].[Code]
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Line Fee Note on Report Hist.]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Line Fee Note on Report Hist.].[Reminder Terms Code] = [Reminder Terms].[Code] | |||||||
| 5 | Reminder Level No | Reminder Level No | Normal | Integer | 4 | Reminder Level No | int |
| 6 | ReportText | ReportText | Normal | Text | 200 | ReportText | nvarchar(400) |
| 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
[Line Fee Note on Report Hist.].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Line Fee Note on Report Hist.]
LEFT JOIN
[User] AS [User]
ON
[Line Fee Note on Report Hist.].[$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
[Line Fee Note on Report Hist.].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Line Fee Note on Report Hist_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Line Fee Note on Report Hist.]
LEFT JOIN
[User] AS [User]
ON
[Line Fee Note on Report Hist.].[$systemModifiedBy] = [User].[User Security ID] | |||||||