Table 5505290 M365 Indicator Rule

Table 5505290 M365 Indicator Rule

LanguageCaption
de-DEHinweisregel
es-ESRegla del indicador
en-USIndicator Rule
it-CHRegola indicatore
it-ITRegola indicatore

Fields

Indicator Code (10)

Code[20]

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

LanguageCaption
de-DEHinweiscode
es-ESCódigo del indicador
en-USIndicator Code
it-CHCodice indicatore
it-ITCodice indicatore

Table Id (20)

Integer

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

LanguageCaption
de-DETabellen-ID
es-ESID de tabla
en-USTable ID
it-CHID tabella
it-ITID tabella

Relation Table Id (30)

Integer

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

LanguageCaption
de-DERelationstabellenkennung
es-ESID de tabla de relaciones
en-USRelation Table ID
it-CHID tabella relazioni
it-ITID tabella relazioni

Line No. (40)

Integer

LanguageCaption
de-DEZeilennr.
es-ESNo. Línea
en-USLine No.
it-CHNr. riga
it-ITNr. riga

Value Field Number (100)

Integer

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

LanguageCaption
de-DEWert-Feldnr.
es-ESNúmero de campo de valor
en-USValue Field Number
it-CHNumero campo valore
it-ITNumero campo valore

Type (105)

Enum "M365 Field Relation Type"

LanguageCaption
de-DEArt
es-ESTipo
en-USType
it-CHTipo
it-ITTipo

Value (110)

Text[500]

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

LanguageCaption
de-DEWert
es-ESValor
en-USValue
it-CHValore
it-ITValore

Aggregation (120)

Enum "M365 Aggregation Type"

LanguageCaption
de-DEAggregation
es-ESAgregación
en-USAggregation
it-CHAggregazione
it-ITAggregazione

Comparision (130)

Enum "M365 Comparision Type"

LanguageCaption
de-DEVergleich
es-ESComparación
en-USComparision
it-CHConfronto
it-ITConfronto

Relation Type (140)

Enum "M365 Field Relation Type"

LanguageCaption
de-DEBeziehungsart
es-ESTipo de relación
en-USRelation Type
it-CHTipo Collegamento
it-ITTipo Collegamento

Relation Value (150)

Text[500]

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

LanguageCaption
de-DEBeziehungswert
es-ESValor de relación
en-USRelation Value
it-CHValore relazione
it-ITValore relazione

Relation Value Field Number (160)

Integer

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

LanguageCaption
de-DEBeziehungswert-Feldnr.
es-ESNúmero de campo de valor de relación
en-USRelation Value Field Number
it-CHNumero campo Valore relazione
it-ITNumero campo Valore relazione

Operator (170)

Enum "M365 Operator Type"

LanguageCaption
de-DEOperator
es-ESOperador
en-USOperator
it-CHOperatore
it-ITOperatore

Indicator Style Code (180)

Code[20]

TableRelation: "M365 Indicator Style"

LanguageCaption
de-DEHinweis-Stilcode
es-ESCódigo de estilo del indicador
en-USIndicator Style Code
it-CHCodice di stile indicatore
it-ITCodice di stile indicatore

Table (200)

Text[249]

FieldClass: FlowField

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

LanguageCaption
de-DETabelle
es-ESTabla
en-USTable
it-CHTabella
it-ITTabella

Relation Table (210)

Text[249]

FieldClass: FlowField

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

LanguageCaption
de-DERelationstabellenbeschriftung
es-ESTítulo de la tabla de relaciones
en-USRelation Table Caption
it-CHDidascalia tabella relazioni
it-ITDidascalia 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


EOS Labs -