If restore from backup option is no aviable,
the information on BISTAX is on the BKARHINV table.
 
So the data on bistax can be populate, update or inserted from the bkarhinv table.
 
select * from BKISTAX where bkis_tax_invno = 123456789
 
select * from "BKARHINV" where bkar_inv_num = 123456789
 
 

 
Kelloggs
 
PD: the table duplicate itself??? how big is the table?? because if it reaches the limit pervasive will create BKISTAX.000, BKISTAX.001

Thanks for the info Kelloggs,
 
I'm not up on the SQL  
 
I have emailed and called for help for the last three days and we have not received a response back.
 
I was hoping there was a DBA program we could run in UT-A that would replace the missing tax or is there a way to us UT-K-B?
 
Luckily we only need the tax info from August 1st. to the 19th.  We can get that info from Inv. listing in SO-H and just make manual entries and move on.  We just wont have a complete sales tax report in AR-K or AR-L for August.
 
Thanks again for your help.