🗄️ Database Explorer
dengan Relasi
🔗 Relasi Tabel: supplier
💡 Klik tombol Lihat Relasi di bawah untuk melihat data dari tabel terkait.
📊 Tabel: supplier
3 baris
| supplier_code |
supplier_name |
street |
city |
prov |
zip |
country_code |
phone |
fax |
email |
web_address |
npwp |
supplier_status |
description |
last_update_by |
last_update_date |
last_ip_address |
| 01 |
FORTUNE AC |
|
|
|
|
ID |
|
|
|
|
|
|
|
admin |
2021-02-07 09:10:39 |
127.0.0.1 |
| 03 |
TR TECH |
|
|
|
|
ID |
|
|
|
|
|
|
|
admin |
2021-12-23 13:47:21 |
127.0.0.1 |
| 02 |
Graha Denso |
Cibubur point automotive centre ruko blok d no.12a |
Jakarta |
|
|
ID |
84593238 |
|
|
|
|
|
|
andrew |
2007-07-22 04:45:42 |
127.0.0.1 |
🔗 Data Relasi: buy
| supplier_code |
invoice_no |
invoice_date |
container_no |
in_date |
total_price |
discount |
total_price_after_discount |
ppn_percent |
faktur_code |
faktur_date |
pay_status |
pay_date |
status |
status_date |
issued_code |
description |
last_update_by |
last_update_date |
last_ip_address |
| 01 |
00001 |
2021-02-07 |
00001 |
2021-02-07 |
450000 |
0.00 |
450000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-07 |
|
|
admin |
2021-02-07 15:00:03 |
127.0.0.1 |
| 01 |
00002 |
2021-02-01 |
00002 |
2021-02-07 |
100000 |
0.00 |
100000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-01 |
|
|
admin |
2021-02-07 15:00:01 |
127.0.0.1 |
| 01 |
00003 |
2021-02-07 |
00003 |
2021-02-07 |
9110000 |
0.00 |
9110000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-07 |
|
|
admin |
2021-02-07 14:59:58 |
127.0.0.1 |
| 01 |
00004 |
2021-02-07 |
00004 |
2021-02-07 |
1675000 |
0.00 |
1675000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-07 |
|
|
admin |
2021-02-07 14:59:55 |
127.0.0.1 |
| 01 |
00005 |
2021-02-07 |
00005 |
2021-02-07 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-07 |
|
|
admin |
2021-02-07 14:59:51 |
127.0.0.1 |
| 01 |
00008 |
2021-02-09 |
00008 |
2021-02-09 |
650000 |
0.00 |
650000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-09 |
|
|
admin |
2021-02-10 09:38:14 |
127.0.0.1 |
| 01 |
00007 |
2021-02-07 |
00007 |
2021-02-07 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-07 |
|
|
admin |
2021-02-07 14:59:53 |
127.0.0.1 |
| 01 |
00009 |
2021-02-10 |
00009 |
2021-02-10 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-10 |
|
|
admin |
2021-02-10 09:38:28 |
127.0.0.1 |
| 01 |
00010 |
2021-02-10 |
00010 |
2021-02-10 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-10 |
|
|
admin |
2021-02-14 10:14:52 |
127.0.0.1 |
| 01 |
00011 |
2021-02-11 |
00011 |
2021-02-11 |
100000 |
0.00 |
100000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-11 |
|
|
admin |
2021-02-14 10:14:54 |
127.0.0.1 |
| 01 |
00012 |
2021-02-12 |
00012 |
2021-02-12 |
500000 |
0.00 |
500000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-12 |
|
|
admin |
2021-02-14 10:14:56 |
127.0.0.1 |
| 01 |
00013 |
2021-02-13 |
00013 |
2021-02-13 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-13 |
|
|
admin |
2021-02-14 10:14:46 |
127.0.0.1 |
| 01 |
00014 |
2021-02-14 |
00014 |
2021-02-14 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-14 |
|
|
admin |
2021-02-20 16:22:44 |
127.0.0.1 |
| 01 |
00015 |
2021-02-14 |
00015 |
2021-02-14 |
135500 |
0.00 |
135500 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-14 |
|
|
admin |
2021-02-20 16:22:46 |
127.0.0.1 |
| 01 |
00016 |
2021-02-15 |
00016 |
2021-02-15 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-15 |
|
|
admin |
2021-02-20 16:22:49 |
127.0.0.1 |
| 01 |
00017 |
2021-02-15 |
00017 |
2021-02-15 |
4100000 |
0.00 |
4100000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-15 |
|
|
admin |
2021-02-20 16:22:49 |
127.0.0.1 |
| 01 |
00018 |
2021-02-18 |
00018 |
2021-02-18 |
90000 |
0.00 |
90000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-18 |
|
|
admin |
2021-02-20 16:22:54 |
127.0.0.1 |
| 01 |
00019 |
2021-02-18 |
00019 |
2021-02-18 |
2708000 |
0.00 |
2708000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-18 |
|
|
admin |
2021-02-20 16:22:56 |
127.0.0.1 |
| 01 |
00020 |
2021-02-19 |
00020 |
2021-02-19 |
140000 |
0.00 |
140000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-19 |
|
|
admin |
2021-02-20 16:23:01 |
127.0.0.1 |
| 01 |
00021 |
2021-02-19 |
00021 |
2021-02-19 |
850000 |
0.00 |
850000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-19 |
|
|
admin |
2021-02-20 16:23:02 |
127.0.0.1 |
| 01 |
00022 |
2021-02-19 |
00022 |
2021-02-19 |
90000 |
0.00 |
90000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-19 |
|
|
admin |
2021-02-20 16:23:06 |
127.0.0.1 |
| 01 |
00023 |
2021-02-20 |
00023 |
2021-02-20 |
800000 |
0.00 |
800000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-20 |
|
|
admin |
2021-02-20 16:22:18 |
127.0.0.1 |
| 01 |
00024 |
2021-02-20 |
00024 |
2021-02-20 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-20 |
|
|
admin |
2021-02-20 16:23:10 |
127.0.0.1 |
| 01 |
00025 |
2021-02-21 |
00025 |
2021-02-21 |
1900000 |
0.00 |
1900000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-21 |
|
|
admin |
2021-04-07 16:02:51 |
127.0.0.1 |
| 01 |
00162 |
2021-05-03 |
00163 |
2021-05-03 |
700000 |
0.00 |
700000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-05-03 |
|
|
admin |
2021-05-07 14:48:44 |
127.0.0.1 |
| 01 |
00027 |
2021-02-22 |
00027 |
2021-02-22 |
100000 |
0.00 |
100000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-22 |
|
|
admin |
2021-04-07 16:02:56 |
127.0.0.1 |
| 01 |
00161 |
2021-05-03 |
00162 |
2021-05-03 |
200000 |
0.00 |
200000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-05-03 |
|
|
admin |
2021-05-07 14:48:39 |
127.0.0.1 |
| 01 |
00029 |
2021-02-22 |
00029 |
2021-02-22 |
400000 |
0.00 |
400000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-22 |
|
|
admin |
2021-04-07 16:03:01 |
127.0.0.1 |
| 01 |
00030 |
2021-02-23 |
00030 |
2021-02-23 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-23 |
|
|
admin |
2021-04-07 16:03:03 |
127.0.0.1 |
| 01 |
00032 |
2021-02-23 |
00032 |
2021-02-23 |
675000 |
0.00 |
675000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-23 |
|
|
admin |
2021-04-07 16:03:09 |
127.0.0.1 |
| 01 |
00033 |
2021-02-24 |
00033 |
2021-02-24 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-24 |
|
|
admin |
2021-04-07 16:03:13 |
127.0.0.1 |
| 01 |
00034 |
2021-02-24 |
00034 |
2021-02-24 |
2050000 |
0.00 |
2050000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-24 |
|
|
admin |
2021-04-07 16:03:14 |
127.0.0.1 |
| 01 |
00035 |
2021-02-26 |
00035 |
2021-02-26 |
450000 |
0.00 |
450000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-26 |
|
|
admin |
2021-04-07 16:03:18 |
127.0.0.1 |
| 01 |
00036 |
2021-02-27 |
00036 |
2021-02-27 |
650000 |
0.00 |
650000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-27 |
|
|
admin |
2021-04-07 16:03:18 |
127.0.0.1 |
| 01 |
00037 |
2021-02-27 |
00037 |
2021-02-27 |
800000 |
0.00 |
800000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-02-27 |
|
|
admin |
2021-04-07 16:03:22 |
127.0.0.1 |
| 01 |
00040 |
2021-03-01 |
00040 |
2021-03-01 |
250000 |
0.00 |
250000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-01 |
|
|
admin |
2021-04-07 16:03:35 |
127.0.0.1 |
| 01 |
00039 |
2021-03-01 |
00039 |
2021-03-01 |
800000 |
0.00 |
800000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-01 |
|
|
admin |
2021-04-07 16:03:29 |
127.0.0.1 |
| 01 |
00041 |
2021-03-01 |
00041 |
2021-03-01 |
20000 |
0.00 |
20000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-01 |
|
|
admin |
2021-04-07 16:03:36 |
127.0.0.1 |
| 01 |
00042 |
2021-03-02 |
00042 |
2021-03-02 |
825000 |
0.00 |
825000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-02 |
|
|
admin |
2021-04-07 16:03:41 |
127.0.0.1 |
| 01 |
00043 |
2021-03-03 |
00043 |
2021-03-03 |
112500 |
0.00 |
112500 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-03 |
|
|
admin |
2021-04-07 16:03:46 |
127.0.0.1 |
| 01 |
00044 |
2021-03-03 |
00044 |
2021-03-03 |
100000 |
0.00 |
100000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-03 |
|
|
admin |
2021-04-07 16:04:34 |
127.0.0.1 |
| 01 |
00045 |
2021-03-03 |
00045 |
2021-03-03 |
600000 |
0.00 |
600000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-03 |
|
|
admin |
2021-04-07 16:04:38 |
127.0.0.1 |
| 01 |
00046 |
2021-03-03 |
00046 |
2021-03-03 |
800000 |
0.00 |
800000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-03 |
|
|
admin |
2021-04-07 16:04:41 |
127.0.0.1 |
| 01 |
00047 |
2021-03-04 |
00047 |
2021-03-04 |
50000 |
0.00 |
50000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-04 |
|
|
admin |
2021-04-07 16:04:44 |
127.0.0.1 |
| 01 |
00048 |
2021-03-04 |
00048 |
2021-03-04 |
650000 |
0.00 |
650000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-04 |
|
|
admin |
2021-04-07 16:04:48 |
127.0.0.1 |
| 01 |
00049 |
2021-03-05 |
00049 |
2021-03-05 |
550000 |
0.00 |
550000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-05 |
|
|
admin |
2021-04-07 16:04:51 |
127.0.0.1 |
| 01 |
00050 |
2021-03-06 |
00050 |
2021-03-06 |
290000 |
0.00 |
290000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-06 |
|
|
admin |
2021-04-07 16:04:55 |
127.0.0.1 |
| 01 |
00051 |
2021-03-07 |
00051 |
2021-03-07 |
105000 |
0.00 |
105000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-07 |
|
|
admin |
2021-04-07 16:04:57 |
127.0.0.1 |
| 01 |
00052 |
2021-03-07 |
00052 |
2021-03-07 |
2080000 |
0.00 |
2080000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-07 |
|
|
admin |
2021-04-07 16:05:00 |
127.0.0.1 |
| 01 |
00053 |
2021-03-08 |
00053 |
2021-03-08 |
20000 |
0.00 |
20000 |
0.00 |
|
0000-00-00 |
|
0000-00-00 |
2 |
2021-03-08 |
|
|
admin |
2021-04-07 16:05:04 |
127.0.0.1 |
Database: u621414011_backup | Total tabel: 40