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 Account«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.«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. (No.) Integer
2 Creation Date (Creation Date) Date
3 Account Type (Account Type) Option
4 Posting Group (Posting Group) Code10
5 Currency Code (Currency Code) Code10
6 Currency Factor (Currency Factor) Decimal (0:15)
7 Adjusted Base (Adjusted Base) Decimal
8 Adjusted Base (LCY) (Adjusted Base (LCY)) Decimal
9 Adjusted Amt. (LCY) (Adjusted Amt. (LCY)) Decimal
10 Adjusted Base (Add.-Curr.) (Adjusted Base (Add.-Curr.)) Decimal
11 Adjusted Amt. (Add.-Curr.) (Adjusted Amt. (Add.-Curr.)) Decimal

Keys

# Fields
0 No. (No.) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field