Skip to content

Standard Table Structure in MerciGlobal Cloud ERP

DEFINEs Table Reference

The following table outlines the standard field definitions (DEFINEs) used across MerciGlobal Cloud ERP. These fields ensure consistency in table structure and data handling throughout the ERP system.

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 Example

The following PHP array demonstrates how to define table structures using these constants in MerciGlobal Cloud ERP:

$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 globally available within MerciGlobal Cloud ERP.
  • They help in maintaining a uniform data schema and ease integration across modules.
  • Follow naming conventions and data types for reliable behavior across ERP features.