Gen. Journal Line

Dynamics 365 BC Table ReferenceTablesCompany TablesGGen. Journal Line

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

Table Type: Company

Table Name: Gen. Journal Line
Database Table Name: CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 81

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 Gen. Journal Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Journal Template Name]
   ,[Line No_]
   ,[Account Type]
   ,[Account No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[VAT _]
   ,[Bal_ Account No_]
   ,[Currency Code]
   ,[Amount]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Amount (LCY)]
   ,[Balance (LCY)]
   ,[Currency Factor]
   ,[Sales_Purch_ (LCY)]
   ,[Profit (LCY)]
   ,[Inv_ Discount (LCY)]
   ,[Bill-to_Pay-to No_]
   ,[Posting Group]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Salespers__Purch_ Code]
   ,[Pending Approval]
   ,[Source Code]
   ,[Your Reference]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Due Date]
   ,[Pmt_ Discount Date]
   ,[Payment Discount _]
   ,[Job No_]
   ,[Quantity]
   ,[VAT Amount]
   ,[VAT Posting]
   ,[Payment Terms Code]
   ,[Applies-to ID]
   ,[Business Unit Code]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Recurring Method]
   ,[Expiration Date]
   ,[Recurring Frequency]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[EU 3-Party Trade]
   ,[Allow Application]
   ,[Bal_ Account Type]
   ,[Bal_ Gen_ Posting Type]
   ,[Bal_ Gen_ Bus_ Posting Group]
   ,[Bal_ Gen_ Prod_ Posting Group]
   ,[Bal_ VAT Calculation Type]
   ,[Bal_ VAT _]
   ,[Bal_ VAT Amount]
   ,[Bank Payment Type]
   ,[VAT Base Amount]
   ,[Bal_ VAT Base Amount]
   ,[Correction]
   ,[Print Posted Documents]
   ,[Check Printed]
   ,[Document Date]
   ,[External Document No_]
   ,[Source Type]
   ,[Source No_]
   ,[Posting No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[Bal_ Tax Area Code]
   ,[Bal_ Tax Liable]
   ,[Bal_ Tax Group Code]
   ,[Bal_ Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Bal_ VAT Bus_ Posting Group]
   ,[Bal_ VAT Prod_ Posting Group]
   ,[Additional-Currency Posting]
   ,[FA Add_-Currency Factor]
   ,[Source Currency Code]
   ,[Source Currency Amount]
   ,[Source Curr_ VAT Base Amount]
   ,[Source Curr_ VAT Amount]
   ,[VAT Base Discount _]
   ,[VAT Amount (LCY)]
   ,[VAT Base Amount (LCY)]
   ,[Bal_ VAT Amount (LCY)]
   ,[Bal_ VAT Base Amount (LCY)]
   ,[Reversing Entry]
   ,[Allow Zero-Amount Posting]
   ,[Ship-to_Order Address Code]
   ,[VAT Difference]
   ,[Bal_ VAT Difference]
   ,[IC Partner Code]
   ,[IC Direction]
   ,[IC Partner G_L Acc_ No_]
   ,[IC Partner Transaction No_]
   ,[Sell-to_Buy-from No_]
   ,[VAT Registration No_]
   ,[Country_Region Code]
   ,[Prepayment]
   ,[Financial Void]
   ,[Copy VAT Setup to Jnl_ Lines]
   ,[VAT Base Before Pmt_ Disc_]
   ,[Orig_ Pmt_ Disc_ Possible]
   ,[Orig_ Pmt_ Disc_ Possible(LCY)]
   ,[VAT Reporting Date]
   ,[IC Account Type]
   ,[IC Account No_]
   ,[Job Queue Status]
   ,[Job Queue Entry ID]
   ,[Incoming Document Entry No_]
   ,[Creditor No_]
   ,[Payment Reference]
   ,[Payment Method Code]
   ,[Applies-to Ext_ Doc_ No_]
   ,[Invoice Received Date]
   ,[Keep Description]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[Credit Card No_]
   ,[Remit-to Code]
   ,[Job Task No_]
   ,[Job Unit Price (LCY)]
   ,[Job Total Price (LCY)]
   ,[Job Quantity]
   ,[Job Unit Cost (LCY)]
   ,[Job Line Discount _]
   ,[Job Line Disc_ Amount (LCY)]
   ,[Job Unit Of Measure Code]
   ,[Job Line Type]
   ,[Job Unit Price]
   ,[Job Total Price]
   ,[Job Unit Cost]
   ,[Job Total Cost]
   ,[Job Line Discount Amount]
   ,[Job Line Amount]
   ,[Job Total Cost (LCY)]
   ,[Job Line Amount (LCY)]
   ,[Job Currency Factor]
   ,[Job Currency Code]
   ,[Job Planning Line No_]
   ,[Job Remaining Qty_]
   ,[Direct Debit Mandate ID]
   ,[Data Exch_ Entry No_]
   ,[Payer Information]
   ,[Transaction Information]
   ,[Data Exch_ Line No_]
   ,[Applied Automatically]
   ,[Linked Table ID]
   ,[Deferral Code]
   ,[Deferral Line No_]
   ,[Selected Alloc_ Account No_]
   ,[Allocation Account No_]
   ,[Campaign No_]
   ,[Prod_ Order No_]
   ,[FA Posting Date]
   ,[FA Posting Type]
   ,[Depreciation Book Code]
   ,[Salvage Value]
   ,[No_ of Depreciation Days]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[Maintenance Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[FA Reclassification Entry]
   ,[FA Error Entry No_]
   ,[Index Entry]
   ,[Source Line No_]
   ,[Comment]
   ,[Check Exported]
   ,[Check Transmitted]
   ,[Reverse Date Calculation]
   ,[Non-Deductible VAT _]
   ,[Non-Deductible VAT Base]
   ,[Non-Deductible VAT Amount]
   ,[Non-Deductible VAT Base LCY]
   ,[Non-Deductible VAT Amount LCY]
   ,[Non-Deductible VAT Base ACY]
   ,[Non-Deductible VAT Amount ACY]
   ,[FA G_L Account No_]
   ,[Non-Deductible VAT Diff_]
   ,[Bal_ Non-Ded_ VAT _]
   ,[Bal_ Non-Ded_ VAT Base]
   ,[Bal_ Non-Ded_ VAT Amount]
   ,[Bal_ Non-Ded_ VAT Base LCY]
   ,[Bal_ Non-Ded_ VAT Amount LCY]
   ,[Id]
   ,[Account Id]
   ,[Customer Id]
   ,[Applies-to Invoice Id]
   ,[Contact Graph Id]
   ,[Last Modified DateTime]
   ,[Journal Batch Id]
   ,[Payment Method Id]
   ,[Balance Account Id]
   ,[Vendor Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Gen. Journal Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Gen. Journal Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Gen. Journal Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Gen. Journal Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Gen. Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Gen. Journal Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Gen. Journal Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Gen. Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Gen. Journal Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Gen. Journal Line].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [Gen. Journal Line].[Business Unit Code] = [Business Unit].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Gen. Journal Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Gen. Journal Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Gen. Journal Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Gen. Journal Line].[Source Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Gen. Journal Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Gen. Journal Line].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Gen. Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Gen. Journal Line].[Job Unit Of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Gen. Journal Line].[Deferral Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Gen. Journal Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
      ON
         [Gen. Journal Line].[Maintenance Code] = [Maintenance].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Gen. Journal Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Gen. Journal Line].[Account Id] = [G/L Account].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Gen. Journal Line].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header]
      ON
         [Gen. Journal Line].[Applies-to Invoice Id] = [Sales Invoice Header].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
      ON
         [Gen. Journal Line].[Journal Batch Id] = [Gen. Journal Batch].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Gen. Journal Line].[Payment Method Id] = [Payment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Gen. Journal Line].[Balance Account Id] = [G/L Account].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Gen. Journal Line].[Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
      ON
         [Gen. Journal Line].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Gen. Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Gen. Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Gen. Journal Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name Primary Key SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Account Type SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
4Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Gen. Journal Line].[Account No_] = [G/L Account].[No_]
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
11Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
12Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Gen. Journal Line].[Currency Code] = [Currency].[Code]
13Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
14Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
15Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
16Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
17Balance (LCY) SearchBalance ($)NormalDecimal12Balance (LCY)decimal(38,38)
18Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
19Sales/Purch. (LCY) SearchSales/Purch. ($)NormalDecimal12Sales_Purch_ (LCY)decimal(38,38)
20Profit (LCY) SearchProfit ($)NormalDecimal12Profit (LCY)decimal(38,38)
21Inv. Discount (LCY) SearchInv. Discount ($)NormalDecimal12Inv_ Discount (LCY)decimal(38,38)
22Bill-to/Pay-to No. SearchBill-to/Pay-to No.NormalCode20Bill-to_Pay-to No_nvarchar(40)
23Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Gen. Journal Line].[Posting Group] = [Customer Posting Group].[Code]
24Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Gen. Journal Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Gen. Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
26Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Gen. Journal Line].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
28Pending Approval SearchPending ApprovalNormalBoolean4Pending Approvaltinyint
29Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Gen. Journal Line].[Source Code] = [Source Code].[Code]
30System-Created Entry SearchSystem-Created EntryNormalBoolean4
31Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
34On Hold SearchOn HoldNormalCode3On Holdnvarchar(6)
35Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
36Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
38Due Date SearchDue DateNormalDate4Due Datedatetime
39Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
40Payment Discount % SearchPayment Discount %NormalDecimal12Payment Discount _decimal(38,38)
42Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Gen. Journal Line].[Job No_] = [Job].[No_]
43Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
44VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
45VAT Posting SearchTax PostingNormalOption4VAT Postingint
Available options are:
  • “Automatic VAT Entry”
  • “Manual VAT Entry”
47Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Gen. Journal Line].[Payment Terms Code] = [Payment Terms].[Code]
48Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
50Business Unit Code SearchBusiness Unit CodeNormalCode20Business Unit Codenvarchar(40)
Key to join to the Business Unit table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Business Unit Code]
       ,[Business Unit].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
              ON
                     [Gen. Journal Line].[Business Unit Code] = [Business Unit].[Code]
51Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
52Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Gen. Journal Line].[Reason Code] = [Reason Code].[Code]
53Recurring Method SearchRecurring MethodNormalOption4Recurring Methodint
Available options are:
  • ” “
  • “F Fixed”
  • “V Variable”
  • “B Balance”
  • “RF Reversing Fixed”
  • “RV Reversing Variable”
  • “RB Reversing Balance”
  • “BD Balance by Dimension”
  • “RBD Reversing Balance by Dimension”
54Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
55Recurring Frequency SearchRecurring FrequencyNormalDateFormula32Recurring Frequencyvarchar(32)
56Allocated Amt. (LCY) SearchAllocated Amt. ($)FlowFieldDecimal12
57Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
58Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Gen. Journal Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
59Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Gen. Journal Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
60VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
61EU 3-Party Trade SearchEU 3-Party TradeNormalBoolean4EU 3-Party Tradetinyint
62Allow Application SearchAllow ApplicationNormalBoolean4Allow Applicationtinyint
63Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
64Bal. Gen. Posting Type SearchBal. Gen. Posting TypeNormalOption4Bal_ Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
65Bal. Gen. Bus. Posting Group SearchBal. Gen. Bus. Posting GroupNormalCode20Bal_ Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Bal_ Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Gen. Journal Line].[Bal_ Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
66Bal. Gen. Prod. Posting Group SearchBal. Gen. Prod. Posting GroupNormalCode20Bal_ Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Bal_ Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Gen. Journal Line].[Bal_ Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
67Bal. VAT Calculation Type SearchBal. VAT Calculation TypeNormalOption4Bal_ VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
68Bal. VAT % SearchBal. Tax %NormalDecimal12Bal_ VAT _decimal(38,38)
69Bal. VAT Amount SearchBal. Tax AmountNormalDecimal12Bal_ VAT Amountdecimal(38,38)
70Bank Payment Type SearchBank Payment TypeNormalOption4Bank Payment Typeint
Available options are:
  • ” “
  • “Computer Check”
  • “Manual Check”
  • “Electronic Payment”
  • “Electronic Payment-IAT”
71VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
72Bal. VAT Base Amount SearchBal. Tax Base AmountNormalDecimal12Bal_ VAT Base Amountdecimal(38,38)
73Correction SearchCorrectionNormalBoolean4Correctiontinyint
74Print Posted Documents SearchPrint Posted DocumentsNormalBoolean4Print Posted Documentstinyint
75Check Printed SearchCheck PrintedNormalBoolean4Check Printedtinyint
76Document Date SearchDocument DateNormalDate4Document Datedatetime
77External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
78Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
79Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
80Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Gen. Journal Line].[Posting No_ Series] = [No. Series].[Code]
82Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Gen. Journal Line].[Tax Area Code] = [Tax Area].[Code]
83Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
84Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Gen. Journal Line].[Tax Group Code] = [Tax Group].[Code]
85Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
86Bal. Tax Area Code SearchBal. Tax Area CodeNormalCode20Bal_ Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Bal_ Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Gen. Journal Line].[Bal_ Tax Area Code] = [Tax Area].[Code]
87Bal. Tax Liable SearchBal. Tax LiableNormalBoolean4Bal_ Tax Liabletinyint
88Bal. Tax Group Code SearchBal. Tax Group CodeNormalCode20Bal_ Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Bal_ Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Gen. Journal Line].[Bal_ Tax Group Code] = [Tax Group].[Code]
89Bal. Use Tax SearchBal. Use TaxNormalBoolean4Bal_ Use Taxtinyint
90VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Gen. Journal Line].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
91VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Gen. Journal Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
92Bal. VAT Bus. Posting Group SearchBal. VAT Bus. Posting GroupNormalCode20Bal_ VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Bal_ VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Gen. Journal Line].[Bal_ VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
93Bal. VAT Prod. Posting Group SearchBal. VAT Prod. Posting GroupNormalCode20Bal_ VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Bal_ VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Gen. Journal Line].[Bal_ VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
95Additional-Currency Posting SearchAdditional-Currency PostingNormalOption4Additional-Currency Postingint
Available options are:
  • “None”
  • “Amount Only”
  • “Additional-Currency Amount Only”
98FA Add.-Currency Factor SearchFA Add.-Currency FactorNormalDecimal12FA Add_-Currency Factordecimal(38,38)
99Source Currency Code SearchSource Currency CodeNormalCode10Source Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Source Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Gen. Journal Line].[Source Currency Code] = [Currency].[Code]
100Source Currency Amount SearchSource Currency AmountNormalDecimal12Source Currency Amountdecimal(38,38)
101Source Curr. VAT Base Amount SearchSource Curr. Tax Base AmountNormalDecimal12Source Curr_ VAT Base Amountdecimal(38,38)
102Source Curr. VAT Amount SearchSource Curr. Tax AmountNormalDecimal12Source Curr_ VAT Amountdecimal(38,38)
103VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
104VAT Amount (LCY) SearchTax Amount ($)NormalDecimal12VAT Amount (LCY)decimal(38,38)
105VAT Base Amount (LCY) SearchTax Base Amount ($)NormalDecimal12VAT Base Amount (LCY)decimal(38,38)
106Bal. VAT Amount (LCY) SearchBal. Tax Amount ($)NormalDecimal12Bal_ VAT Amount (LCY)decimal(38,38)
107Bal. VAT Base Amount (LCY) SearchBal. Tax Base Amount ($)NormalDecimal12Bal_ VAT Base Amount (LCY)decimal(38,38)
108Reversing Entry SearchReversing EntryNormalBoolean4Reversing Entrytinyint
109Allow Zero-Amount Posting SearchAllow Zero-Amount PostingNormalBoolean4Allow Zero-Amount Postingtinyint
110Ship-to/Order Address Code SearchShip-to/Order Address CodeNormalCode10Ship-to_Order Address Codenvarchar(20)
111VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
112Bal. VAT Difference SearchBal. Tax DifferenceNormalDecimal12Bal_ VAT Differencedecimal(38,38)
113IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Gen. Journal Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Gen. Journal Line].[IC Partner Code] = [IC Partner].[Code]
114IC Direction SearchIC DirectionNormalOption4IC Directionint
Available options are:
  • “Outgoing”
  • “Incoming”
