XPT / Schema / GPPOPPOLineHist

GPPOPPOLineHist #4058

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

95
Fields
0
Records
3
Primary key
0
FlowFields
2
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.FIELDTYPECLASSRELATION
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

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms