kode_brng
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_brng
varchar(80)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kode_satbesar
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - AMP - AMP AMP2 - AMP2 BKS - BKS BOX - BOX BTL - BTL CAP - CAP CM - CM CRM - CRM DRP - DRP Fle - Fle GAR - GAR GEL - GEL GLN - GLN INF - INF Item - Item KAL - KAL KAP - KAP KG - KG LBR - LBR Lus - Lus MG - MG MIN - MIN ML - ML PAC - PAC PCS - PCS PEN - PEN PUY - PUY REC - REC REM - REM RIM - RIM S02 - S02 S32 - S32 S35 - S35 S36 - S36 S37 - S37 S38 - S38 S45 - S45 S47 - S47 S48 - S48 SAC - SAC SAL - SAL SET - SET SUP - SUP SYR - SYR TAB - TAB TUB - TUB VL - VL - - - AMP - AMP AMP2 - AMP2 BKS - BKS BOX - BOX BTL - BTL CAP - CAP CM - CM CRM - CRM DRP - DRP Fle - Fle GAR - GAR GEL - GEL GLN - GLN INF - INF Item - Item KAL - KAL KAP - KAP KG - KG LBR - LBR Lus - Lus MG - MG MIN - MIN ML - ML PAC - PAC PCS - PCS PEN - PEN PUY - PUY REC - REC REM - REM RIM - RIM S02 - S02 S32 - S32 S35 - S35 S36 - S36 S37 - S37 S38 - S38 S45 - S45 S47 - S47 S48 - S48 SAC - SAC SAL - SAL SET - SET SUP - SUP SYR - SYR TAB - TAB TUB - TUB VL - VL
kode_sat
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - AMP - AMP AMP2 - AMP2 BKS - BKS BOX - BOX BTL - BTL CAP - CAP CM - CM CRM - CRM DRP - DRP Fle - Fle GAR - GAR GEL - GEL GLN - GLN INF - INF Item - Item KAL - KAL KAP - KAP KG - KG LBR - LBR Lus - Lus MG - MG MIN - MIN ML - ML PAC - PAC PCS - PCS PEN - PEN PUY - PUY REC - REC REM - REM RIM - RIM S02 - S02 S32 - S32 S35 - S35 S36 - S36 S37 - S37 S38 - S38 S45 - S45 S47 - S47 S48 - S48 SAC - SAC SAL - SAL SET - SET SUP - SUP SYR - SYR TAB - TAB TUB - TUB VL - VL - - - AMP - AMP AMP2 - AMP2 BKS - BKS BOX - BOX BTL - BTL CAP - CAP CM - CM CRM - CRM DRP - DRP Fle - Fle GAR - GAR GEL - GEL GLN - GLN INF - INF Item - Item KAL - KAL KAP - KAP KG - KG LBR - LBR Lus - Lus MG - MG MIN - MIN ML - ML PAC - PAC PCS - PCS PEN - PEN PUY - PUY REC - REC REM - REM RIM - RIM S02 - S02 S32 - S32 S35 - S35 S36 - S36 S37 - S37 S38 - S38 S45 - S45 S47 - S47 S48 - S48 SAC - SAC SAL - SAL SET - SET SUP - SUP SYR - SYR TAB - TAB TUB - TUB VL - VL
letak_barang
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
dasar
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
h_beli
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ralan
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kelas1
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kelas2
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kelas3
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
utama
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
vip
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
vvip
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
beliluar
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jualbebas
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
karyawan
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
stokminimal
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kdjns
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - ALK - ALK BDK - BDK CRM - CRM EO - EO ESS - ESS GEL - GEL INF - INF INH - INH INJ - INJ IOL - IOL J001 - J001 J002 - J002 J003 - J003 J004 - J004 J007 - J007 J008 - J008 J009 - J009 J010 - J010 J011 - J011 J012 - J012 J013 - J013 J018 - J018 J047 - J047 JB01 - JB01 JB02 - JB02 JB03 - JB03 JB04 - JB04 JB05 - JB05 KAP - KAP KOYO - KOYO LINI - LINI LIPS - LIPS LOT - LOT OIL - OIL OPT - OPT PCS - PCS PLA - PLA PLE - PLE SALK - SALK SALO - SALO SOL - SOL SYR - SYR TAB - TAB TABE - TABE TMMD - TMMD TTS - TTS - - - ALK - ALK BDK - BDK CRM - CRM EO - EO ESS - ESS GEL - GEL INF - INF INH - INH INJ - INJ IOL - IOL J001 - J001 J002 - J002 J003 - J003 J004 - J004 J007 - J007 J008 - J008 J009 - J009 J010 - J010 J011 - J011 J012 - J012 J013 - J013 J018 - J018 J047 - J047 JB01 - JB01 JB02 - JB02 JB03 - JB03 JB04 - JB04 JB05 - JB05 KAP - KAP KOYO - KOYO LINI - LINI LIPS - LIPS LOT - LOT OIL - OIL OPT - OPT PCS - PCS PLA - PLA PLE - PLE SALK - SALK SALO - SALO SOL - SOL SYR - SYR TAB - TAB TABE - TABE TMMD - TMMD TTS - TTS
isi
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kapasitas
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
expire
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status
enum('0', '1')
latin1_swedish_ci
= != IS NULL IS NOT NULL
0
1
kode_industri
char(5)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - I0001 - I0001 I0003 - I0003 I0004 - I0004 I0005 - I0005 I0006 - I0006 I0007 - I0007 I0008 - I0008 - - - I0001 - I0001 I0003 - I0003 I0004 - I0004 I0005 - I0005 I0006 - I0006 I0007 - I0007 I0008 - I0008
kode_kategori
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - FRM - FRM - - - FRM - FRM
kode_golongan
char(4)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - G01 - G01 G03 - G03 G04 - G04 G05 - G05 G06 - G06 G07 - G07 G08 - G08 G09 - G09 G10 - G10 G11 - G11 - - - G01 - G01 G03 - G03 G04 - G04 G05 - G05 G06 - G06 G07 - G07 G08 - G08 G09 - G09 G10 - G10 G11 - G11
