Child tables

Manufacturing child tables — 27 entities with their key fields and relationships.

Row sets owned by exactly one parent document. They have no independent existence — deleting the parent deletes the rows.

27 entities in Manufacturing.

BOM Creator Item

Stores items for a BOM Creator.

Naming: child row (hash) · 34 fields · 1 inbound ref · Parent(s): BOM Creator.items

Key fields

Field	Type	Label
`is_expandable`	Check	Is Expandable
`qty`	Float	Qty
`rate`	Currency	Rate

Relationships

Field	Type	References	Req
`fg_item`	Link	Item	yes
`item_code`	Link	Item	yes
`item_group`	Link	Item Group
`operation`	Link	Operation
`stock_uom`	Link	UOM
`uom`	Link	UOM

BOM Explosion Item

Stores the fully expanded material requirements of a BOM; unlike BOM Item, it includes components reached through lower-level BOMs.

Naming: child row (hash) · 20 fields · 1 inbound ref · Parent(s): BOM.exploded_items

Key fields

Field	Type	Label
`item_name`	Data	Item Name
`stock_qty`	Float	Stock Qty
`rate`	Currency	Rate
`qty_consumed_per_unit`	Float	Qty Consumed Per Unit
`amount`	Currency	Amount

Relationships

Field	Type	References
`item_code`	Link	Item
`operation`	Link	Operation
`source_warehouse`	Link	Warehouse
`stock_uom`	Link	UOM

BOM Item

Stores components for a BOM.

Naming: child row (hash) · 38 fields · 1 inbound ref · Parent(s): BOM.items

Key fields

Field	Type	Req	Label
`qty`	Float	yes	Qty
`rate`	Currency	yes	Rate
`amount`	Currency		Amount

Relationships

Field	Type	References	Req
`bom_no`	Link	BOM
`item_code`	Link	Item	yes
`operation`	Link	Operation
`original_item`	Link	Item
`source_warehouse`	Link	Warehouse
`stock_uom`	Link	UOM
`uom`	Link	UOM	yes

BOM Operation

Defines an operation, Workstation, time, and operating cost on a BOM or reusable Routing.

Naming: child row (hash) · 35 fields · 2 inbound refs · Parent(s): BOM.operations, Routing.operations

Key fields

Field	Type	Req	Label
`time_in_mins`	Float	yes	Operation Time
`sequence_id`	Int		Sequence ID
`finished_good_qty`	Float		Qty to Produce

Relationships

Field	Type	References	Req
`bom_no`	Link	BOM
`fg_warehouse`	Link	Warehouse
`finished_good`	Link	Item
`operation`	Link	Operation	yes
`source_warehouse`	Link	Warehouse
`wip_warehouse`	Link	Warehouse
`workstation`	Link	Workstation
`workstation_type`	Link	Workstation Type

BOM Secondary Item

Lists secondary or by-product items produced by a BOM, rather than the input materials listed in BOM Item.

Naming: child row (hash) · 25 fields · 1 inbound ref · Parent(s): BOM.secondary_items

Key fields

Field	Type	Req	Label
`type`	Select		Type
`item_name`	Data		Item Name
`cost`	Currency	yes	Cost
`conversion_factor`	Float	yes	Conversion Factor
`qty`	Float		Qty
`cost_allocation_per`	Percent	yes	Cost Allocation %
`process_loss_per`	Percent	yes	Process Loss %
`base_cost`	Currency	yes	Base Cost (Company Currency)
`process_loss_qty`	Float	yes	Process Loss Qty

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes
`stock_uom`	Link	UOM
`uom`	Link	UOM	yes

Blanket Order Item

Stores item for a Blanket Order.

Naming: child row (hash) · 9 fields · 1 inbound ref · Parent(s): Blanket Order.items

Key fields

Field	Type	Req	Label
`qty`	Float		Quantity
`rate`	Currency	yes	Rate
`ordered_qty`	Float		Ordered Quantity

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes

Job Card Item

Stores items for a Job Card.

Naming: child row (hash) · 14 fields · 1 inbound ref · Parent(s): Job Card.items

Key fields

Field	Type	Req	Label
`required_qty`	Float		Required Qty

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes
`item_group`	Link	Item Group
`source_warehouse`	Link	Warehouse
`stock_uom`	Link	UOM
`uom`	Link	UOM

Job Card Operation

Stores sub operations for a Job Card.

Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Job Card.sub_operations

Key fields

Field	Type	Label
`status`	Select	Status
`completed_time`	Data	Completed Time
`completed_qty`	Float	Completed Qty

