TableExtension 15 G/L Account

TableExtension 18004123 EOS_TableExt18004123

Fields

EOS Entry Type Filter (18004105)

Option

FieldClass: FlowFilter

" " (0) , Opening (1) , Closure (2)

EOS Allow Sim. Posting (18004127)

Boolean

EOS Balance at Date (Sim.) (18004122)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Sim. G/L Entry"."Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field(upperlimit("Date Filter")), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS Net Change (Sim.) (18004123)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Sim. G/L Entry"."Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field("Date Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS Balance (Sim.) (18004124)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Sim. G/L Entry"."Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS Debit Amount (Sim.) (18004125)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Sim. G/L Entry"."Debit Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field("Date Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS Credit Amount (Sim.) (18004126)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Sim. G/L Entry"."Credit Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field("Date Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS DTI Bal. at Date (18122511)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS001 DTI Entry"."Amount (LCY)" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Posting Date" = field(upperlimit("Date Filter")), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS DTI Net Change (18122512)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS001 DTI Entry"."Amount (LCY)" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Posting Date" = field("Date Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS Bal. at Date (Entry Type) (18004100)

Decimal

FieldClass: FlowField

CalcFormula: Sum("G/L Entry"."Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field(upperlimit("Date Filter"))) )

EOS Net Change (Entry Type) (18004101)

Decimal

FieldClass: FlowField

CalcFormula: Sum("G/L Entry"."Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field("Date Filter")) )

EOS Balance (Entry Type) (18004102)

Decimal

FieldClass: FlowField

CalcFormula: Sum("G/L Entry"."Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter")) )

EOS Debit Amount (Entry Type) (18004103)

Decimal

FieldClass: FlowField

CalcFormula: Sum("G/L Entry"."Debit Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field("Date Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )

EOS Credit Amount (Entry Type) (18004104)

Decimal

FieldClass: FlowField

CalcFormula: Sum("G/L Entry"."Credit Amount" where( "G/L Account No." = field("No."), "G/L Account No." = field(filter(Totaling)), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "EOS Entry Type" = field("EOS Entry Type Filter"), "Posting Date" = field("Date Filter"), "Dimension Set ID" = field("Dimension Set ID Filter")) )


EOS Labs -