Diagrams


Table

Exch. Rate Adjmt. Reg.

DynamicsDocs.comExch. Rate Adjmt. Reg.«Table 86»Exch. Rate Adjmt. Reg.No. [PK]Creation DateAccount Type; [G/L Account,Customer,Ve...Posting GroupCurrency CodeCurrency FactorAdjusted BaseAdjusted Base [LCY]Adjusted Amt. [LCY]Adjusted Base [Add.-Curr.]Adjusted Amt. [Add.-Curr.]«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line AccountDescriptionUsed in CustomersUsed in Ledger Entries«Table 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.DescriptionUsed in VendorsUsed in Ledger Entries«Table 277»Bank Account Posting GroupCode [PK,NN]G/L Bank Account No.«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]...<Posting Group><Posting Group><Posting Group><Currency Code>

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

Fields

# Name Type
1 No. Integer
2 Creation Date Date
3 Account Type Option
4 Posting Group Code20
5 Currency Code Code10
6 Currency Factor Decimal (0:15)
7 Adjusted Base Decimal
8 Adjusted Base (LCY) Decimal
9 Adjusted Amt. (LCY) Decimal
10 Adjusted Base (Add.-Curr.) Decimal
11 Adjusted Amt. (Add.-Curr.) Decimal

Keys

# Fields
0 No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Posting Group Bank Account Posting Group Code 1..n
Currency Code Currency Code 1..n
Posting Group Customer Posting Group Code 1..n
Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field