-- MySQL dump 10.19  Distrib 10.3.39-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: mj681954-001.privatesql    Database: serious
-- ------------------------------------------------------
-- Server version	10.6.24-MariaDB-deb11-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `llx_stripe_reconciliation`
--

DROP TABLE IF EXISTS `llx_stripe_reconciliation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `llx_stripe_reconciliation` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `payout_id` varchar(255) DEFAULT NULL,
  `balance_txn_id` varchar(255) NOT NULL,
  `charge_id` varchar(255) DEFAULT NULL,
  `payment_intent_id` varchar(255) DEFAULT NULL,
  `source_type` varchar(32) DEFAULT NULL,
  `fk_paiement` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_bank_fee` int(11) DEFAULT NULL,
  `amount_gross` double(24,8) DEFAULT 0.00000000,
  `amount_fee` double(24,8) DEFAULT 0.00000000,
  `amount_net` double(24,8) DEFAULT 0.00000000,
  `currency` varchar(3) DEFAULT NULL,
  `stripe_created` datetime DEFAULT NULL,
  `stripe_available` datetime DEFAULT NULL,
  `status` varchar(16) NOT NULL DEFAULT 'pending',
  `date_reconciliation` datetime DEFAULT NULL,
  `fk_user_reconcile` int(11) DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `stripe_description` varchar(255) DEFAULT NULL,
  `tms` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `date_harmonize` datetime DEFAULT NULL,
  `fk_user_harmonize` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_stripe_reconciliation_txn` (`entity`,`balance_txn_id`),
  KEY `idx_stripe_reconciliation_payout` (`payout_id`),
  KEY `idx_stripe_reconciliation_charge` (`charge_id`),
  KEY `idx_stripe_reconciliation_pi` (`payment_intent_id`),
  KEY `idx_stripe_reconciliation_status` (`status`),
  KEY `idx_stripe_reconciliation_paiement` (`fk_paiement`),
  KEY `idx_stripe_reconciliation_facture` (`fk_facture`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `llx_stripe_reconciliation`
--

LOCK TABLES `llx_stripe_reconciliation` WRITE;
/*!40000 ALTER TABLE `llx_stripe_reconciliation` DISABLE KEYS */;
INSERT INTO `llx_stripe_reconciliation` VALUES (1,1,'po_1TnpIfHVPrEDljqmj2A5sAGw','txn_1TnpIfHVPrEDljqmFuJc0vTg',NULL,NULL,'payout',NULL,NULL,NULL,3485,NULL,-2722.02000000,0.00000000,-2722.02000000,'EUR','2026-06-30 02:13:17','2026-06-30 02:13:17','reconciled','2026-07-19 04:00:10',3,'2026-07-18 17:16:40','20260718171639','STRIPE PAYOUT','2026-07-19 02:00:10',NULL,NULL),(2,1,'po_1TnpIfHVPrEDljqmj2A5sAGw','txn_3TmCz9HVPrEDljqm060wVOLc','py_3TmCz9HVPrEDljqm0MWr7TqD','pi_3TmCz9HVPrEDljqm0tenYD9J','payment',1471,2066,280,3421,3484,2775.00000000,52.98000000,2722.02000000,'EUR','2026-06-25 15:07:22','2026-06-30 02:00:00','reconciled','2026-07-19 03:25:52',3,'2026-07-18 17:16:40','20260718171639','Pichinov - Commande 14','2026-07-19 16:58:39','2026-07-19 03:53:04',2),(3,1,'po_1SePlaHVPrEDljqmEng5K76R','txn_1SePlbHVPrEDljqmaEPn05JN',NULL,NULL,'payout',NULL,NULL,NULL,2942,NULL,-237.40000000,0.00000000,-237.40000000,'EUR','2025-12-15 01:35:58','2025-12-15 01:35:58','historical',NULL,NULL,'2026-07-18 17:16:40','20260718171640','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(4,1,'po_1SePlaHVPrEDljqmEng5K76R','txn_3ScjJLHVPrEDljqm1c3zWNAX','ch_3ScjJLHVPrEDljqm1mdsOtE7','pi_3ScjJLHVPrEDljqm1MOs06g8','charge',1279,1840,31,2941,3170,242.25000000,4.85000000,237.40000000,'EUR','2025-12-10 10:04:07','2025-12-15 01:00:00','historical',NULL,NULL,'2026-07-18 17:16:40','20260718171640','Stripe payment: INV=1840.CUS=31 ref=FA2512-1343','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(5,1,'po_1SYFG3HVPrEDljqmc474mzHS','txn_1SYFG4HVPrEDljqm7qdDKGtx',NULL,NULL,'payout',NULL,NULL,NULL,2900,NULL,-48.35000000,0.00000000,-48.35000000,'EUR','2025-11-28 01:09:55','2025-11-28 01:09:55','historical',NULL,NULL,'2026-07-18 17:16:40','20260718171640','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(6,1,'po_1SYFG3HVPrEDljqmc474mzHS','txn_3SXJeNHVPrEDljqm07f7CA6m','ch_3SXJeNHVPrEDljqm0fLaorea','pi_3SXJeNHVPrEDljqm0o1Xqz9b','charge',1259,1799,31,2899,3169,49.54000000,1.19000000,48.35000000,'EUR','2025-11-25 11:40:09','2025-11-28 01:00:00','historical',NULL,NULL,'2026-07-18 17:16:40','20260718171640','Stripe payment: INV=1799.CUS=31 ref=FA2511-1311','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(7,1,'po_1SXAAGHVPrEDljqm5TdTtpa0','txn_1SXAAHHVPrEDljqmlTv0YuYu',NULL,NULL,'payout',NULL,NULL,NULL,2895,NULL,-41.35000000,0.00000000,-41.35000000,'EUR','2025-11-25 01:31:28','2025-11-25 01:31:28','historical',NULL,NULL,'2026-07-18 17:16:41','20260718171640','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(8,1,'po_1SXAAGHVPrEDljqm5TdTtpa0','txn_3SVXNWHVPrEDljqm0U6kR9qF','ch_3SVXNWHVPrEDljqm0ulfxkNp','pi_3SVXNWHVPrEDljqm0rwfCOZP','charge',1256,1798,90,2892,3172,42.23000000,0.88000000,41.35000000,'EUR','2025-11-20 13:55:29','2025-11-25 01:00:00','historical',NULL,NULL,'2026-07-18 17:16:41','20260718171640','Stripe payment: INV=1798.CUS=90 ref=FA2511-1310','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(9,1,'po_1SViAPHVPrEDljqmdFfoM8ID','txn_1SViAPHVPrEDljqma0MDbhnv',NULL,NULL,'payout',NULL,NULL,NULL,2893,NULL,-588.35000000,0.00000000,-588.35000000,'EUR','2025-11-21 01:25:37','2025-11-21 01:25:37','historical',NULL,NULL,'2026-07-18 17:16:41','20260718171641','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(10,1,'po_1SViAPHVPrEDljqmdFfoM8ID','txn_3SUsUZHVPrEDljqm19n7NCpa','ch_3SUsUZHVPrEDljqm1HsWvagM','pi_3SUsUZHVPrEDljqm1JjahxZI','charge',1380,1797,226,3173,3174,600.00000000,11.65000000,588.35000000,'EUR','2025-11-18 18:15:27','2025-11-21 01:00:00','historical',NULL,NULL,'2026-07-18 17:16:41','20260718171641','Pichinov - Commande 13','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(11,1,'po_1RW4srHVPrEDljqmeMAj57YI','txn_1RW4ssHVPrEDljqmIrwduvzO',NULL,NULL,'payout',NULL,NULL,NULL,2544,NULL,-1118.09000000,0.00000000,-1118.09000000,'EUR','2025-06-04 02:08:45','2025-06-04 02:08:45','historical',NULL,NULL,'2026-07-19 01:11:02','20260719011101','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(12,1,'po_1RW4srHVPrEDljqmeMAj57YI','txn_3RUSeDHVPrEDljqm0mPhIKaq','ch_3RUSeDHVPrEDljqm0EUXzpZC','pi_3RUSeDHVPrEDljqm0DQD5ZRj','charge',1379,1538,226,3167,3171,1140.00000000,21.91000000,1118.09000000,'EUR','2025-05-30 15:07:34','2025-06-04 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:02','20260719011101','Pichinov - Commande 12','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(13,1,'po_1RViPhHVPrEDljqmVpIueCaV','txn_1RViPiHVPrEDljqmTmDLdXvU',NULL,NULL,'payout',NULL,NULL,NULL,2541,NULL,-151.75000000,0.00000000,-151.75000000,'EUR','2025-06-03 02:09:09','2025-06-03 02:09:09','historical',NULL,NULL,'2026-07-19 01:11:02','20260719011102','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(14,1,'po_1RViPhHVPrEDljqmVpIueCaV','txn_3RU0XkHVPrEDljqm07oPaDSx','ch_3RU0XkHVPrEDljqm0BaSSXk7','pi_3RU0XkHVPrEDljqm0YrB3KjI','charge',1066,1464,31,2532,3168,154.94000000,3.19000000,151.75000000,'EUR','2025-05-29 09:07:20','2025-06-03 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:02','20260719011102','Stripe payment: INV=1464.CUS=31 ref=FA2505-1071','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(15,1,'po_1QrqKaHVPrEDljqmaMOJVydJ','txn_1QrqKbHVPrEDljqmhQ7ccFbA',NULL,NULL,'payout',NULL,NULL,NULL,2197,NULL,-46.84000000,0.00000000,-46.84000000,'EUR','2025-02-13 01:31:04','2025-02-13 01:31:04','historical',NULL,NULL,'2026-07-19 01:11:02','20260719011102','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(16,1,'po_1QrqKaHVPrEDljqmaMOJVydJ','txn_3Qr39AHVPrEDljqm0D6NeMQS','ch_3Qr39AHVPrEDljqm0h0D20md','pi_3Qr39AHVPrEDljqm0RrTvAID','charge',925,1210,31,2196,2277,48.00000000,1.16000000,46.84000000,'EUR','2025-02-10 21:00:27','2025-02-13 01:00:00','historical',NULL,NULL,'2026-07-19 01:11:02','20260719011102','Stripe payment: INV=1210.CUS=31 ref=FA2502-0947','2026-07-19 16:58:39','2026-07-19 04:39:27',2),(17,1,'po_1QpIk8HVPrEDljqm3RBnlDi7','txn_1QpIk9HVPrEDljqmzhvnIg0t',NULL,NULL,'payout',NULL,NULL,NULL,2183,NULL,-93.93000000,0.00000000,-93.93000000,'EUR','2025-02-06 01:14:56','2025-02-06 01:14:56','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011102','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(18,1,'po_1QpIk8HVPrEDljqm3RBnlDi7','txn_3QoRTQHVPrEDljqm0eEv5nbL','ch_3QoRTQHVPrEDljqm050RJmsK','pi_3QoRTQHVPrEDljqm0F1tvYiZ','charge',910,1214,31,2170,2276,37.49000000,0.96000000,36.53000000,'EUR','2025-02-03 16:22:25','2025-02-06 01:00:00','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011102','Stripe payment: INV=1214.CUS=31 ref=FA2502-0946','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(19,1,'po_1QpIk8HVPrEDljqm3RBnlDi7','txn_3QoRRHHVPrEDljqm0KIu3ghE','ch_3QoRRHHVPrEDljqm0FDxLdrl','pi_3QoRRHHVPrEDljqm0F3nssbf','charge',909,1071,31,2169,2275,58.77000000,1.37000000,57.40000000,'EUR','2025-02-03 16:21:38','2025-02-06 01:00:00','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011102','Stripe payment: INV=1071.CUS=31 ref=FA2412-0881','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(20,1,'po_1QfVsWHVPrEDljqmvAgsTAzU','txn_1QfVsaHVPrEDljqmlpfM2cBu',NULL,NULL,'payout',NULL,NULL,NULL,2120,NULL,-121.37000000,0.00000000,-121.37000000,'EUR','2025-01-10 01:15:09','2025-01-10 01:15:09','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(21,1,'po_1QfVsWHVPrEDljqmvAgsTAzU','txn_3QedmWHVPrEDljqm1VBCaDz5','ch_3QedmWHVPrEDljqm1I9bta9m','pi_3QedmWHVPrEDljqm1sizFw3m','charge',894,1116,31,2119,2278,123.98000000,2.61000000,121.37000000,'EUR','2025-01-07 15:30:08','2025-01-10 01:00:00','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','Stripe payment: INV=1116.CUS=31 ref=FA2501-0940','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(22,1,'po_1QTvjiHVPrEDljqmIg2vkE2G','txn_1QTvjlHVPrEDljqmnOFHfZ6S',NULL,NULL,'payout',NULL,NULL,NULL,2051,NULL,-38.35000000,0.00000000,-38.35000000,'EUR','2024-12-09 02:26:11','2024-12-09 02:26:11','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(23,1,'po_1QTvjiHVPrEDljqmIg2vkE2G','txn_3QSLWjHVPrEDljqm1CmZ7yA2','ch_3QSLWjHVPrEDljqm1T4v3g4q','pi_3QSLWjHVPrEDljqm1WotQRPi','charge',850,1072,90,2020,2047,39.19000000,0.84000000,38.35000000,'EUR','2024-12-04 17:35:38','2024-12-09 01:00:00','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','Stripe payment: INV=1072.CUS=90 ref=FA2412-0882','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(24,1,'po_1PbBXdHVPrEDljqmqjHIC9ek','txn_1PbBXdHVPrEDljqmpj8p9msW',NULL,NULL,'payout',NULL,NULL,NULL,1696,NULL,-73.16000000,0.00000000,-73.16000000,'EUR','2024-07-11 03:11:25','2024-07-11 03:11:25','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(25,1,'po_1PbBXdHVPrEDljqmqjHIC9ek','txn_3PZYNFHVPrEDljqm13rueshm','ch_3PZYNFHVPrEDljqm1md6AMQ0','pi_3PZYNFHVPrEDljqm13DtyUDz','charge',709,709,90,1683,1719,36.99000000,0.80000000,36.19000000,'EUR','2024-07-06 15:20:15','2024-07-11 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','Stripe payment: INV=709.CUS=90 ref=FA2403-0615','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(26,1,'po_1PbBXdHVPrEDljqmqjHIC9ek','txn_3PZYUlHVPrEDljqm0mIagi7D','ch_3PZYUlHVPrEDljqm0k1X9Pgb','pi_3PZYUlHVPrEDljqm0B1euaDp','charge',708,711,90,1682,1720,37.79000000,0.82000000,36.97000000,'EUR','2024-07-06 15:18:24','2024-07-11 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:03','20260719011103','Stripe payment: INV=711.CUS=90 ref=FA2403-0616','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(27,1,'po_1PTvzCHVPrEDljqmhj2tRJQc','txn_1PTvzCHVPrEDljqmTrzoUC8l',NULL,NULL,'payout',NULL,NULL,NULL,1648,NULL,-3310.37000000,0.00000000,-3310.37000000,'EUR','2024-06-21 03:09:54','2024-06-21 03:09:54','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011103','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(28,1,'po_1PTvzCHVPrEDljqmhj2tRJQc','txn_3PT1KWHVPrEDljqm1rWbZmm1','ch_3PT1KWHVPrEDljqm1rL56EGT','pi_3PT1KWHVPrEDljqm17PTTFLN','charge',684,829,82,1647,1717,2775.00000000,52.98000000,2722.02000000,'EUR','2024-06-18 14:40:46','2024-06-21 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011103','Pichinov - Commande 11','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(29,1,'po_1PTvzCHVPrEDljqmhj2tRJQc','txn_3PSy9PHVPrEDljqm1RV6NfAj','ch_3PSy9PHVPrEDljqm1FVsj2SB','pi_3PSy9PHVPrEDljqm1kKuxiIw','charge',683,817,NULL,1631,1718,600.00000000,11.65000000,588.35000000,'EUR','2024-06-18 11:17:05','2024-06-21 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011103','Pichinov - Commande 10','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(30,1,'po_1Oyl0VHVPrEDljqmxGjMQLI8','txn_1Oyl0VHVPrEDljqmENoIpJ3L',NULL,NULL,'payout',NULL,NULL,NULL,1440,NULL,-51.71000000,0.00000000,-51.71000000,'EUR','2024-03-27 02:10:23','2024-03-27 02:10:23','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011104','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(31,1,'po_1Oyl0VHVPrEDljqmxGjMQLI8','txn_3Ox90VHVPrEDljqm1M4JtNhC','ch_3Ox90VHVPrEDljqm1bBZlJMJ','pi_3Ox90VHVPrEDljqm1xik9Ijc','charge',594,705,26,1433,1721,52.97000000,1.26000000,51.71000000,'EUR','2024-03-22 15:24:32','2024-03-27 01:00:00','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011104','Stripe payment: INV=705.CUS=26 ref=FA2403-0587','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(32,1,'po_1N8D03HVPrEDljqmx85cainp','txn_1N8D03HVPrEDljqmnlSNJQIt',NULL,NULL,'payout',NULL,NULL,NULL,1318,NULL,-588.35000000,0.00000000,-588.35000000,'EUR','2023-05-16 03:48:27','2023-05-16 03:48:27','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011104','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:02:28',2),(33,1,'po_1N8D03HVPrEDljqmx85cainp','txn_3N6bA2HVPrEDljqm0Usq71As','ch_3N6bA2HVPrEDljqm0wkLj6gM','pi_3N6bA2HVPrEDljqm0fNJE7JF','charge',312,399,86,825,1320,600.00000000,11.65000000,588.35000000,'EUR','2023-05-11 17:12:12','2023-05-16 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:04','20260719011104','Pichinov - Commande 8','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(34,1,'po_1LrwCxHVPrEDljqmAOgISKBB','txn_1LrwCzHVPrEDljqmNoO1s4r6',NULL,NULL,'payout',NULL,NULL,NULL,783,NULL,-591.35000000,0.00000000,-591.35000000,'EUR','2022-10-12 06:06:15','2022-10-17 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:05','20260719011104','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:07:34',2),(35,1,'po_1LrwCxHVPrEDljqmAOgISKBB','txn_3LrITmHVPrEDljqm1WyZtOkB','ch_3LrITmHVPrEDljqm1de5sQ7u','pi_3LrITmHVPrEDljqm1vr3BZva','charge',144,209,74,158,778,600.00000000,8.65000000,591.35000000,'EUR','2022-10-10 11:41:42','2022-10-17 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:05','20260719011104','Pichinov - Commande 3','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(36,1,'po_1LpkExHVPrEDljqmQTCrOkQN','txn_1LpkEzHVPrEDljqmCFI8BEb0',NULL,NULL,'payout',NULL,NULL,NULL,785,NULL,-591.35000000,0.00000000,-591.35000000,'EUR','2022-10-06 04:55:16','2022-10-11 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:05','20260719011105','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:07:34',2),(37,1,'po_1LpkExHVPrEDljqmQTCrOkQN','txn_3LpAjVHVPrEDljqm1YL9nbVn','ch_3LpAjVHVPrEDljqm14aDL0jw','pi_3LpAjVHVPrEDljqm1Xnsrmh3','charge',145,210,60,159,779,600.00000000,8.65000000,591.35000000,'EUR','2022-10-04 15:01:10','2022-10-11 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:05','20260719011105','Pichinov - Commande 2','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(38,1,'po_1LjFLcHVPrEDljqmvRPHZkLb','txn_1LjFLdHVPrEDljqmojqezMbB',NULL,NULL,'payout',NULL,NULL,NULL,787,NULL,-514.44000000,0.00000000,-514.44000000,'EUR','2022-09-18 06:43:16','2022-09-23 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:05','20260719011105','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:07:34',2),(39,1,'po_1LjFLcHVPrEDljqmvRPHZkLb','txn_3LiYShHVPrEDljqm11nIjl5z','ch_3LiYShHVPrEDljqm1qEKqQYt','pi_3LiYShHVPrEDljqm1PSYejud','charge',287,120,82,777,780,522.00000000,7.56000000,514.44000000,'EUR','2022-09-16 08:56:23','2022-09-23 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:05','20260719011105','Stripe payment: INV=120.CUS=82 ref=FA2209-0081','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(40,1,'po_1LipT0HVPrEDljqmoKVyLLJj','txn_1LipT2HVPrEDljqmMBtv9FaV',NULL,NULL,'payout',NULL,NULL,NULL,789,NULL,-289.39000000,0.00000000,-289.39000000,'EUR','2022-09-17 03:05:10','2022-09-22 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:06','20260719011105','STRIPE PAYOUT','2026-07-19 16:58:39','2026-07-19 03:07:34',2),(41,1,'po_1LipT0HVPrEDljqmoKVyLLJj','txn_3LiFSAHVPrEDljqm08DM9f3G','ch_3LiFSAHVPrEDljqm0gZdQbYa','pi_3LiFSAHVPrEDljqm0hPoWWav','charge',286,111,60,776,781,156.00000000,2.43000000,153.57000000,'EUR','2022-09-15 12:38:34','2022-09-22 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:06','20260719011105','Stripe payment: INV=111.CUS=60 ref=FA2209-0072','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(42,1,'po_1LipT0HVPrEDljqmoKVyLLJj','txn_3LiEiXHVPrEDljqm1tV2GRKl','ch_3LiEiXHVPrEDljqm1L987jH4','pi_3LiEiXHVPrEDljqm1XNqdhnY','charge',285,117,68,775,782,138.00000000,2.18000000,135.82000000,'EUR','2022-09-15 11:51:49','2022-09-22 02:00:00','historical',NULL,NULL,'2026-07-19 01:11:06','20260719011105','Stripe payment: INV=117.CUS=68 ref=FA2209-0078','2026-07-19 16:58:39','2026-07-19 04:39:26',2),(43,1,'po_1Tv5KpHVPrEDljqmbDNYJJVZ','txn_3TtNxlHVPrEDljqm1euKy0rM','ch_3TtNxlHVPrEDljqm1r4DZMYQ','pi_3TtNxlHVPrEDljqm1buqayV3','charge',1504,2098,31,3482,3483,83.99000000,1.85000000,82.14000000,'EUR','2026-07-15 10:16:48','2026-07-20 02:00:00','reconciled','2026-07-19 03:25:52',3,'2026-07-19 03:13:45','20260719031344','Stripe payment: INV=2098.CUS=31 ref=FA2607-1575','2026-07-24 19:06:59','2026-07-19 03:53:04',2),(44,1,'po_1Tv5KpHVPrEDljqmbDNYJJVZ','txn_1Tv5KpHVPrEDljqmQJDPbJvq',NULL,NULL,'payout',NULL,NULL,NULL,3487,NULL,-82.14000000,0.00000000,-82.14000000,'EUR','2026-07-20 02:45:31','2026-07-20 02:45:31','reconciled','2026-07-24 21:07:41',3,'2026-07-24 21:06:59','20260724210658','STRIPE PAYOUT','2026-07-24 19:07:41',NULL,NULL);
/*!40000 ALTER TABLE `llx_stripe_reconciliation` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-29 23:26:34
