Table 18060651 EOS028 CFG Def. ConfigCharac

Table 18060651 EOS028 CFG Def. ConfigCharac

Fields

Document Type (1)

Option

Quote (0) , "Order" (1) , Invoice (2) , "Credit Memo" (3) , "Blanket Order" (4) , "Return Order" (5)

“Document Type” from which the configuration starts.

Document No. (2)

Code[20]

“Document No.” from which the configuration starts.

Document Line No. (3)

Integer

“Document Line No.” from which the configuration starts.

WBS No. (4)

Text[200]

“WBS No.” is Work breakdown structure. It’s a code calculated during the bill of material explosion to identify the bill of material levels.

Characteristic Code (5)

Code[10]

TableRelation: "EOS028 CFG Characteristic"

“Characteristic Code” contains the code of the characteristic.

Characteristic Value (10)

Code[50]

“Characteristic Value” contains the value of the characteristic.

Sequence (11)

Integer

Sequence contains the sequence in which the characteristics are requested during a configuration.

Rule Code (12)

Code[10]

TableRelation: "EOS028 CFG Rule"

“Rule Code” contains the code of the rule.

Mandatory (13)

Option

Mandatory (0) , Optional (1)

Mandatory expresses whether the characteristic is mandatory. it is mandatory to respond to this characteristic otherwise the configuration stops.

Characteristic Description (14)

Text[100]

FieldClass: FlowField

CalcFormula: lookup("EOS028 CFG Characteristic".Description where(Code = field("Characteristic Code")))

“Characteristic Description” contains the description of the characteristic.

Charac. Value Description (15)

Text[100]

FieldClass: FlowField

CalcFormula: lookup("EOS028 CFG Charac. Value".Description where(Code = field("Characteristic Value"), "Characteristic Code" = field("Characteristic Code")))

“Charac. Value Description” contains the description of the characteristic value.

Entry No. (16)

Integer

It is a system field that is inherited from the explosion of the bill of materials

Indentation (17)

Integer

Indentation contains the level of indentation of the current characteristic.

Surcharge (18)

Decimal

Surcharge contains the surcharge value generated by the configuration for the current characteristic.

Is Surcharge (19)

Boolean

“Is Surcharge” expresses whether an surcharge could be activated when this characteristic changes.

Price (20)

Boolean

Price expresses whether a change in price could trigger when this characteristic changes.

Not Editable (21)

Boolean

“Not Editable” expresses whether the characteristic is editable or not.

Price List Surcharge (22)

Boolean

“Price List Surcharge” expresses whether an price list surcharge could be activated when this characteristic changes.

Optional Amount (23)

Decimal

“Optional Amount” contains the optional amount value generated by the configuration for the current characteristic.

Allowed Charac. Code (24)

Code[10]

TableRelation: "EOS028 CFG Characteristic".Code

This is an unused field.

Item No. (25)

Code[20]

TableRelation: Item

“Item No.” contains the code of neutral item.

Description (26)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Item.Description where("No." = field("Item No.")))

Description contains the description of neutral item.

Description 2 (27)

Text[50]

FieldClass: FlowField

CalcFormula: lookup(Item."Description 2" where("No." = field("Item No.")))

“Description 2” contains the description 2 of neutral item.

Rule Value Charac. Nr. (28)

Integer

FieldClass: FlowField

CalcFormula: count("EOS028 CFG Rule Charac. Value" where("Rule Code" = field("Rule Code"), "Characteristic Code" = field("Characteristic Code")))

This is a calculated field that counts the number of possible values for the current characteristic.

Item Value Charac. Nr. (29)

Integer

FieldClass: FlowField

CalcFormula: count("EOS028 CFG Incl. Item Charac." where("Item No." = field("Item No."), "Characteristic Code" = field("Master Charac. Code"), "Neutral Rule Charac. Code" = filter('')))

This is a calculated field that counts the number of allowed values ​​for the current characteristic and for the current neutral item.

Rule Relations Charac. Nr. (30)

Integer

FieldClass: FlowField

CalcFormula: count("EOS028 CFG Def. CharacValue" where("Config. Item No." = field("Config. Item No."), "Config. Variant Code" = field("Config. Variant Code"), "Characteristic Code" = field("Characteristic Code")))

This is a calculated field that counts the number of relations ​​for the current characteristic.

Linked Characteristic Code (31)

Code[10]

TableRelation: "EOS028 CFG Characteristic".Code

“Linked Characteristic Code” contains the code of the linked characteristic.

Linked Characteristic Value (32)

Code[50]

TableRelation: "EOS028 CFG Charac. Value".Code where("Characteristic Code" = field("Linked Characteristic Code"))

“Linked Characteristic Value” contains the value of the linked characteristic.

