== Columnas PROVEEDORES == CODPROVEEDOR CODCONTABLE NOMPROVEEDOR NOMCOMERCIAL CIF NIF20 ALIAS DIRECCION1 CODPOSTAL POBLACION PROVINCIA PAIS PERSONACONTACTO TELEFONO1 TELEFONO2 FAX FAXPEDIDOS TELEX E_MAIL CODCLISUYO NUMCUENTA CODBANCO NUMSUCURSAL DIGCONTROLBANCO CODPOSTALBANCO NOMBREBANCO DIRECCIONBANCO POBLACIONBANCO CODSWIFT ENVIOPOR ENVIODIRECION ENVIOCODPOSTAL ENVIOPOBLACION ENVIOPROVINCIA ENVIOPAIS CANTPORTESPAG TIPOPORTES NUMDIASENTREGA OBSERVACIONES CODTALLA COMPRARSINIMPUESTOS COMPRARIVAINCLUIDO APTOCORREOS DTOCOMERCIAL TIPO REGIMFACT CODMONEDA DIAPAGO1 DIAPAGO2 FECHAMODIFICADO DIRECCION2 TRANSPORTE CODIDIOMA TIPODOC SERIEALBINDIRECTA SERIEFACINDIRECTA B2B_ORIGEN B2B_IDMAPPING CODCENTRAL CODVISIBLE VENCIMSEGUN CODPAIS ENVIOCODPAIS B2B_ORIGENPEDIDO B2B_IDMAPPINGPEDIDO CODCENTRALPEDIDO NUMDIASCANCELACION PEDIDOMINIMO FACTURARCONIMPUESTO CODCONTABLECOMPRA DESCATALOGADO CODIGOIBAN CODCONTABLEDMN PEDIDOSVENCIMSEGUN MOBIL ESPROVDELGRUPO REGIMRET TIPORET RET_TIPORETENCIONIVA RET_PORCEXCLUSION RET_FECHAINIEXCLUSION RET_FECHAFINEXCLUSION IVANODEDUCIBLE RECC BLOQUEADO ORDENADEUDO VERSION TIPODOCIDENT CODEMPRESACONTABLE PERSONAJURIDICA CUOTAIVADEDUCIBLE PORCCUOTAIVADEDUCIBLE REGIMRETICA NOACOGIDOROI SERIE ALMACEN == Series de compra 2025-2026 y su ultimo numero == {"NUMSERIE":"001F","N":"B","ULT_NUM":"99925","N_ALB":"9757","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"001G","N":"B","ULT_NUM":"117","N_ALB":"1","ULT_FECHA":"2026-02-26 00:00:00.000"} {"NUMSERIE":"001X","N":"B","ULT_NUM":"6388","N_ALB":"796","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"004F","N":"B","ULT_NUM":"383","N_ALB":"32","ULT_FECHA":"2026-02-04 00:00:00.000"} {"NUMSERIE":"004X","N":"B","ULT_NUM":"61","N_ALB":"4","ULT_FECHA":"2026-04-01 00:00:00.000"} {"NUMSERIE":"009G","N":"B","ULT_NUM":"9022","N_ALB":"521","ULT_FECHA":"2026-11-17 00:00:00.000"} {"NUMSERIE":"009X","N":"B","ULT_NUM":"136","N_ALB":"6","ULT_FECHA":"2026-02-28 00:00:00.000"} {"NUMSERIE":"60CF","N":"B","ULT_NUM":"371","N_ALB":"139","ULT_FECHA":"2026-10-26 00:00:00.000"} {"NUMSERIE":"60CG","N":"B","ULT_NUM":"1141","N_ALB":"211","ULT_FECHA":"2026-10-24 00:00:00.000"} {"NUMSERIE":"60CX","N":"B","ULT_NUM":"65","N_ALB":"19","ULT_FECHA":"2026-05-27 00:00:00.000"} {"NUMSERIE":"61CF","N":"B","ULT_NUM":"12121","N_ALB":"803","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"61CG","N":"B","ULT_NUM":"400","N_ALB":"43","ULT_FECHA":"2026-11-09 00:00:00.000"} {"NUMSERIE":"61CX","N":"B","ULT_NUM":"1107","N_ALB":"63","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"62CF","N":"B","ULT_NUM":"5430","N_ALB":"2","ULT_FECHA":"2025-11-28 00:00:00.000"} {"NUMSERIE":"62CX","N":"B","ULT_NUM":"860","N_ALB":"3","ULT_FECHA":"2025-11-28 00:00:00.000"} {"NUMSERIE":"63CF","N":"B","ULT_NUM":"6821","N_ALB":"761","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"63CG","N":"B","ULT_NUM":"309","N_ALB":"63","ULT_FECHA":"2026-11-09 00:00:00.000"} {"NUMSERIE":"63CX","N":"B","ULT_NUM":"822","N_ALB":"36","ULT_FECHA":"2026-11-12 00:00:00.000"} {"NUMSERIE":"65CF","N":"B","ULT_NUM":"13969","N_ALB":"895","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"65CG","N":"B","ULT_NUM":"427","N_ALB":"55","ULT_FECHA":"2026-11-01 00:00:00.000"} {"NUMSERIE":"65CX","N":"B","ULT_NUM":"1929","N_ALB":"73","ULT_FECHA":"2026-11-19 00:00:00.000"} {"NUMSERIE":"66CF","N":"B","ULT_NUM":"12942","N_ALB":"888","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"66CG","N":"B","ULT_NUM":"631","N_ALB":"75","ULT_FECHA":"2026-11-04 00:00:00.000"} {"NUMSERIE":"66CX","N":"B","ULT_NUM":"1433","N_ALB":"34","ULT_FECHA":"2026-11-12 00:00:00.000"} {"NUMSERIE":"67CF","N":"B","ULT_NUM":"12873","N_ALB":"735","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"67CG","N":"B","ULT_NUM":"603","N_ALB":"79","ULT_FECHA":"2026-11-09 00:00:00.000"} {"NUMSERIE":"67CX","N":"B","ULT_NUM":"1100","N_ALB":"65","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"68CF","N":"B","ULT_NUM":"12195","N_ALB":"772","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"68CG","N":"B","ULT_NUM":"509","N_ALB":"68","ULT_FECHA":"2026-11-01 00:00:00.000"} {"NUMSERIE":"68CX","N":"B","ULT_NUM":"1460","N_ALB":"56","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"69CF","N":"B","ULT_NUM":"9903","N_ALB":"860","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"69CG","N":"B","ULT_NUM":"414","N_ALB":"55","ULT_FECHA":"2026-11-01 00:00:00.000"} {"NUMSERIE":"69CX","N":"B","ULT_NUM":"1140","N_ALB":"61","ULT_FECHA":"2026-11-10 00:00:00.000"} {"NUMSERIE":"6ACF","N":"B","ULT_NUM":"14361","N_ALB":"849","ULT_FECHA":"2026-11-20 00:00:00.000"} {"NUMSERIE":"6ACG","N":"B","ULT_NUM":"452","N_ALB":"52","ULT_FECHA":"2026-11-09 00:00:00.000"} {"NUMSERIE":"6ACX","N":"B","ULT_NUM":"1302","N_ALB":"53","ULT_FECHA":"2026-11-12 00:00:00.000"} {"NUMSERIE":"6CCG","N":"B","ULT_NUM":"140","N_ALB":"7","ULT_FECHA":"2025-08-01 00:00:00.000"} {"NUMSERIE":"6DCF","N":"B","ULT_NUM":"2512","N_ALB":"1","ULT_FECHA":"2026-06-03 00:00:00.000"} {"NUMSERIE":"6ECG","N":"B","ULT_NUM":"194","N_ALB":"7","ULT_FECHA":"2025-08-01 00:00:00.000"} {"NUMSERIE":"6FCG","N":"B","ULT_NUM":"101","N_ALB":"24","ULT_FECHA":"2026-11-01 00:00:00.000"} {"NUMSERIE":"6GCG","N":"B","ULT_NUM":"317","N_ALB":"76","ULT_FECHA":"2026-11-01 00:00:00.000"} {"NUMSERIE":"6HCG","N":"B","ULT_NUM":"260","N_ALB":"86","ULT_FECHA":"2026-07-08 00:00:00.000"} == Impuestos == == Columnas ALBCOMPRATOT == SERIE nvarchar NUMERO int N nchar NUMLINEA int BRUTO float DTOCOMERC float TOTDTOCOMERC float DTOPP float TOTDTOPP float BASEIMPONIBLE float IVA float TOTIVA float REQ float TOTREQ float TOTAL float ESGASTO nchar CODDTO int DESCRIPCION nvarchar TIPOIVA int == Un albaran de 2026 con sus totales == {"NUMSERIE":"6ACF","NUMALBARAN":"14361","N":"B","SUALBARAN":"003F-26008003","CODPROVEEDOR":"999","FECHAALBARAN":"2026-11-20 00:00:00.000","TOTALBRUTO":"4.6200000000000001","TOTALIMPUESTOS":"0.17999999999999999","TOTALNETO":"4.7999999999999998","TIPODOC":"6","TIPODOCFAC":"6","IDESTADO":"-1","IVAINCLUIDO":"T","CODMONEDA":"1","FACTORMONEDA":"1.0","FECHACREACION":"2026-11-21 06:02:36.000"} TOT {"SERIE":"6ACF","NUMERO":"14361","N":"B","NUMLINEA":"1","BRUTO":"4.6200000000000001","DTOCOMERC":"0.0","TOTDTOCOMERC":"-0.0","DTOPP":"0.0","TOTDTOPP":"-0.0","BASEIMPONIBLE":"4.6200000000000001","IVA":"4.0","TOTIVA":"0.17999999999999999","REQ":"0.0","TOTREQ":"0.0","TOTAL":"4.7999999999999998","ESGASTO":"F","CODDTO":"-1","DESCRIPCION":"","TIPOIVA":"3"} LIN {"NUMLIN":"1","CODARTICULO":"129164","REFERENCIA":"000482","UNID1":"1.0","UNID2":"8.0","UNIDADESTOTAL":"8.0","PRECIO":"0.57692307692307698","TOTAL":"4.6200000000000001","TIPOIMPUESTO":"3","IVA":"4.0","CODALMACEN":"10"} == Espinaler (solo por nombre) ==