Table 4068 "GPSOPCommissionsWorkHist"

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	SOPTYPE	Option	SOP Type caption
2	SOPNUMBE	text[22]	SOP Number caption
3	SEQNUMBR	Integer	Sequence Number caption
4	SLPRSNID	text[16]	Salesperson ID caption
5	SALSTERR	text[16]	Sales Territory caption
6	COMPRCNT	Integer	Commission Percent caption
7	COMMAMNT	Decimal	Commission Amount caption
8	OCOMMAMT	Decimal	Originating Commission Amount caption
9	NCOMAMNT	Decimal	Non-Commissioned Amount caption
10	ORNCMAMT	Decimal	Originating Non-Commissioned Amount caption
11	PRCTOSAL	Integer	Percent of Sale caption
12	ACTSLAMT	Decimal	Actual Sale Amount caption
13	ORSLSAMT	Decimal	Originating Sales Amount caption
14	CMMSLAMT	Decimal	Commission Sale Amount caption
15	ORCOSAMT	Decimal	Originating Commission Sales Amount caption
16	CURRNIDX	Integer	Currency Index caption
17	TRXSORCE	text[14]	TRX Source caption
18	DEX_ROW_ID	Integer	—

Keys

PK: SOPNUMBE, SOPTYPE, SEQNUMBR

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: "GPSOPCommissionsWorkHist"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.