assemblybuild
The AssemblyBuild table stores records of assembly builds, tracking the conversion of components into finished goods through the production process.
Columns
| Name | Type | References | Description |
| billofmaterials | String | The bill of materials (BOM) that is used for this assembly build. This BOM defines the list of raw materials, components, and subassemblies required to produce the finished item. | |
| billofmaterialsrevision | String | The specific revision of the BOM that is applied to this assembly build. This field ensures that the correct version of the BOM is used, reflecting any design or component updates. | |
| buildable | Double | The number of finished units that can be built based on available inventory. This field helps determine production feasibility by comparing component availability to the BOM requirements. | |
| class | String | The classification associated with this assembly build. This classification supports financial segmentation and reporting by grouping transactions under specific categories. | |
| createddate | Datetime | The date and time when the assembly build record was created. This timestamp provides an audit trail for manufacturing and inventory tracking purposes. | |
| customform | String | The custom form that is used for this assembly build transaction. This field allows organizations to apply a specific layout and data fields to meet unique business requirements. | |
| department | String | The department that is responsible for the assembly build. This field ensures that production costs are correctly attributed to the appropriate department for budgeting and financial reporting. | |
| externalid | String | The unique identifier (Id) assigned to this assembly build by an external system. This Id facilitates data synchronization and integration with third-party manufacturing or inventory systems. | |
| inventorydetail | String | Detailed inventory-tracking information that is associated with this assembly build. This information provides visibility into lot numbers, serial numbers, and bin locations for better inventory control. | |
| item | String | The finished item that is produced by this assembly build. This field identifies the manufactured product and links it to inventory management and sales processes. | |
| lastmodifieddate | Datetime | The date and time when the assembly build record was last modified. This timestamp helps track changes and ensures data accuracy in manufacturing records. | |
| location | String | The physical or operational location where the assembly build is performed. This location supports warehouse management, inventory tracking, and cost allocation. | |
| memo | String | A free-text field for adding notes or comments related to this assembly build. This field provides additional context or instructions for production and inventory teams. | |
| postingperiod | String | The financial period in which this assembly build transaction is recorded. This field ensures that manufacturing costs and inventory adjustments are properly recognized in accounting records. | |
| quantity | String | The total number of finished units that is produced in this assembly build. This field helps track production output and inventory adjustments. | |
| revision | String | The specific product or engineering revision that is applied to the finished item. This field ensures that the correct version of the product is manufactured according to current specifications. | |
| revisionmemo | String | Additional notes or details related to the revision used in this assembly build. This field provides contextual information about design changes or production updates. | |
| subsidiary | String | The subsidiary that is responsible for this assembly build transaction. This field ensures that manufacturing activities are correctly assigned to the appropriate legal entity in multi-subsidiary organizations. | |
| total | Decimal | The total cost that is associated with this assembly build. This total includes the cost of components, labor, and overhead, ensuring accurate financial tracking of production expenses. | |
| trandate | Date | The transaction date of the assembly build. This date determines when the inventory and financial impact of the build is recorded in the system. | |
| tranid | String | The system-generated unique Id for this assembly build transaction. This Id provides a reference for tracking and retrieving build records in inventory and financial systems. | |
| units | String | The unit of measure (UOM) that is applied to the finished item. This UOM ensures consistency in inventory tracking and production planning. |