Gen. Journal Line Entity – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages GGen. Journal Line Entity

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

Page Name: Gen. Journal Line Entity
Page Number: 6407
Page Type: List

Source Table Name: Gen. Journal Line
Source Table Number: 81

Show/hide columns in the Gen. Journal Line Entity page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1703627374	journalTemplateName	1	Journal Template Name	true	True	true
1	371778899	lineNumber	2	Line No.	true	True	true
2	1638432457	accountType	3	Account Type	true	True	true
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
3	1407298618	accountNumber	4	Account No.	true	True	true
4	1429933084	postingDate	5	Posting Date	true	True	true
5	2036198281	documentType	6	Document Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
6	86399764	documentNumber	7	Document No.	true	True	true
7	2124023458	description	8	Description	true	True	true
8	1713465088	vatPercent	10	VAT %	true	False	true
9	1053016989	balAccountNumber	11	Bal. Account No.	true	True	true
10	1829180302	currencyCode	12	Currency Code	true	True	true
11	374251668	amount	13	Amount	true	True	true
12	1870471126	debitAmount	14	Debit Amount	true	True	true
13	283481463	creditAmount	15	Credit Amount	true	True	true
14	24840346	amountLcy	16	Amount (LCY)	true	True	true
15	1323177080	balanceLcy	17	Balance (LCY)	true	False	true
16	171618678	currencyFactor	18	Currency Factor	true	False	true
17	284941438	salesPurchLcy	19	Sales/Purch. (LCY)	true	True	true
18	1033351840	profitLcy	20	Profit (LCY)	true	True	true
19	1515663206	invDiscountLcy	21	Inv. Discount (LCY)	true	True	true
20	995149104	billToPayToNumber	22	Bill-to/Pay-to No.	true	False	true
21	898484519	postingGroup	23	Posting Group	true	True	true
22	427050460	shortcutDimension1Code	24	Shortcut Dimension 1 Code	true	True	true
23	1251844177	shortcutDimension2Code	25	Shortcut Dimension 2 Code	true	True	true
24	727936555	salespersPurchCode	26	Salespers./Purch. Code	true	True	true
25	2018462424	sourceCode	29	Source Code	true	False	true
26	951487831	systemCreatedEntry	30	System-Created Entry	true	False	true
27	1454852046	onHold	34	On Hold	true	True	true
28	642692977	appliesToDocType	35	Applies-to Doc. Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
29	1924659602	appliesToDocNumber	36	Applies-to Doc. No.	true	True	true
30	1538605600	dueDate	38	Due Date	true	True	true
31	2002325872	pmtDiscountDate	39	Pmt. Discount Date	true	True	true
32	398208076	paymentDiscountPercent	40	Payment Discount %	true	True	true
33	1843592156	jobNumber	42	Job No.	true	True	true
34	1565838347	quantity	43	Quantity	true	True	true
35	888411177	vatAmount	44	VAT Amount	true	True	true
36	755883309	vatPosting	45	VAT Posting	true	False	true
	Available options are: “Automatic VAT Entry” “Manual VAT Entry”
37	515535286	paymentTermsCode	47	Payment Terms Code	true	True	true
38	1378014364	appliesToId	48	Applies-to ID	true	True	true
39	1321834139	businessUnitCode	50	Business Unit Code	true	True	true
40	310332978	journalBatchName	51	Journal Batch Name	true	True	true
41	1364393791	reasonCode	52	Reason Code	true	True	true
42	1979837462	recurringMethod	53	Recurring Method	true	True	true
	Available options are: ” “ “F Fixed” “V Variable” “B Balance” “RF Reversing Fixed” “RV Reversing Variable” “RB Reversing Balance” “BD Balance by Dimension” “RBD Reversing Balance by Dimension”
43	1652358065	expirationDate	54	Expiration Date	true	True	true
44	168034571	recurringFrequency	55	Recurring Frequency	true	True	true
45	1690480049	allocatedAmtLcy	56	Allocated Amt. (LCY)	true	False	true
46	2068424796	genPostingType	57	Gen. Posting Type	true	True	true
	Available options are: ” “ “Purchase” “Sale” “Settlement”