116IC Partner G/L Acc. No. SearchIC Partner G/L Acc. No.NormalCode20IC Partner G_L Acc_ No_nvarchar(40)
Key to join to the IC G/L Account table.

Show/hide example query

SELECT
       [Gen. Journal Line].[IC Partner G_L Acc_ No_]
       ,[IC G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC G/L Account]
              ON
                     [Gen. Journal Line].[IC Partner G_L Acc_ No_] = [IC G/L Account].[No_]
117IC Partner Transaction No. SearchIC Partner Transaction No.NormalInteger4IC Partner Transaction No_int
118Sell-to/Buy-from No. SearchSell-to/Buy-from No.NormalCode20Sell-to_Buy-from No_nvarchar(40)
119VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
120Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Gen. Journal Line].[Country_Region Code] = [Country/Region].[Code]
121Prepayment SearchPrepaymentNormalBoolean4Prepaymenttinyint
122Financial Void SearchFinancial VoidNormalBoolean4Financial Voidtinyint
123Copy VAT Setup to Jnl. Lines SearchCopy Tax Setup to Jnl. LinesNormalBoolean4Copy VAT Setup to Jnl_ Linestinyint
125VAT Base Before Pmt. Disc. SearchTax Base Before Pmt. Disc.NormalDecimal12VAT Base Before Pmt_ Disc_decimal(38,38)
126Orig. Pmt. Disc. Possible SearchOriginal Pmt. Disc. PossibleNormalDecimal12Orig_ Pmt_ Disc_ Possibledecimal(38,38)
127Orig. Pmt. Disc. Possible(LCY) SearchOrig. Pmt. Disc. Possible ($)NormalDecimal12Orig_ Pmt_ Disc_ Possible(LCY)decimal(38,38)
128VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
130IC Account Type SearchIC Account TypeNormalOption4IC Account Typeint
Available options are:
  • “G/L Account”
  • “Bank Account”
