* ID GID ACID GEN_NAMES account_code account_description CLASSIFICATION SUBLASS t_account GEN_CODE CLASSIFICATION_CODE SUBCLASS_CODE markcontra ACCOUNT_SPACE

* id acid origCode Ncode NewCode Account

* ID GenID GENCODE GENNAME GroupID GROUPCODE GROUPNAME TypeID TYPES SUBTYPES TypeCode

* ID GenID GENCODE GENNAME GroupID GROUPCODE GROUPNAME TypeCode TYPES STATUS CF

* ID GenID GENCODE GENNAME GroupID GROUPCODE GROUPNAME TypeCode TYPES STATUS CF

* id code desc status GENID

* id type

* id code name

* ID DepartmentId AccountID DESCRIPT t_f

* account_id MAINID account_code account_description GENCODE GENNAME CLASSID CLASSCODE classname SUBCLASSID SUBCLASSCODE SUBCLASSNAME SUBCLASS2ID SUBCLASS2NAME SUBCLASS2ORDER t_account Bank ledger status OwnerTitle_id explanation levels visibleinentry CF Contra BudgetType AppropParentId migrated mapToId ParentCode L0 L1 L2 L3 L4 CFGroupID ISCIB ISCASH

* account_id account_code account_description GENCODE GENNAME CLASSID CLASSCODE classname MAINID SUBCLASSID SUBCLASSCODE SUBCLASSNAME t_account Bank ledger status OwnerTitle_id explanation levels visibleinentry GID GID1 CF Contra ActCode Book Dept Proj Unit IsUnit IsProject IsSubSidiary BudgetType AppropParentId migrated mapToId

* account_id account_code account_description GENCODE GENNAME CLASSID CLASSCODE classname MAINID SUBCLASSID SUBCLASSCODE SUBCLASSNAME t_account Bank ledger status OwnerTitle_id explanation levels visibleinentry GID GID1 CF Contra ActCode Book Dept Proj Unit IsUnit IsProject IsSubSidiary BudgetType Balance

* account_id account_code account_description sub_class_code classification_code account_type t_account contra_account bank ledger status ArrangeAssets OwnerTitle_id explanation markcontra

* account_id account_code account_description GENCODE GENNAME CLASSID CLASSCODE classname MAINID SUBCLASSID SUBCLASSCODE SUBCLASSNAME t_account Bank ledger status OwnerTitle_id explanation levels visibleinentry GID GID1 CF Contra ActCode Book Dept Proj Unit IsUnit IsProject IsSubSidiary BudgetType AppropParentId migrated mapToId

* account_id account_code account_description GENCODE GENNAME CLASSID CLASSCODE classname MAINID SUBCLASSID SUBCLASSCODE SUBCLASSNAME t_account Bank ledger status OwnerTitle_id explanation levels visibleinentry GID GID1 CF Contra ActCode Book Dept Proj Unit IsUnit IsProject IsSubSidiary BudgetType AppropParentId migrated mapToId

* account_id account_code account_description GENCODE GENNAME CLASSID CLASSCODE classname MAINID SUBCLASSID SUBCLASSCODE SUBCLASSNAME t_account Bank ledger status OwnerTitle_id explanation levels visibleinentry GID GID1 CF Contra ActCode Book Dept Proj Unit IsUnit IsProject IsSubSidiary BudgetType AppropParentId migrated mapToId

* ID TYPE

* ID JID reference_no status amount custID ts

* ID AMOUNT_DOWN JID tstamp STATUS CHK REFERENCE SUPPLIERID SUPPLIERNNAME CHECKDATE TRANSDATE GUID LOC COMPID PAYEEID PAYEE_TYPE PAYEE ACID SUBTYPE SUBID PETTY_GRP REMARKS WT RAD SERIES WTAX RATE WTXACID ATCID

* ID advid JID AMOUNT STATUS GUID

* ID MainID GUID AccountNum CheckNum CheckDate PayeeName Amount JID Memo

* ID GUID SOFID SOF ToAddress ContactNum AdviceDate PreparedID PreparedName PreparedPosition ApprovedID ApprovedName ApprovedPosition DeliveredBy ReceivedBy TS UID Status CancelledBy CancelledReason CancelleddateTime

* ID AGENTID AGENT_NAME AMT TDATE UID JID REF GUID TS REMARKS

* ID JID BaseDate REFNUM PID

* id REQUEST_TYPE Amount

* ID FrmName FrmCaption TransactedByID TransactedBy CompID UID TimeLog Actions TS VerifiedData PCName IPADD

* IDENTITY TYPE StartDate EndDate AllDay SUBJECT Location Description STATUS Label ResourceID ResourceIDs ReminderInfo RecurrenceInfo TimeZoneId CustomField1 PK_Appointments PRJID

* ID DATE PARENTGUID CHILD_GUID APVNUMBER APVDOCNUM ORIGVENDORID NEWVENDORID COSTCENTERID BIRCOLUMN EWTACID ATC ATC_RATE VNV AMT TAXAMT EWTAMT PARTICULARS TS UID ATCID STATUS

* id countered_entry_id cntrid debit credit costcenterd_id uid sup_id acid GUID

* ID JID APVNUM LOC TITLE YYYY PO INV GRPS MM

* ID JID APVNUM LOC TITLE YYYY PO INV GRPS MM

* ID APV_DATE APVNUM DUEDATE SIAS SIDate AMT ATC ATCPERCENT RATE ATC_DESCRIPTION TINNUM SUPID VendorName PAYEEID TS STATUS GUID JID TITLEID PRJIDx UID REMARKS SIRemarks SourceGUID TRANSNAME Address Class ApprovedBy ReviewedBy ApprovedStatus PmtStat GSB imported_from_excel

* ID JID ACID TS GRP

* id main_group main description

* ID DESCRIPTION Goodservice ATC RATE ACID CACID CID Groups BIR_FORMS imported_from_excel catx

* ID ATC Rate

* ID DESCRIPTION Goodservice ATC RATE ACID CACID CID Groups BID

* id AD_number emp_name transdate emp_dept dept_id reporting_manager user_id

* id AD_number amount full_on_date full_on_amt installment_amt installment_from installment_to comments

* ID ACID account_description BS_group BSGroup_description Status

* ID GUID AccountID AccountName SOFID SOFName StatementDate BalancePerBook AdjustmentAdd AdjustmentLess AdjustedBook BalancePerBank IntransitCleared OutstandingCleared AdjustedBank UID TS Status

* ID JID GRP ACCOUNTID SAVE_DATE ReportedBankBalance AmountBeforeRecon asofdate GUID ReconDates Orig_guid drcr AMT Recon_gui

* ID REFERENCE CODE VENDOR BALANCE TS

* ID REFERENCE CODE VENDOR RECIEVABLE TS

* ID ACID DRCR SIDATE DUEDATE SI AMT TS

* ID ACID CODE DESCRIPTION JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YR GID GID1 ACCOUNTSPACE MAINID OFFICE COST_CENTER DRCR SUBTYPE ISBANK

* ID equipmentID BILL_NO CUSTOMER LOCATION TITLEID FL CTYPE trans_date reference start_time end_time unit rate location_frm location_to REMARKS TRIPS_NUM KM TS JID GUID UID dispatchid refnum operators DTLS EQUIPMENT DEPARTMENT DEPID entry_date ITEMDESCRIPTION

