TableExtension 376 G/L Account (Analysis View)

TableExtension 18004104 EOSxxx

Fields

EOS Balance at Date (Sim) (18004100)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Analysis View Entry".Amount WHERE("Analysis View Code" = FIELD("Analysis View Filter"), "Business Unit Code" = FIELD("Business Unit Filter"), "Account No." = FIELD("No."), "Account Source" = FIELD("Account Source"), "Account No." = FIELD(FILTER(Totaling)), "Dimension 1 Value Code" = FIELD("Dimension 1 Filter"), "Dimension 2 Value Code" = FIELD("Dimension 2 Filter"), "Dimension 3 Value Code" = FIELD("Dimension 3 Filter"), "Dimension 4 Value Code" = FIELD("Dimension 4 Filter"), "Posting Date" = FIELD(UPPERLIMIT("Date Filter")), "EOS Simulation" = Const(true)))

EOS Net Change (Sim) (18004101)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Analysis View Entry".Amount WHERE("Analysis View Code" = FIELD("Analysis View Filter"), "Business Unit Code" = FIELD("Business Unit Filter"), "Account No." = FIELD("No."), "Account Source" = FIELD("Account Source"), "Account No." = FIELD(FILTER(Totaling)), "Dimension 1 Value Code" = FIELD("Dimension 1 Filter"), "Dimension 2 Value Code" = FIELD("Dimension 2 Filter"), "Dimension 3 Value Code" = FIELD("Dimension 3 Filter"), "Dimension 4 Value Code" = FIELD("Dimension 4 Filter"), "Posting Date" = FIELD("Date Filter"), "EOS Simulation" = Const(true)))

EOS Balance (Sim) (18004102)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Analysis View Entry".Amount WHERE("Analysis View Code" = FIELD("Analysis View Filter"), "Business Unit Code" = FIELD("Business Unit Filter"), "Account No." = FIELD("No."), "Account Source" = FIELD("Account Source"), "Account No." = FIELD(FILTER(Totaling)), "Dimension 1 Value Code" = FIELD("Dimension 1 Filter"), "Dimension 2 Value Code" = FIELD("Dimension 2 Filter"), "Dimension 3 Value Code" = FIELD("Dimension 3 Filter"), "Dimension 4 Value Code" = FIELD("Dimension 4 Filter"), "Posting Date" = FIELD("Date Filter"), "EOS Simulation" = Const(true)))

EOS Balance at Date (GL) (18004103)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Analysis View Entry".Amount WHERE("Analysis View Code" = FIELD("Analysis View Filter"), "Business Unit Code" = FIELD("Business Unit Filter"), "Account No." = FIELD("No."), "Account Source" = FIELD("Account Source"), "Account No." = FIELD(FILTER(Totaling)), "Dimension 1 Value Code" = FIELD("Dimension 1 Filter"), "Dimension 2 Value Code" = FIELD("Dimension 2 Filter"), "Dimension 3 Value Code" = FIELD("Dimension 3 Filter"), "Dimension 4 Value Code" = FIELD("Dimension 4 Filter"), "Posting Date" = FIELD(UPPERLIMIT("Date Filter")), "EOS Simulation" = Const(false)))

EOS Net Change (GL) (18004104)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Analysis View Entry".Amount WHERE("Analysis View Code" = FIELD("Analysis View Filter"), "Business Unit Code" = FIELD("Business Unit Filter"), "Account No." = FIELD("No."), "Account Source" = FIELD("Account Source"), "Account No." = FIELD(FILTER(Totaling)), "Dimension 1 Value Code" = FIELD("Dimension 1 Filter"), "Dimension 2 Value Code" = FIELD("Dimension 2 Filter"), "Dimension 3 Value Code" = FIELD("Dimension 3 Filter"), "Dimension 4 Value Code" = FIELD("Dimension 4 Filter"), "Posting Date" = FIELD("Date Filter"), "EOS Simulation" = Const(false)))

EOS Balance (GL) (18004105)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Analysis View Entry".Amount WHERE("Analysis View Code" = FIELD("Analysis View Filter"), "Business Unit Code" = FIELD("Business Unit Filter"), "Account No." = FIELD("No."), "Account Source" = FIELD("Account Source"), "Account No." = FIELD(FILTER(Totaling)), "Dimension 1 Value Code" = FIELD("Dimension 1 Filter"), "Dimension 2 Value Code" = FIELD("Dimension 2 Filter"), "Dimension 3 Value Code" = FIELD("Dimension 3 Filter"), "Dimension 4 Value Code" = FIELD("Dimension 4 Filter"), "Posting Date" = FIELD("Date Filter"), "EOS Simulation" = Const(false)))


EOS Labs -