Diagrams


Table

Employee Posting Group

DynamicsDocs.comEmployee Posting Group«Table 5221»Employee Posting GroupCode [PK]Payables Account«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 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 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....<Payables Account><Employee Posting Group><Employee Posting Group><Manager No.><Employee No. Filter><Employee No.><Closed by Entry No.><Bal. Account No.>

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

Fields

# Name Type
1 Code Code20
2 Payables Account Code20

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Payables Account G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field
Employee Employee Posting Group 1..n
Employee Ledger Entry Employee Posting Group 1..n