Diagrams

Table

G/L Entry

DynamicsDocs.comG/L Entry«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 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountSorting OrderStmt To Rem. Amount Difference«Table 5823»G/L - Item Ledger RelationG/L Entry No. [PK,NN]Value Entry No. [PK,NN]G/L Register No.«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...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 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.Business Unit Filter...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting Group«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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<G/L Account No.><Bal. Account No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><IC Partner Code><Job No.><Business Unit Code><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Reversed by Entry No.><Reversed Entry No.><Applies-to Entry No.><G/L Entry No.><Bank Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Business Unit Filter><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><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Receivables Account><Payables Account><Bill-to Customer No.><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Bill-to Customer No.><Pay-to Vendor No.><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Vendor No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset><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 Entry No. (Entry No.) Integer
3 G/L Account No. (G/L Account No.) Code20
4 Posting Date (Posting Date) Date [ClosingDates:Yes]
5 Document Type (Document Type) Option
6 Document No. (Document No.) Code20
7 Description (Description) Text50
10 Bal. Account No. (Bal. Account No.) Code20
17 Amount (Amount) Decimal
23 Global Dimension 1 Code (Global Dimension 1 Code) Code20
24 Global Dimension 2 Code (Global Dimension 2 Code) Code20
27 User ID (User ID) Code50
28 Source Code (Source Code) Code10
29 System-Created Entry (System-Created Entry) Boolean
30 Prior-Year Entry (Prior-Year Entry) Boolean
41 Job No. (Job No.) Code20
42 Quantity (Quantity) Decimal (0:5)
43 VAT Amount (VAT Amount) Decimal
45 Business Unit Code (Business Unit Code) Code20
46 Journal Batch Name (Journal Batch Name) Code10
47 Reason Code (Reason Code) Code10
48 Gen. Posting Type (Gen. Posting Type) Option
49 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
50 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
51 Bal. Account Type (Bal. Account Type) Option
52 Transaction No. (Transaction No.) Integer
53 Debit Amount (Debit Amount) Decimal BlankZero: Yes
54 Credit Amount (Credit Amount) Decimal BlankZero: Yes
55 Document Date (Document Date) Date [ClosingDates:Yes]
56 External Document No. (External Document No.) Code35
57 Source Type (Source Type) Option
58 Source No. (Source No.) Code20
59 No. Series (No. Series) Code10
60 Tax Area Code (Tax Area Code) Code20
61 Tax Liable (Tax Liable) Boolean
62 Tax Group Code (Tax Group Code) Code10
63 Use Tax (Use Tax) Boolean
64 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
65 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
68 Additional-Currency Amount (Additional-Currency Amount) Decimal
69 Add.-Currency Debit Amount (Add.-Currency Debit Amount) Decimal
70 Add.-Currency Credit Amount (Add.-Currency Credit Amount) Decimal
71 Close Income Statement Dim. ID (Close Income Statement Dim. ID) Integer
72 IC Partner Code (IC Partner Code) Code20
73 Reversed (Reversed) Boolean
74 Reversed by Entry No. (Reversed by Entry No.) Integer BlankZero: Yes
75 Reversed Entry No. (Reversed Entry No.) Integer BlankZero: Yes
76 G/L Account Name (G/L Account Name) Text50 Editable: No
FlowField
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
5400 Prod. Order No. (Prod. Order No.) Code20
5600 FA Entry Type (FA Entry Type) Option
5601 FA Entry No. (FA Entry No.) Integer BlankZero: Yes

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 G/L Account No.,Posting Date (G/L Account No.,Posting Date)
2 G/L Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date (G/L Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date)
3 G/L Account No.,Business Unit Code,Posting Date (G/L Account No.,Business Unit Code,Posting Date)
4 G/L Account No.,Business Unit Code,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date (G/L Account No.,Business Unit Code,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date)
5 Document No.,Posting Date (Document No.,Posting Date)
6 Transaction No. (Transaction No.)
7 IC Partner Code (IC Partner Code)
8 G/L Account No.,Job No.,Posting Date (G/L Account No.,Job No.,Posting Date)
9 Posting Date,G/L Account No.,Dimension Set ID (Posting Date,G/L Account No.,Dimension Set ID)

Table Relations To Other Tables

Field Related Table Related Field
Source No. (Source No.) Bank Account No. (No.) 1..n
Business Unit Code (Business Unit Code) Business Unit Code (Code) 1..n
Source No. (Source No.) Customer No. (No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
FA Entry No. (FA Entry No.) FA Ledger Entry Entry No. (Entry No.) 1..n
Source No. (Source No.) Fixed Asset No. (No.) 1..n
Bal. Account No. (Bal. Account No.) G/L Account No. (No.) 1..n
Reversed Entry No. (Reversed Entry No.) G/L Entry Entry No. (Entry No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
IC Partner Code (IC Partner Code) IC Partner Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
FA Entry No. (FA Entry No.) Maintenance Ledger Entry Entry No. (Entry No.) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
Tax Group Code (Tax Group Code) Tax Group Code (Code) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n
Source No. (Source No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Applies-to Entry No. (Applies-to Entry No.) 1..n
Cost Entry G/L Entry No. (G/L Entry No.) 1..n
Cost Journal Line G/L Entry No. (G/L Entry No.) 1..n
Cost Register To G/L Entry No. (To G/L Entry No.) 1..n
FA Ledger Entry G/L Entry No. (G/L Entry No.) 1..n
G/L - Item Ledger Relation G/L Entry No. (G/L Entry No.) 1..n
G/L Entry Reversed Entry No. (Reversed Entry No.) 1..n
G/L Entry - VAT Entry Link G/L Entry No. (G/L Entry No.) 1..n
G/L Register To Entry No. (To Entry No.) 1..n
Job Journal Line Ledger Entry No. (Ledger Entry No.) 1..n
Job Ledger Entry Ledger Entry No. (Ledger Entry No.) 1..n
Job Planning Line Ledger Entry No. (Ledger Entry No.) 1..n
Job WIP G/L Entry G/L Entry No. (G/L Entry No.) 1..n
Maintenance Ledger Entry G/L Entry No. (G/L Entry No.) 1..n
Payment Application Proposal Applies-to Entry No. (Applies-to Entry No.) 1..n
Reversal Entry Entry No. (Entry No.) 1..n