* PERIODCOVERED MONTHS YEAR PREPAREDBY POSITION1 REVIEWEDBY POSITION2 PDESCRIPTION LOCATION AREA VENDOR CPRICE REMARKS TYPE GUID

* ID TRANSNO DATE REMARKS REFERENCE TS USERID

* id GAFNO GAFDATE TXNNO PRNO RESDATE MODEID MODENAME PRAMOUNT PPAMOUNT PAIDTOSUPPLIER PURCHASEAMOUNT CHANGE REFERENCE REIMBURSEMENT PURCHASEAMOUNT1 CHANGE1 REFERENCE1 SUPPLIERID SUPPLIERNAME ADDRESS PONO PODATE CONTACTNO POAMOUNT PLACEDELIVERY DELIVERYTERM DELIVERYDATE PAYMENTTERM PURPOSE ENDUSERID ENDUSER CHARGING STATUS DELIVERYSTATUS PROCESS ORDERID ORDERNAME INCHARFEID INCHARGENAME FACILITATEDID FACILITATEDNAME CHEQUE USERID TS USERDEPTID REFID

* id MAINID ITEMID DESCRIPTION QTY UOM UCOST GUID GRPID

* ID sched_group Type StartDate EndDate AllDay Subject Location Description Status Label ResourceId ResourceIds ReminderInfo RecurrenceInfo GUID Notes Initiator bride_ groom_ bride_name groom_name date_of_death trans_date tomb_no contact_person contact_no expiration_date

* ID ParentID TransId frmName Message SenderId Sender ReceiverId Receiver TimeStamp Status

* id Level Approval Frm ApprovalStatus SOF ORDER STATUS

* Id FrmID FrmName TransID Reference TransDate TransTitle Level ApprovelLevel signId signDate Status Remarks amount Comments CurrentSender CurrentReceiver NotifID InitID DeptOwnerID TS DEV_NOTES

* ID series Reference Referenceid Trans GUID DocumentType SOFID SOFName DeptID PAR SERIESNO DR_OR Date PR PO POID Location Supplier Supplierid DeliveryDate Modes Remarks ReceivedFromID ReceivedFromName ReceivedFromPosition ReceivedFromDate ReceivedbyID ReceivedbyName ReceivedbyPosition ReceivedbyDate AccountableID AccountableName UID TS Encodedby FundClusterID FundCluster EntityName Locked Transaction Prev_Areno Pre_AreID Pre_AccountableID Pre_AccountableName IsExpense Status transfer_status

* areid areno accountableid accountablename transaction pre_areno pre_accountableid pre_accountablename userid ts

* ID Referenceid assetareID ACID Account ACIDCode Qty Unit ItemID Description AssetNumber UnitCost TotalCost PPEID AcquiredDate ItemGUID ProductNum SerialNum Model Life UnitStatus GUID GRPID

* ID Fname Lname Mi age positions address Contact Skills Image UID TS Status

* ID Code Name

* ID AssetID AssetName Date Remarks RequestorName RequestorID GUID

* ID assetareID ACID Account ACIDCode GUID Qty Unit Description AssetNumber UnitCost TotalCost PPEID AcquiredDate ItemGUID ProductNum SerialNum Model Life UnitStatus

* ID Date RefNum GUID requestorid requestorname purpose datestart dateend approverid approvername typeofrequest remarks UID TS Status

* ID MainID GUID assetid barcode assetnumber assetName amount Status RequestorsID

* id series requestingId requestingType requestNo requestDate Status UID recommendid recommendname receivedid receivedname verifiedid verifiedname recommendDes receivedDes verifiedDes recommendDate receivedDate verifiedDate TS

* id mainid itemno itemid itemname reason_a reason_b reason_c reason_d reason price status intended_usersID intended_usersName intended_use employment_status

* ID MainID Qty Unit AssetID Description AcquiredDate PropertyNo ARENo NameID NameofEndUser UnitValue TotalValue GUID GRPID

* ID series PRNo Date LocalGov Disposal Repair ReturnedStock Others Specify CntrlNo PRSNo Day1 of1 Year1 return1a return1aID return1a_d return1a_dt return1b return1bID return1b_d return1b_dt Day2 of2 Year2 return2a return2aID return2a_dt return2a_d return2b return2bID UID withattached TS Status

* ID series FundCluster PTRNo Date AREID ARENum FromID FromName TOID ToName IsDonation Reassignment Relocate Others Specify Reason Approver1Name Approver1Designation Approver1DeptID Approver1DeptName Approver1Date Approver2Name Approver2Designation Approver2DeptID Approver2DeptName Approver2Date Approver3Name Approver3Designation Approver3Date Approver1ID Approver2ID Approver3ID InspectedName ReceivedName InspectedDate ReceivedDate UID Status TS

* ID MainID AssetID AcquiredDate PropertyNo usefullLife ARENumber Description Quantity Amount Unit Condition GUID GRPID

* ID GUID MainID PPEID BarCode AssetNumber AssetName Amount Status

* ID GUID Date reference RequestorId RequestorName DateStart DateEnd PreparedbyID PreparedName Purpose Remarks UID TS Status

* ID IssueID IssuedRef GUID date Reference RequestorID RequestorName ReceivedbyID ReceivedbyName Processbyid ProcessbyName ItemStatus Status Remarks UID TS

* Id GUID IssuedGUID IssuedID IssuedReference BarCode AssetNumner AssetName AssetID Status Amount

* ID MainID DozerBladeAssembly CuttingEdges DraglineBucket BackhoeBucket FairleadAssemblyForCrane Compressor BoomAssembly LiftingBlock RiperAssembly EndBits ClamshellBucket DitchingBucket TaglineAssembly Cables BoomPulley Others

* ID MainID MasterCylinderAssembly

* ID MainID FrontSeat RearSeat OperatorSeat

* ID MainID Front Rear

* ID MainID GeneratorAlteratorAssembly StarterAssembly VoltageRegulatorAssembly SolenoidAssembly IgnitionCoilAssy Magneto DistributorAssymbly2CapRotor WiperAssembly HeadlightAssembly HeadAndTailLightAssy Battery ClutchAssembly

* ID MainID OperatingConditionally InjectionPumpAssembly InjectionNozzleAssy FuelPumpAssembly CylinderHeadAssembly WaterPumpAssembly RadiatorAssembly AirCleanerAssembly CarburatorAssembly GovernorAssembly TurboCharger OilCoolerAssembly NoOfCylinder

* ID MainID SprocketAssembly DriveChain

* ID MainID HourServiceMeter Speedometer Tachometer TemperatureGauges ConverterOilTemperatureGuages

* ID EquipmentType Cost UnitSerial PropertyNo PPEID EngineSerial AcquiredDate ReportedDate Inspector Designation UID TS Remarks

* ID MainID Front Rear

* ID MainID PowerSteeringSystem SteeringClutchAssemblyWithDiscPlateAndBreakLining

* ID MainID FrontSpringAssembly RearSpringAssembly

* ID MainID TrackLinkAssembly IdlerAssembly TrackAdjusterAssy TrackRollerAssy CarrierRollerAssy TorqueConverter BodyCabFenders ChassisFrame WindShield FuelTankAssembly HydraulicSystem HydraulicPumpAssembly HydraulicMotorAssembly HydraulicHoses ControlValveAssembly HydraulicCylinder TransmissionAssembly TransferCaseAssembly

* ID MainID TiresFront TiresRear SpareTire

* ID BatchGUID Article Qty UnitCost TotalCost PropertyNo DateAcquired NoOfYearsInService AccumDepreciation Disposition1 Disposition2 Disposition3 Disposition4 Disposition5 Appraisal ORNum Amount

* ID BatchGUID Date Reference AccountableID AccountableName AccoutableDesignation Station Requestedby RequestedDesignation Approvedby ApprovedbyDesignation Inspector Witness RequestedbyID ApprovedbyID InspectorID WitnessID UID TS Days Months Years Status

* ID series GUID PTCNo PTCDate Name NameID Position DepartmentID Reason Location Verified VerifiedID Noted NotedID Approved ApprovedID Requested RequestedID DateRequested TS UID Status

* id MainID ARENo AccountableID Accountable ItemID Description Qty Cost

* PATH TYPE ISLIMIT

* id bacc_proj_id trans_date ref_no name_of_project remarks proc_type

* id bacc_proj_id project_name ref_no philgep pre_bid bidd_conference