131IC Account No. SearchIC Account No.NormalCode20IC Account No_nvarchar(40)
160Job Queue Status SearchJob Queue StatusNormalOption4Job Queue Statusint
Available options are:
  • ” “
  • “Scheduled for Posting”
  • “Error”
  • “Posting”
161Job Queue Entry ID SearchJob Queue Entry IDNormalGUID16Job Queue Entry IDuniqueidentifier
165Incoming Document Entry No. SearchIncoming Document Entry No.NormalInteger4Incoming Document Entry No_int
Key to join to the Incoming Document table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Incoming Document Entry No_]
       ,[Incoming Document].[Entry No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
              ON
                     [Gen. Journal Line].[Incoming Document Entry No_] = [Incoming Document].[Entry No_]
170Creditor No. SearchCreditor No.NormalCode20Creditor No_nvarchar(40)
171Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
172Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Gen. Journal Line].[Payment Method Code] = [Payment Method].[Code]
173Applies-to Ext. Doc. No. SearchApplies-to Ext. Doc. No.NormalCode35Applies-to Ext_ Doc_ No_nvarchar(70)
175Invoice Received Date SearchInvoice Received DateNormalDate4Invoice Received Datedatetime
180Keep Description SearchKeep DescriptionNormalBoolean4Keep Descriptiontinyint
288Recipient Bank Account SearchRecipient Bank AccountNormalCode20Recipient Bank Accountnvarchar(40)
289Message to Recipient SearchMessage to RecipientNormalText140Message to Recipientnvarchar(280)
290Exported to Payment File SearchExported to Payment FileNormalBoolean4Exported to Payment Filetinyint
291Has Payment Export Error SearchHas Payment Export ErrorFlowFieldBoolean4
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Gen. Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
827Credit Card No. SearchCredit Card No.NormalCode20Credit Card No_nvarchar(40)
1000Remit-to Code SearchRemit-to CodeNormalCode20Remit-to Codenvarchar(40)
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Unit Price (LCY) SearchJob Unit Price ($)NormalDecimal12Job Unit Price (LCY)decimal(38,38)
1003Job Total Price (LCY) SearchJob Total Price ($)NormalDecimal12Job Total Price (LCY)decimal(38,38)
1004Job Quantity SearchJob QuantityNormalDecimal12Job Quantitydecimal(38,38)
1005Job Unit Cost (LCY) SearchJob Unit Cost ($)NormalDecimal12Job Unit Cost (LCY)decimal(38,38)
1006Job Line Discount % SearchJob Line Discount %NormalDecimal12Job Line Discount _decimal(38,38)
1007Job Line Disc. Amount (LCY) SearchJob Line Disc. Amount ($)NormalDecimal12Job Line Disc_ Amount (LCY)decimal(38,38)
1008Job Unit Of Measure Code SearchJob Unit Of Measure CodeNormalCode10Job Unit Of Measure Codenvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Job Unit Of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Gen. Journal Line].[Job Unit Of Measure Code] = [Unit of Measure].[Code]
1009Job Line Type SearchJob Line TypeNormalOption4Job Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
1010Job Unit Price SearchJob Unit PriceNormalDecimal12Job Unit Pricedecimal(38,38)
1011Job Total Price SearchJob Total PriceNormalDecimal12Job Total Pricedecimal(38,38)
1012Job Unit Cost SearchJob Unit CostNormalDecimal12Job Unit Costdecimal(38,38)
1013Job Total Cost SearchJob Total CostNormalDecimal12Job Total Costdecimal(38,38)
1014Job Line Discount Amount SearchJob Line Discount AmountNormalDecimal12Job Line Discount Amountdecimal(38,38)
1015Job Line Amount SearchJob Line AmountNormalDecimal12Job Line Amountdecimal(38,38)
1016Job Total Cost (LCY) SearchJob Total Cost ($)NormalDecimal12Job Total Cost (LCY)decimal(38,38)
1017Job Line Amount (LCY) SearchJob Line Amount ($)NormalDecimal12Job Line Amount (LCY)decimal(38,38)
1018Job Currency Factor SearchJob Currency FactorNormalDecimal12Job Currency Factordecimal(38,38)
1019Job Currency Code SearchJob Currency CodeNormalCode10Job Currency Codenvarchar(20)
1020Job Planning Line No. SearchJob Planning Line No.NormalInteger4Job Planning Line No_int
1030Job Remaining Qty. SearchJob Remaining Qty.NormalDecimal12Job Remaining Qty_decimal(38,38)
1200Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
1220Data Exch. Entry No. SearchData Exch. Entry No.NormalInteger4Data Exch_ Entry No_int
Key to join to the Data Exch. table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Data Exch_ Entry No_]
       ,[Data Exch.].[Entry No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.]
              ON
                     [Gen. Journal Line].[Data Exch_ Entry No_] = [Data Exch.].[Entry No_]
