Table 18091486 EOS077 Store Real Time Stats

Table 18091486 EOS077 Store Real Time Stats

LanguageCaption
en-USStore Real Time Statistics
it-ITStatistiche negozio real time

Fields

Primary Key (1)

Code[10]

LanguageCaption
en-USPrimary Key
it-ITChiave primaria

Store No. Filter (2)

Code[10]

FieldClass: FlowFilter

LanguageCaption
en-USStore No. Filter
it-ITFiltro nr. negozio

Date Filter (3)

Date

FieldClass: FlowFilter

LanguageCaption
en-USDate Filter
it-ITFiltro data

Infocode Filter (4)

Code[10]

FieldClass: FlowFilter

LanguageCaption
en-USInfocode Filter
it-ITFiltro infocode

Trans. Count (5)

Integer

FieldClass: FlowField

CalcFormula: Count("LSC Transaction Header" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USTrans. Count
it-ITCont. transazioni

Net Amount (6)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header"."Net Amount" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USNet Amount
it-ITImporto netto

Cost Amount (7)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header"."Cost Amount" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USCost Amount
it-ITImporto costo

Gross Amount (8)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header"."Gross Amount" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USGross Amount
it-ITImporto lordo

Payment (9)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header".Payment WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USPayment
it-ITPagamento

Discount Amount (10)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header"."Discount Amount" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USDiscount Amount
it-ITImporto sconto

Total Discount (11)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header"."Total Discount" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USTotal Discount
it-ITSconto totale

No. of Items (12)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Transaction Header"."No. of Items" WHERE("Transaction Type" = CONST(Sales), Date = FIELD("Date Filter"), "Store No." = FIELD("Store No. Filter"), "Entry Status" = CONST(" ")))

LanguageCaption
en-USNo. of Items
it-ITNr. di articoli

IC No. of Time Used (13)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Trans. Infocode Entry"."Counter" WHERE("Store No." = FIELD("Store No. Filter"), Date = FIELD("Date Filter"), Infocode = FIELD("Infocode Filter")))

LanguageCaption
en-USIC No. of Time Used
it-ITIC nr. volte utilizzo

Infocode Amount (14)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Trans. Infocode Entry".Amount WHERE("Store No." = FIELD("Store No. Filter"), Date = FIELD("Date Filter"), Infocode = FIELD("Infocode Filter")))

LanguageCaption
en-USInfocode Amount
it-ITImporto infocode


EOS Labs -