TableExtension 99001608 LSC Inventory Lookup Table

TableExtension 18091486 EOS TableExt18091486

Fields

EOS Calc. Phys. Inventory (18091480)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry".Quantity WHERE("Item No." = FIELD("Item No."), "Location Code" = FIELD(Location)))

EOS Calc. Purch. Order. (18091481)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE("Document Type" = CONST(Order), Type = CONST(Item), "No." = FIELD("Item No."), "Location Code" = FIELD(Location)))

EOS Calc. Total Sales (18091482)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("LSC Trans. Sales Entry".Quantity WHERE("Item No." = FIELD("Item No."), "Store No." = FIELD("Store No.")))

EOS Calc. CO Res. Entries (18091483)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC CO Reservation Entry"."Quantity (Base)" WHERE("Item No." = FIELD("Item No."), "Location Code" = FIELD(Location), "Store No." = FIELD("Store No.")))

EOS Calc. Var. Phys. Inventory (18091484)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry".Quantity WHERE("Item No." = FIELD("Item No."), "Location Code" = FIELD(Location), "Variant Code" = FIELD("Variant Code")))

EOS Calc. Var. Purch. Order. (18091485)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE("Document Type" = CONST(Order), Type = CONST(Item), "No." = FIELD("Item No."), "Variant Code" = FIELD("Variant Code"), "Location Code" = FIELD(Location)))

EOS Calc. Var. Total Sales (18091486)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("LSC Trans. Sales Entry".Quantity WHERE("Item No." = FIELD("Item No."), "Store No." = FIELD("Store No."), "Variant Code" = FIELD("Variant Code")))

EOS Calc. Var. CO Res. Entries (18091487)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC CO Reservation Entry"."Quantity (Base)" WHERE("Item No." = FIELD("Item No."), "Store No." = FIELD("Store No."), "Location Code" = FIELD(Location), "Variant Code" = FIELD("Variant Code")))

EOS Calc. Posted Sales (18091488)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("LSC Trans. Sales Entry Status".Quantity WHERE("Item No." = FIELD("Item No."), Status = FILTER(> " "), "Store No." = FIELD("Store No.")))

EOS Calc. Var. Posted Sales (18091489)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("LSC Trans. Sales Entry Status".Quantity WHERE("Item No." = FIELD("Item No."), "Variant Code" = FIELD("Variant Code"), "Store No." = FIELD("Store No."), Status = FILTER(> " ")))

EOS Calc. Total Inv. Adjmt. (18091490)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Trans. Inv. Adjmt. Entry".Quantity WHERE("Item No." = FIELD("Item No."), "Location Code" = FIELD(Location)))

EOS Calc. Var. Tot Inv. Adjmt. (18091491)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Trans. Inv. Adjmt. Entry".Quantity WHERE("Item No." = FIELD("Item No."), "Location Code" = FIELD(Location), "Variant Code" = FIELD("Variant Code")))

EOS Calc. Posted Inv. Adjmt. (18091492)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Trans. Inv Adjmt. Entry St".Quantity WHERE("Item No." = FIELD("Item No."), Status = FILTER(> " "), "Location Code" = FIELD(Location)))

EOS Calc. Var. Pst Inv. Adjmt. (18091493)

Decimal

FieldClass: FlowField

CalcFormula: Sum("LSC Trans. Inv Adjmt. Entry St".Quantity WHERE("Item No." = FIELD("Item No."), "Variant Code" = FIELD("Variant Code"), "Location Code" = FIELD(Location), Status = FILTER(> " ")))

EOS Net Inventory (18091494)

Decimal

EOS Store Name (18091495)

Text[100]

FieldClass: FlowField

CalcFormula: lookup("LSC Store".Name where("No." = field("Store No.")))

EOS Item Description (18091496)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Item.Description where("No." = field("Item No.")))


EOS Labs -