TableExtension 27 Item

TableExtension 18122724 EOS TableExt18122724

Fields

EOS Conai (18122724)

Enum "EOS Conai"

EOS051 Sec. UoM Code (18122730)

Code[10]

TableRelation: "Item Unit of Measure".Code WHERE("Item No." = FIELD("No."))

EOS051 Sec. Qty. Calc. Method (18122731)

Enum "EOS051 Sec. Qty. Calc. Method"

EOS051 Sales Pr. Calc. Method (18122732)

Enum "EOS051 Price Calc. Method"

EOS051 Purch. Pr. Calc. Method (18122733)

Enum "EOS051 Price Calc. Method"

EOS051 Quantity Calc. Method (18122734)

Enum "EOS051 Quantity Calc. Method"

EOS051 Sec.Qty. on Purch.Order (18122738)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Purchase Line"."EOS051 Sec. Outst. Quantity" where("Document Type" = const("Order"), "Type" = const(Item), "No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Expected Receipt Date" = field("Date Filter"), "Unit of Measure Code" = field("Unit of Measure Filter")))

EOS051 Sec.Qty. on Sales Order (18122739)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Sales Line"."EOS051 Sec. Outst. Quantity" where("Document Type" = const("Order"), "Type" = const(Item), "No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Shipment Date" = field("Date Filter"), "Unit of Measure Code" = field("Unit of Measure Filter")))

EOS051 Sec. Qty. in Transit (18122725)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Transfer Line"."EOS051 Sec. Qty. in Transit" where("Derived From Line No." = const(0), "Item No." = field("No."), "Transfer-to Code" = field("Location Filter"), "Variant Code" = field("Variant Filter"), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Receipt Date" = field("Date Filter"), "Unit of Measure Code" = field("Unit of Measure Filter")))

EOS051Trans.Ord.Rcpt(Sec.Qty.) (18122726)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Transfer Line"."EOS051 Sec. Outst. Quantity" where("Derived From Line No." = const(0), "Item No." = field("No."), "Transfer-to Code" = field("Location Filter"), "Variant Code" = field("Variant Filter"), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Receipt Date" = field("Date Filter"), "Unit of Measure Code" = field("Unit of Measure Filter")))

EOS051Trans.Ord.Shpt(Sec.Qty.) (18122727)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Transfer Line"."EOS051 Sec. Outst. Quantity" where("Derived From Line No." = const(0), "Item No." = field("No."), "Transfer-from Code" = field("Location Filter"), "Variant Code" = field("Variant Filter"), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Shipment Date" = field("Date Filter"), "Unit of Measure Code" = field("Unit of Measure Filter")))


EOS Labs -