* bill_id bill_projectNo bill_projectname bill_requesteddate bill_requestpercentage bill_requestdetails bill_requestamount bill_requestremarks bill_date bill_percentage bill_details bill_amount bill_recoupment bill_vat2 bill_vat5 bill_others bill_incometax1 bill_royalty bill_birdue bill_bonds bill_otherssubcon bill_amountNet bill_remarks saved_date bill_actualAccomplished bill_subcon PROJECT_ID RETENTION JID

* ID JID DTL_ID ACCOUNT_ID AMOUNT ORNUM ORDATE BLID ACCOUNT_DESC CONTAINER CID

* ID Year series titleid JID ref SUBID tstamp

* ID Description

* id Type_ Value_

* ID EMPID TDATE REF AMT RELEASEDBY STATUS TS LOCATION CANCEL_reason memo custodian supervisor

* ID ReleasedID EMPID TS STATUS LIQ_JID GRP

* ID dates costcenter resolutionApproved policiesPass DirectorsFee Held regular special seminar ts uid STATUS GID

* id beginning_id SI_num SI_date SI_amount due_date PRJID LOC_TYPE CID STATUS SUPID

* id beginning_id SI_num SI_date SI_amount due_date PRJID LOC_TYPE CID STATUS SUPID

* ID M_Group MainGroup SubGroup1 SubGroup2 GroupOrder STATUS

* ID BudgetName

* ID JID REF GUID DATES EMPID MEMOS AMOUNT UID status tstamp COMPANYCODE DEPTCODE CASH_ACID FUND_LOC LOCATION_ SUBSIDIARY NAME_TYPES JE_SERIES SUBACCOUNTID subsidiary_type bank account_type

* id CA_number emp_name emp_dept emp_status trans_date reporting_manager installment_amt Comments dept_id emp_id user_id

* ID GUID TransDate IsPrior AccountId fundType unliquidatedCA grantCA liquidation balance

* id CA_number Reason Amount Payable_date_from Payable_date_to

* ID JOURNAL_ID DRCR

* ID ACID account_description CF_group CFGroup_description Status

* ID ACID account_description CF_group CFGroup_description Status

* CLRFNumber CLEmpName CLProjCode CLProjName CLLocation CLDate CLAmount CLPeriodfrom CLPeriodto CLGrossAmount sss hdmf cassd metrobank bdo

* id JID cv COMPANY YEAR TSTAMP groupentry

* SysPK_CshAdv SysFK_Empl_CshAdv UserCode_CshAdv Name_CshAdv DateTrans_CshAdv Amount_CshAdv Balance_CshAdv Terms_CshAdv AmortAmount_CshAdv Remarks_CshAdv Description_CshAdv CompanyCode ProjectCode deductionType EMP_ID

* id REQREF DRAFT_NUM DRAFT_IDEN UID LNAME FNAME EMP_STAT TRANS_DATE REPORTING_MANAGER PAYEE INSTALLMENT_AMT PROJECT CLIENT_NAME STATUS Notes GUID TS DEADLINE DEPT ISRELEASED

* ID CAID REASON AMOUNT AMT_APPROVED PAYABLE_DT_FRM PAYABLE_DT_TO MAINID TITLEID PRJID PROJECT PAYEE PAYEE_ID GUID STATUS CLIENT_NAME DEPT CLIENT_ID RELEASEDCASH

* ID REF_OLD OLD_JID REF_NEW JID DATE_LIQ EMPID MEMO AMOUNT UID status CV tstamp GROUP CASL_GUID RELASED_ID JE_SERIES SUPID GROSS VAT NET OR# NATURE

* ID JID CUSTID ACCOUNTID SHIPPING AMOUNT ORNUM DATE_PAID CONTAINER PROCESSOR TSTAMP status CASL_GUID

* id journal_details_id TIN REMARKS INV_NUM Suppliername SUPID JID caslID

* ID JID GROUPS

* ID JID REF GUID DATES EMPID MEMOS AMOUNT UID status tstamp COMPANYCODE DEPTCODE CASH_ACID FUND_LOC LOCATION_ PAYEE_ID NAME_TYPES JE_SERIES

* ID MainGroup GroupOrder STATUS

* ID MainGroup SubGroup1 SubGroup2 GroupOrder STATUS

* ID CF_GROUPID CF_GRP_DESCRIPTION ACID ACODE

* ID CF_NAME STATUS ORDER TYPE FLOW

* ID TAXPERCENT JID VATABLE

* id TYPE_ AMOUNT

* ID NAMES1 POSITIONS1 NAMES2 POSITIONS2

* ID JID ACID BANK_NAME CHECKNUMBER CHECKDATES PAYEE PAYEE_TYPES PAYEEID Groups USERSID CVNUMBER RECON_STAT AMT CID VENDORSNAME VENDORSID

* ID JID ACID BANK_NAME CHECKNUMBER CHECKDATES PAYEE PAYEEID Groups USERSID RECON_STAT AMT CID PAYEE_TYPES

* id supplier_id supplier_name acid account_description check_number check_date date_recieve recieveby

* ID VendorName PayeeName Types Number ORDate ReleasedDate ReleasedBy ReleasedNote Address TIN CheckDate CheckNum CVDate CVNum Account CheckPrepGUID TS JID

* ID ACCTID ACCTNAME CHECK_NUM CHECKDATE AMOUNT DRCR UID COMPID PAYEEID VENDORID PAYEE VENDOR PTYPE REF_RECORDS_ID REF_REC_TYPE GRP

* ID ACCTID ACCTNAME CHECK_NUM ARDATE CHECKDATE AMOUNT DRCR TS UID COMPID RECON_STATUS PAYEEID PAYEE PTYPE VENDORID VENDOR REF_RECORDS_ID REF_REC_TYPE GRP REFNUM CHECK_STAT JESTATUS

* ID TransDate JID GUID DRCR Reference DVNum OBR PayeeID PayeeName PayeeType AccountID BankName CheckDate CheckNumber Amount SOFID SUBSOFID FundClassID Particulars Status Type

* ID JID bankreconentryGUID DRCR Reference PayeeName AccountID BankName CheckDate CheckNumber Status Amount Particulars

* ID CDATE ARRIVAL PAYEEID CONSIGNEEID CHECK_NUM C_VOUCHER BL PURPOSE_OF_PAYMENT RECEIVEDBY AMOUNT CONTAINER MC_FEE BP STATUS title_id MC_CHECK LOGBY REMOVEDBY

* ID SUPID SUPNAME CHECK_NUM CASH_ACID REMARKS UID TS PDATE CDATE AMT APVID APVNUMB

* id apv_id debit credit acid check_num cdate GUID

* ID CVDate CVNUM APVNUM APVDATE APV_GUID SUPID VendorName Address PAYEEID CHKDATE CHKNUM GUID BankName Bank BankAMT APVAMT TITLEID PRJID JID PREPAREDBY REVIEWBY AUTHORIZEDBY PMTSTAT STATUS CheckEntryStat ReleasedStat Remarks Types Date1 Date2 WTAXACID IsBank

* ID CVDate CVNUM APVNUM APVDATE APV_GUID SUPID VendorName PAYEEID GUID APVAMT TITLEID JID PMTSTAT STATUS Remarks

* ID JID status RELEASED_DATE UID RECEIVEDBY REMARKS REFERENCE TSTAMP CHK_TYPE Groups SOURCEJID

* id name_id name_types amount dr_cr UID JID GUID _CMP ACID ACCOUNT_NAME JEstatus TS RECON_STATUS REMARKS _chr

* ID Bank CHKNUM ACCOUNT_DESCRIPTION NAME Amount CDate checkType

* id Activity stat

* ID GENID GENCODE GENNAME CLASSCODE CLASSIFICATION STATUS

