| Name | Description | Type | Additional information |
|---|---|---|---|
| name | string |
None. |
|
| identification_id | string |
None. |
|
| email_id | string |
None. |
|
| mobile_no | string |
None. |
|
| userlogin_id | integer |
None. |
|
| last_login | date |
None. |
|
| update_by | string |
None. |
|
| user_dateofbirth | string |
None. |
|
| user_gendercode | string |
None. |
|
| address1 | string |
None. |
|
| address2 | string |
None. |
|
| country_id | integer |
None. |
|
| state_id | integer |
None. |
|
| state_name | string |
None. |
|
| postcodeid | string |
None. |
|
| user_type | string |
None. |
|
| user_id | integer |
None. |
|
| description | string |
None. |
|
| action_menu | string |
None. |
|
| user_password | string |
None. |
|
| user_newpassword | string |
None. |
|
| company_name | string |
None. |
|
| company_regno | string |
None. |
|
| phone_no | string |
None. |
|
| company_email | string |
None. |
|
| signup_category | integer |
None. |
|
| device_type | string |
None. |
|
| device_id | string |
None. |
|
| fcm_id | string |
None. |
|
| reg_id | integer |
None. |
|
| portal_url | string |
None. |
|
| voucher_cat_id | integer |
None. |
|
| voucher_code | string |
None. |
|
| voucher_name | string |
None. |
|
| sub_category_desc | string |
None. |
|
| voucher_id | integer |
None. |
|
| voucher_sub_cat_id | integer |
None. |
|
| voucher_desc | string |
None. |
|
| redeem_offer | string |
None. |
|
| reservation | string |
None. |
|
| redeem_instruction | string |
None. |
|
| redeem_offer_at | integer |
None. |
|
| isSst | integer |
None. |
|
| voucher_image | string |
None. |
|
| voucher_image2 | string |
None. |
|
| voucher_image3 | string |
None. |
|
| voucher_image4 | string |
None. |
|
| voucher_image5 | string |
None. |
|
| original_price | decimal number |
None. |
|
| discount_price | decimal number |
None. |
|
| saving_price | decimal number |
None. |
|
| total_price | decimal number |
None. |
|
| qty | integer |
None. |
|
| bought | integer |
None. |
|
| start_dt | date |
None. |
|
| end_dt | date |
None. |
|
| point | integer |
None. |
|
| voucher_fee | decimal number |
None. |
|
| generated_by | string |
None. |
|
| voucher_category | string |
None. |
|
| voucher_sub_category | string |
None. |
|
| item_type | string |
None. |
|
| password_history | string |
None. |
|
| passwordExpiry_type | string |
None. |
|
| password_expirydays | string |
None. |
|
| change_password | string |
None. |
|
| password_length | string |
None. |
|
| minimum_numeric | string |
None. |
|
| minimum_alpha | string |
None. |
|
| upper_characters | string |
None. |
|
| lowercase_characters | string |
None. |
|
| minimum_age | string |
None. |
|
| password_remaind | string |
None. |
|
| multi_login | string |
None. |
|
| security_question | string |
None. |
|
| maximum_logonretry | string |
None. |
|
| logonretry_tmes | string |
None. |
|
| maximum_session | string |
None. |
|
| user_lockout | string |
None. |
|
| inactive_account | string |
None. |
|
| prev_id | integer |
None. |
|
| search_value | string |
None. |
|
| frdt | string |
None. |
|
| todt | string |
None. |
|
| approved_status | string |
None. |
|
| joining_id | integer |
None. |
|
| joining_category_id | integer |
None. |
|
| merchandise_cat_id | integer |
None. |
|
| merchandise_code | string |
None. |
|
| merchandise_name | string |
None. |
|
| merchandise_id | integer |
None. |
|
| merchandise_desc | string |
None. |
|
| merchandise_redeem_offer | string |
None. |
|
| merchandise_redeem_instruction | string |
None. |
|
| merchandise_redeem_offer_at | integer |
None. |
|
| merchandise_logo | string |
None. |
|
| redeemed | integer |
None. |
|
| point_to_redeem | integer |
None. |
|
| reward_id | integer |
None. |
|
| modified_by | string |
None. |
|
| trans_amount | decimal number |
None. |
|
| rewardPoint | integer |
None. |
|
| community_id | integer |
None. |
|
| card_no | string |
None. |
|
| type | string |
None. |
|
| payment_type | string |
None. |
|
| card_status | string |
None. |
|
| membership_no | string |
None. |
|
| myfare_card_no | string |
None. |
|
| rfid_tag_no | string |
None. |
|
| kmfrom | integer |
None. |
|
| kmto | integer |
None. |
|
| delivery_charges | string |
None. |
|
| merchant_com | string |
None. |
|
| rider_com | string |
None. |
|
| party_com | string |
None. |
|
| delivery_time | string |
None. |
|
| source_user_id | integer |
None. |
|
| source_role_id | integer |
None. |
|
| destination_user_id | integer |
None. |
|
| destination_role_id | integer |
None. |
|
| star_ratings | integer |
None. |
|
| ratings | string |
None. |
|
| senderuserid | string |
None. |
|
| recieveruserid | string |
None. |
|
| channelid | string |
None. |
|
| chanelcode | string |
None. |
|
| channelname | string |
None. |
|
| port | string |
None. |
|
| subscriberid | string |
None. |
|
| errorcode | string |
None. |
|
| error_desc | string |
None. |
|
| messagetext | string |
None. |
|
| checkout_status | integer |
None. |
|
| fc_id | integer |
None. |
|
| f_id | integer |
None. |
|
| fd_id | integer |
None. |
|
| facility_name | string |
None. |
|
| facility_desc | string |
None. |
|
| facility_address | string |
None. |
|
| capacity | string |
None. |
|
| measurements | string |
None. |
|
| price_per_day_night | decimal number |
None. |
|
| room_name | string |
None. |
|
| room_qty | integer |
None. |
|
| map_url | string |
None. |
|
| vacancy_availability | integer |
None. |
|
| image_one | string |
None. |
|
| image_two | string |
None. |
|
| image_three | string |
None. |
|
| image_four | string |
None. |
|
| image_five | string |
None. |
|
| item_name | string |
None. |
|
| item_qty | integer |
None. |
|
| fimg_id | integer |
None. |
|
| booking_id | integer |
None. |
|
| customer_id | integer |
None. |
|
| role | string |
None. |
|
| role_desc | string |
None. |
|
| content_id | integer |
None. |
|
| content_catCode | string |
None. |
|
| city_id | integer |
None. |
|
| city_name | string |
None. |
|
| postcode | string |
None. |
|
| active_status | integer |
None. |
|
| created_by | string |
None. |
|
| search_param | string |
None. |
|
| merchant_id | integer |
None. |
|
| merchant_code | string |
None. |
|
| organization_name | string |
None. |
|
| merchant_cat_id | integer |
None. |
|
| company_reg_number | string |
None. |
|
| person_incharge | string |
None. |
|
| mobile_phone | string |
None. |
|
| office_phone | string |
None. |
|
| fax_no | string |
None. |
|
| address_1 | string |
None. |
|
| address_2 | string |
None. |
|
| string |
None. |
||
| website | string |
None. |
|
| merchant_logo | string |
None. |
|
| user_by | string |
None. |
|
| fees_category | string |
None. |
|
| per_voucher_chargesby_percent | string |
None. |
|
| per_voucher_chargesby_rm | decimal number |
None. |
|
| yearly_one_time_charges_rm | decimal number |
None. |
|
| is_premium_merchant | integer |
None. |
|
| premium_fees | decimal number |
None. |
|
| start_date | string |
None. |
|
| end_date | string |
None. |
|
| doc_id | integer |
None. |
|
| document_name | string |
None. |
|
| doc_file_path | string |
None. |
|
| doc_date | date |
None. |
|
| branch_id | integer |
None. |
|
| branch_name | string |
None. |
|
| longitude | string |
None. |
|
| latitude | string |
None. |
|
| map_path | string |
None. |
|
| remarks | string |
None. |
|
| merchant_category | string |
None. |
|
| user_fistname | string |
None. |
|
| mdr_charges_type | string |
None. |
|
| mdr_bank_fees | decimal number |
None. |
|
| mdr_chargesby_rm | decimal number |
None. |
|
| mdr_chargesby_percent | string |
None. |
|
| mdr_min_fees | decimal number |
None. |
|
| account_id | string |
None. |
|
| login_flag | integer |
None. |
|
| cheque_description | string |
None. |
|
| cheque_no | string |
None. |
|
| cheque_image_file_name | string |
None. |
|
| mifare_card_no | string |
None. |
|
| membership_card_no | string |
None. |
|
| bank_account_no | string |
None. |
|
| promo_id | integer |
None. |
|
| promo_type | string |
None. |
|
| product_voucher_id | string |
None. |
|
| product_voucher_name | string |
None. |
|
| product_voucher_category | string |
None. |
|
| product_voucher_description | string |
None. |
|
| redeem_point | integer |
None. |
|
| redeem_status | string |
None. |
|
| role_id | integer |
None. |
|
| user_name | string |
None. |
|
| password | string |
None. |
|
| FromDate | string |
None. |
|
| ToDate | string |
None. |
|
| search_key | string |
None. |
|
| promocode_id | integer |
None. |
|
| promocode_name | string |
None. |
|
| promocode_type_id | integer |
None. |
|
| promocode_category_id | integer |
None. |
|
| amount | decimal number |
None. |
|
| percentage | string |
None. |
|
| updated_by | string |
None. |
|
| content_category_code | string |
None. |
|
| content_code | string |
None. |
|
| content_title | string |
None. |
|
| content_description | string |
None. |
|
| content_description1 | string |
None. |
|
| image_path | string |
None. |
|
| product_id | integer |
None. |
|
| product_qty | integer |
None. |
|
| product_price | decimal number |
None. |
|
| total_amount | decimal number |
None. |
|
| session_id | string |
None. |
|
| ID | integer |
None. |
|
| hp_no | string |
None. |
|
| subject | string |
None. |
|
| message | string |
None. |
|
| reply_by | string |
None. |
|
| reply_msg | string |
None. |
|
| reply_status | integer |
None. |
|
| StatusVal | integer |
None. |
|
| orderid | string |
None. |
|
| order_no | string |
None. |
|
| payment_mode | string |
None. |
|
| transaction_id | string |
None. |
|
| transaction_status | string |
None. |
|
| transaction_time | string |
None. |
|
| userloginid | string |
None. |
|
| transaction_amount | string |
None. |
|
| comments | string |
None. |
|
| rating | string |
None. |
|
| ref_code | string |
None. |
|
| ref_link | string |
None. |
|
| merchant_number | string |
None. |
|
| client_id | string |
None. |
|
| appname | string |
None. |
|
| bank | string |
None. |
|
| virtual_account | string |
None. |
|
| bank_name | string |
None. |
|
| account_cardno | string |
None. |
|
| card_type | string |
None. |
|
| transaction_no | string |
None. |
|
| transaction_date | string |
None. |
|
| transaction_mode | string |
None. |
|
| transaction_point | integer |
None. |
|
| site_id | integer |
None. |
|
| token_amount | string |
None. |
|
| token_no | string |
None. |
|
| result | string |
None. |
|
| token_id | integer |
None. |
|
| sst | decimal number |
None. |
|
| tax_id | integer |
None. |
|
| created_date | date |
None. |
|
| updated_date | date |
None. |
|
| tax_name | string |
None. |
|
| redeem_id | integer |
None. |
|
| branchid | string |
None. |
|
| notification_id | integer |
None. |
|
| id | integer |
None. |
|
| order_id | integer |
None. |
|
| feedback_id | integer |
None. |
|
| currency_id | integer |
None. |
|
| Amount | decimal number |
None. |
|
| minimum_point | integer |
None. |
|
| maximum_point | integer |
None. |
|
| Point | decimal number |
None. |
|
| currency_type_id | integer |
None. |
|
| currency_type | string |
None. |
|
| pin_id | integer |
None. |
|
| pin_no | string |
None. |
|
| sp_id | integer |
None. |
|
| community_name | string |
None. |
|
| community_url | string |
None. |
|
| community_det_id | integer |
None. |
|
| telephone_phone | string |
None. |
|
| pic_phone | string |
None. |
|
| communityparams | string |
None. |
|
| default_address | integer |
None. |
|
| address_type | string |
None. |
|
| commission_id | integer |
None. |
|
| commission_holder_id | integer |
None. |
|
| product_category_id | integer |
None. |
|
| commission_type | string |
None. |
|
| commission_value | decimal number |
None. |
|
| scheme_operator_id | integer |
None. |
|
| agent_name | string |
None. |
|
| category_id | integer |
None. |
|
| rebate_rate | decimal number |
None. |
|
| rebate_comm_id | integer |
None. |
|
| sch_op_comm | decimal number |
None. |
|
| agent_comm | decimal number |
None. |
|
| merchat_comm | decimal number |
None. |
|
| outlet_comm | decimal number |
None. |
|
| users_comm | decimal number |
None. |
|
| total_comm | decimal number |
None. |
|
| c_month | integer |
None. |
|
| c_year | integer |
None. |
|
| report_type | string |
None. |
|
| merchant_name | string |
None. |
|
| email_status | integer |
None. |
|
| sms_status | integer |
None. |
|
| outlet_id | integer |
None. |
|
| available_amount | decimal number |
None. |
|
| requested_amount | decimal number |
None. |
|
| accno | string |
None. |
|
| refno | string |
None. |
|
| status | integer |
None. |
|
| verifyflag | integer |
None. |
|
| auto_payment_status | integer |
None. |
|
| fromEmail | string |
None. |
|
| toEmail | string |
None. |
|
| filePath | string |
None. |
|
| fromName | string |
None. |
|
| toNumber | string |
None. |
|
| withdraw_id | integer |
None. |
|
| notification_type | string |
None. |
|
| notification_title | string |
None. |
|
| notification_summary | string |
None. |
|
| doc_type | string |
None. |
|
| agent_id | integer |
None. |
|
| agreement_file | string |
None. |
|
| rider_id | integer |
None. |
|
| delivery_status | string |
None. |
|
| no_of_orders | integer |
None. |
|
| totalcommission_earned | decimal number |
None. |
|
| totalcommission_settle | decimal number |
None. |
|
| settlement_slip | string |
None. |
|
| balance_due | string |
None. |
|
| transaction_type | string |
None. |
|
| invoice_no | string |
None. |
|
| file_path | string |
None. |
|
| corpid | integer |
None. |
|
| pay_id | integer |
None. |
|
| reg_no | string |
None. |
|
| reg_no2 | string |
None. |
|
| reg_no3 | string |
None. |
|
| nationality | string |
None. |
|
| identification_id_type | integer |
None. |
|
| tenancy_type | string |
None. |
|
| bay_type | string |
None. |
|
| corp_name | string |
None. |
|
| corp_regNo | string |
None. |
|
| pic_nric | string |
None. |
|
| pic_mobile | string |
None. |
|
| pic_name | string |
None. |
|
| request_type_id | integer |
None. |
|
| status_id | integer |
None. |
|
| month_from | string |
None. |
|
| month_to | string |
None. |
|
| year_from | string |
None. |
|
| year_to | string |
None. |
|
| date_from | string |
None. |
|
| date_to | string |
None. |
|
| req_type | string |
None. |
|
| card_type_id | integer |
None. |
|
| reason_id | integer |
None. |
|
| suspend_file | string |
None. |
|
| approve_status | integer |
None. |
|
| acc_no | string |
None. |
|
| no_of_month | integer |
None. |
|
| card_id | integer |
None. |
|
| total_trans_amount | string |
None. |
|
| vehicle_id | string |
None. |
|
| purchase_status | integer |
None. |
|
| month | string |
None. |
|
| year | string |
None. |
|
| corp_id | integer |
None. |
|
| outstandingmonth | integer |
None. |
|
| payformonth | integer |
None. |
|
| transaction_date1 | date |
None. |
|
| season_type_id | integer |
None. |
|
| user_category | string |
None. |
|
| rate_flag | string |
None. |
|
| monthly_price | string |
None. |
|
| Product_code | string |
None. |
|
| Product_name | string |
None. |
|
| Product_cat_id | integer |
None. |
|
| Product_sub_cat_id | integer |
None. |
|
| Product_desc | string |
None. |
|
| Purchase_instruction | string |
None. |
|
| Product_image | string |
None. |
|
| Product_image2 | string |
None. |
|
| Product_image3 | string |
None. |
|
| Product_image4 | string |
None. |
|
| Product_image5 | string |
None. |
|
| Product_fee | decimal number |
None. |
|
| product_Outlet | integer |
None. |
|
| product_percent_wise | string |
None. |
|
| product_price_wise | decimal number |
None. |
|
| product_cashback_category | string |
None. |
|
| product_del_opt | string |
None. |
|
| product_category | string |
None. |
|
| cashback_type | string |
None. |
|
| cashback_amount | decimal number |
None. |
|
| rebate_status | string |
None. |
|
| rebate_amount | decimal number |
None. |
|
| delivery_distance | decimal number |
None. |
|
| source_latitude | string |
None. |
|
| source_longitude | string |
None. |
|
| destination_latitude | string |
None. |
|
| destination_longitude | string |
None. |
|
| delivery_charge | decimal number |
None. |
|
| sstvalue | decimal number |
None. |
|
| start_time | string |
None. |
|
| end_time | string |
None. |
|
| duration_hr | string |
None. |
|
| duration_min | string |
None. |
|
| total_days | integer |
None. |
|
| payment_status | string |
None. |
|
| booking_no | string |
None. |
|
| TID | string |
None. |
|
| api_key | string |
None. |
|
| checksum | string |
None. |
|
| sportsTypeId | integer |
None. |