-- Test inserting directly into pos_temp_transaction with correct field names
INSERT INTO pos_temp_transaction (
    s_tid, s_mid, s_tid_stan, total_amount, b_tid_date, b_tid_time,
    currency_code, acquirer_id, status, mti, proc_code, entry_mode, 
    condition_code, metadata, inserted_at, updated_at
) VALUES (
    '12345673', '123456789012345', '000001', 100.00, '20250923', '145800',
    '840', 1, 'CREATED', '0200', '000000', '021',
    '00', '{"test": "transaction_processing"}', NOW(), NOW()
);