Diagrams


Table

Gen. Jnl. Allocation

DynamicsDocs.comGen. Jnl. Allocation«Table 221»Gen. Jnl. AllocationJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Account No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeAllocation QuantityAllocation %AmountGen. Posting Type; [,Purchase,Sale]Gen. Bus. Posting GroupGen. Prod. Posting GroupVAT Calculation Type; [Normal VAT,Reve...VAT AmountVAT %Account NameTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupAdditional-Currency AmountDimension Set ID«Table 80»Gen. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [General,Sales,Purchases,Cash Re...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionForce Doc. BalanceBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceCust. Receipt Report IDCust. Receipt Report CaptionVendor Receipt Report IDVendor Receipt Report Caption«Table 232»Gen. Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceAllow Payment ExportBank Statement Import FormatTemplate Type; [General,Sales,Purchase...RecurringSuggest Balancing Amount«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 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 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 ID«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Journal Template Name><Journal Batch Name><Journal Line No.><Account No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Dimension Set ID><Bal. Account No.><Journal Template Name><Journal Template Name><Bal. Account No.><Journal Batch Name><Account No.><Bal. Account No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Gen. Bus. Posting Group><Bal. Gen. Bus. Posting Group><Gen. Prod. Posting Group><Bal. Gen. Prod. Posting Group><Tax Area Code><Bal. Tax Area Code><Tax Group Code><Bal. Tax Group Code><VAT Bus. Posting Group><Bal. VAT Bus. Posting Group><VAT Prod. Posting Group><Bal. VAT Prod. Posting Group><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Dimension Value Code><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group>

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

Fields

# Name Type
1 Journal Template Name Code10
2 Journal Batch Name Code10
3 Journal Line No. Integer
4 Line No. Integer
5 Account No. Code20
6 Shortcut Dimension 1 Code Code20
7 Shortcut Dimension 2 Code Code20
8 Allocation Quantity Decimal (0:5)
9 Allocation % Decimal (2:2)
10 Amount Decimal
11 Gen. Posting Type Option
12 Gen. Bus. Posting Group Code10
13 Gen. Prod. Posting Group Code10
14 VAT Calculation Type Option Editable: No
15 VAT Amount Decimal Editable: No
16 VAT % Decimal (0:5) Editable: No
17 Account Name Text50 Editable: No
FlowField
18 Tax Area Code Code20
19 Tax Liable Boolean
20 Tax Group Code Code10
21 Use Tax Boolean
22 VAT Bus. Posting Group Code10
23 VAT Prod. Posting Group Code10
24 Additional-Currency Amount Decimal Editable: No
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Journal Line No.,Line No. Clustered: Yes
MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Account No. G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Journal Batch Name Gen. Journal Batch Name 1..n
Journal Line No. Gen. Journal Line Line No. 1..n
Journal Template Name Gen. Journal Template Name 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Tax Area Code Tax Area Code 1..n
Tax Group Code Tax Group Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field