TableExtension 23 Vendor

TableExtension 18008384 EOS011 TableExt18008384

Added contribution module data, extends “Vendor”

Fields

EOS Society Type (18008381)

Option

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Society Type" where("EOS Vendor No." = field("No.")))

"Individual Agent" (0) , Partnership (1) , Company (2)

EOS Partner Of (18008382)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Partner Of" where("EOS Vendor No." = field("No.")))

TableRelation: "Salesperson/Purchaser" where("EOS Society Type" = const(Partnership))

EOS No. of Salespersons (18008383)

Integer

FieldClass: FlowField

CalcFormula: count("Salesperson/Purchaser" where("EOS Vendor No." = field("No.")))

EOS Salesperson Type (18008384)

Option

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Salesperson Type" where("EOS Vendor No." = field("No.")))

"One-Firm" (0) , "Representing Different Firms" (1)

EOS Enasarco Registration No. (18008385)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Enasarco Registration No." where("EOS Vendor No." = field("No.")))

EOS Enasarco Contribution Type (18008386)

Option

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Enasarco Contribution Type" where("EOS Vendor No." = field("No.")))

" " (0) , "Social Security Fund" (1) , "Assistance Fund" (2)

EOS Subject to Enasarco (18008387)

Boolean

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Subject to Enasarco" where("EOS Vendor No." = field("No.")))

EOS Subject to F.I.R.R. (18008388)

Boolean

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Subject to F.I.R.R." where("EOS Vendor No." = field("No.")))

EOS Subject to F.I.S.C. (18008389)

Boolean

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Subject to F.I.S.C." where("EOS Vendor No." = field("No.")))

EOS AEC Type (18008390)

Option

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS AEC Type" where("EOS Vendor No." = field("No.")))

Commercial (0) , Industrial (1)

EOS Soc. Sec. Ripened (18008391)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS011 Contr. Ledger Entry"."Contribution Amount (LCY)" where("Vendor No." = field("No."), "Contribution Type" = const("Social Security"), "Posting Date" = field("Date Filter")))

EOS Assistance Ripened (18008392)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS011 Contr. Ledger Entry"."Contribution Amount (LCY)" where("Vendor No." = field("No."), "Contribution Type" = const(Assistance), "Posting Date" = field("Date Filter")))

EOS F.I.R.R. Ripened (18008393)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS011 Contr. Ledger Entry"."Contribution Amount (LCY)" where("Vendor No." = field("No."), "Contribution Type" = const("F.I.R.R."), "Posting Date" = field("Date Filter")))

EOS F.I.S.C. Ripened (18008394)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS011 Contr. Ledger Entry"."Contribution Amount (LCY)" where("Vendor No." = field("No."), "Contribution Type" = const("F.I.S.C."), "Posting Date" = field("Date Filter")))

EOS Collab. Starting Date (18008395)

Date

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Collab. Starting Date" where("EOS Vendor No." = field("No.")))

EOS Collab. Ending Date (18008396)

Date

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Collab. Ending Date" where("EOS Vendor No." = field("No.")))

EOS F.I.S.C. Hist. Shelved (18008397)

Decimal

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS F.I.S.C. Hist. Shelved" where("EOS Vendor No." = field("No.")))

EOS Contr. Main Salesperson (18008398)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser".Code where("EOS Vendor No." = field("No."), "EOS Partner Of" = const('')))

EOS Settlement ending date (18008380)

Date

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Settlement ending date" where("EOS Vendor No." = field("No.")))

EOS Facilitation Starting Date (18008360)

Date

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Facilitation Starting Date" where("EOS Vendor No." = field("No.")))

EOS Facilitation Ending Date (18008361)

Date

FieldClass: FlowField

CalcFormula: lookup("Salesperson/Purchaser"."EOS Facilitation Ending Date" where("EOS Vendor No." = field("No.")))

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.