* assc_id BankName ClassName Quantity QtyDisposal QtyAuction QtyTransfer BlockPrice BlockType otherCost ActualCost TotalCost

* Assess_id Asstype AssBrand AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate OldBranch NewBranch InputterBranch ContOrder Username

* Assess_id Asstype AssBrand AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate OldBranch NewBranch InputterBranch ContOrder Username

* Assess_id Asstype AssBrand AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate OldBranch NewBranch InputterBranch ContOrder Username

* Assess_id Asstype AssBrand AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate OldBranch NewBranch InputterBranch ContOrder Username

* Assess_id Asstype AssBrand AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate InputterBranch

* bankid bankname

* bb_id BankName BranchName Quantity QtyDisposal QtyAuction QtyTransferFrom QtyTransferTo

* id CCB_asset_tag phone_number branch department assigned_to status last_lat last_lon last_seen consent_signed created_at

* id asset_id asset_tag phone lat lng accuracy last_seen source

* assign_id asset_id asset_tag assigned_to gender department assigned_date returned_at condition_at_issue return_condition assigned_by returned_by remarks branch status created_at staff_id phone lat lng

* detail_id audit_id asset_id asset_tag expected_branch verified_status condition_status actual_location remarks verified_by verified_at photo_count

* photo_id detail_id audit_id asset_tag photo_path uploaded_by uploaded_at

* audit_id audit_name branch audit_date status total_assets verified_count created_by created_at

* cat_id cat_name dep_rate useful_life_years gl_code created_at

* log_id asset_id dep_month dep_amount acc_dep_after nbv_after created_at

* asset_id asset_tag asset_name description cat_id branch location supplier invoice_no purchase_date cost residual_value useful_life_months dep_method dep_rate acc_dep nbv status disposal_date disposal_value created_by created_at

* transfer_id asset_id from_branch to_branch transfer_date reason transferred_by created_at

* transfer_id asset_id from_user to_user transfer_date reason transferred_by branch created_at

* id incidentId name mime size data created item_type type sendername

* id incidentId name mime size data created item_type type sendername

* id phone_number email_to assigned_to branch gmail_subject gmail_body sent_by status created_at

* id gcb_asset_tag phone_number gmail branch department assigned_to accno staff_id consent_signed consent_date status last_lat last_lon last_accuracy last_seen registered_by created_at updated_at

* id phone_number phone_gateway assigned_to email_to sms_body branch status created_at

* incide_id incidentnumber Template_Type Bankname Agencyname ContactNum Description Statustype IssueLogBy IssueAssignTo IssueSolution IssueLogDate IssueResolveDate IssueStatus PriorityStatus IssueAssignedDateT AddNotesUp AddNotesUpDate dateTimeS Messalert fnameAdm

* incide_id incidentnumber Template_Type Bankname Agencyname ContactNum Description Statustype IssueLogBy IssueAssignTo IssueSolution IssueLogDate IssueResolveDate IssueStatus PriorityStatus IssueAssignedDateT

* incide_id incidentnumber Template_Type Staffname AppSdate AppEdate Appdays Bankname Agencyname ContactNum Description Statustype IssueLogBy IssueAssignTo IssueSolution IssueLogDate IssueResolveDate IssueStatus PriorityStatus IssueAssignedDateT AddNotesUp AddNotesUpDate dateTimeS Messalert

* incid_id IncidentTemplate type

* incid_id IncidentTemplate type

* incid_id IncidentTemplate type

* id Status

* mss_id FromSender ToSender Message

* id incidentnumber NotesHistory NotesDate

* title_id titlename

* upload_id upload_date Narration CustomerName Credit_Amount Debit_Amount Debit_AccountNumber Credit_AccountNumber Company Status Upload_By Upload_Month upload_day UploadYear upload_time Authoriser Transid Paid_By Paid_Month Paid_Year Paid_Day Paid_Date Paid_Contact1 Paid_Contact2 Paid_Time Approval_Time idtype idnumber BankBranch ServiceCharge UploadAmount

* upload_id upload_date Narration CustomerName Credit_Amount Debit_Amount Debit_AccountNumber Credit_AccountNumber Company Status Upload_By Upload_Month upload_day UploadYear upload_time Authoriser Transid Paid_By Paid_Month Paid_Year Paid_Day Paid_Date Paid_Contact1 Paid_Contact2 Paid_Time Approval_Time idtype idnumber BankBranch

* userid username Password AccountNum contactnumber BankBranch AccountType SignOnName fullname StatusType Designation Designation2 UserBranch Fname Mname Lname DefaultPassword FullNamek Tdate LogInStatus Messalert1

* UserT_id User_tup

select table assetsclass assetsregister assetsregister2 assetsregister3 assetsregisterold assetsregistert bank bankbranch ccb_phone_registry fa_asset_locations fa_assignments fa_audit_details fa_audit_photos fa_audit_sessions fa_categories fa_depreciation_log fa_register fa_transfers fa_user_transfers file fileleave gcb_gmail_inbox gcb_phone_registry gcb_sms_inbox incidentdescr incidentdescrit incidentdescrleave incidenttype incidenttypeit incidenttypeleave issuestatus messagealert notetable title transtable transtablejournal usertable usertype . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table assetsclass assetsregister assetsregister2 assetsregister3 assetsregisterold assetsregistert bank bankbranch ccb_phone_registry fa_asset_locations fa_assignments fa_audit_details fa_audit_photos fa_audit_sessions fa_categories fa_depreciation_log fa_register fa_transfers fa_user_transfers file fileleave gcb_gmail_inbox gcb_phone_registry gcb_sms_inbox incidentdescr incidentdescrit incidentdescrleave incidenttype incidenttypeit incidenttypeleave issuestatus messagealert notetable title transtable transtablejournal usertable usertype .	select column