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


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


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

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 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
Payment Method Code Employee Ledger Entry Payment Method Code 1..n

Table Relations From Other Tables

From Table From Field