* id bacc_proj_id proj_name trans_date ref_no supplemental remarks

* id bacc_proj_id proj_name trans_date ref_no mop remarks

* id bacc_proj_id proj_name trans_date ref_no mop date_effictive remarks

* id org_id description

* id proj_id entry_type business_id business_name date_invitation date_receipt attachment ts

* id type description order

* id pre_id file_name file_path file_size stat uid

* id process_name orderby

* id proc_type ref_no trans_date steps pow_id doc_ref title_of_project ABC SOF pre_proc posting pre_bid bid_opening post_qua noa posting2 perf_sec sp_resolution contract_date ntp_issuance ntp_effective winning_bidder bidder_id contract_cost contract_duration remarks ts

* id bac_proj_id file_size file_name file_path file_full_path entry_type ts

* ID ProcessName

* ID ProcessName POWID POWNum Status DateCompleted

* id doc_id document employee_id employee_name sequence notif

* ID ProcessName Orders ProcessType

* ID ProcessName OrderNo ProcurementType

* id ref trans_date pow_num title_project ABC sof duration ts

* id description terms days status DP_percent DP_days PB_percent PB_days Completion_percent Completion_days Retention_percent Retention_days encode_userid ts

* ID BusinessType Control Status userid TS

* PARTS SUBPARTS TYPE

* Currency Code Symbol

* ID DELIVERY_STATUS ACCEPTANCE_STATUS DELIVERY_PHASEN DELIVERY_PHASE TRANSAID TRANSFORM USERID TS

* ID DOCID DOCUMENT FILE STREAM TS

* id pre_id pre_ref pow_id pow_ref pr_id pr_ref can_id can_ref po_id po_ref rec_id rec_ref req_id req_ref iss_id iss_ref itm_id itm_ref

* id trans_no trans_date browse_id browse_no driver_name vehicle_id vehicle_name qty supplier fuel_type fuel_subtype requested_id requested_by approved_id approved_by status savedate fs_type

* ARENo PONo ReceivedFrom ReceivedFromName ReceivedBy ReceivedByName ARE_Number Remarks PreviousAccountable PreviousAccountableName ARE_Date ARE_Status ARE_Supplier Prev_ARE_Number GeneralPurchaseItem_ID fund_code ReceivedBy_POSITION ReceivedFrom_POSITION PR_Number Delivery_Date Location Mode PreparedBy PreviousAccountable2

* ARENo ItemNo PropertyNo Amount Quantity Unit Description Remarks AREdtl_id Unit_Cost

* id form_name form_status date_saved

* ItemSetup_No ItemSetup_ANo ItemSetup_ANa ItemSetup_IN ItemSetup_UoM ItemSetup_UC ItemSetup_E ItemSetup_T item_group item_office item_date NEWITEMID UID

* SpecsID ItemID Description GRPID

* id form_id form_name signatory_type employee_id prefix employee_name employee_position signatory_status date_saved

* Id FrmName SignatoryType EmployeeName DefaultValue Position Note Include GRP Order Routing Status AliasType

* Id FrmName SignatoryType DefaultValue Note Include GRP Status

* Id UserID FrmName SignatoryType EmployeeName DefaultValue Position Note Include GRP Order Routing Status AliasType ApproveDate

* ID SIGNATORYID POSITION

* Id FrmName SignatoryType SignatoryName SignatoryID Position UserID tranID GRP AliasType ApproveDate

* Id FrmName SignatoryType SignatoryName SignatoryID Position UserID tranID GRP

* SysPK_PP pp_person_code pp_prefix pp_lastname pp_firstname pp_middlename pp_suffix pp_fullname pp_dob pp_birthplace pp_sex pp_civilstatus pp_citizenship pp_height pp_weight pp_bloodType pp_GSIS_no pp_PAGIBIG_no pp_PHILHEALTH_no pp_SSS_no pp_TIN pp_Address1 pp_zipcode1 pp_Tel_no1 pp_Address2 pp_zipcode2 pp_Tel_no2 pp_email pp_cell_no pp_agency_employee_no pp_religion pp_birthplace_id pp_Address1_id pp_Address2_id pp_Department_id pp_SaveUser pp_SaveDate pp_ModifiedUser pp_ModifiedDate pp_NickName pp_address1_st pp_Profession pp_Priority pp_ICR

* id IARID LINKID PERSONNELID PRESONNELNAME DATE PROCESS USERID FORM TS

* id main_id item_id ItemNo item_name uom transfer_qty unit_cost amount remarks EstimatedLife GUID GRPID status

* id series ics_transno ics_num ics_transdate ics_deptfromID ics_deptfromName ics_deptfromPOS ics_deptfromDate ics_depttoID ics_depttoName ics_depttoPOS ics_depttoDepartment ics_depttoDate ics_fundcluster_id ics_fundcluster_name ics_account_id ics_account_name ics_status ics_remarks date_acquired SOF suppid Supplier PONnum PRnum refnum rrid icsid drnum savedate userid username Trans SPVal Modes Pre_ICSID Prev_ICSNo Pre_AccountableID Pre_AccountableName FundCluster FundClusterID Location

* ID GUID Infra_Canvass_Main_ID SupplierID SupplierName Address Contact powinframateriallaborID ItemID ItemDescription Qty Unit UnitPrice Total IsAwarded Status

* ID GUID Date Reference PRID PRRef powinframainID PowNum Project Remarks SAINum OBRNum Status TS UID

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* ID infra_PO_main_ID GUID powinframateriallaborID ItemID ItemDescription Qty Unit UnitPrice TotalCost

* ID PowID PRID CSID GUID Date Reference Project PowRef PRRef CSRef SupplierID SupplierName Address Contact Remarks MOPID MOPName DeliveryPlace DeliveryDate DeliveryTermDays DeliveryTermCaption PaymentTermDays PaymentTermCaption SAINum OBRNum UID TS Status

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* ID GUID powinframateriallabor_ID infra_pr_main_id ItemID Qty Unit Description UnitCost TotalCost

* ID GUID Reference Date ProjID PowNum ProjectName powinframainID Purpose DepartmentID DepartmentName SAINum SAIDate OBRNum OBRDate UID TS Status

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* ID GUID infra_po_main_id powinframateriallaborID ItemID ItemDescription Unit Qty UnitPrice TotalCost

* ID GUID Date Reference PowRef PRRef CSRef PORef PowID PRID CSID POID Project SAINum OBRNum SupplierId SupplierName Address Contact Remarks Departmentid DepartmentName InvoiceDate InvoiceNum Status TS UID

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* ID CATEGORY PERSONNELID PERSONNELNAME STATUS

* id no main_id unit qty item_id item_description po_id brand rec_qty unit_cost expirydate remarks status savedate GUID GRPID MFTD LotNo Serial Model Color

* id supplier_id supplier_name supaddress series seriesno ref_no trans_date dept_id purpose invoice_no invoice_date pr_id prnum prdate po_id advance_id ponum podate sof delivery_status inspected_by inspectedby_name date_inspected ok_inspect accepted_by acceptedby_name acceptedby_name1 date_accepted acceptance_status browsed status savedate trans userid userdeptid category

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* id trans_no trans_type trans_date group_detail_id item_description po_id po_no pow_id pow_no qty multiplier uom unit_cost serial_no vendor_id vendor_name company_id resp_center_id user_id rec_id wit_id GUID status savedate

* ID CATEGORY NOTES STATUS

* id guid dept_id dept emp_id emp savedate status

* log_id trans_type trans_id inv_master trans_qty inv_cost ret_qty item_no project_id ret_type status trans_date encoded_id modified_id

* log_id trans_type trans_id inv_master trans_qty inv_cost ret_qty item_no project_id ret_type status trans_date encoded_id modified_id

* id item_id unit beginning_bal qty_in qty_out qty_bal location unit_cost amount status savedate

* id transID transDtlID transName transNum itemid io qty unitcost brand itemtype classification inventorytype MFTD LotNo ExpDate officeid status GUID TS

* id item_id item_name item_code unit_measure unit_value percard_count physical_count shortage_count shortage_value remarks date_save inv_status

* ID ITRNO ITRDATE FROMACCOUNTABLEID FROMACCOUNTABLE TOACCOUNTABLEID TOACCOUNTABLE ENTITYNAME FUNDCLUSTERID FUNDCLUSTER TRANSFERTYPE OTHERS REASON APPROVEDID APPROVED APPROVEDPOS APPROVEDDATE RELEASEDID RELEASED RELEASEDPOS RELEASEDDATE RECEIVEDID RECEIVED RECEIVEDPOS RECEIVEDDATE USERID STATUS TS trans_type