Relationships

Field	Type	References	Req
`sub_operation`	Link	Operation

Job Card Scheduled Time

Stores scheduled time logs for a Job Card.

Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Job Card.scheduled_time_logs

Key fields

Field	Type	Label
`from_time`	Datetime	From Time
`to_time`	Datetime	To Time
`time_in_mins`	Float	Time (In Mins)

Relationships

No outgoing relationships.

Job Card Secondary Item

Stores secondary items for a Job Card.

Naming: child row (hash) · 10 fields · 1 inbound ref · Parent(s): Job Card.secondary_items

Key fields

Field	Type	Req	Label
`item_name`	Data		Secondary Item Name
`stock_qty`	Float	yes	Qty
`type`	Select	yes	Type

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes
`stock_uom`	Link	UOM

Job Card Time Log

Stores job card time log for a Job Card.

Naming: child row (hash) · 7 fields · 2 inbound refs · Parent(s): Job Card.employee, Job Card.time_logs

Key fields

Field	Type	Label
`from_time`	Datetime	From Time
`to_time`	Datetime	To Time
`time_in_mins`	Float	Time In Mins
`completed_qty`	Float	Completed Qty

Relationships

Field	Type	References	Req
`employee`	Link	Employee
`operation`	Link	Operation

Master Production Schedule Item

Stores the time-phased demand and planned production quantities for one Item in a Master Production Schedule.

Naming: child row (hash) · 9 fields · 2 inbound refs · Parent(s): Master Production Schedule.items, Master Production Schedule.select_items

Key fields

Field	Type	Label
`delivery_date`	Date	Delivery Date
`planned_qty`	Float	Planned Qty
`order_release_date`	Date	Start Date
`cumulative_lead_time`	Int	Lead Time

Relationships

Field	Type	References
`bom_no`	Link	BOM
`item_code`	Link	Item
`uom`	Link	UOM
`warehouse`	Link	Warehouse

Material Request Plan Item

Stores raw materials for a Production Plan.

Naming: child row (hash) · 32 fields · 1 inbound ref · Parent(s): Production Plan.mr_items

Key fields

Field	Type	Req	Label
`material_request_type`	Select		Type
`quantity`	Float	yes	Required Qty
`projected_qty`	Float		Projected Qty
`min_order_qty`	Float		Minimum Order Quantity
`required_bom_qty`	Float		Reqd Qty (BOM)
`schedule_date`	Date		Required By

Relationships

Field	Type	References	Req
`from_bom`	Link	BOM
`from_warehouse`	Link	Warehouse
`item_code`	Link	Item	yes
`main_item_code`	Link	Item
`sales_order`	Link	Sales Order
`uom`	Link	UOM
`warehouse`	Link	Warehouse	yes

Production Plan Item

Represents one finished or subassembly Item selected for production in a Production Plan.

Naming: child row (hash) · 23 fields · 1 inbound ref · Parent(s): Production Plan.po_items

Key fields

Field	Type	Req	Label
`planned_qty`	Float	yes	Planned Qty
`planned_start_date`	Datetime	yes	Planned Start Date

Relationships

Field	Type	References	Req
`bom_no`	Link	BOM	yes
`item_code`	Link	Item	yes
`material_request`	Link	Material Request
`product_bundle_item`	Link	Item
`sales_order`	Link	Sales Order
`stock_uom`	Link	UOM	yes
`warehouse`	Link	Warehouse

Production Plan Item Reference

Links a planned Item quantity back to the Sales Order or Material Request row that created the demand.

Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Production Plan.prod_plan_references

Key fields

Field	Type	Label
`sales_order_item`	Data	Sales Order Item
`qty`	Float	Qty
`item_reference`	Data	Item Reference

Relationships

Field	Type	References	Req
`sales_order`	Link	Sales Order

Production Plan Material Request

Stores material requests shared by Master Production Schedule and Production Plan.

Naming: child row (hash) · 3 fields · 2 inbound refs · Parent(s): Master Production Schedule.material_requests, Production Plan.material_requests

Key fields

Field	Type	Req	Label
`material_request_date`	Date		Material Request Date

Relationships

Field	Type	References	Req
`material_request`	Link	Material Request	yes

Production Plan Material Request Warehouse

Stores warehouses for a Production Plan.

Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Production Plan.warehouses

Relationships

Field	Type	References	Req
`warehouse`	Link	Warehouse

Production Plan Sales Order

Stores sales orders shared by Master Production Schedule and Production Plan.

Naming: child row (hash) · 6 fields · 2 inbound refs · Parent(s): Master Production Schedule.sales_orders, Production Plan.sales_orders

