Hi,Does anyone know in which table I can find the "Tansaction Type" field (I am using PowerBI)? I have tried the Sales Invoice header, sales invoice Line table and could not find it. In the system it appears in the Customer transaction page.Thanks
It's field CustTrans.TransType. As far as I can see (by looking at the cross references) this field is not shown in any data entity.
Hi Nour,
The field is typically passed as part of transaction. However if you are trying to figure out what value corresponds to what text on the form, you need to check in visual studio for the enum value.
All Transaction type fields used Enum "LedgerTransType".
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,922
André Arnaud de Cal... 835 Super User 2025 Season 2