Standard 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
   [timestamp]
   ,[Journal Template Name]
   ,[Standard Journal Code]
   ,[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]
   ,[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_]
   ,[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Standard General Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Standard General Journal Line].[Job No_] = [Job].[Job No_]
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_$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]

Show/hide columns in Standard General Journal Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Standard Journal Code Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Account Type Searchint
6Account No_ Searchnvarchar(40)
7Document Type Searchint
8Description Searchnvarchar(200)
9VAT _ Searchdecimal(38,38)
10Bal_ Account No_ Searchnvarchar(40)
11Currency Code Searchnvarchar(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]
12Amount Searchdecimal(38,38)
13Debit Amount Searchdecimal(38,38)
14Credit Amount Searchdecimal(38,38)
15Amount (LCY) Searchdecimal(38,38)
16Balance (LCY) Searchdecimal(38,38)
17Currency Factor Searchdecimal(38,38)
18Sales_Purch_ (LCY) Searchdecimal(38,38)
19Profit (LCY) Searchdecimal(38,38)
20Inv_ Discount (LCY) Searchdecimal(38,38)
21Bill-to_Pay-to No_ Searchnvarchar(40)
22Posting Group Searchnvarchar(40)
23Shortcut Dimension 1 Code Searchnvarchar(40)
24Shortcut Dimension 2 Code Searchnvarchar(40)
25Salespers__Purch_ Code Searchnvarchar(40)
26Source Code Searchnvarchar(20)
27On Hold Searchnvarchar(6)
28Applies-to Doc_ Type Searchint
29Payment Discount _ Searchdecimal(38,38)
30Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Standard General Journal Line].[Job No_]
       ,[Job].[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].[Job No_]
31Quantity Searchdecimal(38,38)
32VAT Amount Searchdecimal(38,38)
33Payment Terms Code Searchnvarchar(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]
34Business Unit Code Searchnvarchar(40)
35Reason Code Searchnvarchar(20)
36Gen_ Posting Type Searchint
37Gen_ Bus_ Posting Group Searchnvarchar(40)
38Gen_ Prod_ Posting Group Searchnvarchar(40)
39VAT Calculation Type Searchint
40Bal_ Account Type Searchint
41Bal_ Gen_ Posting Type Searchint
42Bal_ Gen_ Bus_ Posting Group Searchnvarchar(40)
43Bal_ Gen_ Prod_ Posting Group Searchnvarchar(40)
44Bal_ VAT Calculation Type Searchint
45Bal_ VAT _ Searchdecimal(38,38)
46Bal_ VAT Amount Searchdecimal(38,38)
47Bank Payment Type Searchint
48VAT Base Amount Searchdecimal(38,38)
49Bal_ VAT Base Amount Searchdecimal(38,38)
50Correction Searchtinyint
51External Document No_ Searchnvarchar(70)
52Source Type Searchint
53Source No_ Searchnvarchar(40)
54Posting No_ Series Searchnvarchar(40)
55Tax Area Code Searchnvarchar(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]
56Tax Liable Searchtinyint
57Tax Group Code Searchnvarchar(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]
58Use Tax Searchtinyint
59Bal_ Tax Area Code Searchnvarchar(40)
60Bal_ Tax Liable Searchtinyint
61Bal_ Tax Group Code Searchnvarchar(40)
62Bal_ Use Tax Searchtinyint
63VAT Bus_ Posting Group Searchnvarchar(40)
64VAT Prod_ Posting Group Searchnvarchar(40)
65Bal_ VAT Bus_ Posting Group Searchnvarchar(40)
66Bal_ VAT Prod_ Posting Group Searchnvarchar(40)
67Ship-to_Order Address Code Searchnvarchar(20)
68VAT Difference Searchdecimal(38,38)
69Bal_ VAT Difference Searchdecimal(38,38)
70IC Partner Code Searchnvarchar(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]
71IC Partner G_L Acc_ No_ Searchnvarchar(40)
72Sell-to_Buy-from No_ Searchnvarchar(40)
73Dimension Set ID Searchint
74Campaign No_ Searchnvarchar(40)
75Index Entry Searchtinyint
76$systemId Searchuniqueidentifier
77$systemCreatedAt Searchdatetime
78$systemCreatedBy Searchuniqueidentifier
79$systemModifiedAt Searchdatetime
80$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Standard General Journal Line table

Leave a Reply

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