* DTLID MAINID ICSID DATEACQUIRED ITEMNO ICSNO DESCRIPTION AMOUNT CONDITION ITEMID GUID GRPID STATUS TS

* id series trans_no trans_date rfi_id rfi_no supplierid suppliername browsefrom SAI_No SAI_Date sinum prnum ponum sof division dept_id purpose mntnce_ord_no browsed advance_id iar_id status transaction savedate userid userdeptid typeid

* TypeID Code TypeName TypeStatus

* id main_id No item_id item_name specs brand uom qty current_qty widrawn_qty unit_cost Exp_date remarks browsed savedate status GUID GRPID

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* id mainid itemid qty status ts

* id type status code order_by group_type userid ts title_id

* id trans_no trans_date widrawal_id widrawal_no dept_id remarks browsed status savedate

* id main_id item_id item_name uom ret_qty remarks status

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* id itemid specification ts

* group_id group_description status group_type group_code order_by userid ts title_id

* id transdate series transnum preid vehicleid casaname mechanic mechanicid indorse indorseid pickup pickupid pickupdatetime serviceperformed status completiondate userdeptid userid

* id section_id section_name sectionhead_name applicationno applicationdate preparedby_id preparedby_name verifiedby_id verifiedby_name status

* id mainid employee_id employee_name task scheduledate scheduletime_from scheduletime_to location_id location_name

* id activity_type section_id section_name activity_name activity_status

* id agegroup typeofactivity venue lgu date status

* id mainid name barangay age sex contactno email signature

* id category_name category_inchargeId category_inchargeName section_id section_name cat_status

* id main_id category_id category_name category_head cat_det_status

* id facility_name facility_location facility_remarks fac_status

* id section_id section_name dept_id dept_name person_id person_name applicationno applicationdate activity_name activity_datetimefrom activity_datetimeto remarks preparedby_id preparedby_name approvedby_id approvedby_name fac_status

* id main_id facility_id facility_name material_equipment quantity umeasure facd_status

* id disposal_name location gd_status

* id transno transdate date_requested req_type req_company_id req_company_name req_person_id req_person_name barangay_id barangay_name purok_id purok_name gp_malata gp_dilimalata gp_hazardous gp_recyclable gp_others others load_count pickup_schedule vehicle_id vehicle_name vehicle_plateno driver_id driver_name disposal_area_id disposal_area actual_datepickup preparedby_id preparedby_name approvedby_id approvedby_name gp_status ts

* id main_id employee_id employee_name gpd_status

* id truck_name plate_no gbt_status

* id type nameofmother age address nameofbaby sex datedelivered typeofdelivery status

* id section_id section_name location_name remarks loc_status

* id main_id item_no item_description quantity u_measure available_inhouse u_cost total_cost boq_status

* id transno transdate section_id section_name location_id location_name departmentId departmentName insConductedbyId insConductedbyName insConductedDate statementFindings chk_a chk_b chk_b1 chk_c chk_d chk_e chk_f recommend_others requestedby_id requestedby_name approvedby_id approvedby_name mw_status

* id 1.1 1.2 1.3 1.4 1.5 2.1 2.2 2.3 2.4 3 4.1 4.2 4.3 4.4 4.5 5 6 7 8 9 10 11 12 13 14 15 16.1 16.2 16.3 17.1 17.2 17.3 17.4 17.5 18 19 20 21.1 21.2 21.3 21.4 22 23 24 25 26 27 28 29 30.1 30.2 30.3 30.4 30.5 30.6 30.7 31.1 31.2 31.3 r1.1 r1.2 r1.3 r1.4 r1.5 r2.1 r2.2 r2.3 r2.4 r3 r4.1 r4.2 r4.3 r4.4 r4.5 r5 r6 r7 r8 r9 r10 r11 r12 r13 r14 r15 r16.1 r16.2 r16.3 r17.1 r17.2 r17.3 r17.4 r17.5 r18 r19 r20 r21.1 r21.2 r21.3 r21.4 r22 r23 r24 r25 r26 r27 r28 r29 r30.1 r30.2 r30.3 r30.4 r30.5 r30.6 r30.7 r31.1 r31.2 r31.3

* id bname bage bstatus bdateofbirth baddress bcontactnumber bdateofmarriage bplaceofmarriage baddressaftermarriage bhighesteducationalattainment bemployment bincome bregular birregular bsignature gname gage gstatus gdateofbirth gaddress gcontactnumber gdateofmarriage gplaceofmarriage gaddressaftermarriage ghighesteducationalattainment gemployment gincome gregular girregular gsignature status date bplaceofbirth gplaceofbirth

* id transno transdate section_id section_name section_head datefrom dateto preparedby_id preparedby_name checkverifiedby_id checkverifiedby_name pmw_status

* id main_id pmw_date activity_id activity_name location_id location_name employee_id employee_name pmwdet_status

* id project_name projecthead_id projecthead_name proj_status

* id transno transdate section_id section_name location_id location_name person_id person_name dept_id dept_name remarks requestedby_id requestedby_name approvedby_id approvedby_name rmr_status

* id main_id particulars datetimefrom datetimeto rmrd_status

* id main_id item_no item_description quantity u_measure available_inhouse u_cost total_cost boq_status

* id transno transdate requestedbyId requestedbyName requestedDate departmentId departmentName request_description categoryId categoryName categoryHead insDateReceiptRequest insConductedbyId insConductedbyName insConductedDate statementFindings chk_a chk_b chk_b1 chk_c chk_d chk_e chk_f recommend_others boq_DateRequestReceivedGSO boq_GSOrepId boq_GSOrepName boq_DateReturnedEndUser boq_requestorEndUserId boq_requestorEndUserName datetimerepaired verifiedbyId verifiedbyName approvedbyId approvedbyName completiondate postConductedbyId postConductedbyName rfir_status

* id requestfor departmentid departmentname requestedbyid requestedbyname itemcode applicationno applicationdate reasons remarks approvedby materialsreceivedby gso_engineeringoffice status

* id mainid itemCode particular quantity natureofrequest

* id transno transdate section_id section_name section_head datefrom dateto preparedby_id preparedby_name checkverifiedby_id checkverifiedby_name rf_status

* id main_id rf_date activity_id activity_name location_id location_name employee_id employee_name rfdet_status

* id transno transdate section_id section_name section_head preparedby_id preparedby_name checkverifiedby_id checkverifiedby_name rf_status

* id main_id employee_id employee_name location_id location_name activity_name df_date dt_date rodet_status

* id section_name sectionhead_ID sectionhead_name section_status

* id section_id section_name employee_id employee_name mem_status

* id waste_name w_status

* id transno transdate date_requested req_type req_company_id req_company_name req_person_id req_person_name barangay_id barangay_name purok_id purok_name section_id section_name section_head w_watersource w_waterquality w_volume w_purpose delivery_schedule vehicle_id vehicle_name vehicle_plateno driver_id driver_name actual_deliverydate preparedby_id preparedby_name approvedby_id approvedby_name wd_status ts

* id main_id employee_id employee_name gpd_status

* SkinName UseDefaultLookAndFeel UseWindowsXPTheme

* ID TXN DATE

* id modeDesc

* ID Component_Type Status

* id trans_no trans_date reference_id reference_no drivers_id drivers_name vehicle_plate_no passenger_id passenger_name destination purpose departuretime_from_office arrivaltime_at_destination departuretime_from_destination arrivaltime_at_office approximate_distance_oftravel gear_oil_issued lubricant_oil_used brake_fluid_used grease_oil_used speedometer_reading distance_oftravel remarks gasoline_balance_tank gasoline_issued_byoffice gasoline_add_purchased gasoline_deduct_duringtrip gasoline_balance_endoftrip diesel_balance_tank diesel_add_purchased diesel_deduct_duringtrip diesel_endoftrip date_save status type

* id department dept_id driver driver_id status

* ID Code Description UOM Unit_Cost Status

* id trans_no trans_date requesttype browse_no driver_name driver_id vehicle_id vehicle_type PlateNo amount qty supplier supplier_id address fuel_type fueltype_id requestor_id requestor user dept dept_id brgy brgy_id refuelDate lubricantsid lubricants lubricantDesc others remarks Status savedate userid deptuserid

* id mainid itemid itemName unit qty cost guid

