Standard Table Structure in MERCI:¶

DEFINEs¶

Definition / Define	Field Position
FLD_NAME	0
FLD_TYPE	1
FLD_WIDTH	2
FLD_DEC	3
FLD_NULL	4
FLD_AUTOINC	5
FLD_PKEY	6
FLD_INDEX	7
FLD_UNQ	8
FLD_COMPUNQ	9
FLD_LINK	10
FLD_CAP	12
FLD_DEF	13
FLD_TOTAL	15
FLD_SHOWADD	16
FLD_SHOWVEW	17
FLD_ALLOWEDIT	18
FLD_CARRY	19
FLD_ASPOST	21
FLD_CASE	32
FLD_HELP	35
FLD_TABPOS	38
FLD_MOBILE	39

Usage¶

   $aStru = array();
   $aStru[] = array( 'id'        ,'N', 8,0,false,true ,true ,false,false,'', '', '', '', '', '', '',false,false,false,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'name'      ,'C',40,0,false,false,false,false,true ,'', '', '', '', '', '', '',true ,true ,true ,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'gstin'     ,'C',20,0,true ,false,false,false,false,'', '', '', 'CAPTION:GST.No.'   , '', '', '',true ,true ,true ,false, '',str2hex(VerifyGstin()),'','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'street1'   ,'C',40,0,true ,false,false,false,false,'', '', '', '', '', '', '',true ,true ,true ,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'street2'   ,'C',40,0,true ,false,false,false,false,'', '', '', '', '', '', '',true ,true ,true ,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'mobile'    ,'C',10,0,true ,false,false,false,false,'', '', '', '', '', '', '',true ,true ,true ,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'mobile2'   ,'C',10,0,true ,false,false,false,false,'', '', '', '', '', '', '',true ,true ,true ,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'mobile3'   ,'C',10,0,true ,false,false,false,false,'', '', '', '', '', '', '',true ,true ,true ,false, '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');
   $aStru[] = array( 'pincode'   ,'C',10,0,true ,false,false,false,false,'', '', '', '', '', '', '',true ,true ,true ,false , '','','','', 0, 0, 0, 0, 0, 0, 0, 0,'U',false,'','','');

Notes¶

These defines are available system wide and can be used anywhere.