SQLite Web: db.sqlite

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"external_id":"84752056","property_id":131309,"room_id":293386,"room_name":"Chambre Mango","group_id":null,"group_type":null,"guest_name":"Carl VD","guest_email":"carl@vdc-solutions.fr","guest_phone":"0610403088","check_in":"2026-04-27","check_out":"2026-04-29","total_price":146,"commission":0,"status":"cancelled","substatus":"none","source":"kapokier972","api_reference":"","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-02T03:31:18.219Z","raw_modified_time":"2026-04-02T03:31:02Z","payload_json":"{\"timeStamp\":\"2026-04-02T03:31:17Z\",\"booking\":{\"id\":84752056,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293386,\"unitId\":1,\"roomQty\":1,\"offerId\":1,\"status\":\"cancelled\",\"subStatus\":\"none\",\"arrival\":\"2026-04-27\",\"departure\":\"2026-04-29\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Carl\",\"lastName\":\"VD\",\"email\":\"carl@vdc-solutions.fr\",\"phone\":\"0610403088\",\"mobile\":\"0610403088\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"\",\"country2\":null,\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"\",\"message\":\"\",\"groupNote\":\"\",\"custom1\":\"\",\"custom2\":\"\",\"custom3\":\"\",\"custom4\":\"\",\"custom5\":\"\",\"custom6\":\"\",\"custom7\":\"\",\"custom8\":\"\",\"custom9\":\"\",\"custom10\":\"\",\"flagColor\":\"\",\"flagText\":\"\",\"statusCode\":0,\"lang\":\"fr\",\"referer\":\"kapokier972\",\"refererEditable\":\"kapokier972\",\"reference\":\"\",\"channel\":\"direct\",\"apiSourceId\":0,\"apiSource\":\"Direct\",\"apiReference\":\"\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-04-01T17:37:56Z\",\"modifiedTime\":\"2026-04-02T03:31:02Z\",\"cancelTime\":\"2026-04-02T03:31:02Z\",\"price\":146,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Offre 1, \\r\\n2026-04-27 74 Standard Rate, \\r\\n2026-04-28 72 Standard Rate,\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":153260998,\"bookingId\":84752056,\"type\":\"charge\",\"subType\":1,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":146,\"lineTotal\":146,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":72990,\"createTime\":\"2026-04-01T17:37:56Z\"}],\"messages\":[],\"retries\":0}","event_id":"evt_1775100678220_aj0cke","should_notify":1,"dedupe_key":"363f0849"}

TEXT NOT NULL

received_at

DATETIME (default CURRENT_TIMESTAMP

processed

BOOLEAN (default 0

processed_at

DATETIME

error

TEXT

dedupe_key

TEXT

payload_json

{"external_id":"84752056","property_id":131309,"room_id":293386,"room_name":"Chambre Mango","group_id":null,"group_type":null,"guest_name":"Carl VD","guest_email":"carl@vdc-solutions.fr","guest_phone":"0610403088","check_in":"2026-04-27","check_out":"2026-04-29","total_price":146,"commission":0,"status":"cancelled","substatus":"none","source":"kapokier972","api_reference":"","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-02T03:31:18.219Z","raw_modified_time":"2026-04-02T03:31:02Z","payload_json":"{\"timeStamp\":\"2026-04-02T03:31:17Z\",\"booking\":{\"id\":84752056,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293386,\"unitId\":1,\"roomQty\":1,\"offerId\":1,\"status\":\"cancelled\",\"subStatus\":\"none\",\"arrival\":\"2026-04-27\",\"departure\":\"2026-04-29\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Carl\",\"lastName\":\"VD\",\"email\":\"carl@vdc-solutions.fr\",\"phone\":\"0610403088\",\"mobile\":\"0610403088\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"\",\"country2\":null,\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"\",\"message\":\"\",\"groupNote\":\"\",\"custom1\":\"\",\"custom2\":\"\",\"custom3\":\"\",\"custom4\":\"\",\"custom5\":\"\",\"custom6\":\"\",\"custom7\":\"\",\"custom8\":\"\",\"custom9\":\"\",\"custom10\":\"\",\"flagColor\":\"\",\"flagText\":\"\",\"statusCode\":0,\"lang\":\"fr\",\"referer\":\"kapokier972\",\"refererEditable\":\"kapokier972\",\"reference\":\"\",\"channel\":\"direct\",\"apiSourceId\":0,\"apiSource\":\"Direct\",\"apiReference\":\"\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-04-01T17:37:56Z\",\"modifiedTime\":\"2026-04-02T03:31:02Z\",\"cancelTime\":\"2026-04-02T03:31:02Z\",\"price\":146,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Offre 1, \\r\\n2026-04-27 74 Standard Rate, \\r\\n2026-04-28 72 Standard Rate,\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":153260998,\"bookingId\":84752056,\"type\":\"charge\",\"subType\":1,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":146,\"lineTotal\":146,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":72990,\"createTime\":\"2026-04-01T17:37:56Z\"}],\"messages\":[],\"retries\":0}","event_id":"evt_1775100678220_aj0cke","should_notify":1,"dedupe_key":"363f0849"}

TEXT

Update row 234 in inbox_raw