GPIVTrxAmountsHist #4039

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

The GPIVTrxAmountsHist table (ID 4039) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 28 fields, with a primary key of Document Type, Document Number, Line SEQ Number. 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: Document Type, Document Number, Line SEQ Number.

All fields (28)

GPIVTrxAmountsHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	TRX Source	Text	Normal
2	Document Type PK	Option	Normal
3	Document Number PK	Text	Normal
4	Document Date	Date	Normal
5	History Module	Text	Normal
6	Customer Number	Text	Normal
7	Item Number	Text	Normal
8	Line SEQ Number PK	Decimal	Normal
9	U Of M	Text	Normal
10	TRX QTY	Decimal	Normal
11	Unit Cost	Decimal	Normal
12	Extended Cost	Decimal	Normal
13	TRX Location	Text	Normal
14	Transfer To Location	Text	Normal
15	Transfer From QTY Type	Option	Normal
16	Transfer To QTY Type	Option	Normal
17	IV IV Index	Integer	Normal
18	IV IV Offset Index	Integer	Normal
19	Decimal Places Currency	Option	Normal
20	Decimal Places QTYS	Option	Normal
21	QTY In Base U Of M	Decimal	Normal
22	Reason Code	Text	Normal
23	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