Recent
`dbfederation`.`oauth_access_tokens`
`qpsii_lgusystem`.`admin2_outgoing_document_details`
`budget`.`budget_setup`
`lgis_dum_app`.`ecao_certification_trans`
`bac_lgu`.`bac_members`
`mysql`.`innodb_index_stats`
`accounting`.`fvc_checklist_setup`
`online_hr`.`sp_official_name`
`performance_management`.`ipcr_entry_reviewed`
`accounting`.`customeradvanceslog`
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: budget
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`_columns`.*
`_columns`.`id`
`_columns`.`column_name`
`_columns`.`display_col`
`_columns`.`status`
`_columns`.`type`
`_columns`.`liquidate`
`accountbudget`.*
`accountbudget`.`ID`
`accountbudget`.`ParentId`
`accountbudget`.`AppropriationID`
`accountbudget`.`DepartmentId`
`accountbudget`.`SOFID`
`accountbudget`.`BYear`
`accountbudget`.`Description1`
`accountbudget`.`Description2`
`accountbudget`.`Amount`
`accountbudget`.`Amount2`
`accountbudget`.`Amount3`
`accountbudget`.`AllotmentReleased`
`accountbudget`.`SupplementalAmt`
`accountbudget`.`RealignmentAmt`
`accountbudget`.`Expense_Class_id`
`accountbudget`.`Expense_Class`
`accountbudget`.`Status`
`accountbudget`.`SOF`
`accountbudget`.`Category`
`accountbudget`.`CategoryID`
`accountbudget`.`CategoryOrder`
`accountbudget`.`SubCategory`
`accountbudget`.`SubCategoryID`
`accountbudget`.`SubCategoryOrder`
`accountbudget`.`UnderSubName`
`accountbudget`.`UnderSubID`
`accountbudget`.`UnderSubOrder`
`accountbudget`.`DescriptionID2`
`accountbudget`.`DescriptionID1`
`accountbudget`.`isContinuing`
`accountbudget`.`UID`
`accountbudget`.`TS`
`accountbudget`.`ApprovalStatus`
`accountbudget`.`StartDate`
`accountbudget`.`EndDate`
`accountbudget`.`WFPID`
`accountbudget`.`BudgetType`
`accountbudget`.`ORNo`
`accountbudget`.`ProjectName`
`accountbudget`.`projectId`
`accountbudget`.`Purposed`
`accountbudget`.`SheetName`
`accountbudget`.`devremarks`
`accountbudget_copy`.*
`accountbudget_copy`.`ID`
`accountbudget_copy`.`ParentId`
`accountbudget_copy`.`AppropriationID`
`accountbudget_copy`.`DepartmentId`
`accountbudget_copy`.`SOFID`
`accountbudget_copy`.`BYear`
`accountbudget_copy`.`Description1`
`accountbudget_copy`.`Description2`
`accountbudget_copy`.`Amount`
`accountbudget_copy`.`Amount2`
`accountbudget_copy`.`Amount3`
`accountbudget_copy`.`AllotmentReleased`
`accountbudget_copy`.`SupplementalAmt`
`accountbudget_copy`.`RealignmentAmt`
`accountbudget_copy`.`Expense_Class_id`
`accountbudget_copy`.`Expense_Class`
`accountbudget_copy`.`Status`
`accountbudget_copy`.`SOF`
`accountbudget_copy`.`Category`
`accountbudget_copy`.`CategoryID`
`accountbudget_copy`.`CategoryOrder`
`accountbudget_copy`.`SubCategory`
`accountbudget_copy`.`SubCategoryID`
`accountbudget_copy`.`SubCategoryOrder`
`accountbudget_copy`.`UnderSubName`
`accountbudget_copy`.`UnderSubID`
`accountbudget_copy`.`UnderSubOrder`
`accountbudget_copy`.`DescriptionID2`
`accountbudget_copy`.`DescriptionID1`
`accountbudget_copy`.`isContinuing`
`accountbudget_copy`.`UID`
`accountbudget_copy`.`TS`
`accountbudget_copy`.`ApprovalStatus`
`accountbudget_copy`.`StartDate`
`accountbudget_copy`.`EndDate`
`accountbudget_copy`.`WFPID`
`accountbudget_copy`.`BudgetType`
`accountbudget_copy`.`ORNo`
`accountbudget_copy`.`ProjectName`
`accountbudget_copy`.`projectId`
`accountbudget_copy`.`Purposed`
`accountbudget_copy`.`SheetName`
`accountclass`.*
`accountclass`.`ID`
`accountclass`.`LBP`
`accountclass`.`ParentID`
`accountclass`.`description`
`accountclass`.`AccountId`
`accountclass`.`Code`
`accountclass`.`Level`
`accountclass`.`status`
`accountclass_budget`.*
`accountclass_budget`.`ID`
`accountclass_budget`.`AppropId`
`accountclass_budget`.`byear`
`accountclass_budget`.`deptId`
`accountclass_budget`.`Amount`
`accountrevision`.*
`accountrevision`.`Id`
`accountrevision`.`SOF`
`accountrevision`.`BudgetType`
`accountrevision`.`BYear`
`accountrevision`.`DepartmentId`
`accountrevision`.`Acid`
`accountrevision`.`AccountDescription`
`accountrevision`.`Amount`
`accountrevision`.`UID`
`accountrevision`.`TS`
`accountrevision`.`Status`
`accountrevision`.`Revision`
`accountrevision`.`OrigAmt`
`accounts_parents`.*
`accounts_parents`.`ID`
`accounts_parents`.`GID`
`accounts_parents`.`ACID`
`accounts_parents`.`GEN_NAMES`
`accounts_parents`.`account_code`
`accounts_parents`.`account_description`
`accounts_parents`.`CLASSIFICATION`
`accounts_parents`.`SUBLASS`
`accounts_parents`.`t_account`
`accounts_parents`.`GEN_CODE`
`accounts_parents`.`CLASSIFICATION_CODE`
`accounts_parents`.`SUBCLASS_CODE`
`accounts_parents`.`markcontra`
`accounts_parents`.`ACCOUNT_SPACE`
`accountutilization`.*
`accountutilization`.`Id`
`accountutilization`.`AppropriationID`
`accountutilization`.`OBRID`
`accountutilization`.`SOFID`
`accountutilization`.`DepartmentId`
`accountutilization`.`BYear`
`accountutilization`.`RespCenterId`
`accountutilization`.`RespCenterName`
`accountutilization`.`Amount`
`accountutilization`.`Jan`
`accountutilization`.`Feb`
`accountutilization`.`Mar`
`accountutilization`.`Apr`
`accountutilization`.`May`
`accountutilization`.`Jun`
`accountutilization`.`Jul`
`accountutilization`.`Aug`
`accountutilization`.`Sep`
`accountutilization`.`Octo`
`accountutilization`.`Nov`
`accountutilization`.`Dece`
`accountutilization`.`UID`
`accountutilization`.`TS`
`accountutilization`.`Status`
`accountutilization`.`sheetName`
`accountutilization`.`ManualEntryGUID`
`accountutilization`.`Acode`
`accountutilizationbeginning`.*
`accountutilizationbeginning`.`Id`
`accountutilizationbeginning`.`AppropriationID`
`accountutilizationbeginning`.`SOF`
`accountutilizationbeginning`.`BudgetType`
`accountutilizationbeginning`.`BYear`
`accountutilizationbeginning`.`DepartmentId`
`accountutilizationbeginning`.`ACID`
`accountutilizationbeginning`.`_Code`
`accountutilizationbeginning`.`Description`
`accountutilizationbeginning`.`Amount`
`accountutilizationbeginning`.`Jan`
`accountutilizationbeginning`.`Feb`
`accountutilizationbeginning`.`Mar`
`accountutilizationbeginning`.`Apr`
`accountutilizationbeginning`.`May`
`accountutilizationbeginning`.`Jun`
`accountutilizationbeginning`.`Jul`
`accountutilizationbeginning`.`Aug`
`accountutilizationbeginning`.`Sep`
`accountutilizationbeginning`.`Oct`
`accountutilizationbeginning`.`Nov`
`accountutilizationbeginning`.`Dec`
`accountutilizationbeginning`.`UID`
`accountutilizationbeginning`.`TS`
`accountutilizationbeginning`.`Status`
`acctdummy`.*
`acctdummy`.`ID`
`acctdummy`.`Amount4`
`additionalbudget`.*
`additionalbudget`.`ID`
`additionalbudget`.`sofId`
`additionalbudget`.`appropriationId`
`additionalbudget`.`Btype`
`additionalbudget`.`GUID`
`additionalbudget`.`Yr`
`additionalbudget`.`OfficeID`
`additionalbudget`.`OfficeName`
`additionalbudget`.`ACID`
`additionalbudget`.`Code`
`additionalbudget`.`Account`
`additionalbudget`.`PrevBalance`
`additionalbudget`.`AdditionalAmt`
`additionalbudget`.`NewBudget`
`additionalbudget`.`Remarks`
`additionalbudget`.`UID`
`additionalbudget`.`TS`
`additionalbudget`.`Status`
`adjustment_minus`.*
`adjustment_minus`.`ID`
`adjustment_minus`.`BatchId`
`adjustment_minus`.`AppropriationId`
`adjustment_minus`.`Account`
`adjustment_minus`.`Code`
`adjustment_minus`.`SortBy`
`adjustment_minus`.`TransDate`
`adjustment_minus`.`Reference`
`adjustment_minus`.`BYear`
`adjustment_minus`.`OfficeID`
`adjustment_minus`.`OfficeName`
`adjustment_minus`.`FundId`
`adjustment_minus`.`FundName`
`adjustment_minus`.`ExpenseClassId`
`adjustment_minus`.`ExpenseClass`
`adjustment_minus`.`Amount`
`adjustment_minus`.`Remarks`
`adjustment_minus`.`User`
`adjustment_minus`.`Status`
`adjustment_minus`.`OrdinanceNo`
`adjustment_minus`.`OrdinanceDate`
`adjustment_plus`.*
`adjustment_plus`.`ID`
`adjustment_plus`.`BatchId`
`adjustment_plus`.`AppropriationId`
`adjustment_plus`.`Account`
`adjustment_plus`.`Code`
`adjustment_plus`.`SortBy`
`adjustment_plus`.`TransDate`
`adjustment_plus`.`Reference`
`adjustment_plus`.`BYear`
`adjustment_plus`.`OfficeID`
`adjustment_plus`.`OfficeName`
`adjustment_plus`.`FundId`
`adjustment_plus`.`FundName`
`adjustment_plus`.`ExpenseClassId`
`adjustment_plus`.`ExpenseClass`
`adjustment_plus`.`Amount`
`adjustment_plus`.`Remarks`
`adjustment_plus`.`User`
`adjustment_plus`.`Status`
`adjustment_plus`.`OrdinanceNo`
`adjustment_plus`.`OrdinanceDate`
`aipentry`.*
`aipentry`.`ID`
`aipentry`.`SOFID`
`aipentry`.`SOF`
`aipentry`.`StartDate`
`aipentry`.`EndDate`
`aipentry`.`OfficeID`
`aipentry`.`OfficeName`
`aipentry`.`grouping`
`aipentry`.`SectorID`
`aipentry`.`Sector`
`aipentry`.`accountID`
`aipentry`.`AppopriationID`
`aipentry`.`Account`
`aipentry`.`Year`
`aipentry`.`Code`
`aipentry`.`Description`
`aipentry`.`MOOE`
`aipentry`.`CO`
`aipentry`.`Amount`
`aipentry`.`groupid`
`aipentry`.`GroupName`
`aipentry`.`YearCount`
`aipentry`.`class1`
`aipentry`.`class2`
`aipentry`.`class3`
`aipentry`.`UID`
`aipentry`.`Status`
`aipentry`.`WFPID`
`aipentry`.`TS`
`aipentry_utilization`.*
`aipentry_utilization`.`ID`
`aipentry_utilization`.`AIPID`
`aipentry_utilization`.`SOFID`
`aipentry_utilization`.`SOF`
`aipentry_utilization`.`StartDate`
`aipentry_utilization`.`EndDate`
`aipentry_utilization`.`OfficeID`
`aipentry_utilization`.`OfficeName`
`aipentry_utilization`.`SectorId`
`aipentry_utilization`.`Sector`
`aipentry_utilization`.`AppopriationID`
`aipentry_utilization`.`Account`
`aipentry_utilization`.`Year`
`aipentry_utilization`.`Code`
`aipentry_utilization`.`Description`
`aipentry_utilization`.`MOOE`
`aipentry_utilization`.`CO`
`aipentry_utilization`.`ActualMOOE`
`aipentry_utilization`.`ActualCO`
`aipentry_utilization`.`UID`
`aipentry_utilization`.`TS`
`allotmentrelease`.*
`allotmentrelease`.`ID`
`allotmentrelease`.`FullAroNum`
`allotmentrelease`.`ARODate`
`allotmentrelease`.`CategoryID`
`allotmentrelease`.`Category`
`allotmentrelease`.`BYEAR`
`allotmentrelease`.`officeID`
`allotmentrelease`.`ppaCode`
`allotmentrelease`.`appropriationId`
`allotmentrelease`.`AccountID`
`allotmentrelease`.`AccountDescription`
`allotmentrelease`.`FundID`
`allotmentrelease`.`FundCode`
`allotmentrelease`.`FundName`
`allotmentrelease`.`BudgetSource`
`allotmentrelease`.`objectclass_AccountCode`
`allotmentrelease`.`objectclass_AccountCodeId`
`allotmentrelease`.`Appropriation`
`allotmentrelease`.`ReleasedAmt`
`allotmentrelease`.`purpose`
`allotmentrelease`.`UID`
`allotmentrelease`.`ts`
`allotmentrelease`.`LastEntry`
`allotmentrelease`.`Quarter_`
`allotmentrelease`.`Status`
`allotmentrelease`.`BatchGUID`
`allowances_jo`.*
`allowances_jo`.`allowance_id`
`allowances_jo`.`allowance_name`
`allowances_jo`.`allowance_status`
`allowances_jo`.`account_id`
`allowances_jo`.`allowance_type`
`appplan`.*
`appplan`.`ID`
`appplan`.`ItemClass`
`appplan`.`BudTypeID`
`appplan`.`BudType`
`appplan`.`SOFID`
`appplan`.`SOFDescription`
`appplan`.`ACID`
`appplan`.`Account`
`appplan`.`PPMPID`
`appplan`.`GUID`
`appplan`.`DateSubmitted`
`appplan`.`DepartmentID`
`appplan`.`DepartmentName`
`appplan`.`BYear`
`appplan`.`AppropriatedAmt`
`appplan`.`Contigency`
`appplan`.`NetAmt`
`appplan`.`ControlNum`
`appplan`.`UID`
`appplan`.`TS`
`appplan`.`ItemID`
`appplan`.`Description`
`appplan`.`Qty`
`appplan`.`UoM`
`appplan`.`UnitPrice`
`appplan`.`TotalCost`
`appplan`.`FQty`
`appplan`.`FAmount`
`appplan`.`SQty`
`appplan`.`SAmount`
`appplan`.`TQty`
`appplan`.`TAmount`
`appplan`.`FRQty`
`appplan`.`FRAmount`
`appsignatories`.*
`appsignatories`.`ID`
`appsignatories`.`DepartmentID`
`appsignatories`.`SigType`
`appsignatories`.`Signame`
`appsignatories`.`Position`
`appsignatories`.`UID`
`apv_number`.*
`apv_number`.`ID`
`apv_number`.`JID`
`apv_number`.`APVNUM`
`apv_number`.`LOC`
`apv_number`.`TITLE`
`apv_number`.`YYYY`
`apv_number`.`PO`
`apv_number`.`INV`
`apv_number`.`GRPS`
`atc_setup`.*
`atc_setup`.`ID`
`atc_setup`.`DESCRIPTION`
`atc_setup`.`Goodservice`
`atc_setup`.`ATC`
`atc_setup`.`RATE`
`atc_setup`.`ACID`
`atc_setup`.`CID`
`atc_tax_rate`.*
`atc_tax_rate`.`ID`
`atc_tax_rate`.`ATC`
`atc_tax_rate`.`Rate`
`bank_recon_records`.*
`bank_recon_records`.`ID`
`bank_recon_records`.`GRP`
`bank_recon_records`.`ACCOUNTID`
`bank_recon_records`.`SAVE_DATE`
`bank_recon_records`.`ReportedBankBalance`
`bank_recon_records`.`AmountBeforeRecon`
`bank_recon_records`.`asofdate`
`bank_recon_records`.`GUID`
`bank_recon_records`.`ReconDates`
`beginning_temp`.*
`beginning_temp`.`ID`
`beginning_temp`.`ACID`
`beginning_temp`.`CODE`
`beginning_temp`.`DESCRIPTION`
`beginning_temp`.`JAN`
`beginning_temp`.`FEB`
`beginning_temp`.`MAR`
`beginning_temp`.`APR`
`beginning_temp`.`MAY`
`beginning_temp`.`JUN`
`beginning_temp`.`JUL`
`beginning_temp`.`AUG`
`beginning_temp`.`SEP`
`beginning_temp`.`OCT`
`beginning_temp`.`NOV`
`beginning_temp`.`DEC`
`beginning_temp`.`YR`
`beginning_temp`.`GID`
`beginning_temp`.`GID1`
`beginning_temp`.`ACCOUNTSPACE`
`beginning_temp`.`MAINID`
`beginning_temp`.`OFFICE`
`beginning_temp`.`COST_CENTER`
`beginning_temp`.`DRCR`
`beginning_temp`.`SUBTYPE`
`beginning_temp`.`ISBANK`
`bill_series`.*
`bill_series`.`ID`
`bill_series`.`Year`
`bill_series`.`series`
`bill_series`.`titleid`
`bill_series`.`JID`
`bill_series`.`ref`
`bill_series`.`SUBID`
`bill_series`.`tstamp`
`billing_monitoring`.*
`billing_monitoring`.`bill_id`
`billing_monitoring`.`bill_projectNo`
`billing_monitoring`.`bill_projectname`
`billing_monitoring`.`bill_requesteddate`
`billing_monitoring`.`bill_requestpercentage`
`billing_monitoring`.`bill_requestdetails`
`billing_monitoring`.`bill_requestamount`
`billing_monitoring`.`bill_requestremarks`
`billing_monitoring`.`bill_date`
`billing_monitoring`.`bill_percentage`
`billing_monitoring`.`bill_details`
`billing_monitoring`.`bill_amount`
`billing_monitoring`.`bill_recoupment`
`billing_monitoring`.`bill_vat2`
`billing_monitoring`.`bill_vat5`
`billing_monitoring`.`bill_others`
`billing_monitoring`.`bill_incometax1`
`billing_monitoring`.`bill_royalty`
`billing_monitoring`.`bill_birdue`
`billing_monitoring`.`bill_bonds`
`billing_monitoring`.`bill_otherssubcon`
`billing_monitoring`.`bill_amountNet`
`billing_monitoring`.`bill_remarks`
`billing_monitoring`.`saved_date`
`billing_monitoring`.`bill_actualAccomplished`
`billing_monitoring`.`bill_subcon`
`billing_monitoring`.`PROJECT_ID`
`billing_monitoring`.`RETENTION`
`billing_monitoring`.`JID`
`billing_others`.*
`billing_others`.`ID`
`billing_others`.`JID`
`billing_others`.`DTL_ID`
`billing_others`.`ACCOUNT_ID`
`billing_others`.`AMOUNT`
`billing_others`.`ORNUM`
`billing_others`.`ORDATE`
`billing_others`.`BLID`
`billing_others`.`ACCOUNT_DESC`
`billing_others`.`CONTAINER`
`billing_others`.`CID`
`billingrecord`.*
`billingrecord`.`ID`
`billingrecord`.`equipmentID`
`billingrecord`.`BILL_NO`
`billingrecord`.`CUSTOMER`
`billingrecord`.`LOCATION`
`billingrecord`.`TITLEID`
`billingrecord`.`FL`
`billingrecord`.`CTYPE`
`billingrecord`.`trans_date`
`billingrecord`.`reference`
`billingrecord`.`start_time`
`billingrecord`.`end_time`
`billingrecord`.`unit`
`billingrecord`.`rate`
`billingrecord`.`location_frm`
`billingrecord`.`location_to`
`billingrecord`.`REMARKS`
`billingrecord`.`TRIPS_NUM`
`billingrecord`.`KM`
`billingrecord`.`TS`
`billingrecord`.`JID`
`billingrecord`.`GUID`
`billingrecord`.`UID`
`billingrecord`.`dispatchid`
`billingrecord`.`refnum`
`billingrecord`.`operators`
`billingrecord`.`DTLS`
`billingrecord`.`EQUIPMENT`
`billingrecord`.`DEPARTMENT`
`billingrecord`.`DEPID`
`billingrecord`.`entry_date`
`billingrecord`.`ITEMDESCRIPTION`
`bislig_petty_liquidate`.*
`bislig_petty_liquidate`.`ID`
`bislig_petty_liquidate`.`ReleasedID`
`bislig_petty_liquidate`.`EMPID`
`bislig_petty_liquidate`.`TS`
`bislig_petty_liquidate`.`STATUS`
`bislig_petty_liquidate`.`LIQ_JID`
`bislig_petty_liquidate`.`GRP`
`bislig_system`.*
`bislig_system`.`id`
`bislig_system`.`company_name`
`bislig_system`.`address`
`bislig_system`.`logo_name`
`bislig_system`.`photo`
`bisligpetty`.*
`bisligpetty`.`ID`
`bisligpetty`.`EMPID`
`bisligpetty`.`TDATE`
`bisligpetty`.`REF`
`bisligpetty`.`AMT`
`bisligpetty`.`RELEASEDBY`
`bisligpetty`.`STATUS`
`bisligpetty`.`TS`
`bisligpetty`.`LOCATION`
`bisligpetty`.`CANCEL_reason`
`bisligpetty`.`memo`
`bisligpetty`.`custodian`
`bisligpetty`.`supervisor`
`board_directors`.*
`board_directors`.`ID`
`board_directors`.`dates`
`board_directors`.`costcenter`
`board_directors`.`resolutionApproved`
`board_directors`.`policiesPass`
`board_directors`.`DirectorsFee`
`board_directors`.`Held`
`board_directors`.`regular`
`board_directors`.`special`
`board_directors`.`seminar`
`board_directors`.`ts`
`board_directors`.`uid`
`board_directors`.`STATUS`
`board_directors`.`GID`
`branch_setup`.*
`branch_setup`.`id`
`branch_setup`.`reference_no`
`branch_setup`.`branch_name`
`branch_setup`.`branch_address`
`branch_setup`.`application_date`
`branch_setup`.`status`
`breakdowngroup`.*
`breakdowngroup`.`ID`
`breakdowngroup`.`ParentID`
`breakdowngroup`.`Description`
`breakdowngroup`.`Status`
`budget_setup`.*
`budget_setup`.`id`
`budget_setup`.`class`
`budget_setup`.`subclass`
`budget_setup`.`account`
`budget_setup`.`year`
`budget_setup`.`jan`
`budget_setup`.`feb`
`budget_setup`.`mar`
`budget_setup`.`apr`
`budget_setup`.`may`
`budget_setup`.`jun`
`budget_setup`.`jul`
`budget_setup`.`aug`
`budget_setup`.`sep`
`budget_setup`.`oct`
`budget_setup`.`nov`
`budget_setup`.`dec`
`budget_setup`.`location`
`budget_setup`.`division`
`budget_setup`.`titleID`
`budget_setup`.`identification`
`budget_setup_dtl`.*
`budget_setup_dtl`.`dtl_id`
`budget_setup_dtl`.`budget_id`
`budget_setup_dtl`.`year`
`budget_setup_dtl`.`month`
`budget_setup_dtl`.`type`
`budget_setup_dtl`.`cash_flow`
`budget_setup_dtl`.`item_type`
`budget_setup_dtl`.`item_id`
`budget_setup_dtl`.`item_description`
`budget_setup_dtl`.`item_display_name`
`budget_setup_dtl`.`transaction_type`
`budget_setup_dtl`.`expense_type`
`budget_setup_dtl`.`cost_type`
`budget_setup_dtl`.`quantity`
`budget_setup_dtl`.`unit_measure`
`budget_setup_dtl`.`unit_cost`
`budget_setup_dtl`.`no_of_person`
`budget_setup_dtl`.`total_amount`
`budget_setup_dtl`.`purpose`
`budget_setup_dtl`.`status`
`budget_setup_dtl`.`save_date`
`budget_setup_dtl`.`title_id`
`budget_setup_dtl`.`location_id`
`budget_setup_dtl`.`division_id`
`budget_setup_dtl`.`account_id`
`budget_signatory`.*
`budget_signatory`.`Signatory_ID`
`budget_signatory`.`Signatory_Name`
`budget_signatory`.`Signatory_Position`
`budget_signatory`.`Signatory_Position_id`
`budget_signatory`.`Signatory_PP_ID`
`budget_signatory`.`department_id`
`budget_signatory`.`status`
`budgetappropriationstatus`.*
`budgetappropriationstatus`.`ID`
`budgetappropriationstatus`.`budgetType`
`budgetappropriationstatus`.`Yr`
`budgetappropriationstatus`.`OfficeId`
`budgetappropriationstatus`.`Status`
`budgetclosing`.*
`budgetclosing`.`Id`
`budgetclosing`.`ClosingDate`
`budgetclosing`.`ClosedByName`
`budgetdetail`.*
`budgetdetail`.`ID`
`budgetdetail`.`groupid`
`budgetdetail`.`GroupName`
`budgetdetail`.`TypeofBudget`
`budgetdetail`.`BYear`
`budgetdetail`.`DescriptionID`
`budgetdetail`.`Description`
`budgetdetail`.`AppropriationID`
`budgetdetail`.`ACID`
`budgetdetail`.`ACID_Description`
`budgetdetail`.`DepartmentID`
`budgetdetail`.`Jan`
`budgetdetail`.`Feb`
`budgetdetail`.`Mar`
`budgetdetail`.`Apr`
`budgetdetail`.`May`
`budgetdetail`.`Jun`
`budgetdetail`.`Jul`
`budgetdetail`.`Aug`
`budgetdetail`.`Sept`
`budgetdetail`.`Oct`
`budgetdetail`.`Nov`
`budgetdetail`.`Dec`
`budgetdetail_plantilla`.*
`budgetdetail_plantilla`.`ID`
`budgetdetail_plantilla`.`Group`
`budgetdetail_plantilla`.`DescriptionID`
`budgetdetail_plantilla`.`Description`
`budgetdetail_plantilla`.`Positions`
`budgetdetail_plantilla`.`BYear`
`budgetdetail_plantilla`.`ACID`
`budgetdetail_plantilla`.`TypeofBudget`
`budgetdetail_plantilla`.`Jan`
`budgetdetail_plantilla`.`Feb`
`budgetdetail_plantilla`.`Mar`
`budgetdetail_plantilla`.`Apr`
`budgetdetail_plantilla`.`May`
`budgetdetail_plantilla`.`Jun`
`budgetdetail_plantilla`.`Jul`
`budgetdetail_plantilla`.`Aug`
`budgetdetail_plantilla`.`Sept`
`budgetdetail_plantilla`.`Oct`
`budgetdetail_plantilla`.`Nov`
`budgetdetail_plantilla`.`Dec`
`budgetdetail_plantilla`.`Total`
`budgetdetail_plantilla`.`DepartmentID`
`budgetdetail_plantilla`.`SG`
`budgetdetail_plantilla`.`Step`
`budgetdetail_plantilla`.`UID`
`budgetdetail_plantilla`.`PositionID`
`budgetsourcedescription`.*
`budgetsourcedescription`.`ID`
`budgetsourcedescription`.`Description`
`cash_advances`.*
`cash_advances`.`SysPK_CshAdv`
`cash_advances`.`SysFK_Empl_CshAdv`
`cash_advances`.`UserCode_CshAdv`
`cash_advances`.`Name_CshAdv`
`cash_advances`.`DateTrans_CshAdv`
`cash_advances`.`Amount_CshAdv`
`cash_advances`.`Balance_CshAdv`
`cash_advances`.`Terms_CshAdv`
`cash_advances`.`AmortAmount_CshAdv`
`cash_advances`.`Remarks_CshAdv`
`cash_advances`.`Description_CshAdv`
`cash_advances`.`CompanyCode`
`cash_advances`.`ProjectCode`
`cash_advances`.`deductionType`
`cash_advances`.`EMP_ID`
`cashall`.*
`cashall`.`ID`
`cashall`.`JOURNAL_ID`
`cashall`.`DRCR`
`cashliquidation`.*
`cashliquidation`.`CLRFNumber`
`cashliquidation`.`CLEmpName`
`cashliquidation`.`CLProjCode`
`cashliquidation`.`CLProjName`
`cashliquidation`.`CLLocation`
`cashliquidation`.`CLDate`
`cashliquidation`.`CLAmount`
`cashliquidation`.`CLPeriodfrom`
`cashliquidation`.`CLPeriodto`
`cashliquidation`.`CLGrossAmount`
`cashliquidation`.`sss`
`cashliquidation`.`hdmf`
`cashliquidation`.`cassd`
`cashliquidation`.`metrobank`
`cashliquidation`.`bdo`
`cashvoucher_series`.*
`cashvoucher_series`.`id`
`cashvoucher_series`.`JID`
`cashvoucher_series`.`cv`
`cashvoucher_series`.`COMPANY`
`cashvoucher_series`.`YEAR`
`cashvoucher_series`.`TSTAMP`
`cashvoucher_series`.`groupentry`
`casl_liq`.*
`casl_liq`.`ID`
`casl_liq`.`REF_OLD`
`casl_liq`.`OLD_JID`
`casl_liq`.`REF_NEW`
`casl_liq`.`JID`
`casl_liq`.`DATE_LIQ`
`casl_liq`.`EMPID`
`casl_liq`.`MEMO`
`casl_liq`.`AMOUNT`
`casl_liq`.`UID`
`casl_liq`.`status`
`casl_liq`.`CV`
`casl_liq`.`tstamp`
`casl_liq`.`GROUP`
`casl_liq`.`CASL_GUID`
`casl_liq`.`RELASED_ID`
`casl_liq_br`.*
`casl_liq_br`.`ID`
`casl_liq_br`.`JID`
`casl_liq_br`.`CUSTID`
`casl_liq_br`.`ACCOUNTID`
`casl_liq_br`.`SHIPPING`
`casl_liq_br`.`AMOUNT`
`casl_liq_br`.`ORNUM`
`casl_liq_br`.`DATE_PAID`
`casl_liq_br`.`CONTAINER`
`casl_liq_br`.`PROCESSOR`
`casl_liq_br`.`TSTAMP`
`casl_liq_br`.`status`
`casl_liq_br`.`CASL_GUID`
`casl_liq_details`.*
`casl_liq_details`.`id`
`casl_liq_details`.`journal_details_id`
`casl_liq_details`.`TIN`
`casl_liq_details`.`REMARKS`
`casl_liq_details`.`INV_NUM`
`casl_liq_details`.`Suppliername`
`casl_liq_details`.`SUPID`
`casl_liq_details`.`JID`
`casl_liq_details`.`caslID`
`casl_refund_list`.*
`casl_refund_list`.`ID`
`casl_refund_list`.`JID`
`casl_refund_list`.`GROUPS`
`casl_released`.*
`casl_released`.`ID`
`casl_released`.`JID`
`casl_released`.`REF`
`casl_released`.`GUID`
`casl_released`.`DATES`
`casl_released`.`EMPID`
`casl_released`.`MEMOS`
`casl_released`.`AMOUNT`
`casl_released`.`UID`
`casl_released`.`status`
`casl_released`.`tstamp`
`casl_released`.`COMPANYCODE`
`casl_released`.`DEPTCODE`
`casl_released`.`CASH_ACID`
`casl_released`.`FUND_LOC`
`casl_released`.`LOCATION_`
`casl_released`.`PAYEE_ID`
`casl_released`.`NAME_TYPES`
`category`.*
`category`.`ID`
`category`.`ParentID`
`category`.`LBP`
`category`.`Name`
`category`.`Status`
`category`.`Ordering`
`category`.`ExpenseClass`
`cf_description`.*
`cf_description`.`ID`
`cf_description`.`CF_NAME`
`cf_description`.`STATUS`
`cf_description`.`ORDER`
`cf_description`.`TYPE`
`cf_description`.`FLOW`
`check_monitoring`.*
`check_monitoring`.`ID`
`check_monitoring`.`CDATE`
`check_monitoring`.`ARRIVAL`
`check_monitoring`.`PAYEEID`
`check_monitoring`.`CONSIGNEEID`
`check_monitoring`.`CHECK_NUM`
`check_monitoring`.`C_VOUCHER`
`check_monitoring`.`BL`
`check_monitoring`.`PURPOSE_OF_PAYMENT`
`check_monitoring`.`RECEIVEDBY`
`check_monitoring`.`AMOUNT`
`check_monitoring`.`CONTAINER`
`check_monitoring`.`MC_FEE`
`check_monitoring`.`BP`
`check_monitoring`.`STATUS`
`check_monitoring`.`title_id`
`check_monitoring`.`MC_CHECK`
`check_monitoring`.`LOGBY`
`check_monitoring`.`REMOVEDBY`
`check_received_released_stat`.*
`check_received_released_stat`.`ID`
`check_received_released_stat`.`JID`
`check_received_released_stat`.`status`
`check_received_released_stat`.`RELEASED_DATE`
`check_received_released_stat`.`UID`
`check_received_released_stat`.`RECEIVEDBY`
`check_received_released_stat`.`REMARKS`
`check_received_released_stat`.`REFERENCE`
`check_received_released_stat`.`TSTAMP`
`check_received_released_stat`.`CHK_TYPE`
`check_received_released_stat`.`groups`
`checkdefaultsignatories`.*
`checkdefaultsignatories`.`ID`
`checkdefaultsignatories`.`NAMES1`
`checkdefaultsignatories`.`POSITIONS1`
`checkdefaultsignatories`.`NAMES2`
`checkdefaultsignatories`.`POSITIONS2`
`checkingaccountlog`.*
`checkingaccountlog`.`ID`
`checkingaccountlog`.`JID`
`checkingaccountlog`.`ACID`
`checkingaccountlog`.`BANK_NAME`
`checkingaccountlog`.`CHECKNUMBER`
`checkingaccountlog`.`CHECKDATES`
`checkingaccountlog`.`PAYEE`
`checkingaccountlog`.`PAYEEID`
`checkingaccountlog`.`Groups`
`checkingaccountlog`.`USERSID`
`checkingaccountlog`.`CVNUMBER`
`classification_setup`.*
`classification_setup`.`id`
`classification_setup`.`code`
`classification_setup`.`short_description`
`classification_setup`.`full_description`
`classification_setup`.`group`
`classification_setup`.`cash_flow`
`classification_setup`.`type`
`classification_setup`.`status`
`classification_setup`.`OWNERID`
`classification_setup`.`classOrders`
`clearing_cust_advanc_pay`.*
`clearing_cust_advanc_pay`.`ID`
`clearing_cust_advanc_pay`.`CUSTID`
`clearing_cust_advanc_pay`.`CONTAINER`
`clearing_cust_advanc_pay`.`BL`
`clearing_cust_advanc_pay`.`ARRIVAL`
`clearing_cust_advanc_pay`.`AMOUNT`
`clearing_cust_advanc_pay`.`DATEFAX`
`clearing_cust_advanc_pay`.`CHECK_NUM`
`clearing_cust_advanc_pay`.`DATEPAID`
`clearing_cust_advanc_pay`.`TSTAMP`
`clearing_cust_advanc_pay`.`STATUS`
`clearing_cust_advanc_pay`.`CLEARED`
`clearing_cust_advanc_pay`.`REMARKS`
`clearing_cust_advanc_pay`.`JOURNAL_ID`
`clev_deductions`.*
`clev_deductions`.`ID`
`clev_deductions`.`DEDUCIONID`
`clev_deductions`.`ACID`
`clev_deductions`.`AMT`
`clev_deductions`.`JID`
`clev_deductions`.`GID`
`clev_deductions`.`TS`
`clev_deductions`.`JDTL`
`closing_appro`.*
`closing_appro`.`ID`
`closing_appro`.`dateLog`
`closing_appro`.`usercloseEntry`
`closing_appro`.`remarks`
`closing_appro`.`Location`
`closing_appro`.`titleID`
`closing_appro`.`EMPNAME`
`closing_appro`.`Journal_id`
`closing_appro`.`User_syspkID`
`closing_appro`.`Status`
`closing_appro`.`ReopenBy`
`closing_appro`.`datesaved`
`closing_entry`.*
`closing_entry`.`ID`
`closing_entry`.`dateLog`
`closing_entry`.`usercloseEntry`
`closing_entry`.`remarks`
`closing_entry`.`Location`
`closing_entry`.`titleID`
`closing_entry`.`EMPNAME`
`closing_entry`.`Journal_id`
`closing_entry`.`User_syspkID`
`closing_entry`.`Status`
`closing_entry`.`ReopenBy`
`closing_entry`.`datesaved`
`container_monitoring`.*
`container_monitoring`.`ID`
`container_monitoring`.`SHIPPINGID`
`container_monitoring`.`CUSTID`
`container_monitoring`.`CONTAINERNUM`
`container_monitoring`.`BL`
`container_monitoring`.`CONTAINER_DEPO`
`container_monitoring`.`DATE_REC`
`container_monitoring`.`REF_AMOUNT`
`container_monitoring`.`REF_CHECK_NO`
`container_monitoring`.`REF_DATE`
`container_monitoring`.`DET_AMOUNT`
`container_monitoring`.`DET_BILLING`
`container_monitoring`.`CTS_AMOUNT`
`container_monitoring`.`CTS_DATE_PAID`
`container_monitoring`.`CTS_OR`
`container_monitoring`.`ATS_AMOUNT`
`container_monitoring`.`ATS_DATE_PAID`
`container_monitoring`.`ATS_OR`
`container_monitoring`.`DOCD_AMOUNT`
`container_monitoring`.`DOCD_BILLING`
`container_monitoring`.`DOCD_OR`
`container_monitoring`.`CFC_AMOUNT`
`container_monitoring`.`CFC_SOA`
`container_monitoring`.`CFC_CHECK`
`container_monitoring`.`CFC_COLLECTED`
`container_monitoring`.`CFC_COLLECTED_DATE`
`container_monitoring`.`RBTR_AMOUNT`
`container_monitoring`.`RBTR_CHECK`
`container_monitoring`.`RBTR_COLLECTED`
`container_monitoring`.`RBTR_DATE`
`container_monitoring`.`REMARKS`
`container_monitoring`.`TS`
`container_monitoring`.`UID`
`continuingmigration`.*
`continuingmigration`.`Id`
`continuingmigration`.`OfficeCode`
`continuingmigration`.`Office`
`continuingmigration`.`OfficeId`
`continuingmigration`.`SOFID`
`continuingmigration`.`SOF`
`continuingmigration`.`BudgetType`
`continuingmigration`.`SubOfficeCode`
`continuingmigration`.`SubOffice`
`continuingmigration`.`ExpenseClassId`
`continuingmigration`.`ExpDescription`
`continuingmigration`.`ExpCode`
`continuingmigration`.`AccountCode`
`continuingmigration`.`Description`
`continuingmigration`.`Appropriation`
`continuingmigration`.`TotalAllotment`
`continuingmigration`.`AppropriationBalance`
`continuingmigration`.`Obligation`
`continuingmigration`.`UnobligatedBalance`
`continuings`.*
`continuings`.`Id`
`continuings`.`accountType`
`continuings`.`TypeDescription`
`continuings`.`ExpenseClassID`
`continuings`.`OfficeID`
`continuings`.`OfficeCode`
`continuings`.`AccountCode`
`continuings`.`Description`
`continuings`.`Amount`
`cto_budget_account_columns`.*
`cto_budget_account_columns`.`id`
`cto_budget_account_columns`.`accnt_id`
`cto_budget_account_columns`.`col_name`
`cto_budget_account_columns`.`def_val`
`cto_budget_account_columns`.`col_id`
`cto_budget_account_columns`.`col_num`
`cto_budget_account_columns`.`operation`
`cto_budget_account_columns`.`calc_col`
`cto_budget_account_columns`.`data_type`
`cto_budget_account_columns`.`status`
`cto_budget_account_columns_main`.*
`cto_budget_account_columns_main`.`id`
`cto_budget_account_columns_main`.`from_tbl`
`cto_budget_account_columns_main`.`dept_query`
`cto_budget_beg_entry`.*
`cto_budget_beg_entry`.`id`
`cto_budget_beg_entry`.`accnt_id`
`cto_budget_beg_entry`.`dept_id`
`cto_budget_beg_entry`.`year`
`cto_budget_beg_entry`.`app_last_year`
`cto_budget_beg_entry`.`expended_last_year`
`cto_budget_beg_entry`.`app_cur_year`
`cto_budget_beg_entry`.`expended_first_9_month`
`cto_budget_beg_entry`.`anticipated_expenditure`
`cto_budget_beg_entry`.`app_next_year`
`cto_budget_category_none_ppmp`.*
`cto_budget_category_none_ppmp`.`id`
`cto_budget_category_none_ppmp`.`desc`
`cto_budget_mode_pro`.*
`cto_budget_mode_pro`.`id`
`cto_budget_mode_pro`.`mode_pro_desc`
`cto_budget_mode_pro`.`status`
`cto_budget_mode_pro`.`xx`
`cto_budget_none_ppmp`.*
`cto_budget_none_ppmp`.`id`
`cto_budget_none_ppmp`.`budget_year`
`cto_budget_none_ppmp`.`dept_id`
`cto_budget_none_ppmp`.`account_id`
`cto_budget_none_ppmp`.`remarks`
`cto_budget_none_ppmp`.`source_fund`
`cto_budget_none_ppmp`.`status`
`cto_budget_none_ppmp`.`display_detail`
`cto_budget_none_ppmp`.`type`
`cto_budget_none_ppmp`.`date_created`
`cto_budget_none_ppmp`.`charge_dep_id`
`cto_budget_none_ppmp_dtls`.*
`cto_budget_none_ppmp_dtls`.`dtl_id`
`cto_budget_none_ppmp_dtls`.`ledger_type`
`cto_budget_none_ppmp_dtls`.`main_id`
`cto_budget_none_ppmp_dtls`.`trans_id`
`cto_budget_none_ppmp_dtls`.`emp_id`
`cto_budget_none_ppmp_dtls`.`deptid`
`cto_budget_none_ppmp_dtls`.`col1`
`cto_budget_none_ppmp_dtls`.`col2`
`cto_budget_none_ppmp_dtls`.`col3`
`cto_budget_none_ppmp_dtls`.`col4`
`cto_budget_none_ppmp_dtls`.`col5`
`cto_budget_none_ppmp_dtls`.`col6`
`cto_budget_none_ppmp_dtls`.`col7`
`cto_budget_none_ppmp_dtls`.`col8`
`cto_budget_none_ppmp_dtls`.`jan`
`cto_budget_none_ppmp_dtls`.`feb`
`cto_budget_none_ppmp_dtls`.`mar`
`cto_budget_none_ppmp_dtls`.`apr`
`cto_budget_none_ppmp_dtls`.`may`
`cto_budget_none_ppmp_dtls`.`jun`
`cto_budget_none_ppmp_dtls`.`jul`
`cto_budget_none_ppmp_dtls`.`aug`
`cto_budget_none_ppmp_dtls`.`sep`
`cto_budget_none_ppmp_dtls`.`oct`
`cto_budget_none_ppmp_dtls`.`nov`
`cto_budget_none_ppmp_dtls`.`dec`
`cto_budget_none_ppmp_dtls`.`type`
`cto_budget_none_ppmp_dtls`.`util`
`cto_budget_none_ppmp_dtls`.`revision`
`cto_budget_none_ppmp_dtls`.`savedate`
`cto_budget_none_ppmp_dtls`.`status`
`cto_budget_none_ppmp_dtls_temp`.*
`cto_budget_none_ppmp_dtls_temp`.`dtl_id`
`cto_budget_none_ppmp_dtls_temp`.`ledger_type`
`cto_budget_none_ppmp_dtls_temp`.`main_id`
`cto_budget_none_ppmp_dtls_temp`.`trans_id`
`cto_budget_none_ppmp_dtls_temp`.`deptid`
`cto_budget_none_ppmp_dtls_temp`.`emp_id`
`cto_budget_none_ppmp_dtls_temp`.`col1`
`cto_budget_none_ppmp_dtls_temp`.`col2`
`cto_budget_none_ppmp_dtls_temp`.`col3`
`cto_budget_none_ppmp_dtls_temp`.`col4`
`cto_budget_none_ppmp_dtls_temp`.`col5`
`cto_budget_none_ppmp_dtls_temp`.`col6`
`cto_budget_none_ppmp_dtls_temp`.`col7`
`cto_budget_none_ppmp_dtls_temp`.`col8`
`cto_budget_none_ppmp_dtls_temp`.`jan`
`cto_budget_none_ppmp_dtls_temp`.`feb`
`cto_budget_none_ppmp_dtls_temp`.`mar`
`cto_budget_none_ppmp_dtls_temp`.`apr`
`cto_budget_none_ppmp_dtls_temp`.`may`
`cto_budget_none_ppmp_dtls_temp`.`jun`
`cto_budget_none_ppmp_dtls_temp`.`jul`
`cto_budget_none_ppmp_dtls_temp`.`aug`
`cto_budget_none_ppmp_dtls_temp`.`sep`
`cto_budget_none_ppmp_dtls_temp`.`oct`
`cto_budget_none_ppmp_dtls_temp`.`nov`
`cto_budget_none_ppmp_dtls_temp`.`dec`
`cto_budget_none_ppmp_dtls_temp`.`type`
`cto_budget_none_ppmp_dtls_temp`.`revision`
`cto_budget_none_ppmp_dtls_temp`.`util`
`cto_budget_none_ppmp_dtls_temp`.`savedate`
`cto_budget_none_ppmp_dtls_temp`.`status`
`cto_budget_none_ppmp_dtls_temp`.`chk`
`cto_budget_ppmp`.*
`cto_budget_ppmp`.`id`
`cto_budget_ppmp`.`budget_year`
`cto_budget_ppmp`.`dept_id`
`cto_budget_ppmp`.`account_id`
`cto_budget_ppmp`.`remarks`
`cto_budget_ppmp`.`mode_pro`
`cto_budget_ppmp`.`source_fund`
`cto_budget_ppmp`.`Pre_Proc_Conference`
`cto_budget_ppmp`.`Ads_Post_of_IAEB`
`cto_budget_ppmp`.`Pre_bid_Con`
`cto_budget_ppmp`.`Eligibility_Check`
`cto_budget_ppmp`.`Sub_Open_of_Bids`
`cto_budget_ppmp`.`Bid_Evaluation`
`cto_budget_ppmp`.`Post_Qual`
`cto_budget_ppmp`.`Notice_of_Award`
`cto_budget_ppmp`.`Contract_Signing`
`cto_budget_ppmp`.`Notice_to_Proceed`
`cto_budget_ppmp`.`Delivery_Completion`
`cto_budget_ppmp`.`Acceptance_Turnover`
`cto_budget_ppmp`.`status`
`cto_budget_ppmp`.`display_detail`
`cto_budget_ppmp`.`type`
`cto_budget_ppmp`.`date_created`
`cto_budget_ppmp_dtls`.*
`cto_budget_ppmp_dtls`.`dtl_id`
`cto_budget_ppmp_dtls`.`main_id`
`cto_budget_ppmp_dtls`.`item_id`
`cto_budget_ppmp_dtls`.`qty`
`cto_budget_ppmp_dtls`.`unit`
`cto_budget_ppmp_dtls`.`cost`
`cto_budget_ppmp_dtls`.`amont`
`cto_budget_ppmp_dtls`.`remarks`
`cto_budget_ppmp_dtls`.`status`
`cto_budget_ppmp_dtls`.`type`
`cto_budget_ppmp_dtls`.`revision`
`cto_budget_ppmp_dtls`.`01_qty`
`cto_budget_ppmp_dtls`.`01_cost`
`cto_budget_ppmp_dtls`.`01_amt`
`cto_budget_ppmp_dtls`.`02_qty`
`cto_budget_ppmp_dtls`.`02_cost`
`cto_budget_ppmp_dtls`.`02_amt`
`cto_budget_ppmp_dtls`.`03_qty`
`cto_budget_ppmp_dtls`.`03_cost`
`cto_budget_ppmp_dtls`.`03_amt`
`cto_budget_ppmp_dtls`.`04_qty`
`cto_budget_ppmp_dtls`.`04_cost`
`cto_budget_ppmp_dtls`.`04_amt`
`cto_budget_ppmp_dtls`.`05_qty`
`cto_budget_ppmp_dtls`.`05_cost`
`cto_budget_ppmp_dtls`.`05_amt`
`cto_budget_ppmp_dtls`.`06_qty`
`cto_budget_ppmp_dtls`.`06_cost`
`cto_budget_ppmp_dtls`.`06_amt`
`cto_budget_ppmp_dtls`.`07_qty`
`cto_budget_ppmp_dtls`.`07_cost`
`cto_budget_ppmp_dtls`.`07_amt`
`cto_budget_ppmp_dtls`.`08_qty`
`cto_budget_ppmp_dtls`.`08_cost`
`cto_budget_ppmp_dtls`.`08_amt`
`cto_budget_ppmp_dtls`.`09_qty`
`cto_budget_ppmp_dtls`.`09_cost`
`cto_budget_ppmp_dtls`.`09_amt`
`cto_budget_ppmp_dtls`.`10_qty`
`cto_budget_ppmp_dtls`.`10_cost`
`cto_budget_ppmp_dtls`.`10_amt`
`cto_budget_ppmp_dtls`.`11_qty`
`cto_budget_ppmp_dtls`.`11_cost`
`cto_budget_ppmp_dtls`.`11_amt`
`cto_budget_ppmp_dtls`.`12_qty`
`cto_budget_ppmp_dtls`.`12_cost`
`cto_budget_ppmp_dtls`.`12_amt`
`cto_budget_ppmp_dtls`.`savedate`
`cto_budget_ppmp_dtls`.`ISGROUP`
`cto_budget_ppmp_dtls_temp`.*
`cto_budget_ppmp_dtls_temp`.`id`
`cto_budget_ppmp_dtls_temp`.`main_id`
`cto_budget_ppmp_dtls_temp`.`item_id`
`cto_budget_ppmp_dtls_temp`.`qty`
`cto_budget_ppmp_dtls_temp`.`unit`
`cto_budget_ppmp_dtls_temp`.`cost`
`cto_budget_ppmp_dtls_temp`.`amont`
`cto_budget_ppmp_dtls_temp`.`remarks`
`cto_budget_ppmp_dtls_temp`.`status`
`cto_budget_ppmp_dtls_temp`.`type`
`cto_budget_ppmp_dtls_temp`.`revision`
`cto_budget_ppmp_dtls_temp`.`01_qty`
`cto_budget_ppmp_dtls_temp`.`01_cost`
`cto_budget_ppmp_dtls_temp`.`01_amt`
`cto_budget_ppmp_dtls_temp`.`02_qty`
`cto_budget_ppmp_dtls_temp`.`02_cost`
`cto_budget_ppmp_dtls_temp`.`02_amt`
`cto_budget_ppmp_dtls_temp`.`03_qty`
`cto_budget_ppmp_dtls_temp`.`03_cost`
`cto_budget_ppmp_dtls_temp`.`03_amt`
`cto_budget_ppmp_dtls_temp`.`04_qty`
`cto_budget_ppmp_dtls_temp`.`04_cost`
`cto_budget_ppmp_dtls_temp`.`04_amt`
`cto_budget_ppmp_dtls_temp`.`05_qty`
`cto_budget_ppmp_dtls_temp`.`05_cost`
`cto_budget_ppmp_dtls_temp`.`05_amt`
`cto_budget_ppmp_dtls_temp`.`06_qty`
`cto_budget_ppmp_dtls_temp`.`06_cost`
`cto_budget_ppmp_dtls_temp`.`06_amt`
`cto_budget_ppmp_dtls_temp`.`07_qty`
`cto_budget_ppmp_dtls_temp`.`07_cost`
`cto_budget_ppmp_dtls_temp`.`07_amt`
`cto_budget_ppmp_dtls_temp`.`08_qty`
`cto_budget_ppmp_dtls_temp`.`08_cost`
`cto_budget_ppmp_dtls_temp`.`08_amt`
`cto_budget_ppmp_dtls_temp`.`09_qty`
`cto_budget_ppmp_dtls_temp`.`09_cost`
`cto_budget_ppmp_dtls_temp`.`09_amt`
`cto_budget_ppmp_dtls_temp`.`10_qty`
`cto_budget_ppmp_dtls_temp`.`10_cost`
`cto_budget_ppmp_dtls_temp`.`10_amt`
`cto_budget_ppmp_dtls_temp`.`11_qty`
`cto_budget_ppmp_dtls_temp`.`11_cost`
`cto_budget_ppmp_dtls_temp`.`11_amt`
`cto_budget_ppmp_dtls_temp`.`12_qty`
`cto_budget_ppmp_dtls_temp`.`12_cost`
`cto_budget_ppmp_dtls_temp`.`12_amt`
`cto_budget_ppmp_dtls_temp`.`savedate`
`cto_budget_ppmp_dtls_temp`.`chk`
`cto_budget_res_series`.*
`cto_budget_res_series`.`id`
`cto_budget_res_series`.`resolution_num`
`cto_budget_res_series`.`series_num`
`cto_budget_source_fund`.*
`cto_budget_source_fund`.`id`
`cto_budget_source_fund`.`source_fund_desc`
`cto_budget_source_fund`.`status`
`cto_budget_source_fund`.`MainID`
`cto_budget_type`.*
`cto_budget_type`.`id`
`cto_budget_type`.`description`
`cto_budgett_revision_setup`.*
`cto_budgett_revision_setup`.`id`
`cto_budgett_revision_setup`.`desc`
`cto_fund_setup`.*
`cto_fund_setup`.`SysPK_fund_setup`
`cto_fund_setup`.`fund_code`
`cto_fund_setup`.`fund_description`
`cto_fund_setup`.`status`
`cto_transaction_partial_deposit`.*
`cto_transaction_partial_deposit`.`id`
`cto_transaction_partial_deposit`.`ref_no`
`cto_transaction_partial_deposit`.`accntable_prson`
`cto_transaction_partial_deposit`.`receive_by`
`cto_transaction_partial_deposit`.`date`
`cto_transaction_partial_deposit`.`tmestamp`
`cto_transaction_partial_deposit`.`status`
`cto_transaction_partial_deposit_dtl`.*
`cto_transaction_partial_deposit_dtl`.`id`
`cto_transaction_partial_deposit_dtl`.`main_id`
`cto_transaction_partial_deposit_dtl`.`type`
`cto_transaction_partial_deposit_dtl`.`amount`
`cto_transaction_partial_deposit_dtl`.`pieces`
`cto_transaction_partial_deposit_dtl`.`total`
`cust_adv_refund_log`.*
`cust_adv_refund_log`.`ID`
`cust_adv_refund_log`.`DATE`
`cust_adv_refund_log`.`FROM`
`cust_adv_refund_log`.`TO`
`cust_adv_refund_log`.`SUBJECT`
`cust_adv_refund_log`.`MONTH`
`cust_adv_refund_log`.`BILL`
`cust_adv_refund_log`.`CONTAINER`
`cust_adv_refund_log`.`REMARKS`
`cust_adv_refund_log`.`TOTAL_LIQ`
`cust_adv_refund_log`.`ADV`
`cust_adv_refund_log`.`TSTAMP`
`cust_adv_refund_log`.`refund_id`
`customer_setup`.*
`customer_setup`.`SysPKID`
`customer_setup`.`pp_person_code`
`customer_setup`.`application_date`
`customer_setup`.`pp_student_no`
`customer_setup`.`pp_prefix`
`customer_setup`.`pp_lastname`
`customer_setup`.`pp_firstname`
`customer_setup`.`pp_middlename`
`customer_setup`.`pp_suffix`
`customer_setup`.`gender`
`customer_setup`.`dob`
`customer_setup`.`civil_stat`
`customer_setup`.`cellno`
`customer_setup`.`phoneno`
`customer_setup`.`nationality`
`customer_setup`.`religion`
`customer_setup`.`spouseOccupation`
`customer_setup`.`spouse`
`customer_setup`.`mother_name`
`customer_setup`.`mother_cellno`
`customer_setup`.`father_name`
`customer_setup`.`father_cellno`
`customer_setup`.`email_add`
`customer_setup`.`address`
`customer_setup`.`purok_id`
`customer_setup`.`barangay_id`
`customer_setup`.`municipal_id`
`customer_setup`.`province_id`
`customer_setup`.`save_by`
`customer_setup`.`update_by`
`customer_setup`.`cancelled_by`
`customer_setup`.`status`
`customer_setup`.`ts`
`customeradvancedeductionlogs`.*
`customeradvancedeductionlogs`.`ID`
`customeradvancedeductionlogs`.`CID`
`customeradvancedeductionlogs`.`JID`
`customeradvancedeductionlogs`.`Amount`
`customeradvancedeductionlogs`.`Reference_no`
`customeradvancedeductionlogs`.`USERID`
`customeradvances`.*
`customeradvances`.`ID`
`customeradvances`.`CID`
`customeradvances`.`custName`
`customeradvances`.`Amount`
`customeradvances`.`dates`
`customeradvances`.`Businesstype`
`customeradvances`.`Location`
`customeradvances`.`TitleID`
`customeradvanceslog`.*
`customeradvanceslog`.`ID`
`customeradvanceslog`.`CID`
`customeradvanceslog`.`BP`
`customeradvanceslog`.`Amount`
`customeradvanceslog`.`UID`
`customeradvanceslog`.`Remarks`
`customersl_log`.*
`customersl_log`.`ID`
`customersl_log`.`JID`
`customersl_log`.`CID`
`customersl_log`.`REF`
`customersl_log`.`Amount`
`cwip_logs`.*
`cwip_logs`.`ID`
`cwip_logs`.`WIP_NAME`
`cwip_logs`.`WIP_STAT`
`cwip_logs`.`START`
`cwip_logs`.`END`
`cwip_logs`.`ADDRESS`
`cwip_logs`.`REMARKS`
`cwip_logs`.`ts`
`cwip_logs`.`Types`
`cwip_logs`.`OFFICEID`
`cwip_logs`.`contractorid`
`cwip_logs`.`agencyid`
`cwip_logs`.`contract_amount`
`cwip_logs`.`ACIDS`
`debits_actual_deducted`.*
`debits_actual_deducted`.`ID`
`debits_actual_deducted`.`JID`
`debits_actual_deducted`.`AMOUNT`
`debits_actual_deducted`.`STATUS`
`debits_actual_deducted`.`TS`
`debits_actual_deducted`.`GUID`
`defaultbank`.*
`defaultbank`.`ID`
`defaultbank`.`ACID_`
`defaultbank`.`TITLEID`
`defaultbank`.`location`
`defaults_accounts`.*
`defaults_accounts`.`ID`
`defaults_accounts`.`CIB`
`defaults_accounts`.`CASL`
`defaults_accounts`.`CASSD`
`defaults_accounts`.`RECEIVABLE`
`defaults_accounts`.`PAYABLE`
`defaults_accounts`.`PETTY`
`defaults_accounts`.`ADVANCES_FRM_AFF`
`defaults_accounts`.`ADVANCES_TO_AFF`
`defaults_accounts`.`ADVANCES_FRM_CUST`
`defaults_accounts`.`COMPANYID`
`defaults_accounts`.`ADV_TO_SUP`
`defaults_accounts`.`PETTY_CASH_CUSTODIAN`
`defaults_accounts`.`DUE_TO_EMP`
`defaults_accounts`.`OFFICE`
`defaults_accounts`.`DUID`
`defaults_accounts`.`UNDEPOFUND`
`defaults_accounts`.`SRV_INC`
`defaults_accounts`.`RETAINEDEARNINGS`
`defaults_accounts`.`BIRID`
`defaults_accounts`.`INPUTTAX`
`depreciationaccounts`.*
`depreciationaccounts`.`ID`
`depreciationaccounts`.`account_id`
`depreciationaccounts`.`PPEID`
`depreciationaccounts`.`Loc`
`depreciationaccounts`.`TItleID`
`depreciationaccounts`.`accounts`
`depreciationaccounts`.`accumid`
`discount_type`.*
`discount_type`.`id`
`discount_type`.`discount_name`
`discount_type`.`valuex`
`discount_type`.`typex`
`division_setup`.*
`division_setup`.`division_id`
`division_setup`.`division_code`
`division_setup`.`division_name`
`division_setup`.`title_id`
`division_setup`.`division_code1`
`division_setup`.`project_id`
`division_setup`.`status`
`division_setup`.`savedate`
`division_setup`.`userid`
`drivers_profile`.*
`drivers_profile`.`id`
`drivers_profile`.`driver_fullname`
`drivers_profile`.`address`
`drivers_profile`.`contact_no`
`drivers_profile`.`age`
`drivers_profile`.`civil_stat`
`drivers_profile`.`license_no`
`drivers_profile`.`height`
`drivers_profile`.`weight`
`drivers_profile`.`status`
`dummy_table`.*
`dummy_table`.`id`
`dummy_table`.`hour`
`epense_type`.*
`epense_type`.`id`
`epense_type`.`desc`
`epense_type`.`stat`
`expense_item_dtls`.*
`expense_item_dtls`.`id`
`expense_item_dtls`.`exp_id`
`expense_item_dtls`.`itm_id`
`expense_item_dtls`.`qty`
`expense_item_dtls`.`price`
`expense_item_dtls`.`selling_price`
`expense_main`.*
`expense_main`.`id`
`expense_main`.`ref_no`
`expense_main`.`trans_date`
`expense_main`.`trans_no`
`expense_main`.`type`
`expense_main`.`ref_id`
`expense_main`.`total_amount`
`expense_main`.`ts`
`expense_main`.`status`
`expense_main`.`branch_id`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`hide_amount`.*
`hide_amount`.`id`
`incomesource`.*
`incomesource`.`ID`
`incomesource`.`DescriptionID1`
`incomesource`.`Description1`
`incomesource`.`Description2`
`incomesource`.`IncomeType`
`incomesource`.`FundId`
`incomesource`.`Status`
`incomesource`.`Amount`
`incomesource`.`date_source`
`installment_provider_setup`.*
`installment_provider_setup`.`SysPKID`
`installment_provider_setup`.`application_date`
`installment_provider_setup`.`pp_no`
`installment_provider_setup`.`name`
`installment_provider_setup`.`cellno`
`installment_provider_setup`.`phoneno`
`installment_provider_setup`.`email_add`
`installment_provider_setup`.`address`
`installment_provider_setup`.`save_by`
`installment_provider_setup`.`update_by`
`installment_provider_setup`.`cancelled_by`
`installment_provider_setup`.`status`
`installment_provider_setup`.`ts`
`inventory_master`.*
`inventory_master`.`id`
`inventory_master`.`transID`
`inventory_master`.`transDtlID`
`inventory_master`.`transName`
`inventory_master`.`transNum`
`inventory_master`.`itemid`
`inventory_master`.`io`
`inventory_master`.`qty`
`inventory_master`.`unitcost`
`inventory_master`.`imeiNo`
`inventory_master`.`branchid`
`inventory_master`.`status`
`inventory_master`.`guid`
`inventory_master`.`ts`
`inventory_transfer`.*
`inventory_transfer`.`ID`
`inventory_transfer`.`trans_no`
`inventory_transfer`.`trans_date`
`inventory_transfer`.`ref_no`
`inventory_transfer`.`from_Id`
`inventory_transfer`.`to_Id`
`inventory_transfer`.`status`
`inventory_transfer`.`created`
`inventory_transfer`.`created_by`
`lbp2_programappropriation`.*
`lbp2_programappropriation`.`ID`
`lbp2_programappropriation`.`FUNDID`
`lbp2_programappropriation`.`FundName`
`lbp2_programappropriation`.`LBPType`
`lbp2_programappropriation`.`CategoryId`
`lbp2_programappropriation`.`Category`
`lbp2_programappropriation`.`CategoryOrder`
`lbp2_programappropriation`.`SubCategoryID`
`lbp2_programappropriation`.`SubCategory`
`lbp2_programappropriation`.`SubCategoryOrder`
`lbp2_programappropriation`.`UnderSubID`
`lbp2_programappropriation`.`UnderSubName`
`lbp2_programappropriation`.`UnderSubOrder`
`lbp2_programappropriation`.`OfficeID`
`lbp2_programappropriation`.`OfficeName`
`lbp2_programappropriation`.`AccountId`
`lbp2_programappropriation`.`Account_Code`
`lbp2_programappropriation`.`AccountName`
`lbp2_programappropriation`.`UID`
`lbp2_programappropriation`.`ts`
`lbp2_programappropriation`.`Ordering`
`lbp2_programappropriation`.`byear`
`lbp2_programappropriation`.`expenseClass`
`lbp2_programappropriation`.`Description`
`lbp2_programappropriation`.`aCode`
`lbp2_programappropriation`.`Appropriation`
`lbp2_programappropriationx`.*
`lbp2_programappropriationx`.`ID`
`lbp2_programappropriationx`.`FUNDID`
`lbp2_programappropriationx`.`FundName`
`lbp2_programappropriationx`.`LBPType`
`lbp2_programappropriationx`.`CategoryId`
`lbp2_programappropriationx`.`Category`
`lbp2_programappropriationx`.`CategoryOrder`
`lbp2_programappropriationx`.`SubCategoryID`
`lbp2_programappropriationx`.`SubCategory`
`lbp2_programappropriationx`.`SubCategoryOrder`
`lbp2_programappropriationx`.`UnderSubID`
`lbp2_programappropriationx`.`UnderSubName`
`lbp2_programappropriationx`.`UnderSubOrder`
`lbp2_programappropriationx`.`OfficeID`
`lbp2_programappropriationx`.`OfficeName`
`lbp2_programappropriationx`.`AccountId`
`lbp2_programappropriationx`.`Account_Code`
`lbp2_programappropriationx`.`AccountName`
`lbp2_programappropriationx`.`UID`
`lbp2_programappropriationx`.`ts`
`lbp2_programappropriationx`.`Ordering`
`lbp2_programappropriationx`.`byear`
`lbp2_programappropriationx`.`expenseClass`
`lbp2_programappropriationx`.`Description`
`lbp2_programappropriationx`.`aCode`
`lbp2_programappropriationx`.`Appropriation`
`main_fund_account`.*
`main_fund_account`.`Id`
`main_fund_account`.`Description`
`main_fund_account_yearly`.*
`main_fund_account_yearly`.`Id`
`main_fund_account_yearly`.`MainId`
`main_fund_account_yearly`.`Description`
`main_fund_account_yearly`.`Year`
`main_fund_account_yearly`.`Budget`
`main_fund_account_yearly`.`Status`
`mapper`.*
`mapper`.`ID`
`mapper`.`agefrom`
`mapper`.`ageto`
`mapper`.`scorefrom`
`mapper`.`scoreto`
`migrationdata`.*
`migrationdata`.`Id`
`migrationdata`.`RECODE`
`migrationdata`.`TypeDescription`
`migrationdata`.`ExpenseClassID`
`migrationdata`.`OfficeID`
`migrationdata`.`OfficeCode`
`migrationdata`.`Office`
`migrationdata`.`Codes`
`migrationdata`.`Description`
`migrationdata`.`Appropriation`
`migrationdata`.`TotalAllotment`
`migrationdata`.`Obligation`
`migrationdata`.`isContinuing`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`obr`.*
`obr`.`ID`
`obr`.`OBRDate`
`obr`.`OBRNum`
`obr`.`Mnth`
`obr`.`Byear`
`obr`.`Payee`
`obr`.`Remarks`
`obr`.`DepartmentName`
`obr`.`DepartmentID`
`obr`.`Address`
`obr`.`A_ChargesToAppropriation`
`obr`.`A_SupportingDocument`
`obr`.`B_ExistenceofAvailableAppropriation`
`obr`.`A_CertifiedNameID`
`obr`.`A_CertifiedName`
`obr`.`A_Position`
`obr`.`A_Date`
`obr`.`B_CertifiedNameID`
`obr`.`B_CertifiedName`
`obr`.`B_Position`
`obr`.`B_Date`
`obr`.`Amount`
`obr`.`SourceofFund`
`obr`.`UID`
`obr`.`FundId`
`obr`.`poid`
`obr`.`ponum`
`obr`.`ProjectId`
`obr`.`ProjectRegId`
`obr`.`PowId`
`obr`.`ProjectName`
`obr`.`PowNo`
`obr`.`reference`
`obr`.`CancelledReason`
`obr`.`CancelledByID`
`obr`.`Status`
`obr`.`TS`
`obr`.`IsContinuing`
`obr`.`isPosted`
`obr_pr_approval`.*
`obr_pr_approval`.`ID`
`obr_pr_approval`.`Fund`
`obr_pr_approval`.`Appropriation`
`obr_pr_approval`.`AccountNum`
`obr_pr_approval`.`Allotment`
`obr_pr_approval`.`BalancePrevious`
`obr_pr_approval`.`MinusDisbursement`
`obr_pr_approval`.`BalancePresent`
`obr_pr_approval`.`VerifiedByID`
`obr_pr_approval`.`VerifiedByName`
`obr_pr_approval`.`Dates`
`obr_pr_approval`.`ActionTaken`
`obr_pr_approval`.`Signatory`
`obr_pr_approval`.`SignatoryID`
`obr_pr_approval`.`Positions`
`obr_pr_approval`.`TS`
`obr_pr_approval`.`PRID`
`obr_pr_approval`.`Status`
`obrdetail`.*
`obrdetail`.`ID`
`obrdetail`.`OBRID`
`obrdetail`.`AppropriationID`
`obrdetail`.`ACID`
`obrdetail`.`RespCode`
`obrdetail`.`RespID`
`obrdetail`.`AccountCode`
`obrdetail`.`AccountName`
`obrdetail`.`FPP`
`obrdetail`.`Amount`
`obrdetail`.`OBR_STAT`
`obrsignatoryentity`.*
`obrsignatoryentity`.`ID`
`obrsignatoryentity`.`DepartmentId`
`obrsignatoryentity`.`Types`
`obrsignatoryentity`.`EmployeeId`
`obrsignatoryentity`.`FullName`
`obrsignatoryentity`.`Position`
`otherdeductions_jo`.*
`otherdeductions_jo`.`OD_ID`
`otherdeductions_jo`.`OD_Name`
`otherdeductions_jo`.`OD_PriorityNo`
`otherdeductions_jo`.`OD_Status`
`otherdeductions_jo`.`OD_DateSaved`
`otherdeductions_jo`.`Deduction_Type`
`otherdeductions_jo`.`OD_AccountId`
`otherdeductions_jo`.`OD_PayeeId`
`pap_sector`.*
`pap_sector`.`ID`
`pap_sector`.`Name`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`payee`.*
`payee`.`ID`
`payee`.`PayeeName`
`payee`.`Status`
`payment_mode_setup`.*
`payment_mode_setup`.`id`
`payment_mode_setup`.`reference_no`
`payment_mode_setup`.`description`
`payment_mode_setup`.`remarks`
`payment_mode_setup`.`application_date`
`payment_mode_setup`.`status`
`pi_iventory_dtls`.*
`pi_iventory_dtls`.`id`
`pi_iventory_dtls`.`itm_id`
`pi_iventory_dtls`.`date`
`pi_iventory_dtls`.`qty`
`pi_iventory_dtls`.`branch_id`
`pi_iventory_main`.*
`pi_iventory_main`.`id`
`pi_iventory_main`.`date`
`pi_iventory_main`.`status`
`pmhistory`.*
`pmhistory`.`ID`
`pmhistory`.`AppropriationId`
`pmhistory`.`Yr`
`pmhistory`.`Description`
`pmhistory`.`userFullName`
`positions`.*
`positions`.`ID`
`positions`.`DeptID`
`positions`.`DeptName`
`positions`.`DisplayName`
`positions`.`PositionName`
`positions`.`TS`
`ppmp`.*
`ppmp`.`ID`
`ppmp`.`SOFID`
`ppmp`.`SOFDescription`
`ppmp`.`AccountID`
`ppmp`.`Account`
`ppmp`.`APPID`
`ppmp`.`DEPID`
`ppmp`.`DepartmentName`
`ppmp`.`YR`
`ppmp`.`ItemID`
`ppmp`.`ItemDescription`
`ppmp`.`Qty`
`ppmp`.`UoM`
`ppmp`.`Cost`
`ppmp`.`TotalCost`
`ppmp`.`ModeofProc`
`ppmp`.`Jan`
`ppmp`.`Feb`
`ppmp`.`mar`
`ppmp`.`Apr`
`ppmp`.`may`
`ppmp`.`Jun`
`ppmp`.`Jul`
`ppmp`.`Aug`
`ppmp`.`Sept`
`ppmp`.`Oct_`
`ppmp`.`Nov`
`ppmp`.`Dec_`
`ppmp`.`JanAmt`
`ppmp`.`FebAmt`
`ppmp`.`MarAmt`
`ppmp`.`AprAmt`
`ppmp`.`MayAmt`
`ppmp`.`JunAmt`
`ppmp`.`JulAmt`
`ppmp`.`AugAmt`
`ppmp`.`SeptAmt`
`ppmp`.`OctAmt`
`ppmp`.`NovAmt`
`ppmp`.`DecAmt`
`ppmp`.`UID`
`ppmp`.`ts`
`ppmp`.`ModeofEntry`
`projectmilestone`.*
`projectmilestone`.`id`
`projectmilestone`.`description`
`projectmilestone`.`isComplete`
`projectmilestone`.`projId`
`projectmilestone`.`Status`
`projectmilestone`.`orders`
`re_class`.*
`re_class`.`ID`
`re_class`.`SOFID`
`re_class`.`ParentID`
`re_class`.`Description`
`re_class`.`ShortName`
`re_class`.`ClassOrder`
`re_class`.`Types`
`re_class`.`Level`
`realignment`.*
`realignment`.`ID`
`realignment`.`BatchId`
`realignment`.`AppropriationId`
`realignment`.`AccountName`
`realignment`.`AccountCode`
`realignment`.`ResNo`
`realignment`.`ResDate`
`realignment`.`TransDate`
`realignment`.`Reference`
`realignment`.`BYear`
`realignment`.`OfficeID`
`realignment`.`OfficeName`
`realignment`.`FundId`
`realignment`.`FundName`
`realignment`.`ExpenseClassId`
`realignment`.`ExpenseClass`
`realignment`.`Amount`
`realignment`.`Remarks`
`realignment`.`User`
`realignment`.`Status`
`realignmentsource`.*
`realignmentsource`.`ID`
`realignmentsource`.`BatchId`
`realignmentsource`.`AppropriationId`
`realignmentsource`.`AccountName`
`realignmentsource`.`AccountCode`
`realignmentsource`.`ResNo`
`realignmentsource`.`ResDate`
`realignmentsource`.`TransDate`
`realignmentsource`.`Reference`
`realignmentsource`.`BYear`
`realignmentsource`.`OfficeID`
`realignmentsource`.`OfficeName`
`realignmentsource`.`FundId`
`realignmentsource`.`FundName`
`realignmentsource`.`ExpenseClassId`
`realignmentsource`.`ExpenseClass`
`realignmentsource`.`Amount`
`realignmentsource`.`Remarks`
`realignmentsource`.`User`
`realignmentsource`.`Status`
`realignmentsource`.`LessFromAllotment`
`realignmentsource`.`LessFromAppropriation`
`receiving_item`.*
`receiving_item`.`id`
`receiving_item`.`ref_no`
`receiving_item`.`trans_date`
`receiving_item`.`supplier_id`
`receiving_item`.`received_date`
`receiving_item`.`invoice_number`
`receiving_item`.`total_amount`
`receiving_item`.`ts`
`receiving_item`.`stats`
`receiving_item`.`branch_id`
`receiving_item_dtls`.*
`receiving_item_dtls`.`id`
`receiving_item_dtls`.`rev_id`
`receiving_item_dtls`.`itm_id`
`receiving_item_dtls`.`qty`
`receiving_item_dtls`.`price`
`receiving_item_dtls`.`selling_price`
`remittance_beg`.*
`remittance_beg`.`id`
`remittance_beg`.`sales_amount`
`remittance_beg`.`cashier_id`
`remittance_beg`.`ref_no`
`remittance_beg`.`drawer_amount`
`remittance_beg`.`cashonhand`
`remittance_beg`.`one_thousand`
`remittance_beg`.`five_hundred`
`remittance_beg`.`two_hundred`
`remittance_beg`.`one_hundred`
`remittance_beg`.`fifty`
`remittance_beg`.`twenty`
`remittance_beg`.`ten`
`remittance_beg`.`five`
`remittance_beg`.`one`
`remittance_beg`.`cent`
`remittance_beg`.`total`
`remittance_beg`.`overage_shortage`
`remittance_beg`.`status`
`remittance_beg`.`ts`
`remittance_main`.*
`remittance_main`.`id`
`remittance_main`.`sales_amount`
`remittance_main`.`cashier_id`
`remittance_main`.`ref_no`
`remittance_main`.`drawer_amount`
`remittance_main`.`cashonhand`
`remittance_main`.`one_thousand`
`remittance_main`.`five_hundred`
`remittance_main`.`two_hundred`
`remittance_main`.`one_hundred`
`remittance_main`.`fifty`
`remittance_main`.`twenty`
`remittance_main`.`ten`
`remittance_main`.`five`
`remittance_main`.`one`
`remittance_main`.`cent`
`remittance_main`.`total`
`remittance_main`.`overage_shortage`
`remittance_main`.`status`
`remittance_main`.`ts`
`reversal`.*
`reversal`.`ID`
`reversal`.`BatchId`
`reversal`.`TransDate`
`reversal`.`Reference`
`reversal`.`BYear`
`reversal`.`OfficeID`
`reversal`.`OfficeName`
`reversal`.`FundId`
`reversal`.`FundName`
`reversal`.`ExpenseClassName`
`reversal`.`ExpenseClassId`
`reversal`.`AppropriationId`
`reversal`.`AccountName`
`reversal`.`AccountCode`
`reversal`.`Appropriation`
`reversal`.`Balance`
`reversal`.`Reversal`
`reversal`.`Remarks`
`reversal`.`User`
`reversal`.`Status`
`sales_channel`.*
`sales_channel`.`id`
`sales_channel`.`description`
`sales_channel_setup`.*
`sales_channel_setup`.`id`
`sales_channel_setup`.`reference_no`
`sales_channel_setup`.`description`
`sales_channel_setup`.`remarks`
`sales_channel_setup`.`application_date`
`sales_channel_setup`.`status`
`sales_details`.*
`sales_details`.`id`
`sales_details`.`sales_id`
`sales_details`.`itm_id`
`sales_details`.`qty`
`sales_details`.`price`
`sales_details`.`charges`
`sales_details`.`charge_fee`
`sales_details`.`item_status`
`sales_details`.`remarks`
`sales_main`.*
`sales_main`.`id`
`sales_main`.`ref_no`
`sales_main`.`priority_num`
`sales_main`.`trans_date`
`sales_main`.`reservation_date`
`sales_main`.`customer_id`
`sales_main`.`customer_name`
`sales_main`.`payment_mode`
`sales_main`.`downpayment`
`sales_main`.`warranty`
`sales_main`.`trans_type`
`sales_main`.`table_id`
`sales_main`.`total_amount`
`sales_main`.`ts`
`sales_main`.`stat`
`sales_main`.`reservation`
`sales_main`.`discountType`
`sales_main`.`IDtype`
`sales_main`.`ID_num`
`sales_main`.`Cutting_fee`
`sales_main`.`del_Fee`
`sales_main`.`discount_amount`
`sales_main`.`total_payable`
`sales_main`.`cashpaid`
`sales_main`.`amount_paid`
`sales_main`.`uid`
`sales_main`.`person`
`sales_main`.`senior`
`sales_main`.`charge_to_owner`
`sales_main`.`change`
`sales_main`.`remarks`
`sales_main`.`remit_id`
`sales_main`.`cancelled_by`
`sales_main`.`branch_id`
`sales_main`.`entry_type`
`sales_payment`.*
`sales_payment`.`id`
`sales_payment`.`sales_id`
`sales_payment`.`total_amount`
`sales_payment`.`discountType`
`sales_payment`.`discount_amount`
`sales_payment`.`tableName`
`sales_payment`.`total_payable`
`sales_payment`.`amount_paid`
`sales_payment`.`change`
`sales_payment`.`ts`
`sales_payment`.`stats`
`sales_status`.*
`sales_status`.`id`
`sales_status`.`sales_id`
`sales_status`.`statusDescription`
`sales_status`.`ts`
`sales_table`.*
`sales_table`.`id`
`sales_table`.`tbl_name`
`sales_table`.`statx`
`sales_table`.`used`
`sectors`.*
`sectors`.`ID`
`sectors`.`Name`
`sef_budget`.*
`sef_budget`.`ID`
`sef_budget`.`SOF`
`sef_budget`.`AddRptTax`
`sef_budget`.`AddUnAppropriated`
`sef_budget`.`TotalEstimate`
`sef_budget`.`LessContinuing`
`sef_budget`.`NetAmount`
`sef_budget`.`BudgetType`
`sef_budget`.`Category`
`sef_budget`.`CategoryID`
`sef_budget`.`CategoryOrder`
`sef_budget`.`SubCategory`
`sef_budget`.`SubCategoryID`
`sef_budget`.`SubCategoryOrder`
`sef_budget`.`UnderSubName`
`sef_budget`.`UnderSubID`
`sef_budget`.`UnderSubOrder`
`sef_budget`.`BYear`
`sef_budget`.`DescriptionID`
`sef_budget`.`Description`
`sef_budget`.`Personal`
`sef_budget`.`maintenance`
`sef_budget`.`CO`
`sef_budget`.`FinancialExpenses`
`sef_budget`.`Total`
`sef_budget`.`UID`
`sef_budget`.`TS`
`sef_budget`.`Status`
`sef_budget`.`SG`
`sef_budget`.`Step`
`sef_budget`.`ApprovalStatus`
`sef_utilization`.*
`sef_utilization`.`ID`
`sef_utilization`.`ExpClass`
`sef_utilization`.`BudgetType`
`sef_utilization`.`CategoryID`
`sef_utilization`.`Category`
`sef_utilization`.`CategoryOrder`
`sef_utilization`.`SubCategoryID`
`sef_utilization`.`SubCategory`
`sef_utilization`.`SubCategoryOrder`
`sef_utilization`.`UnderSubID`
`sef_utilization`.`UnderSubName`
`sef_utilization`.`UnderSubOrder`
`sef_utilization`.`BYear`
`sef_utilization`.`DescriptionID`
`sef_utilization`.`Description`
`sef_utilization`.`Amount`
`sef_utilization`.`Jan`
`sef_utilization`.`Feb`
`sef_utilization`.`Mar`
`sef_utilization`.`Apr`
`sef_utilization`.`May`
`sef_utilization`.`Jun`
`sef_utilization`.`Jul`
`sef_utilization`.`Aug`
`sef_utilization`.`Sep`
`sef_utilization`.`Oct_`
`sef_utilization`.`Nov`
`sef_utilization`.`Dec_`
`sef_utilization`.`UID`
`sef_utilization`.`TS`
`sef_utilization`.`Status`
`sef_utilizationbeginning`.*
`sef_utilizationbeginning`.`ID`
`sef_utilizationbeginning`.`ExpClass`
`sef_utilizationbeginning`.`BudgetType`
`sef_utilizationbeginning`.`CategoryID`
`sef_utilizationbeginning`.`Category`
`sef_utilizationbeginning`.`CategoryOrder`
`sef_utilizationbeginning`.`SubCategoryID`
`sef_utilizationbeginning`.`SubCategory`
`sef_utilizationbeginning`.`SubCategoryOrder`
`sef_utilizationbeginning`.`UnderSubID`
`sef_utilizationbeginning`.`UnderSubName`
`sef_utilizationbeginning`.`UnderSubOrder`
`sef_utilizationbeginning`.`BYear`
`sef_utilizationbeginning`.`DescriptionID`
`sef_utilizationbeginning`.`Description`
`sef_utilizationbeginning`.`Amount`
`sef_utilizationbeginning`.`Jan`
`sef_utilizationbeginning`.`Feb`
`sef_utilizationbeginning`.`Mar`
`sef_utilizationbeginning`.`Apr`
`sef_utilizationbeginning`.`May`
`sef_utilizationbeginning`.`Jun`
`sef_utilizationbeginning`.`Jul`
`sef_utilizationbeginning`.`Aug`
`sef_utilizationbeginning`.`Sep`
`sef_utilizationbeginning`.`Oct_`
`sef_utilizationbeginning`.`Nov`
`sef_utilizationbeginning`.`Dec_`
`sef_utilizationbeginning`.`UID`
`sef_utilizationbeginning`.`TS`
`sef_utilizationbeginning`.`Status`
`sefmodel`.*
`sefmodel`.`ID`
`sefmodel`.`G1`
`sefmodel`.`G2`
`sefmodel`.`G3`
`sefmodel`.`BYEAR`
`sefmodel`.`OFFICECODE`
`sefmodel`.`OFFICE`
`sefmodel`.`CODE`
`sefmodel`.`DESCRIPTION`
`sefmodel`.`APPROPRIATION`
`sefmodel`.`TOTALALLOTMENT`
`sefmodel`.`APPROPRIATIONBALANCE`
`sefmodel`.`OBLIGATION`
`sefmodel`.`UNOBLIGATEDBALANCE`
`sefmodel`.`isContinuing`
`sefmodel`.`DeptId`
`sefmodel`.`SheetName`
`sefprogramdefault`.*
`sefprogramdefault`.`ID`
`sefprogramdefault`.`LBPType`
`sefprogramdefault`.`CategoryId`
`sefprogramdefault`.`Category`
`sefprogramdefault`.`CategoryOrder`
`sefprogramdefault`.`SubCategoryID`
`sefprogramdefault`.`SubCategory`
`sefprogramdefault`.`SubCategoryOrder`
`sefprogramdefault`.`UnderSubID`
`sefprogramdefault`.`UnderSubName`
`sefprogramdefault`.`UnderSubOrder`
`sefprogramdefault`.`OfficeID`
`sefprogramdefault`.`OfficeName`
`sefprogramdefault`.`Description`
`sefprogramdefault`.`UID`
`sefprogramdefault`.`ts`
`sefprogramdefault`.`Ordering`
`sefprogramdefault`.`FUNDID`
`sefprogramdefault`.`FUNDNAME`
`semester`.*
`semester`.`ID`
`semester`.`Description`
`semester`.`FromDate`
`semester`.`ToDate`
`settings`.*
`settings`.`ID`
`settings`.`ParentID`
`settings`.`Description`
`settings`.`Status`
`settings`.`TValue`
`setup_formtype`.*
`setup_formtype`.`id`
`setup_formtype`.`type`
`setup_formtype`.`status`
`setup_formtype`.`form_id`
`setup_item`.*
`setup_item`.`id`
`setup_item`.`thumPath`
`setup_item`.`imagePath`
`setup_item`.`ref_no`
`setup_item`.`itemName`
`setup_item`.`forKitchen`
`setup_item`.`forInvent`
`setup_item`.`shwMenu`
`setup_item`.`itemDescription`
`setup_item`.`price`
`setup_item`.`uom`
`setup_item`.`commision`
`setup_item`.`category_id`
`setup_item`.`item_group`
`setup_item`.`reorder_lvl`
`setup_item`.`stat`
`setup_item`.`ts`
`setup_item`.`cancelled_by`
`setup_item`.`main_id`
`setup_item`.`item_stat`
`setup_item`.`last_purchase_price`
`setup_item`.`branch_id`
`setup_item`.`withCommsn`
`setup_item_category`.*
`setup_item_category`.`id`
`setup_item_category`.`category_name`
`setup_item_category`.`stat`
`setup_item_category`.`ts`
`setup_item_category`.`cancelled_by`
`setup_item_category`.`sortby`
`setup_item_grouping`.*
`setup_item_grouping`.`id`
`setup_item_grouping`.`main_id`
`setup_item_grouping`.`itm_id`
`signatory`.*
`signatory`.`ID`
`signatory`.`_Type`
`signatory`.`Name`
`signatory`.`_Position`
`signatory_table`.*
`signatory_table`.`id`
`signatory_table`.`Signatory_desc`
`signatory_table`.`stat`
`signatoryentity`.*
`signatoryentity`.`ID`
`signatoryentity`.`FullName`
`signatoryentity`.`Position`
`signatoryentity`.`SigStatus`
`signatoryentity`.`DeptID`
`spa_services`.*
`spa_services`.`id`
`spa_services`.`Name`
`sub_classification_setup`.*
`sub_classification_setup`.`sub_classification_id`
`sub_classification_setup`.`sub_classification_name`
`sub_classification_setup`.`sub_subclass_id`
`sub_classification_setup`.`class_id`
`sub_classification_setup`.`sub_classification_code`
`sub_classification_setup`.`Subclassorders`
`sub_classification_setup`.`OWNERID`
`subcategory`.*
`subcategory`.`ID`
`subcategory`.`LBP`
`subcategory`.`CategoryID`
`subcategory`.`CategoryName`
`subcategory`.`Name`
`subcategory`.`ShortName`
`subcategory`.`Status`
`subcategory`.`Ordering`
`subcategory`.`ExpenseID`
`subsubcategory`.*
`subsubcategory`.`ID`
`subsubcategory`.`LBP`
`subsubcategory`.`CategoryID`
`subsubcategory`.`CategoryName`
`subsubcategory`.`SubCategoryID`
`subsubcategory`.`SubCategoryName`
`subsubcategory`.`Name`
`subsubcategory`.`Status`
`subsubcategory`.`Ordering`
`supplemental`.*
`supplemental`.`ID`
`supplemental`.`BatchId`
`supplemental`.`AppropriationId`
`supplemental`.`Account`
`supplemental`.`Code`
`supplemental`.`SortBy`
`supplemental`.`TransDate`
`supplemental`.`Reference`
`supplemental`.`BYear`
`supplemental`.`OfficeID`
`supplemental`.`OfficeName`
`supplemental`.`FundId`
`supplemental`.`FundName`
`supplemental`.`ExpenseClassId`
`supplemental`.`ExpenseClass`
`supplemental`.`Amount`
`supplemental`.`Remarks`
`supplemental`.`User`
`supplemental`.`Status`
`supplemental`.`OrdinanceNo`
`supplemental`.`OrdinanceDate`
`supplementalsources`.*
`supplementalsources`.`ID`
`supplementalsources`.`BatchId`
`supplementalsources`.`AppropriationId`
`supplementalsources`.`Account`
`supplementalsources`.`Code`
`supplementalsources`.`SortBy`
`supplementalsources`.`TransDate`
`supplementalsources`.`Reference`
`supplementalsources`.`BYear`
`supplementalsources`.`OfficeID`
`supplementalsources`.`OfficeName`
`supplementalsources`.`FundId`
`supplementalsources`.`FundName`
`supplementalsources`.`ExpenseClassId`
`supplementalsources`.`ExpenseClass`
`supplementalsources`.`Amount`
`supplementalsources`.`Remarks`
`supplementalsources`.`User`
`supplementalsources`.`Status`
`supplementalsources`.`OrdinanceNo`
`supplementalsources`.`OrdinanceDate`
`supplier_setup`.*
`supplier_setup`.`id`
`supplier_setup`.`reference_no`
`supplier_setup`.`supplier_name`
`supplier_setup`.`supplier_address`
`supplier_setup`.`application_date`
`supplier_setup`.`status`
`table_reservation`.*
`table_reservation`.`id`
`table_reservation`.`customer_name`
`table_reservation`.`table_no`
`table_reservation`.`ref_no`
`table_reservation`.`res_date`
`table_reservation`.`res_time`
`table_reservation`.`ts`
`table_reservation`.`res_status`
`table_reservation`.`status`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`mobile`
`users`.`approved`
`users`.`admin`
`users`.`cancel`
`users`.`branch_id`
`users`.`ts`
`wfp`.*
`wfp`.`ID`
`wfp`.`BatchGUID`
`wfp`.`budgetYear`
`wfp`.`DepartmentId`
`wfp`.`SectorId`
`wfp`.`Category`
`wfp`.`SubCategory`
`wfp`.`PPA`
`wfp`.`RespPerson`
`wfp`.`Appropriation`
`wfp`.`Utilization`
`wfp`.`Proposed`
`wfp`.`Particulars`
`wfp`.`ExpenseClassId`
`wfp`.`FundingSourceId`
`wfp`.`Output`
`wfp`.`Outcome`
`wfp`.`Target`
`wfp`.`Accomplishment`
`wfp`.`Status`
`wfp`.`ItemOrder`
`_columns`.*
`_columns`.`id`
`_columns`.`column_name`
`_columns`.`display_col`
`_columns`.`status`
`_columns`.`type`
`_columns`.`liquidate`
`accountbudget`.*
`accountbudget`.`ID`
`accountbudget`.`ParentId`
`accountbudget`.`AppropriationID`
`accountbudget`.`DepartmentId`
`accountbudget`.`SOFID`
`accountbudget`.`BYear`
`accountbudget`.`Description1`
`accountbudget`.`Description2`
`accountbudget`.`Amount`
`accountbudget`.`Amount2`
`accountbudget`.`Amount3`
`accountbudget`.`AllotmentReleased`
`accountbudget`.`SupplementalAmt`
`accountbudget`.`RealignmentAmt`
`accountbudget`.`Expense_Class_id`
`accountbudget`.`Expense_Class`
`accountbudget`.`Status`
`accountbudget`.`SOF`
`accountbudget`.`Category`
`accountbudget`.`CategoryID`
`accountbudget`.`CategoryOrder`
`accountbudget`.`SubCategory`
`accountbudget`.`SubCategoryID`
`accountbudget`.`SubCategoryOrder`
`accountbudget`.`UnderSubName`
`accountbudget`.`UnderSubID`
`accountbudget`.`UnderSubOrder`
`accountbudget`.`DescriptionID2`
`accountbudget`.`DescriptionID1`
`accountbudget`.`isContinuing`
`accountbudget`.`UID`
`accountbudget`.`TS`
`accountbudget`.`ApprovalStatus`
`accountbudget`.`StartDate`
`accountbudget`.`EndDate`
`accountbudget`.`WFPID`
`accountbudget`.`BudgetType`
`accountbudget`.`ORNo`
`accountbudget`.`ProjectName`
`accountbudget`.`projectId`
`accountbudget`.`Purposed`
`accountbudget`.`SheetName`
`accountbudget`.`devremarks`
`accountbudget_copy`.*
`accountbudget_copy`.`ID`
`accountbudget_copy`.`ParentId`
`accountbudget_copy`.`AppropriationID`
`accountbudget_copy`.`DepartmentId`
`accountbudget_copy`.`SOFID`
`accountbudget_copy`.`BYear`
`accountbudget_copy`.`Description1`
`accountbudget_copy`.`Description2`
`accountbudget_copy`.`Amount`
`accountbudget_copy`.`Amount2`
`accountbudget_copy`.`Amount3`
`accountbudget_copy`.`AllotmentReleased`
`accountbudget_copy`.`SupplementalAmt`
`accountbudget_copy`.`RealignmentAmt`
`accountbudget_copy`.`Expense_Class_id`
`accountbudget_copy`.`Expense_Class`
`accountbudget_copy`.`Status`
`accountbudget_copy`.`SOF`
`accountbudget_copy`.`Category`
`accountbudget_copy`.`CategoryID`
`accountbudget_copy`.`CategoryOrder`
`accountbudget_copy`.`SubCategory`
`accountbudget_copy`.`SubCategoryID`
`accountbudget_copy`.`SubCategoryOrder`
`accountbudget_copy`.`UnderSubName`
`accountbudget_copy`.`UnderSubID`
`accountbudget_copy`.`UnderSubOrder`
`accountbudget_copy`.`DescriptionID2`
`accountbudget_copy`.`DescriptionID1`
`accountbudget_copy`.`isContinuing`
`accountbudget_copy`.`UID`
`accountbudget_copy`.`TS`
`accountbudget_copy`.`ApprovalStatus`
`accountbudget_copy`.`StartDate`
`accountbudget_copy`.`EndDate`
`accountbudget_copy`.`WFPID`
`accountbudget_copy`.`BudgetType`
`accountbudget_copy`.`ORNo`
`accountbudget_copy`.`ProjectName`
`accountbudget_copy`.`projectId`
`accountbudget_copy`.`Purposed`
`accountbudget_copy`.`SheetName`
`accountclass`.*
`accountclass`.`ID`
`accountclass`.`LBP`
`accountclass`.`ParentID`
`accountclass`.`description`
`accountclass`.`AccountId`
`accountclass`.`Code`
`accountclass`.`Level`
`accountclass`.`status`
`accountclass_budget`.*
`accountclass_budget`.`ID`
`accountclass_budget`.`AppropId`
`accountclass_budget`.`byear`
`accountclass_budget`.`deptId`
`accountclass_budget`.`Amount`
`accountrevision`.*
`accountrevision`.`Id`
`accountrevision`.`SOF`
`accountrevision`.`BudgetType`
`accountrevision`.`BYear`
`accountrevision`.`DepartmentId`
`accountrevision`.`Acid`
`accountrevision`.`AccountDescription`
`accountrevision`.`Amount`
`accountrevision`.`UID`
`accountrevision`.`TS`
`accountrevision`.`Status`
`accountrevision`.`Revision`
`accountrevision`.`OrigAmt`
`accounts_parents`.*
`accounts_parents`.`ID`
`accounts_parents`.`GID`
`accounts_parents`.`ACID`
`accounts_parents`.`GEN_NAMES`
`accounts_parents`.`account_code`
`accounts_parents`.`account_description`
`accounts_parents`.`CLASSIFICATION`
`accounts_parents`.`SUBLASS`
`accounts_parents`.`t_account`
`accounts_parents`.`GEN_CODE`
`accounts_parents`.`CLASSIFICATION_CODE`
`accounts_parents`.`SUBCLASS_CODE`
`accounts_parents`.`markcontra`
`accounts_parents`.`ACCOUNT_SPACE`
`accountutilization`.*
`accountutilization`.`Id`
`accountutilization`.`AppropriationID`
`accountutilization`.`OBRID`
`accountutilization`.`SOFID`
`accountutilization`.`DepartmentId`
`accountutilization`.`BYear`
`accountutilization`.`RespCenterId`
`accountutilization`.`RespCenterName`
`accountutilization`.`Amount`
`accountutilization`.`Jan`
`accountutilization`.`Feb`
`accountutilization`.`Mar`
`accountutilization`.`Apr`
`accountutilization`.`May`
`accountutilization`.`Jun`
`accountutilization`.`Jul`
`accountutilization`.`Aug`
`accountutilization`.`Sep`
`accountutilization`.`Octo`
`accountutilization`.`Nov`
`accountutilization`.`Dece`
`accountutilization`.`UID`
`accountutilization`.`TS`
`accountutilization`.`Status`
`accountutilization`.`sheetName`
`accountutilization`.`ManualEntryGUID`
`accountutilization`.`Acode`
`accountutilizationbeginning`.*
`accountutilizationbeginning`.`Id`
`accountutilizationbeginning`.`AppropriationID`
`accountutilizationbeginning`.`SOF`
`accountutilizationbeginning`.`BudgetType`
`accountutilizationbeginning`.`BYear`
`accountutilizationbeginning`.`DepartmentId`
`accountutilizationbeginning`.`ACID`
`accountutilizationbeginning`.`_Code`
`accountutilizationbeginning`.`Description`
`accountutilizationbeginning`.`Amount`
`accountutilizationbeginning`.`Jan`
`accountutilizationbeginning`.`Feb`
`accountutilizationbeginning`.`Mar`
`accountutilizationbeginning`.`Apr`
`accountutilizationbeginning`.`May`
`accountutilizationbeginning`.`Jun`
`accountutilizationbeginning`.`Jul`
`accountutilizationbeginning`.`Aug`
`accountutilizationbeginning`.`Sep`
`accountutilizationbeginning`.`Oct`
`accountutilizationbeginning`.`Nov`
`accountutilizationbeginning`.`Dec`
`accountutilizationbeginning`.`UID`
`accountutilizationbeginning`.`TS`
`accountutilizationbeginning`.`Status`
`acctdummy`.*
`acctdummy`.`ID`
`acctdummy`.`Amount4`
`additionalbudget`.*
`additionalbudget`.`ID`
`additionalbudget`.`sofId`
`additionalbudget`.`appropriationId`
`additionalbudget`.`Btype`
`additionalbudget`.`GUID`
`additionalbudget`.`Yr`
`additionalbudget`.`OfficeID`
`additionalbudget`.`OfficeName`
`additionalbudget`.`ACID`
`additionalbudget`.`Code`
`additionalbudget`.`Account`
`additionalbudget`.`PrevBalance`
`additionalbudget`.`AdditionalAmt`
`additionalbudget`.`NewBudget`
`additionalbudget`.`Remarks`
`additionalbudget`.`UID`
`additionalbudget`.`TS`
`additionalbudget`.`Status`
`adjustment_minus`.*
`adjustment_minus`.`ID`
`adjustment_minus`.`BatchId`
`adjustment_minus`.`AppropriationId`
`adjustment_minus`.`Account`
`adjustment_minus`.`Code`
`adjustment_minus`.`SortBy`
`adjustment_minus`.`TransDate`
`adjustment_minus`.`Reference`
`adjustment_minus`.`BYear`
`adjustment_minus`.`OfficeID`
`adjustment_minus`.`OfficeName`
`adjustment_minus`.`FundId`
`adjustment_minus`.`FundName`
`adjustment_minus`.`ExpenseClassId`
`adjustment_minus`.`ExpenseClass`
`adjustment_minus`.`Amount`
`adjustment_minus`.`Remarks`
`adjustment_minus`.`User`
`adjustment_minus`.`Status`
`adjustment_minus`.`OrdinanceNo`
`adjustment_minus`.`OrdinanceDate`
`adjustment_plus`.*
`adjustment_plus`.`ID`
`adjustment_plus`.`BatchId`
`adjustment_plus`.`AppropriationId`
`adjustment_plus`.`Account`
`adjustment_plus`.`Code`
`adjustment_plus`.`SortBy`
`adjustment_plus`.`TransDate`
`adjustment_plus`.`Reference`
`adjustment_plus`.`BYear`
`adjustment_plus`.`OfficeID`
`adjustment_plus`.`OfficeName`
`adjustment_plus`.`FundId`
`adjustment_plus`.`FundName`
`adjustment_plus`.`ExpenseClassId`
`adjustment_plus`.`ExpenseClass`
`adjustment_plus`.`Amount`
`adjustment_plus`.`Remarks`
`adjustment_plus`.`User`
`adjustment_plus`.`Status`
`adjustment_plus`.`OrdinanceNo`
`adjustment_plus`.`OrdinanceDate`
`aipentry`.*
`aipentry`.`ID`
`aipentry`.`SOFID`
`aipentry`.`SOF`
`aipentry`.`StartDate`
`aipentry`.`EndDate`
`aipentry`.`OfficeID`
`aipentry`.`OfficeName`
`aipentry`.`grouping`
`aipentry`.`SectorID`
`aipentry`.`Sector`
`aipentry`.`accountID`
`aipentry`.`AppopriationID`
`aipentry`.`Account`
`aipentry`.`Year`
`aipentry`.`Code`
`aipentry`.`Description`
`aipentry`.`MOOE`
`aipentry`.`CO`
`aipentry`.`Amount`
`aipentry`.`groupid`
`aipentry`.`GroupName`
`aipentry`.`YearCount`
`aipentry`.`class1`
`aipentry`.`class2`
`aipentry`.`class3`
`aipentry`.`UID`
`aipentry`.`Status`
`aipentry`.`WFPID`
`aipentry`.`TS`
`aipentry_utilization`.*
`aipentry_utilization`.`ID`
`aipentry_utilization`.`AIPID`
`aipentry_utilization`.`SOFID`
`aipentry_utilization`.`SOF`
`aipentry_utilization`.`StartDate`
`aipentry_utilization`.`EndDate`
`aipentry_utilization`.`OfficeID`
`aipentry_utilization`.`OfficeName`
`aipentry_utilization`.`SectorId`
`aipentry_utilization`.`Sector`
`aipentry_utilization`.`AppopriationID`
`aipentry_utilization`.`Account`
`aipentry_utilization`.`Year`
`aipentry_utilization`.`Code`
`aipentry_utilization`.`Description`
`aipentry_utilization`.`MOOE`
`aipentry_utilization`.`CO`
`aipentry_utilization`.`ActualMOOE`
`aipentry_utilization`.`ActualCO`
`aipentry_utilization`.`UID`
`aipentry_utilization`.`TS`
`allotmentrelease`.*
`allotmentrelease`.`ID`
`allotmentrelease`.`FullAroNum`
`allotmentrelease`.`ARODate`
`allotmentrelease`.`CategoryID`
`allotmentrelease`.`Category`
`allotmentrelease`.`BYEAR`
`allotmentrelease`.`officeID`
`allotmentrelease`.`ppaCode`
`allotmentrelease`.`appropriationId`
`allotmentrelease`.`AccountID`
`allotmentrelease`.`AccountDescription`
`allotmentrelease`.`FundID`
`allotmentrelease`.`FundCode`
`allotmentrelease`.`FundName`
`allotmentrelease`.`BudgetSource`
`allotmentrelease`.`objectclass_AccountCode`
`allotmentrelease`.`objectclass_AccountCodeId`
`allotmentrelease`.`Appropriation`
`allotmentrelease`.`ReleasedAmt`
`allotmentrelease`.`purpose`
`allotmentrelease`.`UID`
`allotmentrelease`.`ts`
`allotmentrelease`.`LastEntry`
`allotmentrelease`.`Quarter_`
`allotmentrelease`.`Status`
`allotmentrelease`.`BatchGUID`
`allowances_jo`.*
`allowances_jo`.`allowance_id`
`allowances_jo`.`allowance_name`
`allowances_jo`.`allowance_status`
`allowances_jo`.`account_id`
`allowances_jo`.`allowance_type`
`appplan`.*
`appplan`.`ID`
`appplan`.`ItemClass`
`appplan`.`BudTypeID`
`appplan`.`BudType`
`appplan`.`SOFID`
`appplan`.`SOFDescription`
`appplan`.`ACID`
`appplan`.`Account`
`appplan`.`PPMPID`
`appplan`.`GUID`
`appplan`.`DateSubmitted`
`appplan`.`DepartmentID`
`appplan`.`DepartmentName`
`appplan`.`BYear`
`appplan`.`AppropriatedAmt`
`appplan`.`Contigency`
`appplan`.`NetAmt`
`appplan`.`ControlNum`
`appplan`.`UID`
`appplan`.`TS`
`appplan`.`ItemID`
`appplan`.`Description`
`appplan`.`Qty`
`appplan`.`UoM`
`appplan`.`UnitPrice`
`appplan`.`TotalCost`
`appplan`.`FQty`
`appplan`.`FAmount`
`appplan`.`SQty`
`appplan`.`SAmount`
`appplan`.`TQty`
`appplan`.`TAmount`
`appplan`.`FRQty`
`appplan`.`FRAmount`
`appsignatories`.*
`appsignatories`.`ID`
`appsignatories`.`DepartmentID`
`appsignatories`.`SigType`
`appsignatories`.`Signame`
`appsignatories`.`Position`
`appsignatories`.`UID`
`apv_number`.*
`apv_number`.`ID`
`apv_number`.`JID`
`apv_number`.`APVNUM`
`apv_number`.`LOC`
`apv_number`.`TITLE`
`apv_number`.`YYYY`
`apv_number`.`PO`
`apv_number`.`INV`
`apv_number`.`GRPS`
`atc_setup`.*
`atc_setup`.`ID`
`atc_setup`.`DESCRIPTION`
`atc_setup`.`Goodservice`
`atc_setup`.`ATC`
`atc_setup`.`RATE`
`atc_setup`.`ACID`
`atc_setup`.`CID`
`atc_tax_rate`.*
`atc_tax_rate`.`ID`
`atc_tax_rate`.`ATC`
`atc_tax_rate`.`Rate`
`bank_recon_records`.*
`bank_recon_records`.`ID`
`bank_recon_records`.`GRP`
`bank_recon_records`.`ACCOUNTID`
`bank_recon_records`.`SAVE_DATE`
`bank_recon_records`.`ReportedBankBalance`
`bank_recon_records`.`AmountBeforeRecon`
`bank_recon_records`.`asofdate`
`bank_recon_records`.`GUID`
`bank_recon_records`.`ReconDates`
`beginning_temp`.*
`beginning_temp`.`ID`
`beginning_temp`.`ACID`
`beginning_temp`.`CODE`
`beginning_temp`.`DESCRIPTION`
`beginning_temp`.`JAN`
`beginning_temp`.`FEB`
`beginning_temp`.`MAR`
`beginning_temp`.`APR`
`beginning_temp`.`MAY`
`beginning_temp`.`JUN`
`beginning_temp`.`JUL`
`beginning_temp`.`AUG`
`beginning_temp`.`SEP`
`beginning_temp`.`OCT`
`beginning_temp`.`NOV`
`beginning_temp`.`DEC`
`beginning_temp`.`YR`
`beginning_temp`.`GID`
`beginning_temp`.`GID1`
`beginning_temp`.`ACCOUNTSPACE`
`beginning_temp`.`MAINID`
`beginning_temp`.`OFFICE`
`beginning_temp`.`COST_CENTER`
`beginning_temp`.`DRCR`
`beginning_temp`.`SUBTYPE`
`beginning_temp`.`ISBANK`
`bill_series`.*
`bill_series`.`ID`
`bill_series`.`Year`
`bill_series`.`series`
`bill_series`.`titleid`
`bill_series`.`JID`
`bill_series`.`ref`
`bill_series`.`SUBID`
`bill_series`.`tstamp`
`billing_monitoring`.*
`billing_monitoring`.`bill_id`
`billing_monitoring`.`bill_projectNo`
`billing_monitoring`.`bill_projectname`
`billing_monitoring`.`bill_requesteddate`
`billing_monitoring`.`bill_requestpercentage`
`billing_monitoring`.`bill_requestdetails`
`billing_monitoring`.`bill_requestamount`
`billing_monitoring`.`bill_requestremarks`
`billing_monitoring`.`bill_date`
`billing_monitoring`.`bill_percentage`
`billing_monitoring`.`bill_details`
`billing_monitoring`.`bill_amount`
`billing_monitoring`.`bill_recoupment`
`billing_monitoring`.`bill_vat2`
`billing_monitoring`.`bill_vat5`
`billing_monitoring`.`bill_others`
`billing_monitoring`.`bill_incometax1`
`billing_monitoring`.`bill_royalty`
`billing_monitoring`.`bill_birdue`
`billing_monitoring`.`bill_bonds`
`billing_monitoring`.`bill_otherssubcon`
`billing_monitoring`.`bill_amountNet`
`billing_monitoring`.`bill_remarks`
`billing_monitoring`.`saved_date`
`billing_monitoring`.`bill_actualAccomplished`
`billing_monitoring`.`bill_subcon`
`billing_monitoring`.`PROJECT_ID`
`billing_monitoring`.`RETENTION`
`billing_monitoring`.`JID`
`billing_others`.*
`billing_others`.`ID`
`billing_others`.`JID`
`billing_others`.`DTL_ID`
`billing_others`.`ACCOUNT_ID`
`billing_others`.`AMOUNT`
`billing_others`.`ORNUM`
`billing_others`.`ORDATE`
`billing_others`.`BLID`
`billing_others`.`ACCOUNT_DESC`
`billing_others`.`CONTAINER`
`billing_others`.`CID`
`billingrecord`.*
`billingrecord`.`ID`
`billingrecord`.`equipmentID`
`billingrecord`.`BILL_NO`
`billingrecord`.`CUSTOMER`
`billingrecord`.`LOCATION`
`billingrecord`.`TITLEID`
`billingrecord`.`FL`
`billingrecord`.`CTYPE`
`billingrecord`.`trans_date`
`billingrecord`.`reference`
`billingrecord`.`start_time`
`billingrecord`.`end_time`
`billingrecord`.`unit`
`billingrecord`.`rate`
`billingrecord`.`location_frm`
`billingrecord`.`location_to`
`billingrecord`.`REMARKS`
`billingrecord`.`TRIPS_NUM`
`billingrecord`.`KM`
`billingrecord`.`TS`
`billingrecord`.`JID`
`billingrecord`.`GUID`
`billingrecord`.`UID`
`billingrecord`.`dispatchid`
`billingrecord`.`refnum`
`billingrecord`.`operators`
`billingrecord`.`DTLS`
`billingrecord`.`EQUIPMENT`
`billingrecord`.`DEPARTMENT`
`billingrecord`.`DEPID`
`billingrecord`.`entry_date`
`billingrecord`.`ITEMDESCRIPTION`
`bislig_petty_liquidate`.*
`bislig_petty_liquidate`.`ID`
`bislig_petty_liquidate`.`ReleasedID`
`bislig_petty_liquidate`.`EMPID`
`bislig_petty_liquidate`.`TS`
`bislig_petty_liquidate`.`STATUS`
`bislig_petty_liquidate`.`LIQ_JID`
`bislig_petty_liquidate`.`GRP`
`bislig_system`.*
`bislig_system`.`id`
`bislig_system`.`company_name`
`bislig_system`.`address`
`bislig_system`.`logo_name`
`bislig_system`.`photo`
`bisligpetty`.*
`bisligpetty`.`ID`
`bisligpetty`.`EMPID`
`bisligpetty`.`TDATE`
`bisligpetty`.`REF`
`bisligpetty`.`AMT`
`bisligpetty`.`RELEASEDBY`
`bisligpetty`.`STATUS`
`bisligpetty`.`TS`
`bisligpetty`.`LOCATION`
`bisligpetty`.`CANCEL_reason`
`bisligpetty`.`memo`
`bisligpetty`.`custodian`
`bisligpetty`.`supervisor`
`board_directors`.*
`board_directors`.`ID`
`board_directors`.`dates`
`board_directors`.`costcenter`
`board_directors`.`resolutionApproved`
`board_directors`.`policiesPass`
`board_directors`.`DirectorsFee`
`board_directors`.`Held`
`board_directors`.`regular`
`board_directors`.`special`
`board_directors`.`seminar`
`board_directors`.`ts`
`board_directors`.`uid`
`board_directors`.`STATUS`
`board_directors`.`GID`
`branch_setup`.*
`branch_setup`.`id`
`branch_setup`.`reference_no`
`branch_setup`.`branch_name`
`branch_setup`.`branch_address`
`branch_setup`.`application_date`
`branch_setup`.`status`
`breakdowngroup`.*
`breakdowngroup`.`ID`
`breakdowngroup`.`ParentID`
`breakdowngroup`.`Description`
`breakdowngroup`.`Status`
`budget_setup`.*
`budget_setup`.`id`
`budget_setup`.`class`
`budget_setup`.`subclass`
`budget_setup`.`account`
`budget_setup`.`year`
`budget_setup`.`jan`
`budget_setup`.`feb`
`budget_setup`.`mar`
`budget_setup`.`apr`
`budget_setup`.`may`
`budget_setup`.`jun`
`budget_setup`.`jul`
`budget_setup`.`aug`
`budget_setup`.`sep`
`budget_setup`.`oct`
`budget_setup`.`nov`
`budget_setup`.`dec`
`budget_setup`.`location`
`budget_setup`.`division`
`budget_setup`.`titleID`
`budget_setup`.`identification`
`budget_setup_dtl`.*
`budget_setup_dtl`.`dtl_id`
`budget_setup_dtl`.`budget_id`
`budget_setup_dtl`.`year`
`budget_setup_dtl`.`month`
`budget_setup_dtl`.`type`
`budget_setup_dtl`.`cash_flow`
`budget_setup_dtl`.`item_type`
`budget_setup_dtl`.`item_id`
`budget_setup_dtl`.`item_description`
`budget_setup_dtl`.`item_display_name`
`budget_setup_dtl`.`transaction_type`
`budget_setup_dtl`.`expense_type`
`budget_setup_dtl`.`cost_type`
`budget_setup_dtl`.`quantity`
`budget_setup_dtl`.`unit_measure`
`budget_setup_dtl`.`unit_cost`
`budget_setup_dtl`.`no_of_person`
`budget_setup_dtl`.`total_amount`
`budget_setup_dtl`.`purpose`
`budget_setup_dtl`.`status`
`budget_setup_dtl`.`save_date`
`budget_setup_dtl`.`title_id`
`budget_setup_dtl`.`location_id`
`budget_setup_dtl`.`division_id`
`budget_setup_dtl`.`account_id`
`budget_signatory`.*
`budget_signatory`.`Signatory_ID`
`budget_signatory`.`Signatory_Name`
`budget_signatory`.`Signatory_Position`
`budget_signatory`.`Signatory_Position_id`
`budget_signatory`.`Signatory_PP_ID`
`budget_signatory`.`department_id`
`budget_signatory`.`status`
`budgetappropriationstatus`.*
`budgetappropriationstatus`.`ID`
`budgetappropriationstatus`.`budgetType`
`budgetappropriationstatus`.`Yr`
`budgetappropriationstatus`.`OfficeId`
`budgetappropriationstatus`.`Status`
`budgetclosing`.*
`budgetclosing`.`Id`
`budgetclosing`.`ClosingDate`
`budgetclosing`.`ClosedByName`
`budgetdetail`.*
`budgetdetail`.`ID`
`budgetdetail`.`groupid`
`budgetdetail`.`GroupName`
`budgetdetail`.`TypeofBudget`
`budgetdetail`.`BYear`
`budgetdetail`.`DescriptionID`
`budgetdetail`.`Description`
`budgetdetail`.`AppropriationID`
`budgetdetail`.`ACID`
`budgetdetail`.`ACID_Description`
`budgetdetail`.`DepartmentID`
`budgetdetail`.`Jan`
`budgetdetail`.`Feb`
`budgetdetail`.`Mar`
`budgetdetail`.`Apr`
`budgetdetail`.`May`
`budgetdetail`.`Jun`
`budgetdetail`.`Jul`
`budgetdetail`.`Aug`
`budgetdetail`.`Sept`
`budgetdetail`.`Oct`
`budgetdetail`.`Nov`
`budgetdetail`.`Dec`
`budgetdetail_plantilla`.*
`budgetdetail_plantilla`.`ID`
`budgetdetail_plantilla`.`Group`
`budgetdetail_plantilla`.`DescriptionID`
`budgetdetail_plantilla`.`Description`
`budgetdetail_plantilla`.`Positions`
`budgetdetail_plantilla`.`BYear`
`budgetdetail_plantilla`.`ACID`
`budgetdetail_plantilla`.`TypeofBudget`
`budgetdetail_plantilla`.`Jan`
`budgetdetail_plantilla`.`Feb`
`budgetdetail_plantilla`.`Mar`
`budgetdetail_plantilla`.`Apr`
`budgetdetail_plantilla`.`May`
`budgetdetail_plantilla`.`Jun`
`budgetdetail_plantilla`.`Jul`
`budgetdetail_plantilla`.`Aug`
`budgetdetail_plantilla`.`Sept`
`budgetdetail_plantilla`.`Oct`
`budgetdetail_plantilla`.`Nov`
`budgetdetail_plantilla`.`Dec`
`budgetdetail_plantilla`.`Total`
`budgetdetail_plantilla`.`DepartmentID`
`budgetdetail_plantilla`.`SG`
`budgetdetail_plantilla`.`Step`
`budgetdetail_plantilla`.`UID`
`budgetdetail_plantilla`.`PositionID`
`budgetsourcedescription`.*
`budgetsourcedescription`.`ID`
`budgetsourcedescription`.`Description`
`cash_advances`.*
`cash_advances`.`SysPK_CshAdv`
`cash_advances`.`SysFK_Empl_CshAdv`
`cash_advances`.`UserCode_CshAdv`
`cash_advances`.`Name_CshAdv`
`cash_advances`.`DateTrans_CshAdv`
`cash_advances`.`Amount_CshAdv`
`cash_advances`.`Balance_CshAdv`
`cash_advances`.`Terms_CshAdv`
`cash_advances`.`AmortAmount_CshAdv`
`cash_advances`.`Remarks_CshAdv`
`cash_advances`.`Description_CshAdv`
`cash_advances`.`CompanyCode`
`cash_advances`.`ProjectCode`
`cash_advances`.`deductionType`
`cash_advances`.`EMP_ID`
`cashall`.*
`cashall`.`ID`
`cashall`.`JOURNAL_ID`
`cashall`.`DRCR`
`cashliquidation`.*
`cashliquidation`.`CLRFNumber`
`cashliquidation`.`CLEmpName`
`cashliquidation`.`CLProjCode`
`cashliquidation`.`CLProjName`
`cashliquidation`.`CLLocation`
`cashliquidation`.`CLDate`
`cashliquidation`.`CLAmount`
`cashliquidation`.`CLPeriodfrom`
`cashliquidation`.`CLPeriodto`
`cashliquidation`.`CLGrossAmount`
`cashliquidation`.`sss`
`cashliquidation`.`hdmf`
`cashliquidation`.`cassd`
`cashliquidation`.`metrobank`
`cashliquidation`.`bdo`
`cashvoucher_series`.*
`cashvoucher_series`.`id`
`cashvoucher_series`.`JID`
`cashvoucher_series`.`cv`
`cashvoucher_series`.`COMPANY`
`cashvoucher_series`.`YEAR`
`cashvoucher_series`.`TSTAMP`
`cashvoucher_series`.`groupentry`
`casl_liq`.*
`casl_liq`.`ID`
`casl_liq`.`REF_OLD`
`casl_liq`.`OLD_JID`
`casl_liq`.`REF_NEW`
`casl_liq`.`JID`
`casl_liq`.`DATE_LIQ`
`casl_liq`.`EMPID`
`casl_liq`.`MEMO`
`casl_liq`.`AMOUNT`
`casl_liq`.`UID`
`casl_liq`.`status`
`casl_liq`.`CV`
`casl_liq`.`tstamp`
`casl_liq`.`GROUP`
`casl_liq`.`CASL_GUID`
`casl_liq`.`RELASED_ID`
`casl_liq_br`.*
`casl_liq_br`.`ID`
`casl_liq_br`.`JID`
`casl_liq_br`.`CUSTID`
`casl_liq_br`.`ACCOUNTID`
`casl_liq_br`.`SHIPPING`
`casl_liq_br`.`AMOUNT`
`casl_liq_br`.`ORNUM`
`casl_liq_br`.`DATE_PAID`
`casl_liq_br`.`CONTAINER`
`casl_liq_br`.`PROCESSOR`
`casl_liq_br`.`TSTAMP`
`casl_liq_br`.`status`
`casl_liq_br`.`CASL_GUID`
`casl_liq_details`.*
`casl_liq_details`.`id`
`casl_liq_details`.`journal_details_id`
`casl_liq_details`.`TIN`
`casl_liq_details`.`REMARKS`
`casl_liq_details`.`INV_NUM`
`casl_liq_details`.`Suppliername`
`casl_liq_details`.`SUPID`
`casl_liq_details`.`JID`
`casl_liq_details`.`caslID`
`casl_refund_list`.*
`casl_refund_list`.`ID`
`casl_refund_list`.`JID`
`casl_refund_list`.`GROUPS`
`casl_released`.*
`casl_released`.`ID`
`casl_released`.`JID`
`casl_released`.`REF`
`casl_released`.`GUID`
`casl_released`.`DATES`
`casl_released`.`EMPID`
`casl_released`.`MEMOS`
`casl_released`.`AMOUNT`
`casl_released`.`UID`
`casl_released`.`status`
`casl_released`.`tstamp`
`casl_released`.`COMPANYCODE`
`casl_released`.`DEPTCODE`
`casl_released`.`CASH_ACID`
`casl_released`.`FUND_LOC`
`casl_released`.`LOCATION_`
`casl_released`.`PAYEE_ID`
`casl_released`.`NAME_TYPES`
`category`.*
`category`.`ID`
`category`.`ParentID`
`category`.`LBP`
`category`.`Name`
`category`.`Status`
`category`.`Ordering`
`category`.`ExpenseClass`
`cf_description`.*
`cf_description`.`ID`
`cf_description`.`CF_NAME`
`cf_description`.`STATUS`
`cf_description`.`ORDER`
`cf_description`.`TYPE`
`cf_description`.`FLOW`
`check_monitoring`.*
`check_monitoring`.`ID`
`check_monitoring`.`CDATE`
`check_monitoring`.`ARRIVAL`
`check_monitoring`.`PAYEEID`
`check_monitoring`.`CONSIGNEEID`
`check_monitoring`.`CHECK_NUM`
`check_monitoring`.`C_VOUCHER`
`check_monitoring`.`BL`
`check_monitoring`.`PURPOSE_OF_PAYMENT`
`check_monitoring`.`RECEIVEDBY`
`check_monitoring`.`AMOUNT`
`check_monitoring`.`CONTAINER`
`check_monitoring`.`MC_FEE`
`check_monitoring`.`BP`
`check_monitoring`.`STATUS`
`check_monitoring`.`title_id`
`check_monitoring`.`MC_CHECK`
`check_monitoring`.`LOGBY`
`check_monitoring`.`REMOVEDBY`
`check_received_released_stat`.*
`check_received_released_stat`.`ID`
`check_received_released_stat`.`JID`
`check_received_released_stat`.`status`
`check_received_released_stat`.`RELEASED_DATE`
`check_received_released_stat`.`UID`
`check_received_released_stat`.`RECEIVEDBY`
`check_received_released_stat`.`REMARKS`
`check_received_released_stat`.`REFERENCE`
`check_received_released_stat`.`TSTAMP`
`check_received_released_stat`.`CHK_TYPE`
`check_received_released_stat`.`groups`
`checkdefaultsignatories`.*
`checkdefaultsignatories`.`ID`
`checkdefaultsignatories`.`NAMES1`
`checkdefaultsignatories`.`POSITIONS1`
`checkdefaultsignatories`.`NAMES2`
`checkdefaultsignatories`.`POSITIONS2`
`checkingaccountlog`.*
`checkingaccountlog`.`ID`
`checkingaccountlog`.`JID`
`checkingaccountlog`.`ACID`
`checkingaccountlog`.`BANK_NAME`
`checkingaccountlog`.`CHECKNUMBER`
`checkingaccountlog`.`CHECKDATES`
`checkingaccountlog`.`PAYEE`
`checkingaccountlog`.`PAYEEID`
`checkingaccountlog`.`Groups`
`checkingaccountlog`.`USERSID`
`checkingaccountlog`.`CVNUMBER`
`classification_setup`.*
`classification_setup`.`id`
`classification_setup`.`code`
`classification_setup`.`short_description`
`classification_setup`.`full_description`
`classification_setup`.`group`
`classification_setup`.`cash_flow`
`classification_setup`.`type`
`classification_setup`.`status`
`classification_setup`.`OWNERID`
`classification_setup`.`classOrders`
`clearing_cust_advanc_pay`.*
`clearing_cust_advanc_pay`.`ID`
`clearing_cust_advanc_pay`.`CUSTID`
`clearing_cust_advanc_pay`.`CONTAINER`
`clearing_cust_advanc_pay`.`BL`
`clearing_cust_advanc_pay`.`ARRIVAL`
`clearing_cust_advanc_pay`.`AMOUNT`
`clearing_cust_advanc_pay`.`DATEFAX`
`clearing_cust_advanc_pay`.`CHECK_NUM`
`clearing_cust_advanc_pay`.`DATEPAID`
`clearing_cust_advanc_pay`.`TSTAMP`
`clearing_cust_advanc_pay`.`STATUS`
`clearing_cust_advanc_pay`.`CLEARED`
`clearing_cust_advanc_pay`.`REMARKS`
`clearing_cust_advanc_pay`.`JOURNAL_ID`
`clev_deductions`.*
`clev_deductions`.`ID`
`clev_deductions`.`DEDUCIONID`
`clev_deductions`.`ACID`
`clev_deductions`.`AMT`
`clev_deductions`.`JID`
`clev_deductions`.`GID`
`clev_deductions`.`TS`
`clev_deductions`.`JDTL`
`closing_appro`.*
`closing_appro`.`ID`
`closing_appro`.`dateLog`
`closing_appro`.`usercloseEntry`
`closing_appro`.`remarks`
`closing_appro`.`Location`
`closing_appro`.`titleID`
`closing_appro`.`EMPNAME`
`closing_appro`.`Journal_id`
`closing_appro`.`User_syspkID`
`closing_appro`.`Status`
`closing_appro`.`ReopenBy`
`closing_appro`.`datesaved`
`closing_entry`.*
`closing_entry`.`ID`
`closing_entry`.`dateLog`
`closing_entry`.`usercloseEntry`
`closing_entry`.`remarks`
`closing_entry`.`Location`
`closing_entry`.`titleID`
`closing_entry`.`EMPNAME`
`closing_entry`.`Journal_id`
`closing_entry`.`User_syspkID`
`closing_entry`.`Status`
`closing_entry`.`ReopenBy`
`closing_entry`.`datesaved`
`container_monitoring`.*
`container_monitoring`.`ID`
`container_monitoring`.`SHIPPINGID`
`container_monitoring`.`CUSTID`
`container_monitoring`.`CONTAINERNUM`
`container_monitoring`.`BL`
`container_monitoring`.`CONTAINER_DEPO`
`container_monitoring`.`DATE_REC`
`container_monitoring`.`REF_AMOUNT`
`container_monitoring`.`REF_CHECK_NO`
`container_monitoring`.`REF_DATE`
`container_monitoring`.`DET_AMOUNT`
`container_monitoring`.`DET_BILLING`
`container_monitoring`.`CTS_AMOUNT`
`container_monitoring`.`CTS_DATE_PAID`
`container_monitoring`.`CTS_OR`
`container_monitoring`.`ATS_AMOUNT`
`container_monitoring`.`ATS_DATE_PAID`
`container_monitoring`.`ATS_OR`
`container_monitoring`.`DOCD_AMOUNT`
`container_monitoring`.`DOCD_BILLING`
`container_monitoring`.`DOCD_OR`
`container_monitoring`.`CFC_AMOUNT`
`container_monitoring`.`CFC_SOA`
`container_monitoring`.`CFC_CHECK`
`container_monitoring`.`CFC_COLLECTED`
`container_monitoring`.`CFC_COLLECTED_DATE`
`container_monitoring`.`RBTR_AMOUNT`
`container_monitoring`.`RBTR_CHECK`
`container_monitoring`.`RBTR_COLLECTED`
`container_monitoring`.`RBTR_DATE`
`container_monitoring`.`REMARKS`
`container_monitoring`.`TS`
`container_monitoring`.`UID`
`continuingmigration`.*
`continuingmigration`.`Id`
`continuingmigration`.`OfficeCode`
`continuingmigration`.`Office`
`continuingmigration`.`OfficeId`
`continuingmigration`.`SOFID`
`continuingmigration`.`SOF`
`continuingmigration`.`BudgetType`
`continuingmigration`.`SubOfficeCode`
`continuingmigration`.`SubOffice`
`continuingmigration`.`ExpenseClassId`
`continuingmigration`.`ExpDescription`
`continuingmigration`.`ExpCode`
`continuingmigration`.`AccountCode`
`continuingmigration`.`Description`
`continuingmigration`.`Appropriation`
`continuingmigration`.`TotalAllotment`
`continuingmigration`.`AppropriationBalance`
`continuingmigration`.`Obligation`
`continuingmigration`.`UnobligatedBalance`
`continuings`.*
`continuings`.`Id`
`continuings`.`accountType`
`continuings`.`TypeDescription`
`continuings`.`ExpenseClassID`
`continuings`.`OfficeID`
`continuings`.`OfficeCode`
`continuings`.`AccountCode`
`continuings`.`Description`
`continuings`.`Amount`
`cto_budget_account_columns`.*
`cto_budget_account_columns`.`id`
`cto_budget_account_columns`.`accnt_id`
`cto_budget_account_columns`.`col_name`
`cto_budget_account_columns`.`def_val`
`cto_budget_account_columns`.`col_id`
`cto_budget_account_columns`.`col_num`
`cto_budget_account_columns`.`operation`
`cto_budget_account_columns`.`calc_col`
`cto_budget_account_columns`.`data_type`
`cto_budget_account_columns`.`status`
`cto_budget_account_columns_main`.*
`cto_budget_account_columns_main`.`id`
`cto_budget_account_columns_main`.`from_tbl`
`cto_budget_account_columns_main`.`dept_query`
`cto_budget_beg_entry`.*
`cto_budget_beg_entry`.`id`
`cto_budget_beg_entry`.`accnt_id`
`cto_budget_beg_entry`.`dept_id`
`cto_budget_beg_entry`.`year`
`cto_budget_beg_entry`.`app_last_year`
`cto_budget_beg_entry`.`expended_last_year`
`cto_budget_beg_entry`.`app_cur_year`
`cto_budget_beg_entry`.`expended_first_9_month`
`cto_budget_beg_entry`.`anticipated_expenditure`
`cto_budget_beg_entry`.`app_next_year`
`cto_budget_category_none_ppmp`.*
`cto_budget_category_none_ppmp`.`id`
`cto_budget_category_none_ppmp`.`desc`
`cto_budget_mode_pro`.*
`cto_budget_mode_pro`.`id`
`cto_budget_mode_pro`.`mode_pro_desc`
`cto_budget_mode_pro`.`status`
`cto_budget_mode_pro`.`xx`
`cto_budget_none_ppmp`.*
`cto_budget_none_ppmp`.`id`
`cto_budget_none_ppmp`.`budget_year`
`cto_budget_none_ppmp`.`dept_id`
`cto_budget_none_ppmp`.`account_id`
`cto_budget_none_ppmp`.`remarks`
`cto_budget_none_ppmp`.`source_fund`
`cto_budget_none_ppmp`.`status`
`cto_budget_none_ppmp`.`display_detail`
`cto_budget_none_ppmp`.`type`
`cto_budget_none_ppmp`.`date_created`
`cto_budget_none_ppmp`.`charge_dep_id`
`cto_budget_none_ppmp_dtls`.*
`cto_budget_none_ppmp_dtls`.`dtl_id`
`cto_budget_none_ppmp_dtls`.`ledger_type`
`cto_budget_none_ppmp_dtls`.`main_id`
`cto_budget_none_ppmp_dtls`.`trans_id`
`cto_budget_none_ppmp_dtls`.`emp_id`
`cto_budget_none_ppmp_dtls`.`deptid`
`cto_budget_none_ppmp_dtls`.`col1`
`cto_budget_none_ppmp_dtls`.`col2`
`cto_budget_none_ppmp_dtls`.`col3`
`cto_budget_none_ppmp_dtls`.`col4`
`cto_budget_none_ppmp_dtls`.`col5`
`cto_budget_none_ppmp_dtls`.`col6`
`cto_budget_none_ppmp_dtls`.`col7`
`cto_budget_none_ppmp_dtls`.`col8`
`cto_budget_none_ppmp_dtls`.`jan`
`cto_budget_none_ppmp_dtls`.`feb`
`cto_budget_none_ppmp_dtls`.`mar`
`cto_budget_none_ppmp_dtls`.`apr`
`cto_budget_none_ppmp_dtls`.`may`
`cto_budget_none_ppmp_dtls`.`jun`
`cto_budget_none_ppmp_dtls`.`jul`
`cto_budget_none_ppmp_dtls`.`aug`
`cto_budget_none_ppmp_dtls`.`sep`
`cto_budget_none_ppmp_dtls`.`oct`
`cto_budget_none_ppmp_dtls`.`nov`
`cto_budget_none_ppmp_dtls`.`dec`
`cto_budget_none_ppmp_dtls`.`type`
`cto_budget_none_ppmp_dtls`.`util`
`cto_budget_none_ppmp_dtls`.`revision`
`cto_budget_none_ppmp_dtls`.`savedate`
`cto_budget_none_ppmp_dtls`.`status`
`cto_budget_none_ppmp_dtls_temp`.*
`cto_budget_none_ppmp_dtls_temp`.`dtl_id`
`cto_budget_none_ppmp_dtls_temp`.`ledger_type`
`cto_budget_none_ppmp_dtls_temp`.`main_id`
`cto_budget_none_ppmp_dtls_temp`.`trans_id`
`cto_budget_none_ppmp_dtls_temp`.`deptid`
`cto_budget_none_ppmp_dtls_temp`.`emp_id`
`cto_budget_none_ppmp_dtls_temp`.`col1`
`cto_budget_none_ppmp_dtls_temp`.`col2`
`cto_budget_none_ppmp_dtls_temp`.`col3`
`cto_budget_none_ppmp_dtls_temp`.`col4`
`cto_budget_none_ppmp_dtls_temp`.`col5`
`cto_budget_none_ppmp_dtls_temp`.`col6`
`cto_budget_none_ppmp_dtls_temp`.`col7`
`cto_budget_none_ppmp_dtls_temp`.`col8`
`cto_budget_none_ppmp_dtls_temp`.`jan`
`cto_budget_none_ppmp_dtls_temp`.`feb`
`cto_budget_none_ppmp_dtls_temp`.`mar`
`cto_budget_none_ppmp_dtls_temp`.`apr`
`cto_budget_none_ppmp_dtls_temp`.`may`
`cto_budget_none_ppmp_dtls_temp`.`jun`
`cto_budget_none_ppmp_dtls_temp`.`jul`
`cto_budget_none_ppmp_dtls_temp`.`aug`
`cto_budget_none_ppmp_dtls_temp`.`sep`
`cto_budget_none_ppmp_dtls_temp`.`oct`
`cto_budget_none_ppmp_dtls_temp`.`nov`
`cto_budget_none_ppmp_dtls_temp`.`dec`
`cto_budget_none_ppmp_dtls_temp`.`type`
`cto_budget_none_ppmp_dtls_temp`.`revision`
`cto_budget_none_ppmp_dtls_temp`.`util`
`cto_budget_none_ppmp_dtls_temp`.`savedate`
`cto_budget_none_ppmp_dtls_temp`.`status`
`cto_budget_none_ppmp_dtls_temp`.`chk`
`cto_budget_ppmp`.*
`cto_budget_ppmp`.`id`
`cto_budget_ppmp`.`budget_year`
`cto_budget_ppmp`.`dept_id`
`cto_budget_ppmp`.`account_id`
`cto_budget_ppmp`.`remarks`
`cto_budget_ppmp`.`mode_pro`
`cto_budget_ppmp`.`source_fund`
`cto_budget_ppmp`.`Pre_Proc_Conference`
`cto_budget_ppmp`.`Ads_Post_of_IAEB`
`cto_budget_ppmp`.`Pre_bid_Con`
`cto_budget_ppmp`.`Eligibility_Check`
`cto_budget_ppmp`.`Sub_Open_of_Bids`
`cto_budget_ppmp`.`Bid_Evaluation`
`cto_budget_ppmp`.`Post_Qual`
`cto_budget_ppmp`.`Notice_of_Award`
`cto_budget_ppmp`.`Contract_Signing`
`cto_budget_ppmp`.`Notice_to_Proceed`
`cto_budget_ppmp`.`Delivery_Completion`
`cto_budget_ppmp`.`Acceptance_Turnover`
`cto_budget_ppmp`.`status`
`cto_budget_ppmp`.`display_detail`
`cto_budget_ppmp`.`type`
`cto_budget_ppmp`.`date_created`
`cto_budget_ppmp_dtls`.*
`cto_budget_ppmp_dtls`.`dtl_id`
`cto_budget_ppmp_dtls`.`main_id`
`cto_budget_ppmp_dtls`.`item_id`
`cto_budget_ppmp_dtls`.`qty`
`cto_budget_ppmp_dtls`.`unit`
`cto_budget_ppmp_dtls`.`cost`
`cto_budget_ppmp_dtls`.`amont`
`cto_budget_ppmp_dtls`.`remarks`
`cto_budget_ppmp_dtls`.`status`
`cto_budget_ppmp_dtls`.`type`
`cto_budget_ppmp_dtls`.`revision`
`cto_budget_ppmp_dtls`.`01_qty`
`cto_budget_ppmp_dtls`.`01_cost`
`cto_budget_ppmp_dtls`.`01_amt`
`cto_budget_ppmp_dtls`.`02_qty`
`cto_budget_ppmp_dtls`.`02_cost`
`cto_budget_ppmp_dtls`.`02_amt`
`cto_budget_ppmp_dtls`.`03_qty`
`cto_budget_ppmp_dtls`.`03_cost`
`cto_budget_ppmp_dtls`.`03_amt`
`cto_budget_ppmp_dtls`.`04_qty`
`cto_budget_ppmp_dtls`.`04_cost`
`cto_budget_ppmp_dtls`.`04_amt`
`cto_budget_ppmp_dtls`.`05_qty`
`cto_budget_ppmp_dtls`.`05_cost`
`cto_budget_ppmp_dtls`.`05_amt`
`cto_budget_ppmp_dtls`.`06_qty`
`cto_budget_ppmp_dtls`.`06_cost`
`cto_budget_ppmp_dtls`.`06_amt`
`cto_budget_ppmp_dtls`.`07_qty`
`cto_budget_ppmp_dtls`.`07_cost`
`cto_budget_ppmp_dtls`.`07_amt`
`cto_budget_ppmp_dtls`.`08_qty`
`cto_budget_ppmp_dtls`.`08_cost`
`cto_budget_ppmp_dtls`.`08_amt`
`cto_budget_ppmp_dtls`.`09_qty`
`cto_budget_ppmp_dtls`.`09_cost`
`cto_budget_ppmp_dtls`.`09_amt`
`cto_budget_ppmp_dtls`.`10_qty`
`cto_budget_ppmp_dtls`.`10_cost`
`cto_budget_ppmp_dtls`.`10_amt`
`cto_budget_ppmp_dtls`.`11_qty`
`cto_budget_ppmp_dtls`.`11_cost`
`cto_budget_ppmp_dtls`.`11_amt`
`cto_budget_ppmp_dtls`.`12_qty`
`cto_budget_ppmp_dtls`.`12_cost`
`cto_budget_ppmp_dtls`.`12_amt`
`cto_budget_ppmp_dtls`.`savedate`
`cto_budget_ppmp_dtls`.`ISGROUP`
`cto_budget_ppmp_dtls_temp`.*
`cto_budget_ppmp_dtls_temp`.`id`
`cto_budget_ppmp_dtls_temp`.`main_id`
`cto_budget_ppmp_dtls_temp`.`item_id`
`cto_budget_ppmp_dtls_temp`.`qty`
`cto_budget_ppmp_dtls_temp`.`unit`
`cto_budget_ppmp_dtls_temp`.`cost`
`cto_budget_ppmp_dtls_temp`.`amont`
`cto_budget_ppmp_dtls_temp`.`remarks`
`cto_budget_ppmp_dtls_temp`.`status`
`cto_budget_ppmp_dtls_temp`.`type`
`cto_budget_ppmp_dtls_temp`.`revision`
`cto_budget_ppmp_dtls_temp`.`01_qty`
`cto_budget_ppmp_dtls_temp`.`01_cost`
`cto_budget_ppmp_dtls_temp`.`01_amt`
`cto_budget_ppmp_dtls_temp`.`02_qty`
`cto_budget_ppmp_dtls_temp`.`02_cost`
`cto_budget_ppmp_dtls_temp`.`02_amt`
`cto_budget_ppmp_dtls_temp`.`03_qty`
`cto_budget_ppmp_dtls_temp`.`03_cost`
`cto_budget_ppmp_dtls_temp`.`03_amt`
`cto_budget_ppmp_dtls_temp`.`04_qty`
`cto_budget_ppmp_dtls_temp`.`04_cost`
`cto_budget_ppmp_dtls_temp`.`04_amt`
`cto_budget_ppmp_dtls_temp`.`05_qty`
`cto_budget_ppmp_dtls_temp`.`05_cost`
`cto_budget_ppmp_dtls_temp`.`05_amt`
`cto_budget_ppmp_dtls_temp`.`06_qty`
`cto_budget_ppmp_dtls_temp`.`06_cost`
`cto_budget_ppmp_dtls_temp`.`06_amt`
`cto_budget_ppmp_dtls_temp`.`07_qty`
`cto_budget_ppmp_dtls_temp`.`07_cost`
`cto_budget_ppmp_dtls_temp`.`07_amt`
`cto_budget_ppmp_dtls_temp`.`08_qty`
`cto_budget_ppmp_dtls_temp`.`08_cost`
`cto_budget_ppmp_dtls_temp`.`08_amt`
`cto_budget_ppmp_dtls_temp`.`09_qty`
`cto_budget_ppmp_dtls_temp`.`09_cost`
`cto_budget_ppmp_dtls_temp`.`09_amt`
`cto_budget_ppmp_dtls_temp`.`10_qty`
`cto_budget_ppmp_dtls_temp`.`10_cost`
`cto_budget_ppmp_dtls_temp`.`10_amt`
`cto_budget_ppmp_dtls_temp`.`11_qty`
`cto_budget_ppmp_dtls_temp`.`11_cost`
`cto_budget_ppmp_dtls_temp`.`11_amt`
`cto_budget_ppmp_dtls_temp`.`12_qty`
`cto_budget_ppmp_dtls_temp`.`12_cost`
`cto_budget_ppmp_dtls_temp`.`12_amt`
`cto_budget_ppmp_dtls_temp`.`savedate`
`cto_budget_ppmp_dtls_temp`.`chk`
`cto_budget_res_series`.*
`cto_budget_res_series`.`id`
`cto_budget_res_series`.`resolution_num`
`cto_budget_res_series`.`series_num`
`cto_budget_source_fund`.*
`cto_budget_source_fund`.`id`
`cto_budget_source_fund`.`source_fund_desc`
`cto_budget_source_fund`.`status`
`cto_budget_source_fund`.`MainID`
`cto_budget_type`.*
`cto_budget_type`.`id`
`cto_budget_type`.`description`
`cto_budgett_revision_setup`.*
`cto_budgett_revision_setup`.`id`
`cto_budgett_revision_setup`.`desc`
`cto_fund_setup`.*
`cto_fund_setup`.`SysPK_fund_setup`
`cto_fund_setup`.`fund_code`
`cto_fund_setup`.`fund_description`
`cto_fund_setup`.`status`
`cto_transaction_partial_deposit`.*
`cto_transaction_partial_deposit`.`id`
`cto_transaction_partial_deposit`.`ref_no`
`cto_transaction_partial_deposit`.`accntable_prson`
`cto_transaction_partial_deposit`.`receive_by`
`cto_transaction_partial_deposit`.`date`
`cto_transaction_partial_deposit`.`tmestamp`
`cto_transaction_partial_deposit`.`status`
`cto_transaction_partial_deposit_dtl`.*
`cto_transaction_partial_deposit_dtl`.`id`
`cto_transaction_partial_deposit_dtl`.`main_id`
`cto_transaction_partial_deposit_dtl`.`type`
`cto_transaction_partial_deposit_dtl`.`amount`
`cto_transaction_partial_deposit_dtl`.`pieces`
`cto_transaction_partial_deposit_dtl`.`total`
`cust_adv_refund_log`.*
`cust_adv_refund_log`.`ID`
`cust_adv_refund_log`.`DATE`
`cust_adv_refund_log`.`FROM`
`cust_adv_refund_log`.`TO`
`cust_adv_refund_log`.`SUBJECT`
`cust_adv_refund_log`.`MONTH`
`cust_adv_refund_log`.`BILL`
`cust_adv_refund_log`.`CONTAINER`
`cust_adv_refund_log`.`REMARKS`
`cust_adv_refund_log`.`TOTAL_LIQ`
`cust_adv_refund_log`.`ADV`
`cust_adv_refund_log`.`TSTAMP`
`cust_adv_refund_log`.`refund_id`
`customer_setup`.*
`customer_setup`.`SysPKID`
`customer_setup`.`pp_person_code`
`customer_setup`.`application_date`
`customer_setup`.`pp_student_no`
`customer_setup`.`pp_prefix`
`customer_setup`.`pp_lastname`
`customer_setup`.`pp_firstname`
`customer_setup`.`pp_middlename`
`customer_setup`.`pp_suffix`
`customer_setup`.`gender`
`customer_setup`.`dob`
`customer_setup`.`civil_stat`
`customer_setup`.`cellno`
`customer_setup`.`phoneno`
`customer_setup`.`nationality`
`customer_setup`.`religion`
`customer_setup`.`spouseOccupation`
`customer_setup`.`spouse`
`customer_setup`.`mother_name`
`customer_setup`.`mother_cellno`
`customer_setup`.`father_name`
`customer_setup`.`father_cellno`
`customer_setup`.`email_add`
`customer_setup`.`address`
`customer_setup`.`purok_id`
`customer_setup`.`barangay_id`
`customer_setup`.`municipal_id`
`customer_setup`.`province_id`
`customer_setup`.`save_by`
`customer_setup`.`update_by`
`customer_setup`.`cancelled_by`
`customer_setup`.`status`
`customer_setup`.`ts`
`customeradvancedeductionlogs`.*
`customeradvancedeductionlogs`.`ID`
`customeradvancedeductionlogs`.`CID`
`customeradvancedeductionlogs`.`JID`
`customeradvancedeductionlogs`.`Amount`
`customeradvancedeductionlogs`.`Reference_no`
`customeradvancedeductionlogs`.`USERID`
`customeradvances`.*
`customeradvances`.`ID`
`customeradvances`.`CID`
`customeradvances`.`custName`
`customeradvances`.`Amount`
`customeradvances`.`dates`
`customeradvances`.`Businesstype`
`customeradvances`.`Location`
`customeradvances`.`TitleID`
`customeradvanceslog`.*
`customeradvanceslog`.`ID`
`customeradvanceslog`.`CID`
`customeradvanceslog`.`BP`
`customeradvanceslog`.`Amount`
`customeradvanceslog`.`UID`
`customeradvanceslog`.`Remarks`
`customersl_log`.*
`customersl_log`.`ID`
`customersl_log`.`JID`
`customersl_log`.`CID`
`customersl_log`.`REF`
`customersl_log`.`Amount`
`cwip_logs`.*
`cwip_logs`.`ID`
`cwip_logs`.`WIP_NAME`
`cwip_logs`.`WIP_STAT`
`cwip_logs`.`START`
`cwip_logs`.`END`
`cwip_logs`.`ADDRESS`
`cwip_logs`.`REMARKS`
`cwip_logs`.`ts`
`cwip_logs`.`Types`
`cwip_logs`.`OFFICEID`
`cwip_logs`.`contractorid`
`cwip_logs`.`agencyid`
`cwip_logs`.`contract_amount`
`cwip_logs`.`ACIDS`
`debits_actual_deducted`.*
`debits_actual_deducted`.`ID`
`debits_actual_deducted`.`JID`
`debits_actual_deducted`.`AMOUNT`
`debits_actual_deducted`.`STATUS`
`debits_actual_deducted`.`TS`
`debits_actual_deducted`.`GUID`
`defaultbank`.*
`defaultbank`.`ID`
`defaultbank`.`ACID_`
`defaultbank`.`TITLEID`
`defaultbank`.`location`
`defaults_accounts`.*
`defaults_accounts`.`ID`
`defaults_accounts`.`CIB`
`defaults_accounts`.`CASL`
`defaults_accounts`.`CASSD`
`defaults_accounts`.`RECEIVABLE`
`defaults_accounts`.`PAYABLE`
`defaults_accounts`.`PETTY`
`defaults_accounts`.`ADVANCES_FRM_AFF`
`defaults_accounts`.`ADVANCES_TO_AFF`
`defaults_accounts`.`ADVANCES_FRM_CUST`
`defaults_accounts`.`COMPANYID`
`defaults_accounts`.`ADV_TO_SUP`
`defaults_accounts`.`PETTY_CASH_CUSTODIAN`
`defaults_accounts`.`DUE_TO_EMP`
`defaults_accounts`.`OFFICE`
`defaults_accounts`.`DUID`
`defaults_accounts`.`UNDEPOFUND`
`defaults_accounts`.`SRV_INC`
`defaults_accounts`.`RETAINEDEARNINGS`
`defaults_accounts`.`BIRID`
`defaults_accounts`.`INPUTTAX`
`depreciationaccounts`.*
`depreciationaccounts`.`ID`
`depreciationaccounts`.`account_id`
`depreciationaccounts`.`PPEID`
`depreciationaccounts`.`Loc`
`depreciationaccounts`.`TItleID`
`depreciationaccounts`.`accounts`
`depreciationaccounts`.`accumid`
`discount_type`.*
`discount_type`.`id`
`discount_type`.`discount_name`
`discount_type`.`valuex`
`discount_type`.`typex`
`division_setup`.*
`division_setup`.`division_id`
`division_setup`.`division_code`
`division_setup`.`division_name`
`division_setup`.`title_id`
`division_setup`.`division_code1`
`division_setup`.`project_id`
`division_setup`.`status`
`division_setup`.`savedate`
`division_setup`.`userid`
`drivers_profile`.*
`drivers_profile`.`id`
`drivers_profile`.`driver_fullname`
`drivers_profile`.`address`
`drivers_profile`.`contact_no`
`drivers_profile`.`age`
`drivers_profile`.`civil_stat`
`drivers_profile`.`license_no`
`drivers_profile`.`height`
`drivers_profile`.`weight`
`drivers_profile`.`status`
`dummy_table`.*
`dummy_table`.`id`
`dummy_table`.`hour`
`epense_type`.*
`epense_type`.`id`
`epense_type`.`desc`
`epense_type`.`stat`
`expense_item_dtls`.*
`expense_item_dtls`.`id`
`expense_item_dtls`.`exp_id`
`expense_item_dtls`.`itm_id`
`expense_item_dtls`.`qty`
`expense_item_dtls`.`price`
`expense_item_dtls`.`selling_price`
`expense_main`.*
`expense_main`.`id`
`expense_main`.`ref_no`
`expense_main`.`trans_date`
`expense_main`.`trans_no`
`expense_main`.`type`
`expense_main`.`ref_id`
`expense_main`.`total_amount`
`expense_main`.`ts`
`expense_main`.`status`
`expense_main`.`branch_id`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`hide_amount`.*
`hide_amount`.`id`
`incomesource`.*
`incomesource`.`ID`
`incomesource`.`DescriptionID1`
`incomesource`.`Description1`
`incomesource`.`Description2`
`incomesource`.`IncomeType`
`incomesource`.`FundId`
`incomesource`.`Status`
`incomesource`.`Amount`
`incomesource`.`date_source`
`installment_provider_setup`.*
`installment_provider_setup`.`SysPKID`
`installment_provider_setup`.`application_date`
`installment_provider_setup`.`pp_no`
`installment_provider_setup`.`name`
`installment_provider_setup`.`cellno`
`installment_provider_setup`.`phoneno`
`installment_provider_setup`.`email_add`
`installment_provider_setup`.`address`
`installment_provider_setup`.`save_by`
`installment_provider_setup`.`update_by`
`installment_provider_setup`.`cancelled_by`
`installment_provider_setup`.`status`
`installment_provider_setup`.`ts`
`inventory_master`.*
`inventory_master`.`id`
`inventory_master`.`transID`
`inventory_master`.`transDtlID`
`inventory_master`.`transName`
`inventory_master`.`transNum`
`inventory_master`.`itemid`
`inventory_master`.`io`
`inventory_master`.`qty`
`inventory_master`.`unitcost`
`inventory_master`.`imeiNo`
`inventory_master`.`branchid`
`inventory_master`.`status`
`inventory_master`.`guid`
`inventory_master`.`ts`
`inventory_transfer`.*
`inventory_transfer`.`ID`
`inventory_transfer`.`trans_no`
`inventory_transfer`.`trans_date`
`inventory_transfer`.`ref_no`
`inventory_transfer`.`from_Id`
`inventory_transfer`.`to_Id`
`inventory_transfer`.`status`
`inventory_transfer`.`created`
`inventory_transfer`.`created_by`
`lbp2_programappropriation`.*
`lbp2_programappropriation`.`ID`
`lbp2_programappropriation`.`FUNDID`
`lbp2_programappropriation`.`FundName`
`lbp2_programappropriation`.`LBPType`
`lbp2_programappropriation`.`CategoryId`
`lbp2_programappropriation`.`Category`
`lbp2_programappropriation`.`CategoryOrder`
`lbp2_programappropriation`.`SubCategoryID`
`lbp2_programappropriation`.`SubCategory`
`lbp2_programappropriation`.`SubCategoryOrder`
`lbp2_programappropriation`.`UnderSubID`
`lbp2_programappropriation`.`UnderSubName`
`lbp2_programappropriation`.`UnderSubOrder`
`lbp2_programappropriation`.`OfficeID`
`lbp2_programappropriation`.`OfficeName`
`lbp2_programappropriation`.`AccountId`
`lbp2_programappropriation`.`Account_Code`
`lbp2_programappropriation`.`AccountName`
`lbp2_programappropriation`.`UID`
`lbp2_programappropriation`.`ts`
`lbp2_programappropriation`.`Ordering`
`lbp2_programappropriation`.`byear`
`lbp2_programappropriation`.`expenseClass`
`lbp2_programappropriation`.`Description`
`lbp2_programappropriation`.`aCode`
`lbp2_programappropriation`.`Appropriation`
`lbp2_programappropriationx`.*
`lbp2_programappropriationx`.`ID`
`lbp2_programappropriationx`.`FUNDID`
`lbp2_programappropriationx`.`FundName`
`lbp2_programappropriationx`.`LBPType`
`lbp2_programappropriationx`.`CategoryId`
`lbp2_programappropriationx`.`Category`
`lbp2_programappropriationx`.`CategoryOrder`
`lbp2_programappropriationx`.`SubCategoryID`
`lbp2_programappropriationx`.`SubCategory`
`lbp2_programappropriationx`.`SubCategoryOrder`
`lbp2_programappropriationx`.`UnderSubID`
`lbp2_programappropriationx`.`UnderSubName`
`lbp2_programappropriationx`.`UnderSubOrder`
`lbp2_programappropriationx`.`OfficeID`
`lbp2_programappropriationx`.`OfficeName`
`lbp2_programappropriationx`.`AccountId`
`lbp2_programappropriationx`.`Account_Code`
`lbp2_programappropriationx`.`AccountName`
`lbp2_programappropriationx`.`UID`
`lbp2_programappropriationx`.`ts`
`lbp2_programappropriationx`.`Ordering`
`lbp2_programappropriationx`.`byear`
`lbp2_programappropriationx`.`expenseClass`
`lbp2_programappropriationx`.`Description`
`lbp2_programappropriationx`.`aCode`
`lbp2_programappropriationx`.`Appropriation`
`main_fund_account`.*
`main_fund_account`.`Id`
`main_fund_account`.`Description`
`main_fund_account_yearly`.*
`main_fund_account_yearly`.`Id`
`main_fund_account_yearly`.`MainId`
`main_fund_account_yearly`.`Description`
`main_fund_account_yearly`.`Year`
`main_fund_account_yearly`.`Budget`
`main_fund_account_yearly`.`Status`
`mapper`.*
`mapper`.`ID`
`mapper`.`agefrom`
`mapper`.`ageto`
`mapper`.`scorefrom`
`mapper`.`scoreto`
`migrationdata`.*
`migrationdata`.`Id`
`migrationdata`.`RECODE`
`migrationdata`.`TypeDescription`
`migrationdata`.`ExpenseClassID`
`migrationdata`.`OfficeID`
`migrationdata`.`OfficeCode`
`migrationdata`.`Office`
`migrationdata`.`Codes`
`migrationdata`.`Description`
`migrationdata`.`Appropriation`
`migrationdata`.`TotalAllotment`
`migrationdata`.`Obligation`
`migrationdata`.`isContinuing`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`obr`.*
`obr`.`ID`
`obr`.`OBRDate`
`obr`.`OBRNum`
`obr`.`Mnth`
`obr`.`Byear`
`obr`.`Payee`
`obr`.`Remarks`
`obr`.`DepartmentName`
`obr`.`DepartmentID`
`obr`.`Address`
`obr`.`A_ChargesToAppropriation`
`obr`.`A_SupportingDocument`
`obr`.`B_ExistenceofAvailableAppropriation`
`obr`.`A_CertifiedNameID`
`obr`.`A_CertifiedName`
`obr`.`A_Position`
`obr`.`A_Date`
`obr`.`B_CertifiedNameID`
`obr`.`B_CertifiedName`
`obr`.`B_Position`
`obr`.`B_Date`
`obr`.`Amount`
`obr`.`SourceofFund`
`obr`.`UID`
`obr`.`FundId`
`obr`.`poid`
`obr`.`ponum`
`obr`.`ProjectId`
`obr`.`ProjectRegId`
`obr`.`PowId`
`obr`.`ProjectName`
`obr`.`PowNo`
`obr`.`reference`
`obr`.`CancelledReason`
`obr`.`CancelledByID`
`obr`.`Status`
`obr`.`TS`
`obr`.`IsContinuing`
`obr`.`isPosted`
`obr_pr_approval`.*
`obr_pr_approval`.`ID`
`obr_pr_approval`.`Fund`
`obr_pr_approval`.`Appropriation`
`obr_pr_approval`.`AccountNum`
`obr_pr_approval`.`Allotment`
`obr_pr_approval`.`BalancePrevious`
`obr_pr_approval`.`MinusDisbursement`
`obr_pr_approval`.`BalancePresent`
`obr_pr_approval`.`VerifiedByID`
`obr_pr_approval`.`VerifiedByName`
`obr_pr_approval`.`Dates`
`obr_pr_approval`.`ActionTaken`
`obr_pr_approval`.`Signatory`
`obr_pr_approval`.`SignatoryID`
`obr_pr_approval`.`Positions`
`obr_pr_approval`.`TS`
`obr_pr_approval`.`PRID`
`obr_pr_approval`.`Status`
`obrdetail`.*
`obrdetail`.`ID`
`obrdetail`.`OBRID`
`obrdetail`.`AppropriationID`
`obrdetail`.`ACID`
`obrdetail`.`RespCode`
`obrdetail`.`RespID`
`obrdetail`.`AccountCode`
`obrdetail`.`AccountName`
`obrdetail`.`FPP`
`obrdetail`.`Amount`
`obrdetail`.`OBR_STAT`
`obrsignatoryentity`.*
`obrsignatoryentity`.`ID`
`obrsignatoryentity`.`DepartmentId`
`obrsignatoryentity`.`Types`
`obrsignatoryentity`.`EmployeeId`
`obrsignatoryentity`.`FullName`
`obrsignatoryentity`.`Position`
`otherdeductions_jo`.*
`otherdeductions_jo`.`OD_ID`
`otherdeductions_jo`.`OD_Name`
`otherdeductions_jo`.`OD_PriorityNo`
`otherdeductions_jo`.`OD_Status`
`otherdeductions_jo`.`OD_DateSaved`
`otherdeductions_jo`.`Deduction_Type`
`otherdeductions_jo`.`OD_AccountId`
`otherdeductions_jo`.`OD_PayeeId`
`pap_sector`.*
`pap_sector`.`ID`
`pap_sector`.`Name`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`payee`.*
`payee`.`ID`
`payee`.`PayeeName`
`payee`.`Status`
`payment_mode_setup`.*
`payment_mode_setup`.`id`
`payment_mode_setup`.`reference_no`
`payment_mode_setup`.`description`
`payment_mode_setup`.`remarks`
`payment_mode_setup`.`application_date`
`payment_mode_setup`.`status`
`pi_iventory_dtls`.*
`pi_iventory_dtls`.`id`
`pi_iventory_dtls`.`itm_id`
`pi_iventory_dtls`.`date`
`pi_iventory_dtls`.`qty`
`pi_iventory_dtls`.`branch_id`
`pi_iventory_main`.*
`pi_iventory_main`.`id`
`pi_iventory_main`.`date`
`pi_iventory_main`.`status`
`pmhistory`.*
`pmhistory`.`ID`
`pmhistory`.`AppropriationId`
`pmhistory`.`Yr`
`pmhistory`.`Description`
`pmhistory`.`userFullName`
`positions`.*
`positions`.`ID`
`positions`.`DeptID`
`positions`.`DeptName`
`positions`.`DisplayName`
`positions`.`PositionName`
`positions`.`TS`
`ppmp`.*
`ppmp`.`ID`
`ppmp`.`SOFID`
`ppmp`.`SOFDescription`
`ppmp`.`AccountID`
`ppmp`.`Account`
`ppmp`.`APPID`
`ppmp`.`DEPID`
`ppmp`.`DepartmentName`
`ppmp`.`YR`
`ppmp`.`ItemID`
`ppmp`.`ItemDescription`
`ppmp`.`Qty`
`ppmp`.`UoM`
`ppmp`.`Cost`
`ppmp`.`TotalCost`
`ppmp`.`ModeofProc`
`ppmp`.`Jan`
`ppmp`.`Feb`
`ppmp`.`mar`
`ppmp`.`Apr`
`ppmp`.`may`
`ppmp`.`Jun`
`ppmp`.`Jul`
`ppmp`.`Aug`
`ppmp`.`Sept`
`ppmp`.`Oct_`
`ppmp`.`Nov`
`ppmp`.`Dec_`
`ppmp`.`JanAmt`
`ppmp`.`FebAmt`
`ppmp`.`MarAmt`
`ppmp`.`AprAmt`
`ppmp`.`MayAmt`
`ppmp`.`JunAmt`
`ppmp`.`JulAmt`
`ppmp`.`AugAmt`
`ppmp`.`SeptAmt`
`ppmp`.`OctAmt`
`ppmp`.`NovAmt`
`ppmp`.`DecAmt`
`ppmp`.`UID`
`ppmp`.`ts`
`ppmp`.`ModeofEntry`
`projectmilestone`.*
`projectmilestone`.`id`
`projectmilestone`.`description`
`projectmilestone`.`isComplete`
`projectmilestone`.`projId`
`projectmilestone`.`Status`
`projectmilestone`.`orders`
`re_class`.*
`re_class`.`ID`
`re_class`.`SOFID`
`re_class`.`ParentID`
`re_class`.`Description`
`re_class`.`ShortName`
`re_class`.`ClassOrder`
`re_class`.`Types`
`re_class`.`Level`
`realignment`.*
`realignment`.`ID`
`realignment`.`BatchId`
`realignment`.`AppropriationId`
`realignment`.`AccountName`
`realignment`.`AccountCode`
`realignment`.`ResNo`
`realignment`.`ResDate`
`realignment`.`TransDate`
`realignment`.`Reference`
`realignment`.`BYear`
`realignment`.`OfficeID`
`realignment`.`OfficeName`
`realignment`.`FundId`
`realignment`.`FundName`
`realignment`.`ExpenseClassId`
`realignment`.`ExpenseClass`
`realignment`.`Amount`
`realignment`.`Remarks`
`realignment`.`User`
`realignment`.`Status`
`realignmentsource`.*
`realignmentsource`.`ID`
`realignmentsource`.`BatchId`
`realignmentsource`.`AppropriationId`
`realignmentsource`.`AccountName`
`realignmentsource`.`AccountCode`
`realignmentsource`.`ResNo`
`realignmentsource`.`ResDate`
`realignmentsource`.`TransDate`
`realignmentsource`.`Reference`
`realignmentsource`.`BYear`
`realignmentsource`.`OfficeID`
`realignmentsource`.`OfficeName`
`realignmentsource`.`FundId`
`realignmentsource`.`FundName`
`realignmentsource`.`ExpenseClassId`
`realignmentsource`.`ExpenseClass`
`realignmentsource`.`Amount`
`realignmentsource`.`Remarks`
`realignmentsource`.`User`
`realignmentsource`.`Status`
`realignmentsource`.`LessFromAllotment`
`realignmentsource`.`LessFromAppropriation`
`receiving_item`.*
`receiving_item`.`id`
`receiving_item`.`ref_no`
`receiving_item`.`trans_date`
`receiving_item`.`supplier_id`
`receiving_item`.`received_date`
`receiving_item`.`invoice_number`
`receiving_item`.`total_amount`
`receiving_item`.`ts`
`receiving_item`.`stats`
`receiving_item`.`branch_id`
`receiving_item_dtls`.*
`receiving_item_dtls`.`id`
`receiving_item_dtls`.`rev_id`
`receiving_item_dtls`.`itm_id`
`receiving_item_dtls`.`qty`
`receiving_item_dtls`.`price`
`receiving_item_dtls`.`selling_price`
`remittance_beg`.*
`remittance_beg`.`id`
`remittance_beg`.`sales_amount`
`remittance_beg`.`cashier_id`
`remittance_beg`.`ref_no`
`remittance_beg`.`drawer_amount`
`remittance_beg`.`cashonhand`
`remittance_beg`.`one_thousand`
`remittance_beg`.`five_hundred`
`remittance_beg`.`two_hundred`
`remittance_beg`.`one_hundred`
`remittance_beg`.`fifty`
`remittance_beg`.`twenty`
`remittance_beg`.`ten`
`remittance_beg`.`five`
`remittance_beg`.`one`
`remittance_beg`.`cent`
`remittance_beg`.`total`
`remittance_beg`.`overage_shortage`
`remittance_beg`.`status`
`remittance_beg`.`ts`
`remittance_main`.*
`remittance_main`.`id`
`remittance_main`.`sales_amount`
`remittance_main`.`cashier_id`
`remittance_main`.`ref_no`
`remittance_main`.`drawer_amount`
`remittance_main`.`cashonhand`
`remittance_main`.`one_thousand`
`remittance_main`.`five_hundred`
`remittance_main`.`two_hundred`
`remittance_main`.`one_hundred`
`remittance_main`.`fifty`
`remittance_main`.`twenty`
`remittance_main`.`ten`
`remittance_main`.`five`
`remittance_main`.`one`
`remittance_main`.`cent`
`remittance_main`.`total`
`remittance_main`.`overage_shortage`
`remittance_main`.`status`
`remittance_main`.`ts`
`reversal`.*
`reversal`.`ID`
`reversal`.`BatchId`
`reversal`.`TransDate`
`reversal`.`Reference`
`reversal`.`BYear`
`reversal`.`OfficeID`
`reversal`.`OfficeName`
`reversal`.`FundId`
`reversal`.`FundName`
`reversal`.`ExpenseClassName`
`reversal`.`ExpenseClassId`
`reversal`.`AppropriationId`
`reversal`.`AccountName`
`reversal`.`AccountCode`
`reversal`.`Appropriation`
`reversal`.`Balance`
`reversal`.`Reversal`
`reversal`.`Remarks`
`reversal`.`User`
`reversal`.`Status`
`sales_channel`.*
`sales_channel`.`id`
`sales_channel`.`description`
`sales_channel_setup`.*
`sales_channel_setup`.`id`
`sales_channel_setup`.`reference_no`
`sales_channel_setup`.`description`
`sales_channel_setup`.`remarks`
`sales_channel_setup`.`application_date`
`sales_channel_setup`.`status`
`sales_details`.*
`sales_details`.`id`
`sales_details`.`sales_id`
`sales_details`.`itm_id`
`sales_details`.`qty`
`sales_details`.`price`
`sales_details`.`charges`
`sales_details`.`charge_fee`
`sales_details`.`item_status`
`sales_details`.`remarks`
`sales_main`.*
`sales_main`.`id`
`sales_main`.`ref_no`
`sales_main`.`priority_num`
`sales_main`.`trans_date`
`sales_main`.`reservation_date`
`sales_main`.`customer_id`
`sales_main`.`customer_name`
`sales_main`.`payment_mode`
`sales_main`.`downpayment`
`sales_main`.`warranty`
`sales_main`.`trans_type`
`sales_main`.`table_id`
`sales_main`.`total_amount`
`sales_main`.`ts`
`sales_main`.`stat`
`sales_main`.`reservation`
`sales_main`.`discountType`
`sales_main`.`IDtype`
`sales_main`.`ID_num`
`sales_main`.`Cutting_fee`
`sales_main`.`del_Fee`
`sales_main`.`discount_amount`
`sales_main`.`total_payable`
`sales_main`.`cashpaid`
`sales_main`.`amount_paid`
`sales_main`.`uid`
`sales_main`.`person`
`sales_main`.`senior`
`sales_main`.`charge_to_owner`
`sales_main`.`change`
`sales_main`.`remarks`
`sales_main`.`remit_id`
`sales_main`.`cancelled_by`
`sales_main`.`branch_id`
`sales_main`.`entry_type`
`sales_payment`.*
`sales_payment`.`id`
`sales_payment`.`sales_id`
`sales_payment`.`total_amount`
`sales_payment`.`discountType`
`sales_payment`.`discount_amount`
`sales_payment`.`tableName`
`sales_payment`.`total_payable`
`sales_payment`.`amount_paid`
`sales_payment`.`change`
`sales_payment`.`ts`
`sales_payment`.`stats`
`sales_status`.*
`sales_status`.`id`
`sales_status`.`sales_id`
`sales_status`.`statusDescription`
`sales_status`.`ts`
`sales_table`.*
`sales_table`.`id`
`sales_table`.`tbl_name`
`sales_table`.`statx`
`sales_table`.`used`
`sectors`.*
`sectors`.`ID`
`sectors`.`Name`
`sef_budget`.*
`sef_budget`.`ID`
`sef_budget`.`SOF`
`sef_budget`.`AddRptTax`
`sef_budget`.`AddUnAppropriated`
`sef_budget`.`TotalEstimate`
`sef_budget`.`LessContinuing`
`sef_budget`.`NetAmount`
`sef_budget`.`BudgetType`
`sef_budget`.`Category`
`sef_budget`.`CategoryID`
`sef_budget`.`CategoryOrder`
`sef_budget`.`SubCategory`
`sef_budget`.`SubCategoryID`
`sef_budget`.`SubCategoryOrder`
`sef_budget`.`UnderSubName`
`sef_budget`.`UnderSubID`
`sef_budget`.`UnderSubOrder`
`sef_budget`.`BYear`
`sef_budget`.`DescriptionID`
`sef_budget`.`Description`
`sef_budget`.`Personal`
`sef_budget`.`maintenance`
`sef_budget`.`CO`
`sef_budget`.`FinancialExpenses`
`sef_budget`.`Total`
`sef_budget`.`UID`
`sef_budget`.`TS`
`sef_budget`.`Status`
`sef_budget`.`SG`
`sef_budget`.`Step`
`sef_budget`.`ApprovalStatus`
`sef_utilization`.*
`sef_utilization`.`ID`
`sef_utilization`.`ExpClass`
`sef_utilization`.`BudgetType`
`sef_utilization`.`CategoryID`
`sef_utilization`.`Category`
`sef_utilization`.`CategoryOrder`
`sef_utilization`.`SubCategoryID`
`sef_utilization`.`SubCategory`
`sef_utilization`.`SubCategoryOrder`
`sef_utilization`.`UnderSubID`
`sef_utilization`.`UnderSubName`
`sef_utilization`.`UnderSubOrder`
`sef_utilization`.`BYear`
`sef_utilization`.`DescriptionID`
`sef_utilization`.`Description`
`sef_utilization`.`Amount`
`sef_utilization`.`Jan`
`sef_utilization`.`Feb`
`sef_utilization`.`Mar`
`sef_utilization`.`Apr`
`sef_utilization`.`May`
`sef_utilization`.`Jun`
`sef_utilization`.`Jul`
`sef_utilization`.`Aug`
`sef_utilization`.`Sep`
`sef_utilization`.`Oct_`
`sef_utilization`.`Nov`
`sef_utilization`.`Dec_`
`sef_utilization`.`UID`
`sef_utilization`.`TS`
`sef_utilization`.`Status`
`sef_utilizationbeginning`.*
`sef_utilizationbeginning`.`ID`
`sef_utilizationbeginning`.`ExpClass`
`sef_utilizationbeginning`.`BudgetType`
`sef_utilizationbeginning`.`CategoryID`
`sef_utilizationbeginning`.`Category`
`sef_utilizationbeginning`.`CategoryOrder`
`sef_utilizationbeginning`.`SubCategoryID`
`sef_utilizationbeginning`.`SubCategory`
`sef_utilizationbeginning`.`SubCategoryOrder`
`sef_utilizationbeginning`.`UnderSubID`
`sef_utilizationbeginning`.`UnderSubName`
`sef_utilizationbeginning`.`UnderSubOrder`
`sef_utilizationbeginning`.`BYear`
`sef_utilizationbeginning`.`DescriptionID`
`sef_utilizationbeginning`.`Description`
`sef_utilizationbeginning`.`Amount`
`sef_utilizationbeginning`.`Jan`
`sef_utilizationbeginning`.`Feb`
`sef_utilizationbeginning`.`Mar`
`sef_utilizationbeginning`.`Apr`
`sef_utilizationbeginning`.`May`
`sef_utilizationbeginning`.`Jun`
`sef_utilizationbeginning`.`Jul`
`sef_utilizationbeginning`.`Aug`
`sef_utilizationbeginning`.`Sep`
`sef_utilizationbeginning`.`Oct_`
`sef_utilizationbeginning`.`Nov`
`sef_utilizationbeginning`.`Dec_`
`sef_utilizationbeginning`.`UID`
`sef_utilizationbeginning`.`TS`
`sef_utilizationbeginning`.`Status`
`sefmodel`.*
`sefmodel`.`ID`
`sefmodel`.`G1`
`sefmodel`.`G2`
`sefmodel`.`G3`
`sefmodel`.`BYEAR`
`sefmodel`.`OFFICECODE`
`sefmodel`.`OFFICE`
`sefmodel`.`CODE`
`sefmodel`.`DESCRIPTION`
`sefmodel`.`APPROPRIATION`
`sefmodel`.`TOTALALLOTMENT`
`sefmodel`.`APPROPRIATIONBALANCE`
`sefmodel`.`OBLIGATION`
`sefmodel`.`UNOBLIGATEDBALANCE`
`sefmodel`.`isContinuing`
`sefmodel`.`DeptId`
`sefmodel`.`SheetName`
`sefprogramdefault`.*
`sefprogramdefault`.`ID`
`sefprogramdefault`.`LBPType`
`sefprogramdefault`.`CategoryId`
`sefprogramdefault`.`Category`
`sefprogramdefault`.`CategoryOrder`
`sefprogramdefault`.`SubCategoryID`
`sefprogramdefault`.`SubCategory`
`sefprogramdefault`.`SubCategoryOrder`
`sefprogramdefault`.`UnderSubID`
`sefprogramdefault`.`UnderSubName`
`sefprogramdefault`.`UnderSubOrder`
`sefprogramdefault`.`OfficeID`
`sefprogramdefault`.`OfficeName`
`sefprogramdefault`.`Description`
`sefprogramdefault`.`UID`
`sefprogramdefault`.`ts`
`sefprogramdefault`.`Ordering`
`sefprogramdefault`.`FUNDID`
`sefprogramdefault`.`FUNDNAME`
`semester`.*
`semester`.`ID`
`semester`.`Description`
`semester`.`FromDate`
`semester`.`ToDate`
`settings`.*
`settings`.`ID`
`settings`.`ParentID`
`settings`.`Description`
`settings`.`Status`
`settings`.`TValue`
`setup_formtype`.*
`setup_formtype`.`id`
`setup_formtype`.`type`
`setup_formtype`.`status`
`setup_formtype`.`form_id`
`setup_item`.*
`setup_item`.`id`
`setup_item`.`thumPath`
`setup_item`.`imagePath`
`setup_item`.`ref_no`
`setup_item`.`itemName`
`setup_item`.`forKitchen`
`setup_item`.`forInvent`
`setup_item`.`shwMenu`
`setup_item`.`itemDescription`
`setup_item`.`price`
`setup_item`.`uom`
`setup_item`.`commision`
`setup_item`.`category_id`
`setup_item`.`item_group`
`setup_item`.`reorder_lvl`
`setup_item`.`stat`
`setup_item`.`ts`
`setup_item`.`cancelled_by`
`setup_item`.`main_id`
`setup_item`.`item_stat`
`setup_item`.`last_purchase_price`
`setup_item`.`branch_id`
`setup_item`.`withCommsn`
`setup_item_category`.*
`setup_item_category`.`id`
`setup_item_category`.`category_name`
`setup_item_category`.`stat`
`setup_item_category`.`ts`
`setup_item_category`.`cancelled_by`
`setup_item_category`.`sortby`
`setup_item_grouping`.*
`setup_item_grouping`.`id`
`setup_item_grouping`.`main_id`
`setup_item_grouping`.`itm_id`
`signatory`.*
`signatory`.`ID`
`signatory`.`_Type`
`signatory`.`Name`
`signatory`.`_Position`
`signatory_table`.*
`signatory_table`.`id`
`signatory_table`.`Signatory_desc`
`signatory_table`.`stat`
`signatoryentity`.*
`signatoryentity`.`ID`
`signatoryentity`.`FullName`
`signatoryentity`.`Position`
`signatoryentity`.`SigStatus`
`signatoryentity`.`DeptID`
`spa_services`.*
`spa_services`.`id`
`spa_services`.`Name`
`sub_classification_setup`.*
`sub_classification_setup`.`sub_classification_id`
`sub_classification_setup`.`sub_classification_name`
`sub_classification_setup`.`sub_subclass_id`
`sub_classification_setup`.`class_id`
`sub_classification_setup`.`sub_classification_code`
`sub_classification_setup`.`Subclassorders`
`sub_classification_setup`.`OWNERID`
`subcategory`.*
`subcategory`.`ID`
`subcategory`.`LBP`
`subcategory`.`CategoryID`
`subcategory`.`CategoryName`
`subcategory`.`Name`
`subcategory`.`ShortName`
`subcategory`.`Status`
`subcategory`.`Ordering`
`subcategory`.`ExpenseID`
`subsubcategory`.*
`subsubcategory`.`ID`
`subsubcategory`.`LBP`
`subsubcategory`.`CategoryID`
`subsubcategory`.`CategoryName`
`subsubcategory`.`SubCategoryID`
`subsubcategory`.`SubCategoryName`
`subsubcategory`.`Name`
`subsubcategory`.`Status`
`subsubcategory`.`Ordering`
`supplemental`.*
`supplemental`.`ID`
`supplemental`.`BatchId`
`supplemental`.`AppropriationId`
`supplemental`.`Account`
`supplemental`.`Code`
`supplemental`.`SortBy`
`supplemental`.`TransDate`
`supplemental`.`Reference`
`supplemental`.`BYear`
`supplemental`.`OfficeID`
`supplemental`.`OfficeName`
`supplemental`.`FundId`
`supplemental`.`FundName`
`supplemental`.`ExpenseClassId`
`supplemental`.`ExpenseClass`
`supplemental`.`Amount`
`supplemental`.`Remarks`
`supplemental`.`User`
`supplemental`.`Status`
`supplemental`.`OrdinanceNo`
`supplemental`.`OrdinanceDate`
`supplementalsources`.*
`supplementalsources`.`ID`
`supplementalsources`.`BatchId`
`supplementalsources`.`AppropriationId`
`supplementalsources`.`Account`
`supplementalsources`.`Code`
`supplementalsources`.`SortBy`
`supplementalsources`.`TransDate`
`supplementalsources`.`Reference`
`supplementalsources`.`BYear`
`supplementalsources`.`OfficeID`
`supplementalsources`.`OfficeName`
`supplementalsources`.`FundId`
`supplementalsources`.`FundName`
`supplementalsources`.`ExpenseClassId`
`supplementalsources`.`ExpenseClass`
`supplementalsources`.`Amount`
`supplementalsources`.`Remarks`
`supplementalsources`.`User`
`supplementalsources`.`Status`
`supplementalsources`.`OrdinanceNo`
`supplementalsources`.`OrdinanceDate`
`supplier_setup`.*
`supplier_setup`.`id`
`supplier_setup`.`reference_no`
`supplier_setup`.`supplier_name`
`supplier_setup`.`supplier_address`
`supplier_setup`.`application_date`
`supplier_setup`.`status`
`table_reservation`.*
`table_reservation`.`id`
`table_reservation`.`customer_name`
`table_reservation`.`table_no`
`table_reservation`.`ref_no`
`table_reservation`.`res_date`
`table_reservation`.`res_time`
`table_reservation`.`ts`
`table_reservation`.`res_status`
`table_reservation`.`status`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`mobile`
`users`.`approved`
`users`.`admin`
`users`.`cancel`
`users`.`branch_id`
`users`.`ts`
`wfp`.*
`wfp`.`ID`
`wfp`.`BatchGUID`
`wfp`.`budgetYear`
`wfp`.`DepartmentId`
`wfp`.`SectorId`
`wfp`.`Category`
`wfp`.`SubCategory`
`wfp`.`PPA`
`wfp`.`RespPerson`
`wfp`.`Appropriation`
`wfp`.`Utilization`
`wfp`.`Proposed`
`wfp`.`Particulars`
`wfp`.`ExpenseClassId`
`wfp`.`FundingSourceId`
`wfp`.`Output`
`wfp`.`Outcome`
`wfp`.`Target`
`wfp`.`Accomplishment`
`wfp`.`Status`
`wfp`.`ItemOrder`
`_columns`.*
`_columns`.`id`
`_columns`.`column_name`
`_columns`.`display_col`
`_columns`.`status`
`_columns`.`type`
`_columns`.`liquidate`
`accountbudget`.*
`accountbudget`.`ID`
`accountbudget`.`ParentId`
`accountbudget`.`AppropriationID`
`accountbudget`.`DepartmentId`
`accountbudget`.`SOFID`
`accountbudget`.`BYear`
`accountbudget`.`Description1`
`accountbudget`.`Description2`
`accountbudget`.`Amount`
`accountbudget`.`Amount2`
`accountbudget`.`Amount3`
`accountbudget`.`AllotmentReleased`
`accountbudget`.`SupplementalAmt`
`accountbudget`.`RealignmentAmt`
`accountbudget`.`Expense_Class_id`
`accountbudget`.`Expense_Class`
`accountbudget`.`Status`
`accountbudget`.`SOF`
`accountbudget`.`Category`
`accountbudget`.`CategoryID`
`accountbudget`.`CategoryOrder`
`accountbudget`.`SubCategory`
`accountbudget`.`SubCategoryID`
`accountbudget`.`SubCategoryOrder`
`accountbudget`.`UnderSubName`
`accountbudget`.`UnderSubID`
`accountbudget`.`UnderSubOrder`
`accountbudget`.`DescriptionID2`
`accountbudget`.`DescriptionID1`
`accountbudget`.`isContinuing`
`accountbudget`.`UID`
`accountbudget`.`TS`
`accountbudget`.`ApprovalStatus`
`accountbudget`.`StartDate`
`accountbudget`.`EndDate`
`accountbudget`.`WFPID`
`accountbudget`.`BudgetType`
`accountbudget`.`ORNo`
`accountbudget`.`ProjectName`
`accountbudget`.`projectId`
`accountbudget`.`Purposed`
`accountbudget`.`SheetName`
`accountbudget`.`devremarks`
`accountbudget_copy`.*
`accountbudget_copy`.`ID`
`accountbudget_copy`.`ParentId`
`accountbudget_copy`.`AppropriationID`
`accountbudget_copy`.`DepartmentId`
`accountbudget_copy`.`SOFID`
`accountbudget_copy`.`BYear`
`accountbudget_copy`.`Description1`
`accountbudget_copy`.`Description2`
`accountbudget_copy`.`Amount`
`accountbudget_copy`.`Amount2`
`accountbudget_copy`.`Amount3`
`accountbudget_copy`.`AllotmentReleased`
`accountbudget_copy`.`SupplementalAmt`
`accountbudget_copy`.`RealignmentAmt`
`accountbudget_copy`.`Expense_Class_id`
`accountbudget_copy`.`Expense_Class`
`accountbudget_copy`.`Status`
`accountbudget_copy`.`SOF`
`accountbudget_copy`.`Category`
`accountbudget_copy`.`CategoryID`
`accountbudget_copy`.`CategoryOrder`
`accountbudget_copy`.`SubCategory`
`accountbudget_copy`.`SubCategoryID`
`accountbudget_copy`.`SubCategoryOrder`
`accountbudget_copy`.`UnderSubName`
`accountbudget_copy`.`UnderSubID`
`accountbudget_copy`.`UnderSubOrder`
`accountbudget_copy`.`DescriptionID2`
`accountbudget_copy`.`DescriptionID1`
`accountbudget_copy`.`isContinuing`
`accountbudget_copy`.`UID`
`accountbudget_copy`.`TS`
`accountbudget_copy`.`ApprovalStatus`
`accountbudget_copy`.`StartDate`
`accountbudget_copy`.`EndDate`
`accountbudget_copy`.`WFPID`
`accountbudget_copy`.`BudgetType`
`accountbudget_copy`.`ORNo`
`accountbudget_copy`.`ProjectName`
`accountbudget_copy`.`projectId`
`accountbudget_copy`.`Purposed`
`accountbudget_copy`.`SheetName`
`accountclass`.*
`accountclass`.`ID`
`accountclass`.`LBP`
`accountclass`.`ParentID`
`accountclass`.`description`
`accountclass`.`AccountId`
`accountclass`.`Code`
`accountclass`.`Level`
`accountclass`.`status`
`accountclass_budget`.*
`accountclass_budget`.`ID`
`accountclass_budget`.`AppropId`
`accountclass_budget`.`byear`
`accountclass_budget`.`deptId`
`accountclass_budget`.`Amount`
`accountrevision`.*
`accountrevision`.`Id`
`accountrevision`.`SOF`
`accountrevision`.`BudgetType`
`accountrevision`.`BYear`
`accountrevision`.`DepartmentId`
`accountrevision`.`Acid`
`accountrevision`.`AccountDescription`
`accountrevision`.`Amount`
`accountrevision`.`UID`
`accountrevision`.`TS`
`accountrevision`.`Status`
`accountrevision`.`Revision`
`accountrevision`.`OrigAmt`
`accounts_parents`.*
`accounts_parents`.`ID`
`accounts_parents`.`GID`
`accounts_parents`.`ACID`
`accounts_parents`.`GEN_NAMES`
`accounts_parents`.`account_code`
`accounts_parents`.`account_description`
`accounts_parents`.`CLASSIFICATION`
`accounts_parents`.`SUBLASS`
`accounts_parents`.`t_account`
`accounts_parents`.`GEN_CODE`
`accounts_parents`.`CLASSIFICATION_CODE`
`accounts_parents`.`SUBCLASS_CODE`
`accounts_parents`.`markcontra`
`accounts_parents`.`ACCOUNT_SPACE`
`accountutilization`.*
`accountutilization`.`Id`
`accountutilization`.`AppropriationID`
`accountutilization`.`OBRID`
`accountutilization`.`SOFID`
`accountutilization`.`DepartmentId`
`accountutilization`.`BYear`
`accountutilization`.`RespCenterId`
`accountutilization`.`RespCenterName`
`accountutilization`.`Amount`
`accountutilization`.`Jan`
`accountutilization`.`Feb`
`accountutilization`.`Mar`
`accountutilization`.`Apr`
`accountutilization`.`May`
`accountutilization`.`Jun`
`accountutilization`.`Jul`
`accountutilization`.`Aug`
`accountutilization`.`Sep`
`accountutilization`.`Octo`
`accountutilization`.`Nov`
`accountutilization`.`Dece`
`accountutilization`.`UID`
`accountutilization`.`TS`
`accountutilization`.`Status`
`accountutilization`.`sheetName`
`accountutilization`.`ManualEntryGUID`
`accountutilization`.`Acode`
`accountutilizationbeginning`.*
`accountutilizationbeginning`.`Id`
`accountutilizationbeginning`.`AppropriationID`
`accountutilizationbeginning`.`SOF`
`accountutilizationbeginning`.`BudgetType`
`accountutilizationbeginning`.`BYear`
`accountutilizationbeginning`.`DepartmentId`
`accountutilizationbeginning`.`ACID`
`accountutilizationbeginning`.`_Code`
`accountutilizationbeginning`.`Description`
`accountutilizationbeginning`.`Amount`
`accountutilizationbeginning`.`Jan`
`accountutilizationbeginning`.`Feb`
`accountutilizationbeginning`.`Mar`
`accountutilizationbeginning`.`Apr`
`accountutilizationbeginning`.`May`
`accountutilizationbeginning`.`Jun`
`accountutilizationbeginning`.`Jul`
`accountutilizationbeginning`.`Aug`
`accountutilizationbeginning`.`Sep`
`accountutilizationbeginning`.`Oct`
`accountutilizationbeginning`.`Nov`
`accountutilizationbeginning`.`Dec`
`accountutilizationbeginning`.`UID`
`accountutilizationbeginning`.`TS`
`accountutilizationbeginning`.`Status`
`acctdummy`.*
`acctdummy`.`ID`
`acctdummy`.`Amount4`
`additionalbudget`.*
`additionalbudget`.`ID`
`additionalbudget`.`sofId`
`additionalbudget`.`appropriationId`
`additionalbudget`.`Btype`
`additionalbudget`.`GUID`
`additionalbudget`.`Yr`
`additionalbudget`.`OfficeID`
`additionalbudget`.`OfficeName`
`additionalbudget`.`ACID`
`additionalbudget`.`Code`
`additionalbudget`.`Account`
`additionalbudget`.`PrevBalance`
`additionalbudget`.`AdditionalAmt`
`additionalbudget`.`NewBudget`
`additionalbudget`.`Remarks`
`additionalbudget`.`UID`
`additionalbudget`.`TS`
`additionalbudget`.`Status`
`adjustment_minus`.*
`adjustment_minus`.`ID`
`adjustment_minus`.`BatchId`
`adjustment_minus`.`AppropriationId`
`adjustment_minus`.`Account`
`adjustment_minus`.`Code`
`adjustment_minus`.`SortBy`
`adjustment_minus`.`TransDate`
`adjustment_minus`.`Reference`
`adjustment_minus`.`BYear`
`adjustment_minus`.`OfficeID`
`adjustment_minus`.`OfficeName`
`adjustment_minus`.`FundId`
`adjustment_minus`.`FundName`
`adjustment_minus`.`ExpenseClassId`
`adjustment_minus`.`ExpenseClass`
`adjustment_minus`.`Amount`
`adjustment_minus`.`Remarks`
`adjustment_minus`.`User`
`adjustment_minus`.`Status`
`adjustment_minus`.`OrdinanceNo`
`adjustment_minus`.`OrdinanceDate`
`adjustment_plus`.*
`adjustment_plus`.`ID`
`adjustment_plus`.`BatchId`
`adjustment_plus`.`AppropriationId`
`adjustment_plus`.`Account`
`adjustment_plus`.`Code`
`adjustment_plus`.`SortBy`
`adjustment_plus`.`TransDate`
`adjustment_plus`.`Reference`
`adjustment_plus`.`BYear`
`adjustment_plus`.`OfficeID`
`adjustment_plus`.`OfficeName`
`adjustment_plus`.`FundId`
`adjustment_plus`.`FundName`
`adjustment_plus`.`ExpenseClassId`
`adjustment_plus`.`ExpenseClass`
`adjustment_plus`.`Amount`
`adjustment_plus`.`Remarks`
`adjustment_plus`.`User`
`adjustment_plus`.`Status`
`adjustment_plus`.`OrdinanceNo`
`adjustment_plus`.`OrdinanceDate`
`aipentry`.*
`aipentry`.`ID`
`aipentry`.`SOFID`
`aipentry`.`SOF`
`aipentry`.`StartDate`
`aipentry`.`EndDate`
`aipentry`.`OfficeID`
`aipentry`.`OfficeName`
`aipentry`.`grouping`
`aipentry`.`SectorID`
`aipentry`.`Sector`
`aipentry`.`accountID`
`aipentry`.`AppopriationID`
`aipentry`.`Account`
`aipentry`.`Year`
`aipentry`.`Code`
`aipentry`.`Description`
`aipentry`.`MOOE`
`aipentry`.`CO`
`aipentry`.`Amount`
`aipentry`.`groupid`
`aipentry`.`GroupName`
`aipentry`.`YearCount`
`aipentry`.`class1`
`aipentry`.`class2`
`aipentry`.`class3`
`aipentry`.`UID`
`aipentry`.`Status`
`aipentry`.`WFPID`
`aipentry`.`TS`
`aipentry_utilization`.*
`aipentry_utilization`.`ID`
`aipentry_utilization`.`AIPID`
`aipentry_utilization`.`SOFID`
`aipentry_utilization`.`SOF`
`aipentry_utilization`.`StartDate`
`aipentry_utilization`.`EndDate`
`aipentry_utilization`.`OfficeID`
`aipentry_utilization`.`OfficeName`
`aipentry_utilization`.`SectorId`
`aipentry_utilization`.`Sector`
`aipentry_utilization`.`AppopriationID`
`aipentry_utilization`.`Account`
`aipentry_utilization`.`Year`
`aipentry_utilization`.`Code`
`aipentry_utilization`.`Description`
`aipentry_utilization`.`MOOE`
`aipentry_utilization`.`CO`
`aipentry_utilization`.`ActualMOOE`
`aipentry_utilization`.`ActualCO`
`aipentry_utilization`.`UID`
`aipentry_utilization`.`TS`
`allotmentrelease`.*
`allotmentrelease`.`ID`
`allotmentrelease`.`FullAroNum`
`allotmentrelease`.`ARODate`
`allotmentrelease`.`CategoryID`
`allotmentrelease`.`Category`
`allotmentrelease`.`BYEAR`
`allotmentrelease`.`officeID`
`allotmentrelease`.`ppaCode`
`allotmentrelease`.`appropriationId`
`allotmentrelease`.`AccountID`
`allotmentrelease`.`AccountDescription`
`allotmentrelease`.`FundID`
`allotmentrelease`.`FundCode`
`allotmentrelease`.`FundName`
`allotmentrelease`.`BudgetSource`
`allotmentrelease`.`objectclass_AccountCode`
`allotmentrelease`.`objectclass_AccountCodeId`
`allotmentrelease`.`Appropriation`
`allotmentrelease`.`ReleasedAmt`
`allotmentrelease`.`purpose`
`allotmentrelease`.`UID`
`allotmentrelease`.`ts`
`allotmentrelease`.`LastEntry`
`allotmentrelease`.`Quarter_`
`allotmentrelease`.`Status`
`allotmentrelease`.`BatchGUID`
`allowances_jo`.*
`allowances_jo`.`allowance_id`
`allowances_jo`.`allowance_name`
`allowances_jo`.`allowance_status`
`allowances_jo`.`account_id`
`allowances_jo`.`allowance_type`
`appplan`.*
`appplan`.`ID`
`appplan`.`ItemClass`
`appplan`.`BudTypeID`
`appplan`.`BudType`
`appplan`.`SOFID`
`appplan`.`SOFDescription`
`appplan`.`ACID`
`appplan`.`Account`
`appplan`.`PPMPID`
`appplan`.`GUID`
`appplan`.`DateSubmitted`
`appplan`.`DepartmentID`
`appplan`.`DepartmentName`
`appplan`.`BYear`
`appplan`.`AppropriatedAmt`
`appplan`.`Contigency`
`appplan`.`NetAmt`
`appplan`.`ControlNum`
`appplan`.`UID`
`appplan`.`TS`
`appplan`.`ItemID`
`appplan`.`Description`
`appplan`.`Qty`
`appplan`.`UoM`
`appplan`.`UnitPrice`
`appplan`.`TotalCost`
`appplan`.`FQty`
`appplan`.`FAmount`
`appplan`.`SQty`
`appplan`.`SAmount`
`appplan`.`TQty`
`appplan`.`TAmount`
`appplan`.`FRQty`
`appplan`.`FRAmount`
`appsignatories`.*
`appsignatories`.`ID`
`appsignatories`.`DepartmentID`
`appsignatories`.`SigType`
`appsignatories`.`Signame`
`appsignatories`.`Position`
`appsignatories`.`UID`
`apv_number`.*
`apv_number`.`ID`
`apv_number`.`JID`
`apv_number`.`APVNUM`
`apv_number`.`LOC`
`apv_number`.`TITLE`
`apv_number`.`YYYY`
`apv_number`.`PO`
`apv_number`.`INV`
`apv_number`.`GRPS`
`atc_setup`.*
`atc_setup`.`ID`
`atc_setup`.`DESCRIPTION`
`atc_setup`.`Goodservice`
`atc_setup`.`ATC`
`atc_setup`.`RATE`
`atc_setup`.`ACID`
`atc_setup`.`CID`
`atc_tax_rate`.*
`atc_tax_rate`.`ID`
`atc_tax_rate`.`ATC`
`atc_tax_rate`.`Rate`
`bank_recon_records`.*
`bank_recon_records`.`ID`
`bank_recon_records`.`GRP`
`bank_recon_records`.`ACCOUNTID`
`bank_recon_records`.`SAVE_DATE`
`bank_recon_records`.`ReportedBankBalance`
`bank_recon_records`.`AmountBeforeRecon`
`bank_recon_records`.`asofdate`
`bank_recon_records`.`GUID`
`bank_recon_records`.`ReconDates`
`beginning_temp`.*
`beginning_temp`.`ID`
`beginning_temp`.`ACID`
`beginning_temp`.`CODE`
`beginning_temp`.`DESCRIPTION`
`beginning_temp`.`JAN`
`beginning_temp`.`FEB`
`beginning_temp`.`MAR`
`beginning_temp`.`APR`
`beginning_temp`.`MAY`
`beginning_temp`.`JUN`
`beginning_temp`.`JUL`
`beginning_temp`.`AUG`
`beginning_temp`.`SEP`
`beginning_temp`.`OCT`
`beginning_temp`.`NOV`
`beginning_temp`.`DEC`
`beginning_temp`.`YR`
`beginning_temp`.`GID`
`beginning_temp`.`GID1`
`beginning_temp`.`ACCOUNTSPACE`
`beginning_temp`.`MAINID`
`beginning_temp`.`OFFICE`
`beginning_temp`.`COST_CENTER`
`beginning_temp`.`DRCR`
`beginning_temp`.`SUBTYPE`
`beginning_temp`.`ISBANK`
`bill_series`.*
`bill_series`.`ID`
`bill_series`.`Year`
`bill_series`.`series`
`bill_series`.`titleid`
`bill_series`.`JID`
`bill_series`.`ref`
`bill_series`.`SUBID`
`bill_series`.`tstamp`
`billing_monitoring`.*
`billing_monitoring`.`bill_id`
`billing_monitoring`.`bill_projectNo`
`billing_monitoring`.`bill_projectname`
`billing_monitoring`.`bill_requesteddate`
`billing_monitoring`.`bill_requestpercentage`
`billing_monitoring`.`bill_requestdetails`
`billing_monitoring`.`bill_requestamount`
`billing_monitoring`.`bill_requestremarks`
`billing_monitoring`.`bill_date`
`billing_monitoring`.`bill_percentage`
`billing_monitoring`.`bill_details`
`billing_monitoring`.`bill_amount`
`billing_monitoring`.`bill_recoupment`
`billing_monitoring`.`bill_vat2`
`billing_monitoring`.`bill_vat5`
`billing_monitoring`.`bill_others`
`billing_monitoring`.`bill_incometax1`
`billing_monitoring`.`bill_royalty`
`billing_monitoring`.`bill_birdue`
`billing_monitoring`.`bill_bonds`
`billing_monitoring`.`bill_otherssubcon`
`billing_monitoring`.`bill_amountNet`
`billing_monitoring`.`bill_remarks`
`billing_monitoring`.`saved_date`
`billing_monitoring`.`bill_actualAccomplished`
`billing_monitoring`.`bill_subcon`
`billing_monitoring`.`PROJECT_ID`
`billing_monitoring`.`RETENTION`
`billing_monitoring`.`JID`
`billing_others`.*
`billing_others`.`ID`
`billing_others`.`JID`
`billing_others`.`DTL_ID`
`billing_others`.`ACCOUNT_ID`
`billing_others`.`AMOUNT`
`billing_others`.`ORNUM`
`billing_others`.`ORDATE`
`billing_others`.`BLID`
`billing_others`.`ACCOUNT_DESC`
`billing_others`.`CONTAINER`
`billing_others`.`CID`
`billingrecord`.*
`billingrecord`.`ID`
`billingrecord`.`equipmentID`
`billingrecord`.`BILL_NO`
`billingrecord`.`CUSTOMER`
`billingrecord`.`LOCATION`
`billingrecord`.`TITLEID`
`billingrecord`.`FL`
`billingrecord`.`CTYPE`
`billingrecord`.`trans_date`
`billingrecord`.`reference`
`billingrecord`.`start_time`
`billingrecord`.`end_time`
`billingrecord`.`unit`
`billingrecord`.`rate`
`billingrecord`.`location_frm`
`billingrecord`.`location_to`
`billingrecord`.`REMARKS`
`billingrecord`.`TRIPS_NUM`
`billingrecord`.`KM`
`billingrecord`.`TS`
`billingrecord`.`JID`
`billingrecord`.`GUID`
`billingrecord`.`UID`
`billingrecord`.`dispatchid`
`billingrecord`.`refnum`
`billingrecord`.`operators`
`billingrecord`.`DTLS`
`billingrecord`.`EQUIPMENT`
`billingrecord`.`DEPARTMENT`
`billingrecord`.`DEPID`
`billingrecord`.`entry_date`
`billingrecord`.`ITEMDESCRIPTION`
`bislig_petty_liquidate`.*
`bislig_petty_liquidate`.`ID`
`bislig_petty_liquidate`.`ReleasedID`
`bislig_petty_liquidate`.`EMPID`
`bislig_petty_liquidate`.`TS`
`bislig_petty_liquidate`.`STATUS`
`bislig_petty_liquidate`.`LIQ_JID`
`bislig_petty_liquidate`.`GRP`
`bislig_system`.*
`bislig_system`.`id`
`bislig_system`.`company_name`
`bislig_system`.`address`
`bislig_system`.`logo_name`
`bislig_system`.`photo`
`bisligpetty`.*
`bisligpetty`.`ID`
`bisligpetty`.`EMPID`
`bisligpetty`.`TDATE`
`bisligpetty`.`REF`
`bisligpetty`.`AMT`
`bisligpetty`.`RELEASEDBY`
`bisligpetty`.`STATUS`
`bisligpetty`.`TS`
`bisligpetty`.`LOCATION`
`bisligpetty`.`CANCEL_reason`
`bisligpetty`.`memo`
`bisligpetty`.`custodian`
`bisligpetty`.`supervisor`
`board_directors`.*
`board_directors`.`ID`
`board_directors`.`dates`
`board_directors`.`costcenter`
`board_directors`.`resolutionApproved`
`board_directors`.`policiesPass`
`board_directors`.`DirectorsFee`
`board_directors`.`Held`
`board_directors`.`regular`
`board_directors`.`special`
`board_directors`.`seminar`
`board_directors`.`ts`
`board_directors`.`uid`
`board_directors`.`STATUS`
`board_directors`.`GID`
`branch_setup`.*
`branch_setup`.`id`
`branch_setup`.`reference_no`
`branch_setup`.`branch_name`
`branch_setup`.`branch_address`
`branch_setup`.`application_date`
`branch_setup`.`status`
`breakdowngroup`.*
`breakdowngroup`.`ID`
`breakdowngroup`.`ParentID`
`breakdowngroup`.`Description`
`breakdowngroup`.`Status`
`budget_setup`.*
`budget_setup`.`id`
`budget_setup`.`class`
`budget_setup`.`subclass`
`budget_setup`.`account`
`budget_setup`.`year`
`budget_setup`.`jan`
`budget_setup`.`feb`
`budget_setup`.`mar`
`budget_setup`.`apr`
`budget_setup`.`may`
`budget_setup`.`jun`
`budget_setup`.`jul`
`budget_setup`.`aug`
`budget_setup`.`sep`
`budget_setup`.`oct`
`budget_setup`.`nov`
`budget_setup`.`dec`
`budget_setup`.`location`
`budget_setup`.`division`
`budget_setup`.`titleID`
`budget_setup`.`identification`
`budget_setup_dtl`.*
`budget_setup_dtl`.`dtl_id`
`budget_setup_dtl`.`budget_id`
`budget_setup_dtl`.`year`
`budget_setup_dtl`.`month`
`budget_setup_dtl`.`type`
`budget_setup_dtl`.`cash_flow`
`budget_setup_dtl`.`item_type`
`budget_setup_dtl`.`item_id`
`budget_setup_dtl`.`item_description`
`budget_setup_dtl`.`item_display_name`
`budget_setup_dtl`.`transaction_type`
`budget_setup_dtl`.`expense_type`
`budget_setup_dtl`.`cost_type`
`budget_setup_dtl`.`quantity`
`budget_setup_dtl`.`unit_measure`
`budget_setup_dtl`.`unit_cost`
`budget_setup_dtl`.`no_of_person`
`budget_setup_dtl`.`total_amount`
`budget_setup_dtl`.`purpose`
`budget_setup_dtl`.`status`
`budget_setup_dtl`.`save_date`
`budget_setup_dtl`.`title_id`
`budget_setup_dtl`.`location_id`
`budget_setup_dtl`.`division_id`
`budget_setup_dtl`.`account_id`
`budget_signatory`.*
`budget_signatory`.`Signatory_ID`
`budget_signatory`.`Signatory_Name`
`budget_signatory`.`Signatory_Position`
`budget_signatory`.`Signatory_Position_id`
`budget_signatory`.`Signatory_PP_ID`
`budget_signatory`.`department_id`
`budget_signatory`.`status`
`budgetappropriationstatus`.*
`budgetappropriationstatus`.`ID`
`budgetappropriationstatus`.`budgetType`
`budgetappropriationstatus`.`Yr`
`budgetappropriationstatus`.`OfficeId`
`budgetappropriationstatus`.`Status`
`budgetclosing`.*
`budgetclosing`.`Id`
`budgetclosing`.`ClosingDate`
`budgetclosing`.`ClosedByName`
`budgetdetail`.*
`budgetdetail`.`ID`
`budgetdetail`.`groupid`
`budgetdetail`.`GroupName`
`budgetdetail`.`TypeofBudget`
`budgetdetail`.`BYear`
`budgetdetail`.`DescriptionID`
`budgetdetail`.`Description`
`budgetdetail`.`AppropriationID`
`budgetdetail`.`ACID`
`budgetdetail`.`ACID_Description`
`budgetdetail`.`DepartmentID`
`budgetdetail`.`Jan`
`budgetdetail`.`Feb`
`budgetdetail`.`Mar`
`budgetdetail`.`Apr`
`budgetdetail`.`May`
`budgetdetail`.`Jun`
`budgetdetail`.`Jul`
`budgetdetail`.`Aug`
`budgetdetail`.`Sept`
`budgetdetail`.`Oct`
`budgetdetail`.`Nov`
`budgetdetail`.`Dec`
`budgetdetail_plantilla`.*
`budgetdetail_plantilla`.`ID`
`budgetdetail_plantilla`.`Group`
`budgetdetail_plantilla`.`DescriptionID`
`budgetdetail_plantilla`.`Description`
`budgetdetail_plantilla`.`Positions`
`budgetdetail_plantilla`.`BYear`
`budgetdetail_plantilla`.`ACID`
`budgetdetail_plantilla`.`TypeofBudget`
`budgetdetail_plantilla`.`Jan`
`budgetdetail_plantilla`.`Feb`
`budgetdetail_plantilla`.`Mar`
`budgetdetail_plantilla`.`Apr`
`budgetdetail_plantilla`.`May`
`budgetdetail_plantilla`.`Jun`
`budgetdetail_plantilla`.`Jul`
`budgetdetail_plantilla`.`Aug`
`budgetdetail_plantilla`.`Sept`
`budgetdetail_plantilla`.`Oct`
`budgetdetail_plantilla`.`Nov`
`budgetdetail_plantilla`.`Dec`
`budgetdetail_plantilla`.`Total`
`budgetdetail_plantilla`.`DepartmentID`
`budgetdetail_plantilla`.`SG`
`budgetdetail_plantilla`.`Step`
`budgetdetail_plantilla`.`UID`
`budgetdetail_plantilla`.`PositionID`
`budgetsourcedescription`.*
`budgetsourcedescription`.`ID`
`budgetsourcedescription`.`Description`
`cash_advances`.*
`cash_advances`.`SysPK_CshAdv`
`cash_advances`.`SysFK_Empl_CshAdv`
`cash_advances`.`UserCode_CshAdv`
`cash_advances`.`Name_CshAdv`
`cash_advances`.`DateTrans_CshAdv`
`cash_advances`.`Amount_CshAdv`
`cash_advances`.`Balance_CshAdv`
`cash_advances`.`Terms_CshAdv`
`cash_advances`.`AmortAmount_CshAdv`
`cash_advances`.`Remarks_CshAdv`
`cash_advances`.`Description_CshAdv`
`cash_advances`.`CompanyCode`
`cash_advances`.`ProjectCode`
`cash_advances`.`deductionType`
`cash_advances`.`EMP_ID`
`cashall`.*
`cashall`.`ID`
`cashall`.`JOURNAL_ID`
`cashall`.`DRCR`
`cashliquidation`.*
`cashliquidation`.`CLRFNumber`
`cashliquidation`.`CLEmpName`
`cashliquidation`.`CLProjCode`
`cashliquidation`.`CLProjName`
`cashliquidation`.`CLLocation`
`cashliquidation`.`CLDate`
`cashliquidation`.`CLAmount`
`cashliquidation`.`CLPeriodfrom`
`cashliquidation`.`CLPeriodto`
`cashliquidation`.`CLGrossAmount`
`cashliquidation`.`sss`
`cashliquidation`.`hdmf`
`cashliquidation`.`cassd`
`cashliquidation`.`metrobank`
`cashliquidation`.`bdo`
`cashvoucher_series`.*
`cashvoucher_series`.`id`
`cashvoucher_series`.`JID`
`cashvoucher_series`.`cv`
`cashvoucher_series`.`COMPANY`
`cashvoucher_series`.`YEAR`
`cashvoucher_series`.`TSTAMP`
`cashvoucher_series`.`groupentry`
`casl_liq`.*
`casl_liq`.`ID`
`casl_liq`.`REF_OLD`
`casl_liq`.`OLD_JID`
`casl_liq`.`REF_NEW`
`casl_liq`.`JID`
`casl_liq`.`DATE_LIQ`
`casl_liq`.`EMPID`
`casl_liq`.`MEMO`
`casl_liq`.`AMOUNT`
`casl_liq`.`UID`
`casl_liq`.`status`
`casl_liq`.`CV`
`casl_liq`.`tstamp`
`casl_liq`.`GROUP`
`casl_liq`.`CASL_GUID`
`casl_liq`.`RELASED_ID`
`casl_liq_br`.*
`casl_liq_br`.`ID`
`casl_liq_br`.`JID`
`casl_liq_br`.`CUSTID`
`casl_liq_br`.`ACCOUNTID`
`casl_liq_br`.`SHIPPING`
`casl_liq_br`.`AMOUNT`
`casl_liq_br`.`ORNUM`
`casl_liq_br`.`DATE_PAID`
`casl_liq_br`.`CONTAINER`
`casl_liq_br`.`PROCESSOR`
`casl_liq_br`.`TSTAMP`
`casl_liq_br`.`status`
`casl_liq_br`.`CASL_GUID`
`casl_liq_details`.*
`casl_liq_details`.`id`
`casl_liq_details`.`journal_details_id`
`casl_liq_details`.`TIN`
`casl_liq_details`.`REMARKS`
`casl_liq_details`.`INV_NUM`
`casl_liq_details`.`Suppliername`
`casl_liq_details`.`SUPID`
`casl_liq_details`.`JID`
`casl_liq_details`.`caslID`
`casl_refund_list`.*
`casl_refund_list`.`ID`
`casl_refund_list`.`JID`
`casl_refund_list`.`GROUPS`
`casl_released`.*
`casl_released`.`ID`
`casl_released`.`JID`
`casl_released`.`REF`
`casl_released`.`GUID`
`casl_released`.`DATES`
`casl_released`.`EMPID`
`casl_released`.`MEMOS`
`casl_released`.`AMOUNT`
`casl_released`.`UID`
`casl_released`.`status`
`casl_released`.`tstamp`
`casl_released`.`COMPANYCODE`
`casl_released`.`DEPTCODE`
`casl_released`.`CASH_ACID`
`casl_released`.`FUND_LOC`
`casl_released`.`LOCATION_`
`casl_released`.`PAYEE_ID`
`casl_released`.`NAME_TYPES`
`category`.*
`category`.`ID`
`category`.`ParentID`
`category`.`LBP`
`category`.`Name`
`category`.`Status`
`category`.`Ordering`
`category`.`ExpenseClass`
`cf_description`.*
`cf_description`.`ID`
`cf_description`.`CF_NAME`
`cf_description`.`STATUS`
`cf_description`.`ORDER`
`cf_description`.`TYPE`
`cf_description`.`FLOW`
`check_monitoring`.*
`check_monitoring`.`ID`
`check_monitoring`.`CDATE`
`check_monitoring`.`ARRIVAL`
`check_monitoring`.`PAYEEID`
`check_monitoring`.`CONSIGNEEID`
`check_monitoring`.`CHECK_NUM`
`check_monitoring`.`C_VOUCHER`
`check_monitoring`.`BL`
`check_monitoring`.`PURPOSE_OF_PAYMENT`
`check_monitoring`.`RECEIVEDBY`
`check_monitoring`.`AMOUNT`
`check_monitoring`.`CONTAINER`
`check_monitoring`.`MC_FEE`
`check_monitoring`.`BP`
`check_monitoring`.`STATUS`
`check_monitoring`.`title_id`
`check_monitoring`.`MC_CHECK`
`check_monitoring`.`LOGBY`
`check_monitoring`.`REMOVEDBY`
`check_received_released_stat`.*
`check_received_released_stat`.`ID`
`check_received_released_stat`.`JID`
`check_received_released_stat`.`status`
`check_received_released_stat`.`RELEASED_DATE`
`check_received_released_stat`.`UID`
`check_received_released_stat`.`RECEIVEDBY`
`check_received_released_stat`.`REMARKS`
`check_received_released_stat`.`REFERENCE`
`check_received_released_stat`.`TSTAMP`
`check_received_released_stat`.`CHK_TYPE`
`check_received_released_stat`.`groups`
`checkdefaultsignatories`.*
`checkdefaultsignatories`.`ID`
`checkdefaultsignatories`.`NAMES1`
`checkdefaultsignatories`.`POSITIONS1`
`checkdefaultsignatories`.`NAMES2`
`checkdefaultsignatories`.`POSITIONS2`
`checkingaccountlog`.*
`checkingaccountlog`.`ID`
`checkingaccountlog`.`JID`
`checkingaccountlog`.`ACID`
`checkingaccountlog`.`BANK_NAME`
`checkingaccountlog`.`CHECKNUMBER`
`checkingaccountlog`.`CHECKDATES`
`checkingaccountlog`.`PAYEE`
`checkingaccountlog`.`PAYEEID`
`checkingaccountlog`.`Groups`
`checkingaccountlog`.`USERSID`
`checkingaccountlog`.`CVNUMBER`
`classification_setup`.*
`classification_setup`.`id`
`classification_setup`.`code`
`classification_setup`.`short_description`
`classification_setup`.`full_description`
`classification_setup`.`group`
`classification_setup`.`cash_flow`
`classification_setup`.`type`
`classification_setup`.`status`
`classification_setup`.`OWNERID`
`classification_setup`.`classOrders`
`clearing_cust_advanc_pay`.*
`clearing_cust_advanc_pay`.`ID`
`clearing_cust_advanc_pay`.`CUSTID`
`clearing_cust_advanc_pay`.`CONTAINER`
`clearing_cust_advanc_pay`.`BL`
`clearing_cust_advanc_pay`.`ARRIVAL`
`clearing_cust_advanc_pay`.`AMOUNT`
`clearing_cust_advanc_pay`.`DATEFAX`
`clearing_cust_advanc_pay`.`CHECK_NUM`
`clearing_cust_advanc_pay`.`DATEPAID`
`clearing_cust_advanc_pay`.`TSTAMP`
`clearing_cust_advanc_pay`.`STATUS`
`clearing_cust_advanc_pay`.`CLEARED`
`clearing_cust_advanc_pay`.`REMARKS`
`clearing_cust_advanc_pay`.`JOURNAL_ID`
`clev_deductions`.*
`clev_deductions`.`ID`
`clev_deductions`.`DEDUCIONID`
`clev_deductions`.`ACID`
`clev_deductions`.`AMT`
`clev_deductions`.`JID`
`clev_deductions`.`GID`
`clev_deductions`.`TS`
`clev_deductions`.`JDTL`
`closing_appro`.*
`closing_appro`.`ID`
`closing_appro`.`dateLog`
`closing_appro`.`usercloseEntry`
`closing_appro`.`remarks`
`closing_appro`.`Location`
`closing_appro`.`titleID`
`closing_appro`.`EMPNAME`
`closing_appro`.`Journal_id`
`closing_appro`.`User_syspkID`
`closing_appro`.`Status`
`closing_appro`.`ReopenBy`
`closing_appro`.`datesaved`
`closing_entry`.*
`closing_entry`.`ID`
`closing_entry`.`dateLog`
`closing_entry`.`usercloseEntry`
`closing_entry`.`remarks`
`closing_entry`.`Location`
`closing_entry`.`titleID`
`closing_entry`.`EMPNAME`
`closing_entry`.`Journal_id`
`closing_entry`.`User_syspkID`
`closing_entry`.`Status`
`closing_entry`.`ReopenBy`
`closing_entry`.`datesaved`
`container_monitoring`.*
`container_monitoring`.`ID`
`container_monitoring`.`SHIPPINGID`
`container_monitoring`.`CUSTID`
`container_monitoring`.`CONTAINERNUM`
`container_monitoring`.`BL`
`container_monitoring`.`CONTAINER_DEPO`
`container_monitoring`.`DATE_REC`
`container_monitoring`.`REF_AMOUNT`
`container_monitoring`.`REF_CHECK_NO`
`container_monitoring`.`REF_DATE`
`container_monitoring`.`DET_AMOUNT`
`container_monitoring`.`DET_BILLING`
`container_monitoring`.`CTS_AMOUNT`
`container_monitoring`.`CTS_DATE_PAID`
`container_monitoring`.`CTS_OR`
`container_monitoring`.`ATS_AMOUNT`
`container_monitoring`.`ATS_DATE_PAID`
`container_monitoring`.`ATS_OR`
`container_monitoring`.`DOCD_AMOUNT`
`container_monitoring`.`DOCD_BILLING`
`container_monitoring`.`DOCD_OR`
`container_monitoring`.`CFC_AMOUNT`
`container_monitoring`.`CFC_SOA`
`container_monitoring`.`CFC_CHECK`
`container_monitoring`.`CFC_COLLECTED`
`container_monitoring`.`CFC_COLLECTED_DATE`
`container_monitoring`.`RBTR_AMOUNT`
`container_monitoring`.`RBTR_CHECK`
`container_monitoring`.`RBTR_COLLECTED`
`container_monitoring`.`RBTR_DATE`
`container_monitoring`.`REMARKS`
`container_monitoring`.`TS`
`container_monitoring`.`UID`
`continuingmigration`.*
`continuingmigration`.`Id`
`continuingmigration`.`OfficeCode`
`continuingmigration`.`Office`
`continuingmigration`.`OfficeId`
`continuingmigration`.`SOFID`
`continuingmigration`.`SOF`
`continuingmigration`.`BudgetType`
`continuingmigration`.`SubOfficeCode`
`continuingmigration`.`SubOffice`
`continuingmigration`.`ExpenseClassId`
`continuingmigration`.`ExpDescription`
`continuingmigration`.`ExpCode`
`continuingmigration`.`AccountCode`
`continuingmigration`.`Description`
`continuingmigration`.`Appropriation`
`continuingmigration`.`TotalAllotment`
`continuingmigration`.`AppropriationBalance`
`continuingmigration`.`Obligation`
`continuingmigration`.`UnobligatedBalance`
`continuings`.*
`continuings`.`Id`
`continuings`.`accountType`
`continuings`.`TypeDescription`
`continuings`.`ExpenseClassID`
`continuings`.`OfficeID`
`continuings`.`OfficeCode`
`continuings`.`AccountCode`
`continuings`.`Description`
`continuings`.`Amount`
`cto_budget_account_columns`.*
`cto_budget_account_columns`.`id`
`cto_budget_account_columns`.`accnt_id`
`cto_budget_account_columns`.`col_name`
`cto_budget_account_columns`.`def_val`
`cto_budget_account_columns`.`col_id`
`cto_budget_account_columns`.`col_num`
`cto_budget_account_columns`.`operation`
`cto_budget_account_columns`.`calc_col`
`cto_budget_account_columns`.`data_type`
`cto_budget_account_columns`.`status`
`cto_budget_account_columns_main`.*
`cto_budget_account_columns_main`.`id`
`cto_budget_account_columns_main`.`from_tbl`
`cto_budget_account_columns_main`.`dept_query`
`cto_budget_beg_entry`.*
`cto_budget_beg_entry`.`id`
`cto_budget_beg_entry`.`accnt_id`
`cto_budget_beg_entry`.`dept_id`
`cto_budget_beg_entry`.`year`
`cto_budget_beg_entry`.`app_last_year`
`cto_budget_beg_entry`.`expended_last_year`
`cto_budget_beg_entry`.`app_cur_year`
`cto_budget_beg_entry`.`expended_first_9_month`
`cto_budget_beg_entry`.`anticipated_expenditure`
`cto_budget_beg_entry`.`app_next_year`
`cto_budget_category_none_ppmp`.*
`cto_budget_category_none_ppmp`.`id`
`cto_budget_category_none_ppmp`.`desc`
`cto_budget_mode_pro`.*
`cto_budget_mode_pro`.`id`
`cto_budget_mode_pro`.`mode_pro_desc`
`cto_budget_mode_pro`.`status`
`cto_budget_mode_pro`.`xx`
`cto_budget_none_ppmp`.*
`cto_budget_none_ppmp`.`id`
`cto_budget_none_ppmp`.`budget_year`
`cto_budget_none_ppmp`.`dept_id`
`cto_budget_none_ppmp`.`account_id`
`cto_budget_none_ppmp`.`remarks`
`cto_budget_none_ppmp`.`source_fund`
`cto_budget_none_ppmp`.`status`
`cto_budget_none_ppmp`.`display_detail`
`cto_budget_none_ppmp`.`type`
`cto_budget_none_ppmp`.`date_created`
`cto_budget_none_ppmp`.`charge_dep_id`
`cto_budget_none_ppmp_dtls`.*
`cto_budget_none_ppmp_dtls`.`dtl_id`
`cto_budget_none_ppmp_dtls`.`ledger_type`
`cto_budget_none_ppmp_dtls`.`main_id`
`cto_budget_none_ppmp_dtls`.`trans_id`
`cto_budget_none_ppmp_dtls`.`emp_id`
`cto_budget_none_ppmp_dtls`.`deptid`
`cto_budget_none_ppmp_dtls`.`col1`
`cto_budget_none_ppmp_dtls`.`col2`
`cto_budget_none_ppmp_dtls`.`col3`
`cto_budget_none_ppmp_dtls`.`col4`
`cto_budget_none_ppmp_dtls`.`col5`
`cto_budget_none_ppmp_dtls`.`col6`
`cto_budget_none_ppmp_dtls`.`col7`
`cto_budget_none_ppmp_dtls`.`col8`
`cto_budget_none_ppmp_dtls`.`jan`
`cto_budget_none_ppmp_dtls`.`feb`
`cto_budget_none_ppmp_dtls`.`mar`
`cto_budget_none_ppmp_dtls`.`apr`
`cto_budget_none_ppmp_dtls`.`may`
`cto_budget_none_ppmp_dtls`.`jun`
`cto_budget_none_ppmp_dtls`.`jul`
`cto_budget_none_ppmp_dtls`.`aug`
`cto_budget_none_ppmp_dtls`.`sep`
`cto_budget_none_ppmp_dtls`.`oct`
`cto_budget_none_ppmp_dtls`.`nov`
`cto_budget_none_ppmp_dtls`.`dec`
`cto_budget_none_ppmp_dtls`.`type`
`cto_budget_none_ppmp_dtls`.`util`
`cto_budget_none_ppmp_dtls`.`revision`
`cto_budget_none_ppmp_dtls`.`savedate`
`cto_budget_none_ppmp_dtls`.`status`
`cto_budget_none_ppmp_dtls_temp`.*
`cto_budget_none_ppmp_dtls_temp`.`dtl_id`
`cto_budget_none_ppmp_dtls_temp`.`ledger_type`
`cto_budget_none_ppmp_dtls_temp`.`main_id`
`cto_budget_none_ppmp_dtls_temp`.`trans_id`
`cto_budget_none_ppmp_dtls_temp`.`deptid`
`cto_budget_none_ppmp_dtls_temp`.`emp_id`
`cto_budget_none_ppmp_dtls_temp`.`col1`
`cto_budget_none_ppmp_dtls_temp`.`col2`
`cto_budget_none_ppmp_dtls_temp`.`col3`
`cto_budget_none_ppmp_dtls_temp`.`col4`
`cto_budget_none_ppmp_dtls_temp`.`col5`
`cto_budget_none_ppmp_dtls_temp`.`col6`
`cto_budget_none_ppmp_dtls_temp`.`col7`
`cto_budget_none_ppmp_dtls_temp`.`col8`
`cto_budget_none_ppmp_dtls_temp`.`jan`
`cto_budget_none_ppmp_dtls_temp`.`feb`
`cto_budget_none_ppmp_dtls_temp`.`mar`
`cto_budget_none_ppmp_dtls_temp`.`apr`
`cto_budget_none_ppmp_dtls_temp`.`may`
`cto_budget_none_ppmp_dtls_temp`.`jun`
`cto_budget_none_ppmp_dtls_temp`.`jul`
`cto_budget_none_ppmp_dtls_temp`.`aug`
`cto_budget_none_ppmp_dtls_temp`.`sep`
`cto_budget_none_ppmp_dtls_temp`.`oct`
`cto_budget_none_ppmp_dtls_temp`.`nov`
`cto_budget_none_ppmp_dtls_temp`.`dec`
`cto_budget_none_ppmp_dtls_temp`.`type`
`cto_budget_none_ppmp_dtls_temp`.`revision`
`cto_budget_none_ppmp_dtls_temp`.`util`
`cto_budget_none_ppmp_dtls_temp`.`savedate`
`cto_budget_none_ppmp_dtls_temp`.`status`
`cto_budget_none_ppmp_dtls_temp`.`chk`
`cto_budget_ppmp`.*
`cto_budget_ppmp`.`id`
`cto_budget_ppmp`.`budget_year`
`cto_budget_ppmp`.`dept_id`
`cto_budget_ppmp`.`account_id`
`cto_budget_ppmp`.`remarks`
`cto_budget_ppmp`.`mode_pro`
`cto_budget_ppmp`.`source_fund`
`cto_budget_ppmp`.`Pre_Proc_Conference`
`cto_budget_ppmp`.`Ads_Post_of_IAEB`
`cto_budget_ppmp`.`Pre_bid_Con`
`cto_budget_ppmp`.`Eligibility_Check`
`cto_budget_ppmp`.`Sub_Open_of_Bids`
`cto_budget_ppmp`.`Bid_Evaluation`
`cto_budget_ppmp`.`Post_Qual`
`cto_budget_ppmp`.`Notice_of_Award`
`cto_budget_ppmp`.`Contract_Signing`
`cto_budget_ppmp`.`Notice_to_Proceed`
`cto_budget_ppmp`.`Delivery_Completion`
`cto_budget_ppmp`.`Acceptance_Turnover`
`cto_budget_ppmp`.`status`
`cto_budget_ppmp`.`display_detail`
`cto_budget_ppmp`.`type`
`cto_budget_ppmp`.`date_created`
`cto_budget_ppmp_dtls`.*
`cto_budget_ppmp_dtls`.`dtl_id`
`cto_budget_ppmp_dtls`.`main_id`
`cto_budget_ppmp_dtls`.`item_id`
`cto_budget_ppmp_dtls`.`qty`
`cto_budget_ppmp_dtls`.`unit`
`cto_budget_ppmp_dtls`.`cost`
`cto_budget_ppmp_dtls`.`amont`
`cto_budget_ppmp_dtls`.`remarks`
`cto_budget_ppmp_dtls`.`status`
`cto_budget_ppmp_dtls`.`type`
`cto_budget_ppmp_dtls`.`revision`
`cto_budget_ppmp_dtls`.`01_qty`
`cto_budget_ppmp_dtls`.`01_cost`
`cto_budget_ppmp_dtls`.`01_amt`
`cto_budget_ppmp_dtls`.`02_qty`
`cto_budget_ppmp_dtls`.`02_cost`
`cto_budget_ppmp_dtls`.`02_amt`
`cto_budget_ppmp_dtls`.`03_qty`
`cto_budget_ppmp_dtls`.`03_cost`
`cto_budget_ppmp_dtls`.`03_amt`
`cto_budget_ppmp_dtls`.`04_qty`
`cto_budget_ppmp_dtls`.`04_cost`
`cto_budget_ppmp_dtls`.`04_amt`
`cto_budget_ppmp_dtls`.`05_qty`
`cto_budget_ppmp_dtls`.`05_cost`
`cto_budget_ppmp_dtls`.`05_amt`
`cto_budget_ppmp_dtls`.`06_qty`
`cto_budget_ppmp_dtls`.`06_cost`
`cto_budget_ppmp_dtls`.`06_amt`
`cto_budget_ppmp_dtls`.`07_qty`
`cto_budget_ppmp_dtls`.`07_cost`
`cto_budget_ppmp_dtls`.`07_amt`
`cto_budget_ppmp_dtls`.`08_qty`
`cto_budget_ppmp_dtls`.`08_cost`
`cto_budget_ppmp_dtls`.`08_amt`
`cto_budget_ppmp_dtls`.`09_qty`
`cto_budget_ppmp_dtls`.`09_cost`
`cto_budget_ppmp_dtls`.`09_amt`
`cto_budget_ppmp_dtls`.`10_qty`
`cto_budget_ppmp_dtls`.`10_cost`
`cto_budget_ppmp_dtls`.`10_amt`
`cto_budget_ppmp_dtls`.`11_qty`
`cto_budget_ppmp_dtls`.`11_cost`
`cto_budget_ppmp_dtls`.`11_amt`
`cto_budget_ppmp_dtls`.`12_qty`
`cto_budget_ppmp_dtls`.`12_cost`
`cto_budget_ppmp_dtls`.`12_amt`
`cto_budget_ppmp_dtls`.`savedate`
`cto_budget_ppmp_dtls`.`ISGROUP`
`cto_budget_ppmp_dtls_temp`.*
`cto_budget_ppmp_dtls_temp`.`id`
`cto_budget_ppmp_dtls_temp`.`main_id`
`cto_budget_ppmp_dtls_temp`.`item_id`
`cto_budget_ppmp_dtls_temp`.`qty`
`cto_budget_ppmp_dtls_temp`.`unit`
`cto_budget_ppmp_dtls_temp`.`cost`
`cto_budget_ppmp_dtls_temp`.`amont`
`cto_budget_ppmp_dtls_temp`.`remarks`
`cto_budget_ppmp_dtls_temp`.`status`
`cto_budget_ppmp_dtls_temp`.`type`
`cto_budget_ppmp_dtls_temp`.`revision`
`cto_budget_ppmp_dtls_temp`.`01_qty`
`cto_budget_ppmp_dtls_temp`.`01_cost`
`cto_budget_ppmp_dtls_temp`.`01_amt`
`cto_budget_ppmp_dtls_temp`.`02_qty`
`cto_budget_ppmp_dtls_temp`.`02_cost`
`cto_budget_ppmp_dtls_temp`.`02_amt`
`cto_budget_ppmp_dtls_temp`.`03_qty`
`cto_budget_ppmp_dtls_temp`.`03_cost`
`cto_budget_ppmp_dtls_temp`.`03_amt`
`cto_budget_ppmp_dtls_temp`.`04_qty`
`cto_budget_ppmp_dtls_temp`.`04_cost`
`cto_budget_ppmp_dtls_temp`.`04_amt`
`cto_budget_ppmp_dtls_temp`.`05_qty`
`cto_budget_ppmp_dtls_temp`.`05_cost`
`cto_budget_ppmp_dtls_temp`.`05_amt`
`cto_budget_ppmp_dtls_temp`.`06_qty`
`cto_budget_ppmp_dtls_temp`.`06_cost`
`cto_budget_ppmp_dtls_temp`.`06_amt`
`cto_budget_ppmp_dtls_temp`.`07_qty`
`cto_budget_ppmp_dtls_temp`.`07_cost`
`cto_budget_ppmp_dtls_temp`.`07_amt`
`cto_budget_ppmp_dtls_temp`.`08_qty`
`cto_budget_ppmp_dtls_temp`.`08_cost`
`cto_budget_ppmp_dtls_temp`.`08_amt`
`cto_budget_ppmp_dtls_temp`.`09_qty`
`cto_budget_ppmp_dtls_temp`.`09_cost`
`cto_budget_ppmp_dtls_temp`.`09_amt`
`cto_budget_ppmp_dtls_temp`.`10_qty`
`cto_budget_ppmp_dtls_temp`.`10_cost`
`cto_budget_ppmp_dtls_temp`.`10_amt`
`cto_budget_ppmp_dtls_temp`.`11_qty`
`cto_budget_ppmp_dtls_temp`.`11_cost`
`cto_budget_ppmp_dtls_temp`.`11_amt`
`cto_budget_ppmp_dtls_temp`.`12_qty`
`cto_budget_ppmp_dtls_temp`.`12_cost`
`cto_budget_ppmp_dtls_temp`.`12_amt`
`cto_budget_ppmp_dtls_temp`.`savedate`
`cto_budget_ppmp_dtls_temp`.`chk`
`cto_budget_res_series`.*
`cto_budget_res_series`.`id`
`cto_budget_res_series`.`resolution_num`
`cto_budget_res_series`.`series_num`
`cto_budget_source_fund`.*
`cto_budget_source_fund`.`id`
`cto_budget_source_fund`.`source_fund_desc`
`cto_budget_source_fund`.`status`
`cto_budget_source_fund`.`MainID`
`cto_budget_type`.*
`cto_budget_type`.`id`
`cto_budget_type`.`description`
`cto_budgett_revision_setup`.*
`cto_budgett_revision_setup`.`id`
`cto_budgett_revision_setup`.`desc`
`cto_fund_setup`.*
`cto_fund_setup`.`SysPK_fund_setup`
`cto_fund_setup`.`fund_code`
`cto_fund_setup`.`fund_description`
`cto_fund_setup`.`status`
`cto_transaction_partial_deposit`.*
`cto_transaction_partial_deposit`.`id`
`cto_transaction_partial_deposit`.`ref_no`
`cto_transaction_partial_deposit`.`accntable_prson`
`cto_transaction_partial_deposit`.`receive_by`
`cto_transaction_partial_deposit`.`date`
`cto_transaction_partial_deposit`.`tmestamp`
`cto_transaction_partial_deposit`.`status`
`cto_transaction_partial_deposit_dtl`.*
`cto_transaction_partial_deposit_dtl`.`id`
`cto_transaction_partial_deposit_dtl`.`main_id`
`cto_transaction_partial_deposit_dtl`.`type`
`cto_transaction_partial_deposit_dtl`.`amount`
`cto_transaction_partial_deposit_dtl`.`pieces`
`cto_transaction_partial_deposit_dtl`.`total`
`cust_adv_refund_log`.*
`cust_adv_refund_log`.`ID`
`cust_adv_refund_log`.`DATE`
`cust_adv_refund_log`.`FROM`
`cust_adv_refund_log`.`TO`
`cust_adv_refund_log`.`SUBJECT`
`cust_adv_refund_log`.`MONTH`
`cust_adv_refund_log`.`BILL`
`cust_adv_refund_log`.`CONTAINER`
`cust_adv_refund_log`.`REMARKS`
`cust_adv_refund_log`.`TOTAL_LIQ`
`cust_adv_refund_log`.`ADV`
`cust_adv_refund_log`.`TSTAMP`
`cust_adv_refund_log`.`refund_id`
`customer_setup`.*
`customer_setup`.`SysPKID`
`customer_setup`.`pp_person_code`
`customer_setup`.`application_date`
`customer_setup`.`pp_student_no`
`customer_setup`.`pp_prefix`
`customer_setup`.`pp_lastname`
`customer_setup`.`pp_firstname`
`customer_setup`.`pp_middlename`
`customer_setup`.`pp_suffix`
`customer_setup`.`gender`
`customer_setup`.`dob`
`customer_setup`.`civil_stat`
`customer_setup`.`cellno`
`customer_setup`.`phoneno`
`customer_setup`.`nationality`
`customer_setup`.`religion`
`customer_setup`.`spouseOccupation`
`customer_setup`.`spouse`
`customer_setup`.`mother_name`
`customer_setup`.`mother_cellno`
`customer_setup`.`father_name`
`customer_setup`.`father_cellno`
`customer_setup`.`email_add`
`customer_setup`.`address`
`customer_setup`.`purok_id`
`customer_setup`.`barangay_id`
`customer_setup`.`municipal_id`
`customer_setup`.`province_id`
`customer_setup`.`save_by`
`customer_setup`.`update_by`
`customer_setup`.`cancelled_by`
`customer_setup`.`status`
`customer_setup`.`ts`
`customeradvancedeductionlogs`.*
`customeradvancedeductionlogs`.`ID`
`customeradvancedeductionlogs`.`CID`
`customeradvancedeductionlogs`.`JID`
`customeradvancedeductionlogs`.`Amount`
`customeradvancedeductionlogs`.`Reference_no`
`customeradvancedeductionlogs`.`USERID`
`customeradvances`.*
`customeradvances`.`ID`
`customeradvances`.`CID`
`customeradvances`.`custName`
`customeradvances`.`Amount`
`customeradvances`.`dates`
`customeradvances`.`Businesstype`
`customeradvances`.`Location`
`customeradvances`.`TitleID`
`customeradvanceslog`.*
`customeradvanceslog`.`ID`
`customeradvanceslog`.`CID`
`customeradvanceslog`.`BP`
`customeradvanceslog`.`Amount`
`customeradvanceslog`.`UID`
`customeradvanceslog`.`Remarks`
`customersl_log`.*
`customersl_log`.`ID`
`customersl_log`.`JID`
`customersl_log`.`CID`
`customersl_log`.`REF`
`customersl_log`.`Amount`
`cwip_logs`.*
`cwip_logs`.`ID`
`cwip_logs`.`WIP_NAME`
`cwip_logs`.`WIP_STAT`
`cwip_logs`.`START`
`cwip_logs`.`END`
`cwip_logs`.`ADDRESS`
`cwip_logs`.`REMARKS`
`cwip_logs`.`ts`
`cwip_logs`.`Types`
`cwip_logs`.`OFFICEID`
`cwip_logs`.`contractorid`
`cwip_logs`.`agencyid`
`cwip_logs`.`contract_amount`
`cwip_logs`.`ACIDS`
`debits_actual_deducted`.*
`debits_actual_deducted`.`ID`
`debits_actual_deducted`.`JID`
`debits_actual_deducted`.`AMOUNT`
`debits_actual_deducted`.`STATUS`
`debits_actual_deducted`.`TS`
`debits_actual_deducted`.`GUID`
`defaultbank`.*
`defaultbank`.`ID`
`defaultbank`.`ACID_`
`defaultbank`.`TITLEID`
`defaultbank`.`location`
`defaults_accounts`.*
`defaults_accounts`.`ID`
`defaults_accounts`.`CIB`
`defaults_accounts`.`CASL`
`defaults_accounts`.`CASSD`
`defaults_accounts`.`RECEIVABLE`
`defaults_accounts`.`PAYABLE`
`defaults_accounts`.`PETTY`
`defaults_accounts`.`ADVANCES_FRM_AFF`
`defaults_accounts`.`ADVANCES_TO_AFF`
`defaults_accounts`.`ADVANCES_FRM_CUST`
`defaults_accounts`.`COMPANYID`
`defaults_accounts`.`ADV_TO_SUP`
`defaults_accounts`.`PETTY_CASH_CUSTODIAN`
`defaults_accounts`.`DUE_TO_EMP`
`defaults_accounts`.`OFFICE`
`defaults_accounts`.`DUID`
`defaults_accounts`.`UNDEPOFUND`
`defaults_accounts`.`SRV_INC`
`defaults_accounts`.`RETAINEDEARNINGS`
`defaults_accounts`.`BIRID`
`defaults_accounts`.`INPUTTAX`
`depreciationaccounts`.*
`depreciationaccounts`.`ID`
`depreciationaccounts`.`account_id`
`depreciationaccounts`.`PPEID`
`depreciationaccounts`.`Loc`
`depreciationaccounts`.`TItleID`
`depreciationaccounts`.`accounts`
`depreciationaccounts`.`accumid`
`discount_type`.*
`discount_type`.`id`
`discount_type`.`discount_name`
`discount_type`.`valuex`
`discount_type`.`typex`
`division_setup`.*
`division_setup`.`division_id`
`division_setup`.`division_code`
`division_setup`.`division_name`
`division_setup`.`title_id`
`division_setup`.`division_code1`
`division_setup`.`project_id`
`division_setup`.`status`
`division_setup`.`savedate`
`division_setup`.`userid`
`drivers_profile`.*
`drivers_profile`.`id`
`drivers_profile`.`driver_fullname`
`drivers_profile`.`address`
`drivers_profile`.`contact_no`
`drivers_profile`.`age`
`drivers_profile`.`civil_stat`
`drivers_profile`.`license_no`
`drivers_profile`.`height`
`drivers_profile`.`weight`
`drivers_profile`.`status`
`dummy_table`.*
`dummy_table`.`id`
`dummy_table`.`hour`
`epense_type`.*
`epense_type`.`id`
`epense_type`.`desc`
`epense_type`.`stat`
`expense_item_dtls`.*
`expense_item_dtls`.`id`
`expense_item_dtls`.`exp_id`
`expense_item_dtls`.`itm_id`
`expense_item_dtls`.`qty`
`expense_item_dtls`.`price`
`expense_item_dtls`.`selling_price`
`expense_main`.*
`expense_main`.`id`
`expense_main`.`ref_no`
`expense_main`.`trans_date`
`expense_main`.`trans_no`
`expense_main`.`type`
`expense_main`.`ref_id`
`expense_main`.`total_amount`
`expense_main`.`ts`
`expense_main`.`status`
`expense_main`.`branch_id`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`hide_amount`.*
`hide_amount`.`id`
`incomesource`.*
`incomesource`.`ID`
`incomesource`.`DescriptionID1`
`incomesource`.`Description1`
`incomesource`.`Description2`
`incomesource`.`IncomeType`
`incomesource`.`FundId`
`incomesource`.`Status`
`incomesource`.`Amount`
`incomesource`.`date_source`
`installment_provider_setup`.*
`installment_provider_setup`.`SysPKID`
`installment_provider_setup`.`application_date`
`installment_provider_setup`.`pp_no`
`installment_provider_setup`.`name`
`installment_provider_setup`.`cellno`
`installment_provider_setup`.`phoneno`
`installment_provider_setup`.`email_add`
`installment_provider_setup`.`address`
`installment_provider_setup`.`save_by`
`installment_provider_setup`.`update_by`
`installment_provider_setup`.`cancelled_by`
`installment_provider_setup`.`status`
`installment_provider_setup`.`ts`
`inventory_master`.*
`inventory_master`.`id`
`inventory_master`.`transID`
`inventory_master`.`transDtlID`
`inventory_master`.`transName`
`inventory_master`.`transNum`
`inventory_master`.`itemid`
`inventory_master`.`io`
`inventory_master`.`qty`
`inventory_master`.`unitcost`
`inventory_master`.`imeiNo`
`inventory_master`.`branchid`
`inventory_master`.`status`
`inventory_master`.`guid`
`inventory_master`.`ts`
`inventory_transfer`.*
`inventory_transfer`.`ID`
`inventory_transfer`.`trans_no`
`inventory_transfer`.`trans_date`
`inventory_transfer`.`ref_no`
`inventory_transfer`.`from_Id`
`inventory_transfer`.`to_Id`
`inventory_transfer`.`status`
`inventory_transfer`.`created`
`inventory_transfer`.`created_by`
`lbp2_programappropriation`.*
`lbp2_programappropriation`.`ID`
`lbp2_programappropriation`.`FUNDID`
`lbp2_programappropriation`.`FundName`
`lbp2_programappropriation`.`LBPType`
`lbp2_programappropriation`.`CategoryId`
`lbp2_programappropriation`.`Category`
`lbp2_programappropriation`.`CategoryOrder`
`lbp2_programappropriation`.`SubCategoryID`
`lbp2_programappropriation`.`SubCategory`
`lbp2_programappropriation`.`SubCategoryOrder`
`lbp2_programappropriation`.`UnderSubID`
`lbp2_programappropriation`.`UnderSubName`
`lbp2_programappropriation`.`UnderSubOrder`
`lbp2_programappropriation`.`OfficeID`
`lbp2_programappropriation`.`OfficeName`
`lbp2_programappropriation`.`AccountId`
`lbp2_programappropriation`.`Account_Code`
`lbp2_programappropriation`.`AccountName`
`lbp2_programappropriation`.`UID`
`lbp2_programappropriation`.`ts`
`lbp2_programappropriation`.`Ordering`
`lbp2_programappropriation`.`byear`
`lbp2_programappropriation`.`expenseClass`
`lbp2_programappropriation`.`Description`
`lbp2_programappropriation`.`aCode`
`lbp2_programappropriation`.`Appropriation`
`lbp2_programappropriationx`.*
`lbp2_programappropriationx`.`ID`
`lbp2_programappropriationx`.`FUNDID`
`lbp2_programappropriationx`.`FundName`
`lbp2_programappropriationx`.`LBPType`
`lbp2_programappropriationx`.`CategoryId`
`lbp2_programappropriationx`.`Category`
`lbp2_programappropriationx`.`CategoryOrder`
`lbp2_programappropriationx`.`SubCategoryID`
`lbp2_programappropriationx`.`SubCategory`
`lbp2_programappropriationx`.`SubCategoryOrder`
`lbp2_programappropriationx`.`UnderSubID`
`lbp2_programappropriationx`.`UnderSubName`
`lbp2_programappropriationx`.`UnderSubOrder`
`lbp2_programappropriationx`.`OfficeID`
`lbp2_programappropriationx`.`OfficeName`
`lbp2_programappropriationx`.`AccountId`
`lbp2_programappropriationx`.`Account_Code`
`lbp2_programappropriationx`.`AccountName`
`lbp2_programappropriationx`.`UID`
`lbp2_programappropriationx`.`ts`
`lbp2_programappropriationx`.`Ordering`
`lbp2_programappropriationx`.`byear`
`lbp2_programappropriationx`.`expenseClass`
`lbp2_programappropriationx`.`Description`
`lbp2_programappropriationx`.`aCode`
`lbp2_programappropriationx`.`Appropriation`
`main_fund_account`.*
`main_fund_account`.`Id`
`main_fund_account`.`Description`
`main_fund_account_yearly`.*
`main_fund_account_yearly`.`Id`
`main_fund_account_yearly`.`MainId`
`main_fund_account_yearly`.`Description`
`main_fund_account_yearly`.`Year`
`main_fund_account_yearly`.`Budget`
`main_fund_account_yearly`.`Status`
`mapper`.*
`mapper`.`ID`
`mapper`.`agefrom`
`mapper`.`ageto`
`mapper`.`scorefrom`
`mapper`.`scoreto`
`migrationdata`.*
`migrationdata`.`Id`
`migrationdata`.`RECODE`
`migrationdata`.`TypeDescription`
`migrationdata`.`ExpenseClassID`
`migrationdata`.`OfficeID`
`migrationdata`.`OfficeCode`
`migrationdata`.`Office`
`migrationdata`.`Codes`
`migrationdata`.`Description`
`migrationdata`.`Appropriation`
`migrationdata`.`TotalAllotment`
`migrationdata`.`Obligation`
`migrationdata`.`isContinuing`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`obr`.*
`obr`.`ID`
`obr`.`OBRDate`
`obr`.`OBRNum`
`obr`.`Mnth`
`obr`.`Byear`
`obr`.`Payee`
`obr`.`Remarks`
`obr`.`DepartmentName`
`obr`.`DepartmentID`
`obr`.`Address`
`obr`.`A_ChargesToAppropriation`
`obr`.`A_SupportingDocument`
`obr`.`B_ExistenceofAvailableAppropriation`
`obr`.`A_CertifiedNameID`
`obr`.`A_CertifiedName`
`obr`.`A_Position`
`obr`.`A_Date`
`obr`.`B_CertifiedNameID`
`obr`.`B_CertifiedName`
`obr`.`B_Position`
`obr`.`B_Date`
`obr`.`Amount`
`obr`.`SourceofFund`
`obr`.`UID`
`obr`.`FundId`
`obr`.`poid`
`obr`.`ponum`
`obr`.`ProjectId`
`obr`.`ProjectRegId`
`obr`.`PowId`
`obr`.`ProjectName`
`obr`.`PowNo`
`obr`.`reference`
`obr`.`CancelledReason`
`obr`.`CancelledByID`
`obr`.`Status`
`obr`.`TS`
`obr`.`IsContinuing`
`obr`.`isPosted`
`obr_pr_approval`.*
`obr_pr_approval`.`ID`
`obr_pr_approval`.`Fund`
`obr_pr_approval`.`Appropriation`
`obr_pr_approval`.`AccountNum`
`obr_pr_approval`.`Allotment`
`obr_pr_approval`.`BalancePrevious`
`obr_pr_approval`.`MinusDisbursement`
`obr_pr_approval`.`BalancePresent`
`obr_pr_approval`.`VerifiedByID`
`obr_pr_approval`.`VerifiedByName`
`obr_pr_approval`.`Dates`
`obr_pr_approval`.`ActionTaken`
`obr_pr_approval`.`Signatory`
`obr_pr_approval`.`SignatoryID`
`obr_pr_approval`.`Positions`
`obr_pr_approval`.`TS`
`obr_pr_approval`.`PRID`
`obr_pr_approval`.`Status`
`obrdetail`.*
`obrdetail`.`ID`
`obrdetail`.`OBRID`
`obrdetail`.`AppropriationID`
`obrdetail`.`ACID`
`obrdetail`.`RespCode`
`obrdetail`.`RespID`
`obrdetail`.`AccountCode`
`obrdetail`.`AccountName`
`obrdetail`.`FPP`
`obrdetail`.`Amount`
`obrdetail`.`OBR_STAT`
`obrsignatoryentity`.*
`obrsignatoryentity`.`ID`
`obrsignatoryentity`.`DepartmentId`
`obrsignatoryentity`.`Types`
`obrsignatoryentity`.`EmployeeId`
`obrsignatoryentity`.`FullName`
`obrsignatoryentity`.`Position`
`otherdeductions_jo`.*
`otherdeductions_jo`.`OD_ID`
`otherdeductions_jo`.`OD_Name`
`otherdeductions_jo`.`OD_PriorityNo`
`otherdeductions_jo`.`OD_Status`
`otherdeductions_jo`.`OD_DateSaved`
`otherdeductions_jo`.`Deduction_Type`
`otherdeductions_jo`.`OD_AccountId`
`otherdeductions_jo`.`OD_PayeeId`
`pap_sector`.*
`pap_sector`.`ID`
`pap_sector`.`Name`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`payee`.*
`payee`.`ID`
`payee`.`PayeeName`
`payee`.`Status`
`payment_mode_setup`.*
`payment_mode_setup`.`id`
`payment_mode_setup`.`reference_no`
`payment_mode_setup`.`description`
`payment_mode_setup`.`remarks`
`payment_mode_setup`.`application_date`
`payment_mode_setup`.`status`
`pi_iventory_dtls`.*
`pi_iventory_dtls`.`id`
`pi_iventory_dtls`.`itm_id`
`pi_iventory_dtls`.`date`
`pi_iventory_dtls`.`qty`
`pi_iventory_dtls`.`branch_id`
`pi_iventory_main`.*
`pi_iventory_main`.`id`
`pi_iventory_main`.`date`
`pi_iventory_main`.`status`
`pmhistory`.*
`pmhistory`.`ID`
`pmhistory`.`AppropriationId`
`pmhistory`.`Yr`
`pmhistory`.`Description`
`pmhistory`.`userFullName`
`positions`.*
`positions`.`ID`
`positions`.`DeptID`
`positions`.`DeptName`
`positions`.`DisplayName`
`positions`.`PositionName`
`positions`.`TS`
`ppmp`.*
`ppmp`.`ID`
`ppmp`.`SOFID`
`ppmp`.`SOFDescription`
`ppmp`.`AccountID`
`ppmp`.`Account`
`ppmp`.`APPID`
`ppmp`.`DEPID`
`ppmp`.`DepartmentName`
`ppmp`.`YR`
`ppmp`.`ItemID`
`ppmp`.`ItemDescription`
`ppmp`.`Qty`
`ppmp`.`UoM`
`ppmp`.`Cost`
`ppmp`.`TotalCost`
`ppmp`.`ModeofProc`
`ppmp`.`Jan`
`ppmp`.`Feb`
`ppmp`.`mar`
`ppmp`.`Apr`
`ppmp`.`may`
`ppmp`.`Jun`
`ppmp`.`Jul`
`ppmp`.`Aug`
`ppmp`.`Sept`
`ppmp`.`Oct_`
`ppmp`.`Nov`
`ppmp`.`Dec_`
`ppmp`.`JanAmt`
`ppmp`.`FebAmt`
`ppmp`.`MarAmt`
`ppmp`.`AprAmt`
`ppmp`.`MayAmt`
`ppmp`.`JunAmt`
`ppmp`.`JulAmt`
`ppmp`.`AugAmt`
`ppmp`.`SeptAmt`
`ppmp`.`OctAmt`
`ppmp`.`NovAmt`
`ppmp`.`DecAmt`
`ppmp`.`UID`
`ppmp`.`ts`
`ppmp`.`ModeofEntry`
`projectmilestone`.*
`projectmilestone`.`id`
`projectmilestone`.`description`
`projectmilestone`.`isComplete`
`projectmilestone`.`projId`
`projectmilestone`.`Status`
`projectmilestone`.`orders`
`re_class`.*
`re_class`.`ID`
`re_class`.`SOFID`
`re_class`.`ParentID`
`re_class`.`Description`
`re_class`.`ShortName`
`re_class`.`ClassOrder`
`re_class`.`Types`
`re_class`.`Level`
`realignment`.*
`realignment`.`ID`
`realignment`.`BatchId`
`realignment`.`AppropriationId`
`realignment`.`AccountName`
`realignment`.`AccountCode`
`realignment`.`ResNo`
`realignment`.`ResDate`
`realignment`.`TransDate`
`realignment`.`Reference`
`realignment`.`BYear`
`realignment`.`OfficeID`
`realignment`.`OfficeName`
`realignment`.`FundId`
`realignment`.`FundName`
`realignment`.`ExpenseClassId`
`realignment`.`ExpenseClass`
`realignment`.`Amount`
`realignment`.`Remarks`
`realignment`.`User`
`realignment`.`Status`
`realignmentsource`.*
`realignmentsource`.`ID`
`realignmentsource`.`BatchId`
`realignmentsource`.`AppropriationId`
`realignmentsource`.`AccountName`
`realignmentsource`.`AccountCode`
`realignmentsource`.`ResNo`
`realignmentsource`.`ResDate`
`realignmentsource`.`TransDate`
`realignmentsource`.`Reference`
`realignmentsource`.`BYear`
`realignmentsource`.`OfficeID`
`realignmentsource`.`OfficeName`
`realignmentsource`.`FundId`
`realignmentsource`.`FundName`
`realignmentsource`.`ExpenseClassId`
`realignmentsource`.`ExpenseClass`
`realignmentsource`.`Amount`
`realignmentsource`.`Remarks`
`realignmentsource`.`User`
`realignmentsource`.`Status`
`realignmentsource`.`LessFromAllotment`
`realignmentsource`.`LessFromAppropriation`
`receiving_item`.*
`receiving_item`.`id`
`receiving_item`.`ref_no`
`receiving_item`.`trans_date`
`receiving_item`.`supplier_id`
`receiving_item`.`received_date`
`receiving_item`.`invoice_number`
`receiving_item`.`total_amount`
`receiving_item`.`ts`
`receiving_item`.`stats`
`receiving_item`.`branch_id`
`receiving_item_dtls`.*
`receiving_item_dtls`.`id`
`receiving_item_dtls`.`rev_id`
`receiving_item_dtls`.`itm_id`
`receiving_item_dtls`.`qty`
`receiving_item_dtls`.`price`
`receiving_item_dtls`.`selling_price`
`remittance_beg`.*
`remittance_beg`.`id`
`remittance_beg`.`sales_amount`
`remittance_beg`.`cashier_id`
`remittance_beg`.`ref_no`
`remittance_beg`.`drawer_amount`
`remittance_beg`.`cashonhand`
`remittance_beg`.`one_thousand`
`remittance_beg`.`five_hundred`
`remittance_beg`.`two_hundred`
`remittance_beg`.`one_hundred`
`remittance_beg`.`fifty`
`remittance_beg`.`twenty`
`remittance_beg`.`ten`
`remittance_beg`.`five`
`remittance_beg`.`one`
`remittance_beg`.`cent`
`remittance_beg`.`total`
`remittance_beg`.`overage_shortage`
`remittance_beg`.`status`
`remittance_beg`.`ts`
`remittance_main`.*
`remittance_main`.`id`
`remittance_main`.`sales_amount`
`remittance_main`.`cashier_id`
`remittance_main`.`ref_no`
`remittance_main`.`drawer_amount`
`remittance_main`.`cashonhand`
`remittance_main`.`one_thousand`
`remittance_main`.`five_hundred`
`remittance_main`.`two_hundred`
`remittance_main`.`one_hundred`
`remittance_main`.`fifty`
`remittance_main`.`twenty`
`remittance_main`.`ten`
`remittance_main`.`five`
`remittance_main`.`one`
`remittance_main`.`cent`
`remittance_main`.`total`
`remittance_main`.`overage_shortage`
`remittance_main`.`status`
`remittance_main`.`ts`
`reversal`.*
`reversal`.`ID`
`reversal`.`BatchId`
`reversal`.`TransDate`
`reversal`.`Reference`
`reversal`.`BYear`
`reversal`.`OfficeID`
`reversal`.`OfficeName`
`reversal`.`FundId`
`reversal`.`FundName`
`reversal`.`ExpenseClassName`
`reversal`.`ExpenseClassId`
`reversal`.`AppropriationId`
`reversal`.`AccountName`
`reversal`.`AccountCode`
`reversal`.`Appropriation`
`reversal`.`Balance`
`reversal`.`Reversal`
`reversal`.`Remarks`
`reversal`.`User`
`reversal`.`Status`
`sales_channel`.*
`sales_channel`.`id`
`sales_channel`.`description`
`sales_channel_setup`.*
`sales_channel_setup`.`id`
`sales_channel_setup`.`reference_no`
`sales_channel_setup`.`description`
`sales_channel_setup`.`remarks`
`sales_channel_setup`.`application_date`
`sales_channel_setup`.`status`
`sales_details`.*
`sales_details`.`id`
`sales_details`.`sales_id`
`sales_details`.`itm_id`
`sales_details`.`qty`
`sales_details`.`price`
`sales_details`.`charges`
`sales_details`.`charge_fee`
`sales_details`.`item_status`
`sales_details`.`remarks`
`sales_main`.*
`sales_main`.`id`
`sales_main`.`ref_no`
`sales_main`.`priority_num`
`sales_main`.`trans_date`
`sales_main`.`reservation_date`
`sales_main`.`customer_id`
`sales_main`.`customer_name`
`sales_main`.`payment_mode`
`sales_main`.`downpayment`
`sales_main`.`warranty`
`sales_main`.`trans_type`
`sales_main`.`table_id`
`sales_main`.`total_amount`
`sales_main`.`ts`
`sales_main`.`stat`
`sales_main`.`reservation`
`sales_main`.`discountType`
`sales_main`.`IDtype`
`sales_main`.`ID_num`
`sales_main`.`Cutting_fee`
`sales_main`.`del_Fee`
`sales_main`.`discount_amount`
`sales_main`.`total_payable`
`sales_main`.`cashpaid`
`sales_main`.`amount_paid`
`sales_main`.`uid`
`sales_main`.`person`
`sales_main`.`senior`
`sales_main`.`charge_to_owner`
`sales_main`.`change`
`sales_main`.`remarks`
`sales_main`.`remit_id`
`sales_main`.`cancelled_by`
`sales_main`.`branch_id`
`sales_main`.`entry_type`
`sales_payment`.*
`sales_payment`.`id`
`sales_payment`.`sales_id`
`sales_payment`.`total_amount`
`sales_payment`.`discountType`
`sales_payment`.`discount_amount`
`sales_payment`.`tableName`
`sales_payment`.`total_payable`
`sales_payment`.`amount_paid`
`sales_payment`.`change`
`sales_payment`.`ts`
`sales_payment`.`stats`
`sales_status`.*
`sales_status`.`id`
`sales_status`.`sales_id`
`sales_status`.`statusDescription`
`sales_status`.`ts`
`sales_table`.*
`sales_table`.`id`
`sales_table`.`tbl_name`
`sales_table`.`statx`
`sales_table`.`used`
`sectors`.*
`sectors`.`ID`
`sectors`.`Name`
`sef_budget`.*
`sef_budget`.`ID`
`sef_budget`.`SOF`
`sef_budget`.`AddRptTax`
`sef_budget`.`AddUnAppropriated`
`sef_budget`.`TotalEstimate`
`sef_budget`.`LessContinuing`
`sef_budget`.`NetAmount`
`sef_budget`.`BudgetType`
`sef_budget`.`Category`
`sef_budget`.`CategoryID`
`sef_budget`.`CategoryOrder`
`sef_budget`.`SubCategory`
`sef_budget`.`SubCategoryID`
`sef_budget`.`SubCategoryOrder`
`sef_budget`.`UnderSubName`
`sef_budget`.`UnderSubID`
`sef_budget`.`UnderSubOrder`
`sef_budget`.`BYear`
`sef_budget`.`DescriptionID`
`sef_budget`.`Description`
`sef_budget`.`Personal`
`sef_budget`.`maintenance`
`sef_budget`.`CO`
`sef_budget`.`FinancialExpenses`
`sef_budget`.`Total`
`sef_budget`.`UID`
`sef_budget`.`TS`
`sef_budget`.`Status`
`sef_budget`.`SG`
`sef_budget`.`Step`
`sef_budget`.`ApprovalStatus`
`sef_utilization`.*
`sef_utilization`.`ID`
`sef_utilization`.`ExpClass`
`sef_utilization`.`BudgetType`
`sef_utilization`.`CategoryID`
`sef_utilization`.`Category`
`sef_utilization`.`CategoryOrder`
`sef_utilization`.`SubCategoryID`
`sef_utilization`.`SubCategory`
`sef_utilization`.`SubCategoryOrder`
`sef_utilization`.`UnderSubID`
`sef_utilization`.`UnderSubName`
`sef_utilization`.`UnderSubOrder`
`sef_utilization`.`BYear`
`sef_utilization`.`DescriptionID`
`sef_utilization`.`Description`
`sef_utilization`.`Amount`
`sef_utilization`.`Jan`
`sef_utilization`.`Feb`
`sef_utilization`.`Mar`
`sef_utilization`.`Apr`
`sef_utilization`.`May`
`sef_utilization`.`Jun`
`sef_utilization`.`Jul`
`sef_utilization`.`Aug`
`sef_utilization`.`Sep`
`sef_utilization`.`Oct_`
`sef_utilization`.`Nov`
`sef_utilization`.`Dec_`
`sef_utilization`.`UID`
`sef_utilization`.`TS`
`sef_utilization`.`Status`
`sef_utilizationbeginning`.*
`sef_utilizationbeginning`.`ID`
`sef_utilizationbeginning`.`ExpClass`
`sef_utilizationbeginning`.`BudgetType`
`sef_utilizationbeginning`.`CategoryID`
`sef_utilizationbeginning`.`Category`
`sef_utilizationbeginning`.`CategoryOrder`
`sef_utilizationbeginning`.`SubCategoryID`
`sef_utilizationbeginning`.`SubCategory`
`sef_utilizationbeginning`.`SubCategoryOrder`
`sef_utilizationbeginning`.`UnderSubID`
`sef_utilizationbeginning`.`UnderSubName`
`sef_utilizationbeginning`.`UnderSubOrder`
`sef_utilizationbeginning`.`BYear`
`sef_utilizationbeginning`.`DescriptionID`
`sef_utilizationbeginning`.`Description`
`sef_utilizationbeginning`.`Amount`
`sef_utilizationbeginning`.`Jan`
`sef_utilizationbeginning`.`Feb`
`sef_utilizationbeginning`.`Mar`
`sef_utilizationbeginning`.`Apr`
`sef_utilizationbeginning`.`May`
`sef_utilizationbeginning`.`Jun`
`sef_utilizationbeginning`.`Jul`
`sef_utilizationbeginning`.`Aug`
`sef_utilizationbeginning`.`Sep`
`sef_utilizationbeginning`.`Oct_`
`sef_utilizationbeginning`.`Nov`
`sef_utilizationbeginning`.`Dec_`
`sef_utilizationbeginning`.`UID`
`sef_utilizationbeginning`.`TS`
`sef_utilizationbeginning`.`Status`
`sefmodel`.*
`sefmodel`.`ID`
`sefmodel`.`G1`
`sefmodel`.`G2`
`sefmodel`.`G3`
`sefmodel`.`BYEAR`
`sefmodel`.`OFFICECODE`
`sefmodel`.`OFFICE`
`sefmodel`.`CODE`
`sefmodel`.`DESCRIPTION`
`sefmodel`.`APPROPRIATION`
`sefmodel`.`TOTALALLOTMENT`
`sefmodel`.`APPROPRIATIONBALANCE`
`sefmodel`.`OBLIGATION`
`sefmodel`.`UNOBLIGATEDBALANCE`
`sefmodel`.`isContinuing`
`sefmodel`.`DeptId`
`sefmodel`.`SheetName`
`sefprogramdefault`.*
`sefprogramdefault`.`ID`
`sefprogramdefault`.`LBPType`
`sefprogramdefault`.`CategoryId`
`sefprogramdefault`.`Category`
`sefprogramdefault`.`CategoryOrder`
`sefprogramdefault`.`SubCategoryID`
`sefprogramdefault`.`SubCategory`
`sefprogramdefault`.`SubCategoryOrder`
`sefprogramdefault`.`UnderSubID`
`sefprogramdefault`.`UnderSubName`
`sefprogramdefault`.`UnderSubOrder`
`sefprogramdefault`.`OfficeID`
`sefprogramdefault`.`OfficeName`
`sefprogramdefault`.`Description`
`sefprogramdefault`.`UID`
`sefprogramdefault`.`ts`
`sefprogramdefault`.`Ordering`
`sefprogramdefault`.`FUNDID`
`sefprogramdefault`.`FUNDNAME`
`semester`.*
`semester`.`ID`
`semester`.`Description`
`semester`.`FromDate`
`semester`.`ToDate`
`settings`.*
`settings`.`ID`
`settings`.`ParentID`
`settings`.`Description`
`settings`.`Status`
`settings`.`TValue`
`setup_formtype`.*
`setup_formtype`.`id`
`setup_formtype`.`type`
`setup_formtype`.`status`
`setup_formtype`.`form_id`
`setup_item`.*
`setup_item`.`id`
`setup_item`.`thumPath`
`setup_item`.`imagePath`
`setup_item`.`ref_no`
`setup_item`.`itemName`
`setup_item`.`forKitchen`
`setup_item`.`forInvent`
`setup_item`.`shwMenu`
`setup_item`.`itemDescription`
`setup_item`.`price`
`setup_item`.`uom`
`setup_item`.`commision`
`setup_item`.`category_id`
`setup_item`.`item_group`
`setup_item`.`reorder_lvl`
`setup_item`.`stat`
`setup_item`.`ts`
`setup_item`.`cancelled_by`
`setup_item`.`main_id`
`setup_item`.`item_stat`
`setup_item`.`last_purchase_price`
`setup_item`.`branch_id`
`setup_item`.`withCommsn`
`setup_item_category`.*
`setup_item_category`.`id`
`setup_item_category`.`category_name`
`setup_item_category`.`stat`
`setup_item_category`.`ts`
`setup_item_category`.`cancelled_by`
`setup_item_category`.`sortby`
`setup_item_grouping`.*
`setup_item_grouping`.`id`
`setup_item_grouping`.`main_id`
`setup_item_grouping`.`itm_id`
`signatory`.*
`signatory`.`ID`
`signatory`.`_Type`
`signatory`.`Name`
`signatory`.`_Position`
`signatory_table`.*
`signatory_table`.`id`
`signatory_table`.`Signatory_desc`
`signatory_table`.`stat`
`signatoryentity`.*
`signatoryentity`.`ID`
`signatoryentity`.`FullName`
`signatoryentity`.`Position`
`signatoryentity`.`SigStatus`
`signatoryentity`.`DeptID`
`spa_services`.*
`spa_services`.`id`
`spa_services`.`Name`
`sub_classification_setup`.*
`sub_classification_setup`.`sub_classification_id`
`sub_classification_setup`.`sub_classification_name`
`sub_classification_setup`.`sub_subclass_id`
`sub_classification_setup`.`class_id`
`sub_classification_setup`.`sub_classification_code`
`sub_classification_setup`.`Subclassorders`
`sub_classification_setup`.`OWNERID`
`subcategory`.*
`subcategory`.`ID`
`subcategory`.`LBP`
`subcategory`.`CategoryID`
`subcategory`.`CategoryName`
`subcategory`.`Name`
`subcategory`.`ShortName`
`subcategory`.`Status`
`subcategory`.`Ordering`
`subcategory`.`ExpenseID`
`subsubcategory`.*
`subsubcategory`.`ID`
`subsubcategory`.`LBP`
`subsubcategory`.`CategoryID`
`subsubcategory`.`CategoryName`
`subsubcategory`.`SubCategoryID`
`subsubcategory`.`SubCategoryName`
`subsubcategory`.`Name`
`subsubcategory`.`Status`
`subsubcategory`.`Ordering`
`supplemental`.*
`supplemental`.`ID`
`supplemental`.`BatchId`
`supplemental`.`AppropriationId`
`supplemental`.`Account`
`supplemental`.`Code`
`supplemental`.`SortBy`
`supplemental`.`TransDate`
`supplemental`.`Reference`
`supplemental`.`BYear`
`supplemental`.`OfficeID`
`supplemental`.`OfficeName`
`supplemental`.`FundId`
`supplemental`.`FundName`
`supplemental`.`ExpenseClassId`
`supplemental`.`ExpenseClass`
`supplemental`.`Amount`
`supplemental`.`Remarks`
`supplemental`.`User`
`supplemental`.`Status`
`supplemental`.`OrdinanceNo`
`supplemental`.`OrdinanceDate`
`supplementalsources`.*
`supplementalsources`.`ID`
`supplementalsources`.`BatchId`
`supplementalsources`.`AppropriationId`
`supplementalsources`.`Account`
`supplementalsources`.`Code`
`supplementalsources`.`SortBy`
`supplementalsources`.`TransDate`
`supplementalsources`.`Reference`
`supplementalsources`.`BYear`
`supplementalsources`.`OfficeID`
`supplementalsources`.`OfficeName`
`supplementalsources`.`FundId`
`supplementalsources`.`FundName`
`supplementalsources`.`ExpenseClassId`
`supplementalsources`.`ExpenseClass`
`supplementalsources`.`Amount`
`supplementalsources`.`Remarks`
`supplementalsources`.`User`
`supplementalsources`.`Status`
`supplementalsources`.`OrdinanceNo`
`supplementalsources`.`OrdinanceDate`
`supplier_setup`.*
`supplier_setup`.`id`
`supplier_setup`.`reference_no`
`supplier_setup`.`supplier_name`
`supplier_setup`.`supplier_address`
`supplier_setup`.`application_date`
`supplier_setup`.`status`
`table_reservation`.*
`table_reservation`.`id`
`table_reservation`.`customer_name`
`table_reservation`.`table_no`
`table_reservation`.`ref_no`
`table_reservation`.`res_date`
`table_reservation`.`res_time`
`table_reservation`.`ts`
`table_reservation`.`res_status`
`table_reservation`.`status`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`mobile`
`users`.`approved`
`users`.`admin`
`users`.`cancel`
`users`.`branch_id`
`users`.`ts`
`wfp`.*
`wfp`.`ID`
`wfp`.`BatchGUID`
`wfp`.`budgetYear`
`wfp`.`DepartmentId`
`wfp`.`SectorId`
`wfp`.`Category`
`wfp`.`SubCategory`
`wfp`.`PPA`
`wfp`.`RespPerson`
`wfp`.`Appropriation`
`wfp`.`Utilization`
`wfp`.`Proposed`
`wfp`.`Particulars`
`wfp`.`ExpenseClassId`
`wfp`.`FundingSourceId`
`wfp`.`Output`
`wfp`.`Outcome`
`wfp`.`Target`
`wfp`.`Accomplishment`
`wfp`.`Status`
`wfp`.`ItemOrder`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
_columns
accountbudget
accountbudget_copy
accountclass
accountclass_budget
accountrevision
accounts_parents
accountutilization
accountutilizationbeginning
acctdummy
additionalbudget
adjustment_minus
adjustment_plus
aipentry
aipentry_utilization
allotmentrelease
allowances_jo
appplan
appsignatories
apv_number
atc_setup
atc_tax_rate
bank_recon_records
beginning_temp
bill_series
billing_monitoring
billing_others
billingrecord
bislig_petty_liquidate
bislig_system
bisligpetty
board_directors
branch_setup
breakdowngroup
budget_setup
budget_setup_dtl
budget_signatory
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
cash_advances
cashall
cashliquidation
cashvoucher_series
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
check_monitoring
check_received_released_stat
checkdefaultsignatories
checkingaccountlog
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budget_account_columns
cto_budget_account_columns_main
cto_budget_beg_entry
cto_budget_category_none_ppmp
cto_budget_mode_pro
cto_budget_none_ppmp
cto_budget_none_ppmp_dtls
cto_budget_none_ppmp_dtls_temp
cto_budget_ppmp
cto_budget_ppmp_dtls
cto_budget_ppmp_dtls_temp
cto_budget_res_series
cto_budget_source_fund
cto_budget_type
cto_budgett_revision_setup
cto_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
cust_adv_refund_log
customer_setup
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
cwip_logs
debits_actual_deducted
defaultbank
defaults_accounts
depreciationaccounts
discount_type
division_setup
drivers_profile
dummy_table
epense_type
expense_item_dtls
expense_main
failed_jobs
form_name
form_profile
form_profile_access
form_user_profile
hide_amount
incomesource
installment_provider_setup
inventory_master
inventory_transfer
lbp2_programappropriation
lbp2_programappropriationx
main_fund_account
main_fund_account_yearly
mapper
migrationdata
migrations
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
obr
obr_pr_approval
obrdetail
obrsignatoryentity
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
re_class
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sef_budget
sef_utilization
sef_utilizationbeginning
sefmodel
sefprogramdefault
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatory_table
signatoryentity
spa_services
sub_classification_setup
subcategory
subsubcategory
supplemental
supplementalsources
supplier_setup
table_reservation
user_logs
users
wfp
SQL query on database
budget
:
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.