Posted Gen_ Journal Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPosted 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Line No_	int
3	Journal Template Name	nvarchar(20)
4	Account Type	int
5	Account No_	nvarchar(40)
6	Posting Date	datetime
7	Document Type	int
8	Document No_	nvarchar(40)
9	Description	nvarchar(200)
10	VAT _	decimal(38,38)
11	Bal_ Account No_	nvarchar(40)
12	Currency Code	nvarchar(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]
13	Amount	decimal(38,38)
14	Debit Amount	decimal(38,38)
15	Credit Amount	decimal(38,38)
16	Amount (LCY)	decimal(38,38)
17	Balance (LCY)	decimal(38,38)
18	Currency Factor	decimal(38,38)
19	Sales_Purch_ (LCY)	decimal(38,38)
20	Profit (LCY)	decimal(38,38)
21	Inv_ Discount (LCY)	decimal(38,38)
22	Bill-to_Pay-to No_	nvarchar(40)
23	Posting Group	nvarchar(40)
24	Shortcut Dimension 1 Code	nvarchar(40)
25	Shortcut Dimension 2 Code	nvarchar(40)
26	Salespers__Purch_ Code	nvarchar(40)
27	Source Code	nvarchar(20)
28	System-Created Entry	tinyint
29	On Hold	nvarchar(6)
30	Applies-to Doc_ Type	int
31	Applies-to Doc_ No_	nvarchar(40)
32	Due Date	datetime
33	Pmt_ Discount Date	datetime
34	Payment Discount _	decimal(38,38)
35	Job No_	nvarchar(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_]
36	Quantity	decimal(38,38)
37	VAT Amount	decimal(38,38)
38	VAT Posting	int
39	Payment Terms Code	nvarchar(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]
40	Applies-to ID	nvarchar(100)
41	Business Unit Code	nvarchar(40)
42	Journal Batch Name	nvarchar(20)
43	Reason Code	nvarchar(20)
44	Recurring Method	int
45	Expiration Date	datetime
46	Recurring Frequency	varchar(32)
47	Gen_ Posting Type	int
48	Gen_ Bus_ Posting Group	nvarchar(40)
49	Gen_ Prod_ Posting Group	nvarchar(40)
50	VAT Calculation Type	int
51	EU 3-Party Trade	tinyint
52	Allow Application	tinyint
53	Bal_ Account Type	int
54	Bal_ Gen_ Posting Type	int
55	Bal_ Gen_ Bus_ Posting Group	nvarchar(40)
56	Bal_ Gen_ Prod_ Posting Group	nvarchar(40)
57	Bal_ VAT Calculation Type	int
58	Bal_ VAT _	decimal(38,38)
59	Bal_ VAT Amount	decimal(38,38)
60	Bank Payment Type	int
61	VAT Base Amount	decimal(38,38)
62	Bal_ VAT Base Amount	decimal(38,38)
63	Correction	tinyint
64	Print Posted Documents	tinyint
65	Check Printed	tinyint
66	Document Date	datetime
67	External Document No_	nvarchar(70)
68	Source Type	int
69	Source No_	nvarchar(40)
70	Posting No_ Series	nvarchar(40)
71	Tax Area Code	nvarchar(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]
72	Tax Liable	tinyint
73	Tax Group Code	nvarchar(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]
74	Use Tax	tinyint
75	Bal_ Tax Area Code	nvarchar(40)
76	Bal_ Tax Liable	tinyint
77	Bal_ Tax Group Code	nvarchar(40)
78	Bal_ Use Tax	tinyint
79	VAT Bus_ Posting Group	nvarchar(40)
80	VAT Prod_ Posting Group	nvarchar(40)
81	Bal_ VAT Bus_ Posting Group	nvarchar(40)
82	Bal_ VAT Prod_ Posting Group	nvarchar(40)
83	Additional-Currency Posting	int
84	FA Add_-Currency Factor	decimal(38,38)
85	Source Currency Code	nvarchar(20)
86	Source Currency Amount	decimal(38,38)
87	Source Curr_ VAT Base Amount	decimal(38,38)
88	Source Curr_ VAT Amount	decimal(38,38)
89	VAT Base Discount _	decimal(38,38)
90	VAT Amount (LCY)	decimal(38,38)
91	VAT Base Amount (LCY)	decimal(38,38)
92	Bal_ VAT Amount (LCY)	decimal(38,38)
93	Bal_ VAT Base Amount (LCY)	decimal(38,38)
94	Reversing Entry	tinyint
95	Allow Zero-Amount Posting	tinyint
96	Ship-to_Order Address Code	nvarchar(20)
97	VAT Difference	decimal(38,38)
98	Bal_ VAT Difference	decimal(38,38)
99	IC Partner Code	nvarchar(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]
100	IC Direction	int
101	IC Partner G_L Acc_ No_	nvarchar(40)
102	IC Partner Transaction No_	int
103	Sell-to_Buy-from No_	nvarchar(40)
104	VAT Registration No_	nvarchar(40)
105	Country_Region Code	nvarchar(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]
106	Prepayment	tinyint
107	Financial Void	tinyint
108	Copy VAT Setup to Jnl_ Lines	tinyint
109	VAT Base Before Pmt_ Disc_	decimal(38,38)
110	Orig_ Pmt_ Disc_ Possible	decimal(38,38)
111	Orig_ Pmt_ Disc_ Possible(LCY)	decimal(38,38)
112	Job Queue Status	int
113	Job Queue Entry ID	uniqueidentifier
114	Incoming Document Entry No_	int
115	Creditor No_	nvarchar(40)
116	Payment Reference	nvarchar(100)
117	Payment Method Code	nvarchar(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]
118	Applies-to Ext_ Doc_ No_	nvarchar(70)
119	Recipient Bank Account	nvarchar(40)
120	Message to Recipient	nvarchar(280)
121	Exported to Payment File	tinyint
122	Dimension Set ID	int
123	Job Task No_	nvarchar(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_]
124	Job Unit Price (LCY)	decimal(38,38)
125	Job Total Price (LCY)	decimal(38,38)
126	Job Quantity	decimal(38,38)
127	Job Unit Cost (LCY)	decimal(38,38)
128	Job Line Discount _	decimal(38,38)
129	Job Line Disc_ Amount (LCY)	decimal(38,38)
130	Job Unit Of Measure Code	nvarchar(20)
131	Job Line Type	int
132	Job Unit Price	decimal(38,38)
133	Job Total Price	decimal(38,38)
134	Job Unit Cost	decimal(38,38)
135	Job Total Cost	decimal(38,38)
136	Job Line Discount Amount	decimal(38,38)
137	Job Line Amount	decimal(38,38)
138	Job Total Cost (LCY)	decimal(38,38)
139	Job Line Amount (LCY)	decimal(38,38)
140	Job Currency Factor	decimal(38,38)
141	Job Currency Code	nvarchar(20)
142	Job Planning Line No_	int
143	Job Remaining Qty_	decimal(38,38)
144	Direct Debit Mandate ID	nvarchar(70)
145	Data Exch_ Entry No_	int
146	Payer Information	nvarchar(100)
147	Transaction Information	nvarchar(200)
148	Data Exch_ Line No_	int
149	Applied Automatically	tinyint
150	Deferral Code	nvarchar(20)
151	Deferral Line No_	int
152	Campaign No_	nvarchar(40)
153	Prod_ Order No_	nvarchar(40)
154	FA Posting Date	datetime
155	FA Posting Type	int
156	Depreciation Book Code	nvarchar(20)
157	Salvage Value	decimal(38,38)
158	No_ of Depreciation Days	int
159	Depr_ until FA Posting Date	tinyint
160	Depr_ Acquisition Cost	tinyint
161	Maintenance Code	nvarchar(20)
162	Insurance No_	nvarchar(40)
163	Budgeted FA No_	nvarchar(40)
164	Duplicate in Depreciation Book	nvarchar(20)
165	Use Duplication List	tinyint
166	FA Reclassification Entry	tinyint
167	FA Error Entry No_	int
168	Index Entry	tinyint
169	Source Line No_	int
170	Comment	nvarchar(500)
171	Check Exported	tinyint
172	Check Transmitted	tinyint
173	Account Id	uniqueidentifier
174	Customer Id	uniqueidentifier
175	Applies-to Invoice Id	uniqueidentifier
176	Contact Graph Id	nvarchar(500)
177	Last Modified DateTime	datetime
178	Journal Batch Id	uniqueidentifier
179	Payment Method Id	uniqueidentifier
180	G_L Register No_	int
181	Indentation	int
182	Invoice Receipt Date	datetime
183	$systemId	uniqueidentifier
184	$systemCreatedAt	datetime
185	$systemCreatedBy	uniqueidentifier
186	$systemModifiedAt	datetime
187	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Posted Gen_ Journal Line table

Country_Region Currency IC Partner Job Job Task Payment Method Payment Terms Tax Area Tax Group

Dynamics 365 BC Table Reference Tables Company Tables PPosted Gen_ Journal Line

Leave a Reply Cancel reply