* ID FuelType status

* ID LubricantType status

* id nature_ofrequest nor_status

* id it_equipment air_condition plumbing electric office_building lab_med_equip office_equip furniture_fixture others others_text req_dept_id req_dept req_by_id req_by details rec_by_id rec_by date action_taken savedate status

* id particulars are_no type_problem savedate status

* ID series DateRequest ReportedBy Type Reason Particulars Quantity Remarks Status

* id main_id ItemID particulars qty natureofrequest_id natureofrequest New Urgent Additional status

* id series trans_no trans_date rfi_id rfi_no plateid plateno vehicletype description serialno brandmodel acquired amount dept_id department_name empid empname driver_id driver_name requestedid requestedname approvedid approvedname receivedid receivedname reason remarks Status indorse_status date_save userdept_id userid userdeptid

* ID Description Component Type Skill Skill_Rate Skill_Qty Help_Rate Help_Qty Estimate_Hour Unit Cost_Estimate_Hr AD_Cost_Estimate_Hr Add_Difficulty Profit_Cost_Estimate_Hr Profit(20%) Job_Order_Cost Status

* ID Service_Type Status

* ID TransactionDate PlateNo Type OwnersName Department Description Color Make Model Year Status

* ID mainID RegLTO GSIS_From GSIS_To status

* id group_name status

* id vehicleid logDate remarks notes Onsite userid frm fmrid ts

* ID trans_date refNo registration vehicle vehicle_id driver driver_id PlateNo ARENo ModelYear ChassisNo TireSize status date_saved

* id mainID inspectionDate lastPMS lubricants odometer engineOil engine_id inspection_remarks work_description remarks status date_saved

* ID trans_no TransactionDate VehicleNo PlateNo Make MVFile ChassisNo EngineNo SerialNo ModelYear TireSize LTOReg ARENo Group Group_id IsServiceable Type Type_id FuelType Driver Driver_id Office Office_id Accountable Accountable_id AcquistionDate Amount PMS_Sched Status

* id main_id vehicleID vehicle_type plateID plate_no destination departure_time est_arrival_time reason_purpose status

* id trans_no reservation_no reservation_date dateof_use dept_id department_name empid empname contact_no remarks browsed status date_saved verifiedID verifiedName verifiedPos approvedID approvedName approvedPos

* ID TransactionDate VehicleName CRN_No OwnersName ORNo ORDate ORAmount EncumberedTo Color Model DatePurchased PurchasedAmount Location EstimateLife Condition MVFileNo PlateNo EngineNo ChassisNo Make Serial BodyType BodyNo YearModel GW NW SW NetCapacity Denomination PistonDisplacement NoCylinders FuelType Department FuelConsumptionLiter FuelConsumptionKM Registered Remarks Status

* id type status

* id description status date_saved

* id main_id description finding status date_saved

* id description status date_saved

* id main_id description finding status date_saved

* id description status date_saved

* id main_id description finding status date_saved

* id description status date_saved

* id main_id description finding status date_saved

* id trans_no check_date vehicle_plate_no driver_id driver_name remarks browsed status date_saved

* ID ParentID levels FRM_NAME PROCESSID SENDERID RECEIVERID MESSAGE TS SETTLED ACTUALID SENDTOACTUALID UserFullName

* ID CATEGORY WITHDECIMAL SEPARATOR WITHNEGATIVE NOTES STATUS

* id Ordinal

* DTLID MAINID REPID REPNAME REPCODE Particulars MFO_PAP UACSObjectCode Amount

* ID ORSNO SERIALNO DATE FUNDCLUSTER PAYEEID PAYEENAME OFFICE ADDRESS A_SIGID A_SIGNAME A_POSITION A_DATE B_SIGID B_SIGNAME B_POSITION B_DATE USERID DEPTOWNID TS STATUS

* DTLID ID DATE LUBRICANTS ODOMETER ENGINEOIL INSPECTIONS DESCRIPTION REMARKS FILTER

* ID PMSID DESC UNIT QTY COST TOTAL

* ID PLATEID UID PMSDATE PMSNEXT STATUS TS

* DTLID ID DATE ENDORSED SERVICE MECHANIC PICKBY PICKDATE PICKTIME

* id main_id pre_repair_no item_id item_no qty unit unit_cost articles remarks status savedate repair_type GUID

* id series trans_no trans_date browsed_id browsed_no department_id department_name findings recommendations inspectedid inspectedname completiondate approvedby approvedid status savedate userdeptid userid

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* ID GUID PowInfraMainID ItemID ItemDescription Qty Unit Km UnitPrice TotalCost GrandTotal

* Id GUID PowInfraMainID ItemID ItemDescription Percent Unit Qty TotalCost Remarks

* ID Reference GUID ProjectID ProjectName Address Date SOF Appropriation ProjectDescription ModeOfImplem Days UID Contractor TS Status EstimatedCost

* Id GUID PowInfraMainID ItemID ItemDescription Qty Unit UnitPrice Material Labor GrandTotal IsItem

* ID GUID PowInfraMainID ItemID ItemDescription Qty Unit NumDays UnitPrice TotalCost GrandTotal

* ID GUID PowInfraMainID SigItemNum Type Name Position

* ID GUID PowInfraMainID SOFID SOF

* Id GUID PowInfraMainID ItemID ItemDescription Percent Unit Qty TotalCost Remarks

* id mainId item_id item_qty UoM cost Total

* id act_item_id act_item_qty act_cost PowId PRID status

* id powid breakdown subbreakdown description amount

* id trans_id item_id detail status savedate

* id trans_id item_id detail status savedate

* id main_id details_type item_id description unit qty unit_cost total_cost unitadjustedcost adjustedcost directcost remarks savedate status GUID GRPID FUNDID GRPORDER

* id type_name proj_type pow_type status

* id main_id isMinor equipment_desc no_of_equipment hours rate cost

* id variation_id item_desc uom qty rate hours production cost ocm profit vat status ts user_id project_id remarks total_ocm_amount total_profit_amount total_vat_amount total_indirectcost total_directcost total_cost total_unitcost total_adjusted_unitcost guid guldDtl isManual type

* id main_id type_ unit qty rate cost type

* id main_id isHauling type_ no_personnel hours rate cost

* id main_id description no savedate status

* id powid type description number tdays drate tcost

* id pow_numbering series reference_no reference_date department_id project_id activity_id activity_date department_name project_title project_loc project_loc_barangay project_loc_CityProvince project_desc rationale project_start project_end mode_proc mode_proc_id modeImplementation pow_type appropriation sof_id sof issued_obligated authority project_duration savedate status happroved browsed Earmark bidamount frm userid userdeptid TXN guid IsBreakEditable IsABCEditable DirectCost OCM CProfit Vat TotalItemCost withBreakdown approve_userid

* ID TRANSID DOCS FILENAME TS

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* id main_id description no savedate status

* id pow_process pow_procstatus

* id pow_id requirement_type remarks req_date emp_id emp_name date_saved req_status

* id pow_id SOF_ID FUNID ACTID SOF_Description year amount save_date

* id trans_id ref_num rec_date rec_by particulars savedate status

* ID GUID ReportTitleGUID ReportTitle TableTitle TableDescription TableFooter Column1 Column2 Column3 Column4 Column6 Column7

* ID GUID ReportTitleGUID ReportTitle TableTitle TableDescription TableFooter Column110 Column111

* ID HeaderGUID GUID Name Caption ParentBandName ParentBandCaption

* ID HeaderGUID GUID Name TableName ParentBand BandCaption ColumnCaption ColumnFieldName Type

* ID GUID ReportTitle Header1 Header2 Header3 Header4 TS UID

* ID Col1 Col2 Col3 Col4 Col5 Col6 Col7

* ID HeaderGUID GUID TableTitle TableName TableDescription Orders IsBanded TableFooter

* ID Date GUID HeaderGUID H1 H2 H3 H4 ReportTitle TS UID

* id trans_id item_id detail status savedate

* id main_id item_id item_name item_no qty unit unit_cost article remarks browsed status savedate repair_type GUID

* id series trans_no trans_date indorse_no indorse_date pickupdatetime browsed_id browsed_no department_id department_name findings recommendations serviceperformed Vehicle VehicleType pri_type indorseid indorsename indorsedatetime mechanic mechanicid inspectedid inspectedname approvedid approvedname status indorse_status savedate browsed jobout uid userIndorseID userdeptid

