assemblyItemMember
The AssemblyItemMember table defines the individual components that make up an assembly item, specifying quantities and roles within the finished product.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The system-generated identifier (Id) for this assembly-item member record. This unique value is used to track and reference specific component associations within the bill of materials (BOM) structure. | |
| bomquantity | Decimal | The quantity of this component that is required to assemble one unit of the parent assembly item, as defined in the BOM. This value determines material consumption per unit of finished goods. | |
| componentyield | Double | The expected yield percentage of this component when used in the assembly process. A yield lower than 100% accounts for potential scrap, wastage, or inefficiencies in manufacturing. | |
| effectivedate | Date | The date when this component becomes effective as part of the BOM for the parent assembly item. Any production or procurement using this BOM before this date does not include the component. | |
| effectiverevision | String | The specific revision of the BOM where this component becomes effective. BOM revisions track changes to product configurations, ensuring that the correct components are used at the right time. | |
| item | String | The unique Id or name of the component item that is included in the assembly. This item is used as a subcomponent in the parent assembly item’s BOM. | |
| itemsource | String | The source of this component, specifying whether it is manufactured internally, procured from vendors, or transferred from another location. This classification helps determine supply chain strategies for the component. | |
| linenumber | Integer | The system-assigned line Id for this component within the BOM. Line numbers define the sequence in which components are listed and help differentiate between multiple components. | |
| obsoletedate | Date | The date when this component is no longer valid for use in the BOM. After this date, the component is considered obsolete and should not be included in new production runs. | |
| obsoleterevision | String | The specific revision of the BOM where this component becomes obsolete. This revision ensures that outdated components are removed from active production and replaced with newer versions if applicable. | |
| parentitem | String | The parent assembly item that this component belongs to in the BOM. This item defines the hierarchical relationship between the finished product and its subcomponents. | |
| quantity | Decimal | The total quantity of this component that is required for the specified parent assembly item, as defined in the BOM. This value determines material requirements for production planning and procurement. |