Diagrams


Table

Column Layout

Fields

# Name Type
1 Column Layout Name (Column Layout Name) Code10
2 Line No. (Line No.) Integer
3 Column No. (Column No.) Code10
4 Column Header (Column Header) Text30
5 Column Type (Column Type) Option
6 Ledger Entry Type (Ledger Entry Type) Option
7 Amount Type (Amount Type) Option
8 Formula (Formula) Code80
9 Comparison Date Formula (Comparison Date Formula) DateFormula
10 Show Opposite Sign (Show Opposite Sign) Boolean
11 Show (Show) Option NotBlank: Yes
12 Rounding Factor (Rounding Factor) Option
14 Comparison Period Formula (Comparison Period Formula) Code20
15 Business Unit Totaling (Business Unit Totaling) Text80
16 Dimension 1 Totaling (Dimension 1 Totaling) Text80
17 Dimension 2 Totaling (Dimension 2 Totaling) Text80
18 Dimension 3 Totaling (Dimension 3 Totaling) Text80
19 Dimension 4 Totaling (Dimension 4 Totaling) Text80
20 Cost Center Totaling (Cost Center Totaling) Text80
21 Cost Object Totaling (Cost Object Totaling) Text80

Keys

# Fields
0 Column Layout Name,Line No. (Column Layout Name,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Column Layout Name (Column Layout Name) Column Layout Name Name (Name) 1..n

Table Relations From Other Tables

From Table From Field
Acc. Sched. Chart Setup Line Column Layout Line No. (Column Layout Line No.) 1..n