* id main_id user_id user_fullname savedate status

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* ID REPORT LANDSCAPE PAPERKIND MLEFT MRIGHT MTOP MBOTTOM USERID

* pow_id pow_no pow_date project_title source_fund dept_id project_duration mode_procurement pupose browsed browsed_req status save_date

* id pow_id item_id charge_account qty unit_cost browsed_req save_date

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* Id FrmID FrmName TransID Reference TransDate TransTitle Level ApprovelLevel signId signDate Status Remarks amount Comments CurrentSender CurrentReceiver NotifID InitID DeptOwnerID TS DEV_NOTES

* LASTID

* id main_id contractor date_started target_completion_date no_of_extension revised_completion_date proj_status_completion proj_status_total_cost_inccured remarks person_incharge pre_bidding republication bid_opening savedate status

* ID DATE TXN ENTITYNAME FUND_CLUSTER PPE DESCRIPTION PROPERTYNO USERID TS STATUS

* DTLID MAINID DATE E_LIFE REFNO R_QTY I_QTY OFFICE B_QTY AMOUNT REMARKS

* ID MAINID Date Reference PurchaseQty BirthQty AOtherQty SaleQty SellingPrice TransferQty DeathQty ROtherQty FairValue BalanceQty Amount Remarks

* DTLID MAINID COMPONENTS ESTIMATED DATE REFERENCE DESCRIPTION COST ADJUSTMENTS CARRYING NATURE AMOUNT

* ID DATE LGU IDNO NAME TYPE LOCATION DESCRIPTION LENGTH WIDTH THICKNESS AREA FLOORNO FUNDID USERID TS STATUS FRM

* id prid template userid ts

* id prid SOF_ID ACTID SOF_Description year amount save_date

* id place_of_delivery status

* Id FrmID FrmName TransID Reference TransDate TransTitle Level ApprovelLevel signId signDate Status Remarks amount Comments CurrentSender CurrentReceiver NotifID InitID DeptOwnerID TS DEV_NOTES

* LASTID

* id ref_no trans_date pr_no dept_id dept shipment_to purpose status savedate

* id main_id item_id description uom qty unit_cost status savedate

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate

* Id FrmID FrmName TransID Reference TransDate TransTitle Level ApprovelLevel signId signDate Status Remarks amount Comments CurrentSender CurrentReceiver NotifID InitID DeptOwnerID TS DEV_NOTES

* LASTID

* id desc status module

* ID REQUESTDATE TXNNO REQUESTID REQUESTNAME REQUESTDEPT REQUESTDESC DATERECEIPT CONDUCTEDON FINDINGS RECOMMENDATION OTHERSPECIFY RECEIVEDBYID RECEIVEDBYNAME RECEIVEDBYDATE ENDUSERID ENDUSERNAME ENDUSERDATE REPAIRDATETIME APPROVEBYID APPROVEBYNAME VERIFIEDID VERIFIEDNAME COMPLETIONDATETIME CONDUCREDBYID CONDUCREDBYNAME UID STATUS TS

* DTLID ID CATEGORY PERSONNELID PERSONNELNAME

* DTLID ID ITEMDESRIPTION QUANTITY UOM AVAILABLE UCOST TCOST ITEMID

* id main_id inspectiontype_id inspectiontype_name status

* id main_id item_no particulars are_no type_of_problem notes status

* id series trans_no trans_date browsed_id browsed_refno dept_id action_taken findings recommendation remarks browsed saved_date type status

* id inspection_type inspection_status date_saved

* id main_id item_id Model Brand Color description specs qty unit unit_cost remarks savedate status GUID GRPID

* id mainid docs

* id mainid docs

* id mainid docs svp

* id series ref_no trans_date recom_date pow_id pr_id pr_no pr_date pr_office_id pr_office advance_id mode_proc mode_proc_id date_opening place time approve_budget cost can_id canvasser_id canvasser_name supply_delivery bid_sec bid_doc sig_name sof browsed type_bidding deliveryperiod modeaward projectname savedate status userid userdeptid canvass_datefrom canvass_dateto

* id rfqid supplierid suppliername

* ResourceID ResourceName Color

* id person_id person position status savedate

* ID SPCNUMBER SPCDATE CLUSTER PONO PRNO LOCATION SUPPLIER PROPERTYCARD SPECS PREPAREDBYID PREPAREDBY PREPAREDPOS USERID DEPTID ACCOUNTID ACCOUNTCODE ACCOUNTNAME TS STATUS

* ID MAINID DATE REFERENCE RQTY UCOST TCOST ITEMNO IQTY OFFICE OFFICEID OFFICER OFFICERID BQTY AMOUNT REMARKS

* id item_id description remarks date_saved userid status title_id

* id delivery_term status savedate

* group_id group_description status group_type group_code order_by userid ts title_id

* group_detail_id group_id subcatid itemgroup item_code SKU Model description specification uomid unit_measure brandid brandname generic_id size_lenghth size_width size_height size_weight reorder_qty min_qty pr_from endoflife whid whname quantity unit_cost classification account_code AccountName date_saved group_id1 title_id account_id item_status Batch_id base1_qty base1_price base1_uom base2_qty base2_price base2_uom item_transdate cost_center account_id2 incr_per item_type inventory_type isLumpSum UID item_year

* group_detail_id group_id description quantity unit_cost unit_measure classification account_code date_saved group_id1 title_id account_id item_status Batch_id base1_qty base1_price base1_uom base2_qty base2_price base2_uom item_code cost_center account_id2 incr_per specification

* id type status code order_by group_type userid ts title_id

* wm_id wm_code wm_name description compid compName clientID clientName address tstamp status costid costname userid

* id item_id supplier_id supplier_code supplier_name status ts

* id payment_term status savedate

* ID TRANSID DOCS FILENAME TS

* id breakdown sub_breakdown status

* id breakdown subbreakdown description remarks

* id projid breakdown subbreakdown description amount

* id prjid type description number

* id prjid type description number

* id ProjID ACTID SOFID SOF AccountCode BudgetDeptId ExpClass SubClass SubFund FundsID Desc year amount save_date

* id projid itemid item_desc uom qty ucost totalcost adjustedunitcost adjustedcosr directcost remarks guid grpid grporder ordx

* id prjid type description number

* id description

* ID item_id conversionID STATUS

* id SOF SOF_code

* id main_id res_no trans_date remarks saveby savedate status

* id main_id img_attach savedate status

* id main_id res_no trans_date remarks saveby img_attach savedate status

* id main_id img_attach savedate status

* ID series TRANSNUM TRANSDATE DEPTID DEPTNAME SECID SECNAME REMARKS INQIUREDBYID INQUIREDBYNAME PROVIDEDID PROVIDEDNAME TS UID STATUS

* ID MAINID ItemDescription Unit Quantity StatusofStock ItemID

* ID COMMAND ACTIVATE

* id main_id user_id user_fullname savedate status

* id main_id pre_main_id supplier_id item_id item_no item_description UoM quantity price_read price total_price status timestamp GUID GRPID

* id can_id yes no na verified_by verified_date save_date

* id series abstract_no trans_date browse_ref remarks pow_id pr_id rfq_id advance_id dept_id dept sof title justification browsed status savedate userdeptid userid noa_date frm Approved_Date approve_userid

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date priority status savedate cancel

* id can_id itemid supplierid suppliername unit_cost total_cost AwardQty IsEligible noa_status date_approved approved_id date_awarded status GUID noa_docs BrandName

* pkid refno appdate complains concern_type concerned_id receive complainant_id telno address status ts

* id bene_pkid sector title_docx type_docx remarks filename status ts

* pkid bene_pkid personid personname brgyid address

* pkid refno appdate caravandate actualdate caravanname purpose remarks status dt

* pkid mainid brgyid

* pkid mainid officeid

* pkid refno appdate service_caravan_id no_of_bene brgy venue office remarks status ts

* pkid service_type status

* id desription

* pkid refno appdate project employee emp_id status ts

* id mainid task sched_date sched_time

* pkid area_name status ts

* id mainid area_sub

* pkid refno appdate facility remarks monitored_id monitored_by area_all status ts

* id mainid area_id area_sub_id area_name stat remarks

* id mainid material area_id area_name

* pkid req_date refno dept_name dept_id remarks reason status ts reqby req_id

* id mainid particular item_id qty nature

* id main_id isMinor equipment_desc no_of_equipment hours rate cost

* id main_id isMinor equipment_desc no_of_equipment hours rate cost frm

