Diagrams


Table

Employee Ledger Entry

DynamicsDocs.comEmployee Ledger Entry«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 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 5224»Payable Employee Ledger EntryEmployee No.Entry No. [PK]Employee Ledg. Entry No.AmountCurrency CodePositive«Table 5225»Employee Payment BufferEmployee No. [PK]Currency Code [PK]Employee Ledg. Entry No. [PK]Dimension Entry No. [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeDocument No.AmountEmployee Ledg. Entry Doc. Type; [,Paym...Employee Ledg. Entry Doc. No.Creditor No.Payment ReferencePayment Method CodeApplies-to Ext. Doc. No.Exported to Payment FileDimension Set ID«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 5221»Employee Posting GroupCode [PK]Payables Account«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 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next Task DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr......«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 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Employee No.><Currency Code><Employee Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Salespers./Purch. Code><User ID><Source Code><Closed by Entry No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Payment Method Code><Dimension Set ID><Employee Ledger Entry No.><Employee Ledg. Entry No.><Employee Ledg. Entry No.><Creditor No.><Payment Reference><Payment Method Code><Employee No.><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><Employee No.><Currency Code><Employee No.><Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><Manager No.><Employee No. Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Salespers./Purch. Code><No. Series><Employee Posting Group><Responsible Employee><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Customer Filter><Currency Code><Currency Filter><Currency Id><Vendor Filter><Currency Code><Currency Filter><Currency Id><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Payables Account><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Salesperson Code><Purchaser Code><Our Contact Code><Bal. Account No.><Bill-to Customer No.><Payment Method Code><Payment Method Id><No. Series><Pay-to Vendor No.><Payment Method Code><Payment Method Id><No. Series><Vendor No.><Maintenance Vendor No.><No. Series><Credit Transfer Msg. Nos.><Direct Debit Msg. Nos.><Bal. Account No.><Component of Main Asset><No. Series>

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
3 Employee No. Code20
4 Posting Date Date
5 Document Type Option
6 Document No. Code20
7 Description Text50
11 Currency Code Code10
13 Amount Decimal Editable: No
FlowField
14 Remaining Amount Decimal Editable: No
FlowField
15 Original Amt. (LCY) Decimal Editable: No
FlowField
16 Remaining Amt. (LCY) Decimal Editable: No
FlowField
17 Amount (LCY) Decimal Editable: No
FlowField
22 Employee Posting Group Code20
23 Global Dimension 1 Code Code20
24 Global Dimension 2 Code Code20
25 Salespers./Purch. Code Code20
27 User ID Code50
28 Source Code Code10
34 Applies-to Doc. Type Option
35 Applies-to Doc. No. Code20
36 Open Boolean
43 Positive Boolean
44 Closed by Entry No. Integer
45 Closed at Date Date
46 Closed by Amount Decimal
47 Applies-to ID Code50
49 Journal Batch Name Code10
50 Reason Code Code10
51 Bal. Account Type Option
52 Bal. Account No. Code20
53 Transaction No. Integer
54 Closed by Amount (LCY) Decimal
58 Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
59 Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
60 Debit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
61 Credit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
64 No. Series Code20
75 Original Amount Decimal Editable: No
FlowField
76 Date Filter Date FlowFilter
84 Amount to Apply Decimal
86 Applying Entry Boolean
170 Creditor No. Code20 [Numeric:Yes]
171 Payment Reference Code50 [Numeric:Yes]
172 Payment Method Code Code10
289 Message to Recipient Text140
290 Exported to Payment File Boolean Editable: No
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Employee No.,Applies-to ID,Open,Positive

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Currency Code Currency Code 1..n
Bal. Account No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Employee No. Employee No. 1..n
Closed by Entry No. Employee Ledger Entry Entry No. 1..n
Employee Posting Group Employee Posting Group Code 1..n
Bal. Account No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
No. Series No. Series Code 1..n
Payment Method Code Payment Method Code 1..n
Reason Code Reason Code Code 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n
Bal. Account No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Detailed Employee Ledger Entry Employee Ledger Entry No. 1..n
Employee Ledger Entry Closed by Entry No. 1..n
Employee Payment Buffer Payment Method Code 1..n
Payable Employee Ledger Entry Employee Ledg. Entry No. 1..n