# APInvExp table doesn't have Acct numbers

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-11-14 19:30 UTC
**Views:** 889
**Replies:** 0
**URL:** https://www.epiusers.help/t/apinvexp-table-doesnt-have-acct-numbers/36274

---

## Post #1 by @ckrusen

The APInvExp table in V8 had the GL accounts for the transactions for each invoice line. (ex: APInvExp.GLChart)

But E10's APInvExp does not.  The Data Dictionary for E10's APInvExp only mentions:

`RefType: Link to the related GLRefTyp.RefType. Not displayed.`

and

`RefCode: Link to the related Code in GLRefCod.RefCode`

But a query of the APInvExp table shows those fields always blank.

Any Idea of where I can get the GL Accts (and the related Exp Amounts) from for APInvDtl's and APInvMisc?

---


**Canonical:** https://www.epiusers.help/t/apinvexp-table-doesnt-have-acct-numbers/36274
**Original content:** https://www.epiusers.help/t/apinvexp-table-doesnt-have-acct-numbers/36274