GPSOPCommissionsWorkHist #4068

Name: GPSOPCommissionsWorkHist — Business Central Table #4068
Creator: Xpertly Ltd

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

Fields

Records

Primary key

FlowFields

Relations

Primary key

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

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