bicson.lalskomputer.my.id / 127.0.0.1 / idm_b / tbv_rekap_tr_ic

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`).
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.

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.

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.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Column	Type	Collation
IdRekap	int(11)
IdDetail	int(11)
IdKaryawan	int(11)
NIK	varchar(50)	latin1_swedish_ci
Nama	varchar(255)	latin1_swedish_ci
IdBaseKaryawan	int(11)
BaseKaryawan	varchar(255)	latin1_swedish_ci
NoPol	varchar(50)	latin1_swedish_ci
Kendaraan	set('-', 'Motor', 'Mobil')	latin1_swedish_ci
Tanggal	date
Tujuan	varchar(255)	latin1_swedish_ci
IdToko	int(11)
KdToko	varchar(10)	latin1_swedish_ci
NamaToko	varchar(255)	latin1_swedish_ci
IdBaseToko	int(11)
BaseToko	varchar(255)	latin1_swedish_ci
Posko	varchar(255)	latin1_swedish_ci
Perhitungan	varchar(14)	utf8mb4_general_ci
Lintas	text	latin1_swedish_ci
Komp_KM	decimal(4,1)
KM_Sebenarnya	decimal(20,1)
TotalJarak	decimal(21,1)
TotalRupiah	double(17,0)
FlagAudit	set('Y', 'N')	latin1_swedish_ci
Ket_Audit	varchar(50)	latin1_swedish_ci
TanggalAudit	datetime
Struk	bigint(20)
Merk	varchar(255)	latin1_swedish_ci
RegDate	datetime
SO_TERAKHIR	date
SO_LALU	date
FLAG_AUDIT	varchar(5)	utf8mb4_general_ci
REF	varchar(70)	latin1_swedish_ci

Column

Type

Collation

Operator

Value

IdRekap

int(11)

IdDetail

int(11)

IdKaryawan

int(11)

NIK

varchar(50)

latin1_swedish_ci

Nama

varchar(255)

latin1_swedish_ci

IdBaseKaryawan

int(11)

BaseKaryawan

varchar(255)

latin1_swedish_ci

NoPol

varchar(50)

latin1_swedish_ci

Kendaraan

set('-', 'Motor', 'Mobil')

latin1_swedish_ci

Tanggal

date

Tujuan

varchar(255)

latin1_swedish_ci

IdToko

int(11)

KdToko

varchar(10)

latin1_swedish_ci

NamaToko

varchar(255)

latin1_swedish_ci

IdBaseToko

int(11)

BaseToko

varchar(255)

latin1_swedish_ci

Posko

varchar(255)

latin1_swedish_ci

Perhitungan

varchar(14)

utf8mb4_general_ci

Lintas

text

latin1_swedish_ci

Komp_KM

decimal(4,1)

KM_Sebenarnya

decimal(20,1)

TotalJarak

decimal(21,1)

TotalRupiah

double(17,0)

FlagAudit

set('Y', 'N')

latin1_swedish_ci

Ket_Audit

varchar(50)

latin1_swedish_ci

TanggalAudit

datetime

Struk

bigint(20)

Merk

varchar(255)

latin1_swedish_ci

RegDate

datetime

SO_TERAKHIR

date

SO_LALU

date

FLAG_AUDIT

varchar(5)

utf8mb4_general_ci

REF

varchar(70)

latin1_swedish_ci

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

IdRekap
IdDetail
IdKaryawan
NIK
Nama
IdBaseKaryawan
BaseKaryawan
NoPol
Kendaraan
Tanggal
Tujuan
IdToko
KdToko
NamaToko
IdBaseToko
BaseToko
Posko
Perhitungan
Lintas
Komp_KM
KM_Sebenarnya
TotalJarak
TotalRupiah
FlagAudit
Ket_Audit
TanggalAudit
Struk
Merk
RegDate
SO_TERAKHIR
SO_LALU
FLAG_AUDIT
REF

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Range search