BC Observatoryunofficial, made by waldo
tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 4078 "GPSOPTrxHist"

HybridGP · Microsoft.DataMigration.GP

Open in Claude4078.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

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 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

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.

Evidence 1 sources