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.")))
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.