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.