Table 18059916 EOS Bonus Settlement Plan

Table 18059916 EOS Bonus Settlement Plan

Fields

Bonus Type (1)

Enum "EOS Bonus Type"

Bonus Code (2)

Code[20]

TableRelation: if ("Bonus Type" = const("Customer Bonus")) "EOS Bonus Header".Code where(Type = const("Customer Bonus")) else if ("Bonus Type" = const("Vendor Bonus")) "EOS Bonus Header".Code where(Type = const("Vendor Bonus"))

Bonus Line No. (3)

Integer

TableRelation: "EOS Bonus Line"."Line No." where("Bonus Type" = field("Bonus Type"), "Bonus Code" = field("Bonus Code"))

Line No. (4)

Integer

Reference Period (5)

Code[20]

TableRelation: "EOS Bonus Reference Period"

Value Type (6)

Option

"Fixed Amount" (0) , "Calculated" (1)

Value (7)

Decimal

Expected Settlement Date (8)

Date

Effective Settlement Date (9)

Date

In Settlement Amount (10)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Bonus Settlement Entry"."Amount (LCY)" where("Bonus Type" = field("Bonus Type"), "Bonus Code" = field("Bonus Code"), "Bonus Line No." = field("Bonus Line No."), "Bonus Settlemet Plan Line No." = field("Line No."), "To Be Accrued" = const(false)))

Settled Amount (11)

Decimal

FieldClass: FlowField

CalcFormula: Sum("EOS Bonus Ledger Entry"."Amount (LCY)" where("Bonus Type" = field("Bonus Type"), "Bonus Code" = field("Bonus Code"), "Bonus Line No." = field("Bonus Line No."), "Bonus Settlemet Plan Line No." = field("Line No."), "Entry Type" = const(Settlement)))

Check Remaining Amount (12)

Boolean

Status (13)

Enum "EOS Bonus Settlement Plan Status"

Note (14)

Text[150]

Settlement Type (15)

Enum "EOS Bonus Settlement Type"

Error Message (16)

Text[100]


EOS Labs -