1221Payer Information SearchPayer InformationNormalText50Payer Informationnvarchar(100)
1222Transaction Information SearchTransaction InformationNormalText100Transaction Informationnvarchar(200)
1223Data Exch. Line No. SearchData Exch. Line No.NormalInteger4Data Exch_ Line No_int
1224Applied Automatically SearchApplied AutomaticallyNormalBoolean4Applied Automaticallytinyint
1300Linked Table ID SearchLinked Table IDNormalInteger4Linked Table IDint
1301Linked System ID SearchLinked System IDNormalGUID16
1700Deferral Code SearchDeferral CodeNormalCode10Deferral Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Deferral Code]
       ,[Deferral Template].[Deferral Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
              ON
                     [Gen. Journal Line].[Deferral Code] = [Deferral Template].[Deferral Code]
1701Deferral Line No. SearchDeferral Line No.NormalInteger4Deferral Line No_int
2676Selected Alloc. Account No. SearchSelected Allocation Account No.NormalCode20Selected Alloc_ Account No_nvarchar(40)
Key to join to the Allocation Account table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Selected Alloc_ Account No_]
       ,[Allocation Account].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account]
              ON
                     [Gen. Journal Line].[Selected Alloc_ Account No_] = [Allocation Account].[No_]
2677Alloc. Acc. Modified by User SearchAllocation Account Distributions ModifiedFlowFieldBoolean4
2678Allocation Account No. SearchAllocation Account No.NormalCode20Allocation Account No_nvarchar(40)
Key to join to the Allocation Account table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Allocation Account No_]
       ,[Allocation Account].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account]
              ON
                     [Gen. Journal Line].[Allocation Account No_] = [Allocation Account].[No_]
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [Gen. Journal Line].[Campaign No_] = [Campaign].[No_]
5400Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
5600FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5601FA Posting Type SearchFA Posting TypeNormalOption4FA Posting Typeint
Available options are:
  • ” “
  • “Acquisition Cost”
  • “Depreciation”
  • “Write-Down”
  • “Appreciation”
  • “Custom 1”
  • “Custom 2”
  • “Disposal”
  • “Maintenance”