* ID MAINID GENCODE GENNAME CLASSCODE CLASSIFICATION STATUS NB IsContra CF Groups

* ID GENID GENCODE GENNAME CLASSCODE CLASSIFICATION STATUS

* id prefix fname lname mname ext bod gender address contact_number stat

* id section_name stat

* id class_type_id class_year_id subject_abr subject_name no_of_units stat ts

* id class_type sorting

* id class_type class_class stat

* ID CUSTID CONTAINER BL ARRIVAL AMOUNT DATEFAX CHECK_NUM DATEPAID TSTAMP STATUS CLEARED REMARKS JOURNAL_ID

* id CID ATTN_NAME ATTN_POSITION TS JID TDATE GID DueDate JD BillSched servicePercent serviceamt origAr TAXPERCENT TAXBASE SERVICEBASE WT NETAMT

* ID DEDUCIONID ACID AMT JID GID TS JDTL

* ID dateLog usercloseEntry remmarks Location titleID EMPNAME Journal_id User_syspkID Status Reopenby datesaved FundID

* id committee_report_no date title committee_description status

* ID SHIPPINGID CUSTID CONTAINERNUM BL CONTAINER_DEPO DATE_REC REF_AMOUNT REF_CHECK_NO REF_DATE DET_AMOUNT DET_BILLING CTS_AMOUNT CTS_DATE_PAID CTS_OR ATS_AMOUNT ATS_DATE_PAID ATS_OR DOCD_AMOUNT DOCD_BILLING DOCD_OR CFC_AMOUNT CFC_SOA CFC_CHECK CFC_COLLECTED CFC_COLLECTED_DATE RBTR_AMOUNT RBTR_CHECK RBTR_COLLECTED RBTR_DATE REMARKS TS UID

* ID project_id RATE PAYROLL_FROM PAYROLL_TO

* id inv_id client_id dr_id dr_number CustomDR dr_date item_id qty uom item_code item_name item_description Serial po_price selling_price soid so_num customer_ponum PRJID title_id branch_loc temp_cogs temp_AR temp_asset temp_income temp_AR_amt temp_cogs_amt temp_income_amt temp_asset_amt type GUID status invoice_id invoice_num TS UID JID imported_from_excel

* ID SUPID POID PONUM SIDATE SINUM SIAMT COUNTEREDGUID COUNTEREDID PRJID POAMT GS Status IsVat

* ID COUNTER_ID GUID POID PONUM RRID RRNUM RR_AMT CMPID PRJDEPID PRJTYPE SUPPLIER_ID

* ID ACID debit credit uid GUID sup_id COSTID CNTRNUMBER SUPID

* ID TransType COUNTER_NUMBER COUNTER_DATES DueDate SI_Date SI SIAMT SUPID VendorName MEMO STATUS GUID TRANS_REF_NUM TRANSMITBY transmital_datetime RECEIVERID TS USER_ID TransmitGUID Types POIDx OLDPOx PONUMx POAMTx IsVatx TITLEID PRJIDx Remarks GSx IsVisibleInTranmittal imported_from_excel Sheet

* ID POID RRID SI COUNTER_DATES SUPID STATUS TBASE AMT TS GOODS_SERVICE JID duedate PROJID

* ID POID PONUM RRID VendorName RR_Date RRNUM RR_Amt VENDORID TitleID TS UID SI_date SINUM SI_AMT

* ID TITLEID COSTCENTERID MILESTONE SUPID MEMO COUNTER_NUMBER COUNTER_DATES DUEDATE SIDATE SINUM POID PONUM RRID RRNUM ACID ITEMID ITEMNAME BATCHCODE ORIGGROSS ORIGVAT ORIGNET GROSS VAT NET GUID STATUS TS

* dc_id syspk_dc ref_no series_no trans_date dc_fundtype classification dc_amount dc_d1000 dc_d500 dc_d200 dc_d100 dc_d50 dc_d20 dc_d10 dc_d5 dc_d1 dc_dcents dc_totalamount dc_Checkno dc_Checkdate dc_dateGranted dc_employee_number type_ dc_additional

* id check_disbursement_voucher_id obr_no office check_no check_date nature_payment payee_id payee_category particulars trans_no jev_no gross BIR other_Deduction NET date DVNo fund class_id stub_no form_no expense_code jev_date sub_fund retention VAT EWT Others Exempt Process status bank ExcludeOtherDeduction variousOffices mobilization_repayment po_no po_date _type Release? Reason DateRelease DateCancelled UID

* ID SysPK_fund_setup fund_description LguCode

* id main_id stub_no series ct_pads ct_sheets ct_tickets ct_no_tickets domination total_amount actual_sheets or_status dte_issued date_saved

* id ref_no series_no ct_pads ct_sheets ct_tickets ct_no_tickets domination total_amount or_accountable_emp_id or_date_issued or_remarks status Fund date_saved

* id main_id coa_code ct_no_tickets denomination total_amount date_saved registry_id

* id or_id ref_no series_no or_accountable_emp_id remarks trans_date status date_saved frm_accountable_emp_id

* id witdraw_main cash_ticket_id ct_pads ct_sheets ct_tickets ct_no_tickets denomination total_amount date_saved trans_status SoldAmount

* id ref_no series_no or_accountable_emp_id ct_pads ct_no_tickets total_amount status remarks trans_date date_saved frm_accountable_emp_id

* id ref_no accntable_prson receive_by date tmestamp status

* id main_id type amount pieces total

* ID CurrencyName Rate

* ID CID JID Amount Reference_no USERID

* ID CID custName Amount dates Businesstype Location TitleID

* ID CID BP Amount UID Remarks

* ID JID CID REF Amount

* id CLIENTID date_inv inv_num description uom qty amount VATABLE TERMS Delivery_address MEMO JID GUID STATUS TITLEID UID TS po_num CancelledDate JESERIES ContactNum ContactName VAT_CODE

* ID DATE FROM TO SUBJECT MONTH BILL CONTAINER REMARKS TOTAL_LIQ ADV TSTAMP refund_id

* ID WIP_NAME WIP_STAT START END ADDRESS REMARKS ts Types OFFICEID contractorid agencyid contract_amount ACIDS

* ID JID AMOUNT STATUS TS GUID

* ID ACID_ TITLEID location

* ID IDENTIFIER IDS Description

* ID COMPID Property Account ACID Status

* ID CIB CASL CASSD RECEIVABLE PAYABLE PETTY ADVANCES_FRM_AFF ADVANCES_TO_AFF ADVANCES_FRM_CUST COMPANYID ADV_TO_SUP PETTY_CASH_CUSTODIAN DUE_TO_EMP OFFICE DUID UNDEPOFUND SRV_INC RETAINEDEARNINGS BIRID INPUTTAX INVENTORY_EXPENSE

* ID recordType deletedDateTime deletedBy Reason

* ID JID GID PRJID STATUS AMT MEMO TITLEID TRANSDATE account_id SERIES ORIG_GUID TS NEW_MEMO

* ID account_id PPEID Loc TItleID accounts accumid

* division_id division_code division_name title_id division_code1 project_id status savedate userid

* id document_type documentName fileSave stats

* id mainID fileName filePath fileSize transtype thumbnail_path uid ts status

* id App_No title purpose fund department status

* id document_name status

* id document_name stats

* id attend_No attend_date attend_time category status

* id IncDocs_No title datex status

* id OutcDocs_No doc_type datex status

* id title status

* id tAndS_no to thru from subject tAndS_date status

* id transmittal_no trans_date recipient status

