In Inspection Processing Entry, where is the Tran Type stored in database?

Epicor ERP 10
1

Hello,

Trying to create a BAQ That can filter by TranType (PO Receipts) that returns parts that are in Bin IMQA.

For the life of me, I can’t find where the tran type is stored to filter by.

You can see the column in the Inspection Processing Entry search.

image
image.png962×484 47.8 KB

Anybody have any ideas?

Any help is appreciated.

Thanks,

Shawn

2

Hi Shawn, Trantype is only stored in the PartTran table. You can look for transactions that ends in INS. For Receipts you can check PUR-INS for raw material. and I believe there is another one called SUB-INS.

3

That is helpful! Thanks.

Do you know where it stored the names for the Tran types? Figured I could make a list if I could find that.

Thanks,

Shawn

4

Yeah I did the same, you can go to Help, then Appliation help and in the search bar type: Transaction Types and you will get your list.