* id variation_id item_desc uom qty rate hours production cost ocm profit vat status ts user_id project_id remarks total_ocm_amount total_profit_amount total_vat_amount total_cost total_directcost total_indirectcost total_unitcost total_adjusted_unitcost guid guldDtl isManual type fromid

* id main_id type_ unit qty rate cost type

* id main_id type_ unit qty rate cost type frm

* id variation_id item_desc uom qty rate hours production cost ocm profit vat status ts user_id project_id remarks total_ocm_amount total_profit_amount total_vat_amount total_cost total_directcost total_indirectcost total_unitcost total_adjusted_unitcost guid guldDtl frm isManual type

* id main_id isHauling type_ no_personnel hours rate cost

* id main_id isHauling type_ no_personnel hours rate cost frm

* id pow_id canvass_id project_id noa_issuance noa_receipt dole_approved security_type security_date security_amount dole_cshp noa_remarks session_date res_no sp_remarks ntp_issuance ntp_effective expected_date_completion ntp_remarks ts

* id form_id department_id series_include series_format series_order type dateStart

* id trans_id form_id signatory_type signatory_id signatory_name signatory_position sig_status date_saved

* id Description status display

* id main_id item_id item_no item_description specs reference_no unit qty unit_cost amount remarks status savedate GUID GRPID

* id powId series po_no po_date po_time reference_no trans_date supplier_name supplier_id suppcontact suppaddress MOPID MoP PoD PoDId PoD_date delivery_term delivery_term_sub payment_term payment_term_sub remarks received_date browsed_ref pr_no browsed pr_id sof canvass_id advance_id status savedate tracker_code submitted JID top userdeptid userid form Approved_Date approve_userid

* id main_id sig_id sig_type_id sig_type prefix sig_emp_id sig_emp designation date status savedate cancel

* id prerepair_id ramount vamount

* id po_id bill_id type percentage amount jid status

* id decription debit credit

* id cat_name status

* id main_id POWItemID ActivityItemID ActivityItemName item_id item_name qty unit_measure unit_cost total_cost remarks type status savedate GUID GRPID FUNDID GRPORDER

* id seriestype series pr_no pr_date pow_id ref_no ref_date pr_description dept_id dept section_id section_name sofid sof alobs_no alobs_date sai_no sai_date remarks mode_proc mode_proc_id status date_approved happroved savedate tracker_code submitted pr_refno pr_refdate browsed refid pr_type terms termDays place userid userdeptid txn_num ismerge supplierid suppliername supplierType IssuedDate approve_userid

* id ItemID PRID POWID Qty

* id main_id sig_id sig_type_id sig_type prefix sig_emp_id sig_emp designation date status savedate cancel

* ID PRID PR_REMARKS PR_STATUS BAC_REMARKS VOURCHER VOUCHER_STATUS USERID TS

* ID REASON FRM TS USERID

* id main_id sig_id sig_type_id sig_type prefix sig_emp_id sig_emp designation date status savedate cancel

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date priority status savedate cancel

* id supplier_code supplier_name TIN address email contactperson contactNum category owner_fname owner_mname owner_lname status timestamp supplier_type business_type business_nature termid

* ID DESC VAT NONVAT VAT_EWT NONVAT_EWT PERCENT STATUS withpo

* id supplier_name owner_fname owner_mname owner_lname address email contactNum status timestamp supplier_type

* id form_id trans_id signatory_type employee_id designation date type status save_date

* id UoM UoM_full status save_date type desc userid title_id

* id qty1 uom_id uom_name conversion_qty cvr_oum_id cvr_oum_name size_Length size_Width size_Height size_Weight status FACTOR

* id formID nameForm form_name status module form_status form_number MODULE_NAME APP_NAME series_type series_length series_start series_reset series_separator series_ref_no series_grouping department_id cert_id req_ver_doc req_ver_dept

* id nameForm form_name status module form_status form_number MODULE_NAME APP_NAME series_type series_length series_start series_reset series_separator series_ref_no cert_id req_ver_doc req_ver_dept

* id main_id user_id user_fullname savedate status

* ID TRANSID TRANSACTION REMARKS USERID USERNAME HOSTNAME MANCHINENAME COMPUTERNAME DETAILS ROW TS

* ID GRPID DATE TRIPNO DATE_TRAVEL DRIVERNAME PLATENO VEHICLE_TYPE PASSENGER DESTINATION PURPOSE TIME_DEPART TIME_ARRIVE TIME_DEPART_FROMO TIME_ARRIVE_TO BAL_TANK ISSUED_STOCK ADD_DURING_TRIP DEDUCTED_DURING_TRIP BALANCE_AFTER_TRIP GEAR_USE LOB_USE GREASE_USE SPEED_METER_BEGIN SPEED_METER_END SPEED_METER_DISTANCE DEPTHEAD DEPTHEADID USERID TS STATUS FORESIG FORESIGID

* DTLID GRPID MAINID PASSERGERNAME

* ID TRIPNO DATE DATEFROM DATETO

* ID TYPE STATUS

* ID series EQUIPMENT_TYPE PROPNO UNITSERIALNO ENGINESERIALNO COST DATE DATEREPORTED REMARKS INSPECTEDBY DESIGNATION STATUS TS UID TYPE

* ID MAINID MainParts Description Status Remarks

* DEPTID USERID

* ID Type StartDate EndDate AllDay Subject Location Description Status Label ResourceId ResourceIds ReminderInfo RecurrenceInfo ReservedID ReservedDtlID VRStatus

* ID Description Color

* TypeID TypeDesc Status TS

* ID DESC ORDER

* id series trans_no trans_date dept_id dept_name place_storage browsed rfi_id rfi_no rfi_frm Certified CertifiedPos Approved ApprovedPos Inspector Witness savedate status

* id certification_type cert_status

* id main_id certification_type_Id certification_type_name quantity transferred_to status

* id main_id item_id item_no unit qty description or_no amount disposed GUID GRPID savedate status

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* id trans_no trans_date dept_id purpose issuance_id issuance_no inpsector status savedate

* id main_id item_id item_name specs uom request_qty widrawn_qty Exp_date type remarks issuance_dtl_id savedate

* id main_id sig_type_id sig_type prefix sig_emp_id sig_emp date status savedate cancel

* amnt supplier_id can_id item_id

* amnt SupplierID can_id ItemID

