Child tables
Stock child tables — 28 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.
28 entities in Stock.
Delivery Note Item
Stores delivery note item for a Delivery Note.
Naming: child row (hash) · 107 fields · 1 inbound ref · Parent(s): Delivery Note.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | yes | Quantity |
conversion_factor |
Float | yes | UOM Conversion Factor |
rate |
Currency | Rate | |
amount |
Currency | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
against_pick_list |
Link | Pick List | |
against_sales_invoice |
Link | Sales Invoice | |
against_sales_order |
Link | Sales Order | |
batch_no |
Link | Batch | |
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
item_code |
Link | Item | yes |
item_group |
Link | Item Group | |
item_tax_template |
Link | Item Tax Template | |
material_request |
Link | Material Request | |
project |
Link | Project | |
purchase_order |
Link | Purchase Order | |
quality_inspection |
Link | Quality Inspection | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | yes |
target_warehouse |
Link | Warehouse | |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM |
Delivery Stop
Stores delivery stop for a Delivery Trip.
Naming: child row (hash) · 24 fields · 1 inbound ref · Parent(s): Delivery Trip.delivery_stops
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
locked |
Check | Locked | |
estimated_arrival |
Datetime | Estimated Arrival |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
address |
Link | Address (fw) | yes |
contact |
Link | Contact (fw) | |
customer |
Link | Customer | |
delivery_note |
Link | Delivery Note | |
uom |
Link | UOM |
Item Attribute Value
Stores item attribute values for an Item Attribute.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Item Attribute.item_attribute_values
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
attribute_value |
Data | yes | Attribute Value |
abbr |
Data | yes | Abbreviation |
Relationships
No outgoing relationships.
Item Barcode
Stores barcodes for an Item.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Item.barcodes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
barcode |
Data | yes | Barcode |
barcode_type |
Select | Barcode Type |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
uom |
Link | UOM |
Item Customer Detail
Stores customer items for an Item.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Item.customer_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
ref_code |
Data | yes | Ref Code |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer_group |
Link | Customer Group | |
customer_name |
Link | Customer |
Item Default
Stores company-specific defaults for an Item, Item Group, or Brand, including Warehouses, Accounts, and buying settings.
Naming: child row (hash) · 26 fields · 3 inbound refs · Parent(s): Brand.brand_defaults, Item.item_defaults, Item Group.item_group_defaults
Relationships
| Field | Type | References | Req |
|---|---|---|---|
buying_cost_center |
Link | Cost Center | |
company |
Link | Company | yes |
default_cogs_account |
Link | Account | |
default_discount_account |
Link | Account | |
default_inventory_account |
Link | Account | |
default_price_list |
Link | Price List | |
default_provisional_account |
Link | Account | |
default_supplier |
Link | Supplier | |
default_warehouse |
Link | Warehouse | |
deferred_expense_account |
Link | Account | |
deferred_revenue_account |
Link | Account | |
expense_account |
Link | Account | |
income_account |
Link | Account | |
inventory_account_currency |
Link | Currency (fw) | |
purchase_expense_account |
Link | Account | |
purchase_expense_contra_account |
Link | Account | |
selling_cost_center |
Link | Cost Center |
Item Quality Inspection Parameter
Stores item quality inspection parameter for a Quality Inspection Template.
Naming: child row (hash) · 9 fields · 1 inbound ref · Parent(s): Quality Inspection Template.item_quality_inspection_parameter
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
value |
Data | Acceptance Criteria Value | |
min_value |
Float | Minimum Value | |
max_value |
Float | Maximum Value | |
numeric |
Check | Numeric |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
parameter_group |
Link | Quality Inspection Parameter Group | |
specification |
Link | Quality Inspection Parameter | yes |
Item Reorder
Stores reorder level based on warehouse for an Item.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Item.reorder_levels
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
warehouse_reorder_level |
Float | Re-order Level | |
warehouse_reorder_qty |
Float | Re-order Qty | |
material_request_type |
Select | yes | Material Request Type |
Relationships
Item Supplier
Stores item supplier for an Item.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Item.supplier_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
supplier_part_no |
Data | Supplier Part Number |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
supplier |
Link | Supplier | yes |
Item Tax
Stores taxes shared by Item Group and Item.
Naming: child row (hash) · 5 fields · 2 inbound refs · Parent(s): Item.taxes, Item Group.taxes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
valid_from |
Date | Valid From | |
maximum_net_rate |
Float | Maximum Net Rate | |
minimum_net_rate |
Float | Minimum Net Rate |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
item_tax_template |
Link | Item Tax Template | yes |
tax_category |
Link | Tax Category |
Item Variant Attribute
Stores variant attributes for an Item.
Naming: child row (hash) · 11 fields · 1 inbound ref · Parent(s): Item.attributes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
attribute_value |
Data | Attribute Value | |
disabled |
Check | Disabled |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
attribute |
Link | Item Attribute | yes |
variant_of |
Link | Item |
Landed Cost Item
Stores receipt items for a Landed Cost Voucher.
Naming: child row (hash) · 15 fields · 1 inbound ref · Parent(s): Landed Cost Voucher.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | Qty | |
amount |
Currency | yes | Amount |
applicable_charges |
Currency | Applicable Charges |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
cost_center |
Link | Cost Center | |
item_code |
Link | Item | yes |
receipt_document |
Dynamic Link | resolved via receipt_document_type |
Landed Cost Purchase Receipt
Stores vouchers for a Landed Cost Voucher.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Landed Cost Voucher.purchase_receipts
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
receipt_document_type |
Select | yes | Receipt Document Type |
posting_date |
Date | Posting Date | |
grand_total |
Currency | Grand Total |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
supplier |
Link | Supplier | |
receipt_document |
Dynamic Link | resolved via receipt_document_type |
Landed Cost Taxes and Charges
Stores landed cost taxes and charges shared by Subcontracting Order, Subcontracting Receipt, Landed Cost Voucher, and Stock Entry.
Naming: child row (hash) · 12 fields · 4 inbound refs · Parent(s): Landed Cost Voucher.taxes, Stock Entry.additional_costs, Subcontracting Order.additional_costs, Subcontracting Receipt.additional_costs
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
description |
Small Text | yes | Description |
amount |
Currency | yes | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account_currency |
Link | Currency (fw) | |
expense_account |
Link | Account |
Landed Cost Vendor Invoice
Stores vendor invoices for a Landed Cost Voucher.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Landed Cost Voucher.vendor_invoices
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
amount |
Currency | Amount (Company Currency) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
vendor_invoice |
Link | Purchase Invoice |
Material Request Item
Stores items for a Material Request.
Naming: child row (hash) · 61 fields · 2 inbound refs · Parent(s): Material Request.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | yes | Quantity |
conversion_factor |
Float | yes | UOM Conversion Factor |
schedule_date |
Date | yes | Required By |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
bom_no |
Link | BOM | |
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
from_warehouse |
Link | Warehouse | |
item_code |
Link | Item | yes |
item_group |
Link | Item Group | |
manufacturer |
Link | Manufacturer | |
production_plan |
Link | Production Plan | |
project |
Link | Project | |
sales_order |
Link | Sales Order | |
stock_uom |
Link | UOM | yes |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
wip_composite_asset |
Link | Asset |
Packed Item
Stores packed item shared by Quotation, Sales Order, Sales Invoice, POS Invoice, and Delivery Note.
Naming: child row (hash) · 36 fields · 5 inbound refs · Parent(s): Delivery Note.packed_items, POS Invoice.packed_items, Quotation.packed_items, Sales Invoice.packed_items, Sales Order.packed_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | Qty | |
rate |
Currency | Rate |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
item_code |
Link | Item | |
parent_item |
Link | Item | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
target_warehouse |
Link | Warehouse | |
uom |
Link | UOM | |
warehouse |
Link | Warehouse |
Packing Slip Item
Stores items for a Packing Slip.
Naming: child row (hash) · 15 fields · 1 inbound ref · Parent(s): Packing Slip.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | Item Name | |
qty |
Float | yes | Quantity |
net_weight |
Float | Net Weight | |
page_break |
Check | Page Break | |
dn_detail |
Data | Delivery Note Item |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
item_code |
Link | Item | yes |
stock_uom |
Link | UOM | |
weight_uom |
Link | UOM |
Pick List Item
Stores item locations for a Pick List.
Naming: child row (hash) · 37 fields · 2 inbound refs · Parent(s): Pick List.locations
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | yes | Qty |
picked_qty |
Float | Picked Qty (in Stock UOM) | |
stock_qty |
Float | Qty (in Stock UOM) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
item_code |
Link | Item | yes |
material_request |
Link | Material Request | |
sales_order |
Link | Sales Order | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | |
uom |
Link | UOM | |
warehouse |
Link | Warehouse |
Price List Country
Stores applicable for countries for a Price List.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Price List.countries
Relationships
| Field | Type | References | Req |
|---|---|---|---|
country |
Link | Country (fw) | yes |
Purchase Receipt Item
Stores items for a Purchase Receipt.
Naming: child row (hash) · 126 fields · 1 inbound ref · Parent(s): Purchase Receipt.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
received_qty |
Float | yes | Received Quantity |
qty |
Float | Accepted Quantity | |
rejected_qty |
Float | Rejected Quantity | |
conversion_factor |
Float | yes | Conversion Factor |
rate |
Currency | Rate | |
amount |
Currency | Amount | |
base_rate |
Currency | yes | Rate (Company Currency) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
asset_category |
Link | Asset Category | |
asset_location |
Link | Location | |
batch_no |
Link | Batch | |
bom |
Link | BOM | |
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
from_warehouse |
Link | Warehouse | |
item_code |
Link | Item | yes |
item_group |
Link | Item Group | |
item_tax_template |
Link | Item Tax Template | |
manufacturer |
Link | Manufacturer | |
material_request |
Link | Material Request | |
product_bundle |
Link | Product Bundle | |
project |
Link | Project | |
provisional_expense_account |
Link | Account | |
purchase_invoice |
Link | Purchase Invoice | |
purchase_order |
Link | Purchase Order | |
putaway_rule |
Link | Putaway Rule | |
quality_inspection |
Link | Quality Inspection | |
rejected_serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
rejected_warehouse |
Link | Warehouse | |
sales_order |
Link | Sales Order | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | yes |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM | |
wip_composite_asset |
Link | Asset |
Quality Inspection Reading
Stores readings for a Quality Inspection.
Naming: child row (hash) · 26 fields · 1 inbound ref · Parent(s): Quality Inspection.readings
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
reading_1 |
Data | Reading 1 | |
status |
Select | Status | |
reading_value |
Data | Reading Value | |
numeric |
Check | Numeric |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
parameter_group |
Link | Quality Inspection Parameter Group | |
specification |
Link | Quality Inspection Parameter | yes |
Serial and Batch Entry
Stores serial and batch entry shared by Stock Reservation Entry and Serial and Batch Bundle.
Naming: child row (hash) · 23 fields · 2 inbound refs · Parent(s): Serial and Batch Bundle.entries, Stock Reservation Entry.sb_entries
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | Qty |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
item_code |
Link | Item | |
serial_no |
Link | Serial No | |
warehouse |
Link | Warehouse |
Shipment Delivery Note
Stores shipment delivery note for a Shipment.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Shipment.shipment_delivery_note
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
grand_total |
Currency | Value |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
delivery_note |
Link | Delivery Note | yes |
Shipment Parcel
Stores shipment parcel for a Shipment.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Shipment.shipment_parcel
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
length |
Float | Length (cm) | |
width |
Float | Width (cm) | |
height |
Float | Height (cm) | |
weight |
Float | yes | Weight (kg) |
count |
Int | yes | Count |
Relationships
No outgoing relationships.
Stock Entry Detail
Stores items for a Stock Entry.
Naming: child row (hash) · 78 fields · 1 inbound ref · Parent(s): Stock Entry.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | yes | Qty |
basic_rate |
Currency | Basic Rate (as per Stock UOM) | |
conversion_factor |
Float | yes | Conversion Factor |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
against_fg |
Link | Subcontracting Inward Order Item | |
against_stock_entry |
Link | Stock Entry | |
batch_no |
Link | Batch | |
bom_no |
Link | BOM | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
item_code |
Link | Item | yes |
material_request |
Link | Material Request | |
material_request_item |
Link | Material Request Item | |
original_item |
Link | Item | |
pick_list_item |
Link | Pick List Item | |
project |
Link | Project | |
putaway_rule |
Link | Putaway Rule | |
quality_inspection |
Link | Quality Inspection | |
reference_purchase_receipt |
Link | Purchase Receipt | |
s_warehouse |
Link | Warehouse | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | yes |
subcontracted_item |
Link | Item | |
t_warehouse |
Link | Warehouse | |
uom |
Link | UOM | yes |
Stock Reconciliation Item
Stores items for a Stock Reconciliation.
Naming: child row (hash) · 33 fields · 1 inbound ref · Parent(s): Stock Reconciliation.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | Quantity | |
valuation_rate |
Currency | Valuation Rate |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
current_serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
item_code |
Link | Item | yes |
item_group |
Link | Item Group | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | |
warehouse |
Link | Warehouse | yes |
UOM Conversion Detail
Stores uom conversion detail for an Item.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Item.uoms
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
conversion_factor |
Float | Conversion Factor |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
uom |
Link | UOM | yes |