General Journal – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages GGeneral Journal

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

Page Name: General Journal
Page Number: 39
Page Type: Worksheet

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

Show/hide columns in the General Journal page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	807646869	CurrentJnlBatchName			true	true	true
1	1181351640				true	true	p39p39IsSimplePage
2	2120209864				true	true	p39p39IsSimplePage
3	1624656426				true	true	p39p39IsSimplePage
4	1984109836	GenJnlBatchApprovalStatus			true	false	p39p39EnabledGenJnlBatchWorkflowsExist
5	1583728259	Posting Date	5	Posting Date	true	True	NOT p39p39IsSimplePage
6	171469978	VAT Reporting Date	128	VAT Reporting Date	true	p39p39VATDateEnabled	( not p39p39IsSimplePage ) and p39p39VATDateEnable
7	769423964	Document Date	76	Document Date	true	True	false
8	423721144	Document Type	6	Document Type	true	True	NOT p39p39IsSimplePage
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
9	674314385	Document No.	7	Document No.	true	True	NOT p39p39IsSimplePage
10	608971709	Incoming Document Entry No.	165	Incoming Document Entry No.	true	True	false
11	1701551798	External Document No.	77	External Document No.	true	True	false
12	570094069	Applies-to Ext. Doc. No.	173	Applies-to Ext. Doc. No.	true	True	false
13	746671918	Account Type	3	Account Type	true	True	NOT p39p39IsSimplePage
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
14	367071417	Account No.	4	Account No.	true	True	true
15	47079313	AccountName			true	false	true
16	1668971326	GenJnlLineApprovalStatus			true	false	p39p39EnabledGenJnlLineWorkflowsExist
17	1769122199	Description	8	Description	true	True	true
18	2012172404	Payer Information	1221	Payer Information	true	True	false
19	2081316145	Transaction Information	1222	Transaction Information	true	True	false
20	169622186	Business Unit Code	50	Business Unit Code	true	True	false
21	1873566613	Salespers./Purch. Code	26	Salespers./Purch. Code	true	True	false
22	255016490	Campaign No.	5050	Campaign No.	true	True	false
23	1445502467	Currency Code	12	Currency Code	true	True	NOT p39p39IsSimplePage
24	660195097	EU 3-Party Trade	61	EU 3-Party Trade	true	False	NOT p39p39IsSimplePage
25	316028189	Gen. Posting Type	57	Gen. Posting Type	true	True	NOT p39p39IsSimplePage
	Available options are: ” “ “Purchase” “Sale” “Settlement”
26	162047944	Gen. Bus. Posting Group	58	Gen. Bus. Posting Group	true	True	NOT p39p39IsSimplePage
27	808468739	Gen. Prod. Posting Group	59	Gen. Prod. Posting Group	true	True	NOT p39p39IsSimplePage
28	39934511	VAT Bus. Posting Group	90	VAT Bus. Posting Group	true	True	false
29	695636404	VAT Prod. Posting Group	91	VAT Prod. Posting Group	true	True	false
30	1333874716	Quantity	43	Quantity	true	True	false
31	1799768629	Amount	13	Amount	true	True	p39p39AmountVisible
32	372932244	Amount (LCY)	16	Amount (LCY)	true	True	p39p39AmountVisible
33	1064315685	Debit Amount	14	Debit Amount	true	True	p39p39DebitCreditVisible
34	581358582	Credit Amount	15	Credit Amount	true	True	p39p39DebitCreditVisible
35	1923582656	VAT Amount	44	VAT Amount	true	True	false
36	988759979	VAT Difference	111	VAT Difference	true	False	false
37	144985257	Bal. VAT Amount	69	Bal. VAT Amount	true	True	false
38	232262414	Bal. VAT Difference	112	Bal. VAT Difference	true	False	false
39	19505143	Bal. Account Type	63	Bal. Account Type	true	True	NOT p39p39IsSimplePage
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
40	1525776440	Bal. Account No.	11	Bal. Account No.	true	True	NOT p39p39IsSimplePage
41	1301811620	Bal. Gen. Posting Type	64	Bal. Gen. Posting Type	true	True	NOT p39p39IsSimplePage
	Available options are: ” “ “Purchase” “Sale” “Settlement”
