Diagrams

Table

G/L Account Category

DynamicsDocs.comG/L Account Category«Table 570»G/L Account CategoryEntry No. [PK]Parent Entry No.Sibling Sequence No.Presentation OrderIndentationDescriptionAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Additional Report Definition; [,Operat...System GeneratedHas Children«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....<Account Subcategory Entry No.>

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 AutoIncrement: Yes
2 Parent Entry No. (Parent Entry No.) Integer
3 Sibling Sequence No. (Sibling Sequence No.) Integer
4 Presentation Order (Presentation Order) Text100
5 Indentation (Indentation) Integer
6 Description (Description) Text80
7 Account Category (Account Category) Option BlankZero: Yes
8 Income/Balance (Income/Balance) Option Editable: No
9 Additional Report Definition (Additional Report Definition) Option
11 System Generated (System Generated) Boolean
12 Has Children (Has Children) Boolean FlowField

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Presentation Order,Sibling Sequence No. (Presentation Order,Sibling Sequence No.)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
G/L Account Account Subcategory Entry No. (Account Subcategory Entry No.) 1..n