Diagrams

Table

Import G/L Transaction

DynamicsDocs.comImport G/L Transaction«Table 1661»Import G/L TransactionApp ID [PK]External Account [PK]G/L AccountG/L Account NameEntry No. [PK]Transaction DateAmountDescription«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....<G/L Account>

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

Fields

# Name Type
1 App ID (App ID) GUID Editable: No
2 External Account (External Account) Code20
3 G/L Account (G/L Account) Code20
4 G/L Account Name (G/L Account Name) Text30 Editable: No
FlowField
5 Entry No. (Entry No.) Integer AutoIncrement: Yes
10 Transaction Date (Transaction Date) Date
12 Amount (Amount) Decimal
13 Description (Description) Text50

Keys

# Fields
0 App ID,External Account,Entry No. (App ID,External Account,Entry No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
G/L Account (G/L Account) G/L Account () 1..n

Table Relations From Other Tables

From Table From Field