Decoding Type (33)

Option

Structure (0) , Measure (1)

“Decoding Type” express the type of characteristic.

Optional (34)

Boolean

Optional expresses whether an optional could be activated when this characteristic changes.

Optional Item No. (35)

Code[20]

TableRelation: Item

“Optional Item No.” contains the code of the optional item.

Optional Item Quantity (36)

Decimal

“Optional Item Quantity” contains the quanity of the optional item.

Linked Sorting Code (37)

Code[50]

“Linked Sorting Code” contains the sort order of the value of the linked characteristic.

Document Date (38)

Date

“Document Date” contains the document date of the document from which the configuration starts.

Currency Code (39)

Code[10]

TableRelation: Currency

“Currency Code” contains the currency code of the document from which the configuration starts.

Customer Price Group (40)

Code[10]

TableRelation: "Customer Price Group"

“Customer Price Group” contains the customer price group of the document from which the configuration starts. if the configuration comes directly from the items master, the CFG setup one is taken.

Sell-to Customer No. (41)

Code[20]

TableRelation: Customer

“Sell-to Customer No.” contains the sell-to customer No. of the sales document from which the configuration starts.

Campaign No. (6)

Code[20]

TableRelation: Campaign

“Campaign No.” contains the Campaign No. of the sales document from which the configuration starts.

Vendor No. (7)

Code[20]

TableRelation: Vendor

“Vendor No.” contains the Vendor No. of the purchase document from which the configuration starts.

Neutral Item (42)

Boolean

“Neutral Item” is inherited from the neutral item field of the characteristics of a rule.

Hide Characteristic (43)

Boolean

“Hide Characteristic” expresses whether the current characteristic is a hidden characteristic in the configuration phase. Generally these characteristics are calculated by formulas automatically.

Numeric Value (44)

Decimal

The numeric value of the characteristic is saved in this field if it is of the measure type.

Master Charac. Code (45)

Code[10]

TableRelation: "EOS028 CFG Characteristic"

“Master Charac. Code” contains the value of the master characteristic.

Style (46)

Option

Ambiguous (0) , Attention (1) , AttentionAccent (2) , Favorable (3) , None (4) , Standard (5) , StandardAccent (6) , Strong (7) , StrongAccent (8) , Subordinate (9) , Unfavorable (10)

Style contains the style with which the characteristic must be displayed in the configuration phase on the page.

Process In Excel (47)

Boolean

if true, the process of Excel is triggered for the calculation of the characteristics.

Get Output From Excel (48)

Boolean

if true, after the Excel process, the value of the current characteristic calculated in Excel is valued in Business Central.

Trigger Custom Code (49)

Boolean

if true, the process of custum code is triggered for the calculation of the characteristics.

Get Output From Custom Code (50)

Boolean

if true, after the custum code process, the value of the current characteristic calculated in Excel is valued in Business Central.

Source Type (51)

Enum "EOS028 CFG Source Type"

“Source Type” from which the configuration starts (sales, purchase,…).

Hide Characteristic Opt./Mand. (52)

Boolean

“Hide Characteristic Opt./Mand.” expresses whether the current characteristic is a hidden characteristic in the configuration phase. These characteristics are always mandatory or optional and are set in rule relations table.

Description Indentation (53)

Integer

“Description Indentation” contains the level of description indentation of the current characteristic.

Exclude Calc. Surcharge (54)

Boolean

FieldClass: FlowField

CalcFormula: lookup("EOS028 CFG Rule Characteristic"."Exclude Calc. Surcharge" where("Characteristic Code" = field("Characteristic Code"), "Rule Code" = field("Rule Code")))

“Exclude Calc. Surcharge” if enabled, excludes the Characteristic from the calculation of surcharge.

Exclude From Releations Calc. (55)

Boolean

“Exclude From Relations Calc.” if enabled, excludes the Characteristic from the calculation of relations.

Excl. From Rel. Calc. Cond. (56)

Boolean

“Excl. From Rel. Calc. Cond.” if enabled, excludes the Characteristic from the calculation of relations with conditions.

Order Date (57)

Date

“Order Date” contains the order dat of the document from which the configuration starts.

Disable Validation (58)

Boolean

If active, the validation of the characteristic value is disabled.

Configuration (59)

Option

Standard (0) , Default (1)

It is used to define the configuration created from default. Only for internal use.

Exclude Calc. Optional (60)

Boolean

“Exclude Calc. Optional” if enabled, excludes the Characteristic from the calculation of optional.

Config. Item No. (100)

Code[20]

TableRelation: Item

Config. Variant Code (101)

Code[10]

TableRelation: "Item Variant".Code where("Item No." = field("Config. Item No."))

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.