Table 18060650 EOS028 CFG Def. ConfigLine

Table 18060650 EOS028 CFG Def. ConfigLine

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.

Campaign No. (5)

Code[20]

TableRelation: Campaign."No."

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

Vendor No. (6)

Code[20]

TableRelation: Vendor

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

Item No. (10)

Code[20]

TableRelation: Item

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

Unit of Measure Code (11)

Code[10]

TableRelation: "Item Unit of Measure".Code where("Item No." = field("Item No."))

“Unit of Measure Code” contains the unit of measure code of the document from which the configuration starts. if the configuration comes directly from the items master, contains the unit of measure code of the neutral item.

Description (12)

Text[100]

Description contains the description of neutral item.

Description 2 (13)

Text[50]

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

Quantity (14)

Decimal

Quantity contains the quantity of the document line from which the configuration starts. Quantity can be changed during configuration

Price (15)

Decimal

Price contains contains the price of the configuration.

Line Type (16)

Text[2]

This is an unused field.

Rule Code (17)

Code[10]

TableRelation: "EOS028 CFG Rule"

“Rule Code” contains the rule code of neutral item.

Scrap % (18)

Decimal

“Scrap %” contains the scrap % specified in the bill of materials.

Routing Link Code (19)

Code[10]

TableRelation: "Routing Link"

“Routing Link Code” contains the routing link code specified in the bill of materials.

Line Discount % (20)

Decimal

“Line Discount %” contains the line discount % of the document line from which the configuration starts.

Entry No. (21)

Integer

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

Indentation (22)

Integer

Indentation contains the level of of the bill of materials.

Key Code (23)

Text[2048]

“Key Code” contains the key for the specific configuration. it is an encrypted string with all the concatenated characteristics (both code and value).

Conf. Item No. (24)

Code[20]

TableRelation: Item."No."

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

Main WBS No. (25)

Text[200]

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

Variant Code (26)

Code[10]

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

If variant management is enabled, the variant code from which the configuration starts is saved in this field.

BOM Line No. (27)

Integer

“BOM Line No.” contains the line no. of the bill of materials.

Configuration Type (28)

Option

Fix (0) , "Neutral to Fix" (1) , "Neutral to Configuration" (2)

“Configuration Type” contains the configuration type of neutral item.

BOM Line Type (29)

Option

" " (0) , Item (1) , "Production BOM" (2)

“BOM Line Type” contains the line type of the bill of materials.

Surcharge (30)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS028 CFG Def. ConfigCharac".Surcharge where("Config. Item No." = field("Config. Item No."), "Config. Variant Code" = field("Config. Variant Code")))

Surcharge contains the total of the surcharges for the current configuration.

Quantity Formula (31)

Text[200]

“Quantity Formula” contains the formula of the bill of materials for calculate quantity per.

Routing Rule Code (32)

Code[20]

TableRelation: "EOS028 CFG Config. Condition".Code where("Destination Type" = Filter("BOM Component" | "All Applications"))

“Routing Rule Code” contains the condition code of the bill of materials.

Document Date (33)

Date

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

Currency Code (34)

Code[10]

TableRelation: Currency

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

Customer Price Group (35)

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. (36)

Code[20]

TableRelation: Customer

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

Order Date (37)

Date

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

Optional Amount (38)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS028 CFG Def. ConfigCharac"."Optional Amount" where("Config. Item No." = field("Config. Item No."), "Config. Variant Code" = field("Config. Variant Code")))

Surcharge contains the total of the optionals for the current configuration.

Sales Unit of Measure Code (39)

Code[10]

TableRelation: "Item Unit of Measure".Code where("Item No." = field("Item No."))

“Sales Unit of Measure Code” contains sales unit of measure code of neutral item.

Qty. per Unit of Measure (40)

Decimal

“Qty. per Unit of Measure” contains qty. per unit of measure of neutral item.

Currency Factor (41)

Decimal

“Currency Factor” contains the currency factor of the document from which the configuration starts.

Posting Date (42)

Date

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

New Item No. (43)

Code[20]

“New Item No.” contains the the item code configured.

Formula Code (44)

Code[20]

TableRelation: "EOS028 CFG Formula Header"

“Formula Code” contains the formula code of the bill of materials for calculate quantity per.

Production BOM No. (45)

Code[20]

TableRelation: "Production BOM Header"

“Production BOM No.” contains the production BOM no. of the neutral item.

BOM Version Code (46)

Code[20]

TableRelation: "Production BOM Version"."Version Code" WHERE("Production BOM No." = FIELD("Production BOM No."))

“BOM Version Code” contains the BOM version code of the neutral item.

Source Type (47)

Enum "EOS028 CFG Source Type"

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

Position (48)

Code[10]

“Position” specifies the position of the component on the bill of material.

Position 2 (49)

Code[10]

“Position 2” specifies the position of the component on the bill of material.

Position 3 (50)

Code[10]

“Position 3” specifies the position of the component on the bill of material.

Scrap % Formula Code (51)

Code[10]

TableRelation: "EOS028 CFG Formula Header"

“Scrap % Formula Code” contains the formula code to calculate scrap %.

Calculation Formula (52)

Integer

“Calculation Formula” contains the “Calculation Formula” on the production BOM line.

Create Sales Line (53)

Boolean

“Create Sales Line” enables the creation of a new sales order line after item configuration

Create Purch. Line (54)

Boolean

“Create Purch. Line” enables the creation of a new purchase order line after item configuration

Sales Price Calc. % (55)

Decimal

“Sales Price Calc. %” specifies the percentage to be applied to the price of the new sales order line after item configuration

Purch. Price Calc. % (56)

Decimal

“Purch. Price Calc. %” specifies the percentage to be applied to the price of the new purchase order line after item configuration

Length (57)

Decimal

“Length” contains the Length on the production BOM line.

Width (58)

Decimal

“Width” contains the Width on the production BOM line.

Weight (59)

Decimal

“Weight” contains the Weight on the production BOM line.

Depth (60)

Decimal

“Depth” contains the Depth on the production BOM line.

BOM Component Type (61)

Enum "BOM Component Type"

“BOM Component Type” contains the line type in BOM Component.

BOM Component Line No. (62)

Integer

“BOM Component Line No.” contains the BOM Component Line No.

Installed in Item No. (63)

Code[20]

TableRelation: IF ("BOM Component Type" = CONST(Item)) Item

“Installed in Item No.” contains the related field in BOM Component.

Installed in Line No. (64)

Integer

“Installed in Line No.” contains the related field in BOM Component.

Replenishment System (65)

Enum "Replenishment System"

“Replenishment System” contains the related field in BOM Buffer.

Item Already Exists (66)

Boolean

Job No. (67)

Code[20]

“Job No.” from which the configuration starts (config. from job planning line).

Job Task No. (68)

Code[20]

“Job Task No.” from which the configuration starts (config. from job planning line).

Job Planning Line No. (69)

Integer

“Job Planning Line No.” from which the configuration starts (config. from job planning line).

Configuration (70)

Option

Standard (0) , Default (1)

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

Derived Rule Code (71)

Code[10]

TableRelation: "EOS028 CFG Rule"

“Derived Rule Code” is set for items configured from BOM Line and specifies the rule code used for the configuration of the component.

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.