Child tables
Subcontracting child tables — 9 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.
9 entities in Subcontracting.
Subcontracting Inward Order Item
Lists finished Items the company will produce for a Customer under a Subcontracting Inward Order.
Naming: child row (hash) · 17 fields · 2 inbound refs · Parent(s): Subcontracting Inward Order.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | yes | Quantity |
delivered_qty |
Float | Delivered Qty |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
bom |
Link | BOM | yes |
delivery_warehouse |
Link | Warehouse | yes |
item_code |
Link | Item | yes |
stock_uom |
Link | UOM | yes |
Subcontracting Inward Order Received Item
Tracks customer-provided raw materials received for a Subcontracting Inward Order.
Naming: child row (hash) · 20 fields · 1 inbound ref · Parent(s): Subcontracting Inward Order.received_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
reference_name |
Data | yes | Reference Name |
required_qty |
Float | Required Qty | |
received_qty |
Float | Received Qty | |
is_customer_provided_item |
Check | yes | Is Customer Provided Item |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
main_item_code |
Link | Item | yes |
rm_item_code |
Link | Item | yes |
stock_uom |
Link | UOM | yes |
warehouse |
Link | Warehouse |
Subcontracting Inward Order Secondary Item
Stores secondary items for a Subcontracting Inward Order.
Naming: child row (hash) · 13 fields · 1 inbound ref · Parent(s): Subcontracting Inward Order.secondary_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
reference_name |
Data | yes | Reference Name |
produced_qty |
Float | yes | Produced Qty |
delivered_qty |
Float | yes | Delivered Qty |
type |
Select | yes | Type |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
fg_item_code |
Link | Item | yes |
item_code |
Link | Item | yes |
stock_uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | yes |
Subcontracting Inward Order Service Item
Lists the service Items billed for work performed under a Subcontracting Inward Order.
Naming: child row (hash) · 14 fields · 1 inbound ref · Parent(s): Subcontracting Inward Order.service_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | yes | Quantity |
rate |
Currency | yes | Rate |
amount |
Currency | yes | Amount |
fg_item_qty |
Float | yes | Finished Good Item Quantity |
Relationships
Subcontracting Order Item
Lists finished Items ordered from a job worker under a Subcontracting Order.
Naming: child row (hash) · 50 fields · 1 inbound ref · Parent(s): Subcontracting Order.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
schedule_date |
Date | Required By | |
expected_delivery_date |
Date | Expected Delivery Date | |
qty |
Float | yes | Quantity |
rate |
Currency | yes | Rate |
amount |
Currency | yes | Amount |
service_cost_per_qty |
Currency | yes | Service Cost Per Qty |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
bom |
Link | BOM | yes |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
item_code |
Link | Item | yes |
job_card |
Link | Job Card | |
manufacturer |
Link | Manufacturer | |
material_request |
Link | Material Request | |
project |
Link | Project | |
stock_uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | yes |
Subcontracting Order Service Item
Lists the service Items purchased from the job worker for a Subcontracting Order.
Naming: child row (hash) · 18 fields · 1 inbound ref · Parent(s): Subcontracting Order.service_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | yes | Quantity |
rate |
Currency | yes | Rate |
amount |
Currency | yes | Amount |
fg_item_qty |
Float | yes | Finished Good Item Quantity |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
fg_item |
Link | Item | yes |
item_code |
Link | Item | yes |
material_request |
Link | Material Request |
Subcontracting Order Supplied Item
Tracks raw materials reserved or transferred to the job worker for a Subcontracting Order.
Naming: child row (hash) · 21 fields · 1 inbound ref · Parent(s): Subcontracting Order.supplied_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
rate |
Currency | Rate | |
required_qty |
Float | Required Qty | |
supplied_qty |
Float | Supplied Qty |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
main_item_code |
Link | Item | |
reserve_warehouse |
Link | Warehouse | |
rm_item_code |
Link | Item | |
stock_uom |
Link | UOM |
Subcontracting Receipt Item
Records each finished Item accepted or rejected from a job worker.
Naming: child row (hash) · 71 fields · 1 inbound ref · Parent(s): Subcontracting Receipt.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
received_qty |
Float | yes | Qty (As per BOM) |
qty |
Float | Accepted Qty | |
rejected_qty |
Float | Rejected Qty | |
rate |
Currency | Rate | |
amount |
Currency | Amount | |
service_cost_per_qty |
Currency | yes | Service Cost Per Qty |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
bom |
Link | BOM | |
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
item_code |
Link | Item | yes |
job_card |
Link | Job Card | |
manufacturer |
Link | Manufacturer | |
project |
Link | Project | |
purchase_order |
Link | Purchase Order | |
quality_inspection |
Link | Quality Inspection | |
rejected_serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
rejected_warehouse |
Link | Warehouse | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
service_expense_account |
Link | Account | |
stock_uom |
Link | UOM | yes |
subcontracting_order |
Link | Subcontracting Order | |
warehouse |
Link | Warehouse |
Subcontracting Receipt Supplied Item
Records the company-supplied raw materials consumed for finished Items on a Subcontracting Receipt.
Naming: child row (hash) · 33 fields · 1 inbound ref · Parent(s): Subcontracting Receipt.supplied_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
required_qty |
Float | Required Qty | |
consumed_qty |
Float | yes | Consumed Qty |
rate |
Currency | Rate | |
reference_name |
Data | Reference Name | |
bom_detail_no |
Data | BOM Detail No |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
main_item_code |
Link | Item | |
rm_item_code |
Link | Item | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | |
subcontracting_order |
Link | Subcontracting Order |