GPIVTrxAmountsHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPIVTrxAmountsHist

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/4039

Table Type: Company

Table Name: GPIVTrxAmountsHist
Database Table Name:

Table Number: 4039

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how GPIVTrxAmountsHist can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GPIVTrxAmountsHist]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [GPIVTrxAmountsHist].[CUSTNMBR] = [Customer].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [GPIVTrxAmountsHist].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GPIVTrxAmountsHist].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GPIVTrxAmountsHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	TRXSORCE	TRX Source	Normal	Text	14
2	DOCTYPE	Document Type	Normal	Option	4
3	DOCNUMBR	Document Number	Normal	Text	22
4	DOCDATE	Document Date	Normal	Date	4
5	HSTMODUL	History Module	Normal	Text	4
6	CUSTNMBR	Customer Number	Normal	Text	16
	Key to join to the Customer table. Show/hide example query SELECT [GPIVTrxAmountsHist].[] ,[Customer].[No_] FROM [] AS [GPIVTrxAmountsHist] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GPIVTrxAmountsHist].[] = [Customer].[No_]
7	ITEMNMBR	Item Number	Normal	Text	32
8	LNSEQNBR	Line SEQ Number	Normal	Decimal	12
9	UOFM	U Of M	Normal	Text	10
10	TRXQTY	TRX QTY	Normal	Decimal	12
11	UNITCOST	Unit Cost	Normal	Decimal	12
12	EXTDCOST	Extended Cost	Normal	Decimal	12
13	TRXLOCTN	TRX Location	Normal	Text	12
14	TRNSTLOC	Transfer To Location	Normal	Text	12
15	TRFQTYTY	Transfer From QTY Type	Normal	Option	4
16	TRTQTYTY	Transfer To QTY Type	Normal	Option	4
17	IVIVINDX	IV IV Index	Normal	Integer	4
18	IVIVOFIX	IV IV Offset Index	Normal	Integer	4
19	DECPLCUR	Decimal Places Currency	Normal	Option	4
20	DECPLQTY	Decimal Places QTYS	Normal	Option	4
21	QTYBSUOM	QTY In Base U Of M	Normal	Decimal	12
22	Reason_Code	Reason Code	Normal	Text	16
23	DEX_ROW_ID	DEX_ROW_ID	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [GPIVTrxAmountsHist].[] ,[User].[User Security ID] FROM [] AS [GPIVTrxAmountsHist] LEFT JOIN [User] AS [User] ON [GPIVTrxAmountsHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16