nota_jual varchar(20)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
tgl_jual date
CURRENT_DATE
CURRENT_TIME
DATE
FROM_DAYS
FROM_UNIXTIME
LAST_DAY
NOW
SEC_TO_TIME
SYSDATE
TIME
TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
YEAR
--------
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_USER
DATABASE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
TAN
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
nip char(20)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
- - - 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)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
Fremdschlüsselwerte ansehen nm_pasien varchar(50)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
keterangan varchar(40)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
jns_jual enum --
Jual Bebas
Karyawan
Beli Luar
Rawat Jalan
Kelas 1
Kelas 2
Kelas 3
Utama/BPJS
VIP
VVIP
ongkir double
ABS
ACOS
ASCII
ASIN
ATAN
BIT_LENGTH
BIT_COUNT
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
HOUR
INET6_ATON
INET_ATON
LENGTH
LN
LOG
LOG2
LOG10
MICROSECOND
MINUTE
MONTH
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SIGN
SIN
SQRT
TAN
TO_DAYS
TO_SECONDS
TIME_TO_SEC
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
--------
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
FROM_DAYS
FROM_UNIXTIME
HEX
INET6_NTOA
INET_NTOA
LAST_DAY
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
NOW
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SEC_TO_TIME
SHA1
SOUNDEX
SPACE
SYSDATE
TIME
TIMESTAMP
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
VERSION
YEAR
ppn double
ABS
ACOS
ASCII
ASIN
ATAN
BIT_LENGTH
BIT_COUNT
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
HOUR
INET6_ATON
INET_ATON
LENGTH
LN
LOG
LOG2
LOG10
MICROSECOND
MINUTE
MONTH
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SIGN
SIN
SQRT
TAN
TO_DAYS
TO_SECONDS
TIME_TO_SEC
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEARWEEK
--------
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
FROM_DAYS
FROM_UNIXTIME
HEX
INET6_NTOA
INET_NTOA
LAST_DAY
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
NOW
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SEC_TO_TIME
SHA1
SOUNDEX
SPACE
SYSDATE
TIME
TIMESTAMP
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
VERSION
YEAR
status enum --
Belum Dibayar
Sudah Dibayar
kd_bangsal char(5)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
- - - 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)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
Fremdschlüsselwerte ansehen nama_bayar varchar(50)
AES_DECRYPT
AES_ENCRYPT
BIN
CHAR
COMPRESS
CURRENT_USER
DATABASE
DAYNAME
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
HEX
INET6_NTOA
INET_NTOA
LOAD_FILE
LOWER
LTRIM
MD5
MONTHNAME
OLD_PASSWORD
PASSWORD
QUOTE
REVERSE
RTRIM
SHA1
SOUNDEX
SPACE
TRIM
UNCOMPRESS
UNHEX
UPPER
USER
UUID
VERSION
--------
ABS
ACOS
ASCII
ASIN
ATAN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR_LENGTH
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
DATE
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
INET6_ATON
INET_ATON
LAST_DAY
LENGTH
LN
LOG
LOG10
LOG2
MICROSECOND
MINUTE
MONTH
NOW
OCT
ORD
PI
QUARTER
RADIANS
RAND
ROUND
SECOND
SEC_TO_TIME
SIGN
SIN
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNCOMPRESSED_LENGTH
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID_SHORT
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
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