TableExtension 38 Purchase Header

TableExtension 18060012 EOS089TableExt18060012

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 Line Exists (18060012)

Boolean

FieldClass: FlowField

CalcFormula: exist("Purchase Line" where("Document Type" = field("Document Type"), "Document No." = field("No."), Type = filter(Item), "Location Code" = field("Location Filter")))

EOS WMS Source Scans Exists (18060013)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS089 WMS Source Scan" where("Activity Type" = filter("Purchase Receipt" | "Purchase Return Shipment"), "Source Subtype" = field("Document Type"), "Source ID" = field("No.")))

EOS WMS Source Scan Id (18060014)

Guid

FieldClass: FlowField

CalcFormula: lookup("EOS089 WMS Source Scan"."Scan Id" where("Activity Type" = filter("Purchase Receipt" | "Purchase Return Shipment"), "Source Subtype" = field("Document Type"), "Source ID" = field("No.")))

EOS WMS Pending Activities (18060015)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS089 WMS Activity Entry" where("Activity Type" = filter("Purchase Receipt" | "Purchase Return Shipment"), "Source Subtype" = field("Document Type"), "Source Id" = field("No."), Status = filter(" " | "In Progress")))

EOS WMS Scanner Reference (18060016)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("EOS089 WMS Scanner Reference"."Scanner Setup" where("Activity Type" = filter("Purchase Receipt" | "Purchase Return Shipment"), "Reference Type" = const(Vendor), "Reference No." = field("Buy-from Vendor No.")))


EOS Labs -