General Ledger table in Microsoft Dynamics 365 Business Central. 47 fields, 7 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Code.
| 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 | 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 |
Tables referenced by fields on the Salesperson/Purchaser table through TableRelation properties.