---
id: object/table/4077
type: object
title: Table 4077 "GPSOPTrxAmountsHist"
summary: Table 4077 "GPSOPTrxAmountsHist" in HybridGP (Microsoft.DataMigration.GP). 120 fields. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
- table
- hybridgp
versions:
introduced: "29"
last_changed: null
deprecated: null
review:
state: derived
by: null
at: null
flags: []
generated:
at: "2026-10-11T00:31:51.816Z"
pipeline: 0.2.0
prompts: {}
input_hash: 82e034a38a2393c6383ebfe1d26f0d51502148af919abdc01d7e8061af3556d5
evidence:
- kind: code
url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/HybridGP/app/src/Migration/History/GPSOPTrxAmountsHist.table.al
title: src/Apps/W1/HybridGP/app/src/Migration/History/GPSOPTrxAmountsHist.table.al (releases/29.x)
date: null
commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
t: null
quote: null
links:
learn: []
objects: []
features: []
topics: []
localizations: []
videos: []
posts: []
guidelines: []
object_type: table
object_id: 4077
name: GPSOPTrxAmountsHist
namespace: Microsoft.DataMigration.GP
app: HybridGP
extends: null
first_version: "29"
last_version: "30"
present_in:
- "29"
- "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
fields: 120
procedures: 0
events: 0
subscribers: 0
relations:
out: 0
referenced_by: 0
pages: 0
extended_by: 0
event_subscribers: 0
calls: 0
called_by: 0
implements: 0
---
# Table 4077 "GPSOPTrxAmountsHist"
> Table 4077 "GPSOPTrxAmountsHist" in HybridGP (Microsoft.DataMigration.GP). 120 fields. Introduced in BC29, still in BC30.
HybridGP · Microsoft.DataMigration.GP · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/HybridGP/app/src/Migration/History/GPSOPTrxAmountsHist.table.al) · 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 | Notes |
|---|---|---|---|---|
| 1 | SOPTYPE | Option | SOP Type caption | |
| 2 | SOPNUMBE | text[22] | SOP Number caption | |
| 3 | LNITMSEQ | Integer | Line Item Sequence caption | |
| 4 | CMPNTSEQ | Integer | Component Sequence caption | |
| 5 | ITEMNMBR | text[32] | Item Number caption | |
| 6 | ITEMDESC | text[102] | Item Description caption | |
| 7 | NONINVEN | Option | Non-Inventory Item caption | |
| 8 | DROPSHIP | Integer | Drop Ship caption | |
| 9 | UOFM | text[10] | U Of M caption | |
| 10 | LOCNCODE | text[12] | Location Code caption | |
| 11 | UNITCOST | Decimal | Unit Cost caption | |
| 12 | ORUNTCST | Decimal | Originating Unit Cost caption | |
| 13 | UNITPRCE | Decimal | Unit Price caption | |
| 14 | ORUNTPRC | Decimal | Originating Unit Price caption | |
| 15 | XTNDPRCE | Decimal | Extended Price caption | |
| 16 | OXTNDPRC | Decimal | Originating Extended Price caption | |
| 17 | REMPRICE | Decimal | Remaining Price caption | |
| 18 | OREPRICE | Decimal | Originating Remaining Price caption | |
| 19 | EXTDCOST | Decimal | Extended Cost caption | |
| 20 | OREXTCST | Decimal | Originating Extended Cost caption | |
| 21 | MRKDNAMT | Decimal | Markdown Amount caption | |
| 22 | ORMRKDAM | Decimal | Originating Markdown Amount caption | |
| 23 | MRKDNPCT | Integer | Markdown Percent caption | |
| 24 | MRKDNTYP | Option | Markdown Type caption | |
| 25 | INVINDX | Integer | Inventory Index caption | |
| 26 | CSLSINDX | Integer | Cost Of Sales Index caption | |
| 27 | SLSINDX | Integer | Sales Index caption | |
| 28 | MKDNINDX | Integer | Markdown Index caption | |
| 29 | RTNSINDX | Integer | Returns Index caption | |
| 30 | INUSINDX | Integer | In Use Index caption | |
| 31 | INSRINDX | Integer | In Service Index caption | |
| 32 | DMGDINDX | Integer | Damaged Index caption | |
| 33 | ITMTSHID | text[16] | Item Tax Schedule ID caption | |
| 34 | IVITMTXB | Option | IV Item Taxable caption | |
| 35 | BKTSLSAM | Decimal | Backout Sales Amount caption | |
| 36 | ORBKTSLS | Decimal | Originating Backout Sales Amount caption | |
| 37 | TAXAMNT | Decimal | Tax Amount caption | |
| 38 | ORTAXAMT | Decimal | Originating Tax Amount caption | |
| 39 | TXBTXAMT | Decimal | Taxable Tax Amount caption | |
| 40 | OTAXTAMT | Decimal | Originating Taxable Tax Amount caption | |
| 41 | BSIVCTTL | Boolean | Based On Invoice Total caption | |
| 42 | TRDISAMT | Decimal | Trade Discount Amount caption | |
| 43 | ORTDISAM | Decimal | Originating Trade Discount Amount caption | |
| 44 | DISCSALE | Decimal | Discount Available Sales caption | |
| 45 | ORDAVSLS | Decimal | Originating Discount Available Sales caption | |
| 46 | QUANTITY | Decimal | QTY caption | |
| 47 | ATYALLOC | Decimal | QTY Allocated caption | |
| 48 | QTYINSVC | Decimal | QTY In Service caption | |
| 49 | QTYINUSE | Decimal | QTY In Use caption | |
| 50 | QTYDMGED | Decimal | QTY Damaged caption | |
| 51 | QTYRTRND | Decimal | QTY Returned caption | |
| 52 | QTYONHND | Decimal | QTY On Hand caption | |
| 53 | QTYCANCE | Decimal | QTY Canceled caption | |
| 54 | QTYCANOT | Decimal | QTY Canceled Other caption | |
| 55 | QTYORDER | Decimal | QTY Ordered caption | |
| 56 | QTYPRBAC | Decimal | QTY Prev Back Ordered caption | |
| 57 | QTYPRBOO | Decimal | QTY Prev BO On Order caption | |
| 58 | QTYPRINV | Decimal | QTY Prev Invoiced caption | |
| 59 | QTYPRORD | Decimal | QTY Prev Ordered caption | |
| 60 | QTYPRVRECVD | Decimal | QTY Prev Received caption | |
| 61 | QTYRECVD | Decimal | QTY Received caption | |
| 62 | QTYREMAI | Decimal | QTY Remaining caption | |
| 63 | QTYREMBO | Decimal | QTY Remaining On BO caption | |
| 64 | QTYTBAOR | Decimal | QTY To Back Order caption | |
| 65 | QTYTOINV | Decimal | QTY To Invoice caption | |
| 66 | QTYTORDR | Decimal | QTY To Order caption | |
| 67 | QTYFULFI | Decimal | QTY Fulfilled caption | |
| 68 | QTYSLCTD | Decimal | QTY Selected caption | |
| 69 | QTYBSUOM | Decimal | QTY In Base U Of M caption | |
| 70 | EXTQTYAL | Decimal | Existing Qty Available caption | |
| 71 | EXTQTYSEL | Decimal | Existing Qty Selected caption | |
| 72 | ReqShipDate | Date | Requested Ship Date caption | |
| 73 | FUFILDAT | Date | Fulfillment Date caption | |
| 74 | ACTLSHIP | Date | Actual Ship Date caption | |
| 75 | SHIPMTHD | text[16] | Shipping Method caption | |
| 76 | SALSTERR | text[16] | Sales Territory caption | |
| 77 | SLPRSNID | text[16] | Salesperson ID caption | |
| 78 | PRCLEVEL | text[12] | PriceLevel caption | |
| 79 | COMMNTID | text[16] | Comment ID caption | |
| 80 | BRKFLD1 | Integer | Break Field 1 caption | |
| 81 | BRKFLD2 | Integer | Break Field 2 caption | |
| 82 | BRKFLD3 | Integer | Break Field 3 caption | |
| 83 | CURRNIDX | Integer | Currency Index caption | |
| 84 | TRXSORCE | text[14] | TRX Source caption | |
| 85 | DOCNCORR | text[22] | Document Number Corrected caption | |
| 86 | ORGSEQNM | Integer | Original Sequence Number Corrected caption | |
| 87 | ITEMCODE | text[16] | Item Code caption | |
| 88 | PURCHSTAT | Option | Purchasing Status caption | |
| 89 | DECPLQTY | Option | Decimal Places QTYS caption | |
| 90 | DECPLCUR | Option | Decimal Places Currency caption | |
| 91 | ODECPLCU | Option | Originating Decimal Places Currency caption | |
| 92 | EXCEPTIONALDEMAND | Boolean | Exceptional Demand caption | |
| 93 | TAXSCHID | text[16] | Tax Schedule ID caption | |
| 94 | TXSCHSRC | Option | Tax Schedule Source caption | |
| 95 | PRSTADCD | text[16] | Primary Shipto Address Code caption | |
| 96 | ShipToName | text[66] | — | |
| 97 | CNTCPRSN | text[62] | Contact Person caption | |
| 98 | ADDRESS1 | text[62] | Address 1 caption | |
| 99 | ADDRESS2 | text[62] | Address 2 caption | |
| 100 | ADDRESS3 | text[62] | Address 3 caption | |
| 101 | CITY | text[36] | City caption | |
| 102 | STATE | text[30] | State caption | |
| 103 | ZIPCODE | text[12] | Zip Code caption | |
| 104 | CCode | text[8] | Country Code caption | |
| 105 | COUNTRY | text[62] | Country caption | |
| 106 | PHONE1 | text[22] | Phone 1 caption | |
| 107 | PHONE2 | text[22] | Phone 2 caption | |
| 108 | PHONE3 | text[22] | Phone 3 caption | |
| 109 | FAXNUMBR | text[22] | Fax Number caption | |
| 110 | Flags | Integer | — | |
| 111 | CONTNBR | text[12] | Contract Number caption | |
| 112 | CONTLNSEQNBR | Decimal | Contract Line SEQ Number caption | |
| 113 | CONTSTARTDTE | Date | Contract Start Date caption | |
| 114 | CONTENDDTE | Date | Contract End Date caption | |
| 115 | CONTITEMNBR | text[32] | Contract Item Number caption | |
| 116 | CONTSERIALNBR | text[22] | Contract Serial Number caption | |
| 117 | ISLINEINTRA | Boolean | IsLineIntrastat caption | |
| 118 | Print_Phone_NumberGB | Option | Print Phone Number GB caption | |
| 119 | DEX_ROW_TS | DateTime | — | |
| 120 | DEX_ROW_ID | Integer | — | |
## Keys
- PK: SOPNUMBE, SOPTYPE, CMPNTSEQ, LNITMSEQ
- Key2: SOPTYPE, SOPNUMBE
## Across versions
- Present in: BC29-30
- Changed (declaration) in: none
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
## 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: "GPSOPTrxAmountsHist")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.