<?php
if (! defined('sugarEntry') || ! sugarEntry)
    die('Not A Valid Entry Point');
/**
 * ***************************************************************************
 * The contents of this file are subject to the RECIPROCAL PUBLIC LICENSE
 * Version 1.1 ("License"); You may not use this file except in compliance
 * with the License.
 * You may obtain a copy of the License at
 * http://opensource.org/licenses/rpl.php. Software distributed under the
 * License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND,
 * either express or implied.
 *
 * You may:
 * a) Use and distribute this code exactly as you received without payment or
 * a royalty or other fee.
 * b) Create extensions for this code, provided that you make the extensions
 * publicly available and document your modifications clearly.
 * c) Charge for a fee for warranty or support or for accepting liability
 * obligations for your customers.
 *
 * You may NOT:
 * a) Charge for the use of the original code or extensions, including in
 * electronic distribution models, such as ASP (Application Service
 * Provider).
 * b) Charge for the original source code or your extensions other than a
 * nominal fee to cover distribution costs where such distribution
 * involves PHYSICAL media.
 * c) Modify or delete any pre-existing copyright notices, change notices,
 * or License text in the Licensed Software
 * d) Assert any patent claims against the Licensor or Contributors, or
 * which would in any way restrict the ability of any third party to use the
 * Licensed Software.
 *
 * You must:
 * a) Document any modifications you make to this code including the nature of
 * the change, the authors of the change, and the date of the change.
 * b) Make the source code for any extensions you deploy available via an
 * Electronic Distribution Mechanism such as FTP or HTTP download.
 * c) Notify the licensor of the availability of source code to your extensions
 * and include instructions on how to acquire the source code and updates.
 * d) Grant Licensor a world-wide, non-exclusive, royalty-free license to use,
 * reproduce, perform, modify, sublicense, and distribute your extensions.
 *
 * The Original Code is: CommuniCore
 * Olavo Farias
 * 2006-04-7 olavo.farias@gmail.com
 *
 * The Initial Developer of the Original Code is CommuniCore.
 * Portions created by CommuniCore are Copyright (C) 2005 CommuniCore Ltda
 * All Rights Reserved.
 * ******************************************************************************
 */
