Source 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
   [timestamp]
   ,[Primary Key]
   ,[Bank Deposit]
   ,[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]
   ,[Consumption Journal]
   ,[Output Journal]
   ,[Flushing]
   ,[Capacity Journal]
   ,[Production Journal]
   ,[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 columns in Source Code Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Bank Deposit Searchnvarchar(20)
3Sales Searchnvarchar(20)
4Purchases Searchnvarchar(20)
5Inventory Post Cost Searchnvarchar(20)
6Exchange Rate Adjmt_ Searchnvarchar(20)
7Post Recognition Searchnvarchar(20)
8Post Value Searchnvarchar(20)
9Close Income Statement Searchnvarchar(20)
10Consolidation Searchnvarchar(20)
11General Journal Searchnvarchar(20)
12Sales Journal Searchnvarchar(20)
13Purchase Journal Searchnvarchar(20)
14Cash Receipt Journal Searchnvarchar(20)
15Payment Journal Searchnvarchar(20)
16Item Journal Searchnvarchar(20)
17Resource Journal Searchnvarchar(20)
18Job Journal Searchnvarchar(20)
19Sales Entry Application Searchnvarchar(20)
20Purchase Entry Application Searchnvarchar(20)
21VAT Settlement Searchnvarchar(20)
22Compress G_L Searchnvarchar(20)
23Compress VAT Entries Searchnvarchar(20)
24Compress Cust_ Ledger Searchnvarchar(20)
25Compress Vend_ Ledger Searchnvarchar(20)
26Compress Item Ledger Searchnvarchar(20)
27Compress Res_ Ledger Searchnvarchar(20)
28Compress Job Ledger Searchnvarchar(20)
29Item Reclass_ Journal Searchnvarchar(20)
30Phys_ Inventory Journal Searchnvarchar(20)
31Compress Bank Acc_ Ledger Searchnvarchar(20)
32Compress Check Ledger Searchnvarchar(20)
33Financially Voided Check Searchnvarchar(20)
34Finance Charge Memo Searchnvarchar(20)
35Reminder Searchnvarchar(20)
36Deleted Document Searchnvarchar(20)
37Adjust Add_ Reporting Currency Searchnvarchar(20)
38Trans_ Bank Rec_ to Gen_ Jnl_ Searchnvarchar(20)
39IC General Journal Searchnvarchar(20)
40Unapplied Empl_ Entry Appln_ Searchnvarchar(20)
41Unapplied Sales Entry Appln_ Searchnvarchar(20)
42Unapplied Purch_ Entry Appln_ Searchnvarchar(20)
43Reversal Searchnvarchar(20)
44Employee Entry Application Searchnvarchar(20)
45Payment Reconciliation Journal Searchnvarchar(20)
46Cash Flow Worksheet Searchnvarchar(20)
47Assembly Searchnvarchar(20)
48Job G_L Journal Searchnvarchar(20)
49Job G_L WIP Searchnvarchar(20)
50G_L Entry to CA Searchnvarchar(20)
51Cost Journal Searchnvarchar(20)
52Cost Allocation Searchnvarchar(20)
53Transfer Budget to Actual Searchnvarchar(20)
54Consumption Journal Searchnvarchar(20)
55Output Journal Searchnvarchar(20)
56Flushing Searchnvarchar(20)
57Capacity Journal Searchnvarchar(20)
58Production Journal Searchnvarchar(20)
59Fixed Asset Journal Searchnvarchar(20)
60Fixed Asset G_L Journal Searchnvarchar(20)
61Insurance Journal Searchnvarchar(20)
62Compress FA Ledger Searchnvarchar(20)
63Compress Maintenance Ledger Searchnvarchar(20)
64Compress Insurance Ledger Searchnvarchar(20)
65Transfer Searchnvarchar(20)
66Revaluation Journal Searchnvarchar(20)
67Adjust Cost Searchnvarchar(20)
68Invt_ Receipt Searchnvarchar(20)
69Invt_ Shipment Searchnvarchar(20)
70Phys_ Invt_ Orders Searchnvarchar(20)
71Service Management Searchnvarchar(20)
72Compress Item Budget Searchnvarchar(20)
73Whse_ Item Journal Searchnvarchar(20)
74Whse_ Phys_ Invt_ Journal Searchnvarchar(20)
75Whse_ Reclassification Journal Searchnvarchar(20)
76Whse_ Put-away Searchnvarchar(20)
77Whse_ Pick Searchnvarchar(20)
78Whse_ Movement Searchnvarchar(20)
79Compress Whse_ Entries Searchnvarchar(20)
80$systemId Searchuniqueidentifier
81$systemCreatedAt Searchdatetime
82$systemCreatedBy Searchuniqueidentifier
83$systemModifiedAt Searchdatetime
84$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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