nota_jual
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_jual
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nip
char(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - 013 - 013 123 - 123 012345678 - 012345678 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 201201013 - 201201013 201305014 - 201305014 201408015 - 201408015 201703019 - 201703019 201704020 - 201704020 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202302045 - 202302045 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D000009 - D000009 D08 - D08 - - - 013 - 013 123 - 123 012345678 - 012345678 200808006 - 200808006 200808007 - 200808007 200808009 - 200808009 201201013 - 201201013 201305014 - 201305014 201408015 - 201408015 201703019 - 201703019 201704020 - 201704020 201808025 - 201808025 201811026 - 201811026 201901028 - 201901028 202201035 - 202201035 202201044 - 202201044 202204036 - 202204036 202206040 - 202206040 202208042 - 202208042 202209043 - 202209043 202210044 - 202210044 202211039 - 202211039 202302045 - 202302045 202306049 - 202306049 202406052 - 202406052 202406053 - 202406053 202409054 - 202409054 202409056 - 202409056 202412057 - 202412057 202412058 - 202412058 202503059 - 202503059 D0000006 - D0000006 D0000007 - D0000007 D0000008 - D0000008 D000009 - D000009 D08 - D08
no_rkm_medis
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nm_pasien
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
keterangan
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jns_jual
enum('Jual Bebas', 'Karyawan', 'Beli Luar', 'Rawat Jalan', 'Kelas 1', 'Kelas 2', 'Kelas 3', 'Utama/BPJS', 'VIP', 'VVIP')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Jual Bebas
Karyawan
Beli Luar
Rawat Jalan
Kelas 1
Kelas 2
Kelas 3
Utama/BPJS
VIP
VVIP
ongkir
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ppn
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status
enum('Belum Dibayar', 'Sudah Dibayar')
latin1_swedish_ci
= != IS NULL IS NOT NULL
Belum Dibayar
Sudah Dibayar
kd_bangsal
char(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - AP - AP B0011 - B0011 B0012 - B0012 B0021 - B0021 B0026 - B0026 B0027 - B0027 B0028 - B0028 B0029 - B0029 B0030 - B0030 B0031 - B0031 KO - KO - - - AP - AP B0011 - B0011 B0012 - B0012 B0021 - B0021 B0026 - B0026 B0027 - B0027 B0028 - B0028 B0029 - B0029 B0030 - B0030 B0031 - B0031 KO - KO
kd_rek
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nama_bayar
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
1. Bayar Cash - 1. Bayar Cash 2. Bayar Via BRI Syariah - 2. Bayar Via BRI Syariah 3. Bayar Via Debit BCa - 3. Bayar Via Debit BCa 3. Transfer Mandiri - 3. Transfer Mandiri 4. Bayar VIa Bank BNI - 4. Bayar VIa Bank BNI 5. Kas Kecil - 5. Kas Kecil 6. BANK DKI - 6. BANK DKI 7. Bank BCA - 7. Bank BCA 1. Bayar Cash - 1. Bayar Cash 2. Bayar Via BRI Syariah - 2. Bayar Via BRI Syariah 3. Bayar Via Debit BCa - 3. Bayar Via Debit BCa 3. Transfer Mandiri - 3. Transfer Mandiri 4. Bayar VIa Bank BNI - 4. Bayar VIa Bank BNI 5. Kas Kecil - 5. Kas Kecil 6. BANK DKI - 6. BANK DKI 7. Bank BCA - 7. Bank BCA
