mysql> select * from parameter_templates; +----+----------------------------------------+------------------------------------------------------+-----------+-----------+------------+-----------+---------------+---------------------+---------------------+ | id | name | description | vendor | model | is_default | is_active | created_by_id | inserted_at | updated_at | +----+----------------------------------------+------------------------------------------------------+-----------+-----------+------------+-----------+---------------+---------------------+---------------------+ | 1 | Ingenico Default Configuration | Default parameters for Ingenico terminals | Ingenico | universal | 1 | 1 | NULL | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 2 | Verifone Default Configuration | Default parameters for Verifone terminals | Verifone | universal | 1 | 1 | NULL | 2025-07-18 04:32:02 | 2025-07-18 04:32:02 | | 3 | MF919 Default Configuration | Default parameters for MoreFun Android terminals | Morefun | MF919 | 1 | 1 | NULL | 2025-07-18 04:32:02 | 2026-02-01 08:56:02 | | 4 | Global Default Configuration | Universal default parameters for all terminals | universal | universal | 1 | 1 | NULL | 2025-07-18 04:32:03 | 2025-07-18 04:32:03 | | 5 | PAX A920 Standard Configuration | Standard configuration for PAX A920 terminals | PAX | A920 | 1 | 1 | NULL | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 6 | Ingenico iWL250 Standard Configuration | Standard configuration for Ingenico iWL250 terminals | Ingenico | iWL250 | 1 | 1 | NULL | 2025-07-18 04:36:31 | 2025-07-18 04:36:31 | | 7 | Communication SR600mini | NULL | Morefun | sr600 | 1 | 1 | NULL | 2025-09-01 07:17:03 | 2025-09-01 07:17:03 | +----+----------------------------------------+------------------------------------------------------+-----------+-----------+------------+-----------+---------------+---------------------+---------------------+ 7 rows in set (0.00 sec) mysql> select * from parameter_categories; +----+--------------------------------+----------------------+-----------------------------------------------------------------------+------------+-----------+---------------------+---------------------+-----------+ | id | name | code | description | sort_order | is_active | inserted_at | updated_at | parent_id | +----+--------------------------------+----------------------+-----------------------------------------------------------------------+------------+-----------+---------------------+---------------------+-----------+ | 1 | Trade Module | trade_module | Trade and transaction related parameters | 1 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | NULL | | 2 | Communication Module | communication_module | Communication and network parameters | 2 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | NULL | | 3 | Transactions | transactions | Transaction processing parameters | 3 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | NULL | | 4 | Card Module | card_module | Card processing parameters | 4 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | NULL | | 5 | APK | apk | Application and system parameters | 5 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | NULL | | 6 | Security | trade_security | NULL | 1 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | 1 | | 7 | ID | trade_id | NULL | 2 | 1 | 2025-07-18 04:31:59 | 2025-07-18 04:31:59 | 1 | | 8 | Print | trade_print | NULL | 3 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 1 | | 9 | Session | trade_session | NULL | 4 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 1 | | 10 | Additional | trade_additional | NULL | 5 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 1 | | 11 | General | comm_general | NULL | 1 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 2 | | 12 | Host | comm_host | NULL | 2 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 2 | | 13 | Financial | trans_financial | NULL | 1 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 3 | | 14 | Administrative | trans_administrative | NULL | 2 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 3 | | 15 | CardRanges | card_ranges | NULL | 1 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 4 | | 16 | MFSetting | apk_mfsetting | NULL | 1 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 5 | | 17 | MFLauncher | apk_mflauncher | NULL | 2 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 5 | | 18 | MFAppstore | apk_mfappstore | NULL | 3 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 5 | | 19 | System | apk_system | NULL | 4 | 1 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | 5 | | 20 | Device Setup | device_setup | Device configuration and setup parameters | 0 | 1 | 2026-01-31 20:45:06 | 2026-01-31 20:45:06 | NULL | | 21 | MF919 Device Setup | mf919_device_setup | Root category for MoreFun MF919 device configuration parameters | 10 | 1 | 2026-03-10 04:24:34 | 2026-03-10 04:24:34 | NULL | | 22 | MF919 Base / Merchant Defaults | mf919_base | Base merchant and transaction default parameters for MF919 | 1 | 1 | 2026-03-10 04:24:34 | 2026-03-10 04:24:34 | 8 | | 23 | MF919 Merchant Overlay | mf919_merchant | Per-terminal merchant-specific parameters (MID, TID, Batch) for MF919 | 2 | 1 | 2026-03-10 04:24:34 | 2026-03-10 04:24:34 | 8 | | 24 | MF919 Communication | mf919_comm | Network and communication parameters for MF919 | 3 | 1 | 2026-03-10 04:24:35 | 2026-03-10 04:24:35 | 8 | | 25 | MF919 Transactions | mf919_transactions | Transaction type enable/disable toggles for MF919 | 4 | 1 | 2026-03-10 04:24:35 | 2026-03-10 04:24:35 | 8 | | 26 | MF919 Printing | mf919_printing | Printer configuration parameters for MF919 | 5 | 1 | 2026-03-10 04:24:35 | 2026-03-10 04:24:35 | 8 | | 27 | MF919 PINPAD | mf919_pinpad | PINPAD and external device parameters for MF919 | 6 | 1 | 2026-03-10 04:24:35 | 2026-03-10 04:24:35 | 8 | | 28 | MF919 Scanner | mf919_scanner | Barcode / QR scanner parameters for MF919 | 7 | 1 | 2026-03-10 04:24:35 | 2026-03-10 04:24:35 | 8 | | 29 | MF919 Security | mf919_security | Security, password, and operational flag parameters for MF919 | 8 | 1 | 2026-03-10 04:24:35 | 2026-03-10 04:24:35 | 8 | +----+--------------------------------+----------------------+-----------------------------------------------------------------------+------------+-----------+---------------------+---------------------+-----------+ 29 rows in set (0.00 sec) mysql> select * from parameter_definitions; +----+--------------------------------+-----------------------------------+-------------------------------------------------------------------------------------------+--------------+--------------------------+------------------------------------------------------------------------------------------------+-------------+-----------+--------------+---------------+-----------+-------------+---------------------+---------------------+ | id | key | name | description | data_type | default_value | validation_rules | is_required | is_system | is_encrypted | display_order | is_active | category_id | inserted_at | updated_at | +----+--------------------------------+-----------------------------------+-------------------------------------------------------------------------------------------+--------------+--------------------------+------------------------------------------------------------------------------------------------+-------------+-----------+--------------+---------------+-----------+-------------+---------------------+---------------------+ | 1 | merchant_id | Merchant ID | Unique merchant identifier | string | 900890089008000 | {"max_length": 20} | 1 | 0 | 0 | 1 | 1 | 7 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | | 2 | terminal_id | Terminal ID | Terminal identifier | string | NULL | {"max_length": 15} | 1 | 0 | 0 | 2 | 1 | 7 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | | 3 | receipt_printing | Receipt Printing | Enable/disable receipt printing | boolean | true | NULL | 0 | 0 | 0 | 1 | 1 | 8 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | | 4 | mqtt_ip | MQTT Server IP | MQTT broker IP address | string | testapp.ariticapp.com | {"pattern": "^[a-zA-Z0-9.-]+$"} | 1 | 0 | 0 | 1 | 1 | 11 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | | 5 | mqtt_port | MQTT Port | MQTT broker port number | integer | 1883 | {"max": 65535, "min": 1} | 1 | 0 | 0 | 2 | 1 | 11 | 2025-07-18 04:32:00 | 2025-07-18 04:32:00 | | 6 | http_ip | HTTP Server IP | HTTP server IP address | string | demo.ctrmv.com | NULL | 1 | 0 | 0 | 3 | 1 | 11 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 7 | http_port | HTTP Port | HTTP server port number | integer | 4001 | {"max": 65535, "min": 1} | 1 | 0 | 0 | 4 | 1 | 11 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 8 | product_key | Product Key | Product authentication key | string | pFppbioOCKlo5c8E | {"min_length": 8} | 1 | 0 | 0 | 1 | 1 | 12 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 9 | product_secret | Product Secret | Product secret for authentication | string | sj2AJl102397fQAV | {"min_length": 8} | 1 | 0 | 0 | 2 | 1 | 12 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 10 | username | Username | Authentication username | string | user001 | NULL | 1 | 0 | 0 | 3 | 1 | 12 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 11 | keepalive_time | Keep Alive Time | Connection keep alive interval (seconds) | integer | 300 | {"max": 3600, "min": 30} | 0 | 0 | 0 | 4 | 1 | 12 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 12 | heartbeat_interval | Heartbeat Interval | Heartbeat transmission interval (seconds) | integer | 300 | {"max": 3600, "min": 60} | 0 | 0 | 0 | 5 | 1 | 12 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 13 | transaction_timeout | Transaction Timeout | Transaction timeout in seconds | integer | 60 | {"max": 300, "min": 30} | 0 | 0 | 0 | 1 | 1 | 13 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 14 | max_transaction_amount | Max Transaction Amount | Maximum allowed transaction amount | integer | 999999 | {"min": 1} | 0 | 0 | 0 | 2 | 1 | 13 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 15 | play_language | Play Language | Audio language setting | integer | 1 | {"max": 10, "min": 1} | 0 | 0 | 0 | 1 | 1 | 19 | 2025-07-18 04:32:01 | 2025-07-18 04:32:01 | | 16 | CURRENCY_CODE | Currency Code | ISO 4217 currency code | select | 840 | {"options": ["840", "978", "826", "392", "124", "356"]} | 1 | 0 | 0 | 12 | 1 | 1 | 2025-07-18 04:32:20 | 2025-07-18 04:32:20 | | 17 | BATCH_NUMBER | Current Batch Number | Current batch number for settlements | integer | 1 | {"max": 999999, "min": 1} | 1 | 0 | 0 | 13 | 1 | 1 | 2025-07-18 04:32:20 | 2025-07-18 04:32:20 | | 18 | MAX_TXN_AMOUNT | Maximum Transaction Amount | Maximum allowed transaction amount in cents | integer | 999999 | {"max": 9999999, "min": 100} | 0 | 0 | 0 | 14 | 1 | 1 | 2025-07-18 04:32:20 | 2025-07-18 04:32:20 | | 19 | PRIMARY_HOST_IP | Primary Host IP | IP address of primary processing host | string | demo.ctrmv.com | {"pattern": "^(?:[0-9]{1,3}\\.){3}[0-9]{1,3}$"} | 1 | 0 | 0 | 20 | 1 | 2 | 2025-07-18 04:32:20 | 2025-07-22 15:25:41 | | 20 | PRIMARY_HOST_PORT | Primary Host Port | Port number of primary processing host | integer | 4001 | {"max": 65535, "min": 1} | 1 | 0 | 0 | 21 | 1 | 2 | 2025-07-18 04:32:20 | 2025-09-01 07:17:55 | | 21 | SECONDARY_HOST_IP | Secondary Host IP | IP address of backup processing host | string | NULL | {"pattern": "^(?:[0-9]{1,3}\\.){3}[0-9]{1,3}$"} | 0 | 0 | 0 | 22 | 1 | 2 | 2025-07-18 04:32:20 | 2025-07-18 04:32:20 | | 22 | SSL_ENABLED | SSL/TLS Enabled | Enable SSL/TLS for host communication | boolean | true | NULL | 1 | 0 | 0 | 23 | 0 | 2 | 2025-07-18 04:32:20 | 2025-09-01 07:19:08 | | 23 | CONNECTION_TIMEOUT | Connection Timeout | Connection timeout in seconds | integer | 60 | {"max": 300, "min": 5} | 0 | 0 | 0 | 24 | 1 | 2 | 2025-07-18 04:32:20 | 2025-09-01 07:19:28 | | 24 | TXN_TYPES_ENABLED | Enabled Transaction Types | List of enabled transaction types | multi_select | ["SALE","VOID","REFUND"] | {"options": ["SALE", "VOID", "REFUND", "AUTH", "COMPLETION", "ADJUSTMENT", "BALANCE_INQUIRY"]} | 0 | 0 | 0 | 30 | 1 | 3 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 25 | TIP_ENABLED | Tip Entry Enabled | Allow tip entry on transactions | boolean | true | NULL | 0 | 0 | 0 | 31 | 1 | 3 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 26 | TIP_PERCENTAGE_OPTIONS | Tip Percentage Options | Predefined tip percentage options | string | 15,18,20,25 | {"pattern": "^[0-9,]+$"} | 0 | 0 | 0 | 32 | 1 | 3 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 27 | CASHBACK_ENABLED | Cashback Enabled | Allow cashback on debit transactions | boolean | false | NULL | 0 | 0 | 0 | 33 | 1 | 3 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 28 | MAX_CASHBACK_AMOUNT | Maximum Cashback Amount | Maximum cashback amount in cents | integer | 10000 | {"max": 50000, "min": 0} | 0 | 0 | 0 | 34 | 1 | 3 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 29 | CONTACTLESS_ENABLED | Contactless Payments Enabled | Enable NFC/contactless payments | boolean | true | NULL | 0 | 0 | 0 | 40 | 1 | 4 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 30 | CONTACTLESS_LIMIT | Contactless Transaction Limit | Transaction limit for contactless payments in cents | integer | 9000 | {"max": 20000, "min": 0} | 1 | 0 | 0 | 41 | 1 | 4 | 2025-07-18 04:36:05 | 2025-07-19 19:36:47 | | 31 | EMV_ENABLED | EMV Chip Reading Enabled | Enable EMV chip card processing | boolean | true | NULL | 1 | 0 | 0 | 42 | 1 | 4 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 32 | MAG_STRIPE_ENABLED | Magnetic Stripe Enabled | Enable magnetic stripe card reading | boolean | true | NULL | 0 | 0 | 0 | 43 | 1 | 4 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 33 | PIN_BYPASS_ENABLED | PIN Bypass Enabled | Allow PIN bypass for small amounts | boolean | false | NULL | 0 | 0 | 0 | 44 | 1 | 4 | 2025-07-18 04:36:05 | 2025-07-18 04:36:05 | | 34 | MQTT_HOST_IP | MQTT Host IP | NULL | string | demo.ctrmv.com | NULL | 1 | 0 | 0 | 3 | 1 | 2 | 2025-09-01 07:18:46 | 2025-09-01 07:18:46 | | 35 | 98764678975 | morefun | NULL | string | NULL | NULL | 1 | 0 | 0 | 0 | 1 | 1 | 2025-09-02 10:55:24 | 2025-09-02 10:58:26 | | 36 | emv_config_version | EMV Config Version | Version of EMV configuration deployed on device | string | 1.6 | NULL | 0 | 0 | 0 | 1 | 1 | 20 | 2026-02-01 05:25:46 | 2026-02-01 05:25:46 | | 37 | keys_config_version | Keys Config Version | Version of encryption keys configuration deployed on device | string | 1.7 | NULL | 0 | 0 | 0 | 2 | 1 | 20 | 2026-02-01 05:25:46 | 2026-02-01 05:25:46 | | 38 | application_version | Application Version | Version of main application deployed on device | string | 3.7 | NULL | 0 | 0 | 0 | 3 | 1 | 20 | 2026-02-01 05:25:46 | 2026-02-01 05:25:46 | | 39 | BATCH_NO | Batch Number | Initial / current batch number for the terminal | string | 000001 | {"pattern": "^\\d{6}$", "max_length": 6} | 0 | 0 | 0 | 3 | 1 | 23 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 40 | BASE_MERCHANT_NAME | Merchant Name | Display name of the merchant shown on receipts | string | Demo Merchant | {"max_length": 64} | 0 | 0 | 0 | 1 | 1 | 22 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 41 | BASE_TRACE_NO | Trace Number | Starting transaction trace / sequence number | string | 000001 | {"pattern": "^\\d{1,6}$", "max_length": 6} | 0 | 0 | 0 | 2 | 1 | 22 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 42 | BASE_MAX_REFUND_AMOUNT | Max Refund Amount | Maximum refund amount in cents | integer | 1000000 | {"min": 0} | 0 | 0 | 0 | 3 | 1 | 22 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 43 | BASE_CURRENCY_CODE | Currency Code | ISO 4217 numeric currency code (e.g. 784 for AED, 840 for USD) | string | 784 | {"pattern": "^\\d{3}$", "max_length": 3} | 0 | 0 | 0 | 4 | 1 | 22 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 44 | BASE_MAX_TRANS_COUNT | Max Transaction Count | Maximum number of transactions stored in batch | integer | 500 | {"max": 9999, "min": 1} | 0 | 0 | 0 | 5 | 1 | 22 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 45 | PINPAD_MASTER_KEY_INDEX | PINPAD Master Key Index | Index of the master key used by the PINPAD | integer | 0 | {"min": 0} | 0 | 0 | 0 | 1 | 1 | 27 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 46 | PINPAD_ALGORITHM_TYPE | PINPAD Algorithm Type | Key derivation algorithm: 0 = DUKPT, 1 = MKSK | select | 0 | {"options": ["0", "1"]} | 0 | 0 | 0 | 2 | 1 | 27 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 47 | PINPAD_TIMEOUT | PINPAD Entry Timeout | PIN entry timeout in seconds | integer | 60 | {"max": 300, "min": 1} | 0 | 0 | 0 | 3 | 1 | 27 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 48 | EXTERNAL_PINPAD_YSDK | Enable YSDK PINPAD | Enable YSDK external PINPAD integration (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 4 | 1 | 27 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 49 | EXTERNAL_PINPAD | Enable External PINPAD | Enable external PINPAD hardware (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 5 | 1 | 27 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 50 | EXTERNAL_PINPAD_CONNECT_MODE | External PINPAD Connect Mode | Connection mode: 0=Serial, 1=USB, 10=Dock Serial, 11=Dock USB1, 12=Dock USB2 | select | 0 | {"options": ["0", "1", "10", "11", "12"]} | 0 | 0 | 0 | 6 | 1 | 27 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 51 | PRINT_COUNT | Print Count | Number of receipt copies to print per transaction | integer | 2 | {"max": 9, "min": 0} | 0 | 0 | 0 | 1 | 1 | 26 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 52 | PRINT_EXTERNAL | Enable External Printer | Use an external printer (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 2 | 1 | 26 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 53 | PRINT_EXTERNAL_CONNECT_MODE | External Printer Connect Mode | Connection mode: 0=Serial, 1=USB, 2=Bluetooth, 10=Dock Serial, 11=Dock USB1, 12=Dock USB2 | select | 1 | {"options": ["0", "1", "2", "10", "11", "12"]} | 0 | 0 | 0 | 3 | 1 | 26 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 54 | PRINT_EXTERNAL_SERIAL_BAUDRATE | External Printer Serial Baud Rate | Baud rate for serial-connected external printer | integer | 115200 | {"min": 1200} | 0 | 0 | 0 | 4 | 1 | 26 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 55 | PRINT_REMARKS | Print Remarks | Custom footer text printed at the bottom of receipts | string | Thank you, Visit Again | {"max_length": 128} | 0 | 0 | 0 | 5 | 1 | 26 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 56 | TRANS_SALE | Enable Sale | Allow sale transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 1 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 57 | TRANS_VOID | Enable Void | Allow void transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 2 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 58 | TRANS_REFUND | Enable Refund | Allow refund transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 3 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 59 | TRANS_BALANCE | Enable Balance Inquiry | Allow balance inquiry transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 4 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 60 | TRANS_PREAUTH | Enable Pre-Auth | Allow pre-authorisation transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 5 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 61 | TRANS_MOBILE_PAY | Enable Mobile Pay | Allow mobile payment transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 6 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 62 | TRANS_INSTALLMENT | Enable Installment | Allow installment payment transactions (1 = YES, 0 = NO) | boolean | true | NULL | 0 | 0 | 0 | 7 | 1 | 25 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 63 | COMM_USE_SSL | Use SSL | Enable SSL/TLS for host communication (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 1 | 1 | 24 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 64 | COMM_TIMEOUT | Communication Timeout | Host communication timeout in seconds | integer | 60 | {"max": 300, "min": 1} | 0 | 0 | 0 | 2 | 1 | 24 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 65 | COMM_TPDU | TPDU | Transport Protocol Data Unit header value | string | 6000782000 | {"max_length": 20} | 0 | 0 | 0 | 3 | 1 | 24 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 66 | COMM_SERVER_ADDRESS | Server Address | Host / acquirer server IP address or hostname | string | 40.120.104.51 | {"max_length": 255} | 0 | 0 | 0 | 4 | 1 | 24 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 67 | COMM_PORT | Server Port | Host / acquirer server TCP port | integer | 80 | {"max": 65535, "min": 1} | 0 | 0 | 0 | 5 | 1 | 24 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 68 | COMM_NII | NII | Network International Identifier used in ISO 8583 messages | string | 782 | {"pattern": "^\\d{1,3}$", "max_length": 3} | 0 | 0 | 0 | 6 | 1 | 24 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 69 | ELECSIGN_IS_SUPPORT | Enable Electronic Signature | Support electronic signature capture (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 1 | 1 | 28 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 70 | SCAN_PRIORITY_SCANNER | Priority Scanner | Preferred scanner: 0 = Front, 1 = Back, 2 = External | select | 1 | {"options": ["0", "1", "2"]} | 0 | 0 | 0 | 2 | 1 | 28 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 71 | SCAN_EXTERN_CONNECT_MODE | External Scanner Connect Mode | Connection mode: 0=Serial, 1=USB, 10=Dock Serial, 11=Dock USB1, 12=Dock USB2 | select | 0 | {"options": ["0", "1", "10", "11", "12"]} | 0 | 0 | 0 | 3 | 1 | 28 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 72 | SCAN_EXTERN_USB_WAIT_TIME | External Scanner USB Wait Time | Milliseconds to wait for USB scan box receipt completion | integer | 300 | {"min": 0} | 0 | 0 | 0 | 4 | 1 | 28 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 73 | SCAN_EXTERN_SERIAL_BAUDRATE | External Scanner Serial Baud Rate | Baud rate for serial-connected external scanner | integer | 115200 | {"min": 1200} | 0 | 0 | 0 | 5 | 1 | 28 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 74 | PASSWORD_ADMIN | Admin Password | Administrator access password for the device | string | 123456 | {"max_length": 32} | 0 | 0 | 0 | 1 | 1 | 29 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 75 | PASSWORD_SYSTEM_ADMIN | System Admin Password | System-level administrator password for the device | string | 000000 | {"max_length": 32} | 0 | 0 | 0 | 2 | 1 | 29 | 2026-03-10 04:24:49 | 2026-03-10 04:24:49 | | 76 | PASSWORD_SECURITY | Security Password | Security access password for the device | string | 888888 | {"max_length": 32} | 0 | 0 | 0 | 3 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 77 | TOMS_FLY_PARAMETERS | TOMS Fly Parameters | Enable parameter update notification (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 4 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 78 | TOMS_FLY_RECEIPT | TOMS Fly Receipt | Enable electronic receipt via TOMS (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 5 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 79 | NFC_RECEIPT | NFC / Digital Receipt | Enable digital receipt delivery (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 6 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 80 | OTHER_TIP_INPUT | Enable Tip Input | Support tip amount entry during a sale (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 7 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 81 | OTHER_THRID_BILL_SHOW | Third-Party Bill Result | Show transaction result to third-party billing apps (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 8 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 82 | OTHER_VOID_CARD | Void Requires Card | Require card tap/swipe to complete a void transaction (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 9 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | | 83 | OTHER_VOID_PIN | Void Requires PIN | Require PIN entry to complete a void transaction (1 = YES, 0 = NO) | boolean | false | NULL | 0 | 0 | 0 | 10 | 1 | 29 | 2026-03-10 04:24:50 | 2026-03-10 04:24:50 | +----+--------------------------------+-----------------------------------+-------------------------------------------------------------------------------------------+--------------+--------------------------+------------------------------------------------------------------------------------------------+-------------+-----------+--------------+---------------+-----------+-------------+---------------------+---------------------+ 83 rows in set (0.00 sec) mysql> select * from parameter_template_values; +-----+------------------------+---------------+-------------+-------------------------+---------------------+---------------------+ | id | value | is_overridden | template_id | parameter_definition_id | inserted_at | updated_at | +-----+------------------------+---------------+-------------+-------------------------+---------------------+---------------------+ | 106 | Demo Merchant | 0 | 3 | 40 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 107 | 000001 | 0 | 3 | 41 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 108 | 1000000 | 0 | 3 | 42 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 109 | 784 | 0 | 3 | 43 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 110 | 500 | 0 | 3 | 44 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 111 | 0 | 0 | 3 | 45 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 112 | 0 | 0 | 3 | 46 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 113 | 60 | 0 | 3 | 47 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 114 | true | 0 | 3 | 48 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 115 | false | 0 | 3 | 49 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 116 | 0 | 0 | 3 | 50 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 117 | 2 | 0 | 3 | 51 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 118 | false | 0 | 3 | 52 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 119 | 1 | 0 | 3 | 53 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 120 | 115200 | 0 | 3 | 54 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 121 | Thank you, Visit Again | 0 | 3 | 55 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 122 | true | 0 | 3 | 56 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 123 | true | 0 | 3 | 57 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 124 | true | 0 | 3 | 58 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 125 | true | 0 | 3 | 59 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 126 | true | 0 | 3 | 60 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 127 | true | 0 | 3 | 61 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 128 | true | 0 | 3 | 62 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 129 | false | 0 | 3 | 63 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 130 | 60 | 0 | 3 | 64 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 131 | 6000782000 | 0 | 3 | 65 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 132 | 40.120.104.51 | 0 | 3 | 66 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 133 | 80 | 0 | 3 | 67 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 134 | 782 | 0 | 3 | 68 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 135 | false | 0 | 3 | 69 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 136 | 1 | 0 | 3 | 70 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 137 | 0 | 0 | 3 | 71 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 138 | 300 | 0 | 3 | 72 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 139 | 115200 | 0 | 3 | 73 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 140 | 123456 | 0 | 3 | 74 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 141 | 000000 | 0 | 3 | 75 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 142 | 888888 | 0 | 3 | 76 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 143 | false | 0 | 3 | 77 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 144 | false | 0 | 3 | 78 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 145 | false | 0 | 3 | 79 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 146 | false | 0 | 3 | 80 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 147 | false | 0 | 3 | 81 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 148 | false | 0 | 3 | 82 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | | 149 | false | 0 | 3 | 83 | 2026-03-10 05:28:54 | 2026-03-10 05:31:29 | +-----+------------------------+---------------+-------------+-------------------------+---------------------+---------------------+ 44 rows in set (0.00 sec)