42	1535155111	Bal. Gen. Bus. Posting Group	65	Bal. Gen. Bus. Posting Group	true	True	NOT p39p39IsSimplePage
43	793068644	Bal. Gen. Prod. Posting Group	66	Bal. Gen. Prod. Posting Group	true	True	NOT p39p39IsSimplePage
44	1793359785	Allocation Account No.	2676	Selected Alloc. Account No.	true	True	p39p39UseAllocationAccountNumber
45	571875093	Deferral Code	1700	Deferral Code	true	True	NOT p39p39IsSimplePage
46	1995536347	Job Queue Status	160	Job Queue Status	true	False	p39p39JobQueuesUsed
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
47	1290617928	Bal. VAT Bus. Posting Group	92	Bal. VAT Bus. Posting Group	true	True	false
48	1293323901	Bal. VAT Prod. Posting Group	93	Bal. VAT Prod. Posting Group	true	True	false
49	1346222068	Bill-to/Pay-to No.	22	Bill-to/Pay-to No.	true	False	false
50	1204977903	Ship-to/Order Address Code	110	Ship-to/Order Address Code	true	True	false
51	1168477875	Payment Terms Code	47	Payment Terms Code	true	True	false
52	309097327	Applied Automatically	1224	Applied Automatically	true	false	false
53	2123041770	Applied			true	False	false
54	1288446531	Applies-to Doc. Type	35	Applies-to Doc. Type	true	True	false
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
55	676157842	Applies-to Doc. No.	36	Applies-to Doc. No.	true	True	false
56	2132762914	Applies-to ID	48	Applies-to ID	true	True	false
57	1599151601	On Hold	34	On Hold	true	True	false
58	1070699003	Bank Payment Type	70	Bank Payment Type	true	True	false
	Available options are: ” “ “Computer Check” “Manual Check” “Electronic Payment” “Electronic Payment-IAT”
59	261935306	Reason Code	52	Reason Code	true	True	false
60	1798497543	Correction	73	Correction	true	True	NOT p39p39IsSimplePage
61	1700244268	Comment	5618	Comment	true	True	NOT p39p39IsSimplePage
62	1265043271	Direct Debit Mandate ID	1200	Direct Debit Mandate ID	true	True	false
63	686015179	Shortcut Dimension 1 Code	24	Shortcut Dimension 1 Code	true	True	p39p39DimVisible1
64	673347752	Shortcut Dimension 2 Code	25	Shortcut Dimension 2 Code	true	True	p39p39DimVisible2
65	928610457	ShortcutDimCode3			true	true	p39p39DimVisible3
66	177873754	ShortcutDimCode4			true	true	p39p39DimVisible4
67	459822863	ShortcutDimCode5			true	true	p39p39DimVisible5
68	1453266988	ShortcutDimCode6			true	true	p39p39DimVisible6
69	815570371	ShortcutDimCode7			true	true	p39p39DimVisible7
70	1922054582	ShortcutDimCode8			true	true	p39p39DimVisible8
71	1065110458	NumberOfJournalRecords			true	false	true
72	375096807	AccName			true	false	0
73	1496064106	BalAccName			true	false	0
74	1922270633	DisplayTotalDebit			true	False	true
75	1429834606	DisplayTotalCredit			true	False	true
76	2052041967	Balance			true	false	p39p39BalanceVisible
77	561985499	TotalBalance			true	false	p39p39TotalBalanceVisible

Dynamics 365 BC Table Reference Pages GGeneral Journal

Show/hide columns in the General Journal page

Leave a Reply Cancel reply