GPIVTrxAmountsHist #4039

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

28
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: Document Type, Document Number, Line SEQ Number.

All fields (28)

GPIVTrxAmountsHist — FIELDS
NO.FIELDTYPECLASSRELATION
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