Payment Journal – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages PPayment Journal

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

Page Name: Payment Journal
Page Number: 256
Page Type: Worksheet

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

Show/hide columns in the Payment Journal page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	733648854	CurrentJnlBatchName			true	true	true
1	498192952	Posting Date	5	Posting Date	true	True	true
2	182954537	Document Date	76	Document Date	true	True	false
3	31369707	Invoice Receipt Date	10500		true	True	false
4	2006575158	Invoice Received Date	175	Invoice Received Date	true	True	false
5	1474424853	Document Type	6	Document Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
6	1084736084	Document No.	7	Document No.	true	True	true
7	1580204654	Incoming Document Entry No.	165	Incoming Document Entry No.	true	True	false
8	565307367	External Document No.	77	External Document No.	true	True	true
9	1401669618	Applies-to Ext. Doc. No.	173	Applies-to Ext. Doc. No.	true	True	false
10	253539371	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”
11	1831670026	Account No.	4	Account No.	true	True	true
12	490669312	Recipient Bank Account	288	Recipient Bank Account	true	True	true
13	1714601287	Message to Recipient	289	Message to Recipient	true	True	true
14	40874934	Description	8	Description	true	True	true
15	1646300802	Salespers./Purch. Code	26	Salespers./Purch. Code	true	True	false
16	1875809027	Campaign No.	5050	Campaign No.	true	True	false
17	1768927954	Currency Code	12	Currency Code	true	True	true
18	770452434	Gen. Posting Type	57	Gen. Posting Type	true	True	false
	Available options are: ” “ “Purchase” “Sale” “Settlement”
19	10769621	Gen. Bus. Posting Group	58	Gen. Bus. Posting Group	true	True	false
20	1090601190	Gen. Prod. Posting Group	59	Gen. Prod. Posting Group	true	True	false
21	635731674	VAT Bus. Posting Group	90	VAT Bus. Posting Group	true	True	false
22	1802849649	VAT Prod. Posting Group	91	VAT Prod. Posting Group	true	True	false
23	1480988467	Posting Group	23	Posting Group	true	p256p256IsPostingGroupEditable	p256p256IsPostingGroupEditable
24	456618540	Payment Method Code	172	Payment Method Code	true	True	true
25	365680555	Payment Reference	171	Payment Reference	true	True	true
26	211371075	Creditor No.	170	Creditor No.	true	True	true
27	1968162784	Amount	13	Amount	true	True	p256p256AmountVisible
28	511953417	Amount (LCY)	16	Amount (LCY)	true	True	p256p256AmountVisible
29	684887470	Debit Amount	14	Debit Amount	true	True	p256p256DebitCreditVisible
30	971177781	Credit Amount	15	Credit Amount	true	True	p256p256DebitCreditVisible
31	892685589	VAT Amount	44	VAT Amount	true	True	false
32	1895667152	VAT Difference	111	VAT Difference	true	False	false
33	823360166	Bal. VAT Amount	69	Bal. VAT Amount	true	True	false
34	600926543	Bal. VAT Difference	112	Bal. VAT Difference	true	False	false
35	370447132	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”
36	70922147	Bal. Account No.	11	Bal. Account No.	true	True	true
37	1468296681	Bal. Gen. Posting Type	64	Bal. Gen. Posting Type	true	True	false
	Available options are: ” “ “Purchase” “Sale” “Settlement”
38	92234302	Bal. Gen. Bus. Posting Group	65	Bal. Gen. Bus. Posting Group	true	True	false
39	2090196807	Bal. Gen. Prod. Posting Group	66	Bal. Gen. Prod. Posting Group	true	True	false
40	2134304811	Bal. VAT Bus. Posting Group	92	Bal. VAT Bus. Posting Group	true	True	false
41	1493219866	Bal. VAT Prod. Posting Group	93	Bal. VAT Prod. Posting Group	true	True	false
42	1427539369	Applied (Yes/No)			true	False	true
43	531077578	Applies-to Doc. Type	35	Applies-to Doc. Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
44	1951141628	AppliesToDocNo	36	Applies-to Doc. No.	true	True	true
45	2089654131	Applies-to ID	48	Applies-to ID	true	True	false
46	259657395	GetAppliesToDocDueDate			true	False	true
47	1477862712	Bank Payment Type	70	Bank Payment Type	true	True	true
	Available options are: ” “ “Computer Check” “Manual Check” “Electronic Payment” “Electronic Payment-IAT”
48	58903286	Check Printed	75	Check Printed	true	False	false
49	1173064309	Reason Code	52	Reason Code	true	True	false
50	741734354	Correction	73	Correction	true	True	true
51	448347173	CommentField	5618	Comment	true	True	false
52	597877894	Exported to Payment File	290	Exported to Payment File	true	False	true
53	832134785	TotalExportedAmount			true	False	true
54	1970158184	Has Payment Export Error	291	Has Payment Export Error	true	False	true
55	1907667650	Job Queue Status	160	Job Queue Status	true	False	p256p256JobQueuesUsed
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
56	713078712	Shortcut Dimension 1 Code	24	Shortcut Dimension 1 Code	true	True	p256p256DimVisible1
57	658834581	Shortcut Dimension 2 Code	25	Shortcut Dimension 2 Code	true	True	p256p256DimVisible2
58	615658126	ShortcutDimCode3			true	true	p256p256DimVisible3
59	1297431725	ShortcutDimCode4			true	true	p256p256DimVisible4
60	659735108	ShortcutDimCode5			true	true	p256p256DimVisible5
61	1722142337	ShortcutDimCode6			true	true	p256p256DimVisible6
62	1935128342	ShortcutDimCode7			true	true	p256p256DimVisible7
63	446749103	ShortcutDimCode8			true	true	p256p256DimVisible8
64	1838192936	Remit-to Code	1000	Remit-to Code	true	True	true
65	1223106991	NumberOfJournalRecords			true	false	true
66	1864769062	AccName			true	false	0
67	658264557	BalAccName			true	false	0
68	162110402	Balance			true	false	p256p256BalanceVisible
69	1748895328	TotalBalance			true	false	p256p256TotalBalanceVisible

Dynamics 365 BC Table Reference Pages PPayment Journal

Show/hide columns in the Payment Journal page

Leave a Reply Cancel reply