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 (Code) Code20
2 Payables Account (Payables Account) Code20

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

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