Patterns - Bill of Materials Pattern
It's an implementation of the Bill Of Materials Pattern
For a specific Transaction, this Pattern generates another transaction representing the components of a product. This allows representing the composite-component relation through a TRN.
This pattern defines the components transaction defining subtype attributes of the selected TRN and a procedure that calculates the components of a product.
Bill of Materials Pattern Instance
It is the Instance File
of the pattern (XML file) associated to the TRN.
The file .billofmaterials is an XML file that can be visualized in TreeView format and modified according to the user requirements. Its main properties are mentioned below.
It indicates the TRN you are working with.
TRN key parameters to be used as supertypes for the key of the Components TRN.
Secondary attribute to be used to define the subtypes group together with the PKAttributes.
Transaction of Components; the attributes to be configured are the following:
|Name||Name of the Composition TRN
|Generate||It indicates whether the TRN will be generated (true) or will be manually defined (False)
|Composite Prefix or Suffix||Prefix or suffix of the attributes defining the Composite
|Component Prefix or Suffix||Prefix or suffix of the attribute defining the Component
|Composite Subtype Group||Name of the subtype group of the Composite product
|Component Subtype Group||Name of the subtype group of the Component product
|Quantity Attribute||Attribute representing the quantity of products defined as Components|
Bill of Materials Procedure
This procedure enables to work out all the components of a product by calculating the quantities required by each of them.
The attributes to be configured are the following:
|Name||Name of the procedure; by default: CalculateBillOfMaterials
|CompositionSDT||SDT containing all the information that is being generated
|Create Test Webpanel||Indicates whether a Web Panel allowing to test the procedure will be generated or not
|Implementation||Manner in which the procedure will be generated: Recursive / Stack. For the time being it is only possible to generate the procedure in Recursive manner. Specifically, if you use the .NET generator to generate these objects, you must define the access to data such as ADO.NET.
Once the xpz generated by Patterns has been consolidated with all required objects, you can visualize in GeneXus
that the following objects are located in the Generated
- TRN containing the products Components
- Procedure that calculates the components of a product
- Web Panel to perform tests with the generated procedure
If .NET generator is used to generate this objects you must configure the DBMS Option:
Access technology to Set = ADO.NET
so that it works correctly.