Gen_ 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: 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 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
   [timestamp]
   ,[Journal Template Name]
   ,[Journal Batch 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]
   ,[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]
   ,[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_]
   ,[Keep Description]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[Credit Card No_]
   ,[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]
   ,[Linked System ID]
   ,[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]
   ,[Reverse Date Calculation]
   ,[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]
   ,[Invoice Receipt Date]
   ,[$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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Gen_ Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Gen_ Journal Line].[Job No_] = [Job].[Job No_]
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_$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_$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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [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
         [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
         [Gen_ Journal Line].[Job Task No_] = [Job Task].[Job Task No_]

Show/hide columns in Gen_ Journal Line table

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

Show/hide example query

SELECT
       [Gen_ Journal Line].[Job No_]
       ,[Job].[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].[Job No_]
38Quantity Searchdecimal(38,38)
39VAT Amount Searchdecimal(38,38)
40VAT Posting Searchint
41Payment Terms Code Searchnvarchar(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]
42Applies-to ID Searchnvarchar(100)
43Business Unit Code Searchnvarchar(40)
44Reason Code Searchnvarchar(20)
45Recurring Method Searchint
46Expiration Date Searchdatetime
47Recurring Frequency Searchvarchar(32)
48Gen_ Posting Type Searchint
49Gen_ Bus_ Posting Group Searchnvarchar(40)
50Gen_ Prod_ Posting Group Searchnvarchar(40)
51VAT Calculation Type Searchint
52EU 3-Party Trade Searchtinyint
53Allow Application Searchtinyint
54Bal_ Account Type Searchint
55Bal_ Gen_ Posting Type Searchint
56Bal_ Gen_ Bus_ Posting Group Searchnvarchar(40)
57Bal_ Gen_ Prod_ Posting Group Searchnvarchar(40)
58Bal_ VAT Calculation Type Searchint
59Bal_ VAT _ Searchdecimal(38,38)
60Bal_ VAT Amount Searchdecimal(38,38)
61Bank Payment Type Searchint
62VAT Base Amount Searchdecimal(38,38)
63Bal_ VAT Base Amount Searchdecimal(38,38)
64Correction Searchtinyint
65Print Posted Documents Searchtinyint
66Check Printed Searchtinyint
67Document Date Searchdatetime
68External Document No_ Searchnvarchar(70)
69Source Type Searchint
70Source No_ Searchnvarchar(40)
71Posting No_ Series Searchnvarchar(40)
72Tax Area Code Searchnvarchar(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]
73Tax Liable Searchtinyint
74Tax Group Code Searchnvarchar(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]
75Use Tax Searchtinyint
76Bal_ Tax Area Code Searchnvarchar(40)
77Bal_ Tax Liable Searchtinyint
78Bal_ Tax Group Code Searchnvarchar(40)
79Bal_ Use Tax Searchtinyint
80VAT Bus_ Posting Group Searchnvarchar(40)
81VAT Prod_ Posting Group Searchnvarchar(40)
82Bal_ VAT Bus_ Posting Group Searchnvarchar(40)
83Bal_ VAT Prod_ Posting Group Searchnvarchar(40)
84Additional-Currency Posting Searchint
85FA Add_-Currency Factor Searchdecimal(38,38)
86Source Currency Code Searchnvarchar(20)
87Source Currency Amount Searchdecimal(38,38)
88Source Curr_ VAT Base Amount Searchdecimal(38,38)
89Source Curr_ VAT Amount Searchdecimal(38,38)
90VAT Base Discount _ Searchdecimal(38,38)
91VAT Amount (LCY) Searchdecimal(38,38)
92VAT Base Amount (LCY) Searchdecimal(38,38)
93Bal_ VAT Amount (LCY) Searchdecimal(38,38)
94Bal_ VAT Base Amount (LCY) Searchdecimal(38,38)
95Reversing Entry Searchtinyint
96Allow Zero-Amount Posting Searchtinyint
97Ship-to_Order Address Code Searchnvarchar(20)
98VAT Difference Searchdecimal(38,38)
99Bal_ VAT Difference Searchdecimal(38,38)
100IC Partner Code Searchnvarchar(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]
101IC Direction Searchint
102IC Partner G_L Acc_ No_ Searchnvarchar(40)
103IC Partner Transaction No_ Searchint
104Sell-to_Buy-from No_ Searchnvarchar(40)
105VAT Registration No_ Searchnvarchar(40)
106Country_Region Code Searchnvarchar(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]
107Prepayment Searchtinyint
108Financial Void Searchtinyint
109Copy VAT Setup to Jnl_ Lines Searchtinyint
110VAT Base Before Pmt_ Disc_ Searchdecimal(38,38)
111Orig_ Pmt_ Disc_ Possible Searchdecimal(38,38)
112Orig_ Pmt_ Disc_ Possible(LCY) Searchdecimal(38,38)
113Job Queue Status Searchint
114Job Queue Entry ID Searchuniqueidentifier
115Incoming Document Entry No_ Searchint
116Creditor No_ Searchnvarchar(40)
117Payment Reference Searchnvarchar(100)
118Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Gen_ Journal Line].[Payment Method Code] = [Payment Method].[Code]
119Applies-to Ext_ Doc_ No_ Searchnvarchar(70)
120Keep Description Searchtinyint
121Recipient Bank Account Searchnvarchar(40)
122Message to Recipient Searchnvarchar(280)
123Exported to Payment File Searchtinyint
124Dimension Set ID Searchint
125Credit Card No_ Searchnvarchar(40)
126Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

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

Show/hide tables related from Gen_ Journal Line table

Leave a Reply

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