workordercompletion

Tracks completed work orders, logging production outputs and associated costs.

Columns


Name	Type	References	Description
class	String		Represents the classification associated with the work order completion, typically used for financial tracking and reporting within NetSuite.
completedquantity	Double		The total quantity of items that have been successfully completed in this work order process.
createddate	Datetime		The timestamp indicating when the work order completion record was first created in the system.
customform	String		The custom form template used to capture and display work order completion details, allowing customization of data entry and reporting.
department	String		The department responsible for overseeing the work order completion, useful for cost allocation and departmental performance tracking.
endoperation	String		Specifies the final operation in the manufacturing process that marks the completion of the work order.
externalid	String		A unique identifier assigned externally to link this work order completion with records in other systems or integrations.
inventorydetail	String		Provides specific inventory-related details, such as lot numbers, serial numbers, or bin assignments, associated with the completed items.
isbackflush	Boolean		Indicates whether backflushing is applied, meaning components are automatically deducted from inventory upon work order completion.
item	String		The specific item or product associated with this work order completion, typically referencing an inventory item in NetSuite.
lastmodifieddate	Datetime		The timestamp reflecting the most recent modification made to this work order completion record.
location	String		The physical site or warehouse where the work order completion took place, important for inventory tracking and logistics.
manufacturingrouting	String		The predefined routing sequence used in the manufacturing process, defining the steps required to complete the work order.
memo	String		An optional field for entering additional notes or remarks related to this work order completion, useful for internal documentation.
orderquantity	Double		The total quantity of items originally planned for production as specified in the work order.
postingperiod	String		The financial posting period in which this work order completion is recorded, affecting accounting and financial reports.
quantity	Double		The actual quantity of items processed and completed in this work order execution.
revision	String		Identifies the version or engineering change level of the item being produced, ensuring the correct product design is followed.
revisionmemo	String		Additional notes regarding the item revision, often used to document engineering changes or version-specific instructions.
scrapquantity	Double		The number of items scrapped or discarded during the production process due to defects, errors, or material loss.
startoperation	String		The initial operation in the manufacturing workflow that begins the process of work order completion.
subsidiary	String		The specific subsidiary within the organization responsible for this work order completion, relevant in multi-entity setups.
taxperiod	String		The designated tax period for this work order completion, used for tax reporting and compliance purposes.
total	Decimal		The total cost or value associated with this work order completion, often used for cost accounting and financial tracking.
trandate	Date		The official transaction date when the work order completion was recorded in the system.
tranid	String		The unique identifier assigned to this work order completion transaction within NetSuite for reference and tracking.
unitcost	Double		The cost per unit of the item completed in this work order, essential for cost analysis and financial reporting.
units	String		The unit of measure (for example, pieces, kilograms, liters) associated with the completed quantity in this work order.

Tableau Connector for NetSuite

workordercompletion

Columns