Child tables
Maintenance child tables — 3 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.
3 entities in Maintenance.
Maintenance Schedule Detail
Stores the individual planned service visits generated for items on a Maintenance Schedule.
Naming: child row (hash) · 12 fields · 2 inbound refs · Parent(s): Maintenance Schedule.schedules
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
scheduled_date |
Date | yes | Scheduled Date |
actual_date |
Date | Actual Date | |
serial_no |
Small Text | Serial No | |
completion_status |
Select | Completion Status |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
item_code |
Link | Item | |
item_reference |
Link | Maintenance Schedule Item | |
sales_person |
Link | Sales Person |
Maintenance Schedule Item
Lists the customer items covered by a Maintenance Schedule; schedule-detail rows hold the individual planned visits for those items.
Naming: child row (hash) · 16 fields · 2 inbound refs · Parent(s): Maintenance Schedule.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | Item Name | |
start_date |
Date | yes | Start Date |
end_date |
Date | yes | End Date |
periodicity |
Select | Periodicity | |
no_of_visits |
Int | yes | No of Visits |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
item_code |
Link | Item | yes |
sales_order |
Link | Sales Order | |
sales_person |
Link | Sales Person | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle |
Maintenance Visit Purpose
Records the Item, work performed, completion status, and service notes for one purpose of a Maintenance Visit.
Naming: child row (hash) · 12 fields · 1 inbound ref · Parent(s): Maintenance Visit.purposes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | Item Name | |
work_done |
Small Text | yes | Work Done |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
item_code |
Link | Item | |
prevdoc_doctype |
Link | DocType (fw) | |
serial_no |
Link | Serial No | |
service_person |
Link | Sales Person | yes |
prevdoc_docname |
Dynamic Link | resolved via prevdoc_doctype |