How to get the Doctype corresponding table in the database

Gerry Conrado

ERP Developer & Business Process Consultant • ERPNext Specialist • Digital Transformation for SMEs

Philippines • Available on Schedule

I help businesses simplify operations, automate processes, and gain real-time insights using ERPNext.

As a Business Process Consultant specializing in ERPNext, I work with organizations to transform manual and disconnected workflows into integrated digital systems that improve efficiency, transparency, and decision-making.

My consulting approach combines business process analysis, ERP system design, and practical implementation, ensuring that technology supports business goals.

I specialize in helping small and medium-sized organizations implement ERPNext across multiple departments including:

✓ Finance and Accounting

✓ Human Resources and Payroll

✓ Inventory and Supply Chain

✓ CRM and Sales Operations

✓ Workflow Automation

✓ Business Reporting and Analytics

With ERPNext, businesses can:

✓ Automate payroll and HR processes

✓ Improve financial reporting accuracy

✓ Track operations in real time

✓ Reduce manual paperwork

✓ Improve collaboration across departments

I also help companies customize ERPNext for local business requirements, including Philippine payroll compliance and government contributions.

Skills and Expertise

Business Process Consulting ERPNext Implementation Payroll System Implementation ERP System Design Business Process Reengineering Digital Transformation HRIS Implementation Accounting System Setup Frappe Framework MariaDB / SQL Data Migration System Integration Business Analysis Financial Reporting Automation Systems IT Consulting Process Mapping and Optimization System Design Operational Efficiency Business Intelligence and Reporting

What I Can Offer

ERPNext Implementation

Full setup of Finance, HR, Payroll, Inventory, and CRM modules — cloud or on-premises.

Business Process Automation

Transform manual workflows into automated, integrated digital processes.

ERPNext Customization

Custom workflows, reports, and system optimization tailored to your operations.

Payroll System Setup

PH-compliant payroll including SSS, Pag-IBIG, PhilHealth, and tax calculations.

Accounting System

Chart of accounts, financial reporting, and automated bookkeeping setup.

Training & Support

Hourly ERPNext training and technical support to maximize your system's value.

How to get the Doctype corresponding table in the database

1. Go to the doctype you need to see corresponding table

In this example we will use Journal Entry, go to Menu->Customize

Below screen will display after you click the Customized button

Take note of the table name, every master data and transaction data table in the system has the prefix of "tab". The pattern of table name in the system is "tab"+DocType name = `tabJournal Entry`, that's how you get the table name.

Field name is straightforward.

2. To get the child table do the following