$dictionary['EcmProductB2B'] = array(
        'table' => 'ecmproducts',
        'audited' => true,
        'comment' => 'EcmProductB2Bs',
        'duplicate_merge' => true,
        'unified_search' => true,
        'fields' => array(
                // STANDARD FIELDS SECTION
                'id' => array(
                        'name' => 'id',
                        'vname' => 'LBL_ID',
                        'type' => 'id',
                        'required' => true,
                        'reportable' => false,
                        'comment' => 'Unique identifier'
                ),
                'name' => array(
                        'name' => 'name',
                        'vname' => 'LBL_NAME',
                        'type' => 'text',
                        'required' => true,
                        'len' => 255,
                        'audited' => true,
                        'unified_search' => true,
                        'comment' => 'The short description of the record contents',
                        'massupdate' => true,
                        'merge_filter' => 'selected'
                ),
                'date_entered' => array(
                        'name' => 'date_entered',
                        'vname' => 'LBL_DATE_ENTERED',
                        'type' => 'datetime',
                        'required' => true,
                        'comment' => 'Date record created'
                ),
                'date_modified' => array(
                        'name' => 'date_modified',
                        'vname' => 'LBL_DATE_MODIFIED',
                        'type' => 'datetime',
                        'required' => true,
                        'comment' => 'Date record last modified'
                ),
                'modified_user_id' => array(
                        'name' => 'modified_user_id',
                        'rname' => 'user_name',
                        'id_name' => 'modified_user_id',
                        'vname' => 'LBL_MODIFIED',
                        'type' => 'assigned_user_name',
                        'table' => 'modified_user_id_users',
                        'isnull' => 'false',
                        'dbType' => 'varchar',
                        'len' => 36,
                        'required' => true,
                        'reportable' => true,
                        'comment' => 'User who last modified record'
                ),
                'assigned_user_id' => 

                array(
                        
                        'name' => 'assigned_user_id',
                        
                        'rname' => 'user_name',
                        
                        'id_name' => 'assigned_user_id',
                        
                        'vname' => 'LBL_ASSIGNED_TO_ID',
                        
                        'group' => 'assigned_user_name',
                        
                        'type' => 'relate',
                        
                        'table' => 'users',
                        
                        'reportable' => true,
                        
                        'Importable' => false,
                        
                        'isnull' => 'false',
                        
                        'dbType' => 'id',
                        
                        'audited' => true,
                        
                        'comment' => 'User ID assigned to record',
                        
                        'duplicate_merge' => 'disabled',
                        
                        'massupdate' => false
                )
                ,
                
                'assigned_user_name' => 

                array(
                        
                        'name' => 'assigned_user_name',
                        
                        'vname' => 'LBL_ASSIGNED_TO',
                        
                        'type' => 'relate',
                        
                        'reportable' => false,
                        
                        'source' => 'non-db',
                        
                        'table' => 'users',
                        
                        'id_name' => 'assigned_user_id',
                        
                        'module' => 'Users',
                        
                        'duplicate_merge' => 'disabled',
                        
                        'massupdate' => false
                )
                ,
                'created_by' => array(
                        'name' => 'created_by',
                        'rname' => 'user_name',
                        'id_name' => 'created_by',
                        'vname' => 'LBL_CREATED',
                        'type' => 'assigned_user_name',
                        'table' => 'created_by_users',
                        'isnull' => 'false',
                        'dbType' => 'varchar',
                        'len' => 36,
                        'comment' => 'User that created the record'
                ),
                'created_by_link' => array(
                        'name' => 'created_by_link',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_created_by',
                        'vname' => 'LBL_CREATED_BY_USER',
                        'link_type' => 'one',
                        'module' => 'Users',
                        'bean_name' => 'User',
                        'source' => 'non-db'
                ),
                'modified_user_link' => array(
                        'name' => 'modified_user_link',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_modified_user',
                        'vname' => 'LBL_MODIFIED_BY_USER',
                        'link_type' => 'one',
                        'module' => 'Users',
                        'bean_name' => 'User',
                        'source' => 'non-db'
                ),
                'assigned_user_link' => array(
                        'name' => 'assigned_user_link',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_assigned_user',
                        'vname' => 'LBL_ASSIGNED_TO_USER',
                        'link_type' => 'one',
                        'module' => 'Users',
                        'bean_name' => 'User',
                        'source' => 'non-db',
                        'duplicate_merge' => 'enabled',
                        'rname' => 'user_name',
                        'id_name' => 'assigned_user_id',
                        'table' => 'users'
                ),
                'deleted' => array(
                        'name' => 'deleted',
                        'vname' => 'LBL_CREATED_BY',
                        'type' => 'bool',
                        'required' => true,
                        'reportable' => false,
                        'comment' => 'Record deletion indicator'
                ),
                // add mz 09-11-2011
                
                'to_order' => array(
                        'name' => 'to_order',
                        'vname' => 'To order',
                        'type' => 'bool'
                ),
                // NEW FIELDS SECTION
                'code' => array(
                        'type' => 'varchar',
                        'name' => 'code',
                        'vname' => 'LBL_PRODUCT_INDEX',
                        'comment' => 'Product index',
                        'required' => true,
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'product_category_id' => array(
                        'name' => 'product_category_id',
                        'rname' => 'name',
                        'id_name' => 'product_category_id',
                        'vname' => 'LBL_PRODUCT_CATEGORY_ID',
                        'group' => 'product_category_name',
                        'type' => 'relate',
                        'table' => 'ecmproductcategories',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'product_category_name' => array(
                        'name' => 'product_category_name',
                        'vname' => 'LBL_PRODUCT_CATEGORY',
                        'type' => 'relate',
                        'reportable' => false,
                        // 'source' => 'non-db',
                        'table' => 'ecmproductcategories',
                        'id_name' => 'product_category_id',
                        'module' => 'EcmProductB2BCategories',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'product_subcategory_id' => array(
                        'name' => 'product_subcategory_id',
                        'rname' => 'name',
                        'id_name' => 'product_subcategory_id',
                        'vname' => 'LBL_PRODUCT_SUBCATEGORY_ID',
                        'group' => 'product_subcategory_name',
                        'type' => 'relate',
                        'table' => 'ecmproductsubcategories',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'product_subcategory_name' => array(
                        'name' => 'product_subcategory_name',
                        'vname' => 'LBL_PRODUCT_SUBCATEGORY',
                        'type' => 'relate',
                        'reportable' => false,
                        // 'source' => 'non-db',
                        'table' => 'ecmproductsubcategories',
                        'id_name' => 'product_subcategory_id',
                        'module' => 'EcmProductB2BSubCategories',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'stock_id' => array(
                        'name' => 'stock_id',
                        'rname' => 'name',
                        'id_name' => 'stock_id',
                        'vname' => 'LBL_STOCK_ID',
                        'group' => 'stock_name',
                        'type' => 'relate',
                        'table' => 'ecmstocks',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false,
                        'source' => 'non-db'
                ),
                'stock_name' => array(
                        'name' => 'stock_name',
                        'vname' => 'LBL_STOCK_NAME',
                        'type' => 'relate',
                        'reportable' => false,
                        'source' => 'non-db',
                        'table' => 'ecmstocks',
                        'id_name' => 'stock_id',
                        'module' => 'EcmStocks',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                
                'product_line_id' => array(
                        'name' => 'product_line_id',
                        'rname' => 'name',
                        'id_name' => 'product_line_id',
                        'vname' => 'LBL_PRODUCT_LINE_ID',
                        'group' => 'product_line_name',
                        'type' => 'relate',
                        'table' => 'ecmproductlines',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'product_line_name' => array(
                        'name' => 'product_line_name',
                        'vname' => 'LBL_PRODUCT_LINE',
                        'type' => 'relate',
                        'reportable' => false,
                        // 'source' => 'non-db',
                        'table' => 'ecmproductlines',
                        'id_name' => 'product_line_id',
                        'module' => 'EcmProductB2BLines',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                
                'manufacturer_id' => array(
                        'name' => 'manufacturer_id',
                        'rname' => 'name',
                        'id_name' => 'manufacturer_id',
                        'vname' => 'LBL_MANUFACTURER_ID',
                        'group' => 'manufacturer_name',
                        'type' => 'relate',
                        'table' => 'ecmproductmanufacturers',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'manufacturer_name' => array(
                        'name' => 'manufacturer_name',
                        'vname' => 'LBL_MANUFACTURER',
                        'type' => 'relate',
                        'reportable' => false,
                        // 'source' => 'non-db',
                        'table' => 'ecmproductmanufacturers',
                        'id_name' => 'manufacturer_id',
                        'module' => 'EcmProductB2BManufacturers',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                
                'contact_id' => array(
                        'name' => 'contact_id',
                        'rname' => 'name',
                        'id_name' => 'contact_id',
                        'vname' => 'LBL_CONTACT_ID',
                        'group' => 'contact_name',
                        'type' => 'relate',
                        'table' => 'contacts',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'contact_name' => array(
                        'name' => 'contact_name',
                        'vname' => 'LBL_CONTACT_NAME',
                        'type' => 'relate',
                        'reportable' => false,
                        // 'source' => 'non-db',
                        'table' => 'contacts',
                        'id_name' => 'contact_id',
                        'module' => 'Contacts',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'documents' => array(
                        'name' => 'documents',
                        'type' => 'link',
                        'relationship' => 'ecmproduct_documents',
                        'source' => 'non-db',
                        'vname' => 'LBL_NOTES'
                ),
                
                'vendor_id' => array(
                        'name' => 'vendor_id',
                        'rname' => 'name',
                        'id_name' => 'vendor_id',
                        'vname' => 'LBL_VENDOR_ID',
                        'group' => 'vendor_name',
                        'type' => 'relate',
                        'table' => 'accounts',
                        'reportable' => true,
                        'Importable' => false,
                        'isnull' => 'false',
                        'dbType' => 'id',
                        'audited' => true,
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                'vendor_name' => array(
                        'name' => 'vendor_name',
                        'vname' => 'LBL_VENDOR_NAME',
                        'type' => 'relate',
                        'reportable' => false,
                        // 'source' => 'non-db',
                        'table' => 'accounts',
                        'id_name' => 'vendor_id',
                        'module' => 'Accounts',
                        'duplicate_merge' => 'disabled',
                        'massupdate' => false
                ),
                
                'vendor_part_no' => array(
                        'type' => 'varchar',
                        'name' => 'vendor_part_no',
                        'vname' => 'LBL_VENDOR_PART_NO',
                        'comment' => 'Vendor part no',
                        'max_size' => '200',
                        'len' => '200'
                ),
                
                'product_active' => array(
                        'type' => 'bool',
                        'name' => 'product_active',
                        'vname' => 'LBL_PRODUCT_ACTIVE',
                        'comment' => 'Product active',
                        'default' => '1'
                ),
                'B2B' => array(
                        'type' => 'bool',
                        'name' => 'B2B',
                        'vname' => 'LBL_BE_TO_BE',
                        'default' => '1'
                ),
                'B2C' => array(
                        'type' => 'bool',
                        'name' => 'B2C',
                        'vname' => 'LBL_BE_TO_SEE',
                        'default' => '1'
                ),
                
                'flag' => array(
                        'type' => 'bool',
                        'name' => 'flag',
                        'vname' => 'LBL_FLAG',
                        'comment' => 'Flag',
                        'default' => '1',
                        'massupdate' => false
                ),
                
                'production' => array(
                        'type' => 'bool',
                        'name' => 'production',
                        'vname' => 'LBL_PRODUCTION',
                        'comment' => 'Production',
                        'default' => '1'
                ),
                
                'th' => array(
                        'type' => 'bool',
                        'name' => 'th',
                        'vname' => 'LBL_TH',
                        'comment' => 'TH',
                        'default' => '1'
                ),
                
                'end_of_line' => array(
                        'type' => 'bool',
                        'name' => 'end_of_line',
                        'vname' => 'LBL_END_OF_LINE',
                        'comment' => 'End of line',
                        'default' => '1'
                ),
                
                'sales_start_date' => array(
                        'type' => 'date',
                        'name' => 'sales_start_date',
                        'vname' => 'LBL_SALES_START_DATE',
                        'comment' => 'Sales start date',
                        'massupdate' => true
                ),
                
                'sales_end_date' => array(
                        'type' => 'date',
                        'name' => 'sales_end_date',
                        'vname' => 'LBL_SALES_END_DATE',
                        'comment' => 'Sales end date',
                        'massupdate' => true
                ),
                
                'parent_type' => 

                array(
                        
                        'name' => 'parent_type',
                        
                        'vname' => 'LBL_PARENT',
                        
                        'type' => 'varchar',
                        
                        'group' => 'parent_name',
                        
                        'reportable' => false,
                        
                        'len' => '25',
                        
                        'comment' => 'The Sugar object to which the call is related',
                        
                        'massupdate' => false
                )
                ,
                'unit_id' => 

                array(
                        'name' => 'unit_id',
                        'options' => 'ecmproducts_unit_dom',
                        'vname' => 'LBL_UNIT_NAME',
                        'type' => 'enum',
                        'len' => '10',
                        'massupdate' => false
                ),
                
                'parent_name' => 

                array(
                        
                        'name' => 'parent_name',
                        
                        'parent_type' => 'ecmproducts_parent_dom',
                        
                        'type_name' => 'parent_type',
                        
                        'id_name' => 'parent_id',
                        
                        'vname' => 'LBL_PARENT_NAME',
                        
                        'type' => 'parent',
                        
                        'group' => 'parent_name',
                        
                        'dbtype' => 'varchar',
                        
                        'len' => '255',
                        
                        // 'source'=>'non-db',
                        
                        'massupdate' => false,
                        
                        'options' => 'ecmquotes_parent_dom'
                )
                ,
                
                'parent_id' => 

                array(
                        
                        'name' => 'parent_id',
                        
                        'type' => 'id',
                        
                        'vname' => 'LBL_PARENT_ID',
                        
                        'group' => 'parent_name',
                        
                        'massupdate' => false,
                        
                        'reportable' => false
                )
                ,
                
                'website' => array(
                        'type' => 'varchar',
                        'name' => 'website',
                        'vname' => 'LBL_WEBSITE',
                        'comment' => 'Website',
                        'max_size' => '255',
                        'len' => '255'
                ),
                
                'part_no' => array(
                        'type' => 'varchar',
                        'name' => 'part_no',
                        'vname' => 'LBL_PART_NO',
                        'comment' => 'Part no',
                        'max_size' => '200',
                        'len' => '200'
                ),
                
                'serial_no' => array(
                        'type' => 'varchar',
                        'name' => 'serial_no',
                        'vname' => 'LBL_SERIAL_NO',
                        'comment' => 'Serial no',
                        'max_size' => '200',
                        'len' => '200'
                ),
                
                'exchange_rate_id' => array(
                        'type' => 'varchar',
                        'name' => 'exchange_rate_id',
                        'vname' => 'LBL_EXCHANGE_RATE_ID',
                        'comment' => 'Exchange rate id',
                        'max_size' => '36',
                        'len' => '36'
                ),
                
                'exchange_rate_name' => array(
                        'type' => 'varchar',
                        'name' => 'exchange_rate_name',
                        'vname' => 'LBL_EXCHANGE_RATE_NAME',
                        'comment' => 'Exchange rate name',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'fob_price' => array(
                        'type' => 'currency',
                        'name' => 'fob_price',
                        'vname' => 'LBL_FOB_PRICE',
                        'comment' => 'FOB price',
                        'max_size' => '7',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '7,2'
                ),
                
                'purchase_price' => array(
                        'type' => 'currency',
                        'name' => 'purchase_price',
                        'vname' => 'LBL_UNIT_PRICE',
                        'comment' => 'Unit price',
                        'max_size' => '11',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '11,2'
                ),
                
                'ems_price' => array(
                        'type' => 'currency',
                        'name' => 'ems_price',
                        'vname' => 'LBL_EMS_PRICE',
                        'comment' => 'EMS price',
                        'max_size' => '7',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '7,2'
                ),
                
                'commission_rate' => array(
                        'type' => 'currency',
                        'name' => 'commission_rate',
                        'vname' => 'LBL_COMMISSION_RATE',
                        'comment' => 'Commission rate',
                        'max_size' => '4',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '9,2'
                ),
                
                'custom_duty_rate' => array(
                        'type' => 'currency',
                        'name' => 'custom_duty_rate',
                        'vname' => 'LBL_CUSTOM_DUTY_RATE',
                        'comment' => 'Custom duty rate',
                        'max_size' => '5',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '5,2'
                ),
                
                'srp_price' => array(
                        'type' => 'currency',
                        'name' => 'srp_price',
                        'vname' => 'LBL_SRP_PRICE',
                        'comment' => 'SRP price',
                        'max_size' => '7',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '7,2'
                ),
                
                'srp_price_eur' => array(
                        'type' => 'currency',
                        'name' => 'srp_price_eur',
                        'vname' => 'LBL_SRP_PRICE_EUR',
                        'comment' => 'SRP price eur',
                        'max_size' => '7',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '7,2'
                ),
                
                'srp_promo_price' => array(
                        'type' => 'currency',
                        'name' => 'srp_promo_price',
                        'vname' => 'LBL_SRP_PROMO_PRICE',
                        'comment' => 'SRP promo price',
                        'max_size' => '7',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '7,2'
                ),
                
                'tax_class_id' => array(
                        'type' => 'varchar',
                        'name' => 'tax_class_id',
                        'vname' => 'LBL_TAX_CLASS_ID',
                        'comment' => 'Tax class id',
                        'max_size' => '36',
                        'len' => '36'
                ),
                
                'tax_class_name' => array(
                        'type' => 'varchar',
                        'name' => 'tax_class_name',
                        'vname' => 'LBL_TAX_CLASS_NAME',
                        'comment' => 'Tax class name',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'usage_unit_id' => array(
                        'type' => 'varchar',
                        'name' => 'usage_unit_id',
                        'vname' => 'LBL_USAGE_UNIT_ID',
                        'comment' => 'Usage unit id',
                        'max_size' => '36',
                        'len' => '36'
                ),
                
                'usage_unit_name' => array(
                        'type' => 'varchar',
                        'name' => 'usage_unit_name',
                        'vname' => 'LBL_USAGE_UNIT_NAME',
                        'comment' => 'Usage unit name',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'qty_in_stock' => array(
                        'type' => 'varchar',
                        'name' => 'qty_in_stock',
                        'vname' => 'LBL_QTY_IN_STOCK',
                        'comment' => 'Qty in stock',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'qty_in_demand' => array(
                        'type' => 'varchar',
                        'name' => 'qty_in_demand',
                        'vname' => 'LBL_QTY_IN_DEMAND',
                        'comment' => 'Qty in demand',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'ems_qty_in_stock' => array(
                        'type' => 'varchar',
                        'name' => 'ems_qty_in_stock',
                        'vname' => 'LBL_EMS_QTY_IN_STOCK',
                        'comment' => 'EMS qty in stock',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'reorder_level' => array(
                        'type' => 'int',
                        'name' => 'reorder_level',
                        'vname' => 'LBL_REORDER_LEVEL',
                        'comment' => 'Reorder level',
                        'len' => '11'
                ),
                
                'sales_last_month_1' => array(
                        'type' => 'currency',
                        'name' => 'sales_last_month_1',
                        'vname' => 'LBL_SALES_LAST_MONTH_1',
                        'comment' => 'Sales last month -1',
                        'max_size' => '8',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '8,2'
                ),
                
                'sales_last_month' => array(
                        'type' => 'currency',
                        'name' => 'sales_last_month',
                        'vname' => 'LBL_SALES_LAST_MONTH',
                        'comment' => 'Sales last month',
                        'max_size' => '8',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '8,2'
                ),
                
                'sales_this_month' => array(
                        'type' => 'currency',
                        'name' => 'sales_this_month',
                        'vname' => 'LBL_SALES_THIS_MONTH',
                        'comment' => 'Sales this month',
                        'max_size' => '8',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '8,2'
                ),
                
                'qty_per_unit' => array(
                        'type' => 'currency',
                        'name' => 'qty_per_unit',
                        'vname' => 'LBL_QTY_PER_UNIT',
                        'comment' => 'Qty per unit',
                        'max_size' => '11',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '11,2'
                ),
                
                'average_sale_3_months' => array(
                        'type' => 'currency',
                        'name' => 'average_sale_3_months',
                        'vname' => 'LBL_AVERAGE_SALE_3_MONTHS',
                        'comment' => 'Average sale 3 months',
                        'max_size' => '8',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '8,2'
                ),
                
                'sales_plus_1' => array(
                        'type' => 'currency',
                        'name' => 'sales_plus_1',
                        'vname' => 'LBL_SALES_PLUS_1',
                        'comment' => 'Sales plus 1',
                        'max_size' => '6',
                        'precision' => '0',
                        'dbType' => 'double',
                        'len' => '6,0'
                ),
                
                'sales_plus_2' => array(
                        'type' => 'currency',
                        'name' => 'sales_plus_2',
                        'vname' => 'LBL_SALES_PLUS_2',
                        'comment' => 'Sales plus 2',
                        'max_size' => '6',
                        'precision' => '0',
                        'dbType' => 'double',
                        'len' => '6,0'
                ),
                
                'sales_plus_3' => array(
                        'type' => 'currency',
                        'name' => 'sales_plus_3',
                        'vname' => 'LBL_SALES_PLUS_3',
                        'comment' => 'Sales plus 3',
                        'max_size' => '6',
                        'precision' => '0',
                        'dbType' => 'double',
                        'len' => '6,0'
                ),
                
                'product_picture' => array(
                        'type' => 'varchar',
                        'name' => 'product_picture',
                        'vname' => 'LBL_PRODUCT_PICTURE',
                        'comment' => 'Product picture',
                        'max_size' => '255',
                        'len' => '255'
                ),
                
                'packing_front_picture' => array(
                        'type' => 'varchar',
                        'name' => 'packing_front_picture',
                        'vname' => 'LBL_PACKING_FRONT_PICTURE',
                        'comment' => 'Packing front picture',
                        'max_size' => '255',
                        'len' => '255'
                ),
                
                'driver_1' => array(
                        'type' => 'varchar',
                        'name' => 'driver_1',
                        'vname' => 'LBL_DRIVER_1',
                        'comment' => 'Driver 1',
                        'max_size' => '255',
                        'len' => '255'
                ),
                
                'driver_2' => array(
                        'type' => 'varchar',
                        'name' => 'driver_2',
                        'vname' => 'LBL_DRIVER_2',
                        'comment' => 'Driver 2',
                        'max_size' => '255',
                        'len' => '255'
                ),
                
                'moq' => array(
                        'type' => 'currency',
                        'name' => 'moq',
                        'vname' => 'LBL_MOQ',
                        'comment' => 'MOQ',
                        'max_size' => '6',
                        'precision' => '0',
                        'dbType' => 'double',
                        'len' => '6,0'
                ),
                
                'fob_basis_id' => array(
                        'type' => 'varchar',
                        'name' => 'fob_basis_id',
                        'vname' => 'LBL_FOB_BASIS_ID',
                        'comment' => 'FOB basis id',
                        'max_size' => '36',
                        'len' => '36'
                ),
                
                'fob_basis_name' => array(
                        'type' => 'varchar',
                        'name' => 'fob_basis_name',
                        'vname' => 'LBL_FOB_BASIS_NAME',
                        'comment' => 'FOB basis name',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'delivery_time_fob' => array(
                        'type' => 'currency',
                        'name' => 'delivery_time_fob',
                        'vname' => 'LBL_DELIVERY_TIME_FOB',
                        'comment' => 'Delivery time FOB',
                        'max_size' => '4',
                        'precision' => '0',
                        'dbType' => 'double',
                        'len' => '4,0'
                ),
                
                'pieces_per_carton' => array(
                        'type' => 'float',
                        'name' => 'pieces_per_carton',
                        'vname' => 'LBL_PIECES_PER_CARTON',
                        'comment' => 'Pieces per carton',
                        'max_size' => '7',
                        'precision' => '0',
                        'dbType' => 'double',
                        'len' => '7,0'
                ),
                
                'product_netto_weight' => array(
                        'type' => 'float',
                        'name' => 'product_netto_weight',
                        'vname' => 'LBL_PRODUCT_NETTO_WEIGHT',
                        'comment' => 'Product netto weight (kg)',
                        'max_size' => '9',
                        'precision' => '3',
                        'dbType' => 'double',
                        'len' => '9,3'
                ),
                
                'product_brutto_weight' => array(
                        'type' => 'float',
                        'name' => 'product_brutto_weight',
                        'vname' => 'LBL_PRODUCT_BRUTTO_WEIGHT',
                        'comment' => 'Product brutto weight (kg)',
                        'max_size' => '9',
                        'precision' => '3',
                        'dbType' => 'double',
                        'len' => '9,3'
                ),
                
                'packing_type_id' => array(
                        'type' => 'varchar',
                        'name' => 'packing_type_id',
                        'vname' => 'LBL_PACKING_TYPE_ID',
                        'comment' => 'Packing type id',
                        'max_size' => '36',
                        'len' => '36'
                ),
                
                'packing_type_name' => array(
                        'type' => 'varchar',
                        'name' => 'packing_type_name',
                        'vname' => 'LBL_PACKING_TYPE_NAME',
                        'comment' => 'Packing type',
                        'max_size' => '40',
                        'len' => '40'
                ),
                
                'packing_dimensions_1' => array(
                        'type' => 'float',
                        'name' => 'packing_dimensions_1',
                        'vname' => 'LBL_PACKING_DIMENSIONS_1',
                        'comment' => 'Packing dimensions (cm)',
                        'max_size' => '5',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '5,2'
                ),
                
                'packing_dimensions_2' => array(
                        'type' => 'float',
                        'name' => 'packing_dimensions_2',
                        'vname' => 'LBL_PACKING_DIMENSIONS_2',
                        'comment' => 'Packing dimensions (cm)',
                        'max_size' => '5',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '5,2'
                ),
                
                'packing_dimensions_3' => array(
                        'type' => 'float',
                        'name' => 'packing_dimensions_3',
                        'vname' => 'LBL_PACKING_DIMENSIONS_3',
                        'comment' => 'Packing dimensions (cm)',
                        'max_size' => '5',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '5,2'
                ),
                
                'rma' => array(
                        'type' => 'float',
                        'name' => 'rma',
                        'vname' => 'LBL_RMA',
                        'comment' => 'RMA (%)',
                        'max_size' => '6',
                        'precision' => '3',
                        'dbType' => 'double',
                        'len' => '6,3'
                ),
                
                'carton_dimensions_1' => array(
                        'type' => 'decimal',
                        'name' => 'carton_dimensions_1',
                        'vname' => 'LBL_CARTON_DIMENSIONS_1',
                        'comment' => 'Carton dimensions (m)',
                        'len' => '5,2'
                ),
                
                'carton_dimensions_2' => array(
                        'type' => 'decimal',
                        'name' => 'carton_dimensions_2',
                        'vname' => 'LBL_CARTON_DIMENSIONS_2',
                        'comment' => 'Carton dimensions (m)',
                        'len' => '5,2'
                ),
                
                'carton_dimensions_3' => array(
                        'type' => 'decimal',
                        'name' => 'carton_dimensions_3',
                        'vname' => 'LBL_CARTON_DIMENSIONS_3',
                        'comment' => 'Carton dimensions (m)',
                        'len' => '5,2'
                ),
                
                'carton_netto_weight' => array(
                        'type' => 'float',
                        'name' => 'carton_netto_weight',
                        'vname' => 'LBL_CARTON_NETTO_WEIGHT',
                        'comment' => 'Carton netto weight',
                        'max_size' => '9',
                        'precision' => '3',
                        'dbType' => 'double',
                        'len' => '9,3'
                ),
                
                'carton_brutto_weight' => array(
                        'type' => 'float',
                        'name' => 'carton_brutto_weight',
                        'vname' => 'LBL_CARTON_BRUTTO_WEIGHT',
                        'comment' => 'Carton brutto weight',
                        'max_size' => '9',
                        'precision' => '3',
                        'dbType' => 'double',
                        'len' => '9,3'
                ),
                
                'carton_volume_meter' => array(
                        'type' => 'float',
                        'name' => 'carton_volume_meter',
                        'vname' => 'LBL_CARTON_VOLUME_METER',
                        'comment' => 'Carton volume (cubic meter)',
                        'max_size' => '5',
                        'precision' => '2',
                        'dbType' => 'double',
                        'len' => '5,2'
                ),
                
                'carton_volume_feet' => array(
                        'type' => 'float',
                        'name' => 'carton_volume_feet',
                        'vname' => 'LBL_CARTON_VOLUME_FEET',
                        'comment' => 'Carton volume (cubic feet)',
                        'max_size' => '5',
                        'precision' => '2',
                        'dbType' => 'double',
                        
                        'len' => '5,2'
                ),
                
                'country_of_origin' => array(
                        'type' => 'varchar',
                        'name' => 'country_of_origin',
                        'vname' => 'LBL_COUNTRY_OF_ORIGIN',
                        'comment' => 'Country of origin',
                        'max_size' => '255',
                        'len' => '255'
                ),
                
                'certificate_of_origin' => array(
                        'type' => 'bool',
                        'name' => 'certificate_of_origin',
                        'vname' => 'LBL_CERTIFICATE_OF_ORIGIN',
                        'comment' => 'Certificate of origin',
                        'default' => '1',
                        'massupdate' => false
                ),
                
                'form_a' => array(
                        'type' => 'bool',
                        'name' => 'form_a',
                        'vname' => 'LBL_FORM_A',
                        'comment' => 'Form A',
                        'default' => '1',
                        'massupdate' => false
                ),
                
                'vat_value' => array(
                        'type' => 'decimal',
                        'name' => 'vat_value',
                        'vname' => 'LBL_VAT_VALUE',
                        'len' => '5,3'
                ),
                
                'vat_name' => array(
                        'type' => 'varchar',
                        'name' => 'vat_name',
                        'vname' => 'LBL_VAT_NAME',
                        'len' => '50'
                ),
                'pkwiu' => array(
                        'type' => 'varchar',
                        'name' => 'pkwiu',
                        'vname' => 'LBL_PKWIU',
                        'len' => '50'
                ),
                'vat_id' => array(
                        'type' => 'varchar',
                        'name' => 'vat_id',
                        'default' => '28079566-b825-e38f-9993-4ccc7b781de5',
                        'vname' => 'LBL_VAT_ID',
                        'len' => '36'
                ),
                
                'selling_price' => array(
                        'type' => 'decimal',
                        'name' => 'selling_price',
                        'vname' => 'LBL_SELLING_PRICE',
                        'len' => '11,2'
                ),
                'ems_ordered' => array(
                        'type' => 'int',
                        'name' => 'ems_ordered',
                        'vname' => 'LBL_EMS_ORDERED',
                        'len' => '11'
                ),
                'ordered' => array(
                        'type' => 'int',
                        'name' => 'ordered',
                        'vname' => 'LBL_EMS_ORDERED',
                        'len' => '11'
                ),
                
                'stock_month' => array(
                        'type' => 'decimal',
                        'name' => 'stock_month',
                        'vname' => 'LBL_STOCK_MONTH',
                        'len' => '11,2'
                ),
                'description_card' => array(
                        'type' => 'bool',
                        'name' => 'description_card',
                        'vname' => 'LBL_DESCRIPTION_CARD',
                        'massupdate' => false
                ),
                'characteristic_card' => array(
                        'type' => 'bool',
                        'name' => 'characteristic_card',
                        'vname' => 'LBL_CHARACTERISTIC_CARD',
                        'massupdate' => false
                ),
                'specification_card' => array(
                        'type' => 'bool',
                        'name' => 'specification_card',
                        'vname' => 'LBL_SPECIFICATION_CARD',
                        'massupdate' => false
                ),
                'used_to_card' => array(
                        'type' => 'bool',
                        'name' => 'used_to_card',
                        'vname' => 'LBL_USED_TO_CARD',
                        'massupdate' => false
                ),
                'image_card' => array(
                        'name' => 'image_card',
                        'options' => 'ecmproducts_image_dom',
                        'vname' => 'LBL_IMAGE_CARD',
                        'type' => 'enum',
                        'len' => '10',
                        'massupdate' => false
                ),
                'status' => array(
                        'name' => 'status',
                        'options' => 'ecmproducts_status_dom',
                        'vname' => 'LBL_STATUS',
                        'default' => 'active',
                        'type' => 'enum',
                        'len' => '10',
                        'massupdate' => false
                ),
                'ks_group' => array(
                        'name' => 'ks_group',
                        'options' => 'ecmproducts_group_ks_dom',
                        'vname' => 'LBL_KS_GROUP',
                        'type' => 'enum',
                        'len' => '3',
                        'required' => true
                ),
                'add_status' => array(
                        'name' => 'add_status',
                        'options' => 'ecmproducts_add_status_dom',
                        'vname' => 'LBL_ADD_STATUS',
                        'type' => 'enum',
                        'len' => '10',
                        'massupdate' => false
                ),
                'description' => array(
                        'name' => 'description',
                        'vname' => 'LBL_DESCRIPTION',
                        'type' => 'text'
                ),
                'models' => array(
                        'name' => 'models',
                        'vname' => 'LBL_MODELS',
                        'type' => 'text'
                ),
                'ean' => array(
                        'name' => 'ean',
                        'vname' => 'LBL_EAN',
                        'type' => 'varchar',
                        'len' => '50'
                ),
                'ean2' => array(
                        'name' => 'ean2',
                        'vname' => 'LBL_EAN2',
                        'type' => 'varchar',
                        'len' => '50'
                ),
                
                'boxes_per_layer' => array(
                        'name' => 'boxes_per_layer',
                        'vname' => 'LBL_BOXES_PER_LAYER',
                        'type' => 'int'
                ),
                'number_of_layers' => array(
                        'name' => 'number_of_layers',
                        'vname' => 'LBL_NUMBER_OF_LAYERS',
                        'type' => 'int'
                ),
                'boxes_per_palette' => array(
                        'name' => 'boxes_per_palette',
                        'vname' => 'LBL_BOXES_PER_PALETTE',
                        'type' => 'int'
                ),
                'pieces_per_palette' => array(
                        'name' => 'pieces_per_palette',
                        'vname' => 'LBL_PIECES_PER_PALETTE',
                        'type' => 'int'
                ),
                'palette_weight_brutto' => array(
                        'name' => 'palette_weight_brutto',
                        'vname' => 'LBL_PALETTE_WEIGHT_BRUTTO',
                        'type' => 'float',
                        'dbType' => 'double'
                ),
                
                'items_list_panel' => array(
                        'name' => 'items_list_panel',
                        'vname' => 'LBL_ITEMS',
                        'type' => 'text',
                        'source' => 'non-db'
                ),
                
                'graduated_prices' => array(
                        'name' => 'graduated_prices',
                        'vname' => 'LBL_GRADUATED_PRICES',
                        'type' => 'text'
                ),
                
                'lead_time' => array(
                        'name' => 'lead_time',
                        'vname' => 'LBL_LEAD_TIME',
                        'type' => 'int'
                ),
                
                'ecmstockins' => array(
                        'name' => 'ecmstockins',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockins',
                        'source' => 'non-db',
                        'vname' => 'LBL_STOCKIN'
                ),
                'ecmstockouts' => array(
                        'name' => 'ecmstockouts',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockouts',
                        'source' => 'non-db',
                        'vname' => 'LBL_STOCKOUT'
                ),
                'ecmpurchaseorders' => array(
                        'name' => 'ecmpurchaseorders',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmpurchaseorders',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMPURCHASEORDERS'
                ),
                'ecmsales' => array(
                        'name' => 'ecmsales',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmsales',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMSALES'
                ),
                'ecmstockdocins' => array(
                        'name' => 'ecmstockdocins',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockdocins',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMSTOCKDOCINS'
                ),
                'ecmstockdocouts' => array(
                        'name' => 'ecmstockdocouts',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockdocouts',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMSTOCKDOCOUTS'
                ),
                'ecmstockdocinsideins' => array(
                        'name' => 'ecmstockdocinsideins',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockdocinsideins',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMSTOCKDOCINSIDEINS'
                ),
                'ecmstockdocinsideouts' => array(
                        'name' => 'ecmstockdocinsideouts',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockdocinsideouts',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMSTOCKDOCINSIDEOUTS'
                ),
                'ecmstockdocmoves' => array(
                        'name' => 'ecmstockdocmoves',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmstockdocmoves',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMSTOCKDOCMOVES'
                ),
                'ecmdeliverynotes' => array(
                        'name' => 'ecmdeliverynotes',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmdeliverynotes',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMDELIVERYNOTES'
                ),
                'ecminvoiceouts' => array(
                        'name' => 'ecminvoiceouts',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecminvoiceouts',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMINVOICEOUTS'
                ),
                'ecmquotes' => array(
                        'name' => 'ecmquotes',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmquotes',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMQUOTES'
                ),
                'ecmpricebooks' => array(
                        'name' => 'ecmpricebooks',
                        'type' => 'link',
                        'relationship' => 'ecmpricebooks_ecmproducts',
                        'source' => 'non-db',
                        'vname' => 'LBL_ECMPRICEBOOKS'
                ),
                'notes' => array(
                        'name' => 'notes',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_notes',
                        'source' => 'non-db',
                        'vname' => 'LBL_NOTES'
                ),
                'ecmcomponents' => array(
                        'name' => 'ecmcomponents',
                        'type' => 'link',
                        'relationship' => 'ecmproducts_ecmcomponents',
                        'source' => 'non-db',
                        'vname' => 'LBL_COMPONENTS'
                )
        // FOR SUBPANELS
                )

        ,
        
        // INDICES SECTION
        'indices' => array(
                array(
                        'name' => 'ecmproductsspk',
                        'type' => 'primary',
                        'fields' => array(
                                'id'
                        )
                ),
                array(
                        'name' => 'idx_ecmproducts_name',
                        'type' => 'index',
                        'fields' => array(
                                'name'
                        )
                )
        ),
        
        // RELATIONSHIPS SECTION
        'relationships' => array(
                'ecmproducts_assigned_user' => array(
                        'lhs_module' => 'Users',
                        'lhs_table' => 'users',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmProductB2Bs',
                        'rhs_table' => 'ecmproducts',
                        'rhs_key' => 'assigned_user_id',
                        'relationship_type' => 'one-to-many'
                ),
                
                'ecmproducts_modified_user' => array(
                        'lhs_module' => 'Users',
                        'lhs_table' => 'users',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmProductB2Bs',
                        'rhs_table' => 'ecmproducts',
                        'rhs_key' => 'modified_user_id',
                        'relationship_type' => 'one-to-many'
                ),
                
                'ecmproducts_created_by' => array(
                        'lhs_module' => 'Users',
                        'lhs_table' => 'users',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmProductB2Bs',
                        'rhs_table' => 'ecmproducts',
                        'rhs_key' => 'created_by',
                        'relationship_type' => 'one-to-many'
                ),
                
                'ecmproducts_ecmstockins' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockIns',
                        'rhs_table' => 'ecmstockins',
                        'rhs_key' => 'product_id',
                        'relationship_type' => 'one-to-many'
                ),
                
                'ecmproducts_ecmstockouts' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockOuts',
                        'rhs_table' => 'ecmstockouts',
                        'rhs_key' => 'product_id',
                        'relationship_type' => 'one-to-many'
                ),
                
                'ecmproducts_ecmpurchaseorders' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmPurchaseOrders',
                        'rhs_table' => 'ecmpurchaseorders',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmproducts_ecmpurchaseorders',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmpurchaseorder_id'
                ),
                
                'ecmproducts_ecmsales' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmSales',
                        'rhs_table' => 'ecmsales',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmsaleitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmsale_id'
                ),
                'ecmproduct_documents' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'Documents',
                        'rhs_table' => 'documents',
                        'rhs_key' => 'parent_id',
                        'relationship_type' => 'one-to-many',
                        'relationship_role_column' => 'parent_type',
                        'relationship_role_column_value' => 'EcmProductB2Bs'
                ),
                'ecmproducts_ecmstockdocins' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockDocIns',
                        'rhs_table' => 'ecmstockdocins',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmstockdocinitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmstockdocin_id'
                ),
                
                'ecmproducts_ecmstockdocouts' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockDocOuts',
                        'rhs_table' => 'ecmstockdocouts',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmstockdocoutitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmstockdocout_id'
                ),
                
                'ecmproducts_ecmstockdocinsideins' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockDocInsideIns',
                        'rhs_table' => 'ecmstockdocinsideins',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmstockdocinsideinitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmstockdocinsidein_id'
                ),
                
                'ecmproducts_ecmstockdocinsideouts' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockDocInsideOuts',
                        'rhs_table' => 'ecmstockdocinsideouts',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmstockdocinsideoutitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmstockdocinsideout_id'
                ),
                
                'ecmproducts_ecmstockdocmoves' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmStockDocMoves',
                        'rhs_table' => 'ecmstockdocmoves',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmstockdocmoveitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmstockdocmove_id'
                ),
                
                'ecmproducts_ecmdeliverynotes' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmDeliveryNotes',
                        'rhs_table' => 'ecmdeliverynotes',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmdeliverynoteitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmdeliverynote_id'
                ),
                
                'ecmproducts_ecminvoiceouts' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmInvoiceOuts',
                        'rhs_table' => 'ecminvoiceouts',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecminvoiceoutitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecminvoiceout_id'
                ),
                
                'ecmproducts_ecmquotes' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmQuotes',
                        'rhs_table' => 'ecmquotes',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmquoteitems',
                        'join_key_lhs' => 'ecmproduct_id',
                        'join_key_rhs' => 'ecmquote_id'
                ),
                
                'ecmpricebooks_ecmproducts' => array(
                        'lhs_module' => 'EcmPriceBooks',
                        'lhs_table' => 'ecmpricebooks',
                        'lhs_key' => 'id',
                        'rhs_module' => 'EcmProductB2Bs',
                        'rhs_table' => 'ecmproducts',
                        'rhs_key' => 'id',
                        'relationship_type' => 'many-to-many',
                        'join_table' => 'ecmpricebooks_ecmproducts',
                        'join_key_lhs' => 'ecmpricebook_id',
                        'join_key_rhs' => 'ecmproduct_id'
                ),
                
                'ecmproducts_notes' => array(
                        'lhs_module' => 'EcmProductB2Bs',
                        'lhs_table' => 'ecmproducts',
                        'lhs_key' => 'id',
                        'rhs_module' => 'Notes',
                        'rhs_table' => 'notes',
                        'rhs_key' => 'parent_id',
                        'relationship_type' => 'one-to-many',
                        'relationship_role_column' => 'parent_type',
                        'relationship_role_column_value' => 'EcmProductB2Bs'
                )
        ),
        // THIS FLAG ENABLES OPTIMISTIC LOCKING FOR SAVES FROM EDITVIEW
        'optimistic_locking' => true
);
?>