47	1815247361	genBusPostingGroup	58	Gen. Bus. Posting Group	true	True	true
48	140553974	genProdPostingGroup	59	Gen. Prod. Posting Group	true	True	true
49	197327886	vatCalculationType	60	VAT Calculation Type	true	False	true
	Available options are: “Normal VAT” “Reverse Charge VAT” “Full VAT” “Sales Tax”
50	551950523	eu3PartyTrade	61	EU 3-Party Trade	true	False	true
51	1173596819	allowApplication	62	Allow Application	true	True	true
52	222465666	balAccountType	63	Bal. Account Type	true	True	true
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
53	95343445	balGenPostingType	64	Bal. Gen. Posting Type	true	True	true
	Available options are: ” “ “Purchase” “Sale” “Settlement”
54	2026519392	balGenBusPostingGroup	65	Bal. Gen. Bus. Posting Group	true	True	true
55	1273459485	balGenProdPostingGroup	66	Bal. Gen. Prod. Posting Group	true	True	true
56	2070524669	balVatCalculationType	67	Bal. VAT Calculation Type	true	False	true
	Available options are: “Normal VAT” “Reverse Charge VAT” “Full VAT” “Sales Tax”
57	894987313	balVatPercent	68	Bal. VAT %	true	False	true
58	1064079488	balVatAmount	69	Bal. VAT Amount	true	True	true
59	698825204	bankPaymentType	70	Bank Payment Type	true	True	true
	Available options are: ” “ “Computer Check” “Manual Check” “Electronic Payment” “Electronic Payment-IAT”
60	716418766	vatBaseAmount	71	VAT Base Amount	true	True	true
61	1338672581	balVatBaseAmount	72	Bal. VAT Base Amount	true	True	true
62	1983194790	correction	73	Correction	true	True	true
63	797153102	checkPrinted	75	Check Printed	true	False	true
64	962197867	documentDate	76	Document Date	true	True	true
65	795517007	externalDocumentNumber	77	External Document No.	true	True	true
66	1149680957	sourceType	78	Source Type	true	True	true
	Available options are: ” “ “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee”
67	278382286	sourceNumber	79	Source No.	true	True	true
68	1043918464	postingNumberSeries	80	Posting No. Series	true	True	true
69	1530381417	taxAreaCode	82	Tax Area Code	true	True	true
70	1371203642	taxLiable	83	Tax Liable	true	True	true
71	1094362975	taxGroupCode	84	Tax Group Code	true	True	true
72	481830018	useTax	85	Use Tax	true	True	true
73	949146096	balTaxAreaCode	86	Bal. Tax Area Code	true	True	true
74	182155715	balTaxLiable	87	Bal. Tax Liable	true	True	true
75	276568096	balTaxGroupCode	88	Bal. Tax Group Code	true	True	true
76	1603441761	balUseTax	89	Bal. Use Tax	true	True	true
77	1950857824	vatBusPostingGroup	90	VAT Bus. Posting Group	true	True	true
78	1151732771	vatProdPostingGroup	91	VAT Prod. Posting Group	true	True	true
79	66076319	balVatBusPostingGroup	92	Bal. VAT Bus. Posting Group	true	True	true
80	597242262	balVatProdPostingGroup	93	Bal. VAT Prod. Posting Group	true	True	true
81	473126426	additionalCurrencyPosting	95	Additional-Currency Posting	true	False	true
	Available options are: “None” “Amount Only” “Additional-Currency Amount Only”
82	826906444	faAddCurrencyFactor	98	FA Add.-Currency Factor	true	True	true
83	363444401	sourceCurrencyCode	99	Source Currency Code	true	False	true
84	1509029038	sourceCurrencyAmount	100	Source Currency Amount	true	False	true
85	1819463207	sourceCurrVatBaseAmount	101	Source Curr. VAT Base Amount	true	False	true
86	1235959548	sourceCurrVatAmount	102	Source Curr. VAT Amount	true	False	true
87	1135095504	vatBaseDiscountPercent	103	VAT Base Discount %	true	False	true
88	1569366095	vatAmountLcy	104	VAT Amount (LCY)	true	False	true
89	790293940	vatBaseAmountLcy	105	VAT Base Amount (LCY)	true	False	true
90	1935761870	balVatAmountLcy	106	Bal. VAT Amount (LCY)	true	False	true
91	26309587	balVatBaseAmountLcy	107	Bal. VAT Base Amount (LCY)	true	False	true
92	1777075393	reversingEntry	108	Reversing Entry	true	False	true
93	171121175	allowZeroAmountPosting	109	Allow Zero-Amount Posting	true	False	true
94	97468540	shipToOrderAddressCode	110	Ship-to/Order Address Code	true	True	true
95	417737196	vatDifference	111	VAT Difference	true	False	true
96	1074648085	balVatDifference	112	Bal. VAT Difference	true	False	true
97	151561351	icPartnerCode	113	IC Partner Code	true	False	true
98	1794635679	icDirection	114	IC Direction	true	True	true
	Available options are: “Outgoing” “Incoming”
99	1314878685	icPartnerGLAccNumber	116	IC Partner G/L Acc. No.	true	True	true
100	1388763451	icPartnerTransactionNumber	117	IC Partner Transaction No.	true	False	true
101	1628651381	icAccountType	130	IC Account Type	true	True	true
	Available options are: “G/L Account” “Bank Account”
102	382897594	icAccountNo	131	IC Account No.	true	True	true
103	867128206	sellToBuyFromNumber	118	Sell-to/Buy-from No.	true	True	true
104	1236286801	vatRegistrationNumber	119	VAT Registration No.	true	True	true
105	736132461	countryRegionCode	120	Country/Region Code	true	True	true
106	1768088635	prepayment	121	Prepayment	true	True	true
107	1278853579	financialVoid	122	Financial Void	true	False	true
108	1665925862	incomingDocumentEntryNumber	165	Incoming Document Entry No.	true	True	true
109	1670041245	creditorNumber	170	Creditor No.	true	True	true
110	1520183855	paymentReference	171	Payment Reference	true	True	true
111	287080248	paymentMethodCode	172	Payment Method Code	true	True	true
112	1425817709	appliesToExtDocNumber	173	Applies-to Ext. Doc. No.	true	True	true
113	717006740	recipientBankAccount	288	Recipient Bank Account	true	True	true
114	1100400731	messageToRecipient	289	Message to Recipient	true	True	true
115	1579865370	exportedToPaymentFile	290	Exported to Payment File	true	False	true
116	1384578708	hasPaymentExportError	291	Has Payment Export Error	true	False	true
117	886758737	dimensionSetId	480	Dimension Set ID	true	False	true
118	993987289	jobTaskNumber	1001	Job Task No.	true	True	true
119	1031936242	jobUnitPriceLcy	1002	Job Unit Price (LCY)	true	False	true
120	1596417314	jobTotalPriceLcy	1003	Job Total Price (LCY)	true	False	true
121	134938628	jobQuantity	1004	Job Quantity	true	True	true
122	367073468	jobUnitCostLcy	1005	Job Unit Cost (LCY)	true	False	true
123	1748334279	jobLineDiscountPercent	1006	Job Line Discount %	true	True	true
124	572727074	jobLineDiscAmountLcy	1007	Job Line Disc. Amount (LCY)	true	False	true
125	1175802075	jobUnitOfMeasureCode	1008	Job Unit Of Measure Code	true	True	true
126	514981255	jobLineType	1009	Job Line Type	true	True	true
	Available options are: ” “ “Budget” “Billable” “Both Budget and Billable”
