===== B1 DOUBLONS DE REF FACTURE CLIENT ===== ===== B2 DOUBLONS DE REF FACTURE FOURNISSEUR (ref interne) ===== ===== B3 DOUBLONS ref_supplier POUR UN MEME FOURNISSEUR (= facture saisie deux fois) ===== ===== B3bis MEME FOURNISSEUR + MEME MONTANT + MEME DATE (doublon probable meme sans ref) ===== soc=353 [MULTILAQUE] date=2026-02-26 ttc=894.42000000 n=2 rowids=301,302 refs=SI2602-0150,SI2602-0151 refsup=02/08,02/09 ===== B4 SEQUENCE DES REFS FACTURES CLIENTS ===== REF NON PARSABLE: rowid=378 ref=(PROV378) REF NON PARSABLE: rowid=379 ref=(PROV379) PREFIXE 'FA2507-' : 20 pieces, de 0001 a 0020 aucun trou PREFIXE 'FA2508-' : 2 pieces, de 0021 a 0022 ATTENTION la sequence ne demarre pas a 0001 (premier = 0021) aucun trou PREFIXE 'FA2509-' : 25 pieces, de 0023 a 0047 ATTENTION la sequence ne demarre pas a 0001 (premier = 0023) aucun trou PREFIXE 'FA2510-' : 22 pieces, de 0048 a 0069 ATTENTION la sequence ne demarre pas a 0001 (premier = 0048) aucun trou PREFIXE 'FA2511-' : 8 pieces, de 0070 a 0077 ATTENTION la sequence ne demarre pas a 0001 (premier = 0070) aucun trou PREFIXE 'FA2512-' : 38 pieces, de 0078 a 0115 ATTENTION la sequence ne demarre pas a 0001 (premier = 0078) aucun trou PREFIXE 'FA2601-' : 12 pieces, de 0116 a 0127 ATTENTION la sequence ne demarre pas a 0001 (premier = 0116) aucun trou PREFIXE 'FA2602-' : 16 pieces, de 0128 a 0143 ATTENTION la sequence ne demarre pas a 0001 (premier = 0128) aucun trou PREFIXE 'FA2603-' : 23 pieces, de 0144 a 0166 ATTENTION la sequence ne demarre pas a 0001 (premier = 0144) aucun trou PREFIXE 'FA2604-' : 43 pieces, de 0167 a 0209 ATTENTION la sequence ne demarre pas a 0001 (premier = 0167) aucun trou PREFIXE 'FA2605-' : 32 pieces, de 0210 a 0343 ATTENTION la sequence ne demarre pas a 0001 (premier = 0210) TROUS (102): 0234,0235,0236,0237,0238,0239,0240,0241,0242,0243,0244,0245,0246,0247,0248,0249,0250,0251,0252,0253,0254,0255,0256,0257,0258,0259,0260,0261,0262,0263,0264,0265,0266,0267,0268,0269,0270,0271,0272,0273,0274,0275,0276,0277,0278,0279,0280,0281,0282,0283,0284,0285,0286,0287,0288,0289,0290,0291,0292,0293,0294,0295,0296,0297,0298,0299,0300,0301,0302,0303,0304,0305,0306,0307,0308,0309,0310,0311,0312,0313,0314,0315,0316,0317,0318,0319,0320,0321,0322,0323,0324,0325,0326,0327,0328,0329,0330,0331,0336,0337,0338,0342 PREFIXE 'FA2606-' : 28 pieces, de 0234 a 0342 ATTENTION la sequence ne demarre pas a 0001 (premier = 0234) TROUS (81): 0259,0260,0261,0262,0263,0264,0265,0266,0267,0268,0269,0270,0271,0272,0273,0274,0275,0276,0277,0278,0279,0280,0281,0282,0283,0284,0285,0286,0287,0288,0289,0290,0291,0292,0293,0294,0295,0296,0297,0298,0299,0300,0301,0302,0303,0304,0305,0306,0307,0308,0309,0310,0311,0312,0313,0314,0315,0316,0317,0318,0319,0320,0321,0322,0323,0324,0325,0326,0327,0328,0329,0330,0331,0332,0333,0334,0335,0338,0339,0340,0341 PREFIXE 'FA2607-' : 42 pieces, de 0259 a 0384 ATTENTION la sequence ne demarre pas a 0001 (premier = 0259) TROUS (84): 0299,0300,0301,0302,0303,0304,0305,0306,0307,0308,0309,0310,0311,0312,0313,0314,0315,0316,0317,0318,0319,0320,0321,0322,0323,0324,0325,0326,0327,0328,0329,0330,0331,0332,0333,0334,0335,0336,0337,0339,0340,0341,0342,0343,0344,0345,0346,0347,0348,0349,0350,0351,0352,0353,0354,0355,0356,0357,0358,0359,0360,0361,0362,0363,0364,0365,0366,0367,0368,0369,0370,0371,0372,0373,0374,0375,0376,0377,0378,0379,0380,0381,0382,0383 PREFIXE 'FA2608-' : 44 pieces, de 0299 a 0385 ATTENTION la sequence ne demarre pas a 0001 (premier = 0299) TROUS (43): 0332,0333,0334,0335,0336,0337,0338,0339,0340,0341,0342,0343,0354,0355,0356,0357,0358,0359,0360,0361,0362,0363,0364,0365,0366,0367,0368,0369,0370,0371,0372,0373,0374,0375,0376,0377,0378,0379,0380,0381,0382,0383,0384 PREFIXE 'FA2609-' : 26 pieces, de 0354 a 0379 ATTENTION la sequence ne demarre pas a 0001 (premier = 0354) aucun trou PREFIXE 'FA2610-' : 9 pieces, de 0380 a 0390 ATTENTION la sequence ne demarre pas a 0001 (premier = 0380) TROUS (2): 0384,0385 ===== B5 SEQUENCE DES REFS FACTURES FOURNISSEURS ===== PREFIXE 'SI2601-' : 14 pieces, de 0034 a 0200 ATTENTION la sequence ne demarre pas a 0001 (premier = 0034) TROUS (153): 0038,0039,0043,0044,0045,0046,0047,0048,0049,0050,0051,0052,0053,0054,0055,0057,0058,0059,0060,0061,0062,0063,0064,0065,0066,0067,0068,0069,0070,0071,0072,0073,0074,0075,0076,0077,0078,0079,0080,0081,0082,0083,0084,0085,0086,0087,0088,0089,0090,0091,0093,0095,0096,0097,0098,0099,0100,0101,0102,0103,0104,0105,0106,0107,0109,0110,0111,0112,0113,0114,0116,0117,0118,0119,0120,0121,0122,0123,0124,0125,0126,0127,0128,0129,0130,0131,0132,0133,0134,0135,0136,0137,0138,0139,0140,0141,0142,0143,0144,0145,0146,0147,0148,0149,0150,0151,0152,0153,0154,0155,0156,0157,0158,0159,0160,0161,0162,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0190,0191,0192,0193,0194,0195,0196,0197,0198,0199 PREFIXE 'SI2602-' : 20 pieces, de 0032 a 0215 ATTENTION la sequence ne demarre pas a 0001 (premier = 0032) TROUS (164): 0034,0035,0036,0037,0038,0039,0040,0041,0042,0045,0046,0047,0048,0049,0050,0051,0052,0053,0054,0055,0056,0057,0058,0059,0060,0061,0062,0063,0064,0065,0066,0067,0068,0069,0070,0071,0072,0073,0074,0075,0076,0077,0078,0079,0080,0081,0082,0083,0084,0085,0086,0087,0088,0089,0090,0091,0092,0094,0096,0097,0098,0099,0100,0101,0102,0104,0105,0106,0107,0108,0110,0111,0112,0113,0114,0115,0116,0117,0118,0119,0120,0122,0123,0124,0125,0126,0127,0128,0129,0130,0131,0132,0133,0134,0135,0136,0137,0138,0140,0141,0142,0143,0144,0145,0146,0147,0148,0153,0154,0155,0156,0157,0158,0159,0160,0161,0162,0163,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0190,0191,0192,0193,0194,0195,0196,0197,0198,0199,0200,0202,0203,0204,0205,0206,0207,0208,0209,0210 PREFIXE 'SI2603-' : 31 pieces, de 0029 a 0231 ATTENTION la sequence ne demarre pas a 0001 (premier = 0029) TROUS (172): 0032,0033,0034,0035,0036,0037,0039,0040,0041,0042,0043,0044,0045,0046,0047,0048,0049,0050,0051,0052,0054,0055,0056,0063,0064,0065,0066,0067,0068,0069,0070,0071,0072,0073,0074,0075,0076,0077,0078,0079,0080,0081,0082,0084,0085,0086,0087,0088,0089,0090,0091,0092,0093,0094,0095,0097,0098,0099,0100,0101,0102,0103,0106,0107,0108,0109,0111,0112,0113,0114,0115,0117,0118,0119,0120,0121,0122,0123,0124,0125,0126,0127,0128,0129,0130,0132,0133,0134,0135,0138,0139,0141,0142,0143,0145,0146,0147,0148,0149,0150,0151,0152,0153,0154,0155,0156,0157,0158,0159,0160,0161,0162,0163,0164,0165,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0190,0191,0193,0194,0195,0197,0198,0199,0200,0201,0203,0204,0205,0206,0207,0208,0209,0210,0211,0212,0213,0214,0215,0217,0218,0219,0220,0221,0222,0223,0224,0225,0226,0227,0228 PREFIXE 'SI2604-' : 27 pieces, de 0026 a 0242 ATTENTION la sequence ne demarre pas a 0001 (premier = 0026) TROUS (190): 0029,0030,0031,0032,0033,0034,0035,0036,0037,0038,0039,0040,0041,0042,0043,0044,0045,0046,0047,0048,0049,0050,0051,0052,0053,0054,0055,0056,0057,0058,0059,0060,0061,0062,0065,0067,0068,0069,0070,0071,0072,0073,0074,0075,0076,0077,0078,0079,0080,0081,0082,0083,0084,0085,0086,0087,0088,0089,0091,0092,0093,0094,0095,0096,0098,0099,0100,0101,0102,0103,0104,0105,0106,0107,0108,0109,0110,0112,0113,0114,0115,0116,0117,0118,0119,0120,0121,0122,0123,0124,0125,0126,0127,0128,0129,0130,0131,0132,0134,0135,0136,0137,0138,0139,0140,0141,0142,0143,0144,0146,0147,0148,0149,0150,0151,0152,0153,0154,0155,0156,0158,0159,0160,0161,0162,0163,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0192,0194,0195,0196,0197,0198,0199,0200,0201,0202,0204,0205,0206,0207,0208,0210,0211,0212,0213,0214,0215,0216,0221,0222,0223,0224,0225,0226,0227,0228,0229,0230,0231,0237,0238,0239,0240,0241 PREFIXE 'SI2605-' : 35 pieces, de 0002 a 0291 ATTENTION la sequence ne demarre pas a 0001 (premier = 0002) TROUS (255): 0003,0004,0005,0006,0007,0008,0009,0010,0011,0012,0013,0014,0015,0016,0017,0018,0019,0020,0021,0022,0023,0024,0026,0027,0028,0029,0030,0031,0032,0033,0034,0035,0036,0037,0038,0040,0041,0042,0043,0044,0047,0048,0049,0051,0053,0055,0056,0057,0058,0059,0060,0061,0062,0063,0064,0065,0066,0074,0075,0076,0077,0078,0079,0080,0081,0082,0083,0085,0086,0087,0088,0089,0090,0091,0092,0093,0094,0095,0096,0097,0101,0102,0103,0104,0105,0106,0107,0108,0109,0110,0111,0113,0114,0115,0116,0117,0118,0119,0120,0121,0122,0123,0124,0125,0126,0127,0128,0129,0130,0131,0132,0133,0135,0136,0137,0138,0139,0140,0142,0143,0144,0145,0146,0147,0148,0149,0150,0151,0152,0153,0155,0156,0157,0158,0159,0160,0161,0162,0163,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0190,0191,0192,0193,0194,0195,0196,0197,0198,0199,0200,0201,0202,0203,0205,0206,0209,0210,0211,0212,0213,0214,0215,0216,0217,0218,0219,0220,0224,0225,0226,0227,0229,0230,0231,0232,0233,0234,0235,0236,0239,0240,0241,0242,0244,0245,0246,0247,0248,0249,0250,0251,0252,0253,0254,0255,0256,0257,0258,0259,0260,0261,0262,0263,0264,0265,0266,0267,0268,0269,0270,0271,0272,0273,0274,0275,0276,0277,0278,0279,0280,0281,0282,0283,0284,0285,0286,0287,0288,0289 PREFIXE 'SI2606-' : 35 pieces, de 0021 a 0248 ATTENTION la sequence ne demarre pas a 0001 (premier = 0021) TROUS (193): 0025,0026,0027,0028,0029,0030,0031,0032,0033,0034,0035,0036,0037,0038,0039,0040,0041,0042,0043,0044,0045,0046,0047,0048,0049,0050,0051,0052,0053,0054,0055,0056,0057,0058,0059,0060,0061,0062,0063,0064,0065,0066,0067,0068,0069,0070,0071,0072,0073,0078,0079,0080,0082,0083,0084,0088,0090,0092,0093,0094,0095,0096,0097,0098,0099,0100,0102,0103,0104,0105,0108,0109,0110,0111,0112,0115,0116,0117,0118,0119,0120,0121,0125,0126,0127,0128,0129,0130,0131,0132,0133,0134,0136,0137,0138,0139,0140,0141,0144,0145,0148,0149,0150,0151,0152,0153,0154,0155,0156,0157,0158,0159,0160,0161,0162,0163,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0190,0191,0192,0193,0196,0197,0198,0200,0201,0202,0203,0204,0206,0207,0208,0209,0210,0211,0212,0213,0214,0215,0216,0217,0218,0219,0220,0221,0222,0223,0226,0227,0228,0229,0230,0231,0232,0233,0234,0235,0236,0237,0238,0239,0240,0241,0242,0243,0245,0246,0247 PREFIXE 'SI2607-' : 44 pieces, de 0003 a 0287 ATTENTION la sequence ne demarre pas a 0001 (premier = 0003) TROUS (241): 0006,0008,0012,0014,0021,0022,0023,0024,0025,0026,0027,0028,0029,0030,0031,0032,0033,0034,0035,0036,0037,0038,0039,0040,0041,0042,0043,0044,0045,0046,0050,0052,0053,0054,0055,0056,0057,0058,0059,0060,0061,0062,0063,0064,0065,0066,0067,0068,0069,0070,0071,0072,0073,0074,0075,0076,0077,0079,0081,0083,0084,0085,0086,0087,0088,0089,0090,0091,0092,0093,0094,0095,0096,0097,0098,0099,0100,0101,0103,0104,0105,0106,0107,0108,0109,0110,0111,0112,0113,0114,0115,0116,0117,0118,0119,0120,0121,0122,0123,0124,0126,0128,0129,0130,0131,0132,0133,0134,0135,0136,0137,0139,0140,0141,0142,0143,0144,0145,0146,0147,0149,0150,0151,0152,0153,0154,0155,0157,0161,0162,0163,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0190,0191,0192,0193,0194,0195,0196,0199,0200,0201,0202,0203,0204,0205,0207,0208,0209,0211,0212,0213,0214,0215,0216,0217,0218,0219,0220,0221,0222,0223,0224,0225,0227,0228,0229,0230,0231,0232,0233,0234,0235,0236,0237,0238,0240,0242,0243,0244,0245,0247,0248,0249,0250,0252,0254,0255,0256,0257,0258,0259,0260,0261,0262,0263,0264,0265,0266,0267,0268,0269,0270,0271,0272,0274,0275,0276,0277,0278,0280,0281,0282,0284,0285,0286 PREFIXE 'SI2608-' : 28 pieces, de 0088 a 0300 ATTENTION la sequence ne demarre pas a 0001 (premier = 0088) TROUS (185): 0089,0090,0091,0092,0093,0094,0095,0096,0097,0098,0099,0100,0101,0102,0103,0104,0105,0106,0107,0108,0109,0110,0111,0112,0113,0114,0115,0116,0117,0118,0119,0120,0121,0122,0123,0124,0125,0126,0127,0128,0129,0130,0131,0132,0133,0134,0135,0136,0137,0138,0139,0140,0141,0142,0143,0144,0145,0146,0147,0148,0149,0150,0151,0152,0153,0154,0155,0156,0157,0158,0159,0160,0161,0162,0163,0164,0165,0166,0167,0168,0169,0170,0171,0172,0173,0174,0175,0176,0177,0178,0179,0180,0181,0182,0183,0184,0185,0186,0187,0188,0189,0190,0191,0192,0193,0194,0195,0196,0197,0198,0199,0200,0201,0202,0203,0204,0205,0206,0207,0208,0209,0210,0211,0212,0213,0214,0215,0216,0217,0218,0219,0220,0221,0222,0223,0224,0225,0226,0228,0229,0230,0231,0232,0233,0234,0235,0236,0237,0238,0239,0241,0242,0243,0244,0246,0248,0251,0253,0259,0260,0261,0262,0263,0264,0265,0267,0268,0269,0270,0271,0272,0273,0274,0275,0279,0283,0287,0289,0290,0291,0292,0295,0297,0298,0299 PREFIXE 'SI2609-' : 14 pieces, de 0259 a 0295 ATTENTION la sequence ne demarre pas a 0001 (premier = 0259) TROUS (23): 0265,0266,0269,0273,0276,0277,0278,0279,0280,0281,0282,0283,0284,0285,0286,0287,0288,0289,0290,0291,0292,0293,0294 PREFIXE 'SI2610-' : 8 pieces, de 0265 a 0301 ATTENTION la sequence ne demarre pas a 0001 (premier = 0265) TROUS (29): 0266,0267,0268,0270,0271,0272,0273,0274,0275,0276,0277,0278,0279,0280,0281,0282,0283,0284,0285,0286,0287,0288,0290,0291,0293,0294,0295,0296,0300 ===== B6 REFS PROVISOIRES / BROUILLONS RESTANTS ===== CLIENT rowid=378 ref=(PROV378) datef=2026-08-19 ttc=197.15000000 statut=0 soc=222 CLIENT rowid=379 ref=(PROV379) datef=2026-08-19 ttc=921.18000000 statut=0 soc=222 ===== B7 ORDRE CHRONOLOGIQUE DES REFS CLIENTS (une ref plus grande doit avoir une date >=) ===== RUPTURE: FA2605-0233 du 2026-05-30 (rowid 255) PUIS FA2605-0332 du 2026-05-27 (rowid 366) ttc=619.97000000 RUPTURE: FA2606-0258 du 2026-06-29 (rowid 280) PUIS FA2606-0336 du 2026-06-01 (rowid 370) ttc=1478.40000000 RUPTURE: FA2606-0337 du 2026-06-26 (rowid 371) PUIS FA2606-0342 du 2026-06-01 (rowid 377) ttc=590.40000000 RUPTURE: FA2607-0298 du 2026-07-31 (rowid 320) PUIS FA2607-0338 du 2026-07-01 (rowid 372) ttc=1478.40000000 RUPTURE: FA2608-0353 du 2026-08-31 (rowid 392) PUIS FA2608-0385 du 2026-08-01 (rowid 427) ttc=1478.40000000 ===== B8 TABLE DE SEQUENCE / DERNIER NUMERO ATTRIBUE ===== derniere_creee rowid=432 ref=FA2610-0390 datef=2026-10-21 derniere_creee rowid=431 ref=FA2610-0389 datef=2026-10-21 derniere_creee rowid=430 ref=FA2610-0388 datef=2026-10-21 derniere_creee rowid=429 ref=FA2610-0387 datef=2026-10-19 derniere_creee rowid=428 ref=FA2610-0386 datef=2026-10-19 FIN NUM