Table CCS DIS Mapping Filter
table 5100962 "CCS DIS Mapping Filter"
Properties
| Name |
Value |
| Caption |
Mapping Filter |
| DataPerCompany |
0 |
Fields
Mapping Code
field(1; "Mapping Code"; Code[20])
Properties
| Name |
Value |
| Caption |
Mapping Code |
| DataClassification |
CustomerContent |
| TableRelation |
"CCS DIS Mapping" |
Version No.
field(2; "Version No."; Integer)
Properties
| Name |
Value |
| Caption |
Version No. |
| DataClassification |
CustomerContent |
| TableRelation |
"CCS DIS Mapping Version"."No." where("Mapping Code" = field("Mapping Code")) |
Mapping Line No.
field(3; "Mapping Line No."; Integer)
Properties
| Name |
Value |
| Caption |
Mapping Line No. |
| DataClassification |
CustomerContent |
| TableRelation |
"CCS DIS Mapping Line"."Line No." where("Mapping Code" = field("Mapping Code"), "Version No." = field("Version No.")) |
Line No.
field(4; "Line No."; Integer)
Properties
| Name |
Value |
| Caption |
Line No. |
| DataClassification |
CustomerContent |
Rec. Field
field(5; "Rec. Field"; Text[250])
Properties
| Name |
Value |
| Caption |
Field |
| DataClassification |
CustomerContent |
| NotBlank |
1 |
Rec. Repository Code
field(6; "Rec. Repository Code"; Code[20])
Properties
| Name |
Value |
| CalcFormula |
lookup("CCS DIS Mapping Line"."Repository Code" where("Mapping Code" = field("Mapping Code"), "Version No." = field("Version No."), "Line No." = field("Mapping Line No."))) |
| Caption |
Repository Code |
| Editable |
0 |
| FieldClass |
FlowField |
Rec. Field Caption
field(15; "Rec. Field Caption"; Text[80])
Properties
| Name |
Value |
| Caption |
Field Caption |
| DataClassification |
CustomerContent |
| Editable |
0 |
Sorting Position
field(16; "Sorting Position"; Integer)
Properties
| Name |
Value |
| Caption |
Sorting Position |
| DataClassification |
CustomerContent |
Value Class
field(30; "Value Class"; Enum "CCS DIS Value Class")
Properties
| Name |
Value |
| Caption |
Value Class |
| DataClassification |
CustomerContent |
| InitValue |
Repository |
Value Repository Code
field(31; "Value Repository Code"; Code[20])
Properties
| Name |
Value |
| Caption |
Value Repository Code |
| DataClassification |
CustomerContent |
| TableRelation |
"CCS DIS Mapping Repository".Code where("Mapping Code" = field("Mapping Code"), "Version No." = field("Version No.")) |
Value Field
field(35; "Value Field"; Text[250])
Properties
| Name |
Value |
| Caption |
Filter Value |
| DataClassification |
CustomerContent |
Value Field Caption
field(36; "Value Field Caption"; Text[50])
Important
This field is obsolete.
Moved to Value Field Caption 80
2.5
Properties
| Name |
Value |
| Caption |
Value Field Caption |
| DataClassification |
CustomerContent |
| Editable |
0 |
| ObsoleteState |
Removed |
| ObsoleteReason |
Moved to Value Field Caption 80 |
| ObsoleteTag |
2.5 |
Value Field Caption 80
field(37; "Value Field Caption 80"; Text[80])
Properties
| Name |
Value |
| Caption |
Value Field Caption |
| DataClassification |
CustomerContent |
| Editable |
0 |
field(40; "Value Format String"; Text[30])
Important
This field is obsolete.
Moved to Value Format String 150
2.6
Properties
| Name |
Value |
| Caption |
Format Property |
| DataClassification |
CustomerContent |
| ObsoleteState |
Removed |
| ObsoleteReason |
Moved to Value Format String 150 |
| ObsoleteTag |
2.6 |
field(41; "Value Format String 150"; Text[150])
Properties
| Name |
Value |
| Caption |
Format Property |
| DataClassification |
CustomerContent |
Conversion Code
field(47; "Conversion Code"; Code[20])
Properties
| Name |
Value |
| Caption |
Conversion Code |
| DataClassification |
CustomerContent |
| TableRelation |
"CCS DIS Conversion Header" |
| ValidateTableRelation |
0 |
Filter Criteria
field(80; "Filter Criteria"; Boolean)
Properties
| Name |
Value |
| CalcFormula |
exist("CCS DIS Mapping Criterion" where("Mapping Code" = field("Mapping Code"), "Version No." = field("Version No."), "Mapping Line No." = field("Mapping Line No."), "Mapping Field Line No." = const(0), "Mapping Codeunit Line No." = const(0), "Mapping Variable Line No." = const(0), "Mapping Filter Line No." = field("Line No."))) |
| Caption |
Criteria |
| Editable |
0 |
| FieldClass |
FlowField |
SharePoint Operator
field(270; "SharePoint Operator"; Enum "CCS DIS SharePoint Filter Operator")
Properties
| Name |
Value |
| Caption |
Comparison Operator (SharePoint) |
| DataClassification |
CustomerContent |
Keys
| Name |
Fields |
Properties |
| PK |
- "Mapping Code"
- "Version No."
- "Mapping Line No."
- "Line No."
|
|
| Key2 |
- "Mapping Code"
- "Version No."
- "Mapping Line No."
- "Sorting Position"
|
- Description = Page sorting
|
| Key3 |
- "Mapping Code"
- "Version No."
- "Mapping Line No."
- "Rec. Field"
|
- Description = Guess primary key
|
Methods
GetValue
public "CCS DIS Mapping Filter" GetValue(var FldValue: Variant): None
Returns the solved value of the mapping filter on mapping processing.
Parameters
| Name |
Type |
Description |
| FldValue |
Variant |
The value of the mapping filter. |
Return Value
None
ShowCriteria
public "CCS DIS Mapping Filter" ShowCriteria(): None
Opens the mapping criteria page, filtered for the mapping filter line.
Return Value
None
Events
OnAfterGetValue
event "CCS DIS Mapping Filter" OnAfterGetValue(var FldValue: Variant)
The event is fired after the value was retrieved.
Parameters
| Name |
Type |
Description |
| FldValue |
Variant |
The retrieved value. |
Attributes
| Name |
Arguments |
| IntegrationEvent |
True, False |