Other table in Microsoft Dynamics 365 Business Central. 34 fields, 0 records in Cronus demo.
The Detailed Employee Ledger Entry table (ID 5223) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 34 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Entry No. PK | Integer | Normal | |
| 2 | Employee Ledger Entry No. | Integer | Normal | → Employee Ledger Entry #5222 |
| 3 | Entry Type | Option | Normal | |
| 4 | Posting Date | Date | Normal | |
| 5 | Document Type | Option | Normal | |
| 6 | Document No. | Code | Normal | |
| 7 | Amount | Decimal | Normal | |
| 8 | Amount (LCY) | Decimal | Normal | |
| 9 | Employee No. | Code | Normal | → Employee #5200 |
| 10 | Currency Code | Code | Normal | → Currency #4 |
| 11 | User ID | Code | Normal | |
| 12 | Source Code | Code | Normal | → Source Code #230 |
| 13 | Transaction No. | Integer | Normal | |
| 14 | Journal Batch Name | Code | Normal | |
| 15 | Reason Code | Code | Normal | → Reason Code #231 |
| 16 | Debit Amount | Decimal | Normal | |
| 17 | Credit Amount | Decimal | Normal | |
| 18 | Debit Amount (LCY) | Decimal | Normal | |
| 19 | Credit Amount (LCY) | Decimal | Normal | |
| 21 | Initial Entry Global Dim. 1 | Code | Normal | → Dimension Value #349 |
| 22 | Initial Entry Global Dim. 2 | Code | Normal | → Dimension Value #349 |
| 35 | Initial Document Type | Option | Normal | |
| 36 | Applied Empl. Ledger Entry No. | Integer | Normal | |
| 37 | Unapplied | Boolean | Normal | |
| 38 | Unapplied by Entry No. | Integer | Normal | → Detailed Employee Ledger Entry #5223 |
| 42 | Application No. | Integer | Normal | |
| 43 | Ledger Entry Amount | Boolean | Normal | |
| 44 | Employee Posting Group | Code | Normal | → Employee Posting Group #5221 |
| 45 | Exch. Rate Adjmt. Reg. No. | Integer | Normal | → Exch. Rate Adjmt. Reg. #86 |
| 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 Detailed Employee Ledger Entry table through TableRelation properties.