Source Code Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesSSource Code Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/242

Table Type: Company

Table Name: Source Code Setup
Database Table Name: CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 242

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 Source Code Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Sales]
   ,[Purchases]
   ,[Inventory Post Cost]
   ,[Exchange Rate Adjmt_]
   ,[Post Recognition]
   ,[Post Value]
   ,[Close Income Statement]
   ,[Consolidation]
   ,[General Journal]
   ,[Sales Journal]
   ,[Purchase Journal]
   ,[Cash Receipt Journal]
   ,[Payment Journal]
   ,[Item Journal]
   ,[Resource Journal]
   ,[Job Journal]
   ,[Sales Entry Application]
   ,[Purchase Entry Application]
   ,[VAT Settlement]
   ,[Compress G_L]
   ,[Compress VAT Entries]
   ,[Compress Cust_ Ledger]
   ,[Compress Vend_ Ledger]
   ,[Compress Item Ledger]
   ,[Compress Res_ Ledger]
   ,[Compress Job Ledger]
   ,[Item Reclass_ Journal]
   ,[Phys_ Inventory Journal]
   ,[Compress Bank Acc_ Ledger]
   ,[Compress Check Ledger]
   ,[Financially Voided Check]
   ,[Finance Charge Memo]
   ,[Reminder]
   ,[Deleted Document]
   ,[Adjust Add_ Reporting Currency]
   ,[Trans_ Bank Rec_ to Gen_ Jnl_]
   ,[IC General Journal]
   ,[Unapplied Empl_ Entry Appln_]
   ,[Unapplied Sales Entry Appln_]
   ,[Unapplied Purch_ Entry Appln_]
   ,[Reversal]
   ,[Employee Entry Application]
   ,[Payment Reconciliation Journal]
   ,[Cash Flow Worksheet]
   ,[Assembly]
   ,[Job G_L Journal]
   ,[Job G_L WIP]
   ,[G_L Entry to CA]
   ,[Cost Journal]
   ,[Cost Allocation]
   ,[Transfer Budget to Actual]
   ,[General Deferral]
   ,[Sales Deferral]
   ,[Purchase Deferral]
   ,[Consumption Journal]
   ,[Output Journal]
   ,[Flushing]
   ,[Capacity Journal]
   ,[Production Journal]
   ,[Production Order]
   ,[Fixed Asset Journal]
   ,[Fixed Asset G_L Journal]
   ,[Insurance Journal]
   ,[Compress FA Ledger]
   ,[Compress Maintenance Ledger]
   ,[Compress Insurance Ledger]
   ,[Transfer]
   ,[Revaluation Journal]
   ,[Adjust Cost]
   ,[Invt_ Receipt]
   ,[Invt_ Shipment]
   ,[Phys_ Invt_ Orders]
   ,[Service Management]
   ,[Compress Item Budget]
   ,[Whse_ Item Journal]
   ,[Whse_ Phys_ Invt_ Journal]
   ,[Whse_ Reclassification Journal]
   ,[Whse_ Put-away]
   ,[Whse_ Pick]
   ,[Whse_ Movement]
   ,[Compress Whse_ Entries]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Sales] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Purchases] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Inventory Post Cost] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Post Recognition] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Post Value] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Close Income Statement] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Consolidation] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[General Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Sales Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Purchase Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Cash Receipt Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Payment Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Item Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Resource Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Job Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Sales Entry Application] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Purchase Entry Application] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[VAT Settlement] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress VAT Entries] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress Item Ledger] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress Job Ledger] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress Check Ledger] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Financially Voided Check] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Finance Charge Memo] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Reminder] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Deleted Document] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[IC General Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Reversal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Employee Entry Application] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Payment Reconciliation Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Cash Flow Worksheet] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Assembly] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Cost Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Cost Allocation] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Transfer Budget to Actual] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Bank Deposit] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[General Deferral] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Sales Deferral] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Purchase Deferral] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Consumption Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Output Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Flushing] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Capacity Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Production Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Production Order] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Fixed Asset Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Insurance Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress FA Ledger] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress Maintenance Ledger] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress Insurance Ledger] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Transfer] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Revaluation Journal] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Adjust Cost] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Service Management] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Compress Item Budget] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Deposits] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Source Code Setup].[Statistical Account Journal] = [Source Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Source Code Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Source Code Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Source Code Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Sales SearchSalesNormalCode10Salesnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Sales]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Sales] = [Source Code].[Code]
3Purchases SearchPurchasesNormalCode10Purchasesnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Purchases]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Purchases] = [Source Code].[Code]
4Inventory Post Cost SearchInventory Post CostNormalCode10Inventory Post Costnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Inventory Post Cost]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Inventory Post Cost] = [Source Code].[Code]
5Exchange Rate Adjmt. SearchExchange Rate Adjmt.NormalCode10Exchange Rate Adjmt_nvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Exchange Rate Adjmt_]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Exchange Rate Adjmt_] = [Source Code].[Code]
6Post Recognition SearchPost RecognitionNormalCode10Post Recognitionnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Post Recognition]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Post Recognition] = [Source Code].[Code]
7Post Value SearchPost ValueNormalCode10Post Valuenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Post Value]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Post Value] = [Source Code].[Code]
8Close Income Statement SearchClose Income StatementNormalCode10Close Income Statementnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Close Income Statement]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Close Income Statement] = [Source Code].[Code]
9Consolidation SearchConsolidationNormalCode10Consolidationnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Consolidation]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Consolidation] = [Source Code].[Code]
10General Journal SearchGeneral JournalNormalCode10General Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[General Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[General Journal] = [Source Code].[Code]
11Sales Journal SearchSales JournalNormalCode10Sales Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Sales Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Sales Journal] = [Source Code].[Code]
12Purchase Journal SearchPurchase JournalNormalCode10Purchase Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Purchase Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Purchase Journal] = [Source Code].[Code]
13Cash Receipt Journal SearchCash Receipt JournalNormalCode10Cash Receipt Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Cash Receipt Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Cash Receipt Journal] = [Source Code].[Code]
14Payment Journal SearchPayment JournalNormalCode10Payment Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Payment Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Payment Journal] = [Source Code].[Code]
16Item Journal SearchItem JournalNormalCode10Item Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Item Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Item Journal] = [Source Code].[Code]
19Resource Journal SearchResource JournalNormalCode10Resource Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Resource Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Resource Journal] = [Source Code].[Code]
20Job Journal SearchJob JournalNormalCode10Job Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Job Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Job Journal] = [Source Code].[Code]
21Sales Entry Application SearchSales Entry ApplicationNormalCode10Sales Entry Applicationnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Sales Entry Application]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Sales Entry Application] = [Source Code].[Code]
22Purchase Entry Application SearchPurchase Entry ApplicationNormalCode10Purchase Entry Applicationnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Purchase Entry Application]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Purchase Entry Application] = [Source Code].[Code]
23VAT Settlement SearchVAT SettlementNormalCode10VAT Settlementnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[VAT Settlement]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[VAT Settlement] = [Source Code].[Code]
24Compress G/L SearchCompress G/LNormalCode10Compress G_Lnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress G_L]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress G_L] = [Source Code].[Code]
25Compress VAT Entries SearchCompress Tax EntriesNormalCode10Compress VAT Entriesnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress VAT Entries]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress VAT Entries] = [Source Code].[Code]
26Compress Cust. Ledger SearchCompress Cust. LedgerNormalCode10Compress Cust_ Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Cust_ Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Cust_ Ledger] = [Source Code].[Code]
27Compress Vend. Ledger SearchCompress Vend. LedgerNormalCode10Compress Vend_ Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Vend_ Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Vend_ Ledger] = [Source Code].[Code]
28Compress Item Ledger SearchCompress Item LedgerNormalCode10Compress Item Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Item Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Item Ledger] = [Source Code].[Code]
31Compress Res. Ledger SearchCompress Res. LedgerNormalCode10Compress Res_ Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Res_ Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Res_ Ledger] = [Source Code].[Code]
32Compress Job Ledger SearchCompress Job LedgerNormalCode10Compress Job Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Job Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Job Ledger] = [Source Code].[Code]
33Item Reclass. Journal SearchItem Reclass. JournalNormalCode10Item Reclass_ Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Item Reclass_ Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Item Reclass_ Journal] = [Source Code].[Code]
34Phys. Inventory Journal SearchPhys. Inventory JournalNormalCode10Phys_ Inventory Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Phys_ Inventory Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Phys_ Inventory Journal] = [Source Code].[Code]
35Compress Bank Acc. Ledger SearchCompress Bank Acc. LedgerNormalCode10Compress Bank Acc_ Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Bank Acc_ Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Bank Acc_ Ledger] = [Source Code].[Code]
36Compress Check Ledger SearchCompress Check LedgerNormalCode10Compress Check Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Check Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Check Ledger] = [Source Code].[Code]
37Financially Voided Check SearchFinancially Voided CheckNormalCode10Financially Voided Checknvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Financially Voided Check]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Financially Voided Check] = [Source Code].[Code]
38Finance Charge Memo SearchFinance Charge MemoNormalCode10Finance Charge Memonvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Finance Charge Memo]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Finance Charge Memo] = [Source Code].[Code]
39Reminder SearchReminderNormalCode10Remindernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Reminder]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Reminder] = [Source Code].[Code]
40Deleted Document SearchDeleted DocumentNormalCode10Deleted Documentnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Deleted Document]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Deleted Document] = [Source Code].[Code]
41Adjust Add. Reporting Currency SearchAdjust Add. Reporting CurrencyNormalCode10Adjust Add_ Reporting Currencynvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Adjust Add_ Reporting Currency]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Adjust Add_ Reporting Currency] = [Source Code].[Code]
42Trans. Bank Rec. to Gen. Jnl. SearchTrans. Bank Rec. to Gen. Jnl.NormalCode10Trans_ Bank Rec_ to Gen_ Jnl_nvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Trans_ Bank Rec_ to Gen_ Jnl_]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Trans_ Bank Rec_ to Gen_ Jnl_] = [Source Code].[Code]
43IC General Journal SearchIC General JournalNormalCode10IC General Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[IC General Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[IC General Journal] = [Source Code].[Code]
44Unapplied Empl. Entry Appln. SearchUnapplied Empl. Entry Appln.NormalCode10Unapplied Empl_ Entry Appln_nvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Unapplied Empl_ Entry Appln_]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Unapplied Empl_ Entry Appln_] = [Source Code].[Code]
45Unapplied Sales Entry Appln. SearchUnapplied Sales Entry Appln.NormalCode10Unapplied Sales Entry Appln_nvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Unapplied Sales Entry Appln_]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Unapplied Sales Entry Appln_] = [Source Code].[Code]
46Unapplied Purch. Entry Appln. SearchUnapplied Purch. Entry Appln.NormalCode10Unapplied Purch_ Entry Appln_nvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Unapplied Purch_ Entry Appln_]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Unapplied Purch_ Entry Appln_] = [Source Code].[Code]
47Reversal SearchReversalNormalCode10Reversalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Reversal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Reversal] = [Source Code].[Code]
48Employee Entry Application SearchEmployee Entry ApplicationNormalCode10Employee Entry Applicationnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Employee Entry Application]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Employee Entry Application] = [Source Code].[Code]
49Payment Reconciliation Journal SearchPayment Reconciliation JournalNormalCode10Payment Reconciliation Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Payment Reconciliation Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Payment Reconciliation Journal] = [Source Code].[Code]
840Cash Flow Worksheet SearchCash Flow WorksheetNormalCode10Cash Flow Worksheetnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Cash Flow Worksheet]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Cash Flow Worksheet] = [Source Code].[Code]
900Assembly SearchAssemblyNormalCode10Assemblynvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Assembly]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Assembly] = [Source Code].[Code]
1000Job G/L Journal SearchJob G/L JournalNormalCode10Job G_L Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Job G_L Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Job G_L Journal] = [Source Code].[Code]
1001Job G/L WIP SearchJob G/L WIPNormalCode10Job G_L WIPnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Job G_L WIP]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Job G_L WIP] = [Source Code].[Code]
1100G/L Entry to CA SearchG/L Entry to CANormalCode10G_L Entry to CAnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[G_L Entry to CA]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[G_L Entry to CA] = [Source Code].[Code]
1102Cost Journal SearchCost JournalNormalCode10Cost Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Cost Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Cost Journal] = [Source Code].[Code]
1104Cost Allocation SearchCost AllocationNormalCode10Cost Allocationnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Cost Allocation]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Cost Allocation] = [Source Code].[Code]
1105Transfer Budget to Actual SearchTransfer Budget to ActualNormalCode10Transfer Budget to Actualnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Transfer Budget to Actual]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Transfer Budget to Actual] = [Source Code].[Code]
1690Bank Deposit SearchBank DepositNormalCode10
1700General Deferral SearchGeneral DeferralNormalCode10General Deferralnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[General Deferral]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[General Deferral] = [Source Code].[Code]
1701Sales Deferral SearchSales DeferralNormalCode10Sales Deferralnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Sales Deferral]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Sales Deferral] = [Source Code].[Code]
1702Purchase Deferral SearchPurchase DeferralNormalCode10Purchase Deferralnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Purchase Deferral]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Purchase Deferral] = [Source Code].[Code]
2630Stat. Account Journal SearchStatistical Account JournalNormalCode10
5400Consumption Journal SearchConsumption JournalNormalCode10Consumption Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Consumption Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Consumption Journal] = [Source Code].[Code]
5402Output Journal SearchOutput JournalNormalCode10Output Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Output Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Output Journal] = [Source Code].[Code]
5403Flushing SearchFlushingNormalCode10Flushingnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Flushing]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Flushing] = [Source Code].[Code]
5404Capacity Journal SearchCapacity JournalNormalCode10Capacity Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Capacity Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Capacity Journal] = [Source Code].[Code]
5500Production Journal SearchProduction JournalNormalCode10Production Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Production Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Production Journal] = [Source Code].[Code]
5502Production Order SearchProduction OrderNormalCode10Production Ordernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Production Order]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Production Order] = [Source Code].[Code]
5600Fixed Asset Journal SearchFixed Asset JournalNormalCode10Fixed Asset Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Fixed Asset Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Fixed Asset Journal] = [Source Code].[Code]
5601Fixed Asset G/L Journal SearchFixed Asset G/L JournalNormalCode10Fixed Asset G_L Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Fixed Asset G_L Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Fixed Asset G_L Journal] = [Source Code].[Code]
5602Insurance Journal SearchInsurance JournalNormalCode10Insurance Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Insurance Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Insurance Journal] = [Source Code].[Code]
5603Compress FA Ledger SearchCompress FA LedgerNormalCode10Compress FA Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress FA Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress FA Ledger] = [Source Code].[Code]
5604Compress Maintenance Ledger SearchCompress Maintenance LedgerNormalCode10Compress Maintenance Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Maintenance Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Maintenance Ledger] = [Source Code].[Code]
5605Compress Insurance Ledger SearchCompress Insurance LedgerNormalCode10Compress Insurance Ledgernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Insurance Ledger]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Insurance Ledger] = [Source Code].[Code]
5700Transfer SearchTransferNormalCode10Transfernvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Transfer]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Transfer] = [Source Code].[Code]
5800Revaluation Journal SearchRevaluation JournalNormalCode10Revaluation Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Revaluation Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Revaluation Journal] = [Source Code].[Code]
5801Adjust Cost SearchAdjust CostNormalCode10Adjust Costnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Adjust Cost]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Adjust Cost] = [Source Code].[Code]
5850Invt. Receipt SearchItem Doc. ReceiptNormalCode10Invt_ Receiptnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Invt_ Receipt]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Invt_ Receipt] = [Source Code].[Code]
5851Invt. Shipment SearchItem Doc. ShipmentNormalCode10Invt_ Shipmentnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Invt_ Shipment]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Invt_ Shipment] = [Source Code].[Code]
5875Phys. Invt. Orders SearchPhys. Invt. OrdersNormalCode10Phys_ Invt_ Ordersnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Phys_ Invt_ Orders]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Phys_ Invt_ Orders] = [Source Code].[Code]
5900Service Management SearchService ManagementNormalCode10Service Managementnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Service Management]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Service Management] = [Source Code].[Code]
7139Compress Item Budget SearchCompress Item BudgetNormalCode10Compress Item Budgetnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Item Budget]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Item Budget] = [Source Code].[Code]
7300Whse. Item Journal SearchWhse. Item JournalNormalCode10Whse_ Item Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Whse_ Item Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Whse_ Item Journal] = [Source Code].[Code]
7302Whse. Phys. Invt. Journal SearchWhse. Phys. Invt. JournalNormalCode10Whse_ Phys_ Invt_ Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Whse_ Phys_ Invt_ Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Whse_ Phys_ Invt_ Journal] = [Source Code].[Code]
7303Whse. Reclassification Journal SearchWhse. Reclassification JournalNormalCode10Whse_ Reclassification Journalnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Whse_ Reclassification Journal]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Whse_ Reclassification Journal] = [Source Code].[Code]
7304Whse. Put-away SearchWhse. Put-awayNormalCode10Whse_ Put-awaynvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Whse_ Put-away]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Whse_ Put-away] = [Source Code].[Code]
7305Whse. Pick SearchWhse. PickNormalCode10Whse_ Picknvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Whse_ Pick]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Whse_ Pick] = [Source Code].[Code]
7306Whse. Movement SearchWhse. MovementNormalCode10Whse_ Movementnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Whse_ Movement]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Whse_ Movement] = [Source Code].[Code]
7307Compress Whse. Entries SearchCompress Whse. EntriesNormalCode10Compress Whse_ Entriesnvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Source Code Setup].[Compress Whse_ Entries]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Source Code Setup].[Compress Whse_ Entries] = [Source Code].[Code]
10002Bank Rec. Adjustment SearchBank Rec. AdjustmentNormalCode10
10003Deposits SearchDepositsNormalCode10
50050Statistical Account Journal SearchStatistical Account JournalNormalCode10
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Source Code Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Source Code Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Source Code Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Source Code Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Source Code Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesSSource Code Setup

Leave a Reply

Your email address will not be published. Required fields are marked *