Diagrams


Table

Business Unit

DynamicsDocs.comBusiness Unit«Table 220»Business UnitCode [PK,NN]ConsolidateConsolidation %Starting DateEnding DateIncome Currency FactorBalance Currency FactorExch. Rate Losses Acc.Exch. Rate Gains Acc.Residual AccountLast Balance Currency FactorNameCompany NameCurrency CodeComp. Exch. Rate Gains Acc.Comp. Exch. Rate Losses Acc.Equity Exch. Rate Gains Acc.Equity Exch. Rate Losses Acc.Minority Exch. Rate Gains Acc.Minority Exch. Rate Losses AccCurrency Exchange Rate Table; [Local,B...Data Source; [Local Curr. <LCY>,Add. R...File Format; [Version 4.00 or Later <....«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 Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«Table 365»Analysis View EntryAnalysis View Code [PK,NN]Business Unit Code [PK]Account No. [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Dimension 4 Value Code [PK]Posting Date [PK]Entry No. [PK]AmountDebit AmountCredit AmountAdd.-Curr. AmountAdd.-Curr. Debit AmountAdd.-Curr. Credit AmountAccount Source; [G/L Account,Cash Flow...Cash Flow Forecast No. [PK]«Table 366»Analysis View Budget EntryAnalysis View Code [PK,NN]Budget Name [PK]Business Unit Code [PK]G/L Account No. [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Dimension 4 Value Code [PK]Posting Date [PK]Entry No. [PK]Amount«Table 368»Dimension Selection BufferCode [PK]DescriptionSelectedNew Dimension Value CodeDimension Value FilterLevel; [,Level 1,Level 2,Level 3,Level...Filter Lookup Table No.«Table 374»G/L Acc. Budget BufferCode [PK,NN]Budget FilterG/L Account FilterBusiness Unit FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBudget Dimension 1 FilterBudget Dimension 2 FilterBudget Dimension 3 FilterBudget Dimension 4 FilterDate FilterBudgeted Amount«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....«Table 395»XBRL Taxonomy LineXBRL Taxonomy Name [PK,NN]Line No. [PK]NameLevelLabelSource Type; [Not Applicable,Rollup,Co...Constant AmountDescriptionXBRL Item TypeParent Line No.InformationRollupG/L Map LinesNotesBusiness Unit FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterXBRL Schema Line No.Label Language FilterPresentation OrderPresentation Order No.ReferenceElement IDNumeric Context Period Type; [,Instant...Presentation Linkbase Line No.Type Description Element«Table 751»Standard General Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Account Type; [G/L Account,Customer,Ve...Account No.Document Type; [,Payment,Invoice,Credi...DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Payment Discount %Job No.QuantityVAT AmountPayment Terms Code...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 85»Acc. Schedule LineSchedule Name [PK]Line No. [PK]Row No.DescriptionTotalingTotaling Type; [Posting Accounts,Total...New PageIndentationDate FilterDimension 1 FilterDimension 2 FilterG/L Budget FilterBusiness Unit FilterShow; [Yes,No,If Any Column Not Zero,W...Dimension 3 FilterDimension 4 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingDimension 4 TotalingBoldItalicUnderlineShow Opposite SignRow Type; [Net Change,Balance at Date,...Amount Type; [Net Amount,Debit Amount,...Double UnderlineCash Flow Forecast FilterCost Center FilterCost Object FilterCost Center Totaling...«Table 96»G/L Budget EntryEntry No. [PK]Budget NameG/L Account No.DateGlobal Dimension 1 CodeGlobal Dimension 2 CodeAmountDescriptionBusiness Unit CodeUser IDBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 CodeLast Date ModifiedDimension Set ID«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]...<Exch. Rate Losses Acc.><Exch. Rate Gains Acc.><Residual Account><Comp. Exch. Rate Gains Acc.><Comp. Exch. Rate Losses Acc.><Equity Exch. Rate Gains Acc.><Equity Exch. Rate Losses Acc.><Minority Exch. Rate Gains Acc.><Minority Exch. Rate Losses Acc><Business Unit Filter><Currency Code><Business Unit Code><Business Unit Code><Business Unit Code><New Dimension Value Code><Business Unit Filter><Business Unit Filter><Business Unit Filter><Business Unit Code><Business Unit Code><Business Unit Filter><Business Unit Code><G/L Account No.><Bal. Account No.><Account No.><G/L Account No.><New Dimension Value Code><No.><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Account No.><Bal. Account No.><Account No.><Bal. Account No.><G/L Account No.><Reversed by Entry No.><Reversed Entry No.><Currency Code><Currency Code><Source Currency Code>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Consolidate Boolean
3 Consolidation % Decimal (1:1)
4 Starting Date Date
5 Ending Date Date
6 Income Currency Factor Decimal (0:15) Editable: No
7 Balance Currency Factor Decimal (0:15) Editable: No
8 Exch. Rate Losses Acc. Code20
9 Exch. Rate Gains Acc. Code20
10 Residual Account Code20
11 Last Balance Currency Factor Decimal (0:15) Editable: No
12 Name Text30
13 Company Name Text30
14 Currency Code Code10
15 Comp. Exch. Rate Gains Acc. Code20
16 Comp. Exch. Rate Losses Acc. Code20
17 Equity Exch. Rate Gains Acc. Code20
18 Equity Exch. Rate Losses Acc. Code20
19 Minority Exch. Rate Gains Acc. Code20
20 Minority Exch. Rate Losses Acc Code20
21 Currency Exchange Rate Table Option
22 Data Source Option
23 File Format Option

Keys

# Fields
0 Code Clustered: Yes
1 Company Name

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Minority Exch. Rate Losses Acc G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field
Acc. Schedule Line Business Unit Filter 1..n
Analysis View Budget Entry Business Unit Code 1..n
Analysis View Entry Business Unit Code 1..n
Dimension Selection Buffer New Dimension Value Code 1..n
G/L Acc. Budget Buffer Business Unit Filter 1..n
G/L Account Business Unit Filter 1..n
G/L Account (Analysis View) Business Unit Filter 1..n
G/L Budget Entry Business Unit Code 1..n
G/L Entry Business Unit Code 1..n
Gen. Journal Line Business Unit Code 1..n
Standard General Journal Line Business Unit Code 1..n
XBRL Taxonomy Line Business Unit Filter 1..n