import win32com.client

conn = win32com.client.Dispatch('ADODB.Connection')
accdb_path = r'c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION\documentacion raul asencio\datos\contasol\0042026.accdb'
conn.Open(f'Provider=Microsoft.ACE.OLEDB.12.0;Data Source={accdb_path};')

rs = win32com.client.Dispatch('ADODB.Recordset')
rs.Open("SELECT TOP 10 * FROM F_APU WHERE TIVAPU = 'S'", conn)
asientos = []
while not rs.EOF:
    asientos.append(rs.Fields('ASIAPU').Value)
    rs.MoveNext()
rs.Close()
print('Asientos con compras (TIVAPU=S):', asientos)

if asientos:
    asi = asientos[0]
    print(f'=== DETALLE ASIENTO COMPRA {asi} ===')
    rs.Open(f'SELECT * FROM F_APU WHERE ASIAPU={asi} ORDER BY ORDAPU', conn)
    while not rs.EOF:
        print('Ord:', rs.Fields('ORDAPU').Value, 'Cta:', rs.Fields('CUEAPU').Value, 'D/H:', rs.Fields('D-HAPU').Value, 'Imp:', rs.Fields('IMEAPU').Value, 'Con:', rs.Fields('CONAPU').Value, 'Doc:', rs.Fields('DOCAPU').Value, 'TIV:', rs.Fields('TIVAPU').Value, 'CIV:', rs.Fields('CIVAPU').Value)
        rs.MoveNext()
    rs.Close()
