Detailed Employee Ledger Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5223

Table Type: Company

Table Name: Detailed Employee Ledger Entry
Database Table Name: CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5223

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Detailed Employee Ledger Entry can be queried.

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in Detailed Employee Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Employee Ledger Entry No. Primary Key SearchEmployee Ledger Entry No.NormalInteger4Employee Ledger Entry No_int
Key to join to the Employee Ledger Entry table.

Show/hide example query

3Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “”
  • “Initial Entry”
  • “Application”
  • “Unrealized Loss”
  • “Unrealized Gain”
  • “Realized Loss”
  • “Realized Gain”
  • “Payment Discount”
  • “Payment Discount (VAT Excl.)”
  • “Payment Discount (VAT Adjustment)”
  • “Appln. Rounding”
  • “Correction of Remaining Amount”
  • “Payment Tolerance”
  • “Payment Discount Tolerance”
  • “Payment Tolerance (VAT Excl.)”
  • “Payment Tolerance (VAT Adjustment)”
  • “Payment Discount Tolerance (VAT Excl.)”
  • “Payment Discount Tolerance (VAT Adjustment)”
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
8Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
9Employee No. SearchEmployee No.NormalCode20Employee No_nvarchar(40)
Key to join to the Employee table.

Show/hide example query

10Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

11User ID SearchUser IDNormalCode50User IDnvarchar(100)
12Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

13Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
14Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
15Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

16Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
17Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
18Debit Amount (LCY) SearchDebit Amount ($)NormalDecimal12Debit Amount (LCY)decimal(38,38)
19Credit Amount (LCY) SearchCredit Amount ($)NormalDecimal12Credit Amount (LCY)decimal(38,38)
21Initial Entry Global Dim. 1 SearchInitial Entry Global Dim. 1NormalCode20Initial Entry Global Dim_ 1nvarchar(40)
22Initial Entry Global Dim. 2 SearchInitial Entry Global Dim. 2NormalCode20Initial Entry Global Dim_ 2nvarchar(40)
35Initial Document Type SearchInitial Document TypeNormalOption4Initial Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
36Applied Empl. Ledger Entry No. SearchApplied Empl. Ledger Entry No.NormalInteger4Applied Empl_ Ledger Entry No_int
37Unapplied SearchUnappliedNormalBoolean4Unappliedtinyint
38Unapplied by Entry No. SearchUnapplied by Entry No.NormalInteger4Unapplied by Entry No_int
42Application No. SearchApplication No.NormalInteger4Application No_int
43Ledger Entry Amount SearchLedger Entry AmountNormalBoolean4Ledger Entry Amounttinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Detailed Employee Ledger Entry table

Leave a Reply

Your email address will not be published. Required fields are marked *