Table 5505290 M365 Indicator Rule

Table 5505290 M365 Indicator Rule

Language	Caption
de-DE	Hinweisregel
es-ES	Regla del indicador
en-US	Indicator Rule
it-CH	Regola indicatore
it-IT	Regola indicatore

Fields

Indicator Code (`10`)

Code[20]

TableRelation: "M365 Indicator Table"."Indicator Code"

Language	Caption
de-DE	Hinweiscode
es-ES	Código del indicador
en-US	Indicator Code
it-CH	Codice indicatore
it-IT	Codice indicatore

Table Id (`20`)

Integer

TableRelation: "M365 Indicator Table"."Table Id" where("Indicator Code" = field("Indicator Code"))

Language	Caption
de-DE	Tabellen-ID
es-ES	ID de tabla
en-US	Table ID
it-CH	ID tabella
it-IT	ID tabella

Relation Table Id (`30`)

Integer

TableRelation: "M365 Indicator Table"."Table Id" where("Indicator Code" = field("Indicator Code"))

Language	Caption
de-DE	Relationstabellenkennung
es-ES	ID de tabla de relaciones
en-US	Relation Table ID
it-CH	ID tabella relazioni
it-IT	ID tabella relazioni

Line No. (`40`)

Integer

Language	Caption
de-DE	Zeilennr.
es-ES	No. Línea
en-US	Line No.
it-CH	Nr. riga
it-IT	Nr. riga

Value Field Number (`100`)

Integer

TableRelation: Field."No." where(TableNo = field("Table Id"))

Language	Caption
de-DE	Wert-Feldnr.
es-ES	Número de campo de valor
en-US	Value Field Number
it-CH	Numero campo valore
it-IT	Numero campo valore

Type (`105`)

Enum "M365 Field Relation Type"

Language	Caption
de-DE	Art
es-ES	Tipo
en-US	Type
it-CH	Tipo
it-IT	Tipo

Value (`110`)

Text[500]

TableRelation: if (Type = const(Field)) Field."No." where(TableNo = field("Table Id"))

Language	Caption
de-DE	Wert
es-ES	Valor
en-US	Value
it-CH	Valore
it-IT	Valore

Aggregation (`120`)

Enum "M365 Aggregation Type"

Language	Caption
de-DE	Aggregation
es-ES	Agregación
en-US	Aggregation
it-CH	Aggregazione
it-IT	Aggregazione

Comparision (`130`)

Enum "M365 Comparision Type"

Language	Caption
de-DE	Vergleich
es-ES	Comparación
en-US	Comparision
it-CH	Confronto
it-IT	Confronto

Relation Type (`140`)

Enum "M365 Field Relation Type"

Language	Caption
de-DE	Beziehungsart
es-ES	Tipo de relación
en-US	Relation Type
it-CH	Tipo Collegamento
it-IT	Tipo Collegamento

Relation Value (`150`)

Text[500]

TableRelation: if ("Relation Type" = const(Field)) Field."No." where(TableNo = field("Relation Table Id"))

Language	Caption
de-DE	Beziehungswert
es-ES	Valor de relación
en-US	Relation Value
it-CH	Valore relazione
it-IT	Valore relazione

Relation Value Field Number (`160`)

Integer

TableRelation: Field."No." where(TableNo = field("Relation Table Id"))

Language	Caption
de-DE	Beziehungswert-Feldnr.
es-ES	Número de campo de valor de relación
en-US	Relation Value Field Number
it-CH	Numero campo Valore relazione
it-IT	Numero campo Valore relazione

Operator (`170`)

Enum "M365 Operator Type"

Language	Caption
de-DE	Operator
es-ES	Operador
en-US	Operator
it-CH	Operatore
it-IT	Operatore

Indicator Style Code (`180`)

Code[20]

TableRelation: "M365 Indicator Style"

Language	Caption
de-DE	Hinweis-Stilcode
es-ES	Código de estilo del indicador
en-US	Indicator Style Code
it-CH	Codice di stile indicatore
it-IT	Codice di stile indicatore

Table (`200`)

Text[249]

FieldClass: FlowField

CalcFormula: lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Table), "Object ID" = field("Table Id")))

Language	Caption
de-DE	Tabelle
es-ES	Tabla
en-US	Table
it-CH	Tabella
it-IT	Tabella

Relation Table (`210`)

Text[249]

FieldClass: FlowField

CalcFormula: lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Table), "Object ID" = field("Relation Table Id")))

Language	Caption
de-DE	Relationstabellenbeschriftung
es-ES	Título de la tabla de relaciones
en-US	Relation Table Caption
it-CH	Didascalia tabella relazioni
it-IT	Didascalia tabella relazioni

Methods

FilterRecord

procedure FilterRecord(indicatorCode: Code[20]; tableId: Integer; lineNo: Integer): Boolean

Parameters / Return Value

indicatorCode Code[20]
tableId Integer
lineNo Integer
Returns Boolean

FilterRecord

procedure FilterRecord(indicatorCode: Code[20]; tableId: Integer): Boolean

Parameters / Return Value

indicatorCode Code[20]
tableId Integer
Returns Boolean

FilterRecord

procedure FilterRecord(indicatorCode: Code[20]): Boolean

Parameters / Return Value

indicatorCode Code[20]
Returns Boolean

FindRecord

procedure FindRecord(indicatorCode: Code[20]; tableId: Integer; lineNo: Integer): Boolean

Parameters / Return Value

indicatorCode Code[20]
tableId Integer
lineNo Integer
Returns Boolean

