DAFTAR TABEL
Tabel 3.1 Kebutuhan User......................................................................................72 Tabel 3.2 Kebutuhan perangkat keras pada bagian desain ....................................74 Tabel 3.3 Kebutuhan perangkat keras pada bagian administrasi ...........................74 Tabel 3.4 Kebutuhan perangkat keras pada bagian kasir .......................................75 Tabel 3.5 Kebutuhan perangkat lunak pada bagian desain ....................................75 Tabel 3.6 Kebutuhan perangkat lunak pada bagian administrasi ...........................76 Tabel 3.7 Kebutuhan perangkat lunak pada bagian kasir ......................................76 Tabel 3.8 Spesifikasi Proses ................................................................................118 Tabel 3.9 Kamus Data Bagian ............................................................................181 Tabel 3.10 Kamus Data Jabatan. ..........................................................................173 Tabel 3.11 Kamus Data Pegawai.. .......................................................................173 Tabel 3.12 Kamus Data User ...............................................................................173 Tabel 3.13 Kamus Data Outlet .............................................................................174 Tabel 3.14 Kamus Data Tempat Kerja.................................................................174 Tabel 3.15 Kamus Data Pengrajin .......................................................................174 Tabel 3.16 Kamus Data Jenis Barang ..................................................................174 Tabel 3.17 Kamus Data Buyer .............................................................................174 Tabel 3.18 Kamus Data Jenis Pengeluaran ..........................................................175 Tabel 3.19 Kamus Data Barang ...........................................................................175 Tabel 3.20 Kamus Data Order .............................................................................175 Tabel 3.21 Kamus Data Rincian Order ................................................................175
ix
Tabel 3.22 Kamus Data Persetujuan Order ..........................................................175 Tabel 3.23 Kamus Data Pembayaran Order .........................................................176 Tabel 3.24 Kamus Data Penerimaan Order..........................................................176 Tabel 3.25 Kamus Data Harga Jual......................................................................176 Tabel 3.26 Kamus Data Persetujuan Harga Jual ..................................................176 Tabel 3.27 Kamus Data Update Stok ...................................................................177 Tabel 3.28 Kamus Data Pengiriman Barang ........................................................177 Tabel 3.29 Kamus Data Biaya Pengiriman Barang .............................................177 Tabel 3.30 Kamus Data Laporan Pengiriman Barang .........................................177 Tabel 3.31 Kamus Data Barang Hilang ...............................................................177 Tabel 3.32 Kamus Data penjualan .......................................................................178 Tabel 3.33 Kamus Data penjualan retail ..............................................................178 Tabel 3.34 Kamus Data penjualan grosir .............................................................178 Tabel 3.35 Kamus Data pembayaran ...................................................................178 Tabel 3.36 Kamus Data Retur ..............................................................................179 Tabel 3.37 Kamus Data barang yang ditukar .......................................................179 Tabel 3.38 Kamus Data penjualan bulanan..........................................................179 Tabel 3.39 Kamus Data penjualan tahunan..........................................................179 Tabel 3.40 Kamus Data pembayaran bulanan......................................................180 Tabel 3.41 Kamus Data pembayaran tahunan......................................................180 Tabel 3.42 Kamus Data Pengeluaran ...................................................................180 Tabel 3.43 Kamus Data Rekapitulasi Pengeluaran ..............................................180 Tabel 3.44 Kamus Data Rekapitulasi Pengeluaran Tahunan ...............................180
x
Tabel 3.45 Kamus Data Rekapitulasi Pengeluaran Bulanan ................................181 Tabel 3.46 Struktur Data Bagian ..........................................................................189 Tabel 3.47 Struktur Data Jabatan .........................................................................189 Tabel 3.48 Struktur Data Pegawai .......................................................................189 Tabel 3.49 Struktur Data User .............................................................................189 Tabel 3.50 Struktur Data Outlet ...........................................................................190 Tabel 3.51 Struktur Data Tempat Kerja (Kasir dan Penanggungjawab Outlet) ..190 Tabel 3.52 Struktur Data Pengrajin ......................................................................190 Tabel 3.53 Struktur Data Jenis Barang ................................................................190 Tabel 3.54 Struktur Data Buyer ...........................................................................190 Tabel 3.55 Struktur Data Jenis Pengeluaran ........................................................191 Tabel 3.56 Struktur Data Order ............................................................................191 Tabel 3.57 Struktur Data Rincian Order ..............................................................191 Tabel 3.58 Struktur Data Biaya Order .................................................................191 Tabel 3.59 Struktur Data Penerimaan Order ........................................................192 Tabel 3.60 Struktur Data Rincian Penerimaan Order ..........................................192 Tabel 3.61 Struktur Data Biaya Pengiriman ........................................................192 Tabel 3.62 Struktur Data Pengiriman Barang ......................................................192 Tabel 3.63 Struktur Data Rincian Pengiriman Barang.........................................193 Tabel 3.64 Struktur Data Penjualan .....................................................................193 Tabel 3.65 Struktur Data Rincian Penjualan ........................................................193 Tabel 3.66 Struktur Data Pembayaran Penjualan ................................................193 Tabel 3.67 Struktur Data Retur Barang................................................................194
xi
Tabel 3.68 Struktur Data Rincian Retur ...............................................................194 Tabel 3.69 Struktur Data Pengeluaran Rutin .......................................................194 Tabel 3.70 Struktur Data Barang .........................................................................195 Tabel 3.71 Struktur Data Barang Hilang..............................................................195 Tabel 3.72 Struktur Data History Harga ..............................................................195 Tabel 3.73 Struktur Data Stok Barang .................................................................195 Tabel 4.1 Kebutuhan Perangkat Keras .................................................................246 Tabel 4.2 Generate Tabel Bagian ........................................................................247 Tabel 4.3 Generate Tabel Jabatan........................................................................247 Tabel 4.4 Generate Tabel Pegawai ......................................................................248 Tabel 4.5 Generate Tabel User ............................................................................248 Tabel 4.6 Generate Tabel Outlet..........................................................................248 Tabel 4.7 Generate Tabel Tempat Kerja..............................................................248 Tabel 4.8 Generate Tabel Pengrajin ....................................................................249 Tabel 4.9 Generate Tabel Jenis Barang ...............................................................249 Tabel 4.10 Generate Tabel Buyer ........................................................................249 Tabel 4.11 Generate Tabel Jenis Pengeluaran .....................................................249 Tabel 4.12 Generate Tabel Order ........................................................................250 Tabel 4.13 Generate Tabel Rincian Order ...........................................................250 Tabel 4.14 Generate Tabel Biaya Order ..............................................................250 Tabel 4.15 Generate Tabel Penerimaan Order ....................................................251 Tabel 4.16 Generate Tabel Rincian Penerimaan Order .......................................251 Tabel 4.17 Generate Tabel Biaya Pengiriman .....................................................251
xii
Tabel 4.18 Generate Tabel Pengiriman Barang ...................................................251 Tabel 4.19 Generate Tabel Rincian Pengiriman Barang .....................................252 Tabel 4.20 Generate Tabel Rincian Penjualan ....................................................252 Tabel 4.21 Generate Tabel Penjualan ..................................................................253 Tabel 4.22 Generate Tabel Pembayaran Penjualan .............................................253 Tabel 4.23 Generate Tabel Retur Barang ............................................................254 Tabel 4.24 Generate Tabel Rincian Retur ...........................................................254 Tabel 4.25 Generate Tabel Pengeluaran Rutin ....................................................254 Tabel 4.26 Generate Tabel Barang ......................................................................255 Tabel 4.27 Generate Tabel barang Hilang ...........................................................255 Tabel 4.28 Generate Tabel Stok Barang ..............................................................255 Tabel 4.29 Generate Constraint...........................................................................256 Tabel 4.30 Inplementasi Form Untuk Bagian Kepegawaian ...............................259 Tabel 4.31 Inplementasi Form Untuk Bagian IT .................................................260 Tabel 4.32 Inplementasi Form Untuk Bagian Kepala Product Development ......260 Tabel 4.33 Inplementasi Form Untuk Bagian Administrasi Product Development261 Tabel 4.34 Inplementasi Form Untuk Bagian Kepala Gudang ............................262 Tabel 4.35 Inplementasi Form Untuk Bagian Administrasi Gudang ...................262 Tabel 4.36 Inplementasi Form Untuk Bagian Quality Control ............................263 Tabel 4.37 Inplementasi Form Untuk Bagian Kepala Marketing ........................263 Tabel 4.38 Inplementasi Form Untuk Bagian Administrasi Marketing ...............264 Tabel 4.39 Inplementasi Form Untuk Bagian Kepala Accounting ......................264 Tabel 4.40 Inplementasi Form Untuk Bagian Cost Accounting ..........................265
xiii
Tabel 4.41 Inplementasi Form Untuk Bagian Kas ...............................................265 Tabel 4.42 Inplementasi Form Untuk Bagian Desain ..........................................266 Tabel 4.43 Inplementasi Form Untuk Bagian Penanggung jawab Outlet ............267 Tabel 4.44 Inplementasi Form Untuk Bagian Kasir ............................................267 Tabel 4.45 Rencana Pengujian Sistem Informasi Pemesanan dan Penjualan produk Beserta Arus Kas di Sinopsis Clothing ................................................................269 Tabel 4.46 Pengujian Login Pegawai ..................................................................272 Tabel 4.47 Pengujian Tambah Data Bagian .........................................................273 Tabel 4.48 Pengujian Edit Data Bagian ...............................................................273 Tabel 4.49 Pengujian Cari Data Bagian ...............................................................274 Tabel 4.50 Pengujian Tambah Data Jabatan ........................................................274 Tabel 4.51 Pengujian Edit Data Jabatan ..............................................................275 Tabel 4.52 Pengujian Cari Data Jabatan ..............................................................275 Tabel 4.53 Pengujian Tambah Data Pegawai ......................................................276 Tabel 4.54 Pengujian Edit Data Pegawai .............................................................277 Tabel 4.55 Pengujian Cari Data Pegawai .............................................................278 Tabel 4.56 Pengujian Tambah Data User ............................................................278 Tabel 4.57 Pengujian Edit Data User ...................................................................279 Tabel 4.58 Pengujian Cari Data User ...................................................................280 Tabel 4.59 Pengujian Tambah Data Outlet ..........................................................280 Tabel 4.60 Pengujian Edit Data Outlet ................................................................281 Tabel 4.61 Pengujian Cari Data Outlet ................................................................281 Tabel 4.62 Pengujian Tambah Data Tempat Kerja ..............................................282
xiv
Tabel 4.63 Pengujian Edit Data Tempat Kerja ....................................................282 Tabel 4.64 Pengujian Tambah Data Pengrajin .....................................................283 Tabel 4.65 Pengujian Edit Data Pengrajin ...........................................................284 Tabel 4.66 Pengujian Cari Data Pengrajin ...........................................................285 Tabel 4.67 Pengujian Tambah Data Jenis Barang ...............................................285 Tabel 4.68 Pengujian Edit Data Jenis Barang ......................................................286 Tabel 4.69 Pengujian Cari Data Jenis Barang ......................................................286 Tabel 4.70 Pengujian Tambah Data Buyer ..........................................................287 Tabel 4.71 Pengujian Edit Data Buyer .................................................................287 Tabel 4.72 Pengujian Cari Data Buyer ................................................................288 Tabel 4.73 Pengujian Tambah Data Jenis Pengeluaran .......................................288 Tabel 4.74 Pengujian Edit Data Jenis Pengeluaran ..............................................289 Tabel 4.75 Pengujian Cari Data Jenis Pengeluaran .............................................290 Tabel 4.76 Pengujian Tambah Data Pengajuan Barang .......................................290 Tabel 4.77 Pengujian Tambah Data Persetujuan Pengajuan Barang ...................291 Tabel 4.78 Pengujian Data Order .........................................................................291 Tabel 4.79 Pengujian Data Rincian Order ...........................................................292 Tabel 4.80 Pengujian Data Penerimaan Order .....................................................293 Tabel 4.81 Pengujian Data Rincian Penerimaan Order .......................................294 Tabel 4.82 Pengujian Data Pembayaran Order ....................................................294 Tabel 4.83 Pengujian Data Quality Control .........................................................295 Tabel 4.84 Pengujian Data Penentuan Harga Jual ...............................................296 Tabel 4.85 Pengujian Data Persetujuan Penentuan Harga Jual............................296
xv
Tabel 4.86 Pengujian Data Pengiriman Barang ...................................................297 Tabel 4.87 Pengujian Data Penerimaan Barang Di Outlet ...................................298 Tabel 4.88 Pengujian Data Penjualan Retail ........................................................298 Tabel 4.89 Pengujian Data Penjualan Grosir .......................................................299 Tabel 4.90 Pengujian Data Penjualan Grosir .......................................................300 Tabel 4.91 Pengujian Data Retur Grosir ..............................................................301 Tabel 4.92 Pengujian Data Pengeluaran Rutin ....................................................301 Tabel 4.93 Pengujian Data Laporan Order ..........................................................302 Tabel 4.94 Pengujian Data Laporan Penerimaan Order.......................................303 Tabel 4.95 Pengujian Data Laporan Pengiriman Barang .....................................304 Tabel 4.96 Pengujian Data Laporan Pembayaran Order ......................................304 Tabel 4.97 Pengujian Data Laporan Penjualan ....................................................305 Tabel 4.98 Pengujian Data Laporan Pengeluaran ................................................306 Tabel 4.99 Pengujian Data Arus Kas ...................................................................306 Tabel 4.100 Pengujian Monitoring Informasi Produksi .......................................307 Tabel 4.101 Pengujian Monitoring Informasi Penjualan .....................................307 Tabel 4.102 Pengujian Monitoring Informasi Stok .............................................308 Tabel 4.103 Pengujian Monitoring Informasi Arus Kas ......................................309
xvi