5602Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Gen. Journal Line].[Depreciation Book Code] = [Depreciation Book].[Code]
5603Salvage Value SearchSalvage ValueNormalDecimal12Salvage Valuedecimal(38,38)
5604No. of Depreciation Days SearchNo. of Depreciation DaysNormalInteger4No_ of Depreciation Daysint
5605Depr. until FA Posting Date SearchDepr. until FA Posting DateNormalBoolean4Depr_ until FA Posting Datetinyint
5606Depr. Acquisition Cost SearchDepr. Acquisition CostNormalBoolean4Depr_ Acquisition Costtinyint
5609Maintenance Code SearchMaintenance CodeNormalCode10Maintenance Codenvarchar(20)
Key to join to the Maintenance table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Maintenance Code]
       ,[Maintenance].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
              ON
                     [Gen. Journal Line].[Maintenance Code] = [Maintenance].[Code]
5610Insurance No. SearchInsurance No.NormalCode20Insurance No_nvarchar(40)
Key to join to the Insurance table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Insurance No_]
       ,[Insurance].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
              ON
                     [Gen. Journal Line].[Insurance No_] = [Insurance].[No_]
5611Budgeted FA No. SearchBudgeted FA No.NormalCode20Budgeted FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Budgeted FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [Gen. Journal Line].[Budgeted FA No_] = [Fixed Asset].[No_]
5612Duplicate in Depreciation Book SearchDuplicate in Depreciation BookNormalCode10Duplicate in Depreciation Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Duplicate in Depreciation Book]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Gen. Journal Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
5613Use Duplication List SearchUse Duplication ListNormalBoolean4Use Duplication Listtinyint
5614FA Reclassification Entry SearchFA Reclassification EntryNormalBoolean4FA Reclassification Entrytinyint
5615FA Error Entry No. SearchFA Error Entry No.NormalInteger4FA Error Entry No_int
Key to join to the FA Ledger Entry table.

