Child tables
Accounts child tables — 81 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.
81 entities in Accounts.
Accounting Dimension Detail
Stores dimension defaults for an Accounting Dimension.
Naming: child row (hash) · 8 fields · 1 inbound ref · Parent(s): Accounting Dimension.dimension_defaults
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
mandatory_for_bs |
Check | Mandatory For Balance Sheet | |
mandatory_for_pl |
Check | Mandatory For Profit and Loss Account |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
company |
Link | Company | |
offsetting_account |
Link | Account | |
reference_document |
Link | DocType (fw) | |
default_dimension |
Dynamic Link | resolved via reference_document |
Advance Taxes and Charges
Stores advance taxes and charges for a Payment Entry.
Naming: child row (hash) · 24 fields · 1 inbound ref · Parent(s): Payment Entry.taxes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
charge_type |
Select | yes | Type |
description |
Small Text | yes | Description |
rate |
Float | Tax Rate | |
tax_amount |
Currency | Amount | |
total |
Currency | Total | |
add_deduct_tax |
Select | yes | Add Or Deduct |
net_amount |
Currency | Net Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account_head |
Link | Account | yes |
cost_center |
Link | Cost Center | |
currency |
Link | Currency (fw) | |
project |
Link | Project |
Allowed Dimension
Stores applicable dimension for an Accounting Dimension Filter.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Accounting Dimension Filter.dimensions
Relationships
| Field | Type | References | Req |
|---|---|---|---|
accounting_dimension |
Link | DocType (fw) | |
dimension_value |
Dynamic Link | resolved via accounting_dimension |
Allowed To Transact With
Stores allowed to transact with shared by Supplier and Customer.
Naming: child row (hash) · 1 fields · 2 inbound refs · Parent(s): Customer.companies, Supplier.companies
Relationships
| Field | Type | References | Req |
|---|---|---|---|
company |
Link | Company | yes |
Applicable On Account
Stores applicable on account for an Accounting Dimension Filter.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Accounting Dimension Filter.accounts
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
is_mandatory |
Check | Is Mandatory |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
applicable_on_account |
Link | Account | yes |
Bank Transaction Mapping
Stores bank transaction mapping for a Bank.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Bank.bank_transaction_mapping
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
bank_transaction_field |
Select | yes | Field in Bank Transaction |
file_field |
Data | yes | Column in Bank File |
Relationships
No outgoing relationships.
Bank Transaction Payments
Stores payment entries for a Bank Transaction.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): Bank Transaction.payment_entries
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
allocated_amount |
Currency | yes | Allocated Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
payment_document |
Link | DocType (fw) | yes |
payment_entry |
Dynamic Link | resolved via payment_document |
Bank Transaction Rule Accounts
Stores accounts for a Bank Transaction Rule.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Bank Transaction Rule.accounts
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | yes |
party_type |
Link | Party Type | |
party |
Dynamic Link | resolved via party_type |
Bank Transaction Rule Description Conditions
Stores description rules for a Bank Transaction Rule.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Bank Transaction Rule.description_rules
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
check |
Select | yes | Check |
value |
Small Text | yes | Value |
Relationships
No outgoing relationships.
Budget Distribution
Stores budget distribution for a Budget.
Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Budget.budget_distribution
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
start_date |
Date | yes | Start Date |
end_date |
Date | yes | End Date |
amount |
Currency | yes | Amount |
percent |
Percent | yes | Percent |
Relationships
No outgoing relationships.
Campaign Item
Stores campaign for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.campaign
Relationships
| Field | Type | References | Req |
|---|---|---|---|
campaign |
Link | UTM Campaign (fw) |
Cashier Closing Payments
Stores payments for a Cashier Closing.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Cashier Closing.payments
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
amount |
Float | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | yes |
Closed Document
Stores closed documents for an Accounting Period.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Accounting Period.closed_documents
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
closed |
Check | Closed |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
document_type |
Link | DocType (fw) | yes |
Cost Center Allocation Percentage
Stores cost center allocation percentages for a Cost Center Allocation.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Cost Center Allocation.allocation_percentages
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
percentage |
Percent | yes | Percentage (%) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
cost_center |
Link | Cost Center | yes |
Customer Group Item
Stores customer group for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.customer_group
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer_group |
Link | Customer Group |
Customer Item
Stores customer for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.customer
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer |
Link | Customer |
Discounted Invoice
Stores invoices for an Invoice Discounting.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Invoice Discounting.invoices
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
posting_date |
Date | Date | |
outstanding_amount |
Currency | Outstanding Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer |
Link | Customer | |
debit_to |
Link | Account | |
sales_invoice |
Link | Sales Invoice | yes |
Dunning Letter Text
Stores dunning letter text for a Dunning Type.
Naming: child row (hash) · 7 fields · 1 inbound ref · Parent(s): Dunning Type.dunning_letter_text
Relationships
| Field | Type | References | Req |
|---|---|---|---|
language |
Link | Language (fw) |
Exchange Rate Revaluation Account
Stores exchange rate revaluation account for an Exchange Rate Revaluation.
Naming: child row (hash) · 20 fields · 1 inbound ref · Parent(s): Exchange Rate Revaluation.accounts
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
balance_in_base_currency |
Currency | Balance In Base Currency | |
new_exchange_rate |
Float | yes | New Exchange Rate |
new_balance_in_base_currency |
Currency | New Balance In Base Currency | |
gain_loss |
Currency | Gain/Loss |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | yes |
account_currency |
Link | Currency (fw) | |
party_type |
Link | DocType (fw) | |
party |
Dynamic Link | resolved via party_type |
Financial Report Row
Stores report line items for a Financial Report Template.
Naming: child row (hash) · 21 fields · 1 inbound ref · Parent(s): Financial Report Template.rows
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
reference_code |
Data | Line Reference | |
display_name |
Data | Display Name | |
indentation_level |
Int | Indent Level | |
data_source |
Select | Data Source | |
balance_type |
Select | Balance Type | |
reverse_sign |
Check | Reverse Sign |
Relationships
No outgoing relationships.
Fiscal Year Company
Stores companies for a Fiscal Year.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Fiscal Year.companies
Relationships
| Field | Type | References | Req |
|---|---|---|---|
company |
Link | Company | yes |
Item Tax Template Detail
Stores tax rates for an Item Tax Template.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Item Tax Template.taxes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
tax_rate |
Float | Tax Rate | |
not_applicable |
Check | Not Applicable |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
tax_type |
Link | Account | yes |
Item Wise Tax Detail
Stores item wise tax details shared by Supplier Quotation, Purchase Order, Quotation, Sales Order, Sales Invoice, POS Invoice, Purchase Invoice, Delivery Note, and Purchase Receipt.
Naming: child row (hash) · 5 fields · 9 inbound refs · Parent(s): Delivery Note.item_wise_tax_details, POS Invoice.item_wise_tax_details, Purchase Invoice.item_wise_tax_details, Purchase Order.item_wise_tax_details, Purchase Receipt.item_wise_tax_details, Quotation.item_wise_tax_details +3 more
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_row |
Data | yes | Item Row |
tax_row |
Data | yes | Tax Row |
rate |
Float | Tax Rate | |
amount |
Currency | Tax Amount | |
taxable_amount |
Currency | Taxable Amount |
Relationships
No outgoing relationships.
Journal Entry Account
Stores accounting entries for a Journal Entry.
Naming: child row (hash) · 32 fields · 1 inbound ref · Parent(s): Journal Entry.accounts
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
debit_in_account_currency |
Currency | Debit | |
debit |
Currency | Debit in Company Currency | |
credit_in_account_currency |
Currency | Credit | |
credit |
Currency | Credit in Company Currency |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | yes |
account_currency |
Link | Currency (fw) | |
advance_voucher_type |
Link | DocType (fw) | |
bank_account |
Link | Bank Account | |
cost_center |
Link | Cost Center | |
party_type |
Link | DocType (fw) | |
project |
Link | Project | |
advance_voucher_no |
Dynamic Link | resolved via advance_voucher_type |
|
party |
Dynamic Link | resolved via party_type |
|
reference_name |
Dynamic Link | resolved via reference_type |
Journal Entry Template Account
Stores accounting entries for a Journal Entry Template.
Naming: child row (hash) · 7 fields · 1 inbound ref · Parent(s): Journal Entry Template.accounts
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | yes |
cost_center |
Link | Cost Center | |
party_type |
Link | DocType (fw) | |
project |
Link | Project | |
party |
Dynamic Link | resolved via party_type |
Ledger Merge Accounts
Stores accounts to merge for a Ledger Merge.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Ledger Merge.merge_accounts
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
merged |
Check | Merged | |
account_name |
Data | yes | Account Name |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | yes |
Loyalty Program Collection
Stores collection rules for a Loyalty Program.
Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Loyalty Program.collection_rules
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
tier_name |
Data | yes | Tier Name |
min_spent |
Currency | Minimum Total Spent | |
collection_factor |
Currency | yes | Collection Factor (=1 LP) |
Relationships
No outgoing relationships.
Mode of Payment Account
Stores accounts for a Mode of Payment.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Mode of Payment.accounts
Relationships
Monthly Distribution Percentage
Stores monthly distribution percentages for a Monthly Distribution.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Monthly Distribution.percentages
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
month |
Data | yes | Month |
percentage_allocation |
Float | Percentage Allocation |
Relationships
No outgoing relationships.
Overdue Payment
Stores overdue payments for a Dunning.
Naming: child row (hash) · 18 fields · 1 inbound ref · Parent(s): Dunning.overdue_payments
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
outstanding |
Currency | Outstanding | |
overdue_days |
Data | Overdue Days | |
dunning_level |
Int | Dunning Level | |
interest |
Currency | Interest |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | |
payment_term |
Link | Payment Term | |
sales_invoice |
Link | Sales Invoice | yes |
POS Closing Entry Detail
Stores payment reconciliation for a POS Closing Entry.
Naming: child row (hash) · 5 fields · 1 inbound ref · Parent(s): POS Closing Entry.payment_reconciliation
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
expected_amount |
Currency | Expected Amount | |
difference |
Currency | Difference | |
opening_amount |
Currency | yes | Opening Amount |
closing_amount |
Currency | yes | Closing Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | yes |
POS Closing Entry Taxes
Stores taxes for a POS Closing Entry.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): POS Closing Entry.taxes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
amount |
Currency | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account_head |
Link | Account |
POS Customer Group
Stores customer groups for a POS Profile.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): POS Profile.customer_groups
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer_group |
Link | Customer Group | yes |
POS Invoice Item
Stores items for a POS Invoice.
Naming: child row (hash) · 98 fields · 1 inbound ref · Parent(s): POS Invoice.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | Quantity | |
conversion_factor |
Float | yes | UOM Conversion Factor |
rate |
Currency | yes | Rate |
amount |
Currency | yes | Amount |
base_rate |
Currency | yes | Rate (Company Currency) |
base_amount |
Currency | yes | Amount (Company Currency) |
serial_no |
Text | Serial No |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
asset |
Link | Asset | |
batch_no |
Link | Batch | |
cost_center |
Link | Cost Center | yes |
deferred_revenue_account |
Link | Account | |
delivery_note |
Link | Delivery Note | |
expense_account |
Link | Account | |
finance_book |
Link | Finance Book | |
income_account |
Link | Account | yes |
item_code |
Link | Item | |
item_group |
Link | Item Group | |
item_tax_template |
Link | Item Tax Template | |
project |
Link | Project | |
quality_inspection |
Link | Quality Inspection | |
sales_order |
Link | Sales Order | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | |
target_warehouse |
Link | Warehouse | |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM |
POS Invoice Reference
Stores pos invoice reference shared by POS Invoice Merge Log and POS Closing Entry.
Naming: child row (hash) · 7 fields · 1 inbound ref · Parent(s): POS Closing Entry.pos_invoices
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
posting_date |
Date | yes | Date |
grand_total |
Currency | yes | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer |
Link | Customer | yes |
pos_invoice |
Link | POS Invoice | yes |
return_against |
Link | POS Invoice |
POS Item Group
Stores item groups for a POS Profile.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): POS Profile.item_groups
Relationships
| Field | Type | References | Req |
|---|---|---|---|
item_group |
Link | Item Group | yes |
POS Opening Entry Detail
Stores opening balance details for a POS Opening Entry.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): POS Opening Entry.balance_details
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
opening_amount |
Currency | yes | Opening Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | yes |
POS Payment Method
Stores payment methods for a POS Profile.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): POS Profile.payments
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
default |
Check | Default | |
allow_in_returns |
Check | Allow In Returns |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | yes |
POS Profile User
Stores applicable for users for a POS Profile.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): POS Profile.applicable_for_users
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
default |
Check | Default |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
user |
Link | User (fw) |
PSOA Cost Center
Stores cost center for a Process Statement Of Accounts.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Process Statement Of Accounts.cost_center
Relationships
| Field | Type | References | Req |
|---|---|---|---|
cost_center_name |
Link | Cost Center | yes |
PSOA Project
Stores project for a Process Statement Of Accounts.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Process Statement Of Accounts.project
Relationships
| Field | Type | References | Req |
|---|---|---|---|
project_name |
Link | Project |
Party Account
Stores party account shared by Supplier, Customer, Customer Group, and Supplier Group.
Naming: child row (hash) · 3 fields · 4 inbound refs · Parent(s): Customer.accounts, Customer Group.accounts, Supplier.accounts, Supplier Group.accounts
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | |
advance_account |
Link | Account | |
company |
Link | Company | yes |
Payment Entry Deduction
Stores payment deductions or loss for a Payment Entry.
Naming: child row (hash) · 6 fields · 1 inbound ref · Parent(s): Payment Entry.deductions
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
amount |
Currency | yes | Amount (Company Currency) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | yes |
cost_center |
Link | Cost Center | yes |
Payment Entry Reference
Stores payment references for a Payment Entry.
Naming: child row (hash) · 20 fields · 1 inbound ref · Parent(s): Payment Entry.references
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
due_date |
Date | Due Date | |
total_amount |
Currency | Grand Total | |
outstanding_amount |
Currency | Outstanding | |
allocated_amount |
Currency | Allocated |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | |
advance_voucher_type |
Link | DocType (fw) | |
payment_request |
Link | Payment Request | |
payment_term |
Link | Payment Term | |
reference_doctype |
Link | DocType (fw) | yes |
advance_voucher_no |
Dynamic Link | resolved via advance_voucher_type |
|
reference_name |
Dynamic Link | resolved via reference_doctype |
Payment Order Reference
Stores payment order reference for a Payment Order.
Naming: child row (hash) · 12 fields · 1 inbound ref · Parent(s): Payment Order.references
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
amount |
Currency | yes | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | |
bank_account |
Link | Bank Account | yes |
mode_of_payment |
Link | Mode of Payment | |
payment_request |
Link | Payment Request | |
reference_doctype |
Link | DocType (fw) | yes |
supplier |
Link | Supplier | |
reference_name |
Dynamic Link | resolved via reference_doctype |
Payment Reference
Stores payment reference for a Payment Request.
Naming: child row (hash) · 10 fields · 1 inbound ref · Parent(s): Payment Request.payment_reference
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
description |
Small Text | Description | |
due_date |
Date | Due Date | |
amount |
Currency | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
currency |
Link | Currency (fw) | |
payment_schedule |
Link | Payment Schedule | |
payment_term |
Link | Payment Term |
Payment Schedule
Stores payment schedule shared by Purchase Order, Quotation, Sales Order, Sales Invoice, POS Invoice, and Purchase Invoice.
Naming: child row (hash) · 27 fields · 7 inbound refs · Parent(s): POS Invoice.payment_schedule, Purchase Invoice.payment_schedule, Purchase Order.payment_schedule, Quotation.payment_schedule, Sales Invoice.payment_schedule, Sales Order.payment_schedule
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
description |
Small Text | Description | |
due_date |
Date | yes | Due Date |
invoice_portion |
Percent | Invoice Portion | |
payment_amount |
Currency | yes | Payment Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | |
payment_term |
Link | Payment Term |
Payment Terms Template Detail
Stores payment terms for a Payment Terms Template.
Naming: child row (hash) · 16 fields · 1 inbound ref · Parent(s): Payment Terms Template.terms
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
description |
Small Text | Description | |
invoice_portion |
Float | yes | Invoice Portion (%) |
due_date_based_on |
Select | yes | Due Date Based On |
credit_days |
Int | Credit Days |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
mode_of_payment |
Link | Mode of Payment | |
payment_term |
Link | Payment Term |
Pricing Rule Brand
Stores pricing rule brand shared by Promotional Scheme and Pricing Rule.
Naming: child row (hash) · 2 fields · 2 inbound refs · Parent(s): Pricing Rule.brands, Promotional Scheme.brands
Relationships
Pricing Rule Detail
Stores pricing rule detail shared by Supplier Quotation, Purchase Order, Quotation, Sales Order, Sales Invoice, POS Invoice, Purchase Invoice, Delivery Note, and Purchase Receipt.
Naming: child row (hash) · 6 fields · 9 inbound refs · Parent(s): Delivery Note.pricing_rules, POS Invoice.pricing_rules, Purchase Invoice.pricing_rules, Purchase Order.pricing_rules, Purchase Receipt.pricing_rules, Quotation.pricing_rules +3 more
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_code |
Data | Item Code |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
pricing_rule |
Link | Pricing Rule |
Pricing Rule Item Code
Stores pricing rule item code shared by Promotional Scheme and Pricing Rule.
Naming: child row (hash) · 2 fields · 2 inbound refs · Parent(s): Pricing Rule.items, Promotional Scheme.items
Relationships
Pricing Rule Item Group
Stores pricing rule item group shared by Promotional Scheme and Pricing Rule.
Naming: child row (hash) · 2 fields · 2 inbound refs · Parent(s): Pricing Rule.item_groups, Promotional Scheme.item_groups
Relationships
| Field | Type | References | Req |
|---|---|---|---|
item_group |
Link | Item Group | |
uom |
Link | UOM |
Process Period Closing Voucher Detail
Stores process period closing voucher detail for a Process Period Closing Voucher.
Naming: child row (hash) · 4 fields · 2 inbound refs · Parent(s): Process Period Closing Voucher.normal_balances, Process Period Closing Voucher.z_opening_balances
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
processing_date |
Date | Processing Date | |
status |
Select | Status | |
report_type |
Select | Report Type |
Relationships
No outgoing relationships.
Process Statement Of Accounts CC
Stores cc to for a Process Statement Of Accounts.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Process Statement Of Accounts.cc_to
Relationships
| Field | Type | References | Req |
|---|---|---|---|
cc |
Link | User (fw) |
Process Statement Of Accounts Customer
Stores customers for a Process Statement Of Accounts.
Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Process Statement Of Accounts.customers
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
billing_email |
Data | Billing Email |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer |
Link | Customer | yes |
Promotional Scheme Price Discount
Stores promotional scheme price discount for a Promotional Scheme.
Naming: child row (hash) · 24 fields · 1 inbound ref · Parent(s): Promotional Scheme.price_discount_slabs
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
rule_description |
Small Text | yes | Rule Description |
min_qty |
Float | Min Qty | |
max_qty |
Float | Max Qty | |
min_amount |
Currency | Min Amount | |
max_amount |
Currency | Max Amount | |
rate_or_discount |
Select | Discount Type |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
for_price_list |
Link | Price List | |
warehouse |
Link | Warehouse |
Promotional Scheme Product Discount
Stores promotional scheme product discount for a Promotional Scheme.
Naming: child row (hash) · 26 fields · 1 inbound ref · Parent(s): Promotional Scheme.product_discount_slabs
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
rule_description |
Small Text | yes | Rule Description |
min_qty |
Float | Min Qty | |
max_qty |
Float | Max Qty | |
min_amount |
Currency | Min Amount | |
max_amount |
Currency | Max Amount | |
free_qty |
Float | Qty |
Relationships
Purchase Invoice Advance
Stores advances for a Purchase Invoice.
Naming: child row (hash) · 10 fields · 1 inbound ref · Parent(s): Purchase Invoice.advances
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
remarks |
Text | Remarks | |
advance_amount |
Currency | Advance Amount | |
allocated_amount |
Currency | Allocated Amount | |
difference_posting_date |
Date | Difference Posting Date |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
reference_type |
Link | DocType (fw) | |
reference_name |
Dynamic Link | resolved via reference_type |
Purchase Invoice Item
Stores items for a Purchase Invoice.
Naming: child row (hash) · 115 fields · 1 inbound ref · Parent(s): Purchase Invoice.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | yes | Accepted Qty |
conversion_factor |
Float | yes | UOM Conversion Factor |
stock_qty |
Float | yes | Accepted Qty in Stock UOM |
rate |
Currency | yes | Rate |
amount |
Currency | yes | Amount |
base_rate |
Currency | yes | Rate (Company Currency) |
base_amount |
Currency | yes | Amount (Company Currency) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
asset_category |
Link | Asset Category | |
asset_location |
Link | Location | |
batch_no |
Link | Batch | |
bom |
Link | BOM | |
brand |
Link | Brand | |
cost_center |
Link | Cost Center | |
deferred_expense_account |
Link | Account | |
expense_account |
Link | Account | |
from_warehouse |
Link | Warehouse | |
item_code |
Link | Item | |
item_group |
Link | Item Group | |
item_tax_template |
Link | Item Tax Template | |
manufacturer |
Link | Manufacturer | |
material_request |
Link | Material Request | |
product_bundle |
Link | Product Bundle | |
project |
Link | Project | |
purchase_order |
Link | Purchase Order | |
purchase_receipt |
Link | Purchase Receipt | |
quality_inspection |
Link | Quality Inspection | |
rejected_serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
rejected_warehouse |
Link | Warehouse | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | |
tax_withholding_category |
Link | Tax Withholding Category | |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM | |
wip_composite_asset |
Link | Asset |
Purchase Taxes and Charges
Stores purchase taxes and charges shared by Supplier Quotation, Purchase Order, Purchase Invoice, Purchase Taxes and Charges Template, and Purchase Receipt.
Naming: child row (hash) · 32 fields · 5 inbound refs · Parent(s): Purchase Invoice.taxes, Purchase Order.taxes, Purchase Receipt.taxes, Purchase Taxes and Charges Template.taxes, Supplier Quotation.taxes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
category |
Select | yes | Consider Tax or Charge for |
add_deduct_tax |
Select | yes | Add or Deduct |
charge_type |
Select | yes | Type |
description |
Small Text | yes | Description |
rate |
Float | Tax Rate | |
tax_amount |
Currency | Amount | |
total |
Currency | Total | |
net_amount |
Currency | Net Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account_currency |
Link | Currency (fw) | |
account_head |
Link | Account | yes |
cost_center |
Link | Cost Center | |
project |
Link | Project |
Repost Accounting Ledger Items
Stores vouchers for a Repost Accounting Ledger.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Repost Accounting Ledger.vouchers
Relationships
| Field | Type | References | Req |
|---|---|---|---|
voucher_type |
Link | DocType (fw) | |
voucher_no |
Dynamic Link | resolved via voucher_type |
Repost Payment Ledger Items
Stores selected vouchers for a Repost Payment Ledger.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Repost Payment Ledger.repost_vouchers
Relationships
| Field | Type | References | Req |
|---|---|---|---|
voucher_type |
Link | DocType (fw) | |
voucher_no |
Dynamic Link | resolved via voucher_type |
Sales Invoice Advance
Stores advances shared by Sales Invoice and POS Invoice.
Naming: child row (hash) · 10 fields · 2 inbound refs · Parent(s): POS Invoice.advances, Sales Invoice.advances
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
remarks |
Text | Remarks | |
advance_amount |
Currency | Advance amount | |
allocated_amount |
Currency | Allocated amount | |
difference_posting_date |
Date | Difference Posting Date |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
reference_type |
Link | DocType (fw) | |
reference_name |
Dynamic Link | resolved via reference_type |
Sales Invoice Item
Stores items for a Sales Invoice.
Naming: child row (hash) · 117 fields · 1 inbound ref · Parent(s): Sales Invoice.items
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
item_name |
Data | yes | Item Name |
qty |
Float | Quantity | |
conversion_factor |
Float | yes | UOM Conversion Factor |
rate |
Currency | yes | Rate |
amount |
Currency | yes | Amount |
base_rate |
Currency | yes | Rate (Company Currency) |
base_amount |
Currency | yes | Amount (Company Currency) |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
against_pick_list |
Link | Pick List | |
asset |
Link | Asset | |
batch_no |
Link | Batch | |
cost_center |
Link | Cost Center | yes |
deferred_revenue_account |
Link | Account | |
delivery_note |
Link | Delivery Note | |
discount_account |
Link | Account | |
expense_account |
Link | Account | |
finance_book |
Link | Finance Book | |
income_account |
Link | Account | yes |
item_code |
Link | Item | |
item_group |
Link | Item Group | |
item_tax_template |
Link | Item Tax Template | |
pos_invoice |
Link | POS Invoice | |
project |
Link | Project | |
purchase_order |
Link | Purchase Order | |
quality_inspection |
Link | Quality Inspection | |
sales_order |
Link | Sales Order | |
serial_and_batch_bundle |
Link | Serial and Batch Bundle | |
stock_uom |
Link | UOM | |
target_warehouse |
Link | Warehouse | |
tax_withholding_category |
Link | Tax Withholding Category | |
uom |
Link | UOM | yes |
warehouse |
Link | Warehouse | |
weight_uom |
Link | UOM |
Sales Invoice Payment
Stores sales invoice payment shared by Sales Invoice and POS Invoice.
Naming: child row (hash) · 9 fields · 2 inbound refs · Parent(s): POS Invoice.payments, Sales Invoice.payments
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
amount |
Currency | yes | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account |
Link | Account | |
mode_of_payment |
Link | Mode of Payment | yes |
Sales Invoice Reference
Stores sales invoice transactions for a POS Closing Entry.
Naming: child row (hash) · 7 fields · 1 inbound ref · Parent(s): POS Closing Entry.sales_invoices
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
posting_date |
Date | yes | Date |
grand_total |
Currency | yes | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
customer |
Link | Customer | yes |
return_against |
Link | Sales Invoice | |
sales_invoice |
Link | Sales Invoice | yes |
Sales Invoice Timesheet
Stores time sheets shared by Sales Invoice and POS Invoice.
Naming: child row (hash) · 15 fields · 2 inbound refs · Parent(s): POS Invoice.timesheets, Sales Invoice.timesheets
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
billing_hours |
Float | Billing Hours | |
billing_amount |
Currency | Billing Amount | |
description |
Small Text | Description |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
activity_type |
Link | Activity Type | |
time_sheet |
Link | Timesheet |
Sales Partner Item
Stores sales partner for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.sales_partner
Relationships
| Field | Type | References | Req |
|---|---|---|---|
sales_partner |
Link | Sales Partner |
Sales Taxes and Charges
Stores sales taxes and charges shared by Quotation, Sales Order, Sales Taxes and Charges Template, Sales Invoice, POS Invoice, and Delivery Note.
Naming: child row (hash) · 27 fields · 6 inbound refs · Parent(s): Delivery Note.taxes, POS Invoice.taxes, Quotation.taxes, Sales Invoice.taxes, Sales Order.taxes, Sales Taxes and Charges Template.taxes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
charge_type |
Select | yes | Type |
description |
Small Text | yes | Description |
rate |
Float | Tax Rate | |
tax_amount |
Currency | Amount | |
total |
Currency | Total | |
net_amount |
Currency | Net Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account_currency |
Link | Currency (fw) | |
account_head |
Link | Account | yes |
cost_center |
Link | Cost Center | |
project |
Link | Project |
Share Balance
Stores share balance for a Shareholder.
Naming: child row (hash) · 10 fields · 1 inbound ref · Parent(s): Shareholder.share_balance
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
from_no |
Int | yes | From No |
rate |
Currency | yes | Rate |
no_of_shares |
Int | yes | No of Shares |
to_no |
Int | yes | To No |
amount |
Currency | yes | Amount |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
share_type |
Link | Share Type | yes |
Shipping Rule Condition
Stores shipping rule conditions for a Shipping Rule.
Naming: child row (hash) · 3 fields · 1 inbound ref · Parent(s): Shipping Rule.conditions
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
from_value |
Float | yes | From Value |
to_value |
Float | To Value | |
shipping_amount |
Currency | yes | Shipping Amount |
Relationships
No outgoing relationships.
Shipping Rule Country
Stores valid for countries for a Shipping Rule.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Shipping Rule.countries
Relationships
| Field | Type | References | Req |
|---|---|---|---|
country |
Link | Country (fw) | yes |
Subscription Plan Detail
Stores subscription plan detail shared by Payment Request and Subscription.
Naming: child row (hash) · 2 fields · 2 inbound refs · Parent(s): Payment Request.subscription_plans, Subscription.plans
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
qty |
Int | yes | Quantity |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
plan |
Link | Subscription Plan | yes |
Supplier Group Item
Stores supplier group for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.supplier_group
Relationships
| Field | Type | References | Req |
|---|---|---|---|
supplier_group |
Link | Supplier Group |
Supplier Item
Stores supplier for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.supplier
Relationships
| Field | Type | References | Req |
|---|---|---|---|
supplier |
Link | Supplier |
Tax Withholding Account
Stores accounts for a Tax Withholding Category.
Naming: child row (hash) · 2 fields · 1 inbound ref · Parent(s): Tax Withholding Category.accounts
Relationships
Tax Withholding Entry
Stores tax withholding entries shared by Sales Invoice, Purchase Invoice, Journal Entry, and Payment Entry.
Naming: child row (hash) · 29 fields · 4 inbound refs · Parent(s): Journal Entry.tax_withholding_entries, Payment Entry.tax_withholding_entries, Purchase Invoice.tax_withholding_entries, Sales Invoice.tax_withholding_entries
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
tax_rate |
Percent | Tax Rate | |
taxable_amount |
Currency | Base Taxable Amount | |
status |
Select | Status | |
withholding_amount |
Currency | Base Tax Withheld |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
company |
Link | Company | |
currency |
Link | Currency (fw) | |
lower_deduction_certificate |
Link | Lower Deduction Certificate | |
party_type |
Link | DocType (fw) | |
tax_withholding_category |
Link | Tax Withholding Category | |
tax_withholding_group |
Link | Tax Withholding Group | |
taxable_doctype |
Link | DocType (fw) | |
withholding_doctype |
Link | DocType (fw) | |
party |
Dynamic Link | resolved via party_type |
|
taxable_name |
Dynamic Link | resolved via taxable_doctype |
|
withholding_name |
Dynamic Link | resolved via withholding_doctype |
Tax Withholding Rate
Stores rates for a Tax Withholding Category.
Naming: child row (hash) · 7 fields · 1 inbound ref · Parent(s): Tax Withholding Category.rates
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
tax_withholding_rate |
Float | yes | Tax Withholding Rate |
single_threshold |
Float | Transaction Threshold | |
cumulative_threshold |
Float | Cumulative Threshold | |
from_date |
Date | yes | From Date |
to_date |
Date | yes | To Date |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
tax_withholding_group |
Link | Tax Withholding Group |
Territory Item
Stores territory for a Promotional Scheme.
Naming: child row (hash) · 1 fields · 1 inbound ref · Parent(s): Promotional Scheme.territory
Relationships
| Field | Type | References | Req |
|---|---|---|---|
territory |
Link | Territory |
Transaction Deletion Record Details
Stores summary for a Transaction Deletion Record.
Naming: child row (hash) · 4 fields · 1 inbound ref · Parent(s): Transaction Deletion Record.doctypes
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
no_of_docs |
Int | No of Docs | |
done |
Check | Done |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
doctype_name |
Link | DocType (fw) | yes |
Unreconcile Payment Entries
Stores allocations for an Unreconcile Payment.
Naming: child row (hash) · 8 fields · 1 inbound ref · Parent(s): Unreconcile Payment.allocations
Key fields
| Field | Type | Req | Label |
|---|---|---|---|
allocated_amount |
Currency | Allocated Amount | |
unlinked |
Check | Unlinked |
Relationships
| Field | Type | References | Req |
|---|---|---|---|
account_currency |
Link | Currency (fw) | |
reference_doctype |
Link | DocType (fw) | |
reference_name |
Dynamic Link | resolved via reference_doctype |