Key fields

Field	Type	Label
`sales_order_date`	Date	Sales Order Date
`grand_total`	Currency	Grand Total
`status`	Data	Status

Relationships

Field	Type	References	Req
`customer`	Link	Customer
`sales_order`	Link	Sales Order	yes

Production Plan Sub Assembly Item

Stores the subassemblies that a Production Plan must manufacture or obtain before producing its finished Items.

Naming: child row (hash) · 34 fields · 1 inbound ref · Parent(s): Production Plan.sub_assembly_items

Key fields

Field	Type	Label
`qty`	Float	Qty to Order
`type_of_manufacturing`	Select	Manufacturing Type
`projected_qty`	Float	Projected Qty
`required_qty`	Float	Required Qty

Relationships

Field	Type	References
`bom_no`	Link	BOM
`fg_warehouse`	Link	Warehouse
`parent_item_code`	Link	Item
`production_item`	Link	Item
`purchase_order`	Link	Purchase Order
`sales_order`	Link	Sales Order
`stock_uom`	Link	UOM
`supplier`	Link	Supplier
`uom`	Link	UOM

Sales Forecast Item

Stores forecast demand for one Item and Warehouse across the forecast’s weekly or monthly periods.

Naming: child row (hash) · 6 fields · 2 inbound refs · Parent(s): Sales Forecast.items, Sales Forecast.selected_items

Key fields

Field	Type	Req	Label
`item_name`	Data		Item Name
`delivery_date`	Date		Delivery Date
`demand_qty`	Float	yes	Demand Qty

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes
`uom`	Link	UOM
`warehouse`	Link	Warehouse

Sub Operation

Stores sub operation for an Operation.

Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Operation.sub_operations

Key fields

Field	Type	Req	Label
`time_in_mins`	Float		Operation Time

Relationships

Field	Type	References	Req
`operation`	Link	Operation	yes

Work Order Additional Item

Stores work order additional item for a Work Order.

Naming: child row (hash) · 7 fields · 2 inbound refs · Parent(s): Work Order.non_stock_items, Work Order.secondary_items

Key fields

Field	Type	Label
`type`	Data	Type
`qty`	Float	Qty
`amount`	Currency	Amount
`rate`	Currency	Rate

Relationships

Field	Type	References	Req
`item_code`	Link	Item
`uom`	Link	UOM

Work Order Item

Stores work order item for a Work Order.

Naming: child row (hash) · 26 fields · 1 inbound ref · Parent(s): Work Order.required_items

Key fields

Field	Type	Label
`required_qty`	Float	Required Qty
`transferred_qty`	Float	Transferred Qty
`consumed_qty`	Float	Consumed Qty
`returned_qty`	Float	Returned Qty

Relationships

Field	Type	References
`item_code`	Link	Item
`operation`	Link	Operation
`source_warehouse`	Link	Warehouse
`stock_uom`	Link	UOM

Work Order Operation

Stores operations for a Work Order.

Naming: child row (hash) · 38 fields · 1 inbound ref · Parent(s): Work Order.operations

Key fields

Field	Type	Req	Label
`status`	Select		Status
`time_in_mins`	Float	yes	Time

Relationships

Field	Type	References	Req
`bom`	Link	BOM
`bom_no`	Link	BOM
`fg_warehouse`	Link	Warehouse
`finished_good`	Link	Item
`operation`	Link	Operation	yes
`source_warehouse`	Link	Warehouse
`wip_warehouse`	Link	Warehouse
`workstation`	Link	Workstation
`workstation_type`	Link	Workstation Type

Workstation Cost

Stores operating components cost shared by Workstation and Workstation Type.

Naming: child row (hash) · 2 fields · 2 inbound refs · Parent(s): Workstation.workstation_costs, Workstation Type.workstation_costs

Key fields

Field	Type	Req	Label
`operating_cost`	Currency	yes	Operating Cost

Relationships

Field	Type	References	Req
`operating_component`	Link	Workstation Operating Component	yes

Workstation Operating Component Account

Stores component expense account for a Workstation Operating Component.

Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Workstation Operating Component.accounts

Relationships

Field	Type	References	Req
`company`	Link	Company	yes
`expense_account`	Link	Account

Workstation Working Hour

Stores working hours for a Workstation.

Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Workstation.working_hours

Key fields

Field	Type	Req	Label
`start_time`	Time	yes	Start Time
`end_time`	Time	yes	End Time
`enabled`	Check		Enabled

Relationships

No outgoing relationships.