Skip to main content
Solved

Difference between Stock_bin and Stock_bin_table

  • July 26, 2023
  • 2 replies
  • 65 views

Forum|alt.badge.img+8

Hi Experts , 

What is the difference between Stock_Bin and Stock_bin_table?

Thanks and Regards 

Shobana

Best answer by BrianG

Hi @Shobana ,

STOCK_BIN is actually a database View.  STOCK_BIN_TABLE is the database Table that holds the data.  To the best of my recollection, this was a change done several years back to improve performance and optimize functionality related to stock transactions.  

2 replies

Forum|alt.badge.img+6
  • Hero (Customer)
  • Answer
  • July 27, 2023

Hi @Shobana ,

STOCK_BIN is actually a database View.  STOCK_BIN_TABLE is the database Table that holds the data.  To the best of my recollection, this was a change done several years back to improve performance and optimize functionality related to stock transactions.  


Forum|alt.badge.img+8
  • Author
  • Sidekick (Employee)
  • July 27, 2023

hi @BrianG , 

Thank you so much for this response 

Regards 

Shobana