Posted Gen_ Journal Line

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Line No_]
   ,[Journal Template Name]
   ,[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]
   ,[Source Code]
   ,[System-Created Entry]
   ,[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)]
   ,[Job Queue Status]
   ,[Job Queue Entry ID]
   ,[Incoming Document Entry No_]
   ,[Creditor No_]
   ,[Payment Reference]
   ,[Payment Method Code]
   ,[Applies-to Ext_ Doc_ No_]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[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]
   ,[Deferral Code]
   ,[Deferral Line 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]
   ,[Account Id]
   ,[Customer Id]
   ,[Applies-to Invoice Id]
   ,[Contact Graph Id]
   ,[Last Modified DateTime]
   ,[Journal Batch Id]
   ,[Payment Method Id]
   ,[G_L Register No_]
   ,[Indentation]
   ,[Invoice Receipt Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted 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_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Posted Gen_ Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Posted Gen_ Journal Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Posted Gen_ Journal Line].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Posted 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
         [Posted Gen_ Journal Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Posted Gen_ Journal Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Posted Gen_ Journal Line].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Posted Gen_ Journal Line].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Posted Gen_ Journal Line].[Job Task No_] = [Job Task].[Job Task No_]

Show/hide columns in Posted Gen_ Journal Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Journal Template Name Searchnvarchar(20)
4Account Type Searchint
5Account No_ Searchnvarchar(40)
6Posting Date Searchdatetime
7Document Type Searchint
8Document No_ Searchnvarchar(40)
9Description Searchnvarchar(200)
10VAT _ Searchdecimal(38,38)
11Bal_ Account No_ Searchnvarchar(40)
12Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Posted Gen_ Journal Line].[Currency Code] = [Currency].[Code]
13Amount Searchdecimal(38,38)
14Debit Amount Searchdecimal(38,38)
15Credit Amount Searchdecimal(38,38)
16Amount (LCY) Searchdecimal(38,38)
17Balance (LCY) Searchdecimal(38,38)
18Currency Factor Searchdecimal(38,38)
19Sales_Purch_ (LCY) Searchdecimal(38,38)
20Profit (LCY) Searchdecimal(38,38)
21Inv_ Discount (LCY) Searchdecimal(38,38)
22Bill-to_Pay-to No_ Searchnvarchar(40)
23Posting Group Searchnvarchar(40)
24Shortcut Dimension 1 Code Searchnvarchar(40)
25Shortcut Dimension 2 Code Searchnvarchar(40)
26Salespers__Purch_ Code Searchnvarchar(40)
27Source Code Searchnvarchar(20)
28System-Created Entry Searchtinyint
29On Hold Searchnvarchar(6)
30Applies-to Doc_ Type Searchint
31Applies-to Doc_ No_ Searchnvarchar(40)
32Due Date Searchdatetime
33Pmt_ Discount Date Searchdatetime
34Payment Discount _ Searchdecimal(38,38)
35Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Posted Gen_ Journal Line].[Job No_] = [Job].[Job No_]
36Quantity Searchdecimal(38,38)
37VAT Amount Searchdecimal(38,38)
38VAT Posting Searchint
39Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Posted Gen_ Journal Line].[Payment Terms Code] = [Payment Terms].[Code]
40Applies-to ID Searchnvarchar(100)
41Business Unit Code Searchnvarchar(40)
42Journal Batch Name Searchnvarchar(20)
43Reason Code Searchnvarchar(20)
44Recurring Method Searchint
45Expiration Date Searchdatetime
46Recurring Frequency Searchvarchar(32)
47Gen_ Posting Type Searchint
48Gen_ Bus_ Posting Group Searchnvarchar(40)
49Gen_ Prod_ Posting Group Searchnvarchar(40)
50VAT Calculation Type Searchint
51EU 3-Party Trade Searchtinyint
52Allow Application Searchtinyint
53Bal_ Account Type Searchint
54Bal_ Gen_ Posting Type Searchint
55Bal_ Gen_ Bus_ Posting Group Searchnvarchar(40)
56Bal_ Gen_ Prod_ Posting Group Searchnvarchar(40)
57Bal_ VAT Calculation Type Searchint
58Bal_ VAT _ Searchdecimal(38,38)
59Bal_ VAT Amount Searchdecimal(38,38)
60Bank Payment Type Searchint
61VAT Base Amount Searchdecimal(38,38)
62Bal_ VAT Base Amount Searchdecimal(38,38)
63Correction Searchtinyint
64Print Posted Documents Searchtinyint
65Check Printed Searchtinyint
66Document Date Searchdatetime
67External Document No_ Searchnvarchar(70)
68Source Type Searchint
69Source No_ Searchnvarchar(40)
70Posting No_ Series Searchnvarchar(40)
71Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Posted Gen_ Journal Line].[Tax Area Code] = [Tax Area].[Code]
72Tax Liable Searchtinyint
73Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Posted Gen_ Journal Line].[Tax Group Code] = [Tax Group].[Code]
74Use Tax Searchtinyint
75Bal_ Tax Area Code Searchnvarchar(40)
76Bal_ Tax Liable Searchtinyint
77Bal_ Tax Group Code Searchnvarchar(40)
78Bal_ Use Tax Searchtinyint
79VAT Bus_ Posting Group Searchnvarchar(40)
80VAT Prod_ Posting Group Searchnvarchar(40)
81Bal_ VAT Bus_ Posting Group Searchnvarchar(40)
82Bal_ VAT Prod_ Posting Group Searchnvarchar(40)
83Additional-Currency Posting Searchint
84FA Add_-Currency Factor Searchdecimal(38,38)
85Source Currency Code Searchnvarchar(20)
86Source Currency Amount Searchdecimal(38,38)
87Source Curr_ VAT Base Amount Searchdecimal(38,38)
88Source Curr_ VAT Amount Searchdecimal(38,38)
89VAT Base Discount _ Searchdecimal(38,38)
90VAT Amount (LCY) Searchdecimal(38,38)
91VAT Base Amount (LCY) Searchdecimal(38,38)
92Bal_ VAT Amount (LCY) Searchdecimal(38,38)
93Bal_ VAT Base Amount (LCY) Searchdecimal(38,38)
94Reversing Entry Searchtinyint
95Allow Zero-Amount Posting Searchtinyint
96Ship-to_Order Address Code Searchnvarchar(20)
97VAT Difference Searchdecimal(38,38)
98Bal_ VAT Difference Searchdecimal(38,38)
99IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Posted Gen_ Journal Line].[IC Partner Code] = [IC Partner].[Code]
100IC Direction Searchint
101IC Partner G_L Acc_ No_ Searchnvarchar(40)
102IC Partner Transaction No_ Searchint
103Sell-to_Buy-from No_ Searchnvarchar(40)
104VAT Registration No_ Searchnvarchar(40)
105Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Posted Gen_ Journal Line].[Country_Region Code] = [Country_Region].[Code]
106Prepayment Searchtinyint
107Financial Void Searchtinyint
108Copy VAT Setup to Jnl_ Lines Searchtinyint
109VAT Base Before Pmt_ Disc_ Searchdecimal(38,38)
110Orig_ Pmt_ Disc_ Possible Searchdecimal(38,38)
111Orig_ Pmt_ Disc_ Possible(LCY) Searchdecimal(38,38)
112Job Queue Status Searchint
113Job Queue Entry ID Searchuniqueidentifier
114Incoming Document Entry No_ Searchint
115Creditor No_ Searchnvarchar(40)
116Payment Reference Searchnvarchar(100)
117Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Posted Gen_ Journal Line].[Payment Method Code] = [Payment Method].[Code]
118Applies-to Ext_ Doc_ No_ Searchnvarchar(70)
119Recipient Bank Account Searchnvarchar(40)
120Message to Recipient Searchnvarchar(280)
121Exported to Payment File Searchtinyint
122Dimension Set ID Searchint
123Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Posted Gen_ Journal Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Gen_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Posted Gen_ Journal Line].[Job Task No_] = [Job Task].[Job Task No_]
124Job Unit Price (LCY) Searchdecimal(38,38)
125Job Total Price (LCY) Searchdecimal(38,38)
126Job Quantity Searchdecimal(38,38)
127Job Unit Cost (LCY) Searchdecimal(38,38)
128Job Line Discount _ Searchdecimal(38,38)
129Job Line Disc_ Amount (LCY) Searchdecimal(38,38)
130Job Unit Of Measure Code Searchnvarchar(20)
131Job Line Type Searchint
132Job Unit Price Searchdecimal(38,38)
133Job Total Price Searchdecimal(38,38)
134Job Unit Cost Searchdecimal(38,38)
135Job Total Cost Searchdecimal(38,38)
136Job Line Discount Amount Searchdecimal(38,38)
137Job Line Amount Searchdecimal(38,38)
138Job Total Cost (LCY) Searchdecimal(38,38)
139Job Line Amount (LCY) Searchdecimal(38,38)
140Job Currency Factor Searchdecimal(38,38)
141Job Currency Code Searchnvarchar(20)
142Job Planning Line No_ Searchint
143Job Remaining Qty_ Searchdecimal(38,38)
144Direct Debit Mandate ID Searchnvarchar(70)
145Data Exch_ Entry No_ Searchint
146Payer Information Searchnvarchar(100)
147Transaction Information Searchnvarchar(200)
148Data Exch_ Line No_ Searchint
149Applied Automatically Searchtinyint
150Deferral Code Searchnvarchar(20)
151Deferral Line No_ Searchint
152Campaign No_ Searchnvarchar(40)
153Prod_ Order No_ Searchnvarchar(40)
154FA Posting Date Searchdatetime
155FA Posting Type Searchint
156Depreciation Book Code Searchnvarchar(20)
157Salvage Value Searchdecimal(38,38)
158No_ of Depreciation Days Searchint
159Depr_ until FA Posting Date Searchtinyint
160Depr_ Acquisition Cost Searchtinyint
161Maintenance Code Searchnvarchar(20)
162Insurance No_ Searchnvarchar(40)
163Budgeted FA No_ Searchnvarchar(40)
164Duplicate in Depreciation Book Searchnvarchar(20)
165Use Duplication List Searchtinyint
166FA Reclassification Entry Searchtinyint
167FA Error Entry No_ Searchint
168Index Entry Searchtinyint
169Source Line No_ Searchint
170Comment Searchnvarchar(500)
171Check Exported Searchtinyint
172Check Transmitted Searchtinyint
173Account Id Searchuniqueidentifier
174Customer Id Searchuniqueidentifier
175Applies-to Invoice Id Searchuniqueidentifier
176Contact Graph Id Searchnvarchar(500)
177Last Modified DateTime Searchdatetime
178Journal Batch Id Searchuniqueidentifier
179Payment Method Id Searchuniqueidentifier
180G_L Register No_ Searchint
181Indentation Searchint
182Invoice Receipt Date Searchdatetime
183$systemId Searchuniqueidentifier
184$systemCreatedAt Searchdatetime
185$systemCreatedBy Searchuniqueidentifier
186$systemModifiedAt Searchdatetime
187$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Gen_ Journal Line table

Leave a Reply

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