Show/hide example query

SELECT
       [Gen. Journal Line].[FA Error Entry No_]
       ,[FA Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
              ON
                     [Gen. Journal Line].[FA Error Entry No_] = [FA Ledger Entry].[Entry No_]
5616Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
5617Source Line No. SearchSource Line No.NormalInteger4Source Line No_int
5618Comment SearchCommentNormalText250Commentnvarchar(500)
5701Check Exported SearchCheck ExportedNormalBoolean4Check Exportedtinyint
5702Check Transmitted SearchCheck TransmittedNormalBoolean4Check Transmittedtinyint
5703Reverse Date Calculation SearchReverse Date CalculationNormalDateFormula32Reverse Date Calculationvarchar(32)
6200Non-Deductible VAT % SearchNon-Deductible Tax %NormalDecimal12Non-Deductible VAT _decimal(38,38)
6201Non-Deductible VAT Base SearchNon-Deductible Tax BaseNormalDecimal12Non-Deductible VAT Basedecimal(38,38)
6202Non-Deductible VAT Amount SearchNon-Deductible Tax AmountNormalDecimal12Non-Deductible VAT Amountdecimal(38,38)
6203Non-Deductible VAT Base LCY SearchNon-Deductible Tax Base LCYNormalDecimal12Non-Deductible VAT Base LCYdecimal(38,38)
6204Non-Deductible VAT Amount LCY SearchNon-Deductible Tax Amount LCYNormalDecimal12Non-Deductible VAT Amount LCYdecimal(38,38)
6205Non-Deductible VAT Base ACY SearchNon-Deductible Tax Base ACYNormalDecimal12Non-Deductible VAT Base ACYdecimal(38,38)
6206Non-Deductible VAT Amount ACY SearchNon-Deductible Tax Amount ACYNormalDecimal12Non-Deductible VAT Amount ACYdecimal(38,38)
6207FA G/L Account No. SearchFA G/L Account No.NormalCode20FA G_L Account No_nvarchar(40)
6208Non-Deductible VAT Diff. SearchNon-Deductible Tax DifferenceNormalDecimal12Non-Deductible VAT Diff_decimal(38,38)
6209Bal. Non-Ded. VAT % SearchBal. Non-Deductible Tax %NormalDecimal12Bal_ Non-Ded_ VAT _decimal(38,38)
6210Bal. Non-Ded. VAT Base SearchBal. Non-Deductible Tax BaseNormalDecimal12Bal_ Non-Ded_ VAT Basedecimal(38,38)
6211Bal. Non-Ded. VAT Amount SearchBal. Non-Deductible Tax AmountNormalDecimal12Bal_ Non-Ded_ VAT Amountdecimal(38,38)
6212Bal. Non-Ded. VAT Base LCY SearchBal. Non-Deductible Tax Base LCYNormalDecimal12Bal_ Non-Ded_ VAT Base LCYdecimal(38,38)
6213Bal. Non-Ded. VAT Amount LCY SearchBal. Non-Deductible Tax Amount LCYNormalDecimal12Bal_ Non-Ded_ VAT Amount LCYdecimal(38,38)
8000Id SearchIdNormalGUID16Iduniqueidentifier
8001Account Id SearchAccount IdNormalGUID16Account Iduniqueidentifier
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Account Id]
       ,[G/L Account].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Gen. Journal Line].[Account Id] = [G/L Account].[$systemId]
