Child tables
Buying child tables — 10 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.
10 entities in Buying.
Customer Number At Supplier
Stores customer numbers for a Supplier.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Supplier.customer_numbers
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
customer_number |
Data | Customer Number |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
company |
Link | Company |
Purchase Order Item
Stores items for a Purchase Order.
Naming: child row (hash) · 107 fields · 1 inbound ref · Parent(s): Purchase Order.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
schedule_date |
Date | yes | Required By |
expected_delivery_date |
Date | Expected Delivery Date | |
qty |
Float | yes | Quantity |
conversion_factor |
Float | yes | UOM Conversion Factor |
rate |
Currency | Rate | |
amount |
Currency | Amount | |
base_rate |
Currency | yes | Rate (Company Currency) |
base_amount |
Currency | yes | Amount (Company Currency) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
blanket_order |
Link | Blanket Order | |
bom |
Link | BOM | |
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
expense_account |
Link | Account | |
fg_item |
Link | Item | |
from_warehouse |
Link | Warehouse | |
item_code |
Link | Item | yes |
item_group |
Link | Item Group | |
item_tax_template |
Link | Item Tax Template | |
job_card |
Link | Job Card | |
manufacturer |
Link | Manufacturer | |
material_request |
Link | Material Request | |
product_bundle |
Link | Product Bundle | |
production_plan |
Link | Production Plan | |
project |
Link | Project | |
sales_order |
Link | Sales Order | |
stock_uom |
Link | UOM | yes |
supplier_quotation |
Link | Supplier Quotation | |
supplier_quotation_item |
Link | Supplier Quotation Item | |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM | |
wip_composite_asset |
Link | Asset |
Purchase Order Item Supplied
Lists raw materials the buyer will supply for a subcontracted Purchase Order, separate from the finished items being ordered.
Naming: child row (hash) · 20 fields · 1 inbound ref · Parent(s): Purchase Order.supplied_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
required_qty |
Float | Required Qty | |
rate |
Currency | Rate | |
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 |
Purchase Receipt Item Supplied
Records the supplied raw materials consumed against a subcontracted receipt, rather than the finished items received.
Naming: child row (hash) · 23 fields · 2 inbound refs · Parent(s): Purchase Invoice.supplied_items, Purchase Receipt.supplied_items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
required_qty |
Float | Available Qty For Consumption | |
consumed_qty |
Float | yes | Qty to Be Consumed |
current_stock |
Float | Current Stock | |
reference_name |
Data | Reference Name | |
bom_detail_no |
Data | BOM Detail No |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
batch_no |
Link | Batch | |
main_item_code |
Link | Item | |
purchase_order |
Link | Purchase Order | |
rm_item_code |
Link | Item | |
stock_uom |
Link | UOM |
Request for Quotation Item
Stores items for a Request for Quotation.
Naming: child row (hash) · 28 fields · 1 inbound ref · Parent(s): Request for Quotation.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | yes | Quantity |
schedule_date |
Date | yes | Required Date |
conversion_factor |
Float | yes | UOM Conversion Factor |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
brand |
Link | Brand | |
item_code |
Link | Item | yes |
item_group |
Link | Item Group | |
material_request |
Link | Material Request | |
project_name |
Link | Project | |
stock_uom |
Link | UOM | yes |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse |
Request for Quotation Supplier
Stores suppliers for a Request for Quotation.
Naming: child row (hash) · 8 fields · 1 inbound ref · Parent(s): Request for Quotation.suppliers
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
send_email |
Check | Send Email | |
email_id |
Data | Email ID |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
contact |
Link | Contact (fw) | |
supplier |
Link | Supplier | yes |
Supplier Quotation Item
Stores items for a Supplier Quotation.
Naming: child row (hash) · 71 fields · 2 inbound refs · Parent(s): Supplier Quotation.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Float | yes | Quantity |
conversion_factor |
Float | yes | UOM Conversion Factor |
rate |
Currency | Rate | |
amount |
Currency | Amount | |
base_rate |
Currency | yes | Rate (Company Currency) |
base_amount |
Currency | yes | Amount (Company Currency) |
expected_delivery_date |
Date | Expected Delivery Date |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
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 | |
project |
Link | Project | |
request_for_quotation |
Link | Request for Quotation | |
sales_order |
Link | Sales Order | |
stock_uom |
Link | UOM | yes |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM |
Supplier Scorecard Scoring Criteria
Stores supplier scorecard scoring criteria shared by Supplier Scorecard Period and Supplier Scorecard.
Naming: child row (hash) · 7 fields · 2 inbound refs · Parent(s): Supplier Scorecard.criteria, Supplier Scorecard Period.criteria
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
score |
Percent | Score | |
weight |
Percent | yes | Criteria Weight |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
criteria_name |
Link | Supplier Scorecard Criteria | yes |
Supplier Scorecard Scoring Standing
Stores scoring standings for a Supplier Scorecard.
Naming: child row (hash) · 15 fields · 1 inbound ref · Parent(s): Supplier Scorecard.standings
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
min_grade |
Percent | Min Grade | |
max_grade |
Percent | Max Grade |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
employee_link |
Link | Employee | |
standing_name |
Link | Supplier Scorecard Standing |
Supplier Scorecard Scoring Variable
Stores variables for a Supplier Scorecard Period.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Supplier Scorecard Period.variables
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
value |
Float | Value |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
variable_label |
Link | Supplier Scorecard Variable | yes |