Recent
`documenttracker`.`it_preventive_maintenance`
`general`.`systemprofileforms`
`documenttracker`.`documentfiles`
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
Query window
*
ID
ParentId
AppropriationID
DepartmentId
SOFID
BYear
Description1
Description2
Amount
Amount2
Amount3
AllotmentReleased
SupplementalAmt
RealignmentAmt
Expense_Class_id
Expense_Class
Status
SOF
Category
CategoryID
CategoryOrder
SubCategory
SubCategoryID
SubCategoryOrder
UnderSubName
UnderSubID
UnderSubOrder
DescriptionID2
DescriptionID1
isContinuing
UID
TS
ApprovalStatus
StartDate
EndDate
WFPID
BudgetType
ORNo
ProjectName
projectId
Purposed
SheetName
devremarks
*
ID
ParentId
AppropriationID
DepartmentId
SOFID
BYear
Description1
Description2
Amount
Amount2
Amount3
AllotmentReleased
SupplementalAmt
RealignmentAmt
Expense_Class_id
Expense_Class
Status
SOF
Category
CategoryID
CategoryOrder
SubCategory
SubCategoryID
SubCategoryOrder
UnderSubName
UnderSubID
UnderSubOrder
DescriptionID2
DescriptionID1
isContinuing
UID
TS
ApprovalStatus
StartDate
EndDate
WFPID
BudgetType
ORNo
ProjectName
projectId
Purposed
SheetName
*
ID
LBP
ParentID
description
AccountId
Code
Level
status
*
ID
AppropId
byear
deptId
Amount
*
Id
SOF
BudgetType
BYear
DepartmentId
Acid
AccountDescription
Amount
UID
TS
Status
Revision
OrigAmt
*
ID
GID
ACID
GEN_NAMES
account_code
account_description
CLASSIFICATION
SUBLASS
t_account
GEN_CODE
CLASSIFICATION_CODE
SUBCLASS_CODE
markcontra
ACCOUNT_SPACE
*
Id
AppropriationID
OBRID
SOFID
DepartmentId
BYear
RespCenterId
RespCenterName
Amount
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Octo
Nov
Dece
UID
TS
Status
sheetName
ManualEntryGUID
Acode
*
Id
AppropriationID
SOF
BudgetType
BYear
DepartmentId
ACID
_Code
Description
Amount
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
UID
TS
Status
*
ID
Amount4
*
ID
sofId
appropriationId
Btype
GUID
Yr
OfficeID
OfficeName
ACID
Code
Account
PrevBalance
AdditionalAmt
NewBudget
Remarks
UID
TS
Status
*
ID
BatchId
AppropriationId
Account
Code
SortBy
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassId
ExpenseClass
Amount
Remarks
User
Status
OrdinanceNo
OrdinanceDate
*
ID
BatchId
AppropriationId
Account
Code
SortBy
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassId
ExpenseClass
Amount
Remarks
User
Status
OrdinanceNo
OrdinanceDate
*
ID
SOFID
SOF
StartDate
EndDate
OfficeID
OfficeName
grouping
SectorID
Sector
accountID
AppopriationID
Account
Year
Code
Description
MOOE
CO
Amount
groupid
GroupName
YearCount
class1
class2
class3
UID
Status
WFPID
TS
*
ID
AIPID
SOFID
SOF
StartDate
EndDate
OfficeID
OfficeName
SectorId
Sector
AppopriationID
Account
Year
Code
Description
MOOE
CO
ActualMOOE
ActualCO
UID
TS
*
ID
FullAroNum
ARODate
CategoryID
Category
BYEAR
officeID
ppaCode
appropriationId
AccountID
AccountDescription
FundID
FundCode
FundName
BudgetSource
objectclass_AccountCode
objectclass_AccountCodeId
Appropriation
ReleasedAmt
purpose
UID
ts
LastEntry
Quarter_
Status
BatchGUID
*
allowance_id
allowance_name
allowance_status
account_id
allowance_type
*
ID
ItemClass
BudTypeID
BudType
SOFID
SOFDescription
ACID
Account
PPMPID
GUID
DateSubmitted
DepartmentID
DepartmentName
BYear
AppropriatedAmt
Contigency
NetAmt
ControlNum
UID
TS
ItemID
Description
Qty
UoM
UnitPrice
TotalCost
FQty
FAmount
SQty
SAmount
TQty
TAmount
FRQty
FRAmount
*
ID
DepartmentID
SigType
Signame
Position
UID
*
ID
JID
APVNUM
LOC
TITLE
YYYY
PO
INV
GRPS
*
ID
DESCRIPTION
Goodservice
ATC
RATE
ACID
CID
*
ID
ATC
Rate
*
ID
GRP
ACCOUNTID
SAVE_DATE
ReportedBankBalance
AmountBeforeRecon
asofdate
GUID
ReconDates
*
ID
ACID
CODE
DESCRIPTION
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
YR
GID
GID1
ACCOUNTSPACE
MAINID
OFFICE
COST_CENTER
DRCR
SUBTYPE
ISBANK
*
ID
equipmentID
BILL_NO
CUSTOMER
LOCATION
TITLEID
FL
CTYPE
trans_date
reference
start_time
end_time
unit
rate
location_frm
location_to
REMARKS
TRIPS_NUM
KM
TS
JID
GUID
UID
dispatchid
refnum
operators
DTLS
EQUIPMENT
DEPARTMENT
DEPID
entry_date
ITEMDESCRIPTION
*
bill_id
bill_projectNo
bill_projectname
bill_requesteddate
bill_requestpercentage
bill_requestdetails
bill_requestamount
bill_requestremarks
bill_date
bill_percentage
bill_details
bill_amount
bill_recoupment
bill_vat2
bill_vat5
bill_others
bill_incometax1
bill_royalty
bill_birdue
bill_bonds
bill_otherssubcon
bill_amountNet
bill_remarks
saved_date
bill_actualAccomplished
bill_subcon
PROJECT_ID
RETENTION
JID
*
ID
JID
DTL_ID
ACCOUNT_ID
AMOUNT
ORNUM
ORDATE
BLID
ACCOUNT_DESC
CONTAINER
CID
*
ID
Year
series
titleid
JID
ref
SUBID
tstamp
*
ID
EMPID
TDATE
REF
AMT
RELEASEDBY
STATUS
TS
LOCATION
CANCEL_reason
memo
custodian
supervisor
*
ID
ReleasedID
EMPID
TS
STATUS
LIQ_JID
GRP
*
id
company_name
address
logo_name
photo
*
ID
dates
costcenter
resolutionApproved
policiesPass
DirectorsFee
Held
regular
special
seminar
ts
uid
STATUS
GID
*
id
reference_no
branch_name
branch_address
application_date
status
*
ID
ParentID
Description
Status
*
ID
budgetType
Yr
OfficeId
Status
*
Id
ClosingDate
ClosedByName
*
ID
groupid
GroupName
TypeofBudget
BYear
DescriptionID
Description
AppropriationID
ACID
ACID_Description
DepartmentID
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
*
ID
Group
DescriptionID
Description
Positions
BYear
ACID
TypeofBudget
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
Total
DepartmentID
SG
Step
UID
PositionID
*
ID
Description
*
id
class
subclass
account
year
jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
location
division
titleID
identification
*
dtl_id
budget_id
year
month
type
cash_flow
item_type
item_id
item_description
item_display_name
transaction_type
expense_type
cost_type
quantity
unit_measure
unit_cost
no_of_person
total_amount
purpose
status
save_date
title_id
location_id
division_id
account_id
*
Signatory_ID
Signatory_Name
Signatory_Position
Signatory_Position_id
Signatory_PP_ID
department_id
status
*
ID
JOURNAL_ID
DRCR
*
CLRFNumber
CLEmpName
CLProjCode
CLProjName
CLLocation
CLDate
CLAmount
CLPeriodfrom
CLPeriodto
CLGrossAmount
sss
hdmf
cassd
metrobank
bdo
*
id
JID
cv
COMPANY
YEAR
TSTAMP
groupentry
*
SysPK_CshAdv
SysFK_Empl_CshAdv
UserCode_CshAdv
Name_CshAdv
DateTrans_CshAdv
Amount_CshAdv
Balance_CshAdv
Terms_CshAdv
AmortAmount_CshAdv
Remarks_CshAdv
Description_CshAdv
CompanyCode
ProjectCode
deductionType
EMP_ID
*
ID
REF_OLD
OLD_JID
REF_NEW
JID
DATE_LIQ
EMPID
MEMO
AMOUNT
UID
status
CV
tstamp
GROUP
CASL_GUID
RELASED_ID
*
ID
JID
CUSTID
ACCOUNTID
SHIPPING
AMOUNT
ORNUM
DATE_PAID
CONTAINER
PROCESSOR
TSTAMP
status
CASL_GUID
*
id
journal_details_id
TIN
REMARKS
INV_NUM
Suppliername
SUPID
JID
caslID
*
ID
JID
GROUPS
*
ID
JID
REF
GUID
DATES
EMPID
MEMOS
AMOUNT
UID
status
tstamp
COMPANYCODE
DEPTCODE
CASH_ACID
FUND_LOC
LOCATION_
PAYEE_ID
NAME_TYPES
*
ID
ParentID
LBP
Name
Status
Ordering
ExpenseClass
*
ID
CF_NAME
STATUS
ORDER
TYPE
FLOW
*
ID
NAMES1
POSITIONS1
NAMES2
POSITIONS2
*
ID
JID
ACID
BANK_NAME
CHECKNUMBER
CHECKDATES
PAYEE
PAYEEID
Groups
USERSID
CVNUMBER
*
ID
CDATE
ARRIVAL
PAYEEID
CONSIGNEEID
CHECK_NUM
C_VOUCHER
BL
PURPOSE_OF_PAYMENT
RECEIVEDBY
AMOUNT
CONTAINER
MC_FEE
BP
STATUS
title_id
MC_CHECK
LOGBY
REMOVEDBY
*
ID
JID
status
RELEASED_DATE
UID
RECEIVEDBY
REMARKS
REFERENCE
TSTAMP
CHK_TYPE
groups
*
id
code
short_description
full_description
group
cash_flow
type
status
OWNERID
classOrders
*
ID
CUSTID
CONTAINER
BL
ARRIVAL
AMOUNT
DATEFAX
CHECK_NUM
DATEPAID
TSTAMP
STATUS
CLEARED
REMARKS
JOURNAL_ID
*
ID
DEDUCIONID
ACID
AMT
JID
GID
TS
JDTL
*
ID
dateLog
usercloseEntry
remarks
Location
titleID
EMPNAME
Journal_id
User_syspkID
Status
ReopenBy
datesaved
*
ID
dateLog
usercloseEntry
remarks
Location
titleID
EMPNAME
Journal_id
User_syspkID
Status
ReopenBy
datesaved
*
ID
SHIPPINGID
CUSTID
CONTAINERNUM
BL
CONTAINER_DEPO
DATE_REC
REF_AMOUNT
REF_CHECK_NO
REF_DATE
DET_AMOUNT
DET_BILLING
CTS_AMOUNT
CTS_DATE_PAID
CTS_OR
ATS_AMOUNT
ATS_DATE_PAID
ATS_OR
DOCD_AMOUNT
DOCD_BILLING
DOCD_OR
CFC_AMOUNT
CFC_SOA
CFC_CHECK
CFC_COLLECTED
CFC_COLLECTED_DATE
RBTR_AMOUNT
RBTR_CHECK
RBTR_COLLECTED
RBTR_DATE
REMARKS
TS
UID
*
Id
OfficeCode
Office
OfficeId
SOFID
SOF
BudgetType
SubOfficeCode
SubOffice
ExpenseClassId
ExpDescription
ExpCode
AccountCode
Description
Appropriation
TotalAllotment
AppropriationBalance
Obligation
UnobligatedBalance
*
Id
accountType
TypeDescription
ExpenseClassID
OfficeID
OfficeCode
AccountCode
Description
Amount
*
id
desc
*
id
accnt_id
col_name
def_val
col_id
col_num
operation
calc_col
data_type
status
*
id
from_tbl
dept_query
*
id
accnt_id
dept_id
year
app_last_year
expended_last_year
app_cur_year
expended_first_9_month
anticipated_expenditure
app_next_year
*
id
desc
*
id
mode_pro_desc
status
xx
*
id
budget_year
dept_id
account_id
remarks
source_fund
status
display_detail
type
date_created
charge_dep_id
*
dtl_id
ledger_type
main_id
trans_id
emp_id
deptid
col1
col2
col3
col4
col5
col6
col7
col8
jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
type
util
revision
savedate
status
*
dtl_id
ledger_type
main_id
trans_id
deptid
emp_id
col1
col2
col3
col4
col5
col6
col7
col8
jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
type
revision
util
savedate
status
chk
*
id
budget_year
dept_id
account_id
remarks
mode_pro
source_fund
Pre_Proc_Conference
Ads_Post_of_IAEB
Pre_bid_Con
Eligibility_Check
Sub_Open_of_Bids
Bid_Evaluation
Post_Qual
Notice_of_Award
Contract_Signing
Notice_to_Proceed
Delivery_Completion
Acceptance_Turnover
status
display_detail
type
date_created
*
dtl_id
main_id
item_id
qty
unit
cost
amont
remarks
status
type
revision
01_qty
01_cost
01_amt
02_qty
02_cost
02_amt
03_qty
03_cost
03_amt
04_qty
04_cost
04_amt
05_qty
05_cost
05_amt
06_qty
06_cost
06_amt
07_qty
07_cost
07_amt
08_qty
08_cost
08_amt
09_qty
09_cost
09_amt
10_qty
10_cost
10_amt
11_qty
11_cost
11_amt
12_qty
12_cost
12_amt
savedate
ISGROUP
*
id
main_id
item_id
qty
unit
cost
amont
remarks
status
type
revision
01_qty
01_cost
01_amt
02_qty
02_cost
02_amt
03_qty
03_cost
03_amt
04_qty
04_cost
04_amt
05_qty
05_cost
05_amt
06_qty
06_cost
06_amt
07_qty
07_cost
07_amt
08_qty
08_cost
08_amt
09_qty
09_cost
09_amt
10_qty
10_cost
10_amt
11_qty
11_cost
11_amt
12_qty
12_cost
12_amt
savedate
chk
*
id
resolution_num
series_num
*
id
source_fund_desc
status
MainID
*
id
description
*
SysPK_fund_setup
fund_code
fund_description
status
*
id
ref_no
accntable_prson
receive_by
date
tmestamp
status
*
id
main_id
type
amount
pieces
total
*
ID
CID
JID
Amount
Reference_no
USERID
*
ID
CID
custName
Amount
dates
Businesstype
Location
TitleID
*
ID
CID
BP
Amount
UID
Remarks
*
ID
JID
CID
REF
Amount
*
SysPKID
pp_person_code
application_date
pp_student_no
pp_prefix
pp_lastname
pp_firstname
pp_middlename
pp_suffix
gender
dob
civil_stat
cellno
phoneno
nationality
religion
spouseOccupation
spouse
mother_name
mother_cellno
father_name
father_cellno
email_add
address
purok_id
barangay_id
municipal_id
province_id
save_by
update_by
cancelled_by
status
ts
*
ID
DATE
FROM
TO
SUBJECT
MONTH
BILL
CONTAINER
REMARKS
TOTAL_LIQ
ADV
TSTAMP
refund_id
*
ID
WIP_NAME
WIP_STAT
START
END
ADDRESS
REMARKS
ts
Types
OFFICEID
contractorid
agencyid
contract_amount
ACIDS
*
ID
JID
AMOUNT
STATUS
TS
GUID
*
ID
ACID_
TITLEID
location
*
ID
CIB
CASL
CASSD
RECEIVABLE
PAYABLE
PETTY
ADVANCES_FRM_AFF
ADVANCES_TO_AFF
ADVANCES_FRM_CUST
COMPANYID
ADV_TO_SUP
PETTY_CASH_CUSTODIAN
DUE_TO_EMP
OFFICE
DUID
UNDEPOFUND
SRV_INC
RETAINEDEARNINGS
BIRID
INPUTTAX
*
ID
account_id
PPEID
Loc
TItleID
accounts
accumid
*
id
discount_name
valuex
typex
*
division_id
division_code
division_name
title_id
division_code1
project_id
status
savedate
userid
*
id
driver_fullname
address
contact_no
age
civil_stat
license_no
height
weight
status
*
id
hour
*
id
desc
stat
*
id
exp_id
itm_id
qty
price
selling_price
*
id
ref_no
trans_date
trans_no
type
ref_id
total_amount
ts
status
branch_id
*
id
uuid
connection
queue
payload
exception
failed_at
*
id
module
grouping
form_name
file_route
access
*
id
profile_name
stat
*
id
profile_id
file_route
access
*
id
uid
profile_id
*
id
*
ID
DescriptionID1
Description1
Description2
IncomeType
FundId
Status
Amount
date_source
*
SysPKID
application_date
pp_no
name
cellno
phoneno
email_add
address
save_by
update_by
cancelled_by
status
ts
*
id
transID
transDtlID
transName
transNum
itemid
io
qty
unitcost
imeiNo
branchid
status
guid
ts
*
ID
trans_no
trans_date
ref_no
from_Id
to_Id
status
created
created_by
*
ID
FUNDID
FundName
LBPType
CategoryId
Category
CategoryOrder
SubCategoryID
SubCategory
SubCategoryOrder
UnderSubID
UnderSubName
UnderSubOrder
OfficeID
OfficeName
AccountId
Account_Code
AccountName
UID
ts
Ordering
byear
expenseClass
Description
aCode
Appropriation
*
ID
FUNDID
FundName
LBPType
CategoryId
Category
CategoryOrder
SubCategoryID
SubCategory
SubCategoryOrder
UnderSubID
UnderSubName
UnderSubOrder
OfficeID
OfficeName
AccountId
Account_Code
AccountName
UID
ts
Ordering
byear
expenseClass
Description
aCode
Appropriation
*
Id
Description
*
Id
MainId
Description
Year
Budget
Status
*
ID
agefrom
ageto
scorefrom
scoreto
*
Id
RECODE
TypeDescription
ExpenseClassID
OfficeID
OfficeCode
Office
Codes
Description
Appropriation
TotalAllotment
Obligation
isContinuing
*
id
migration
batch
*
id
user_id
client_id
name
scopes
revoked
created_at
updated_at
expires_at
*
id
user_id
client_id
scopes
revoked
expires_at
*
id
user_id
name
secret
provider
redirect
personal_access_client
password_client
revoked
created_at
updated_at
*
id
client_id
created_at
updated_at
*
id
access_token_id
revoked
expires_at
*
ID
OBRDate
OBRNum
Mnth
Byear
Payee
Remarks
DepartmentName
DepartmentID
Address
A_ChargesToAppropriation
A_SupportingDocument
B_ExistenceofAvailableAppropriation
A_CertifiedNameID
A_CertifiedName
A_Position
A_Date
B_CertifiedNameID
B_CertifiedName
B_Position
B_Date
Amount
SourceofFund
UID
FundId
poid
ponum
ProjectId
ProjectRegId
PowId
ProjectName
PowNo
reference
CancelledReason
CancelledByID
Status
TS
IsContinuing
isPosted
*
ID
OBRID
AppropriationID
ACID
RespCode
RespID
AccountCode
AccountName
FPP
Amount
OBR_STAT
*
ID
DepartmentId
Types
EmployeeId
FullName
Position
*
ID
Fund
Appropriation
AccountNum
Allotment
BalancePrevious
MinusDisbursement
BalancePresent
VerifiedByID
VerifiedByName
Dates
ActionTaken
Signatory
SignatoryID
Positions
TS
PRID
Status
*
OD_ID
OD_Name
OD_PriorityNo
OD_Status
OD_DateSaved
Deduction_Type
OD_AccountId
OD_PayeeId
*
ID
Name
*
email
token
created_at
*
ID
PayeeName
Status
*
id
reference_no
description
remarks
application_date
status
*
id
itm_id
date
qty
branch_id
*
id
date
status
*
ID
AppropriationId
Yr
Description
userFullName
*
ID
DeptID
DeptName
DisplayName
PositionName
TS
*
ID
SOFID
SOFDescription
AccountID
Account
APPID
DEPID
DepartmentName
YR
ItemID
ItemDescription
Qty
UoM
Cost
TotalCost
ModeofProc
Jan
Feb
mar
Apr
may
Jun
Jul
Aug
Sept
Oct_
Nov
Dec_
JanAmt
FebAmt
MarAmt
AprAmt
MayAmt
JunAmt
JulAmt
AugAmt
SeptAmt
OctAmt
NovAmt
DecAmt
UID
ts
ModeofEntry
*
id
description
isComplete
projId
Status
orders
*
ID
BatchId
AppropriationId
AccountName
AccountCode
ResNo
ResDate
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassId
ExpenseClass
Amount
Remarks
User
Status
*
ID
BatchId
AppropriationId
AccountName
AccountCode
ResNo
ResDate
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassId
ExpenseClass
Amount
Remarks
User
Status
LessFromAllotment
LessFromAppropriation
*
id
ref_no
trans_date
supplier_id
received_date
invoice_number
total_amount
ts
stats
branch_id
*
id
rev_id
itm_id
qty
price
selling_price
*
id
sales_amount
cashier_id
ref_no
drawer_amount
cashonhand
one_thousand
five_hundred
two_hundred
one_hundred
fifty
twenty
ten
five
one
cent
total
overage_shortage
status
ts
*
id
sales_amount
cashier_id
ref_no
drawer_amount
cashonhand
one_thousand
five_hundred
two_hundred
one_hundred
fifty
twenty
ten
five
one
cent
total
overage_shortage
status
ts
*
ID
BatchId
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassName
ExpenseClassId
AppropriationId
AccountName
AccountCode
Appropriation
Balance
Reversal
Remarks
User
Status
*
ID
SOFID
ParentID
Description
ShortName
ClassOrder
Types
Level
*
id
description
*
id
reference_no
description
remarks
application_date
status
*
id
sales_id
itm_id
qty
price
charges
charge_fee
item_status
remarks
*
id
ref_no
priority_num
trans_date
reservation_date
customer_id
customer_name
payment_mode
downpayment
warranty
trans_type
table_id
total_amount
ts
stat
reservation
discountType
IDtype
ID_num
Cutting_fee
del_Fee
discount_amount
total_payable
cashpaid
amount_paid
uid
person
senior
charge_to_owner
change
remarks
remit_id
cancelled_by
branch_id
entry_type
*
id
sales_id
total_amount
discountType
discount_amount
tableName
total_payable
amount_paid
change
ts
stats
*
id
sales_id
statusDescription
ts
*
id
tbl_name
statx
used
*
ID
Name
*
ID
G1
G2
G3
BYEAR
OFFICECODE
OFFICE
CODE
DESCRIPTION
APPROPRIATION
TOTALALLOTMENT
APPROPRIATIONBALANCE
OBLIGATION
UNOBLIGATEDBALANCE
isContinuing
DeptId
SheetName
*
ID
LBPType
CategoryId
Category
CategoryOrder
SubCategoryID
SubCategory
SubCategoryOrder
UnderSubID
UnderSubName
UnderSubOrder
OfficeID
OfficeName
Description
UID
ts
Ordering
FUNDID
FUNDNAME
*
ID
SOF
AddRptTax
AddUnAppropriated
TotalEstimate
LessContinuing
NetAmount
BudgetType
Category
CategoryID
CategoryOrder
SubCategory
SubCategoryID
SubCategoryOrder
UnderSubName
UnderSubID
UnderSubOrder
BYear
DescriptionID
Description
Personal
maintenance
CO
FinancialExpenses
Total
UID
TS
Status
SG
Step
ApprovalStatus
*
ID
ExpClass
BudgetType
CategoryID
Category
CategoryOrder
SubCategoryID
SubCategory
SubCategoryOrder
UnderSubID
UnderSubName
UnderSubOrder
BYear
DescriptionID
Description
Amount
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct_
Nov
Dec_
UID
TS
Status
*
ID
ExpClass
BudgetType
CategoryID
Category
CategoryOrder
SubCategoryID
SubCategory
SubCategoryOrder
UnderSubID
UnderSubName
UnderSubOrder
BYear
DescriptionID
Description
Amount
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct_
Nov
Dec_
UID
TS
Status
*
ID
Description
FromDate
ToDate
*
ID
ParentID
Description
Status
TValue
*
id
type
status
form_id
*
id
thumPath
imagePath
ref_no
itemName
forKitchen
forInvent
shwMenu
itemDescription
price
uom
commision
category_id
item_group
reorder_lvl
stat
ts
cancelled_by
main_id
item_stat
last_purchase_price
branch_id
withCommsn
*
id
category_name
stat
ts
cancelled_by
sortby
*
id
main_id
itm_id
*
ID
_Type
Name
_Position
*
ID
FullName
Position
SigStatus
DeptID
*
id
Signatory_desc
stat
*
id
Name
*
ID
LBP
CategoryID
CategoryName
Name
ShortName
Status
Ordering
ExpenseID
*
ID
LBP
CategoryID
CategoryName
SubCategoryID
SubCategoryName
Name
Status
Ordering
*
sub_classification_id
sub_classification_name
sub_subclass_id
class_id
sub_classification_code
Subclassorders
OWNERID
*
ID
BatchId
AppropriationId
Account
Code
SortBy
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassId
ExpenseClass
Amount
Remarks
User
Status
OrdinanceNo
OrdinanceDate
*
ID
BatchId
AppropriationId
Account
Code
SortBy
TransDate
Reference
BYear
OfficeID
OfficeName
FundId
FundName
ExpenseClassId
ExpenseClass
Amount
Remarks
User
Status
OrdinanceNo
OrdinanceDate
*
id
reference_no
supplier_name
supplier_address
application_date
status
*
id
customer_name
table_no
ref_no
res_date
res_time
ts
res_status
status
*
id
name
email
email_verified_at
password
remember_token
created_at
updated_at
mobile
approved
admin
cancel
branch_id
ts
*
id
uid
IPX
MAC
ts
*
ID
BatchGUID
budgetYear
DepartmentId
SectorId
Category
SubCategory
PPA
RespPerson
Appropriation
Utilization
Proposed
Particulars
ExpenseClassId
FundingSourceId
Output
Outcome
Target
Accomplishment
Status
ItemOrder
*
id
column_name
display_col
status
type
liquidate
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
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
billingrecord
billing_monitoring
billing_others
bill_series
bisligpetty
bislig_petty_liquidate
bislig_system
board_directors
branch_setup
breakdowngroup
budgetappropriationstatus
budgetclosing
budgetdetail
budgetdetail_plantilla
budgetsourcedescription
budget_setup
budget_setup_dtl
budget_signatory
cashall
cashliquidation
cashvoucher_series
cash_advances
casl_liq
casl_liq_br
casl_liq_details
casl_refund_list
casl_released
category
cf_description
checkdefaultsignatories
checkingaccountlog
check_monitoring
check_received_released_stat
classification_setup
clearing_cust_advanc_pay
clev_deductions
closing_appro
closing_entry
container_monitoring
continuingmigration
continuings
cto_budgett_revision_setup
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_fund_setup
cto_transaction_partial_deposit
cto_transaction_partial_deposit_dtl
customeradvancedeductionlogs
customeradvances
customeradvanceslog
customersl_log
customer_setup
cust_adv_refund_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
obrdetail
obrsignatoryentity
obr_pr_approval
otherdeductions_jo
pap_sector
password_resets
payee
payment_mode_setup
pi_iventory_dtls
pi_iventory_main
pmhistory
positions
ppmp
projectmilestone
realignment
realignmentsource
receiving_item
receiving_item_dtls
remittance_beg
remittance_main
reversal
re_class
sales_channel
sales_channel_setup
sales_details
sales_main
sales_payment
sales_status
sales_table
sectors
sefmodel
sefprogramdefault
sef_budget
sef_utilization
sef_utilizationbeginning
semester
settings
setup_formtype
setup_item
setup_item_category
setup_item_grouping
signatory
signatoryentity
signatory_table
spa_services
subcategory
subsubcategory
sub_classification_setup
supplemental
supplementalsources
supplier_setup
table_reservation
users
user_logs
wfp
_columns
.
select column
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.