--- id: object/table/4078 type: object title: Table 4078 "GPSOPTrxHist" summary: Table 4078 "GPSOPTrxHist" in HybridGP (Microsoft.DataMigration.GP). 179 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: 7a918312ba91379af4c45fcb673ed6fa5a39267adc91cf0c33fe618aa24b062d evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/HybridGP/app/src/Migration/History/GPSOPTrxHist.table.al title: src/Apps/W1/HybridGP/app/src/Migration/History/GPSOPTrxHist.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: 4078 name: GPSOPTrxHist 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: 179 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 4078 "GPSOPTrxHist" > Table 4078 "GPSOPTrxHist" in HybridGP (Microsoft.DataMigration.GP). 179 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/GPSOPTrxHist.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 | ORIGTYPE | Option | Original Type caption | | | 4 | ORIGNUMB | text[22] | Original Number caption | | | 5 | DOCID | text[16] | Document ID caption | | | 6 | DOCDATE | Date | Document Date caption | | | 7 | GLPOSTDT | Date | GL Posting Date caption | | | 8 | QUOTEDAT | Date | Quote Date caption | | | 9 | QUOEXPDA | Date | Quote Expiration Date caption | | | 10 | ORDRDATE | Date | Order Date caption | | | 11 | INVODATE | Date | Invoice Date caption | | | 12 | BACKDATE | Date | Back Order Date caption | | | 13 | RETUDATE | Date | Return Date caption | | | 14 | ReqShipDate | Date | Requested Ship Date caption | | | 15 | FUFILDAT | Date | Fulfillment Date caption | | | 16 | ACTLSHIP | Date | Actual Ship Date caption | | | 17 | DISCDATE | Date | Discount Date caption | | | 18 | DUEDATE | Date | Due Date caption | | | 19 | REPTING | Boolean | Repeating caption | | | 20 | TRXFREQU | Option | TRX Frequency caption | | | 21 | TIMEREPD | Integer | Times Repeated caption | | | 22 | TIMETREP | Integer | Times To Repeat caption | | | 23 | DYSTINCR | Integer | Days to Increment caption | | | 24 | DTLSTREP | Date | Date Last Repeated caption | | | 25 | DSTBTCH1 | text[16] | Dest Batch 1 caption | | | 26 | DSTBTCH2 | text[16] | Dest Batch 2 caption | | | 27 | USDOCID1 | text[16] | Use Document ID 1 caption | | | 28 | USDOCID2 | text[16] | Use Document ID 2 caption | | | 29 | DISCFRGT | Decimal | Discount Available Freight caption | | | 30 | ORDAVFRT | Decimal | Originating Discount Available Freight caption | | | 31 | DISCMISC | Decimal | Discount Available Misc caption | | | 32 | ORDAVMSC | Decimal | Originating Discount Available Misc caption | | | 33 | DISAVAMT | Decimal | Discount Available Amount caption | | | 34 | ORDAVAMT | Decimal | Originating Discount Available Amount caption | | | 35 | DISCRTND | Decimal | Discount Returned caption | | | 36 | ORDISRTD | Decimal | Originating Discount Returned caption | | | 37 | DISTKNAM | Decimal | Discount Taken Amount caption | | | 38 | ORDISTKN | Decimal | Originating Discount Taken Amount caption | | | 39 | DSCPCTAM | Integer | Discount Percent Amount caption | | | 40 | DSCDLRAM | Decimal | Discount Dollar Amount caption | | | 41 | ORDDLRAT | Decimal | Originating Discount Dollar Amount caption | | | 42 | DISAVTKN | Decimal | Discount Available Taken caption | | | 43 | ORDATKN | Decimal | Originating Discount Available Taken caption | | | 44 | PYMTRMID | text[22] | Payment Terms ID caption | | | 45 | PRCLEVEL | text[12] | PriceLevel caption | | | 46 | LOCNCODE | text[12] | Location Code caption | | | 47 | BCHSOURC | text[16] | Batch Source caption | | | 48 | BACHNUMB | text[16] | Batch Number caption | | | 49 | CUSTNMBR | text[16] | Customer Number caption | | | 50 | CUSTNAME | text[66] | Customer Name caption | | | 51 | CSTPONBR | text[22] | Customer PO Number caption | | | 52 | PROSPECT | Integer | Prospect caption | | | 53 | MSTRNUMB | Integer | Master Number caption | | | 54 | PCKSLPNO | text[22] | Packing Slip Number caption | | | 55 | PICTICNU | text[22] | Picking Ticket Number caption | | | 56 | MRKDNAMT | Decimal | Markdown Amount caption | | | 57 | ORMRKDAM | Decimal | Originating Markdown Amount caption | | | 58 | PRBTADCD | text[16] | Primary Billto Address Code caption | | | 59 | PRSTADCD | text[16] | Primary Shipto Address Code caption | | | 60 | CNTCPRSN | text[62] | Contact Person caption | | | 61 | ShipToName | text[66] | — | | | 62 | ADDRESS1 | text[62] | Address 1 caption | | | 63 | ADDRESS2 | text[62] | Address 2 caption | | | 64 | ADDRESS3 | text[62] | Address 3 caption | | | 65 | CITY | text[36] | City caption | | | 66 | STATE | text[30] | State caption | | | 67 | ZIPCODE | text[12] | Zip Code caption | | | 68 | CCode | text[8] | Country Code caption | | | 69 | COUNTRY | text[62] | Country caption | | | 70 | PHNUMBR1 | text[22] | Phone Number 1 caption | | | 71 | PHNUMBR2 | text[22] | Phone Number 2 caption | | | 72 | PHONE3 | text[22] | Phone 3 caption | | | 73 | FAXNUMBR | text[22] | Fax Number caption | | | 74 | COMAPPTO | Option | Commission Applied To caption | | | 75 | COMMAMNT | Decimal | Commission Amount caption | | | 76 | OCOMMAMT | Decimal | Originating Commission Amount caption | | | 77 | CMMSLAMT | Decimal | Commission Sale Amount caption | | | 78 | ORCOSAMT | Decimal | Originating Commission Sales Amount caption | | | 79 | NCOMAMNT | Decimal | Non-Commissioned Amount caption | | | 80 | ORNCMAMT | Decimal | Originating Non-Commissioned Amount caption | | | 81 | SHIPMTHD | text[16] | Shipping Method caption | | | 82 | TRDISAMT | Decimal | Trade Discount Amount caption | | | 83 | ORTDISAM | Decimal | Originating Trade Discount Amount caption | | | 84 | TRDISPCT | Integer | Trade Discount Percent caption | | | 85 | SUBTOTAL | Decimal | Subtotal caption | | | 86 | ORSUBTOT | Decimal | Originating Subtotal caption | | | 87 | REMSUBTO | Decimal | Remaining Subtotal caption | | | 88 | OREMSUBT | Decimal | Originating Remaining Subtotal caption | | | 89 | EXTDCOST | Decimal | Extended Cost caption | | | 90 | OREXTCST | Decimal | Originating Extended Cost caption | | | 91 | FRTAMNT | Decimal | Freight Amount caption | | | 92 | ORFRTAMT | Decimal | Originating Freight Amount caption | | | 93 | MISCAMNT | Decimal | Misc Amount caption | | | 94 | ORMISCAMT | Decimal | Originating Misc Amount caption | | | 95 | TXENGCLD | Boolean | Tax Engine Called caption | | | 96 | TAXEXMT1 | text[26] | Tax Exempt 1 caption | | | 97 | TAXEXMT2 | text[26] | Tax Exempt 2 caption | | | 98 | TXRGNNUM | text[26] | Tax Registration Number caption | | | 99 | TAXSCHID | text[16] | Tax Schedule ID caption | | | 100 | TXSCHSRC | Option | Tax Schedule Source caption | | | 101 | BSIVCTTL | Boolean | Based On Invoice Total caption | | | 102 | FRTSCHID | text[16] | Freight Schedule ID caption | | | 103 | FRTTXAMT | Decimal | Freight Tax Amount caption | | | 104 | ORFRTTAX | Decimal | Originating Freight Tax Amount caption | | | 105 | FRGTTXBL | Option | Freight Taxable caption | | | 106 | MSCSCHID | text[16] | Misc Schedule ID caption | | | 107 | MSCTXAMT | Decimal | Misc Tax Amount caption | | | 108 | ORMSCTAX | Decimal | Originating Misc Tax Amount caption | | | 109 | MISCTXBL | Option | Misc Taxable caption | | | 110 | BKTFRTAM | Decimal | Backout Freight Amount caption | | | 111 | ORBKTFRT | Decimal | Originating Backout Freight Amount caption | | | 112 | BKTMSCAM | Decimal | Backout Misc Amount caption | | | 113 | ORBKTMSC | Decimal | Originating Backout Misc Amount caption | | | 114 | BCKTXAMT | Decimal | Backout Tax Amount caption | | | 115 | OBTAXAMT | Decimal | Originating Backout Tax Amount caption | | | 116 | TXBTXAMT | Decimal | Taxable Tax Amount caption | | | 117 | OTAXTAMT | Decimal | Originating Taxable Tax Amount caption | | | 118 | TAXAMNT | Decimal | Tax Amount caption | | | 119 | ORTAXAMT | Decimal | Originating Tax Amount caption | | | 120 | ECTRX | Boolean | EC Transaction caption | | | 121 | DOCAMNT | Decimal | Document Amount caption | | | 122 | ORDOCAMT | Decimal | Originating Document Amount caption | | | 123 | PYMTRCVD | Decimal | Payment Received caption | | | 124 | ORPMTRVD | Decimal | Originating Payment Received caption | | | 125 | DEPRECVD | Decimal | Deposit Received caption | | | 126 | ORDEPRVD | Decimal | Originating Deposit Received caption | | | 127 | CODAMNT | Decimal | COD Amount caption | | | 128 | ORCODAMT | Decimal | Originating COD Amount caption | | | 129 | ACCTAMNT | Decimal | Account Amount caption | | | 130 | ORACTAMT | Decimal | Originating Account Amount caption | | | 131 | SALSTERR | text[16] | Sales Territory caption | | | 132 | SLPRSNID | text[16] | Salesperson ID caption | | | 133 | UPSZONE | text[4] | UPS Zone caption | | | 134 | TIMESPRT | Integer | Times Printed caption | | | 135 | PSTGSTUS | Integer | Posting Status caption | | | 136 | VOIDSTTS | Option | Void Status caption | | | 137 | ALLOCABY | Option | Allocate By caption | | | 138 | NOTEINDX | Decimal | Note Index caption | | | 139 | CURNCYID | text[16] | Currency ID caption | | | 140 | CURRNIDX | Integer | Currency Index caption | | | 141 | RATETPID | text[16] | Rate Type ID caption | | | 142 | EXGTBLID | text[16] | Exchange Table ID caption | | | 143 | XCHGRATE | Decimal | Exchange Rate caption | | | 144 | DENXRATE | Decimal | Denomination Exchange Rate caption | | | 145 | EXCHDATE | Date | Exchange Date caption | | | 146 | TIME1 | DateTime | Time caption | | | 147 | RTCLCMTD | Option | Rate Calculation Method caption | | | 148 | MCTRXSTT | Option | MC Transaction State caption | | | 149 | TRXSORCE | text[14] | TRX Source caption | | | 150 | COMMNTID | text[16] | Comment ID caption | | | 151 | REFRENCE | text[32] | Reference caption | | | 152 | POSTEDDT | Date | Posted Date caption | | | 153 | PTDUSRID | text[16] | Posted User ID caption | | | 154 | USER2ENT | text[16] | User To Enter caption | | | 155 | CREATDDT | Date | Created Date caption | | | 156 | MODIFDT | Date | Modified Date caption | | | 157 | Tax_Date | Date | Tax Date caption | | | 158 | APLYWITH | Boolean | Apply Withholding caption | | | 159 | WITHHAMT | Decimal | Withholding Amount caption | | | 160 | SHPPGDOC | Boolean | Shipping Document caption | | | 161 | CORRCTN | Boolean | Correction caption | | | 162 | SIMPLIFD | Boolean | Simplified caption | | | 163 | DOCNCORR | text[22] | Document Number Corrected caption | | | 164 | SEQNCORR | Integer | Sequence Number Corrected caption | | | 165 | SALEDATE | Date | Sale Date caption | | | 166 | EXCEPTIONALDEMAND | Boolean | Exceptional Demand caption | | | 167 | Flags | Integer | — | | | 168 | SOPSTATUS | Option | SOP Status caption | | | 169 | SHIPCOMPLETE | Boolean | Ship Complete Document caption | | | 170 | DIRECTDEBIT | Boolean | Direct Debit caption | | | 171 | WorkflowApprStatCreditLm | Option | Workflow Approval Status Credit Limit caption | | | 172 | WorkflowPriorityCreditLm | Option | Workflow Priority Credit Limit caption | | | 173 | WorkflowApprStatusQuote | Option | Workflow Approval Status Quote caption | | | 174 | WorkflowPriorityQuote | Option | Workflow Priority Quote caption | | | 175 | Workflow_Status | Option | Workflow Status caption | | | 176 | ContractExchangeRateStat | Integer | Contract Exchange Rate Status caption | | | 177 | Print_Phone_NumberGB | Option | Print Phone Number GB caption | | | 178 | DEX_ROW_TS | DateTime | — | | | 179 | DEX_ROW_ID | Integer | — | | ## Keys - PK: SOPNUMBE, SOPTYPE - DueDate: DUEDATE - Key3: DEX_ROW_ID - Key4: DEX_ROW_ID, DOCDATE - Key5: PYMTRMID ## 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: "GPSOPTrxHist")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.