127	1082996468	jobUnitPrice	1010	Job Unit Price	true	True	true
128	488812080	jobTotalPrice	1011	Job Total Price	true	False	true
129	437605258	jobUnitCost	1012	Job Unit Cost	true	False	true
130	437079434	jobTotalCost	1013	Job Total Cost	true	False	true
131	1518985576	jobLineDiscountAmount	1014	Job Line Discount Amount	true	True	true
132	481187555	jobLineAmount	1015	Job Line Amount	true	True	true
133	1406299032	jobTotalCostLcy	1016	Job Total Cost (LCY)	true	False	true
134	1133272651	jobLineAmountLcy	1017	Job Line Amount (LCY)	true	False	true
135	680429021	jobCurrencyFactor	1018	Job Currency Factor	true	True	true
136	946364661	jobCurrencyCode	1019	Job Currency Code	true	True	true
137	608579991	jobPlanningLineNumber	1020	Job Planning Line No.	true	True	true
138	2121653375	jobRemainingQty	1030	Job Remaining Qty.	true	True	true
139	1978574664	directDebitMandateId	1200	Direct Debit Mandate ID	true	True	true
140	436014447	dataExchEntryNumber	1220	Data Exch. Entry No.	true	False	true
141	1300070845	payerInformation	1221	Payer Information	true	True	true
142	739265016	transactionInformation	1222	Transaction Information	true	True	true
143	248300037	dataExchLineNumber	1223	Data Exch. Line No.	true	False	true
144	226158752	appliedAutomatically	1224	Applied Automatically	true	True	true
145	1837879958	deferralCode	1700	Deferral Code	true	True	true
146	1580035198	deferralLineNumber	1701	Deferral Line No.	true	True	true
147	2108283181	campaignNumber	5050	Campaign No.	true	True	true
148	1950877404	prodOrderNumber	5400	Prod. Order No.	true	False	true
149	1585472085	faPostingDate	5600	FA Posting Date	true	True	true
150	411852983	faPostingType	5601	FA Posting Type	true	True	true
	Available options are: ” “ “Acquisition Cost” “Depreciation” “Write-Down” “Appreciation” “Custom 1” “Custom 2” “Disposal” “Maintenance”
151	601430019	depreciationBookCode	5602	Depreciation Book Code	true	True	true
152	1506934640	salvageValue	5603	Salvage Value	true	True	true
153	740535236	numberOfDepreciationDays	5604	No. of Depreciation Days	true	True	true
154	436872034	deprUntilFaPostingDate	5605	Depr. until FA Posting Date	true	True	true
155	1246275561	deprAcquisitionCost	5606	Depr. Acquisition Cost	true	True	true
156	1671327776	maintenanceCode	5609	Maintenance Code	true	True	true
157	688822689	insuranceNumber	5610	Insurance No.	true	True	true
158	1205698088	budgetedFaNumber	5611	Budgeted FA No.	true	True	true
159	1476864200	duplicateInDepreciationBook	5612	Duplicate in Depreciation Book	true	True	true
160	215482251	useDuplicationList	5613	Use Duplication List	true	True	true
161	1361864078	faReclassificationEntry	5614	FA Reclassification Entry	true	True	true
162	802815512	faErrorEntryNumber	5615	FA Error Entry No.	true	True	true
163	1837510630	indexEntry	5616	Index Entry	true	True	true
164	2024606336	sourceLineNumber	5617	Source Line No.	true	True	true
165	1980316989	comment	5618	Comment	true	True	true
166	823461157	checkExported	5701	Check Exported	true	True	true
167	1528490593	checkTransmitted	5702	Check Transmitted	true	True	true
168	1217060373	id	2000000000	$systemId	true	False	true
169	1693396636	accountId	8001	Account Id	true	True	true
170	436485983	customerId	8002	Customer Id	true	True	true
171	479940787	appliesToInvoiceId	8003	Applies-to Invoice Id	true	True	true
172	734224553	contactGraphId	8004	Contact Graph Id	true	True	true
173	409484722	lastModifiedDatetime	8005	Last Modified DateTime	true	True	true
174	241716072	journalBatchId	8006	Journal Batch Id	true	True	true

Dynamics 365 BC Table Reference Pages GGen. Journal Line Entity

Show/hide columns in the Gen. Journal Line Entity page

Leave a Reply Cancel reply