Job G/L Journal – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages JJob G/L Journal

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

Page Name: Job G/L Journal
Page Number: 1020
Page Type: Worksheet

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

Show/hide columns in the Job G/L Journal page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1394164100	CurrentJnlBatchName			true	true	true
1	256714814	Posting Date	5	Posting Date	true	True	true
2	443398147	Document Date	76	Document Date	true	True	false
3	1576501665	Document Type	6	Document Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
4	1054461086	Document No.	7	Document No.	true	True	true
5	2098824701	External Document No.	77	External Document No.	true	True	false
6	2082599151	Account Type	3	Account Type	true	True	true
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
7	1275347536	Account No.	4	Account No.	true	True	true
8	64717696	Description	8	Description	true	True	true
9	1678959099	Business Unit Code	50	Business Unit Code	true	True	false
10	931224828	Salespers./Purch. Code	26	Salespers./Purch. Code	true	True	false
11	1220514649	Campaign No.	5050	Campaign No.	true	True	false
12	1161790932	Currency Code	12	Currency Code	true	True	false
13	1241029148	Gen. Posting Type	57	Gen. Posting Type	true	True	true
	Available options are: ” “ “Purchase” “Sale” “Settlement”
14	663658639	Gen. Bus. Posting Group	58	Gen. Bus. Posting Group	true	True	true
15	665165356	Gen. Prod. Posting Group	59	Gen. Prod. Posting Group	true	True	true
16	964696432	VAT Bus. Posting Group	90	VAT Bus. Posting Group	true	True	false
17	214322725	VAT Prod. Posting Group	91	VAT Prod. Posting Group	true	True	false
18	574184440	VAT %	10	VAT %	true	False	false
19	253443002	Amount	13	Amount	true	True	p1020p1020AmountVisible
20	827189171	Amount (LCY)	16	Amount (LCY)	true	True	p1020p1020AmountVisible
21	1295128908	Debit Amount	14	Debit Amount	true	True	p1020p1020DebitCreditVisible
22	313674575	Credit Amount	15	Credit Amount	true	True	p1020p1020DebitCreditVisible
23	1766878559	VAT Amount	44	VAT Amount	true	True	false
24	867353958	VAT Difference	111	VAT Difference	true	False	false
25	2067929792	Bal. VAT Amount	69	Bal. VAT Amount	true	True	false
26	805823189	Bal. VAT Difference	112	Bal. VAT Difference	true	False	false
27	356528978	Bal. Account Type	63	Bal. Account Type	true	True	true
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
28	1318384185	Bal. Account No.	11	Bal. Account No.	true	True	true
29	1911316125	Bal. Gen. Posting Type	64	Bal. Gen. Posting Type	true	True	true
	Available options are: ” “ “Purchase” “Sale” “Settlement”
30	230508984	Bal. Gen. Bus. Posting Group	65	Bal. Gen. Bus. Posting Group	true	True	true
31	524891011	Bal. Gen. Prod. Posting Group	66	Bal. Gen. Prod. Posting Group	true	True	true
32	902290257	Bal. VAT Bus. Posting Group	92	Bal. VAT Bus. Posting Group	true	True	false
33	303079476	Bal. VAT Prod. Posting Group	93	Bal. VAT Prod. Posting Group	true	True	false
34	1154291219	Bill-to/Pay-to No.	22	Bill-to/Pay-to No.	true	False	false
35	893712624	Ship-to/Order Address Code	110	Ship-to/Order Address Code	true	True	false
36	504741204	Payment Terms Code	47	Payment Terms Code	true	True	false
37	2063958996	Applies-to Doc. Type	35	Applies-to Doc. Type	true	True	false
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
38	1295641067	Applies-to Doc. No.	36	Applies-to Doc. No.	true	True	false
39	908330793	Applies-to ID	48	Applies-to ID	true	True	false
40	1434530760	On Hold	34	On Hold	true	True	false
41	1998561570	Bank Payment Type	70	Bank Payment Type	true	True	false
	Available options are: ” “ “Computer Check” “Manual Check” “Electronic Payment” “Electronic Payment-IAT”
42	872753569	Reason Code	52	Reason Code	true	True	false
43	1019030770	Job No.	42	Job No.	true	True	true
44	1592052245	Job Task No.	1001	Job Task No.	true	True	true
45	947683275	Job Planning Line No.	1020	Job Planning Line No.	true	True	false
46	1589455561	Job Line Type	1009	Job Line Type	true	True	true
	Available options are: ” “ “Budget” “Billable” “Both Budget and Billable”
47	1815068917	Job Unit Of Measure Code	1008	Job Unit Of Measure Code	true	True	false
48	1954930230	Job Quantity	1004	Job Quantity	true	True	true
49	1369042532	Job Unit Cost	1012	Job Unit Cost	true	False	true
50	293169267	Job Unit Cost (LCY)	1005	Job Unit Cost (LCY)	true	False	true
51	1477787224	Job Total Cost	1013	Job Total Cost	true	False	true
52	1772570065	Job Total Cost (LCY)	1016	Job Total Cost (LCY)	true	False	true
53	1764957934	Job Unit Price	1010	Job Unit Price	true	True	true
54	705417723	Job Unit Price (LCY)	1002	Job Unit Price (LCY)	true	False	false
55	1661048429	Job Line Amount	1015	Job Line Amount	true	True	true
56	176818060	Job Line Amount (LCY)	1017	Job Line Amount (LCY)	true	False	true
57	574870806	Job Line Discount Amount	1014	Job Line Discount Amount	true	True	true
58	662505625	Job Line Discount %	1006	Job Line Discount %	true	True	true
59	1122790478	Job Total Price	1011	Job Total Price	true	False	false
60	1675277127	Job Total Price (LCY)	1003	Job Total Price (LCY)	true	False	true
61	942283289	Job Remaining Qty.	1030	Job Remaining Qty.	true	True	false
62	244329700	Job Queue Status	160	Job Queue Status	true	False	p1020p1020JobQueuesUsed
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
63	1301046840	Correction	73	Correction	true	True	false
64	1325874002	Shortcut Dimension 1 Code	24	Shortcut Dimension 1 Code	true	True	p1020p1020DimVisible1
65	1573180847	Shortcut Dimension 2 Code	25	Shortcut Dimension 2 Code	true	True	p1020p1020DimVisible2
66	1887303320	ShortcutDimCode3			true	true	p1020p1020DimVisible3
67	1718394297	ShortcutDimCode4			true	true	p1020p1020DimVisible4
68	1938876382	ShortcutDimCode5			true	true	p1020p1020DimVisible5
69	1301179765	ShortcutDimCode6			true	true	p1020p1020DimVisible6
70	663483148	ShortcutDimCode7			true	true	p1020p1020DimVisible7
71	780819109	ShortcutDimCode8			true	true	p1020p1020DimVisible8
72	42262096	AccName			true	false	0
73	2044376871	BalAccName			true	false	0
74	1736657912	Balance			true	false	p1020p1020BalanceVisible
75	841512406	TotalBalance			true	false	p1020p1020TotalBalanceVisible

Dynamics 365 BC Table Reference Pages JJob G/L Journal

Show/hide columns in the Job G/L Journal page

Leave a Reply Cancel reply