Table 4039 "GPIVTrxAmountsHist"

HybridGP · Microsoft.DataMigration.GP · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Extensible	false
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation
1	TRXSORCE	text[14]	TRX Source caption
2	DOCTYPE	Option	Document Type caption
3	DOCNUMBR	text[22]	Document Number caption
4	DOCDATE	Date	Document Date caption
5	HSTMODUL	text[4]	History Module caption
6	CUSTNMBR	text[16]	Customer Number caption
7	ITEMNMBR	text[32]	Item Number caption
8	LNSEQNBR	Decimal	Line SEQ Number caption
9	UOFM	text[10]	U Of M caption
10	TRXQTY	Decimal	TRX QTY caption
11	UNITCOST	Decimal	Unit Cost caption
12	EXTDCOST	Decimal	Extended Cost caption
13	TRXLOCTN	text[12]	TRX Location caption
14	TRNSTLOC	text[12]	Transfer To Location caption
15	TRFQTYTY	Option	Transfer From QTY Type caption
16	TRTQTYTY	Option	Transfer To QTY Type caption
17	IVIVINDX	Integer	IV IV Index caption
18	IVIVOFIX	Integer	IV IV Offset Index caption
19	DECPLCUR	Option	Decimal Places Currency caption
20	DECPLQTY	Option	Decimal Places QTYS caption
21	QTYBSUOM	Decimal	QTY In Base U Of M caption
22	Reason_Code	text[16]	Reason Code caption
23	DEX_ROW_ID	Integer	—

Keys

PK: DOCTYPE, DOCNUMBR, LNSEQNBR
Key2: DOCTYPE, ITEMNMBR, DOCDATE, DOCNUMBR
Key3: TRXSORCE, DOCNUMBR

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "GPIVTrxAmountsHist"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.