* id verMotion_No title term_id description datex status

* id vermotion_id pp_code attend mposition

* id driver_fullname address contact_no age civil_stat license_no height weight status

* ID Name Identifier Position

* v_id main_id check violation_id violation_desc dept_id complied ts

* ID POSITION EMPNAME empid positionid prefix sufix

* ID Restrict pass_encrypted

* ID SUPID goods_serrvices ACCOUNTID DR_CR TS SUBTYPE SUBID

* id RE_Number Date_ ClientName ClientID Expense_Type Description acid

* id type ts

* id uuid connection queue payload exception failed_at

* ID ACUM_ID DEPREACT

* id fa_ID dateofrepair JEVNo description cost fa_remarks status date_saved

* id PPEID info1 info2 info3 info4 info5 info6 info7 info8

* ID TransGUID JID PPEID components account_id Description PPENo Life TransDate Reference Particulars Cost Depreciation losses AdjustedCost carryingAmount Disposal NatureOfRepair RepairAmount Remarks

* ID iar_id item_id AREReference ARENo AREGUID PPE_Account_code PPE_Account_id accounts ppenumber FADescription dateEncode dateAccquired DepreDate LifeYear SalvageValue ProductNum Model Serials Conditions Status StartDepre remarks UID GUID po_number prNumber STORAGE_LOCATION depreacct accumacct cost deprecost impairment AutoDepreciation imported_from_excel FundingSource FundId Supplier SupplierAddress SupplierContact WarrantyDate IsPending EntityName FundCluster SLMigrateId NatureOfRepair RepairAmount MainFundId SourceFrom forRandM

* ID TITLEID LOCATION Start_Date

* id form_name NAME stamp

* ID JID REFERENCE_NO TRANS_DATE BANKACCOUNT PAYEE CHECK_NO CHECK_DATE GROUPS USERID

* ID systemFundId FundName lguFundId

* id type service_type checked status save_date userid location title category

* id CMP Properties Values

* ID VARS VALS

* ID JID GJVNUM LOC TITLE YYYY PO INV GRPS MM

* ID GUID TransType TS TransDate Fund Account Code AccountId Debit Credit userId Status ForNormalization Subsidiary mainFundId

* id form_name form_status date_saved

* id form_id form_name signatory_type employee_id prefix employee_name employee_position signatory_status date_saved

* id emp_id main_id logDate time_log mode_id mode_type device_id ip_address date_created type

* ID HRDB APP

* SysPK_emp_attendance attendance_id employee_number employee_fullName dtr_date in_am out_am am_note in_pm out_pm pm_note late undertime total_hours_worked status att_remarks note_am_in note_am_out note_pm_in note_pm_out OB_notes modify_user overtime in_ot out_ot modifiedby modifieddate total_hours_worked_new leave_status dept_code machine_id

* SysPK_emp_attendance attendance_id employee_number employee_fullName dtr_date in_am out_am am_note in_pm out_pm pm_note late undertime total_hours_worked status att_remarks note_am_in note_am_out note_pm_in note_pm_out OB_notes modify_user overtime in_ot out_ot modifiedby modifieddate total_hours_worked_new leave_status dept_code machine_id

* id appdate refno agency_id agency_name purpose other period_from period_to office_id office_name employee_id emp_name position supervisor_id supervisor_name HeadOffice_id HeadOffice_name 1a_stat 1a_official_id 1b_stat 1b_official_id 1c_stat 1c_official_id 2a_stat 2a_official_id 2b_stat 2b_official_id 3a_stat 3a_official_id 3b_stat 3b_official_id 3c_stat 3c_official_id 4a_stat 4a_official_id pending_stat pending_clear pending_official_id verification head_agency_id status TS

* ID ACID account_description IS_group ISGroup_description Status

* ID JID GUID GROSS TAXBASE RATE TAX_AMT CREDIT_TAX NATURE PARTICULARS SUPPLIERID SUPPLIER_NAME INVOICE TS CHARGETO FL DATES TAX_CODE SERVICES CASL_RELEASED_ID

* ID JID GUID GROSS TAXBASE RATE TAX_AMT NATURE PARTICULARS SUPPLIERID SUPPLIER_NAME INVOICE TS CHARGETO FL DATES TAX_CODE SERVICES CASL_RELEASED_ID

* inventory_id item_no item_description item_cost item_measurement supplier_id received_quantity withdrawn_quantity receipt_no withdraw_no registered_no division_code account_code tstamp claim_status item_code project_location_id title_id status type inventory_no prepared_by received_by location_remarks reference_no property_no remarks1 source project_loc project_sup supplier_type ref_po

* id withdrw_id invoice_num dr_services date_invoice savedate bill_no terms po_number client_id Memo amount withdraw_num

* ID MainGroup SubGroup1 SubGroup2 GroupOrder STATUS

* ID JID DateLog UID username UserFullName Reason ActionMade

* id journal_id atc_code atc_description atc_rate

* journal_detail_id journal_id account_id subsidiary subsidiary_description subsidiary_type bank SUBACCOUNTID Memorandom GroupEntryD RECONDATE _CMP _BRN _CHR INV_REF GS DEBITS CREDITS DueDate ATC_CODE ATC_RATE ATC_DESCRIPTION imported_from_excel WVAT UNITID UNITNAME SOF SOFID SOFCode SubFundName SubFundID FundClassName FundClassID migrationGUID STAT OtherRemarks ARE_No FacilityID CFTypeID

* JDID LogID journal_id account_id subsidiary subsidiary_type bank SUBACCOUNTID Memorandom GroupEntryD RECONDATE _CMP _BRN _CHR INV_REF GS DEBITS CREDITS DueDate ATC_CODE ATC_RATE ATC_DESCRIPTION imported_from_excel WVAT UNITID UNITNAME SOF SOFID SOFCode SubFundName SubFundID FundClassName FundClassID

* journal_id STATUS ApprovalStatus SERIESNUMBER TransNo OfficeId RespId ProjectId TIN DVNum OBRID OBRNum SOF_ID SOF_NAME SOF_CODE trans_type Type FrmCaption trans_date PostingDate memo userid username po_id save_date name_id Name_type PayeeName address MOP GroupEntry VENDORID CheckDate CheckNumber BankName vc_reason CancelledDate imported_from_excel AttachmentTBL Sheet obligated CompleteDocs avail_fund CancelledBy ias_status ias_cancel_reason ias_approverId ias_logDateTime migrationGUID CheckAmount BankAccountID DVID DVNO EntryType

* ID journal_id STATUS ApprovalStatus SERIESNUMBER DVNum OBRNum SOF_ID SOF_NAME SOF_CODE trans_type Type FrmCaption trans_date PostingDate memo userid po_id save_date name_id Name_type PayeeName MOP GroupEntry VENDORID CheckDate CheckNumber BankName vc_reason CancelledDate imported_from_excel AttachmentTBL Sheet

* journal_id STATUS ApprovalStatus SERIESNUMBER DVNum OBRNum SOF_ID SOF_NAME SOF_CODE trans_type Type FrmCaption trans_date PostingDate memo userid po_id save_date name_id Name_type PayeeName MOP GroupEntry VENDORID CheckDate CheckNumber BankName vc_reason CancelledDate imported_from_excel AttachmentTBL Sheet CancelledBy

* ID ACID CVS YR CheckId Location JID TITLEID GRP

* ID ACID CVS YR CheckId Location JID TITLEID GRP

* ID SOFID_ SOFNAME AccountID Balance Sheet

* id lawyer_id subject_name app_date app_start app_end attendee venue stat ts

