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)

Option

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("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 -