TableExtension 27 Item

TableExtension 70491771 EOS TableExt70491771

Fields

EOS051 Sec. Inventory (70491755)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS051 Sec. Quantity" where("Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Lot No." = field("Lot No. Filter"), "Serial No." = field("Serial No. Filter"), "Unit of Measure Code" = field("Unit of Measure Filter"), "Package No." = field("Package No. Filter")))

EOS051 Net Invoiced Sec. Qty. (70491756)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS051 Sec. Invoiced Quantity" where("Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Lot No." = field("Lot No. Filter"), "Serial No." = field("Serial No. Filter"), "Package No." = field("Package No. Filter")))

EOS051 Sec. Net Change (70491757)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS051 Sec. Quantity" where("Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Posting Date" = field("Date Filter"), "Variant Code" = field("Variant Filter"), "Lot No." = field("Lot No. Filter"), "Serial No." = field("Serial No. Filter"), "Unit of Measure Code" = field("Unit of Measure Filter"), "Package No." = field("Package No. Filter")))

EOS051 Purchases (Sec. Qty.) (70491758)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS051 Sec. Invoiced Quantity" where("Entry Type" = const(Purchase), "Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Posting Date" = field("Date Filter"), "Lot No." = field("Lot No. Filter"), "Serial No." = field("Serial No. Filter"), "Package No." = field("Package No. Filter")))

EOS051 Sales (Sec. Qty.) (70491759)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS051 Sec. Invoiced Quantity" where("Entry Type" = const(Sale), "Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Posting Date" = field("Date Filter")))

EOS051 Pos. Adjmt. (Sec. Qty.) (70491760)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS051 Sec. Invoiced Quantity" where("Entry Type" = const("Positive Adjmt."), "Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Posting Date" = field("Date Filter"), "Lot No." = field("Lot No. Filter"), "Serial No." = field("Serial No. Filter"), "Package No." = field("Package No. Filter")))

EOS 051 Neg. Adjmt. (Sec.Qty.) (70491761)

Decimal

FieldClass: FlowField

CalcFormula: - Sum("Item Ledger Entry"."EOS051 Sec. Invoiced Quantity" where("Entry Type" = const("Negative Adjmt."), "Item No." = field("No."), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Posting Date" = field("Date Filter"), "Lot No." = field("Lot No. Filter"), "Serial No." = field("Serial No. Filter"), "Package No." = field("Package No. Filter")))


EOS Labs -