TableExtension 5107 Sales Header Archive

TableExtension 18008305 EOS TableExt18008305

Added commission module data, extends “Sales Header Archive”

Fields

EOS Commission Group (18008293)

Code[10]

TableRelation: "EOS Commission Group".Code where("Group Type" = const(Customer))

EOS Sales Network (18008290)

Code[10]

TableRelation: "EOS Sales Network"

EOS Salesperson Code (18008291)

Integer

FieldClass: FlowField

CalcFormula: Count("EOS Add. Salesperson Archive" where( #pragma warning restore AL0432 //15162 "Header Type" = const(5107), "Header Ref. No." = const(0), #pragma warning disable AL0603 "Header Subtype" = field("Document Type"), #pragma warning restore AL0603 "Header ID" = field("No."), "Doc. No. Occurrence" = field("Doc. No. Occurrence"), "Version No." = field("Version No.") ))

EOS Exclude from Commission (18008292)

Boolean

EOS Salesperson Set ID (18008320)

Integer

TableRelation: "EOS010 Salesperson Set Entry"."Salesperson Set ID"

EOS Salespersons Count (18008321)

Integer

FieldClass: FlowField

CalcFormula: count("EOS010 Salesperson Set Entry" where( "Salesperson Set ID" = field("EOS Salesperson Set ID")))

Methods

EOSShowSalesPersons

procedure EOSShowSalesPersons(): Boolean

Parameters / Return Value

  • Returns Boolean

EOS010GetSalesPersons

procedure EOS010GetSalesPersons() Result: Dictionary of [Code[10], Code[20]]

Get salespersons from the Sales Header Archive

Parameters / Return Value

  • Returns Dictionary[Code,Code]

EOS Labs -