Diagrams


Table

Employee Payment Buffer

DynamicsDocs.comEmployee Payment Buffer«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 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 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 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 Ledg. Entry No.><Creditor No.><Payment Reference><Payment Method 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><Employee No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><Closed by Entry No.><Dimension Set ID><Dimension Value Code>

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

Fields

# Name Type
1 Employee No. (Employee No.) Code20
2 Currency Code (Currency Code) Code10
3 Employee Ledg. Entry No. (Employee Ledg. Entry No.) Integer
4 Dimension Entry No. (Dimension Entry No.) Integer
5 Global Dimension 1 Code (Global Dimension 1 Code) Code20
6 Global Dimension 2 Code (Global Dimension 2 Code) Code20
7 Document No. (Document No.) Code20
8 Amount (Amount) Decimal
9 Employee Ledg. Entry Doc. Type (Employee Ledg. Entry Doc. Type) Option
10 Employee Ledg. Entry Doc. No. (Employee Ledg. Entry Doc. No.) Code20
170 Creditor No. (Creditor No.) Code20 [Numeric:Yes]
171 Payment Reference (Payment Reference) Code50 [Numeric:Yes]
172 Payment Method Code (Payment Method Code) Code10
173 Applies-to Ext. Doc. No. (Applies-to Ext. Doc. No.) Code35
290 Exported to Payment File (Exported to Payment File) Boolean Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Employee No.,Currency Code,Employee Ledg. Entry No.,Dimension Entry No. (Employee No.,Currency Code,Employee Ledg. Entry No.,Dimension Entry No.) Clustered: Yes
1 Document No. (Document No.)

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Employee No. (Employee No.) Employee No. (No.) 1..n
Payment Method Code (Payment Method Code) Employee Ledger Entry Payment Method Code (Payment Method Code) 1..n

Table Relations From Other Tables

From Table From Field