Other table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The GPIVTrxHist table (ID 4052) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of TRX Source, IV Document Type, Document 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: TRX Source, IV Document Type, Document Number.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | TRX Source PK | Text | Normal | |
| 2 | IV Document Type PK | Option | Normal | |
| 3 | Document Number PK | Text | Normal | |
| 4 | Document Date | Date | Normal | |
| 5 | Batch Source | Text | Normal | |
| 6 | Batch Number | Text | Normal | |
| 7 | Note Index | Decimal | Normal | |
| 8 | GL Posting Date | Date | Normal | |
| 9 | Source Reference Number | Text | Normal | |
| 10 | Source Indicator | Option | Normal | |
| 11 | DEX_ROW_TS | DateTime | Normal | |
| 12 | 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 |