Salesperson/Purchaser #13

General Ledger table in Microsoft Dynamics 365 Business Central. 47 fields, 7 records in Cronus demo.

The Salesperson/Purchaser table (ID 13) is part of the General Ledger area in Microsoft Dynamics 365 Business Central. It contains 47 fields, with a primary key of Code, and includes 12 calculated FlowFields. 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: Code.

All fields (47)

Salesperson/Purchaser — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Name	Text	Normal
3	Commission %	Decimal	Normal
140	Image	Media	Normal
150	Privacy Blocked	Boolean	Normal
721	Coupled to Dataverse ⚡ FLOW	Boolean	FlowField
5050	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
5051	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
5052	Email	Text	Normal
5053	Phone No.	Text	Normal
5054	Next Task Date ⚡ FLOW	Date	FlowField
5055	No. of Opportunities ⚡ FLOW	Integer	FlowField
5056	Estimated Value (LCY) ⚡ FLOW	Decimal	FlowField
5057	Calcd. Current Value (LCY) ⚡ FLOW	Decimal	FlowField
5058	Date Filter	Date	FlowFilter
5059	No. of Interactions ⚡ FLOW	Integer	FlowField
5060	Cost (LCY) ⚡ FLOW	Decimal	FlowField
5061	Duration (Min.) ⚡ FLOW	Decimal	FlowField
5062	Job Title	Text	Normal
5063	Action Taken Filter	Option	FlowFilter
5064	Sales Cycle Filter	Code	FlowFilter	→ Sales Cycle #5090
5065	Sales Cycle Stage Filter	Integer	FlowFilter	→ Sales Cycle Stage #5091
5066	Probability % Filter	Decimal	FlowFilter
5067	Completed % Filter	Decimal	FlowFilter
5068	Avg. Estimated Value (LCY) ⚡ FLOW	Decimal	FlowField
5069	Avg.Calcd. Current Value (LCY) ⚡ FLOW	Decimal	FlowField
5070	Contact Filter	Code	FlowFilter	→ Contact #5050
5071	Contact Company Filter	Code	FlowFilter	→ Contact #5050
5072	Campaign Filter	Code	FlowFilter	→ Campaign #5071
5073	Estimated Value Filter	Decimal	FlowFilter
5074	Calcd. Current Value Filter	Decimal	FlowFilter
5075	Chances of Success % Filter	Decimal	FlowFilter
5076	Task Status Filter	Option	FlowFilter
5077	Closed Task Filter	Boolean	FlowFilter
5078	Priority Filter	Option	FlowFilter
5079	Team Filter	Code	FlowFilter	→ Team #5083
5082	Opportunity Entry Exists ⚡ FLOW	Boolean	FlowField
5083	Task Entry Exists ⚡ FLOW	Boolean	FlowField
5084	Close Opportunity Filter	Code	FlowFilter	→ Close Opportunity Code #5094
5085	Search Email	Code	Normal
5086	Email 2	Text	Normal
5087	Blocked	Boolean	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

Related tables (8)

Tables referenced by fields on the Salesperson/Purchaser table through TableRelation properties.

Dimension Value

#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code

Sales Cycle

#5090 · Other · via Sales Cycle Filter

Sales Cycle Stage

#5091 · Other · via Sales Cycle Stage Filter

Contact

#5050 · Other · via Contact Filter, Contact Company Filter

Campaign

#5071 · Other · via Campaign Filter

Team

#5083 · Other · via Team Filter

Close Opportunity Code

#5094 · Other · via Close Opportunity Filter