How long does history data get stored in the audit tables?

You set the time frame for data storage when you start or stop the audit.

See Audit Configuration for Business Object Attributes for more information.

For information on which Sales objects you can audit, see What fields can I audit for Sales?.