TableExtension 27 Item

TableExtension 18125905 EOS EX080 TableExt18125905

Fields

EOS EX080 Alcohol (18125905)

Decimal

EOS EX080 Year (18125906)

Integer

EOS EX080 Sugar g/Kg (18125907)

Decimal

EOS EX080 Bottle Volume (18125908)

Decimal

EOS EX080 Wine Type (18125909)

Enum "EOS EX080 Wine Type"

EOS EX080 Lot No. Formula (18125910)

Code[20]

EOS EX080 Wine Color Code (18125911)

Code[10]

FieldClass: FlowField

CalcFormula: lookup("Item Category"."EOS EX080 Wine Color Code" where(Code = field("Item Category Code")))

EOS EX080 Wine Category Code (18125912)

Code[10]

FieldClass: FlowField

CalcFormula: lookup("Item Category"."EOS EX080 Wine Category Code" where(Code = field("Item Category Code")))

EOS EX080 Wine Grow. Area Code (18125913)

Code[10]

FieldClass: FlowField

CalcFormula: lookup("Item Category"."EOS EX080 Wine Grow. Area Code" where(Code = field("Item Category Code")))

EOS EX080 Inventory in Liter (18125914)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS Qty. In Liter" 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")))

EOS EX080 Inventory in Kg (18125915)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Item Ledger Entry"."EOS Qty. In Kg" 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")))

EOS EX080 Qty. Bla. Sal. Order (18125916)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Sales Line"."Outstanding Qty. (Base)" where("Document Type" = const("Blanket 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")))

EOS EX080 Qty. Bla. Pur. Order (18125917)

Decimal

FieldClass: FlowField

CalcFormula: Sum("Purchase Line"."Outstanding Qty. (Base)" where("Document Type" = const("Blanket 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")))

EOS EX080 SIAN Primary Code (18125918)

Code[15]

EOS EX080 SIAN Secondary Code (18125919)

Code[15]

EOS EX080 IGP % (18125920)

Decimal


EOS Labs -