Other table in Microsoft Dynamics 365 Business Central. 14 fields, 0 records in Cronus demo.
The GPIVTrxDetailHist table (ID 4051) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 14 fields, with a primary key of Document Type, Document Number, Line SEQ Number, Detail SEQ Number. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Document Type, Document Number, Line SEQ Number, Detail SEQ Number.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Document Type PK | Option | Normal | |
| 2 | Document Number PK | Text | Normal | |
| 3 | Line SEQ Number PK | Decimal | Normal | |
| 4 | Detail SEQ Number PK | Integer | Normal | |
| 5 | QTY Type | Option | Normal | |
| 6 | Receipt Number | Text | Normal | |
| 7 | Receipt QTY | Decimal | Normal | |
| 8 | Receipt Extended Cost | Decimal | Normal | |
| 9 | 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 |