* id customer_id address_type value1 value2 value3 value4 postal_code

* id type body subject reservation_type

* id Customer_ID RoomTrans_ID Trans_ID Doctype_ID DocDescription DocFileName Employee_ID CreateDateTime

* id Customer_ID NoteType_ID CreateDateTime Employee_ID RecurrenceType_ID RecurrenceMonth RecurrenceDay DiaryDate

* id created_date CreatedBy Surname Initials Title AKA Country_Code_C Country_Code_W Tel_H Tel_W Tel_C EMail GeneralNotes DOB RecMailYN RecSMSYN CustClass_ID CCNumber CCSecurityCode CCCardHolder CCExpiryDate CCCartType_ID Fax EMail2 InvoiceName InvoiceRegNo InvoiceAddress1 InvoiceAddress2 InvoiceAddress3 InvoiceAddress4 Address_Type Newsletter

* id DiaryentryType_ID CreateDateTime Employee_ID Customer_ID Recipient_ID RecurrenceType_ID RecurrenceMonth_ID RecurrenceDay_ID PostDateTime DiaryStatus_ID Note Subject

* id EventType_ID EventDescription EventHost EventGuestHost Booking_ID SalesRep_ID CreateDateTime StartDateTime EndDateTime Room_ID GuestCostPP HostingCostPP TotalHostingCost TotalOtherCost TotalAccomodationCost EventStatus_ID ExpectedGuests Note

* id filename

* id description

* id Area AreaType_ID

* id CardType

* id CorrespondenceType

* id Currency BuyRate SellRate

* id DiaryDay

* id DiaryEntryType

* id DiaryMonth

* id DiaryStatus

* id EventStatus

* id EventType

* id MethodOfPayment DefaultStatus_ID

* id occasion

* id Product_ID Option DisplayOrder

* id Option_ID Selection AddPrepSeconds AddCost DisplayOrder

* id PaymentStatus

* id PointOfSale

* id PrepStation

* id PrepStatus

* id ProductType_ID ProductDepartment

* id ProductType_ID Description Unit UnitPrice AvailableYN PrepStation_ID PrepSeconds QtyOnHand QtyOnOrder

* id ProductType tva

* id RecurrenceType

* id room

* id Session StartTime EndTime

* id session

* id StockAdjustStatus

* id StockAdjustType

* id Area_ID TableDescription TableType_ID Status_ID DailyRate Heads SpecialDailyRate SpecialStartDate SpecialDurationDays Tva Filename RoomHeadDesc RoomFullDesc RoomSizeDesc RoomBedDesc

* id TableType

* id name tax

* id TransactionStatus

* id TransactionType

* id visit_type

* id Waiter ActiveYN EmploymentStartDate EmploymentEndDate EmployeeType_ID EmpWord

* id user_id notes date_created status type page createdBy

* id room_trans_id customer_id description price roomname other_trans_id nights firstnight lastnight

* id create_date room_trans_id customer_id payment_method payment_ref amount_due amount_paid change notes status

* id create_date room_trans_id customer_id product_id qty price total status Notes

* id room_id amenity_id

* id room_id filename main map

* id RoomTrans_ID POS_ID PaymentDateTime MethodOfPayment_ID PaymentStatus_ID PaymentReference ZARAmountDue TenderAmount Currency_ID CurrencyBuyRate PaymentAmount ChangeAmount Employee_ID PaymentDescription

* id Room_ID Product_ID ReqQTY OnHandQTY OrderQTY

* id Room_ID Customer_ID BookingDateTime Status_ID FirstNight LastNight Nights SessionTime SessionDesc AccommodationTotal OtherTotal GrandTotal PaidTotal AlarmYN AlarmTime DailyRate Notes Complaints SalesRep_ID Booking_ID Cancel_ID CancelReason_ID CancelDate StandardDailyRate PriceIncludes ReferredBy Pax SoldBy Identifier CreatedBy Occasion_ID Session_ID Period Customer_ID2

* id session_id slot

* id AdjustDateTime Employee_ID AdjustType_ID StockAdjustStatus_ID

* id StockAdjust_ID Product_ID InputQTY QTYOnHand Adjustment

* id Transaction_ID CreateDateTime SeatIdentification Product_ID ProductDescription PrepGroup_ID NoteToCheff PrepStatus_ID PrepStation_ID PrepSeconds SubUnitCost ChargeQTY SubCost SubOptionalCost SubTotal PrepStartTime

* id TransactionType_ID BookingDateTime AppointmentDateTime Table_ID Identifier Opperator_ID Waiter_ID Status_ID TotalBaseCost TotalOptionalCost TotalPrepMinutes RoomTransaction_ID Customer_ID Pax Gratuity TotalDue TotalPaid SalesRep_ID Booking_ID Cancel_ID CancelReason_ID CancelDate Note ReferredBy Event_ID Session_ID

* id name surname email username password dateCreated role active

* id user_id loginTime logoutTime

select table address communication correspondence customernotes customers diarynotes eventsdiary images l_amenities l_area l_cccardtype l_correspondencetype l_currencyex l_diaryday l_diaryentrytype l_diarymonth l_diarystatus l_eventstatus l_eventtype l_methodofpayment l_occasion l_options l_optionselect l_paymentstatus l_pos l_prepstation l_prepstatus l_proddepartment l_products l_producttype l_recurrencetype l_room l_servsessions l_sessions l_stockadjuststatus l_stockadjusttype l_tables l_tabletype l_tax l_transactionstatus l_transactiontype l_visit_type l_waiter notification other payments productorder roomamenity roomimages roompayments roomstock roomtransactions sessionslot stockadjust stockadjustdetail transactiondetails transactions user useractivity . 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 address communication correspondence customernotes customers diarynotes eventsdiary images l_amenities l_area l_cccardtype l_correspondencetype l_currencyex l_diaryday l_diaryentrytype l_diarymonth l_diarystatus l_eventstatus l_eventtype l_methodofpayment l_occasion l_options l_optionselect l_paymentstatus l_pos l_prepstation l_prepstatus l_proddepartment l_products l_producttype l_recurrencetype l_room l_servsessions l_sessions l_stockadjuststatus l_stockadjusttype l_tables l_tabletype l_tax l_transactionstatus l_transactiontype l_visit_type l_waiter notification other payments productorder roomamenity roomimages roompayments roomstock roomtransactions sessionslot stockadjust stockadjustdetail transactiondetails transactions user useractivity .	select column