* id court_id branch_name remarks status

* ID casedate Case_Number Case_Type Case_Title court_id case_status opponent_id opponent_lawyer_id Status MAINID TSTAMP guid layer

* id case_entry_id client_id lawyer_id

* ID FK_cases FK_law Count Description

* id case_id doc_type file_name file_path file_full_path received_from remarks stat ts

* id case_id lawyer_id agenda date_time venue remarks stat

* ID case_type title_id proj_id user_id tstamp status

* patient_id pp_code company_name trade_name prefix fname lname mname suffix address phone sex birth_date blood_group contact_person ts status save_type

* id ref_no trans_date ppid prefix fname mname lname suffix bdate gender brgy_id barangay_name purok_name contact_no subject_matter supporting_documents legal_advice ts status

* id court_type court_name Region Branch_Name City_municipal court_address Contact_no status

* id court_type status

* ID Type Description Court Type

* ID case_id Date_time Agenda todolist Status judge_id to_do lawyer court_id tstamp userid

* judge_id pp_code prc fname lname mname address phone sex birth_date contact_person ts status

* patient_id pp_code ibp mcle prefix fname lname mname suffix address phone sex birth_date blood_group contact_person ts stat lawyer_type

* ID law_type case_type law_name description userid status tstamp title_id proj_id

* id case_id ppcode prefix fname mname lname suffix gender contact_no address stat ts

* ID office Date RefNo Amount RefDate Purpose DueDate AccountUsed Remarks

* SysPK_fund_setup fund_code_new fund_description

* ID GUID TS

* ID GUID Trans_date Trans_Type JEV_Num Fund_Name Particulars Payee Subsidiary Account_Code DR CR Reference DueDate

* ID MOP

* ID FileName GUID Types TOF QRK Mitigation NDRRMF Barangay FromOtherSources Total MOA Remarks UID TS

* id OfficeID OfficeName OfficeSubcode Remarks Status

* ID amount OFFSET_GID ENTRY_GID

* id dr_num uom_name ITEM_CODE item_name item_id QTY price inv_no inv_id client_name client_id status GUID UID TITLEID PRJID PROJECT po_num DR_DATE vat_code VATABLE ACID account_code ts TRANSDATE po_cost tempAR_amt tempInc_amt tempCogs_amt tempInv_amt

* ID BID PAYEE_NAME TIN Status Auto

* ID Office Amount

* id JID GUID PRJID TITLEID PETTYCASH_CUSTOD PETTYCASH_CUSTID MEMO DATE_RELEASED TRANS_DATE TS AMOUNT SERIES STATUS LIQ_UNLIQ DR_CR PAYEE PAYEE_TYPE CHECK_DATE CHECK_NUM ADDRESS_ID ADDRESS

* id PCID payee_id PAYEE CLIENT_NAME TITLEID PRJID PROJECT DESCRIPTION AMOUNT GUID TS MAINID STATUS CLIENT_ID EXPENSE_TYPE DEPT RELEASEDCASH date_ ISLIQUIDATED

* ID project_id title_id Amount status ts reference_no remarks supplier trans_date JID GROUPNAME

* id REQREF DRAFT_NUM DRAFT_IDEN UID LNAME FNAME DEPARTMENT REPORTING_MANAGER TRANS_DATE REQUESTED_DATE AMT_DUE_FRM_EMP REQUESTED_AMT DEADLINE DESCRIPTION STATUS GUID PROJECT TS PAYEE ISRELEASED RELEASEDCASH PRJID CLIENT_NAME CLIENT_ID

* id PCID PRJID payee_id PAYEE CLIENT_NAME DESTINATION_FRM DESTINATION_TO DESCRIPTION AMT_SPENT TITLEID MOT PROJECT GUID TS MAINID STATUS CLIENT_ID DEPT RELEASEDCASH date_ ISLIQUIDATED

* ID JID ACID BANK_NAME CHECKNUMBER CHECKDATES PAYEE PAYEEID Groups USERSID CVNUMBER DRCR CHK_AMOUNT TRANSDATE SERVICE_CHARGE SERVICE_INTEREST _CMP TS TYPE

* ID JID PostedBy PostedDate TimePosted posted_grp

* ID PO_ID JID AMOUNT STATUS GUID

* ID StorageName

* ID PPEType ClassID ClassName Status

* ID Categoryname Location Title_id Status

* ID group_name account_id account_code account_description status

* ID JID ACID UID printdate checkNumber groups

* ID GUID ChargeName Percentage LessAmt BaseAmt GrossAmount DVType LastPrintedDVType DVDescription Remarks CertDate

* ID CV_num JID UID DatePrinted TimePrinted CHKNumber Amount Location TitleID groups

* ID NAME

* id CUSTID SI SIDATE AMOUNT COMPID PRJID PMTDATE REF_NUM MEMO WTAX ATCID ATC CHECK_NUM CHECK_DATE JID GUID ORNUM ORDATE BANK_REF status savedate PMT_SERIES MOP ReconStat RECEIVED_AMT DISCOUNT ADVANCED_AMT OTHERDEDUCTION_AMT

* ID RECONGUID ACID BANKNAME AMT STATEMENTDATE DRCR OrigGUI TS UID CheckNumb ChckDate Status

* ID ACID Account GUID Remarks Beginning Ending Interest Charges Adjustment Date CID Status UID TS

* ID RECON_DATE CheckDate Debit Credit serviceCharge InterestEarned GUID COMPID UID STATUS TS ReconGUID CHECK_NUM

* ID RECONGUID ACID BANKNAME AMT STATEMENTDATE DRCR OrigGUI TS UID CheckNumb ChckDate Status REFNUM payee

* ID JID

* id reNum caslRef acid account subid subsidiary amount empid empname jid guid checkNum checkdate TS STATUS release_id UID TITLEID transdate memo TYPE_ REQID ATC CASL_GUID ACTUAL_ID FORMNAME

* id REID payee_id PAYEE CLIENT_NAME TITLEID PRJID PROJECT DESCRIPTION AMOUNT GUID TS MAINID STATUS CLIENT_ID EXPENSE_TYPE DEPT RELEASEDCASH date_

* id REQREF DRAFT_NUM DRAFT_IDEN UID LNAME FNAME DEPARTMENT REPORTING_MANAGER PAYEEID PAYEE TRANS_DATE REQUESTED_DATE AMT_DUE_TO_COMP AMT_DUE_FRM_EMP TOTAL_AMT_SPENT DEADLINE DESCRIPTION STATUS GUID PROJECT TS DESTINATION_FROM DESTINATION_TO ISRELEASED PRJID RELEASEDCASH CLIENT_NAME

* id REID PRJID payee_id PAYEE CLIENT_NAME DESTINATION_FRM DESTINATION_TO DESCRIPTION AMT_SPENT TITLEID MOT PROJECT GUID TS MAINID STATUS CLIENT_ID DEPT RELEASEDCASH date_

* id JID RL_REF GUID EMP_ID PAYEE_ID account_id remarks trans_date savedate UID name_type

* ID REPLE_REF OLD_JID REFLW_LIQ JID DATE_LIQ EMPID MEMO AMOUNT UID status CV tstamp GROUP REPLE_GUID REPLE_ID

* ID JID_OLD JID_NEW GID_NEW UID TS STATUS

* id main_id item_no particulars are_no type_of_problem

* id trans_id trans_date dept_id inspection_type_id inspection_type_name action_taken remarks browsed saved_date

