Standard General Journal Line

Dynamics 365 BC Table ReferenceTablesCompany TablesSStandard General Journal Line

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

Table Type: Company

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

Table Number: 751

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Standard General 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_]
   ,[Document Type]
   ,[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]
   ,[Source Code]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Payment Discount _]
   ,[Job No_]
   ,[Quantity]
   ,[VAT Amount]
   ,[Payment Terms Code]
   ,[Business Unit Code]
   ,[Standard Journal Code]
   ,[Reason Code]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[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]
   ,[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]
   ,[Ship-to_Order Address Code]
   ,[VAT Difference]
   ,[Bal_ VAT Difference]
   ,[IC Partner Code]
   ,[IC Partner G_L Acc_ No_]
   ,[Sell-to_Buy-from No_]
   ,[IC Account Type]
   ,[IC Account No_]
   ,[Dimension Set ID]
   ,[Campaign No_]
   ,[Index Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Standard General 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_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Standard General Journal Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Standard General Journal Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Standard General Journal Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Standard General Journal Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Standard General Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Standard General Journal Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Standard General Journal Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Standard General Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Standard General Journal Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Standard General Journal Line].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [Standard General Journal Line].[Business Unit Code] = [Business Unit].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Standard General Journal Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Standard General Journal Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Standard General Journal Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Standard General Journal Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Standard General Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Standard General Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Standard General Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Standard General 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
       [Standard General Journal Line].[Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Standard General Journal Line].[Account No_] = [G/L Account].[No_]
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
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
       [Standard General Journal Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Standard General Journal Line].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
29Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Standard General Journal Line].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Standard General Journal Line].[Source Code] = [Source Code].[Code]
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”
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
       [Standard General Journal Line].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Standard General Journal Line].[Job No_] = [Job].[No_]
43Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
44VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
47Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Standard General Journal Line].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Standard General Journal Line].[Reason Code] = [Reason Code].[Code]
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
       [Standard General Journal Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Standard General 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”
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
       [Standard General Journal Line].[Bal_ Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Bal_ Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Standard General 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
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”
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
       [Standard General Journal Line].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Bal_ Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Bal_ Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Bal_ VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Standard General 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
       [Standard General Journal Line].[Bal_ VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Standard General Journal Line].[Bal_ VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
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
       [Standard General Journal Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Standard General Journal Line].[IC Partner Code] = [IC Partner].[Code]
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
       [Standard General Journal Line].[IC Partner G_L Acc_ No_]
       ,[IC G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC G/L Account]
              ON
                     [Standard General Journal Line].[IC Partner G_L Acc_ No_] = [IC G/L Account].[No_]
118Sell-to/Buy-from No. SearchSell-to/Buy-from No.NormalCode20Sell-to_Buy-from No_nvarchar(40)
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)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Standard General Journal Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Standard General Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [Standard General Journal Line].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [Standard General Journal Line].[Campaign No_] = [Campaign].[No_]
5616Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
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
       [Standard General Journal Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Standard General 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
       [Standard General Journal Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Standard General Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard General Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Standard General Journal Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Standard General Journal Line table

CurrencyIC PartnerPayment TermsSales HeaderSales Header ArchiveTax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesSStandard General Journal Line

Leave a Reply

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