Tables:
- refund_status(refund_status_id, description)
- response_received_abandoned(created_at, order_refference_number, payment_id)
- tbl_administrator(administrator_id, user_group_id, username, password, salt, first_name, last_name, email, contact_number, image, ip, is_active, date_added, rep_code, failed_attempt)
- tbl_bank(id, name, bank_code)
- tbl_bank_branch(bank_branch_id, bank_code, branch_code, branch_name)
- tbl_bin_lookup_response(bin_lookup_response_id, order_id, payment_gateway_id, payment_token, reason_code, auth_response, card_type, card_first_six, card_last_four, response_message, date_time_added)
- tbl_block_transaction(block_transaction_id, config_id, setting, remark, start_date, end_date, status, created_at)
- tbl_bpsp_orders(bpsp_order_id, date_added, supplier_id, supplier_invoice_id, supplier_invoice_reference, account_name, account_number, bank_id, bank_branch_id, bearer, subtotal, supplier_fee, merchant_fee, transaction_amount, settlement_amount, master_order_id, mdr_rate, supplier_settlement_status, settlement_request_date_time, settlement_date_time)
- tbl_bpsp_supplier_accounts(supplier_accounts_id, supplier_id, account_name, account_number, bank_id, bank_branch_id, status)
- tbl_bpsp_supplier_types(bpsp_supplier_type_id, supplier_type)
- tbl_bpsp_suppliers(supplier_id, store_id, supplier_store_id, username, business_name, phone_number, business_email, merchant_number, wesite_url, type_of_service, account_name, account_number, bank_id, bank_branch_id, date_added, status)
- tbl_category_code(category_code_id, code, description, is_active, section)
- tbl_ceft(ceft_id, store_id, product_id, master_order_id, payment_status_id, order_refference_number, transaction_amount, ceft_transaction_reference, ceft_amount, ceft_code, ceft_message, ceft_description, ceft_status_id, ceft_details, ceft_datetime, ceft_org_account_no, ceft_org_bank_code, govpay_payment_status_id, govpay_payment_details, govpay_payment_datetime, created_at, updated_at)
- tbl_company_ownership_type(id, description, laravel_db_id)
- tbl_country(country_id, name, iso_code_2, iso_code_3, address_format, postcode_required, status)
- tbl_currency(currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified)
- tbl_device_user(mobile_device_id, user_id, store_id, jwt_token, push_token, info, created_at)
- tbl_email_templates(id, key_value, body, email_subject)
- tbl_exchange_rate(exchange_rate_id, date, currency_id, buying_rate, selling_rate)
- tbl_flagged_payment(flagged_payment_id, payment_id, reason, is_flagged, datetime_added, datetime_updated)
- tbl_gateway_pre_response(pre_response_id, order_id, message)
- tbl_geo_zone(geo_zone_id, name, description, date_modified, date_added)
- tbl_holiday(holiday_id, date)
- tbl_ipg_bin(ipg_bin_id, payment_gateway_id, bin_range_start, bin_range_end, is_active, percentage, date_start, date_expire, description, date_added)
- tbl_ipg_category_code(ipg_category_code_id, ipg_category_code, payment_gateway_id, description, section, rate, merchant_id, store_name, shared_secret, other_data, is_active)
- tbl_ipg_provider(ipg_provider_id, ipg_provider, is_active)
- tbl_ipg_provider_view(ipg_provider_view_id, ipg_provider_id, type, order_id, date_time_added)
- tbl_language(language_id, name, code, locale, image, directory, sort_order, status)
- tbl_log(id, source_ip, user_id, message, datetime, store_id, log_type)
- tbl_log_type(log_type_id, log_type, description)
- tbl_master_log(log_id, log_type, product_id, message, log_from, serialized, create_date, session_id, source_ip)
- tbl_merchant_payout_status(merchant_payout_status_id, description)
- tbl_order(order_id, order_refference_number, store_id, product_id, payment_id, payment_gateway_rate, bank_payment_gateway_rate, total_amount, convenience_fee, payment_status_id, order_status_id, store_payment_gateway_id, store_order_refference_id, payment_customer_id, payment_method_id, gateway_order_id, date_added, payment_currency_id, processing_currency_id, payment_amount_rate, exchange_rate, ip_address, ip_country_code, ip_address_text, unresponsive_payment_status, sub_product_type, tunnel_cms, custom_field, order_type_id, date_order_complete, created_at, sss_tracking_number, sss_test_product_id, sss_order_shipped_date, sss_is_customer_confirmed, sss_is_merchant_confirmed, sss_isInvoiceSent, sss_process_amount, sss_payment_amount, sss_shipping_code, sss_shipping_status_id, bank_mid, payment_gateway_id)
- tbl_order_parent_gateway(order_parent_gateway_id, order_id, payment_gateway_id, payment_gateway_rate, payment_gateway_settlement, payment_gateway_settlement_datetime, parent_gateway_id, parent_gateway_rate)
- tbl_order_request_attempt(order_request_attempt_id, attemp_ref_no, response_ref_no, order_id, store_id, payment_gateway_id, total_amount, request_body, response, status, created_at)
- tbl_order_status(order_status_id, language_id, name)
- tbl_order_type(order_type_id, order_type)
- tbl_other_order_data(other_order_data_id, order_id, other_data_type, other_data, serialized)
- tbl_other_order_data_type(other_order_data_type_id, other_order_data_type)
- tbl_package(package_id, package_name, package_type, is_active, subscription_type)
- tbl_package_plan(package_plan_id, package_id, plan_id, is_active)
- tbl_package_product(package_product_id, package_id, product_id)
- tbl_payment(payment_id, card_owner_name, card_number_first_six, card_number_last_four, card_type, transaction_refference_number, custom_parameter, response_code, response_text, date_time_settlement, date_time_transaction, tested, merchant_payout_status_id, transaction_reference_number, date_time_payout_request, is_flagged, payout_ipg_provider_id, payout_deposit_summery_id)
- tbl_payment_customer(payment_customer_id, first_name, last_name, address_line_one, address_line_two, city, state, postal_code, country_id, email_address, contact_number, country, customer_groupid)
- tbl_payment_day(payment_day_id, payment_day)
- tbl_payment_gateway(payment_gateway_id, payment_gateway_category_id, tenure, description, display, currency_id, rate, logo_url, active, ipg_provider_id, identifier, sort_order, parent_gateway_id, processing_type, logo_name, gateway_type)
- tbl_payment_gateway_category(payment_gateway_category_id, display_name, description, code, sort_order)
- tbl_payment_gateway_request(gateway_request_id, store_id, product_id, master_order_id, order_reference_number, gateway_id, parameter, created_at)
- tbl_payment_gateway_response(payment_gateway_response_id, order_id, order_refference_number, parameter, date_time)
- tbl_payment_method(payment_method_id, description, payment_code)
- tbl_payment_plan(id, name)
- tbl_payment_request_url_log(payment_request_url_log_id, store_id, log_message, issue_count, date_time_added, date_time_updated)
- tbl_payment_request_url_whitelist(whitelist_id, store_id, reason, date_added, status)
- tbl_payment_status(payment_status_id, description)
- tbl_payment_term(payment_term_id, description)
- tbl_payout_deposit_summery(payout_deposit_summery_id, store_id, payout_reference, bank_id, branch_code, account_holder_name, account_number, date_time_added)
- tbl_plan(plan_id, name, bill_every, trial_period, setup_fee, setup_fee_discount, setup_fee_discount_type, recurring_fee, tax_percentage, is_active)
- tbl_pos_store_bank_mid(id, store_id, ipg_provider_id, narration, bank_merchant_mid, mdr_rate, type)
- tbl_pre_auth(pre_auth_id, date_time, order_id, payment_gateway_id, currency_id, amount, auth_transaction_id, bin_lookup_response_id, status, reverse_request_body, reverse_id, reverse_response_code, reverse_response_body, reverse_date_time)
- tbl_product(id, description, setup_fee, monthly_fee, quarterly_discount_rate, annual_discount_rate, is_active)
- tbl_province(province_id, country_id, province, status)
- tbl_refund(refund_id, date, store_id, order_id, processing_currency_id, payment_currency_id, total_amount, refund_amount, exchange_rate, payment_amount_rate, refund_reason_id, other_reason_text, status, approved_date, user_id, merchant_payout_status_id, date_time_settlement, date_time_payout_request, refund_charge, return_dr_status, payout_ipg_provider_id, payout_deposit_summery_id)
- tbl_refund_reason(refund_reason_id, description, type)
- tbl_remarked_order(remarked_order_id, order_id, status)
- tbl_setting(setting_id, key, value)
- tbl_sms_manager(id, invoice_id, store_id, sent_date, report_added, report_added_date)
- tbl_socialmedia(id, fb, tw, goo, insta, skype, youtube)
- tbl_store(store_id, registered_name, is_active, free_trail, doing_business_name, business_registration_number, category_code_id, merchant_number, address_line_one, address_line_two, city, state, postal_code, province_id, country_id, currency_id, email_address, contact_number, company_ownership_type_id, company_ownership_other, server_protocol, store_url, logo_url, average_monthly_sales_volume, average_ticket_size, payment_term_id, payment_term_differ_day, db_name, db_username, db_password, secret_key, public_key, private_key, temp_public_key, temp_private_key, date_registered, credit_review_approved_date, credit_review_status, is_custom_domain, is_own_payment_gateway, average_ticket_count, average_monthly_count, active_date, diactive_date, free_trail_active_date, free_trail_deactive_date, show_webxpay_informations, rm_code, signup_rm_name, website_url, website_ip, lkr_limit, usd_limit, gbp_limit, aud_limit, gateway_name, partner_type_id, partner_id, return_dr_status, payment_day, sub_product_type, restricted_ipg_providers, return_url_web, return_url_app, return_url_webxpay_dashboard, return_url_ip, transaction_notification_url, lkr_refund_charge, is_settlement_hold, size_of_business, is_bpp, checkout_page_version, bpsp_status, bpsp_mdr_rate, subscription_end_date, dashboard_transaction_type_only)
- tbl_store_billing_bank(store_owner_bank_id, store_id, bank_id, branch_code, account_holder_name, account_number)
- tbl_store_bin(store_bin_id, store_id, payment_gateway_id, bin_range_start, bin_range_end, is_active, percentage, date_start, date_expire, description, date_added, date_updated)
- tbl_store_change_request(store_change_request_id, store_id, change_type, table_name, where_field, where_value, column_name, existing_value, change_value, request_user_id, update_user_id, status, description, reject_reason, requested_at, updated_at)
- tbl_store_deduction_types(store_deduction_type_id, store_deduction_type, status)
- tbl_store_deductions(store_deduction_id, reference, store_deduction_type_id, date_time, store_id, currency_id, exchange_rate, description, amount, user_id, merchant_payout_status_id, payout_deposit_summery_id, date_time_payout_request, payout_ipg_provider_id, date_time_settlement)
- tbl_store_gateway_info(store_gateway_info_id, store_id, payment_gateway_id, key_fields, value)
- tbl_store_ipg_category(store_ipg_category_id, store_id, ipg_category_code_id)
- tbl_store_markup(store_markup_id, store_id, markup_rate)
- tbl_store_other_data(store_other_data_id, store_id, other_data_type, store_other_data, serialized)
- tbl_store_owner_kyc(store_owner_id, store_id, first_name, last_name, gender, designation, nic, passport, contact_number, address_line_one, address_line_two, city, state, postal_code, country_id, address_status, address_lived, is_political_person, parliment_of_sri_lanka, provincial_councils, municipal_councils, ministries, police_force, army, air_force, central_bank, goverment_banks, goverment_corporation_institution, high_commissions, judiciary, relation_details, owner_email)
- tbl_store_package_plan(store_package_plan_id, store_id, package_plan_id, is_active, setup_fee, recurring_fee)
- tbl_store_payment_currency(store_payment_currency_id, store_id, payment_currency_id, isActive, date)
- tbl_store_payment_gateway_2(store_payment_gateway_id, store_id, payment_gateway_id, rate, response_url, is_own_payment_gateway, is_active, sandbox_active, convenience_fee_percentage)
- tbl_store_payment_plan(store_payment_plan_id, store_id, payment_plan_id, recurring_fee, setup_fee, date_added)
- tbl_store_product(store_product_id, store_id, product_id, date_added, date_trial_expire, is_active)
- tbl_store_remark(store_remark_id, store_id, date, remark)
- tbl_store_token(store_token_id, store_id, username, password, status, date_added, date_updated)
- tbl_store_token_plan(store_token_plan_id, store_id, token_plan_id, token_count, date_added, status, payment_gateway_id)
- tbl_subscription(subscription_id, store_package_plan_id, created_at, valid_until, type, is_active, last_updated, reason, transaction_history_id, is_paid, recurring_fee)
- tbl_token_merchant(id, store_id, token_username, token_password, first_name, last_name, email, contact_number, address_line1, address_line2, city, state, country, zip_code, currency, secret_key, process_currency, postal_code, user_type, public_key)
- tbl_token_payment(id, customer_token_id, order_id, receipt, message, type, provided_order_number)
- tbl_token_plan(token_plan_id, token_plan, token_count, status)
- tbl_transaction_history(transaction_history_id, transaction_history_type_id, date_time, store_id, currency_id, exchange_rate, description, ipg_value, credit, debit, user_id)
- tbl_transaction_history_type(transaction_history_type_id, transaction_history_type)
- tbl_unresponsive_payment_log(unresponsive_payment_log_id, order_id, order_refference_number, message, date_added, user_id)
- tbl_user(user_id, password, salt, first_name, last_name, email, country_id, contact_number, fax, image, code, ip, access_code, is_active, date_added, google_id, facebook_id, invalid_locked_removalll, invalid_attempt_count, invalid_locked_removal, jwt_token)
- tbl_user_addons(id, store_id, addons_id, status_id)
- tbl_user_group(user_group_id, description, permission)
- tbl_user_store_access(user_store_access_id, store_id, user_id, user_group_id, access_code, date_added, is_active)
- tbl_webx_partners(webx_partner_id, description, transaction_code, rate)
- tbl_xgo_data(xgo_data_id, store_id, xgo_lkr_monthly_limit, xgo_usd_monthly_limit, xgo_promo_lkr_monthly_limit, xgo_promo_usd_monthly_limit)
- tbl_zone(zone_id, country_id, name, code, status, province_id)
- tbl_zone_to_geo_zone(zone_to_geo_zone_id, country_id, zone_id, geo_zone_id, date_added, date_modified)
- xxx_test(id, date_time, message)