GPSOPCommissionsWorkHist #4068

Other table in Microsoft Dynamics 365 Business Central. 23 fields, 0 records in Cronus demo.

The GPSOPCommissionsWorkHist table (ID 4068) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 23 fields, with a primary key of SOP Type, SOP Number, Sequence Number. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: SOP Type, SOP Number, Sequence Number.

All fields (23)

GPSOPCommissionsWorkHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	SOP Type PK	Option	Normal
2	SOP Number PK	Text	Normal
3	Sequence Number PK	Integer	Normal
4	Salesperson ID	Text	Normal
5	Sales Territory	Text	Normal
6	Commission Percent	Integer	Normal
7	Commission Amount	Decimal	Normal
8	Originating Commission Amount	Decimal	Normal
9	Non-Commissioned Amount	Decimal	Normal
10	Originating Non-Commissioned Amount	Decimal	Normal
11	Percent of Sale	Integer	Normal
12	Actual Sale Amount	Decimal	Normal
13	Originating Sales Amount	Decimal	Normal
14	Commission Sale Amount	Decimal	Normal
15	Originating Commission Sales Amount	Decimal	Normal
16	Currency Index	Integer	Normal
17	TRX Source	Text	Normal
18	DEX_ROW_ID	Integer	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal