Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/329
Table Type: Company
Table Name: Currency for Reminder Level
Database Table Name: CRONUS UK Ltd_$Currency for Reminder Level$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 Currency for Reminder Level can be queried.
Show/hide an example select of all columns
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
Show/hide columns in Currency for Reminder Level table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | 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 query | |||||||
| 2 | No.  | No. | Normal | Integer | 4 | No_ | int |
| 3 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example query | |||||||
| 4 | Additional Fee | Additional Fee | Normal | Decimal | 12 | Additional Fee | decimal(38,38) |
| 5 | Add. Fee per Line | Add. Fee per Line | Normal | Decimal | 12 | Add_ Fee per Line | decimal(38,38) |
| 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 query | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |