General Ledger Setup

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

Table Type: Company

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

Table Number: 98

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 General Ledger Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Allow Posting From]
   ,[Allow Posting To]
   ,[Register Time]
   ,[Allow Deferral Posting From]
   ,[Allow Deferral Posting To]
   ,[VAT Reporting Date]
   ,[VAT Reporting Date Usage]
   ,[Pmt_ Disc_ Excl_ VAT]
   ,[Unrealized VAT]
   ,[Adjust for Payment Disc_]
   ,[Post with Job Queue]
   ,[Job Queue Category Code]
   ,[Job Queue Priority for Post]
   ,[Post & Print with Job Queue]
   ,[Job Q_ Prio_ for Post & Print]
   ,[Notify On Success]
   ,[Mark Cr_ Memos as Corrections]
   ,[Local Address Format]
   ,[Inv_ Rounding Precision (LCY)]
   ,[Inv_ Rounding Type (LCY)]
   ,[Local Cont_ Addr_ Format]
   ,[Report Output Type]
   ,[Bank Account Nos_]
   ,[Summarize G_L Entries]
   ,[Amount Decimal Places]
   ,[Unit-Amount Decimal Places]
   ,[Additional Reporting Currency]
   ,[VAT Tolerance _]
   ,[EMU Currency]
   ,[LCY Code]
   ,[VAT Exchange Rate Adjustment]
   ,[Amount Rounding Precision]
   ,[Unit-Amount Rounding Precision]
   ,[Appln_ Rounding Precision]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Shortcut Dimension 3 Code]
   ,[Shortcut Dimension 4 Code]
   ,[Shortcut Dimension 5 Code]
   ,[Shortcut Dimension 6 Code]
   ,[Shortcut Dimension 7 Code]
   ,[Shortcut Dimension 8 Code]
   ,[Max_ VAT Difference Allowed]
   ,[VAT Rounding Type]
   ,[Pmt_ Disc_ Tolerance Posting]
   ,[Payment Discount Grace Period]
   ,[Payment Tolerance _]
   ,[Max_ Payment Tolerance Amount]
   ,[Adapt Main Menu to Permissions]
   ,[Allow G_L Acc_ Deletion Before]
   ,[Check G_L Account Usage]
   ,[Payment Tolerance Posting]
   ,[Pmt_ Disc_ Tolerance Warning]
   ,[Payment Tolerance Warning]
   ,[Last IC Transaction No_]
   ,[Bill-to_Sell-to VAT Calc_]
   ,[Block Deletion of G_L Accounts]
   ,[Acc_ Sched_ for Balance Sheet]
   ,[Acc_ Sched_ for Income Stmt_]
   ,[Acc_ Sched_ for Cash Flow Stmt]
   ,[Acc_ Sched_ for Retained Earn_]
   ,[Fin_ Rep_ for Balance Sheet]
   ,[Fin_ Rep_ for Income Stmt_]
   ,[Fin_ Rep_ for Cash Flow Stmt]
   ,[Fin_ Rep_ for Retained Earn_]
   ,[Tax Invoice Renaming Threshold]
   ,[Req_Country_Reg_ Code in Addr_]
   ,[Print VAT specification in LCY]
   ,[Prepayment Unrealized VAT]
   ,[Use Legacy G_L Entry Locking]
   ,[Payroll Trans_ Import Format]
   ,[VAT Reg_ No_ Validation URL]
   ,[Local Currency Symbol]
   ,[Local Currency Description]
   ,[Show Amounts]
   ,[Posting Preview Type]
   ,[SEPA Non-Euro Export]
   ,[SEPA Export w_o Bank Acc_ Data]
   ,[Journal Templ_ Name Mandatory]
   ,[Hide Payment Method Code]
   ,[Enable Data Check]
   ,[Apply Jnl_ Template Name]
   ,[Apply Jnl_ Batch Name]
   ,[Job WIP Jnl_ Template Name]
   ,[Job WIP Jnl_ Batch Name]
   ,[Adjust ARC Jnl_ Template Name]
   ,[Adjust ARC Jnl_ Batch Name]
   ,[Bank Acc_ Recon_ Template Name]
   ,[Bank Acc_ Recon_ Batch Name]
   ,[Control VAT Period]
   ,[Allow Query From Consolid_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$General Ledger 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_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
      ON
         [General Ledger Setup].[Job Queue Category Code] = [Job Queue Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [General Ledger Setup].[Additional Reporting Currency] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [General Ledger Setup].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [General Ledger Setup].[USD Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [General Ledger Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [General Ledger Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in General Ledger Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Allow Posting From SearchAllow Posting FromNormalDate4Allow Posting Fromdatetime
3Allow Posting To SearchAllow Posting ToNormalDate4Allow Posting Todatetime
4Register Time SearchRegister TimeNormalBoolean4Register Timetinyint
5Allow Deferral Posting From SearchAllow Deferral Posting FromNormalDate4Allow Deferral Posting Fromdatetime
6Allow Deferral Posting To SearchAllow Deferral Posting ToNormalDate4Allow Deferral Posting Todatetime
7VAT Reporting Date SearchDefault Tax DateNormalOption4VAT Reporting Dateint
Available options are:
  • “Posting Date”
  • “Document Date”
8VAT Reporting Date Usage SearchTax Date UsageNormalOption4VAT Reporting Date Usageint
Available options are:
  • “Enabled”
  • “Enabled (Prevent modification)”
  • “Disabled”
28Pmt. Disc. Excl. VAT SearchPmt. Disc. Excl. TaxNormalBoolean4Pmt_ Disc_ Excl_ VATtinyint
41Date Filter SearchDate FilterFlowFilterDate4
42Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
43Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
44Cust. Balances Due SearchCust. Balances DueFlowFieldDecimal12
45Vendor Balances Due SearchVendor Balances DueFlowFieldDecimal12
48Unrealized VAT SearchUnrealized TaxNormalBoolean4Unrealized VATtinyint
49Adjust for Payment Disc. SearchAdjust for Payment Disc.NormalBoolean4Adjust for Payment Disc_tinyint
50Post with Job Queue SearchPost with Job QueueNormalBoolean4Post with Job Queuetinyint
51Job Queue Category Code SearchJob Queue Category CodeNormalCode10Job Queue Category Codenvarchar(20)
Key to join to the Job Queue Category table.

Show/hide example query

SELECT
       [General Ledger Setup].[Job Queue Category Code]
       ,[Job Queue Category].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
              ON
                     [General Ledger Setup].[Job Queue Category Code] = [Job Queue Category].[Code]
52Job Queue Priority for Post SearchJob Queue Priority for PostNormalInteger4Job Queue Priority for Postint
53Post & Print with Job Queue SearchPost & Print with Job QueueNormalBoolean4Post & Print with Job Queuetinyint
54Job Q. Prio. for Post & Print SearchJob Q. Prio. for Post & PrintNormalInteger4Job Q_ Prio_ for Post & Printint
55Notify On Success SearchNotify On SuccessNormalBoolean4Notify On Successtinyint
56Mark Cr. Memos as Corrections SearchMark Cr. Memos as CorrectionsNormalBoolean4Mark Cr_ Memos as Correctionstinyint
57Local Address Format SearchLocal Address FormatNormalOption4Local Address Formatint
Available options are:
  • “Post Code+City”
  • “City+Post Code”
  • “City+County+Post Code”
  • “Blank Line+Post Code+CityCity+County+New Line+Post Code”
  • “Post Code+City+CountyCustom”
58Inv. Rounding Precision (LCY) SearchInv. Rounding Precision ($)NormalDecimal12Inv_ Rounding Precision (LCY)decimal(38,38)
59Inv. Rounding Type (LCY) SearchInv. Rounding Type ($)NormalOption4Inv_ Rounding Type (LCY)int
Available options are:
  • “Nearest”
  • “Up”
  • “Down”
60Local Cont. Addr. Format SearchLocal Cont. Addr. FormatNormalOption4Local Cont_ Addr_ Formatint
Available options are:
  • “First”
  • “After Company Name”
  • “Last”
61Report Output Type SearchReport Output TypeNormalOption4Report Output Typeint
Available options are:
  • “PDF”
  • “Print”
63Bank Account Nos. SearchBank Account Nos.NormalCode20Bank Account Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [General Ledger Setup].[Bank Account Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [General Ledger Setup].[Bank Account Nos_] = [No. Series].[Code]
65Summarize G/L Entries SearchSummarize G/L EntriesNormalBoolean4Summarize G_L Entriestinyint
66Amount Decimal Places SearchAmount Decimal PlacesNormalText5Amount Decimal Placesnvarchar(10)
67Unit-Amount Decimal Places SearchUnit-Amount Decimal PlacesNormalText5Unit-Amount Decimal Placesnvarchar(10)
68Additional Reporting Currency SearchAdditional Reporting CurrencyNormalCode10Additional Reporting Currencynvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [General Ledger Setup].[Additional Reporting Currency]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [General Ledger Setup].[Additional Reporting Currency] = [Currency].[Code]
69VAT Tolerance % SearchTax Tolerance %NormalDecimal12VAT Tolerance _decimal(38,38)
70EMU Currency SearchEMU CurrencyNormalBoolean4EMU Currencytinyint
71LCY Code SearchLCY CodeNormalCode10LCY Codenvarchar(20)
72VAT Exchange Rate Adjustment SearchTax Exchange Rate AdjustmentNormalOption4VAT Exchange Rate Adjustmentint
Available options are:
  • “No Adjustment”
  • “Adjust Amount”
  • “Adjust Additional-Currency Amount”
73Amount Rounding Precision SearchAmount Rounding PrecisionNormalDecimal12Amount Rounding Precisiondecimal(38,38)
74Unit-Amount Rounding Precision SearchUnit-Amount Rounding PrecisionNormalDecimal12Unit-Amount Rounding Precisiondecimal(38,38)
75Appln. Rounding Precision SearchAppln. Rounding PrecisionNormalDecimal12Appln_ Rounding Precisiondecimal(38,38)
79Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Global Dimension 1 Code] = [Dimension].[Code]
80Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Global Dimension 2 Code] = [Dimension].[Code]
81Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 1 Code] = [Dimension].[Code]
82Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 2 Code] = [Dimension].[Code]
83Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeNormalCode20Shortcut Dimension 3 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 3 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 3 Code] = [Dimension].[Code]
84Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeNormalCode20Shortcut Dimension 4 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 4 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 4 Code] = [Dimension].[Code]
85Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeNormalCode20Shortcut Dimension 5 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 5 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 5 Code] = [Dimension].[Code]
86Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeNormalCode20Shortcut Dimension 6 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 6 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 6 Code] = [Dimension].[Code]
87Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeNormalCode20Shortcut Dimension 7 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 7 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 7 Code] = [Dimension].[Code]
88Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeNormalCode20Shortcut Dimension 8 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [General Ledger Setup].[Shortcut Dimension 8 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [General Ledger Setup].[Shortcut Dimension 8 Code] = [Dimension].[Code]
89Max. VAT Difference Allowed SearchMax. Tax Difference AllowedNormalDecimal12Max_ VAT Difference Alloweddecimal(38,38)
90VAT Rounding Type SearchTax Rounding TypeNormalOption4VAT Rounding Typeint
Available options are:
  • “Nearest”
  • “Up”
  • “Down”
92Pmt. Disc. Tolerance Posting SearchPmt. Disc. Tolerance PostingNormalOption4Pmt_ Disc_ Tolerance Postingint
Available options are:
  • “Payment Tolerance Accounts”
  • “Payment Discount Accounts”
93Payment Discount Grace Period SearchPayment Discount Grace PeriodNormalDateFormula32Payment Discount Grace Periodvarchar(32)
94Payment Tolerance % SearchPayment Tolerance %NormalDecimal12Payment Tolerance _decimal(38,38)
95Max. Payment Tolerance Amount SearchMax. Payment Tolerance AmountNormalDecimal12Max_ Payment Tolerance Amountdecimal(38,38)
96Adapt Main Menu to Permissions SearchAdapt Main Menu to PermissionsNormalBoolean4Adapt Main Menu to Permissionstinyint
97Allow G/L Acc. Deletion Before SearchCheck G/L Acc. Deletion AfterNormalDate4Allow G_L Acc_ Deletion Beforedatetime
98Check G/L Account Usage SearchCheck G/L Account UsageNormalBoolean4Check G_L Account Usagetinyint
99Payment Tolerance Posting SearchPayment Tolerance PostingNormalOption4Payment Tolerance Postingint
Available options are:
  • “Payment Tolerance Accounts”
  • “Payment Discount Accounts”
100Pmt. Disc. Tolerance Warning SearchPmt. Disc. Tolerance WarningNormalBoolean4Pmt_ Disc_ Tolerance Warningtinyint
101Payment Tolerance Warning SearchPayment Tolerance WarningNormalBoolean4Payment Tolerance Warningtinyint
102Last IC Transaction No. SearchLast IC Transaction No.NormalInteger4Last IC Transaction No_int
103Bill-to/Sell-to VAT Calc. SearchBill-to/Sell-to VAT Calc.NormalOption4Bill-to_Sell-to VAT Calc_int
Available options are:
  • “Bill-to/Pay-to No.”
  • “Sell-to/Buy-from No.”
104Block Deletion of G/L Accounts SearchBlock Deletion of G/L AccountsNormalBoolean4Block Deletion of G_L Accountstinyint
110Acc. Sched. for Balance Sheet SearchAccount Schedule for Balance SheetNormalCode10Acc_ Sched_ for Balance Sheetnvarchar(20)
Key to join to the Acc. Schedule Name table.

Show/hide example query

SELECT
       [General Ledger Setup].[Acc_ Sched_ for Balance Sheet]
       ,[Acc. Schedule Name].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name]
              ON
                     [General Ledger Setup].[Acc_ Sched_ for Balance Sheet] = [Acc. Schedule Name].[Name]
111Acc. Sched. for Income Stmt. SearchAccount Schedule for Income Stmt.NormalCode10Acc_ Sched_ for Income Stmt_nvarchar(20)
Key to join to the Acc. Schedule Name table.

Show/hide example query

SELECT
       [General Ledger Setup].[Acc_ Sched_ for Income Stmt_]
       ,[Acc. Schedule Name].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name]
              ON
                     [General Ledger Setup].[Acc_ Sched_ for Income Stmt_] = [Acc. Schedule Name].[Name]
112Acc. Sched. for Cash Flow Stmt SearchAccount Schedule for Cash Flow StmtNormalCode10Acc_ Sched_ for Cash Flow Stmtnvarchar(20)
Key to join to the Acc. Schedule Name table.

Show/hide example query

SELECT
       [General Ledger Setup].[Acc_ Sched_ for Cash Flow Stmt]
       ,[Acc. Schedule Name].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name]
              ON
                     [General Ledger Setup].[Acc_ Sched_ for Cash Flow Stmt] = [Acc. Schedule Name].[Name]
113Acc. Sched. for Retained Earn. SearchAccount Schedule for Retained Earn.NormalCode10Acc_ Sched_ for Retained Earn_nvarchar(20)
Key to join to the Acc. Schedule Name table.

Show/hide example query

SELECT
       [General Ledger Setup].[Acc_ Sched_ for Retained Earn_]
       ,[Acc. Schedule Name].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name]
              ON
                     [General Ledger Setup].[Acc_ Sched_ for Retained Earn_] = [Acc. Schedule Name].[Name]
114Fin. Rep. for Balance Sheet SearchFinancial Report for Balance SheetNormalCode10Fin_ Rep_ for Balance Sheetnvarchar(20)
115Fin. Rep. for Income Stmt. SearchFinancial Report for Income Stmt.NormalCode10Fin_ Rep_ for Income Stmt_nvarchar(20)
116Fin. Rep. for Cash Flow Stmt SearchFinancial Report for Cash Flow StmtNormalCode10Fin_ Rep_ for Cash Flow Stmtnvarchar(20)
117Fin. Rep. for Retained Earn. SearchFinancial Report for Retained Earn.NormalCode10Fin_ Rep_ for Retained Earn_nvarchar(20)
120Tax Invoice Renaming Threshold SearchTax Invoice Renaming ThresholdNormalDecimal12Tax Invoice Renaming Thresholddecimal(38,38)
130Req.Country/Reg. Code in Addr. SearchRequire Country/Region Code in AddressNormalBoolean4Req_Country_Reg_ Code in Addr_tinyint
150Print VAT specification in LCY SearchPrint tax specification in $NormalBoolean4Print VAT specification in LCYtinyint
151Prepayment Unrealized VAT SearchPrepayment Unrealized TaxNormalBoolean4Prepayment Unrealized VATtinyint
152Use Legacy G/L Entry Locking SearchUse Legacy G/L Entry LockingNormalBoolean4Use Legacy G_L Entry Lockingtinyint
160Payroll Trans. Import Format SearchPayroll Trans. Import FormatNormalCode20Payroll Trans_ Import Formatnvarchar(40)
161VAT Reg. No. Validation URL SearchVAT Reg. No. Validation URLNormalText250VAT Reg_ No_ Validation URLnvarchar(500)
162Local Currency Symbol SearchLocal Currency SymbolNormalText10Local Currency Symbolnvarchar(20)
163Local Currency Description SearchLocal Currency DescriptionNormalText60Local Currency Descriptionnvarchar(120)
164Show Amounts SearchShow AmountsNormalOption4Show Amountsint
Available options are:
  • “Amount Only”
  • “Debit/Credit Only”
  • “All Amounts”
169Posting Preview Type SearchPosting Preview TypeNormalOption4Posting Preview Typeint
Available options are:
  • “Standard”
  • “Extended”
170SEPA Non-Euro Export SearchSEPA Non-Euro ExportNormalBoolean4SEPA Non-Euro Exporttinyint
171SEPA Export w/o Bank Acc. Data SearchSEPA Export w/o Bank Acc. DataNormalBoolean4SEPA Export w_o Bank Acc_ Datatinyint
175Journal Templ. Name Mandatory SearchJournal Templ. Name MandatoryNormalBoolean4Journal Templ_ Name Mandatorytinyint
176Hide Payment Method Code SearchHide Payment Method CodeNormalBoolean4Hide Payment Method Codetinyint
177Enable Data Check SearchEnable Data CheckNormalBoolean4Enable Data Checktinyint
180Apply Jnl. Template Name SearchApply Jnl. Template NameNormalCode10Apply Jnl_ Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
       [General Ledger Setup].[Apply Jnl_ Template Name]
       ,[Gen. Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
              ON
                     [General Ledger Setup].[Apply Jnl_ Template Name] = [Gen. Journal Template].[Name]
181Apply Jnl. Batch Name SearchApply Jnl. Batch NameNormalCode10Apply Jnl_ Batch Namenvarchar(20)
182Job WIP Jnl. Template Name SearchJob WIP Jnl. Template NameNormalCode10Job WIP Jnl_ Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
       [General Ledger Setup].[Job WIP Jnl_ Template Name]
       ,[Gen. Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
              ON
                     [General Ledger Setup].[Job WIP Jnl_ Template Name] = [Gen. Journal Template].[Name]
183Job WIP Jnl. Batch Name SearchJob WIP Jnl. Batch NameNormalCode10Job WIP Jnl_ Batch Namenvarchar(20)
184Adjust ARC Jnl. Template Name SearchAdjust Add. Rep. Currency Jnl. Template NameNormalCode10Adjust ARC Jnl_ Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
       [General Ledger Setup].[Adjust ARC Jnl_ Template Name]
       ,[Gen. Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
              ON
                     [General Ledger Setup].[Adjust ARC Jnl_ Template Name] = [Gen. Journal Template].[Name]
185Adjust ARC Jnl. Batch Name SearchAdjust Add. Rep. Currency Jnl. Batch NameNormalCode10Adjust ARC Jnl_ Batch Namenvarchar(20)
186Bank Acc. Recon. Template Name SearchBank Acc. Recon. Template NameNormalCode10Bank Acc_ Recon_ Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
       [General Ledger Setup].[Bank Acc_ Recon_ Template Name]
       ,[Gen. Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
              ON
                     [General Ledger Setup].[Bank Acc_ Recon_ Template Name] = [Gen. Journal Template].[Name]
187Bank Acc. Recon. Batch Name SearchBank Acc. Recon. Batch NameNormalCode10Bank Acc_ Recon_ Batch Namenvarchar(20)
188Control VAT Period SearchControl Tax PeriodNormalOption4Control VAT Periodint
Available options are:
  • “Block posting within closed and warn for released period”
  • “Block posting within closed period”
  • “Warn when posting in closed period”
  • “Disabled”
189Allow Query From Consolid. SearchEnable company as subsidiaryNormalBoolean4Allow Query From Consolid_tinyint
10001VAT in Use SearchVAT in UseNormalBoolean4
10002Bank Rec. Adj. Doc. Nos. SearchBank Rec. Adj. Doc. Nos.NormalCode20
10003Deposit Nos. SearchDeposit Nos.NormalCode20
10004SAT Certificate Thumbprint SearchSAT Certificate ThumbprintNormalText250
10005Send PDF Report SearchSend PDF ReportNormalBoolean4
10006Hash Algorithm SearchHash AlgorithmNormalOption4
10007PAC Code SearchPAC CodeNormalCode10
10008PAC Environment SearchPAC EnvironmentNormalOption4
10009CFDI Enabled SearchEnabledNormalBoolean4
10010Sim. Signature SearchSim. SignatureNormalBoolean4
10011Sim. Send SearchSim. SendNormalBoolean4
10012Sim. Request Stamp SearchSim. Request StampNormalBoolean4
10120Bank Recon. with Auto. Match SearchBank Recon. with Auto. MatchNormalBoolean4
10121SAT Certificate SearchSAT CertificateNormalCode20
10122Disable CFDI Payment Details SearchDisable CFDI Payment DetailsNormalBoolean4
10123USD Currency Code SearchUSD Currency CodeNormalCode10
10124Cancel on Time Expiration SearchCancel on Time ExpirationNormalBoolean4
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
       [General Ledger Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [General Ledger 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
       [General Ledger Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$General Ledger Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [General Ledger Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [General Ledger Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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