Where Is Avs Order Data Stored

any idea what table and field stores the AVS match or fail data?

Check serialised array in the cscart_order_data table with the P type

It also depends on the payment method and whether it captures it or not.