Purchase Journal – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages PPurchase Journal

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

Page Name: Purchase Journal
Page Number: 254
Page Type: Worksheet

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

Show/hide columns in the Purchase Journal page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	1690569356	CurrentJnlBatchName			true	true	true
1	1758967290	Posting Date	5	Posting Date	true	True	true
2	1570869265	VAT Reporting Date	128	VAT Reporting Date	true	p254p254VATDateEnabled	p254p254VATDateEnabled
3	279455029	Document Date	76	Document Date	true	True	false
4	634464007	Invoice Receipt Date	10500		true	True	false
5	234010100	Invoice Received Date	175	Invoice Received Date	true	True	false
6	1759446743	Document Type	6	Document Type	true	True	true
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
7	526019910	Document No.	7	Document No.	true	True	true
8	404538892	Incoming Document Entry No.	165	Incoming Document Entry No.	true	True	false
9	2111566277	External Document No.	77	External Document No.	true	True	true
10	227481017	Account Type	3	Account Type	true	True	not p254p254IsSimplePage
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
11	1745756632	Account No.	4	Account No.	true	True	true
12	1618927039				true	false	true
13	1945984904	Description	8	Description	true	True	true
14	238496852	Salespers./Purch. Code	26	Salespers./Purch. Code	true	True	false
15	1270961361	Campaign No.	5050	Campaign No.	true	True	false
16	584136724	Currency Code	12	Currency Code	true	True	false
17	386257420	Gen. Posting Type	57	Gen. Posting Type	true	True	not p254p254IsSimplePage
	Available options are: ” “ “Purchase” “Sale” “Settlement”
18	1682476919	Gen. Bus. Posting Group	58	Gen. Bus. Posting Group	true	True	not p254p254IsSimplePage
19	1527005868	Gen. Prod. Posting Group	59	Gen. Prod. Posting Group	true	True	not p254p254IsSimplePage
20	415404376	VAT Bus. Posting Group	90	VAT Bus. Posting Group	true	True	false
21	647280557	VAT Prod. Posting Group	91	VAT Prod. Posting Group	true	True	false
22	493075953	Posting Group	23	Posting Group	true	p254p254IsPostingGroupEditable	p254p254IsPostingGroupEditable
23	1932400629	DocumentAmount			true	true	true
24	622236754	Amount	13	Amount	true	True	p254p254AmountVisible
25	2074632389	Amount (LCY)	16	Amount (LCY)	true	True	p254p254AmountVisible
26	332243492	Debit Amount	14	Debit Amount	true	True	p254p254DebitCreditVisible
27	48046089	Credit Amount	15	Credit Amount	true	True	p254p254DebitCreditVisible
28	954936308	Tax Liable	83	Tax Liable	true	True	false
29	677060969	Tax Area Code	82	Tax Area Code	true	True	false
30	1526569073	Tax Group Code	84	Tax Group Code	true	True	false
31	1411652528	Use Tax	85	Use Tax	true	True	false
32	1421795943	VAT Amount	44	VAT Amount	true	True	false
33	1772025218	VAT Difference	111	VAT Difference	true	False	false
34	1178033080	Bal. VAT Amount	69	Bal. VAT Amount	true	True	false
35	641787565	Bal. VAT Difference	112	Bal. VAT Difference	true	False	false
36	69943910	Bal. Account Type	63	Bal. Account Type	true	True	not p254p254IsSimplePage
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
37	368270833	Bal. Account No.	11	Bal. Account No.	true	True	true
38	2003878437	Bal. Gen. Posting Type	64	Bal. Gen. Posting Type	true	True	not p254p254IsSimplePage
	Available options are: ” “ “Purchase” “Sale” “Settlement”
39	293081872	Bal. Gen. Bus. Posting Group	65	Bal. Gen. Bus. Posting Group	true	True	not p254p254IsSimplePage
40	1791332005	Bal. Gen. Prod. Posting Group	66	Bal. Gen. Prod. Posting Group	true	True	not p254p254IsSimplePage
41	1400503639	Bal. VAT Bus. Posting Group	92	Bal. VAT Bus. Posting Group	true	True	false
42	1858579252	Bal. VAT Prod. Posting Group	93	Bal. VAT Prod. Posting Group	true	True	false
43	1828029355	Bill-to/Pay-to No.	22	Bill-to/Pay-to No.	true	False	false
44	44792968	Ship-to/Order Address Code	110	Ship-to/Order Address Code	true	True	false
45	1678126620	Sales/Purch. (LCY)	19	Sales/Purch. (LCY)	true	True	false
46	394730053	Inv. Discount (LCY)	21	Inv. Discount (LCY)	true	True	false
47	585505788	Payment Terms Code	47	Payment Terms Code	true	True	false
48	157080730	Due Date	38	Due Date	true	True	false
49	863087688	Pmt. Discount Date	39	Pmt. Discount Date	true	True	false
50	2141761628	Payment Discount %	40	Payment Discount %	true	True	false
51	1056776860	Applies-to Doc. Type	35	Applies-to Doc. Type	true	True	not p254p254IsSimplePage
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
52	291304413	Applies-to Doc. No.	36	Applies-to Doc. No.	true	True	not p254p254IsSimplePage
53	1145450705	Applies-to ID	48	Applies-to ID	true	True	false
54	1033191280	On Hold	34	On Hold	true	True	true
55	2130472329	Reason Code	52	Reason Code	true	True	false
56	768457664	Correction	73	Correction	true	True	true
57	2125749163	Comment	5618	Comment	true	True	false
58	917898988	Job Queue Status	160	Job Queue Status	true	False	p254p254JobQueuesUsed
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
59	1507947338	Shortcut Dimension 1 Code	24	Shortcut Dimension 1 Code	true	True	p254p254DimVisible1
60	2081754281	Shortcut Dimension 2 Code	25	Shortcut Dimension 2 Code	true	True	p254p254DimVisible2
61	1589042016	ShortcutDimCode3			true	true	p254p254DimVisible3
62	1420132993	ShortcutDimCode4			true	true	p254p254DimVisible4
63	2057829610	ShortcutDimCode5			true	true	p254p254DimVisible5
64	1599441069	ShortcutDimCode6			true	true	p254p254DimVisible6
65	961744452	ShortcutDimCode7			true	true	p254p254DimVisible7
66	1130653475	ShortcutDimCode8			true	true	p254p254DimVisible8
67	1058958973	NumberOfJournalRecords			true	false	true
68	60508792	AccName			true	false	0
69	15784959	BalAccName			true	false	0
70	847882048	Balance			true	false	p254p254BalanceVisible
71	1273917650	TotalBalance			true	false	p254p254TotalBalanceVisible

Dynamics 365 BC Table Reference Pages PPurchase Journal

Show/hide columns in the Purchase Journal page

Leave a Reply Cancel reply