* ID DRAFT_IDEN DRAFTNUM DATE REQREF PROJECT Deadline AMOUNT STATUS UID FNAME LNAME DEPARTMENT REPORTING_MANAGER POSITION TS GUID COMMENTS ISRELEASED

* IDENTITY ResourceID ResourceName Color image CustomField1

* id return_ref caslRef acid account amount empid empname JID GUID TS STATUS release_id UID TITLEID transdate memo CANCEL_UID CANCEL_DATE CASL_GUID

* ID REF Date DueDate VENDORID Vendor TIN PayeeID Payee Remarks GUID GS TS Amount Status TitleID UID DocsStamp CreditableWTax TransferTax RegFee Annotation Others OthersTxt RegCheck ManagerCheck DoasDate UnitID UNITCODE PROJID PRJNAME CLIENTID CLIENTNAME RequestedBy VerifiedBy NotedBy ReceivedBy ApprovedBy RequestedByDate VerifiedByDate NotedByDate ReceivedByDate ApprovedByDate

* ID RFPID PROJECTID ClientID CLIENTNAME TITLEID PAYEEID MAINID PROJECT DATENEEDED PAYEE MOP PURPOSED DESCRIPTION CURRENCY currency_id AMOUNT STATUS GUID RELEASEDCASH TS

* id RFPID trans_date client_id client_name description amt_due_to_comp amt_due_to_emp date_ Amount STATUS ts ISLIQUIDATED currency_id currency

* ID Name Name1 Name2 Name3 Name4 Name5

* ID accountid title_id employee_id stub_no serial_no_from serial_to_to quantity date_issued remarks status used

* ID CHKMAINID check_no date_used check_status employee_id

* ID FORMS EMPID EMPNAME SIGTYPE SIGIMG DISPNAME positions autosign STAT FORM_ID frmname module

* ID DOCNAME SIGNATURE SIG1 SIG2 SIG3 SIG4 SIG5 SIG6 SIG1_FULL SIG2_FULL SIG3_FULL SIG4_FULL SIG5_FULL SIG6_FULL POS1 POS2 POS3 POS4 POS5 POS6

* ID BID FNAME VENUE MARKETTING_OFFICER EVENT_DATE AREA SIGNUP_DATE _TYPES PACKAGE_NAME TRANSFERED_TO RELATION REASON_TRANSFERED DEED_OF_TRANSFER NEW_Fname REASON_CHANGE_NAME SPOUSE_NAME ADDRESS EMAIL TIN CONTACT ACCOUNTNUMBER LNAME MIDDLE SUFIX NEW_LNAME NEW_MIDDLE NEW_SUFIX PRICE EVENTID EVENTNAME FL LOC _STATUS REG_PRICE STAT_BY STAT_DATE appr_remarks declined_reason NewEmail NewContact NewTIN

* ID SIGNAME

* ID journal_detail_id GUID TransType MigrationDate TransDate ReferenceNo TransNo Memo Payee AccountId Code Account GenName SubCode AccountType Subsidiary Fund SubId Debit Credit userId Status DueDate ForNormalization ApType TS IsBeg CheckNo

* ID MainID GUID CheckDate CheckNum Payee Particulars Amount

* ID GUID Project FundingAgency BankAccount PeriodFrom PeriodTo beginning AddReceipts TotalCashBeginning TotalChecksAmount AdjustmentPlusMinus TotalDisbursementAll TotalCashEnding Certified1Name Certified1Position Certified2Name Certified2Position ApproverName ApproverPosition VerifiedName VerifiedPosition UID TS Status

* ID GUID _Date Reference Particulars AmountDilig AmountLgu AmountTotal

* ID GUID CheckDate CheckNum Payee Particulars AmountDilig AmountLgu AmountTotal

* ID GUID SORDReference Project DateFrom DateTo LoanProceeds LGUEquity TotalProjectCost PercentCompletion TotalReceiptDilg TotalReceiptLgu TotalReceiptTotal TotalFundsAvailableDilg TotalFundsAvailableLgu TotalFundsAvailableTotal TotalDisbursementDilg TotalDisbursementLgu TotalDisbursementTotal BalEndDILG BalEndLGU BalEndTotal LabelDescription SummaryReceiptDilg SummaryReceiptLgu SummaryReceiptTotal SummaryDisbursementDilg SummaryDisbursementLgu SummaryDisbursementTotal SummaryBalanceDilg SummaryBalanceLgu SummaryBalanceTotal CertName CertPosition NotedName NotedPosition ApprovedName ApprovedPosition VerifiedBy VerifiedPosition UID TS Status

* ID Property Status

* ID Property Values UID Pwd Status

* ID GenID GENCODE GENNAME GroupID GROUPCODE GROUPNAME TypeCode TypeID TYPES SUBTYPES SUBTYPEOrder STATUS CF

* ID code NAME ACID mapToId status OrigACID PPEID MainFund SubFund

* ID ID2 code NAME ACID mapToId status OrigACID PPEID MainFund SubFund

* ID MAINID GENCODE GENNAME CLASSID CLASSCODE CLASSNAME SUBCODE SUBNAME STATUS CFlow

* id mainID transType transDate referenceNo qty uCost totalCost noOfDays dStatus

* id itemFund ItemId ItemCode ItemName ItemSpecs ItemUmeasure ItemReorderPoint ItemStatus datesaved

* ID FrmName FrmClass PropertiesExternal

* id Modules FRM_CAPTION FRM_CLASS Properties DefaultValue RType

* ID Profilename AddedByUID Status

* ID ProfileID ProfileName FrmClass FormName Properties Value

* ID FrmClass FrmName GroupName ORDERED ADDEDBYUSERID TS Status Task

* ID UID RMID TS Uname UFullName RMName imported_from_excel

* ID RoleID RoleName ProfileName

* ID ProfileName UID TS UserName

* id action task userid username form department timestamp

* ID name3 name1 name2

* ID registeredOwner formerowner Lot size remarks tax DEC number statusOfProperty landDescription PROJID Acquisition Date Total acq cost Acq cost per sqm LGU zone value BIR zonal value Assessed value Carrying value Tct number location

* id fund_id sub_fund_id account_id sl_id sl_code sl_name amount effectivity_date save_date

* id year balance_amount fund_type cie_status

* id emp_id shift_id date first_in first_out first_late first_undertime first_notes second_in second_out second_late second_undertime second_notes ot_in ot_out late undertime overtime diferential cto no_of_hrs holiday is_rest_day direct_overtime status trans_id type lock_status modified_by modified_date tmstamp rate_per_day pos_id paygroup_id

* id emp_id shift_id date first_in first_out first_notes second_in second_out second_notes ot_in ot_out trans_id type tmstamp rate_per_day pos_id paygroup_id

* id itemid sku itemname desc brand excel_row

* id EquityAmount EYear eStatus

* id PreviousAmount CurrentAmount EYear EStatus

* id TotalAmount GFAmount SEFAmount TFAmount EYear Estatus

* id trans_id form_id signatory_type signatory_id signatory_name signatory_position sig_status date_saved

* leave_id ref_no asOfDate sl_bal vl_bal applied_date approved_date approved_by by_authority_id employee_id contact_person contact_no purpose supervisor_comment status tmstamp dept_id position_id commutation incaseVLPhilCheck incaseVLPhilText incaseVLAbroadCheck incaseVLAbroadText incaseSLHospitalCheck incaseSLHospitalText incaseSLOutPatientCheck incaseSLOutPatientText incaseSpecialLeaveWomenText incaseStudyMastersDegreeCheck incaseStudyBARBoardCheck MonetizationLeaveCheck TerminalLeaveCheck LeaveRemarks recommended_by recommended_date certify_by certify_date wherespent declined_remarks declined_remarks_approval isWebApp dateSelected isposted

