TableExtension 5878 Phys. Invt. Record Line

TableExtension 18060031 EOSTableExt18060031

Fields

EOS WMS Employee No. Filter (18060010)

Code[20]

FieldClass: FlowFilter

EOS WMS Activity Type Filter (18060011)

Enum "EOS089 WMS Activity Type"

FieldClass: FlowFilter

EOS WMS Item Identifier (18060012)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Item Identifier".Code where("Item No." = field("Item No."), "Variant Code" = field("Variant Code"), "Unit of Measure Code" = field("Unit of Measure Code")))

EOS WMS Item Barcode Reference (18060014)

Code[50]

FieldClass: FlowField

CalcFormula: lookup("Item Reference"."Reference No." where("Item No." = field("Item No."), "Variant Code" = field("Variant Code"), "Unit of Measure" = field("Unit of Measure Code"), "Reference Type" = const("Bar Code"), "Reference Type No." = const('')))

EOS WMS Base Unit Of Measure (18060015)

Code[10]

FieldClass: FlowField

CalcFormula: lookup(Item."Base Unit of Measure" where("No." = field("Item No.")))

EOS WMS Exp. Qty. (Base) (18060016)

Decimal

FieldClass: FlowField

CalcFormula: sum("Phys. Invt. Order Line"."Qty. Expected (Base)" where("Document No." = field("Order No."), "Item No." = field("Item No."), "Variant Code" = field("Variant Code"), "Base Unit of Measure Code" = field("EOS WMS Base Unit Of Measure"), "Location Code" = field("Location Code"), "Bin Code" = field("Bin Code")))

EOS WMS Created By PowerWMS (18060017)

Boolean

EOS WMS Source Scans Exists (18060018)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS089 WMS Source Scan" where("Activity Type" = field("EOS WMS Activity Type Filter"), "Source SystemId" = field(SystemId)))


EOS Labs -