# Data Definitions

**URL:** <https://www.epiusers.help/t/data-definitions/63206>\
**Category:** Epicor ERP 10\
**Tags:** table, report-data-definiti\
**Created:** [January 3, 2020, 3:50pm UTC](https://www.epiusers.help/t/data-definitions/63206 "2020-01-03T15:50:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chalmbacher](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/2bfe46/32.png) [@Chalmbacher](https://www.epiusers.help/u/Chalmbacher)\
**Post date:** [January 3, 2020, 3:50pm UTC](https://www.epiusers.help/t/data-definitions/63206/1 "2020-01-03T15:50:28Z")

</div>

I would like to obtain a data definition file for the tables in the Epicor system. I am only looking for several tables at the moment, but would appreciate the most up to date comprehensive listing that is available. The topic which this most closely relates to is the ‘Table Name’ topic within the help menu. See requested tables:  
Table: Erp\_APInvExp  
Table: Erp\_APInvHed  
Table: Erp\_APTran  
Table: Erp\_CashDtl  
Table: Erp\_FiscalPer  
Table: Erp\_GLJrnDtl  
Table: Erp\_Customer  
Table: Erp\_InvcDtl  
Table: Erp\_JobHead  
Table: Erp\_LaborDtl  
Table: Erp\_PartTran  
Table: Erp\_TranGLC  
Table: Erp\_Vendor

---

<div class="post-metadata">

**Author:** ![tsmith](https://www.epiusers.help/user_avatar/www.epiusers.help/tsmith/32/64774_2.png) [@tsmith](https://www.epiusers.help/u/tsmith)\
**Post date:** [January 3, 2020, 3:54pm UTC](https://www.epiusers.help/t/data-definitions/63206/2 "2020-01-03T15:54:43Z")

</div>

Have you looked at the Data Dictionary Viewer under System Maintenance? It gives you a (somewhat) decent listing of all Tables and Fields and their descriptions, formats, etc. It also allows you to print a report with the same information if you want it in a document.

There was a Windows Help File version of this going around here a few months ago, I’ll see if I can track it down.

EDIT: Take a look at these links.

> [@\[Download \] Epicor 10.2 & Kinetic .CHM Schema](https://www.epiusers.help/t/download-epicor-10-2-chm-schema/49603):
>
> We have taken the time to generate a brand new Schema .chm for easier researching, and would like to offer the file to you. It is for educational purposes, not to be sold. It is current as of 10.2.300.2: I find doing research in it I find column details, all tables that contain the column etc… its my #sidekick always open and its extremely convenient and efficient. You can also use \*wildcard. In any page you can use CTRL+F to prompt a search window, and easily find a word in a desc like “Cost” …

[https://www.epiusers.help/t/download-epicor-10-2-300-chm/48944](https://www.epiusers.help/t/download-epicor-10-2-300-chm/48944)

---

<div class="post-metadata">

**Author:** ![Chalmbacher](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/2bfe46/32.png) [@Chalmbacher](https://www.epiusers.help/u/Chalmbacher)\
**Post date:** [January 3, 2020, 4:28pm UTC](https://www.epiusers.help/t/data-definitions/63206/3 "2020-01-03T16:28:22Z")

</div>

Exactly what I was looking for!