select table acquisitionanddisposal adjustment_main advances advancesdtls appointments approvalcomments approvalprofile approval_process assetare assetarehistory assetareitems assetborrower assetfundcluster assethistory assetinventory assetissuance assetissuance_details assetpropertyrequest assetpropertyrequestdtls assetpropertyreturndetails assetpropertyreturnmain assetpropertytransfer assetpropertytransfer_items assetreservationdetails assetreservationmain assetreturned assetreturned_details asset_eu_accessories asset_eu_breaksystem asset_eu_cushion asset_eu_differentialassy asset_eu_electrical asset_eu_engine asset_eu_finaldrive asset_eu_gauges asset_eu_main asset_eu_profellershaftassy asset_eu_steeringsystem asset_eu_suspensions asset_eu_undercarriages asset_eu_wheels asset_iirupitem asset_iirupmain asset_ptc asset_ptc_dtl attachemnt_location bacc_1pre bacc_2invitationtobid bacc_7suplemental bacc_15resolution bacc_16noa bacc_commite_tag bacc_invitation_prebid bacc_preproc_docs bacc_pre_docs_entry bacc_proc_process bacc_proj bacc_proj_docs bacprocurementprocess bacprocurementprocessactual bac_document_receiver_seq bac_process_checklist bac_procurement_process bac_project_monitor business_terms business_type checklist currencylist delivery_inspection documents doc_tracking fuel_slip gso_acknowledgementreceiptforequipment gso_acknowledgementreceiptforequipment_details gso_forms gso_itemsetup gso_item_sub_details gso_signatories gso_signatories_list gso_signatories_list_eng gso_signatories_per_user gso_signatories_position gso_signatories_value gso_signatories_value_eng hr_person_profile iarprocess ics_details ics_main infra_canvass_details infra_canvass_main infra_canvass_signatory infra_po_details infra_po_main infra_po_signatory infra_pr_details infra_pr_main infra_pr_signatory infra_rr_details infra_rr_main infra_rr_signatory inspectioncategory inspection_and_acceptance_detail inspection_and_acceptance_main inspection_and_acceptance_signatory inventory inventory_category inventory_custodial_slip inventory_details inventory_lgu inventory_main inventory_master inventory_physical inventory_transfer inventory_transfer_dtls issuance issuancetype issuance_detail issuance_signatory item_assembly item_maincategory item_return item_return_detail item_return_signatory item_specifications item_subcategory jobout_repair jtbl_accomplishmententry jtbl_accomplishmententry_details jtbl_activity jtbl_ahdp jtbl_ahdp_details jtbl_category jtbl_category_details jtbl_facility jtbl_facilitysetup jtbl_facilitysetup_details jtbl_garbage_disposal jtbl_garbage_pickup jtbl_garbage_pickup_details jtbl_garbage_truck jtbl_livebirthregistry jtbl_location jtbl_maintenancework_boqdetails jtbl_maintenancework_main jtbl_marriage jtbl_mcs jtbl_periodic_maintenance jtbl_periodic_maintenance_details jtbl_projects jtbl_repairmaintenance_request jtbl_repairmaintenance_request_detail jtbl_requestforrepair_boqdetails jtbl_requestforrepair_main jtbl_requestmaterial jtbl_requestmaterial_details jtbl_routinary_functions jtbl_routinary_functions_details jtbl_routinary_others jtbl_routinary_others_details jtbl_section jtbl_section_members jtbl_waste_type jtbl_water_delivery jtbl_water_delivery_details lookandfeel material_request modeimplementation motorpool_component_setup motorpool_drivers_trip_ticket motorpool_driver_setup motorpool_equipment_setup motorpool_fuel_purchase motorpool_fuel_purchase_items motorpool_fuel_type motorpool_lubricant_type motorpool_natureofrequest motorpool_repair_inspection motorpool_repair_inspection_detail motorpool_request_repair motorpool_request_repair_detail motorpool_request_repair_main motorpool_serviceactivity_setup motorpool_service_setup motorpool_vehiclesetup motorpool_vehicle_details motorpool_vehicle_group motorpool_vehicle_logs motorpool_vehicle_maintenance motorpool_vehicle_maintenance_detail motorpool_vehicle_master motorpool_vehicle_reservation_details motorpool_vehicle_reservation_main motorpool_vehicle_setup motorpool_vehicle_type motorpool_weeklyvehiclecheck_external motorpool_weeklyvehiclecheck_external_detail motorpool_weeklyvehiclecheck_fluids motorpool_weeklyvehiclecheck_fluids_detail motorpool_weeklyvehiclecheck_internal motorpool_weeklyvehiclecheck_internal_detail motorpool_weeklyvehiclecheck_light motorpool_weeklyvehiclecheck_lights_detail motorpool_weekly_vehicle_check_main notifications numberformat ordinal_number ors_details ors_main pms_inspection pms_item pms_main pms_maintenance post_inspection_detail post_inspection_main post_inspection_signatory powinfrahaulage powinfraitems powinframain powinframateriallabor powinfrarental powinfrasignatories powinfrasof powinfrasummary pow_activity_items pow_activity_main pow_breakdown_list pow_details_dtl pow_details_dtl_ pow_detail_individual pow_detail_type pow_dupa_equipment pow_dupa_item pow_dupa_item_dtl pow_dupa_labor pow_equipment_required pow_equip_person pow_main_individual pow_main_individual_attachemnt pow_main_individual_signatory pow_personnel_required pow_processes pow_requirements pow_sof_detail po_receive_form ppacustom_table5109 ppacustom_table5110 ppa_band ppa_columns ppa_reportheader ppa_signatory1 ppa_tables ppa_tables_transactions pre_details_dtl pre_inspection_detail pre_inspection_main pre_inspection_report_approve_status pre_inspection_signatory print_settings program_of_work program_of_work_detail program_of_work_signatory project_proposal_routing project_proposal_routing_status proj_prog_act propertycard propertycarddtls propertycarddtls_biological propertycarddtls_other propertycard_other pr_mode_request pr_sof_detail purchase_order_pod purchase_order_routing purchase_order_routing_status purchase_request2 purchase_request2_dtl purchase_request2_signatory purchase_request_routing purchase_request_routing_status related_to_type requestforinspection requestforinspectionconcern requestforinspectiondtl request_for_inspectiontype_detail request_for_inspection_detail request_for_inspection_main request_for_inspection_type request_for_quotation_detail request_for_quotation_docs request_for_quotation_docs_copy request_for_quotation_docs_dummy request_for_quotation_main request_for_quotation_supplier resources rfq_report_signatory semiexpandablecard semiexpandablecarddtls setup_brand setup_delivery_term setup_group setup_group_detail setup_group_detail_copy setup_group_type setup_group_wh setup_item_supplier_default setup_payment_term setup_project_registration_attachemnt setup_project_registration_breakdown setup_project_registration_breakdown_default setup_project_registration_breakdown_list setup_project_registration_equipment setup_project_registration_equip_person setup_project_registration_funds setup_project_registration_items setup_project_registration_person setup_project_registration_sub_breakdown setup_qty_packing setup_sof sp_resolution sp_resolution_img sp_resolution_pre sp_resolution_pre_img suppliesinquiry suppliesinquiry_dtls system_settings tbl_canvass_approve_status tbl_canvass_detail tbl_canvass_documnets tbl_canvass_main tbl_canvass_signatory tbl_canvass_supplier tbl_cicro_complain_concern tbl_cicro_service_beneficiary_docx tbl_cicro_service_beneficiary_list tbl_cicro_service_caravan tbl_cicro_service_caravan_brgy tbl_cicro_service_caravan_dept tbl_cicro_service_caravan_no_bene tbl_cicro_service_caravan_setup tbl_documents_setup tbl_dps_accomplishement_entry tbl_dps_accomplishement_entry_dtl tbl_dps_facility_area_setup tbl_dps_facility_area_setup_dtl tbl_dps_facility_setup tbl_dps_facility_setup_dtl_area tbl_dps_facility_setup_dtl_material tbl_dps_request_material tbl_dps_request_material_dtl tbl_eceo_dupa_equipment tbl_eceo_dupa_equipment_dummy tbl_eceo_dupa_item tbl_eceo_dupa_item_dtl tbl_eceo_dupa_item_dtl_dummy tbl_eceo_dupa_item_dummy tbl_eceo_dupa_labor tbl_eceo_dupa_labor_dummy tbl_eceo_svp_record tbl_form_setup_series tbl_gso_signatories tbl_item_type tbl_po_detail tbl_po_main tbl_po_signatory tbl_prerepair_generate_percentage tbl_progress_billing tbl_prog_bill_setup tbl_project_category tbl_pr_detail tbl_pr_main tbl_pr_project_item tbl_pr_signatory tbl_pr_status tbl_reasons tbl_repair_signatory tbl_rfq_signatory tbl_supplier tbl_supplier_type_setup tbl_supplier___ tbl_transaction_signatory tbl_uom tbl_uom_conversion tbl_user_form tbl_user_form_copy tb_po_approve_status transaction_logs tripticket tripticketdtl tripticketmain type_of_road unserviceableequipment unserviceableequipmentchecklist userdepartmentaccess vehicle_reservation_calendar vehicle_reservation_calendar_resources vendor_type voucher_computation_dtls waste_material waste_material_certifications waste_material_certification_detail waste_material_details waste_material_signatory withdrawal withdrawal_details withdrawal_signatory _temp_canvass_supplier _temp_canvass_supplier_infra . 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 acquisitionanddisposal adjustment_main advances advancesdtls appointments approvalcomments approvalprofile approval_process assetare assetarehistory assetareitems assetborrower assetfundcluster assethistory assetinventory assetissuance assetissuance_details assetpropertyrequest assetpropertyrequestdtls assetpropertyreturndetails assetpropertyreturnmain assetpropertytransfer assetpropertytransfer_items assetreservationdetails assetreservationmain assetreturned assetreturned_details asset_eu_accessories asset_eu_breaksystem asset_eu_cushion asset_eu_differentialassy asset_eu_electrical asset_eu_engine asset_eu_finaldrive asset_eu_gauges asset_eu_main asset_eu_profellershaftassy asset_eu_steeringsystem asset_eu_suspensions asset_eu_undercarriages asset_eu_wheels asset_iirupitem asset_iirupmain asset_ptc asset_ptc_dtl attachemnt_location bacc_1pre bacc_2invitationtobid bacc_7suplemental bacc_15resolution bacc_16noa bacc_commite_tag bacc_invitation_prebid bacc_preproc_docs bacc_pre_docs_entry bacc_proc_process bacc_proj bacc_proj_docs bacprocurementprocess bacprocurementprocessactual bac_document_receiver_seq bac_process_checklist bac_procurement_process bac_project_monitor business_terms business_type checklist currencylist delivery_inspection documents doc_tracking fuel_slip gso_acknowledgementreceiptforequipment gso_acknowledgementreceiptforequipment_details gso_forms gso_itemsetup gso_item_sub_details gso_signatories gso_signatories_list gso_signatories_list_eng gso_signatories_per_user gso_signatories_position gso_signatories_value gso_signatories_value_eng hr_person_profile iarprocess ics_details ics_main infra_canvass_details infra_canvass_main infra_canvass_signatory infra_po_details infra_po_main infra_po_signatory infra_pr_details infra_pr_main infra_pr_signatory infra_rr_details infra_rr_main infra_rr_signatory inspectioncategory inspection_and_acceptance_detail inspection_and_acceptance_main inspection_and_acceptance_signatory inventory inventory_category inventory_custodial_slip inventory_details inventory_lgu inventory_main inventory_master inventory_physical inventory_transfer inventory_transfer_dtls issuance issuancetype issuance_detail issuance_signatory item_assembly item_maincategory item_return item_return_detail item_return_signatory item_specifications item_subcategory jobout_repair jtbl_accomplishmententry jtbl_accomplishmententry_details jtbl_activity jtbl_ahdp jtbl_ahdp_details jtbl_category jtbl_category_details jtbl_facility jtbl_facilitysetup jtbl_facilitysetup_details jtbl_garbage_disposal jtbl_garbage_pickup jtbl_garbage_pickup_details jtbl_garbage_truck jtbl_livebirthregistry jtbl_location jtbl_maintenancework_boqdetails jtbl_maintenancework_main jtbl_marriage jtbl_mcs jtbl_periodic_maintenance jtbl_periodic_maintenance_details jtbl_projects jtbl_repairmaintenance_request jtbl_repairmaintenance_request_detail jtbl_requestforrepair_boqdetails jtbl_requestforrepair_main jtbl_requestmaterial jtbl_requestmaterial_details jtbl_routinary_functions jtbl_routinary_functions_details jtbl_routinary_others jtbl_routinary_others_details jtbl_section jtbl_section_members jtbl_waste_type jtbl_water_delivery jtbl_water_delivery_details lookandfeel material_request modeimplementation motorpool_component_setup motorpool_drivers_trip_ticket motorpool_driver_setup motorpool_equipment_setup motorpool_fuel_purchase motorpool_fuel_purchase_items motorpool_fuel_type motorpool_lubricant_type motorpool_natureofrequest motorpool_repair_inspection motorpool_repair_inspection_detail motorpool_request_repair motorpool_request_repair_detail motorpool_request_repair_main motorpool_serviceactivity_setup motorpool_service_setup motorpool_vehiclesetup motorpool_vehicle_details motorpool_vehicle_group motorpool_vehicle_logs motorpool_vehicle_maintenance motorpool_vehicle_maintenance_detail motorpool_vehicle_master motorpool_vehicle_reservation_details motorpool_vehicle_reservation_main motorpool_vehicle_setup motorpool_vehicle_type motorpool_weeklyvehiclecheck_external motorpool_weeklyvehiclecheck_external_detail motorpool_weeklyvehiclecheck_fluids motorpool_weeklyvehiclecheck_fluids_detail motorpool_weeklyvehiclecheck_internal motorpool_weeklyvehiclecheck_internal_detail motorpool_weeklyvehiclecheck_light motorpool_weeklyvehiclecheck_lights_detail motorpool_weekly_vehicle_check_main notifications numberformat ordinal_number ors_details ors_main pms_inspection pms_item pms_main pms_maintenance post_inspection_detail post_inspection_main post_inspection_signatory powinfrahaulage powinfraitems powinframain powinframateriallabor powinfrarental powinfrasignatories powinfrasof powinfrasummary pow_activity_items pow_activity_main pow_breakdown_list pow_details_dtl pow_details_dtl_ pow_detail_individual pow_detail_type pow_dupa_equipment pow_dupa_item pow_dupa_item_dtl pow_dupa_labor pow_equipment_required pow_equip_person pow_main_individual pow_main_individual_attachemnt pow_main_individual_signatory pow_personnel_required pow_processes pow_requirements pow_sof_detail po_receive_form ppacustom_table5109 ppacustom_table5110 ppa_band ppa_columns ppa_reportheader ppa_signatory1 ppa_tables ppa_tables_transactions pre_details_dtl pre_inspection_detail pre_inspection_main pre_inspection_report_approve_status pre_inspection_signatory print_settings program_of_work program_of_work_detail program_of_work_signatory project_proposal_routing project_proposal_routing_status proj_prog_act propertycard propertycarddtls propertycarddtls_biological propertycarddtls_other propertycard_other pr_mode_request pr_sof_detail purchase_order_pod purchase_order_routing purchase_order_routing_status purchase_request2 purchase_request2_dtl purchase_request2_signatory purchase_request_routing purchase_request_routing_status related_to_type requestforinspection requestforinspectionconcern requestforinspectiondtl request_for_inspectiontype_detail request_for_inspection_detail request_for_inspection_main request_for_inspection_type request_for_quotation_detail request_for_quotation_docs request_for_quotation_docs_copy request_for_quotation_docs_dummy request_for_quotation_main request_for_quotation_supplier resources rfq_report_signatory semiexpandablecard semiexpandablecarddtls setup_brand setup_delivery_term setup_group setup_group_detail setup_group_detail_copy setup_group_type setup_group_wh setup_item_supplier_default setup_payment_term setup_project_registration_attachemnt setup_project_registration_breakdown setup_project_registration_breakdown_default setup_project_registration_breakdown_list setup_project_registration_equipment setup_project_registration_equip_person setup_project_registration_funds setup_project_registration_items setup_project_registration_person setup_project_registration_sub_breakdown setup_qty_packing setup_sof sp_resolution sp_resolution_img sp_resolution_pre sp_resolution_pre_img suppliesinquiry suppliesinquiry_dtls system_settings tbl_canvass_approve_status tbl_canvass_detail tbl_canvass_documnets tbl_canvass_main tbl_canvass_signatory tbl_canvass_supplier tbl_cicro_complain_concern tbl_cicro_service_beneficiary_docx tbl_cicro_service_beneficiary_list tbl_cicro_service_caravan tbl_cicro_service_caravan_brgy tbl_cicro_service_caravan_dept tbl_cicro_service_caravan_no_bene tbl_cicro_service_caravan_setup tbl_documents_setup tbl_dps_accomplishement_entry tbl_dps_accomplishement_entry_dtl tbl_dps_facility_area_setup tbl_dps_facility_area_setup_dtl tbl_dps_facility_setup tbl_dps_facility_setup_dtl_area tbl_dps_facility_setup_dtl_material tbl_dps_request_material tbl_dps_request_material_dtl tbl_eceo_dupa_equipment tbl_eceo_dupa_equipment_dummy tbl_eceo_dupa_item tbl_eceo_dupa_item_dtl tbl_eceo_dupa_item_dtl_dummy tbl_eceo_dupa_item_dummy tbl_eceo_dupa_labor tbl_eceo_dupa_labor_dummy tbl_eceo_svp_record tbl_form_setup_series tbl_gso_signatories tbl_item_type tbl_po_detail tbl_po_main tbl_po_signatory tbl_prerepair_generate_percentage tbl_progress_billing tbl_prog_bill_setup tbl_project_category tbl_pr_detail tbl_pr_main tbl_pr_project_item tbl_pr_signatory tbl_pr_status tbl_reasons tbl_repair_signatory tbl_rfq_signatory tbl_supplier tbl_supplier_type_setup tbl_supplier___ tbl_transaction_signatory tbl_uom tbl_uom_conversion tbl_user_form tbl_user_form_copy tb_po_approve_status transaction_logs tripticket tripticketdtl tripticketmain type_of_road unserviceableequipment unserviceableequipmentchecklist userdepartmentaccess vehicle_reservation_calendar vehicle_reservation_calendar_resources vendor_type voucher_computation_dtls waste_material waste_material_certifications waste_material_certification_detail waste_material_details waste_material_signatory withdrawal withdrawal_details withdrawal_signatory _temp_canvass_supplier _temp_canvass_supplier_infra .	select column