TableExtension 13 Salesperson/Purchaser

TableExtension 18008382 EOS011 TableExt18008382

Added contribution module data, extends “Salesperson/Purchaser”

Fields

EOS Society Type (18008381)

Option

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


EOS Partner Of (18008382)

Code[20]

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


EOS Company Share (18008383)

Decimal


EOS Salesperson Type (18008384)

Option

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


EOS Enasarco Registration No. (18008385)

Code[20]


EOS Enasarco Contribution Type (18008386)

Option

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


EOS Subject to Enasarco (18008387)

Boolean


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

Boolean


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

Boolean


EOS AEC Type (18008390)

Enum "EOS011 AEC Type"


EOS Soc. Sec. Ripened (18008391)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS011 Contr. Ledger Entry"."Contribution Amount (LCY)" where("Vendor No." = field("EOS Vendor No."), "Contribution Type" = const("Social Security"), "Salesperson Code" = field("EOS Salesperson Filter"), "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("EOS Vendor No."), "Contribution Type" = const(Assistance), "Salesperson Code" = field("EOS Salesperson Filter"), "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("EOS Vendor No."), "Contribution Type" = const("F.I.R.R."), "Salesperson Code" = field("EOS Salesperson Filter"), "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("EOS Vendor No."), "Contribution Type" = const("F.I.S.C."), "Salesperson Code" = field("EOS Salesperson Filter"), "Posting Date" = field("Date Filter")))


EOS Collab. Starting Date (18008395)

Date


EOS Collab. Ending Date (18008396)

Date


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

Decimal


EOS Salesperson Filter (18008398)

Code[20]

FieldClass: FlowFilter


EOS Facilitation Starting Date (18008380)

Date


EOS Facilitation Ending Date (18008360)

Date



EOS Labs -