* id leave_id leave_type_id leave_date leave_dateto leave_for hrs_leave payment_mode status status_rec status_cert status_approved leave_others deductLeave

* contract_id application_id leassor unit_id act_by ACT_BY2 its tenant_id tenant_address property_name property_address due_day area_word area_double Number st brgy city 1_year_word 1_year_double 1_commencing 1_terminating 2_rent_word 2_rent_double 2_office 3_pay_month_rent 4_security_word BASIC_RENT EVATPERCENT EVATAMOUNT CWTPERCENT CWTAMOUNT NETRENT 4_security_double 4_security_term 4_security_term_pay_word 4_security_term_pay_double 4_security_start 4_security_end 5_util_word 5_util_double 5_util_term 4_util_term_pay_word 4_until_term_pay_double 4_util_start 4_util_end 6_refund_days_word 6_refund_days_double 8_contract_type 13_limited_word 13_limited_double 25_calendar_word 25_calendar_double 26_calendar_ter_word 26_calendar_double 28_penalized_word 28_penalized_double 31_A 31_B 35_att_pay_word 35_att_pay_double tertimony_day tertimony_date tertimony_at lessee by1 by2 republic ack_day ack_date doc_no page_no book series contract_type conract_id_renew WITH_WATER WITH_ELIC chksec chkutil chktes contract_status _DATEFROM _DATETO Payment_Form _TYPE docno pageno bookno seriesno last_con_id TSTAMP statuss LED_ID

* id ref_id module RF_no TRN username userid date title loc

* id j_id series_no new_series_no

* id acid accName Property

* id j_id series_no new_series_no

* id j_id series_no new_series_no

* id j_id series_no new_series_no

* id j_id series_no new_series_no

* id description

* ID Description

* id JID GUID UID MEMO AMOUNT TS TRANS_DATE MAC_ADDRESS PC_NAME IP_ADDRESS TYPE

* ID MODE ts

* ID ACID AssetType UID TS

* ID JID GUID STATUS AMOUNT MEMO CLIENTID TRANS_DATE COMPID SERIES TS

* ID DATE REF Remarks visibility REFID JID AMOUNT UNITID BUSINESSID TS

* ID LBID GUID DESCRIPTION TAXDEC TCT COST UID PRJID TS

* ID UID DateLog TimeIn TimeOut

* id consul_id refno trans_date animal_id owner_id date_visit brgy_id popn cases death clinical_sign disorder remarks health_status status date_save

* ID JID ACID CHECKNO SAVE_DATE UID Remarks

* ID GUID REFID FRM series NO NODUP DVDATE MOP PAYEEID PAYEENAME PAYEETYPE TYPEOFPAYEE ADDRESS REMARKS PRNO BACRESNO PONO ALLOTMENT SUPPORTING CASHADVANCE IMPAGENCY EXISTENCEFUNDS FUNDS A_NAME A_POS B_NAME B_POS C_NAME C_POS CHECKNO CHECKDATE BANKNAME ORNO JEVNO OBRNO OBRID WITH_TAX ISVATABLE ISEXEMPT VAT0 VAT1 VAT2 VAT3 RETENTION AMOUNT UID UID_DEPT userdeptid STATUS TS FINALBILL ACCOUNT_NO

* DTLID MAINID DESCRIPTION VALUE AMOUNT TYPE

* ID GUID MAINID EXPLANATION AMOUNT NAMOUNT DEDUCTION PENALTY

