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: 5223Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Entry No_]
,[Employee Ledger Entry No_]
,[Entry Type]
,[Posting Date]
,[Document Type]
,[Document No_]
,[Amount]
,[Amount (LCY)]
,[Employee No_]
,[Currency Code]
,[User ID]
,[Source Code]
,[Transaction No_]
,[Journal Batch Name]
,[Reason Code]
,[Debit Amount]
,[Credit Amount]
,[Debit Amount (LCY)]
,[Credit Amount (LCY)]
,[Initial Entry Global Dim_ 1]
,[Initial Entry Global Dim_ 2]
,[Initial Document Type]
,[Applied Empl_ Ledger Entry No_]
,[Unapplied]
,[Unapplied by Entry No_]
,[Application No_]
,[Ledger Entry Amount]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[Detailed Employee Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
AND
[Detailed Employee Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[Detailed Employee Ledger Entry].[Document Type] = [Sales Header].[Document Type]
AND
[Detailed Employee Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Detailed Employee Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Detailed Employee Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Detailed Employee Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
[User] AS [User]
ON
[Detailed Employee Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Detailed Employee Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Entry No.  | Entry No. | Normal | Integer | 4 | Entry No_ | int |
| 2 | Employee Ledger Entry No.  | Employee Ledger Entry No. | Normal | Integer | 4 | Employee Ledger Entry No_ | int |
| Key to join to the Employee Ledger Entry table.SELECT
[Detailed Employee Ledger Entry].[Employee Ledger Entry No_]
,[Employee Ledger Entry].[Entry No_]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
ON
[Detailed Employee Ledger Entry].[Employee Ledger Entry No_] = [Employee Ledger Entry].[Entry No_] |
| 3 | Entry Type | Entry Type | Normal | Option | 4 | Entry Type | int |
| 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)”
|
| 4 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
| 5 | Document Type | Document Type | Normal | Option | 4 | Document Type | int |
| Available options are:
- ” “
- “Payment”
- “Invoice”
- “Credit Memo”
- “Finance Charge Memo”
- “Reminder”
- “Refund”
|
| 6 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
| 7 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
| 8 | Amount (LCY) | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
| 9 | Employee No. | Employee No. | Normal | Code | 20 | Employee No_ | nvarchar(40) |
| Key to join to the Employee table.SELECT
[Detailed Employee Ledger Entry].[Employee No_]
,[Employee].[No_]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
ON
[Detailed Employee Ledger Entry].[Employee No_] = [Employee].[No_] |
| 10 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
| Key to join to the Currency table.SELECT
[Detailed Employee Ledger Entry].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Detailed Employee Ledger Entry].[Currency Code] = [Currency].[Code] |
| 11 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 12 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
| Key to join to the Source Code table.SELECT
[Detailed Employee Ledger Entry].[Source Code]
,[Source Code].[Code]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Detailed Employee Ledger Entry].[Source Code] = [Source Code].[Code] |
| 13 | Transaction No. | Transaction No. | Normal | Integer | 4 | Transaction No_ | int |
| 14 | Journal Batch Name | Journal Batch Name | Normal | Code | 10 | Journal Batch Name | nvarchar(20) |
| 15 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
| Key to join to the Reason Code table.SELECT
[Detailed Employee Ledger Entry].[Reason Code]
,[Reason Code].[Code]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Detailed Employee Ledger Entry].[Reason Code] = [Reason Code].[Code] |
| 16 | Debit Amount | Debit Amount | Normal | Decimal | 12 | Debit Amount | decimal(38,38) |
| 17 | Credit Amount | Credit Amount | Normal | Decimal | 12 | Credit Amount | decimal(38,38) |
| 18 | Debit Amount (LCY) | Debit Amount ($) | Normal | Decimal | 12 | Debit Amount (LCY) | decimal(38,38) |
| 19 | Credit Amount (LCY) | Credit Amount ($) | Normal | Decimal | 12 | Credit Amount (LCY) | decimal(38,38) |
| 21 | Initial Entry Global Dim. 1 | Initial Entry Global Dim. 1 | Normal | Code | 20 | Initial Entry Global Dim_ 1 | nvarchar(40) |
| 22 | Initial Entry Global Dim. 2 | Initial Entry Global Dim. 2 | Normal | Code | 20 | Initial Entry Global Dim_ 2 | nvarchar(40) |
| 35 | Initial Document Type | Initial Document Type | Normal | Option | 4 | Initial Document Type | int |
| Available options are:
- ” “
- “Payment”
- “Invoice”
- “Credit Memo”
- “Finance Charge Memo”
- “Reminder”
- “Refund”
|
| 36 | Applied Empl. Ledger Entry No. | Applied Empl. Ledger Entry No. | Normal | Integer | 4 | Applied Empl_ Ledger Entry No_ | int |
| 37 | Unapplied | Unapplied | Normal | Boolean | 4 | Unapplied | tinyint |
| 38 | Unapplied by Entry No. | Unapplied by Entry No. | Normal | Integer | 4 | Unapplied by Entry No_ | int |
| 42 | Application No. | Application No. | Normal | Integer | 4 | Application No_ | int |
| 43 | Ledger Entry Amount | Ledger Entry Amount | Normal | Boolean | 4 | Ledger Entry Amount | tinyint |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
| Key to join to the User table.SELECT
[Detailed Employee Ledger Entry].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
[User] AS [User]
ON
[Detailed Employee Ledger Entry].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
