Skip to content

Function: <table>_custom_fields

Description: This function allows extending the table structures for any Merci System Table in Merciglobal Cloud ERP.


Usage

This function should be defined in libfuncs.php:

fasmast_custom_fields($aStru){
    $aStru[] = array(
        'gsthead', 'N', 8, 0, false, false, false, false, false, '',
        'LINK_BROW:mst_gsthead:id:name', '',
        'CAPTION:Gst Head',
        'DEF:CAPTIONLINE:Additional Fields',
        '', '', true, true, true, false,
        '', '', '', '',
        0, 0, 0, 0, 0, 0, 0, 0,
        'U', false, '', '', ''
    );

    $aStru[] = array(
        'tds', 'C', 3, 0, false, false, false, true, false, '',
        'FIX_DDL:YES|NO', '',
        'CAPTION:TDS?',
        '', '', '', true, true, true, false,
        '', '', '', '',
        0, 0, 0, 0, 0, 0, 0, 0,
        'U', false, '', '', ''
    );

    $aStru[] = array(
        'payterms', 'N', 3, 0, false, false, false, false, false, '',
        '', '',
        'CAPTION:Pay Terms',
        '', '', '', true, true, true, false,
        '', '', '', '',
        0, 0, 0, 0, 0, 0, 0, 0,
        'U', false, '', '', ''
    );

    return $aStru;
}

Parameters

Name Type Required Description
$aStru array Yes Original structure from Merci Library

Return

  • array – Returns the extended table structure.

Notes

  • This function is used to add custom fields dynamically to existing Merci system tables, enabling flexibility in extending data models as needed.
  • Particularly useful for customization in the Merciglobal Cloud ERP without altering the base structure.
  • Use with caution to ensure compatibility with existing functionalities.

For more details and implementation guidelines, visit the Merciglobal Cloud ERP Documentation.