Child tables

Selling child tables — 7 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.

7 entities in Selling.

Customer Credit Limit

Stores credit limit shared by Customer and Customer Group.

Naming: child row (hash) · 4 fields · 2 inbound refs · Parent(s): Customer.credit_limits, Customer Group.credit_limits

Key fields

Field	Type	Req	Label
`credit_limit`	Currency		Credit Limit
`bypass_credit_limit_check`	Check		Bypass credit limit check at sales order

Relationships

Field	Type	References	Req
`company`	Link	Company

Installation Note Item

Stores items for an Installation Note.

Naming: child row (hash) · 8 fields · 1 inbound ref · Parent(s): Installation Note.items

Key fields

Field	Type	Req	Label
`qty`	Float	yes	Installed Qty

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes
`serial_and_batch_bundle`	Link	Serial and Batch Bundle

Product Bundle Item

Stores items for a Product Bundle.

Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Product Bundle.items

Key fields

Field	Type	Req	Label
`qty`	Float	yes	Qty

Relationships

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

Quotation Item

Stores items for a Quotation.

Naming: child row (hash) · 77 fields · 1 inbound ref · Parent(s): Quotation.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
`ordered_qty`	Float	yes	Ordered Qty

Relationships

Field	Type	References	Req
`blanket_order`	Link	Blanket Order
`brand`	Link	Brand
`item_code`	Link	Item
`item_group`	Link	Item Group
`item_tax_template`	Link	Item Tax Template
`prevdoc_doctype`	Link	DocType (fw)
`stock_uom`	Link	UOM
`uom`	Link	UOM	yes
`warehouse`	Link	Warehouse
`weight_uom`	Link	UOM
`prevdoc_docname`	Dynamic Link	resolved via `prevdoc_doctype`

Sales Order Item

Stores items for a Sales Order.

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

Key fields

Field	Type	Req	Label
`item_name`	Data	yes	Item Name
`delivery_date`	Date		Delivery Date
`qty`	Float	yes	Quantity
`conversion_factor`	Float	yes	UOM Conversion Factor
`rate`	Currency		Rate
`amount`	Currency		Amount
`transaction_date`	Date		Sales Order Date

Relationships

Field	Type	References	Req
`blanket_order`	Link	Blanket Order
`bom_no`	Link	BOM
`brand`	Link	Brand
`cost_center`	Link	Cost Center
`fg_item`	Link	Item
`item_code`	Link	Item	yes
`item_group`	Link	Item Group
`item_tax_template`	Link	Item Tax Template
`material_request`	Link	Material Request
`prevdoc_docname`	Link	Quotation
`project`	Link	Project
`purchase_order`	Link	Purchase Order
`stock_uom`	Link	UOM
`supplier`	Link	Supplier
`target_warehouse`	Link	Warehouse
`uom`	Link	UOM	yes
`warehouse`	Link	Warehouse
`weight_uom`	Link	UOM

Sales Team

Allocates a sales transaction or Customer to Sales Persons by contribution percentage and commission.

Naming: child row (hash) · 6 fields · 5 inbound refs · Parent(s): Customer.sales_team, Delivery Note.sales_team, POS Invoice.sales_team, Sales Invoice.sales_team, Sales Order.sales_team

Key fields

Field	Type	Label
`contact_no`	Data	Contact No.
`allocated_percentage`	Float	Contribution (%)
`allocated_amount`	Currency	Contribution to Net Total
`commission_rate`	Data	Commission Rate
`incentives`	Currency	Incentives

Relationships

Field	Type	References	Req
`sales_person`	Link	Sales Person	yes

Supplier Number At Customer

Stores supplier numbers for a Customer.

Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Customer.supplier_numbers

Key fields

Field	Type	Req	Label
`supplier_number`	Data		Supplier Number

Relationships

Field	Type	References	Req
`company`	Link	Company