TableExtension 5767 Warehouse Activity Line

TableExtension 18060025 EOSTableExt18060025

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 Scan Exists (18060016)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS089 WMS Source Scan" where("Source SystemId" = field(SystemId)))

EOS WMS Take Location Code (18060017)

Code[10]

FieldClass: FlowField

CalcFormula: lookup("Warehouse Activity Line"."Location Code" where("Activity Type" = field("Activity Type"), "No." = field("No."), "Source Type" = field("Source Type"), "Source Subtype" = field("Source Subtype"), "Source No." = field("Source No."), "Source Line No." = field("Source Line No."), "Source Subline No." = field("Source Subline No."), "Unit of Measure Code" = field("Unit of Measure Code"), "Action Type" = const(Take), "Breakbulk No." = field("Breakbulk No."), "Original Breakbulk" = field("Original Breakbulk"), "Assemble to Order" = field("Assemble to Order"), "Serial No." = field("Serial No."), "Lot No." = field("Lot No."), "Qty. Outstanding" = field("Qty. Outstanding")))

EOS WMS Take Bin Code (18060018)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Warehouse Activity Line"."Bin Code" where("Activity Type" = field("Activity Type"), "No." = field("No."), "Line No." = field("EOS WMS Take Line No.")))

EOS WMS Splitted From Line No. (18060019)

Integer

EOS WMS Take Line No. (18060020)

Integer

EOS WMS Fixed Id (18060021)

Guid

EOS WMS Split By PowerWMS (18060022)

Boolean

EOS WMS Original Serial No. (18060023)

Code[50]

EOS WMS Original Lot No. (18060024)

Code[50]

EOS WMS Original Package No. (18060025)

Code[50]

EOS WMS Original Line No. (18060026)

Integer

EOS WMS Original System Id (18060027)

Guid

EOS WMS Last Splitted Line No. (18060028)

Integer


EOS Labs -