Diagrams


Table

Detailed Employee Ledger Entry

DynamicsDocs.comDetailed Employee Ledger Entry«Table 5223»Detailed Employee Ledger EntryEntry No. [PK]Employee Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Employee No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Global Dim. 1Initial Entry Global Dim. 2Initial Document Type; [,Payment,Invoi...Applied Empl. Ledger Entry No.UnappliedUnapplied by Entry No.Application No.Ledger Entry Amount«Table 5222»Employee Ledger EntryEntry No. [PK]Employee No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Employee Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalespers./Purch. CodeUser IDSource CodeApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenPositiveClosed by Entry No.Closed at DateClosed by AmountApplies-to IDJournal Batch NameReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.Transaction No....«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time«Table 380»Detailed Vendor Ledg. EntryEntry No. [PK]Vendor Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Vendor No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Due DateInitial Entry Global Dim. 1Initial Entry Global Dim. 2Gen. Bus. Posting GroupGen. Prod. Posting GroupUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupInitial Document Type; [,Payment,Invoi...Applied Vend. Ledger Entry No.UnappliedUnapplied by Entry No....<Employee Ledger Entry No.><Employee No.><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><Unapplied by Entry No.><Employee No.><Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><User ID><Source Code><Closed by Entry No.><Reason Code><Manager No.><Employee No. Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><Unapplied by Entry No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Entry No. Integer
2 Employee Ledger Entry No. Integer
3 Entry Type Option
4 Posting Date Date
5 Document Type Option
6 Document No. Code20
7 Amount Decimal
8 Amount (LCY) Decimal
9 Employee No. Code20
10 Currency Code Code10
11 User ID Code50
12 Source Code Code10
13 Transaction No. Integer
14 Journal Batch Name Code10
15 Reason Code Code10
16 Debit Amount Decimal BlankZero: Yes
17 Credit Amount Decimal BlankZero: Yes
18 Debit Amount (LCY) Decimal BlankZero: Yes
19 Credit Amount (LCY) Decimal BlankZero: Yes
21 Initial Entry Global Dim. 1 Code20
22 Initial Entry Global Dim. 2 Code20
35 Initial Document Type Option
36 Applied Empl. Ledger Entry No. Integer
37 Unapplied Boolean
38 Unapplied by Entry No. Integer
42 Application No. Integer Editable: No
43 Ledger Entry Amount Boolean Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Unapplied by Entry No. Detailed Vendor Ledg. Entry Entry No. 1..n
Initial Entry Global Dim. 2 Dimension Value Code 1..n
Employee No. Employee No. 1..n
Employee Ledger Entry No. Employee Ledger Entry Entry No. 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field