select table accounts_parents accounttable accounttypemodel accounttypes accounttypescopy account_classification account_ledger account_main account_per_department account_setup account_setup2 account_setupcopy account_setup_default account_setup_excel account_setup_orig account_setup_orig2 account_type advances_from_customer advance_to_supplier advance_to_supplier_offsetted adviceentrydetail adviceentrymain agents_cash_adv aging_basedate amount_limits applog appointments apv_charges apv_entry apv_number apv_number_copy apv_records ap_account assistance_survey_setup atc_setup atc_tax_rate atc_vendor_default autoritytodeduct autoritytodeduct_details balancesheet_group bankreconentry bank_recon_records beginning_ap beginning_ar beginning_entry beginning_temp billingrecord billing_monitoring billing_others bill_series bircolumn bir_signatories bisligpetty bislig_petty_liquidate board_directors breakdown_invoices breakdown_invoices_ar bsgroup_setup budgettypes casd_release cashadvance cashadvancemonitoring cashadvance_details cashall cashflowdetail_group cashflow_group cashliquidation cashvoucher_series cash_advances cash_advance_request cash_advance_request_details casl_liq casl_liq_br casl_liq_details casl_refund_list casl_released cfdetailgroup_setup cfgroup_setup cf_accounts cf_description cf_taxes change_in_eqt_setup checkdefaultsignatories checkingaccountlog checkingaccountlog_debits checkrecieve checkreleasinginfo checks_records checks_warehouse checkwarehouse checkwarehouseclearingstatus check_monitoring check_preparation check_preparation_accounts check_prep_apvs check_prep_apvs_wtax check_received_released_stat check_warehouse check_warehousing cho1_potability_permit_insp_activity classification_setup classification_setup2 classification_setupcopy class_instructors class_section class_subject class_type class_type_year clearing_cust_advanc_pay clev_ar clev_deductions closing_entry_log committee_report container_monitoring conversion_setup costing counteredpo counteredporr countered_entry countered_rr countered_si countered_si_rr_matching countering cto_cash_disbursement_statement cto_check_disbursement_voucher cto_fund_setup cto_official_reciept_setup_cash_tickets_registry_details cto_official_reciept_setup_cash_tickets_registry_main cto_official_reciept_setup_cash_tickets_sales_dtails cto_official_reciept_setup_cash_tickets_sales_main cto_official_reciept_setup_cash_tickets_withdrawal_dtails cto_official_reciept_setup_cash_tickets_withdrawal_main cto_transaction_partial_deposit cto_transaction_partial_deposit_dtl currencysetup customeradvancedeductionlogs customeradvances customeradvanceslog customersl_log customize_invoice cust_adv_refund_log cwip_logs debits_actual_deducted defaultbank defaultids defaults defaults_accounts deletionlogmodel deposited_collection depreciationaccounts division_setup documentmanager documentmanager_file document_financial document_name1 document_setup doc_attendance doc_incoming doc_outgoing doc_recording doc_trainseminar doc_transmittal doc_verbalmotion doc_verbalmotion_dtls drivers_profile dvsignatories ebplo_violation_dtl_new employee_with_positions enforceaccounting_sec enter_payment_default expense_details expense_type_setup failed_jobs fa_account fa_history fa_info fa_ledgercard fa_setup fiscalyear form_name for_setup_check fundmap fvc_checklist_setup generalsettings genset gjv_number glmigrate gso_forms gso_signatories hr_biometric_logs hr_db hr_emp_attendance hr_emp_attendance_jo hr_tbl_clearance incomestatement_group input_tax_records input_tax_records_copy inventory_main invoices isgroup_setup journal_acctivity_log journal_atc journal_detail journal_detail_log journal_main journal_main_log journal_main_temp1 lastcash lastcv lastreconbalance law_appointment law_branh_setup law_cases_entry law_cases_entry_client law_cases_entry_law law_case_document law_case_meeting law_case_type law_client law_consultation law_court_setup law_court_type law_document_type law_hearing_schedule law_judge law_lawyer law_law_setup law_witness listofcashadvance majorfund migrated_apv migrated_apv_details mop nddrmf office_subcode offsetted_trans_record open_dr payee pettycashfund pettycash_replinishment petty_cash_expense_details petty_cash_released petty_cash_request petty_cash_request_details postdated postinglog po_offset_payment ppestorage ppetypes ppe_category ppe_group printedchecklog printeddvless printedvoucherlogs project_acct_types receive_payment reconcialtionlogs reconlastbalance recon_records recon_uncleared referencemodel reimburse reimbursement_expense_details reimbursement_request reimbursement_request_details replenishment replenishmentl_liq replinished_trans request_for_inspection_detail request_for_inspection_main request_for_payment resources return_casl rfp rfp_details rfp_liquidation sample setup_check setup_check_dtl signatories signature signups sigtype slmigrate sord1detail sord1main sord2detailaddfunds sord2detaildisbursement sord2main specialaccess specialaccesspermission subaccount_types subsidiarymodel subsidiarymodel_others sub_classification_setup suppliesledger_detail suppliesledger_main systemformproperties systemforms systemprofile systemprofileforms systemprofileorders systemreportingmanager systemroleprofile systemuserroleprofile system_log table2 taxdec tbl_bank_balances tbl_changeinequity tbl_dtr_jo tbl_dtr_temp_jo tbl_duplicate tbl_equity tbl_equity_compa tbl_equity_conso tbl_gso_signatories tbl_leaves tbl_leaves_dtl tbl_property_contract tbl_user_logs temp tempapaccount temp_ckd temp_ckd_copy temp_gj temp_sef terms textfileexclusionmodel transaction_logs transpo_setup typeofassets undeposited_collection unithistory used_land user_logs vet_animal_health_monitoring void_check_log voucher voucher_computation voucher_dtl . 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 accounts_parents accounttable accounttypemodel accounttypes accounttypescopy account_classification account_ledger account_main account_per_department account_setup account_setup2 account_setupcopy account_setup_default account_setup_excel account_setup_orig account_setup_orig2 account_type advances_from_customer advance_to_supplier advance_to_supplier_offsetted adviceentrydetail adviceentrymain agents_cash_adv aging_basedate amount_limits applog appointments apv_charges apv_entry apv_number apv_number_copy apv_records ap_account assistance_survey_setup atc_setup atc_tax_rate atc_vendor_default autoritytodeduct autoritytodeduct_details balancesheet_group bankreconentry bank_recon_records beginning_ap beginning_ar beginning_entry beginning_temp billingrecord billing_monitoring billing_others bill_series bircolumn bir_signatories bisligpetty bislig_petty_liquidate board_directors breakdown_invoices breakdown_invoices_ar bsgroup_setup budgettypes casd_release cashadvance cashadvancemonitoring cashadvance_details cashall cashflowdetail_group cashflow_group cashliquidation cashvoucher_series cash_advances cash_advance_request cash_advance_request_details casl_liq casl_liq_br casl_liq_details casl_refund_list casl_released cfdetailgroup_setup cfgroup_setup cf_accounts cf_description cf_taxes change_in_eqt_setup checkdefaultsignatories checkingaccountlog checkingaccountlog_debits checkrecieve checkreleasinginfo checks_records checks_warehouse checkwarehouse checkwarehouseclearingstatus check_monitoring check_preparation check_preparation_accounts check_prep_apvs check_prep_apvs_wtax check_received_released_stat check_warehouse check_warehousing cho1_potability_permit_insp_activity classification_setup classification_setup2 classification_setupcopy class_instructors class_section class_subject class_type class_type_year clearing_cust_advanc_pay clev_ar clev_deductions closing_entry_log committee_report container_monitoring conversion_setup costing counteredpo counteredporr countered_entry countered_rr countered_si countered_si_rr_matching countering cto_cash_disbursement_statement cto_check_disbursement_voucher cto_fund_setup cto_official_reciept_setup_cash_tickets_registry_details cto_official_reciept_setup_cash_tickets_registry_main cto_official_reciept_setup_cash_tickets_sales_dtails cto_official_reciept_setup_cash_tickets_sales_main cto_official_reciept_setup_cash_tickets_withdrawal_dtails cto_official_reciept_setup_cash_tickets_withdrawal_main cto_transaction_partial_deposit cto_transaction_partial_deposit_dtl currencysetup customeradvancedeductionlogs customeradvances customeradvanceslog customersl_log customize_invoice cust_adv_refund_log cwip_logs debits_actual_deducted defaultbank defaultids defaults defaults_accounts deletionlogmodel deposited_collection depreciationaccounts division_setup documentmanager documentmanager_file document_financial document_name1 document_setup doc_attendance doc_incoming doc_outgoing doc_recording doc_trainseminar doc_transmittal doc_verbalmotion doc_verbalmotion_dtls drivers_profile dvsignatories ebplo_violation_dtl_new employee_with_positions enforceaccounting_sec enter_payment_default expense_details expense_type_setup failed_jobs fa_account fa_history fa_info fa_ledgercard fa_setup fiscalyear form_name for_setup_check fundmap fvc_checklist_setup generalsettings genset gjv_number glmigrate gso_forms gso_signatories hr_biometric_logs hr_db hr_emp_attendance hr_emp_attendance_jo hr_tbl_clearance incomestatement_group input_tax_records input_tax_records_copy inventory_main invoices isgroup_setup journal_acctivity_log journal_atc journal_detail journal_detail_log journal_main journal_main_log journal_main_temp1 lastcash lastcv lastreconbalance law_appointment law_branh_setup law_cases_entry law_cases_entry_client law_cases_entry_law law_case_document law_case_meeting law_case_type law_client law_consultation law_court_setup law_court_type law_document_type law_hearing_schedule law_judge law_lawyer law_law_setup law_witness listofcashadvance majorfund migrated_apv migrated_apv_details mop nddrmf office_subcode offsetted_trans_record open_dr payee pettycashfund pettycash_replinishment petty_cash_expense_details petty_cash_released petty_cash_request petty_cash_request_details postdated postinglog po_offset_payment ppestorage ppetypes ppe_category ppe_group printedchecklog printeddvless printedvoucherlogs project_acct_types receive_payment reconcialtionlogs reconlastbalance recon_records recon_uncleared referencemodel reimburse reimbursement_expense_details reimbursement_request reimbursement_request_details replenishment replenishmentl_liq replinished_trans request_for_inspection_detail request_for_inspection_main request_for_payment resources return_casl rfp rfp_details rfp_liquidation sample setup_check setup_check_dtl signatories signature signups sigtype slmigrate sord1detail sord1main sord2detailaddfunds sord2detaildisbursement sord2main specialaccess specialaccesspermission subaccount_types subsidiarymodel subsidiarymodel_others sub_classification_setup suppliesledger_detail suppliesledger_main systemformproperties systemforms systemprofile systemprofileforms systemprofileorders systemreportingmanager systemroleprofile systemuserroleprofile system_log table2 taxdec tbl_bank_balances tbl_changeinequity tbl_dtr_jo tbl_dtr_temp_jo tbl_duplicate tbl_equity tbl_equity_compa tbl_equity_conso tbl_gso_signatories tbl_leaves tbl_leaves_dtl tbl_property_contract tbl_user_logs temp tempapaccount temp_ckd temp_ckd_copy temp_gj temp_sef terms textfileexclusionmodel transaction_logs transpo_setup typeofassets undeposited_collection unithistory used_land user_logs vet_animal_health_monitoring void_check_log voucher voucher_computation voucher_dtl .	select column