• Registered: 12/30/2016
  • Posts: 3

Topic: "trans_no" field in 'stock_moves'

I am working on a custom assembly package and I am trying to figure out where the trans_no comes from in the stock_moves table. I understand that they are related to and come from the types.inc file but I have the number "7" in the field and I do not see that in the types.inc file or system files, basically cannot figure out where it came from. Is there a table somewhere that contains all of the possible trans_no or relationship.

2 Reply by apmuthu (edited by apmuthu 01/01/2017 06:11:18 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Re: "trans_no" field in 'stock_moves'

The "type", "trans_type" fields are the ones that mapped to those in the "types.inc" file. The "trans_no" is the transaction number. Refer the ERD in the Wiki.

apmuthu's Website