FindRecord

procedure FindRecord(indicatorCode: Code[20]; tableId: Integer): Boolean

Parameters / Return Value

indicatorCode Code[20]
tableId Integer
Returns Boolean

FindRecord

procedure FindRecord(indicatorCode: Code[20]): Boolean

Parameters / Return Value

indicatorCode Code[20]
Returns Boolean

NewRecord

procedure NewRecord(indicatorCode: Code[20]; tableId: Integer; lineNo: Integer): Boolean

Parameters / Return Value

indicatorCode Code[20]
tableId Integer
lineNo Integer
Returns Boolean

NewRecord

procedure NewRecord(indicatorCode: Code[20]; tableId: Integer): Boolean

Parameters / Return Value

indicatorCode Code[20]
tableId Integer
Returns Boolean

NewRecord

procedure NewRecord(indicatorCode: Code[20]): Boolean

Parameters / Return Value

indicatorCode Code[20]
Returns Boolean

GetFieldReference

procedure GetFieldReference(recRef: RecordRef; fieldId: Integer; var fldRef: FieldRef; allowCalcField: Boolean): Boolean

Parameters / Return Value

recRef RecordRef
fieldId Integer
fldRef FieldRef
allowCalcField Boolean
Returns Boolean

GetRelationalTableAndApplyFilters

procedure GetRelationalTableAndApplyFilters(recRef: RecordRef; var relationalRecRef: RecordRef): Boolean

Parameters / Return Value

recRef RecordRef
relationalRecRef RecordRef
Returns Boolean

GetSumAndCount

procedure GetSumAndCount(relationRecRef: RecordRef; relationFldRef: FieldRef; var calculatedValue: Decimal; var recordCount: Integer): Boolean

Parameters / Return Value

relationRecRef RecordRef
relationFldRef FieldRef
calculatedValue Decimal
recordCount Integer
Returns Boolean

GetValueDifference

procedure GetValueDifference(actualValue: Variant; expectedValue: Variant): Decimal

Parameters / Return Value

actualValue Variant
expectedValue Variant
Returns Decimal

IsMatch

procedure IsMatch(actualValue: Variant; expectedValue: Variant): Boolean

Parameters / Return Value

actualValue Variant
expectedValue Variant
Returns Boolean

IsMatchWithAggregation

procedure IsMatchWithAggregation(fldRef: FieldRef; var relationRecRef: RecordRef): Boolean

Parameters / Return Value

fldRef FieldRef
relationRecRef RecordRef
Returns Boolean

IsMatch

procedure IsMatch(actualFldRef: FieldRef; expectedValue: Variant): Boolean

Parameters / Return Value

actualFldRef FieldRef
expectedValue Variant
Returns Boolean

IsMatch

procedure IsMatch(var fldRef: FieldRef; var relationRecRef: RecordRef): Boolean

Parameters / Return Value

fldRef FieldRef
relationRecRef RecordRef
Returns Boolean

IsMatch

procedure IsMatch(var fldRef: FieldRef): Boolean

Parameters / Return Value

fldRef FieldRef
Returns Boolean

IsMatch

procedure IsMatch(var recRef: RecordRef; var relationRecRef: RecordRef): Boolean

Parameters / Return Value

recRef RecordRef
relationRecRef RecordRef
Returns Boolean

IsMatch

procedure IsMatch(var recRef: RecordRef): Boolean

Parameters / Return Value

recRef RecordRef
Returns Boolean

GetStyle

procedure GetStyle(var indicatorStyle: Record "M365 Indicator Style"): Boolean

Parameters / Return Value

indicatorStyle Record "M365 Indicator Style"
Returns Boolean

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.

EOS Labs - 28.06.2024

Table 5505290 M365 Indicator Rule

Fields

Indicator Code (10)

Table Id (20)

Relation Table Id (30)

Line No. (40)

Value Field Number (100)

Type (105)

Value (110)

Aggregation (120)

Comparision (130)

Relation Type (140)

Relation Value (150)

Relation Value Field Number (160)

Operator (170)

Indicator Style Code (180)

Table (200)

Relation Table (210)

Methods

FilterRecord

Parameters / Return Value

FilterRecord

Parameters / Return Value

FilterRecord

Parameters / Return Value

FindRecord

Parameters / Return Value

FindRecord

Parameters / Return Value

FindRecord

Parameters / Return Value

NewRecord

Parameters / Return Value

NewRecord

Parameters / Return Value

NewRecord

Parameters / Return Value

GetFieldReference

Parameters / Return Value

GetRelationalTableAndApplyFilters

Parameters / Return Value

GetSumAndCount

Parameters / Return Value

GetValueDifference

Parameters / Return Value

IsMatch

Parameters / Return Value

IsMatchWithAggregation

Parameters / Return Value

IsMatch

Parameters / Return Value

IsMatch

Parameters / Return Value

IsMatch

Parameters / Return Value

IsMatch

Parameters / Return Value

IsMatch

Parameters / Return Value

GetStyle

Parameters / Return Value

Feedback

Indicator Code (`10`)

Table Id (`20`)

Relation Table Id (`30`)

Line No. (`40`)

Value Field Number (`100`)

Type (`105`)

Value (`110`)

Aggregation (`120`)

Comparision (`130`)

Relation Type (`140`)

Relation Value (`150`)

Relation Value Field Number (`160`)

Operator (`170`)

Indicator Style Code (`180`)

Table (`200`)

Relation Table (`210`)