saldo_buku_besar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(16) | No | ||||
| tahun | int(11) | No | ||||
| kode_buku_besar | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| s_aw_d | decimal(18,2) | No | 0.00 | |||
| s_aw_k | decimal(18,2) | No | 0.00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 355 | A | No |
saldo_buku_pembantu
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(16) | No | ||||
| tahun | int(11) | No | ||||
| kode | varchar(15) | No | ||||
| kode_buku_besar | varchar(10) | No | ||||
| kode_buku_pembantu | varchar(10) | No | ||||
| nama_buku_pembantu | text | No | ||||
| s_aw_d | decimal(18,2) | No | 0.00 | |||
| s_aw_k | decimal(18,2) | No | 0.00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 973 | A | No |
setting
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tahun | int(11) | No | ||||
| bulan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
setting_keu
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tahun | int(11) | No | ||||
| bulan | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
tabel_admin
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_admin (Primary) | int(4) | No | ||||
| nama | varchar(20) | No | ||||
| username | varchar(20) | No | ||||
| password | varchar(50) | No | ||||
| tanggal | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_admin | 2 | A | No |
tabel_buku_besar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kode_buku_besar (Primary) | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| msk_keu | varchar(1) | No | n | y(ya)/n(tidak) | ||
| kode_bukti | varchar(2) | No | - |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | kode_buku_besar | 73 | A | No |
tabel_buku_pembantu
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kode (Primary) | varchar(15) | No | ||||
| kode_buku_besar | varchar(10) | No | ||||
| kode_buku_pembantu | varchar(10) | No | ||||
| nama_buku_pembantu | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | kode | 246 | A | No |
tabel_profil
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| nama_perusahaan | varchar(30) | No | ||||
| gedung | varchar(30) | No | ||||
| jalan | varchar(30) | No | ||||
| kelurahan | varchar(30) | No | ||||
| kecamatan | varchar(30) | No | ||||
| kabupaten | varchar(30) | No | ||||
| propinsi | varchar(15) | No | ||||
| negara | varchar(15) | No | ||||
| telpon | varchar(12) | No | ||||
| fax | varchar(12) | No | ||||
| varchar(30) | No | |||||
| website | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
transaksi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| input_by | varchar(1) | No | k(keuangan)/p(posting) | |||
| tanggal | date | No | ||||
| tahun | int(11) | No | ||||
| bulan | int(11) | No | ||||
| no_bukti | varchar(22) | No | ||||
| kode_bukti | varchar(22) | No | ||||
| tipe_transaksi | varchar(1) | No | k(keluar)/m(masuk)/o(memorial)/a(ajustment) | |||
| kode_buku_besar | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| kode_buku_pembantu | varchar(15) | No | - | |||
| nama_buku_pembantu | text | No | ||||
| nama | text | No | ||||
| nc_d | decimal(18,2) | No | 0.00 | |||
| nc_k | decimal(18,2) | No | 0.00 | |||
| rl_d | decimal(18,2) | No | 0.00 | |||
| rl_k | decimal(18,2) | No | 0.00 | |||
| posting | varchar(1) | No | n | y(ya)/n(tidak) | ||
| foto | varchar(225) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 43470 | A | No |
transaksi_awal_adjustment
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tanggal | date | No | ||||
| no_bukti | varchar(22) | No | ||||
| tipe_transaksi | varchar(1) | No | ||||
| kode_buku_besar | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| kode_buku_pembantu | varchar(15) | No | ||||
| nama_buku_pembantu | text | No | ||||
| nama | text | No | ||||
| debet | decimal(18,2) | No | 0.00 | |||
| kredit | decimal(18,2) | No | 0.00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
transaksi_awal_editan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| input_by | varchar(1) | No | k=kasir;p=postingan | |||
| tanggal | date | No | ||||
| no_bukti | varchar(22) | No | ||||
| tipe_transaksi | varchar(1) | No | ||||
| kode_buku_besar | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| kode_buku_pembantu | varchar(15) | No | ||||
| nama_buku_pembantu | text | No | ||||
| nama | text | No | ||||
| debet | decimal(18,2) | No | 0.00 | |||
| kredit | decimal(18,2) | No | 0.00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
transaksi_awal_memorial
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tanggal | date | No | ||||
| no_bukti | varchar(22) | No | ||||
| tipe_transaksi | varchar(1) | No | ||||
| kode_buku_besar | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| kode_buku_pembantu | varchar(15) | No | ||||
| nama_buku_pembantu | text | No | ||||
| nama | text | No | ||||
| debet | decimal(18,2) | No | 0.00 | |||
| kredit | decimal(18,2) | No | 0.00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
transaksi_awal_posting
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tanggal | date | No | ||||
| no_bukti | varchar(22) | No | ||||
| tipe_transaksi | varchar(1) | No | k(keluar)/m(masuk) | |||
| kode_buku_besar | varchar(10) | No | ||||
| nama_buku_besar | text | No | ||||
| kode_buku_pembantu | varchar(15) | No | ||||
| nama_buku_pembantu | text | No | ||||
| nama | text | No | ||||
| nominal | decimal(18,2) | No | 0.00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |