Child tables
Setup child tables — 11 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.
11 entities in Setup.
Driving License Category
Stores driving license category for a Driver.
Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Driver.driving_license_category
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
class |
Data | Driver licence class | |
description |
Data | Description | |
issuing_date |
Date | Issuing Date | |
expiry_date |
Date | Expiry Date |
Relationships
No outgoing relationships.
Email Digest Recipient
Stores recipients for an Email Digest.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Email Digest.recipients
Relationships
| Field | Type | References | Req |
|---|---|---|---|
recipient |
Link | User (fw) | yes |
Employee Education
Stores education for an Employee.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Employee.education
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
school_univ |
Small Text | School/University | |
qualification |
Data | Qualification | |
level |
Select | Level | |
year_of_passing |
Int | Year of Passing | |
class_per |
Data | Class / Percentage | |
maj_opt_subj |
Text | Major/Optional Subjects |
Relationships
No outgoing relationships.
Employee External Work History
Stores external work history for an Employee.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Employee.external_work_history
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
company_name |
Data | Company | |
designation |
Data | Designation | |
salary |
Currency | Salary | |
address |
Small Text | Address | |
contact |
Data | Contact | |
total_experience |
Data | Total Experience |
Relationships
No outgoing relationships.
Employee Group Table
Stores employee for an Employee Group.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Employee Group.employee_list
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
employee_name |
Data | Employee Name | |
user_id |
Data | ERPNext User ID |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
employee |
Link | Employee |
Employee Internal Work History
Stores internal work history for an Employee.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Employee.internal_work_history
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
from_date |
Date | From Date | |
to_date |
Date | To Date |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
branch |
Link | Branch | |
department |
Link | Department | |
designation |
Link | Designation |
Holiday
Stores holidays for a Holiday List.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Holiday List.holidays
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
holiday_date |
Date | yes | Date |
is_half_day |
Check | Is Half Day |
Relationships
No outgoing relationships.
Quotation Lost Reason Detail
Stores lost reasons for a Quotation.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Quotation.lost_reasons
Relationships
| Field | Type | References | Req |
|---|---|---|---|
lost_reason |
Link | Quotation Lost Reason |
Target Detail
Defines an Item Group target and its monthly distribution for a Sales Partner, Sales Person, or Territory.
Naming: child row (hash) · 5 fields · 3 inbound refs · Parent(s): Sales Partner.targets, Sales Person.targets, Territory.targets
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
target_qty |
Float | Target Qty | |
target_amount |
Float | Target Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
distribution_id |
Link | Monthly Distribution | yes |
fiscal_year |
Link | Fiscal Year | yes |
item_group |
Link | Item Group |
Transaction Deletion Record Item
Stores excluded doctypes for a Transaction Deletion Record.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Transaction Deletion Record.doctypes_to_be_ignored
Relationships
| Field | Type | References | Req |
|---|---|---|---|
doctype_name |
Link | DocType (fw) | yes |
Transaction Deletion Record To Delete
Stores doctypes to delete for a Transaction Deletion Record.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Transaction Deletion Record.doctypes_to_delete
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
company_field |
Data | Company Field | |
document_count |
Int | Document Count | |
child_doctypes |
Small Text | Child DocTypes | |
deleted |
Check | Deleted |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
doctype_name |
Link | DocType (fw) |