Sales Journal – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages SSales Journal

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

Page Name: Sales Journal
Page Number: 253
Page Type: Worksheet

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

Show/hide columns in the Sales Journal page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	962445203	CurrentJnlBatchName			true	true	true
1	2039728853	Posting Date	5	Posting Date	true	True	true
2	270462384	VAT Reporting Date	128	VAT Reporting Date	true	p253p253VATDateEnabled	p253p253VATDateEnabled
3	1437925858	Document Date	76	Document Date	true	True	false
4	499515374	Document Type	6	Document Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
5	47175801	Document No.	7	Document No.	true	True	true
6	1003988795	Incoming Document Entry No.	165	Incoming Document Entry No.	true	True	false
7	1716231948	External Document No.	77	External Document No.	true	True	false
8	714339080	Account Type	3	Account Type	true	True	not p253p253IsSimplePage
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
9	677366143	Account No.	4	Account No.	true	True	true
10	1872296176				true	false	true
11	534084431	Description	8	Description	true	True	true
12	518748317	Salespers./Purch. Code	26	Salespers./Purch. Code	true	True	false
13	135469024	Campaign No.	5050	Campaign No.	true	True	false
14	1250135717	Currency Code	12	Currency Code	true	True	false
15	1729164955	Gen. Posting Type	57	Gen. Posting Type	true	True	not p253p253IsSimplePage
	Available options are: ” “ “Purchase” “Sale” “Settlement”
16	1197923262	Gen. Bus. Posting Group	58	Gen. Bus. Posting Group	true	True	not p253p253IsSimplePage
17	409814539	Gen. Prod. Posting Group	59	Gen. Prod. Posting Group	true	True	not p253p253IsSimplePage
18	873935367	VAT Bus. Posting Group	90	VAT Bus. Posting Group	true	True	false
19	1931914934	VAT Prod. Posting Group	91	VAT Prod. Posting Group	true	True	false
20	35292522	DocumentAmount			true	true	true
21	1112098339	Amount	13	Amount	true	True	p253p253AmountVisible
22	1463246938	Amount (LCY)	16	Amount (LCY)	true	True	p253p253AmountVisible
23	1865477261	Debit Amount	14	Debit Amount	true	True	p253p253DebitCreditVisible
24	776394224	Credit Amount	15	Credit Amount	true	True	p253p253DebitCreditVisible
25	1957869477	Tax Liable	83	Tax Liable	true	True	false
26	150148030	Tax Area Code	82	Tax Area Code	true	True	false
27	1883869922	Tax Group Code	84	Tax Group Code	true	True	false
28	243385430	VAT Amount	44	VAT Amount	true	True	false
29	955872285	VAT Difference	111	VAT Difference	true	False	false
30	663662063	Bal. VAT Amount	69	Bal. VAT Amount	true	True	false
31	1297369780	Bal. VAT Difference	112	Bal. VAT Difference	true	False	false
32	788980335	Bal. Account Type	63	Bal. Account Type	true	True	not p253p253IsSimplePage
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
33	1002475118	Bal. Account No.	11	Bal. Account No.	true	True	true
34	355640694	Bal. Gen. Posting Type	64	Bal. Gen. Posting Type	true	True	not p253p253IsSimplePage
	Available options are: ” “ “Purchase” “Sale” “Settlement”
35	1353254641	Bal. Gen. Bus. Posting Group	65	Bal. Gen. Bus. Posting Group	true	True	not p253p253IsSimplePage
36	504333854	Bal. Gen. Prod. Posting Group	66	Bal. Gen. Prod. Posting Group	true	True	not p253p253IsSimplePage
37	367640866	Bal. VAT Bus. Posting Group	92	Bal. VAT Bus. Posting Group	true	True	false
38	253912725	Bal. VAT Prod. Posting Group	93	Bal. VAT Prod. Posting Group	true	True	false
39	720819338	Posting Group	23	Posting Group	true	p253p253IsPostingGroupEditable	p253p253IsPostingGroupEditable
40	1095378362	Bill-to/Pay-to No.	22	Bill-to/Pay-to No.	true	False	false
41	1981250535	Ship-to/Order Address Code	110	Ship-to/Order Address Code	true	True	false
42	695167173	Sales/Purch. (LCY)	19	Sales/Purch. (LCY)	true	True	false
43	1277917104	Profit (LCY)	20	Profit (LCY)	true	True	false
44	345641316	Inv. Discount (LCY)	21	Inv. Discount (LCY)	true	True	false
45	2018889509	Payment Terms Code	47	Payment Terms Code	true	True	false
46	1115891735	Due Date	38	Due Date	true	True	false
47	798070615	Pmt. Discount Date	39	Pmt. Discount Date	true	True	false
48	240645907	Payment Discount %	40	Payment Discount %	true	True	false
49	1640495861	Applies-to Doc. Type	35	Applies-to Doc. Type	true	True	not p253p253IsSimplePage
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
50	1304942028	Applies-to Doc. No.	36	Applies-to Doc. No.	true	True	not p253p253IsSimplePage
51	1710312488	Applies-to ID	48	Applies-to ID	true	True	false
52	857745879	On Hold	34	On Hold	true	True	false
53	117413680	Reason Code	52	Reason Code	true	True	false
54	594159089	Correction	73	Correction	true	True	true
55	1410344690	Comment	5618	Comment	true	True	false
56	44148577	Direct Debit Mandate ID	1200	Direct Debit Mandate ID	true	True	false
57	370256947	Job Queue Status	160	Job Queue Status	true	False	p253p253JobQueuesUsed
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
58	1585021677	Shortcut Dimension 1 Code	24	Shortcut Dimension 1 Code	true	True	p253p253DimVisible1
59	622409586	Shortcut Dimension 2 Code	25	Shortcut Dimension 2 Code	true	True	p253p253DimVisible2
60	2007198639	ShortcutDimCode3			true	true	p253p253DimVisible3
61	1838289616	ShortcutDimCode4			true	true	p253p253DimVisible4
62	1818981063	ShortcutDimCode5			true	true	p253p253DimVisible5
63	1181284446	ShortcutDimCode6			true	true	p253p253DimVisible6
64	543587829	ShortcutDimCode7			true	true	p253p253DimVisible7
65	900714428	ShortcutDimCode8			true	true	p253p253DimVisible8
66	1818082188	NumberOfJournalRecords			true	false	true
67	611117087	AccName			true	false	0
68	1705908032	BalAccName			true	false	0
69	857287095	Balance			true	false	p253p253BalanceVisible
70	646561747	TotalBalance			true	false	p253p253TotalBalanceVisible

Dynamics 365 BC Table Reference Pages SSales Journal

Show/hide columns in the Sales Journal page

Leave a Reply Cancel reply