8002Customer Id SearchCustomer IdNormalGUID16Customer Iduniqueidentifier
Key to join to the Customer table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Customer Id]
       ,[Customer].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Gen. Journal Line].[Customer Id] = [Customer].[$systemId]
8003Applies-to Invoice Id SearchApplies-to Invoice IdNormalGUID16Applies-to Invoice Iduniqueidentifier
Key to join to the Sales Invoice Header table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Applies-to Invoice Id]
       ,[Sales Invoice Header].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header]
              ON
                     [Gen. Journal Line].[Applies-to Invoice Id] = [Sales Invoice Header].[$systemId]
8004Contact Graph Id SearchContact Graph IdNormalText250Contact Graph Idnvarchar(500)
8005Last Modified DateTime SearchLast Modified DateTimeNormalDateTime8Last Modified DateTimedatetime
8006Journal Batch Id SearchJournal Batch IdNormalGUID16Journal Batch Iduniqueidentifier
Key to join to the Gen. Journal Batch table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Journal Batch Id]
       ,[Gen. Journal Batch].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
              ON
                     [Gen. Journal Line].[Journal Batch Id] = [Gen. Journal Batch].[$systemId]
8007Payment Method Id SearchPayment Method IdNormalGUID16Payment Method Iduniqueidentifier
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Payment Method Id]
       ,[Payment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Gen. Journal Line].[Payment Method Id] = [Payment Method].[$systemId]
8008Balance Account Id SearchBalance Account IdNormalGUID16Balance Account Iduniqueidentifier
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Balance Account Id]
       ,[G/L Account].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Gen. Journal Line].[Balance Account Id] = [G/L Account].[$systemId]
8009Vendor Id SearchVendor IdNormalGUID16Vendor Iduniqueidentifier
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Gen. Journal Line].[Vendor Id]
       ,[Vendor].[$systemId]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Gen. Journal Line].[Vendor Id] = [Vendor].[$systemId]
10006Export File Name SearchExport File NameNormalText30
10011Tax Jurisdiction Code SearchTax Jurisdiction CodeNormalCode10
10012Tax Type SearchTax TypeNormalOption4
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10020IRS 1099 Code SearchIRS 1099 CodeNormalCode10
10021IRS 1099 Amount SearchIRS 1099 AmountNormalDecimal12
10030Foreign Exchange Indicator SearchForeign Exchange IndicatorNormalOption4
10031Foreign Exchange Ref.Indicator SearchForeign Exchange Ref.IndicatorNormalOption4
10032Foreign Exchange Reference SearchForeign Exchange ReferenceNormalCode20
10033Gateway Operator OFAC Scr.Inc SearchGateway Operator OFAC Scr.IncNormalOption4
10034Secondary OFAC Scr.Indicator SearchSecondary OFAC Scr.IndicatorNormalOption4
10035Origin. DFI ID Qualifier SearchOrigin. DFI ID QualifierNormalOption4
10036Receiv. DFI ID Qualifier SearchReceiv. DFI ID QualifierNormalOption4
10037Transaction Type Code SearchTransaction Type CodeNormalOption4
10038Transaction Code SearchTransaction CodeNormalCode3
10039Company Entry Description SearchCompany Entry DescriptionNormalText10
10040Payment Related Information 1 SearchPayment Related Information 1NormalText80
10041Payment Related Information 2 SearchPayment Related Information 2NormalText52
10045GST/HST SearchGST/HSTNormalOption4
10046EFT Export Sequence No. SearchEFT Export Sequence No.NormalInteger4
27030DIOT Type of Operation SearchDIOT Type of OperationNormalOption4
27040DIOT-Type of Operation SearchDIOT Type of OperationNormalOption4
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
       [Gen. Journal Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Gen. Journal Line].[$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
       [Gen. Journal Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Gen. Journal Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Gen. Journal Line table

CurrencyIC PartnerPayment MethodPayment TermsSales HeaderSales Header ArchiveTax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesGGen. Journal Line

Leave a Reply

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