GPPOPPOLineHist #4058

Other table in Microsoft Dynamics 365 Business Central. 95 fields, 0 records in Cronus demo.

The GPPOPPOLineHist table (ID 4058) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 95 fields, with a primary key of PO Number, Ord, Break Field 1. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: PO Number, Ord, Break Field 1.

All fields (95)

GPPOPPOLineHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	PO Number PK	Text	Normal
2	Ord PK	Integer	Normal
3	PO Line Status	Option	Normal
4	PO Type	Option	Normal
5	Item Number	Text	Normal
6	Item Description	Text	Normal
7	Vendor ID	Text	Normal
8	Vendor Item Number	Text	Normal
9	Vendor Item Description	Text	Normal
10	Non-Inventory Item	Option	Normal
11	Location Code	Text	Normal
12	U Of M	Text	Normal
13	U Of M QTY In Base	Decimal	Normal
14	QTY Ordered	Decimal	Normal
15	QTY Canceled	Decimal	Normal
16	Unit Cost	Decimal	Normal
17	Extended Cost	Decimal	Normal
18	Inventory Index	Integer	Normal
19	Required Date	Date	Normal
20	Promised Date	Date	Normal
21	Promised Ship Date	Date	Normal
22	Requested By	Text	Normal
23	Comment ID	Text	Normal
24	Document Type	Option	Normal
25	PO Line Note ID Array	Decimal	Normal
26	PO Line Note ID Array	Decimal	Normal
27	PO Line Note ID Array	Decimal	Normal
28	PO Line Note ID Array	Decimal	Normal
29	PO Line Note ID Array	Decimal	Normal
30	PO Line Note ID Array	Decimal	Normal
31	PO Line Note ID Array	Decimal	Normal
32	PO Line Note ID Array	Decimal	Normal
33	PO Line Note ID Array	Decimal	Normal
34	Decimal Places Currency	Option	Normal
35	Decimal Places QTYS	Option	Normal
36	Break Field 1 PK	Integer	Normal
37	Job Number	Text	Normal
38	Cost Code	Text	Normal
39	Cost Code Type	Integer	Normal
40	Currency Index	Integer	Normal
41	Originating Unit Cost	Decimal	Normal
42	Originating Extended Cost	Decimal	Normal
43	Line Origin	Option	Normal
44	Free On Board	Option	Normal
45	Originating Decimal Places Currency	Option	Normal
46	Product Indicator	Integer	Normal
47	Source Document Number	Text	Normal
48	Source Document Line Number	Integer	Normal
49	Release By Date	Date	Normal
50	Released Date	Date	Normal
51	Purchase IV Item Taxable	Option	Normal
52	Purchase Item Tax Schedule ID	Text	Normal
53	Purchase Site Tax Schedule ID	Text	Normal
54	Purchase Site Tax Schedule Source	Integer	Normal
55	Based On Invoice Total	Boolean	Normal
56	Tax Amount	Decimal	Normal
57	Originating Tax Amount	Decimal	Normal
58	Backout Tax Amount	Decimal	Normal
59	Originating Backout Tax Amount	Decimal	Normal
60	Landed Cost Group ID	Text	Normal
61	Shipping Method	Text	Normal
62	LineNumber	Integer	Normal
63	Original Promised Date	Date	Normal
64	First Receipt Date	Date	Normal
65	Last Receipt Date	Date	Normal
66	Release	Integer	Normal
67	Address Code	Text	Normal
68	Company Name	Text	Normal
69	Contact	Text	Normal
70	Address 1	Text	Normal
71	Address 2	Text	Normal
72	Address 3	Text	Normal
73	City	Text	Normal
74	State	Text	Normal
75	Zip Code	Text	Normal
76	Country Code	Text	Normal
77	Country	Text	Normal
78	Phone 1	Text	Normal
79	Phone 2	Text	Normal
80	Phone 3	Text	Normal
81	Fax	Text	Normal
82	Address Source	Integer	Normal
83	Flags	Integer	Normal
84	Project Number	Text	Normal
85	Cost Category ID	Text	Normal
86	Item Tracking Option	Option	Normal
87	Valuation Method	Option	Normal
88	Print Phone Number GB	Option	Normal
89	DEX_ROW_TS	DateTime	Normal
90	DEX_ROW_ID	Integer	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