Table 18123257 EOS Purch. Req. Multi Vendor

Table 18123257 EOS Purch. Req. Multi Vendor

Fields

Create Document (2)

Boolean


Insert all items (3)

Boolean


Vendor No. (4)

Code[20]


Vendor Name (5)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Vendor.Name where("No." = field("Vendor No.")))


Blocked (6)

Enum "Vendor Blocked"

FieldClass: FlowField

CalcFormula: lookup(Vendor.Blocked where("No." = field("Vendor No.")))


No. Available items (7)

Integer


Last Invoice Date (8)

Date

FieldClass: FlowField

CalcFormula: max("Purch. Inv. Header"."Posting Date" where("Buy-from Vendor No." = field("Vendor No.")))


Purch. Req. No. (9)

Code[20]


Create Doc. With Items (10)

Enum "EOS PRQ Create Doc. With Items"


No. Vendor Items on PRQ (11)

Integer

FieldClass: FlowField

CalcFormula: count("EOS Purch. Request Line" where("EOS Purch. Requisition No." = field("Purch. Req. No."), "EOS Vendor No." = field("Vendor No.")))



EOS Labs -