Child tables

Assets 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 Assets.

Asset Capitalization Asset Item

Lists existing assets whose value is combined into a new capitalized asset.

Naming: child row (hash) · 15 fields · 1 inbound ref · Parent(s): Asset Capitalization.asset_items

Key fields

Field	Type	Label
`asset_name`	Data	Asset Name
`asset_value`	Currency	Asset Value
`current_asset_value`	Currency	Current Asset Value

Relationships

Field	Type	References	Req
`asset`	Link	Asset	yes
`cost_center`	Link	Cost Center
`finance_book`	Link	Finance Book
`fixed_asset_account`	Link	Account
`item_code`	Link	Item	yes
`project`	Link	Project

Asset Capitalization Service Item

Lists service costs included in an asset’s capitalization without representing stock or an existing asset.

Naming: child row (hash) · 13 fields · 1 inbound ref · Parent(s): Asset Capitalization.service_items

Key fields

Field	Type	Label
`qty`	Float	Qty
`rate`	Currency	Rate
`amount`	Currency	Amount

Relationships

Field	Type	References	Req
`cost_center`	Link	Cost Center
`expense_account`	Link	Account	yes
`item_code`	Link	Item
`uom`	Link	UOM

Asset Capitalization Stock Item

Lists stock items consumed and capitalized into a new asset.

Naming: child row (hash) · 23 fields · 1 inbound ref · Parent(s): Asset Capitalization.stock_items

Key fields

Field	Type	Label
`stock_qty`	Float	Quantity
`valuation_rate`	Currency	Valuation Rate
`amount`	Currency	Amount

Relationships

Field	Type	References	Req
`batch_no`	Link	Batch
`cost_center`	Link	Cost Center
`item_code`	Link	Item	yes
`serial_and_batch_bundle`	Link	Serial and Batch Bundle
`stock_uom`	Link	UOM	yes
`warehouse`	Link	Warehouse	yes

Asset Category Account

Stores accounts for an Asset Category.

Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Asset Category.accounts

Relationships

Field	Type	References	Req
`accumulated_depreciation_account`	Link	Account
`capital_work_in_progress_account`	Link	Account
`company_name`	Link	Company	yes
`depreciation_expense_account`	Link	Account
`fixed_asset_account`	Link	Account	yes

Asset Finance Book

Stores an Asset’s depreciation settings and opening values for one Finance Book.

Naming: child row (hash) · 16 fields · 2 inbound refs · Parent(s): Asset.finance_books, Asset Category.finance_books

Key fields

Field	Type	Req	Label
`depreciation_method`	Select	yes	Depreciation Method
`total_number_of_depreciations`	Int	yes	Total Number of Depreciations
`frequency_of_depreciation`	Int	yes	Frequency of Depreciation (Months)
`depreciation_start_date`	Date		Depreciation Posting Date

Relationships

Field	Type	References	Req
`finance_book`	Link	Finance Book

Asset Maintenance Task

Stores maintenance tasks for an Asset Maintenance.

Naming: child row (hash) · 20 fields · 1 inbound ref · Parent(s): Asset Maintenance.asset_maintenance_tasks

Key fields

Field	Type	Req	Label
`maintenance_task`	Data	yes	Maintenance Task
`maintenance_status`	Select	yes	Maintenance Status
`start_date`	Date	yes	Start Date
`periodicity`	Select	yes	Periodicity
`next_due_date`	Date		Next Due Date
`last_completion_date`	Date		Last Completion Date

Relationships

Field	Type	References	Req
`assign_to`	Link	User (fw)

Asset Movement Item

Stores assets for an Asset Movement.

Naming: child row (hash) · 8 fields · 1 inbound ref · Parent(s): Asset Movement.assets

Relationships

Field	Type	References	Req
`asset`	Link	Asset	yes
`company`	Link	Company
`from_employee`	Link	Employee
`source_location`	Link	Location
`target_location`	Link	Location
`to_employee`	Link	Employee

Asset Repair Consumed Item

Stores stock items for an Asset Repair.

Naming: child row (hash) · 9 fields · 1 inbound ref · Parent(s): Asset Repair.stock_items

Key fields

Field	Type	Label
`valuation_rate`	Currency	Valuation Rate
`consumed_quantity`	Data	Consumed Quantity
`total_value`	Currency	Total Value

Relationships

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

Asset Repair Purchase Invoice

Stores repair purchase invoices for an Asset Repair.

Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Asset Repair.invoices

Key fields

Field	Type	Req	Label
`repair_cost`	Currency	yes	Repair Cost

Relationships

Field	Type	References	Req
`expense_account`	Link	Account	yes
`purchase_invoice`	Link	Purchase Invoice

Depreciation Schedule

Stores one scheduled depreciation posting date and amount for an Asset Depreciation Schedule or shift adjustment.

Naming: child row (hash) · 7 fields · 2 inbound refs · Parent(s): Asset Depreciation Schedule.depreciation_schedule, Asset Shift Allocation.depreciation_schedule

Key fields

Field	Type	Req	Label
`schedule_date`	Date	yes	Schedule Date
`depreciation_amount`	Currency	yes	Depreciation Amount
`accumulated_depreciation_amount`	Currency		Accumulated Depreciation Amount

Relationships

Field	Type	References	Req
`journal_entry`	Link	Journal Entry
`shift`	Link	Asset Shift Factor

Maintenance Team Member

Stores maintenance team members for an Asset Maintenance Team.

Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Asset Maintenance Team.maintenance_team_members

Key fields

Field	Type	Req	Label
`full_name`	Data		Full Name

Relationships

Field	Type	References	Req
`maintenance_role`	Link	Role (fw)	yes
`team_member`	Link	User (fw)	yes