Purch. Rcpt. Header #120

Posted Purchases table in Microsoft Dynamics 365 Business Central. 100 fields, 224 records in Cronus demo.

The Purch. Rcpt. Header table (ID 120) is part of the Posted Purchases area in Microsoft Dynamics 365 Business Central. It contains 100 fields, with a primary key of No., and includes 1 calculated FlowField. Use the reference below to explore every field, data type, and table relation.

NO.	FIELD	TYPE	CLASS	RELATION
2	Buy-from Vendor No.	Code	Normal	→ Vendor #23
3	No. PK	Code	Normal
4	Pay-to Vendor No.	Code	Normal	→ Vendor #23
5	Pay-to Name	Text	Normal
6	Pay-to Name 2	Text	Normal
7	Pay-to Address	Text	Normal
8	Pay-to Address 2	Text	Normal
9	Pay-to City	Text	Normal	→ Post Code #225
10	Pay-to Contact	Text	Normal
11	Your Reference	Text	Normal
12	Ship-to Code	Code	Normal	→ Ship-to Address #222
13	Ship-to Name	Text	Normal
14	Ship-to Name 2	Text	Normal
15	Ship-to Address	Text	Normal
16	Ship-to Address 2	Text	Normal
17	Ship-to City	Text	Normal	→ Post Code #225
18	Ship-to Contact	Text	Normal
19	Order Date	Date	Normal
20	Posting Date	Date	Normal
21	Expected Receipt Date	Date	Normal
22	Posting Description	Text	Normal
23	Payment Terms Code	Code	Normal	→ Payment Terms #3
24	Due Date	Date	Normal
25	Payment Discount %	Decimal	Normal
26	Pmt. Discount Date	Date	Normal
27	Shipment Method Code	Code	Normal	→ Shipment Method #10
28	Location Code	Code	Normal	→ Location #14
29	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
30	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
31	Vendor Posting Group	Code	Normal	→ Vendor Posting Group #93
32	Currency Code	Code	Normal	→ Currency #4
33	Currency Factor	Decimal	Normal
37	Invoice Disc. Code	Code	Normal
41	Language Code	Code	Normal	→ Language #8
42	Format Region	Text	Normal
43	Purchaser Code	Code	Normal	→ Salesperson/Purchaser #13
44	Order No.	Code	Normal
46	Comment ⚡ FLOW	Boolean	FlowField
47	No. Printed	Integer	Normal
51	On Hold	Code	Normal
52	Applies-to Doc. Type	Option	Normal
53	Applies-to Doc. No.	Code	Normal
55	Bal. Account No.	Code	Normal
66	Vendor Order No.	Code	Normal
67	Vendor Shipment No.	Code	Normal
70	VAT Registration No.	Text	Normal
72	Sell-to Customer No.	Code	Normal	→ Customer #18
73	Reason Code	Code	Normal	→ Reason Code #231
74	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
76	Transaction Type	Code	Normal	→ Transaction Type #258
77	Transport Method	Code	Normal	→ Transport Method #259
78	VAT Country/Region Code	Code	Normal	→ Country/Region #9
79	Buy-from Vendor Name	Text	Normal
80	Buy-from Vendor Name 2	Text	Normal
81	Buy-from Address	Text	Normal
82	Buy-from Address 2	Text	Normal
83	Buy-from City	Text	Normal	→ Post Code #225
84	Buy-from Contact	Text	Normal
85	Pay-to Post Code	Code	Normal	→ Post Code #225
86	Pay-to County	Text	Normal
87	Pay-to Country/Region Code	Code	Normal	→ Country/Region #9
88	Buy-from Post Code	Code	Normal	→ Post Code #225
89	Buy-from County	Text	Normal
90	Buy-from Country/Region Code	Code	Normal	→ Country/Region #9
91	Ship-to Post Code	Code	Normal	→ Post Code #225
92	Ship-to County	Text	Normal
93	Ship-to Country/Region Code	Code	Normal	→ Country/Region #9
94	Bal. Account Type	Option	Normal
95	Order Address Code	Code	Normal	→ Order Address #224
97	Entry Point	Code	Normal	→ Entry/Exit Point #282
98	Correction	Boolean	Normal
99	Document Date	Date	Normal
101	Area	Code	Normal	→ Area #284
102	Transaction Specification	Code	Normal	→ Transaction Specification #285
104	Payment Method Code	Code	Normal	→ Payment Method #289
109	No. Series	Code	Normal	→ No. Series #308
110	Order No. Series	Code	Normal	→ No. Series #308
112	User ID	Code	Normal
113	Source Code	Code	Normal	→ Source Code #230
114	Tax Area Code	Code	Normal	→ Tax Area #318
115	Tax Liable	Boolean	Normal
116	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
119	VAT Base Discount %	Decimal	Normal
151	Quote No.	Code	Normal
210	Ship-to Phone No.	Text	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
5050	Campaign No.	Code	Normal	→ Campaign #5071
5052	Buy-from Contact No.	Code	Normal	→ Contact #5050
5053	Pay-to Contact no.	Code	Normal	→ Contact #5050
5700	Responsibility Center	Code	Normal	→ Responsibility Center #5714
5790	Requested Receipt Date	Date	Normal
5791	Promised Receipt Date	Date	Normal
5792	Lead Time Calculation	DateFormula	Normal
5793	Inbound Whse. Handling Time	DateFormula	Normal
7000	Price Calculation Method	Option	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Purch. Rcpt. Header #120

Primary key

All fields (100)

Related tables (32)