Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/8
Table Type: Company
Table Name: Language
Database Table Name: CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f
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 Language can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Code]
,[Name]
,[Windows Language ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f]Show/hide columns in Language table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Code  | nvarchar(20) |
| 3 | Name | nvarchar(100) |
| 4 | Windows Language ID | int |
| 5 | $systemId | uniqueidentifier |
| 6 | $systemCreatedAt | datetime |
| 7 | $systemCreatedBy | uniqueidentifier |
| 8 | $systemModifiedAt | datetime |
| 9 | $systemModifiedBy | uniqueidentifier |
Show/hide tables related to Language table
Bank AccountBank Deposit HeaderContactCountry_Region TranslationCustomerCustomer Bank AccountCustomer Templ_Delivery SorterExtended Text HeaderExtended Text LineFiled Service Contract HeaderFinance Charge Memo HeaderGeneric Chart Captions BufferGeneric Chart Memo BufferInteraction Tmpl_ LanguageInvt_ Document HeaderInvt_ Receipt HeaderInvt_ Shipment HeaderIssued Fin_ Charge Memo HeaderIssued Reminder HeaderItem Attribute TranslationItem Attr_ Value TranslationItem TranslationJobLine Fee Note on Report Hist_Mini Customer TemplateMini Vendor TemplateNative – Gen_ Settings BufferO365 Payment Instr_ Transl_Payment Method TranslationPayment Reporting ArgumentPayment Term TranslationPosted Bank Deposit HeaderPurchase HeaderPurchase Header ArchivePurch_ Cr_ Memo Hdr_Purch_ Inv_ HeaderPurch_ Rcpt_ HeaderRecommended AppsReminder HeaderReminder Terms TranslationReturn Receipt HeaderReturn Shipment HeaderSales Cr_Memo HeaderSales HeaderSales Header ArchiveSales Invoice HeaderSales Shipment HeaderSalutation FormulaSegment Interaction LanguageSegment LineService Contract HeaderService Contract TemplateService Cr_Memo HeaderService HeaderService Invoice HeaderService Shipment HeaderShipment Method TranslationTax Area TranslationTax Jurisdiction TranslationTo-doTo-do Interaction LanguageUnit of Measure TranslationVAT Clause by Doc_ Type Trans_VAT Clause TranslationVendorVendor Bank AccountVendor Templ_Word Template