<?php
return array(
    'Inventory' => array(
        'fields' => array(
            array('tablename' => "vtiger_inventoryproductrel", 'columnname' => "productid",
                'fieldname' => "productname", 'fieldlabel' => "LBL_SUBJECT_TITLE", 'uitype' => -22,
                'typeofdata' => 'N~M', 'presence' => 1, 'block' => 52),
            array('tablename' => "vtiger_inventoryproductrel", 'columnname' => "quantity",
                'fieldname' => "quantity", 'fieldlabel' => "LBL_QTY", 'uitype' => 7,
                'typeofdata' => 'N~M', 'presence' => 1, 'block' => 52),
            array('tablename' => "vtiger_inventoryproductrel", 'columnname' => "listprice",
                'fieldname' => "listprice", 'fieldlabel' => "LBL_LIST_PRICE", 'uitype' => 7,
                'typeofdata' => 'N~M', 'presence' => 1, 'block' => 52),
            array('tablename' => "vtiger_inventoryproductrel", 'columnname' => "comment",
                'fieldname' => "comment", 'fieldlabel' => "LBL_ITEM_COMMENT", 'uitype' => 1,
                'typeofdata' => 'V~O', 'presence' => 1, 'block' => 52),
            array('tablename' => "vtiger_inventoryproductrel", 'columnname' => "quantity`*`#alias#`.`listprice",
                'fieldname' => "netprice", 'fieldlabel' => "LBL_NET_PRICE", 'uitype' => 7,
                'typeofdata' => 'V~O', 'presence' => 1, 'block' => 52),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "discount_percent",
                'fieldname' => "discount_percent",
                'fieldlabel' => "Item Discount Percent",
                'uitype' => 7,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "discount_amount",
                'fieldname' => "discount_amount",
                'fieldlabel' => "Item Discount Amount",
                'uitype' => 71,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "tax1",
                'fieldname' => "tax1",
                'fieldlabel' => "VAT",
                'uitype' => 83,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "tax2",
                'fieldname' => "tax2",
                'fieldlabel' => "Sales",
                'uitype' => 83,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "tax3",
                'fieldname' => "tax3",
                'fieldlabel' => "Service",
                'uitype' => 83,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "purchase_cost",
                'fieldname' => "purchase_cost",
                'fieldlabel' => "Purchase Cost",
                'uitype' => 71,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "comment",
                'fieldname' => "comment",
                'fieldlabel' => "Item Comment",
                'uitype' => 19,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "margin",
                'fieldname' => "margin",
                'fieldlabel' => "Margin",
                'uitype' => 71,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            // SAI
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "erpdiscount1",
                'fieldname' => "erpdiscount1",
                'fieldlabel' => "Descuento ERP 1",
                'uitype' => 7,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "erpdiscount2",
                'fieldname' => "erpdiscount2",
                'fieldlabel' => "Descuento ERP 2",
                'uitype' => 7,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "erpdiscount3",
                'fieldname' => "erpdiscount3",
                'fieldlabel' => "Descuento ERP 3",
                'uitype' => 7,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "erpdiscount4",
                'fieldname' => "erpdiscount4",
                'fieldlabel' => "Descuento ERP 4",
                'uitype' => 7,
                'typeofdata' => 'N~O',
                'presence' => 1,
                'block' => 52
            ),
            array(
                'tablename' => "vtiger_inventoryproductrel",
                'columnname' => "auxname",
                'fieldname' => "auxname",
                'fieldlabel' => "Nombre auxiliar",
                'uitype' => 1,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => 52
            ),
        ),
        'tab_name_index' => array('vtiger_inventoryproductrel' => 'lineitem_id'),
        'table_name' => 'vtiger_inventoryproductrel',
        'table_index' => 'lineitem_id',
        'blocks' => array(
            array("blockid" => 52, "blocklabel" => 'LBL_ITEM_DETAILS')
        )
    ),
    'Inventory2' => array(
        'tab_name_index' => array('vtiger_inventoryproductrel' => 'lineitem_id'),
        'table_name' => 'vtiger_inventoryproductrel',
        'table_index' => 'lineitem_id'
    ),
    'CampaignAcc' => array(
        'fields' => array(
            array(
                'tablename' => "vtiger_campaignaccountrel",
                'columnname' => "campaignid",
                'fieldname' => "campaignid",
                'fieldlabel' => "Campaign",
                'uitype' => 58,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -1
            ),
            array(
                'tablename' => "vtiger_campaignaccountrel",
                'columnname' => "accountid",
                'fieldname' => "accountname",
                'fieldlabel' => "Account",
                'uitype' => 51,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -1
            ),
            array(
                'tablename' => "vtiger_campaignaccountrel",
                'columnname' => "campaignrelstatusid",
                'fieldname' => "campaignrelstatus",
                'fieldlabel' => "Status", 'uitype' => -24,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => -1
            ),
        ),
        'tab_name_index' => array('vtiger_campaignaccountrel' => 'accountid'),
        'table_name' => 'vtiger_campaignaccountrel',
        'table_index' => 'accountid',
        'blocks' => array(
            array("blockid" => -1, "blocklabel" => 'Accounts')
        )
    ),
    'PriceBooksRel' => array(
        'fields' => array(
            array('tablename' => "vtiger_pricebookproductrel", 'columnname' => "pricebookid",
                'fieldname' => "pricebookid", 'fieldlabel' => "PriceBook ID", 'uitype' => 59,
                'typeofdata' => 'I~M', 'presence' => 1, 'block' => -4),
            array('tablename' => "vtiger_pricebookproductrel", 'columnname' => "productid",
                'fieldname' => "productid", 'fieldlabel' => "Product ID", 'uitype' => 59,
                'typeofdata' => 'I~M', 'presence' => 1, 'block' => -4),
            array('tablename' => "vtiger_pricebookproductrel", 'columnname' => "listprice",
                'fieldname' => "listprice", 'fieldlabel' => "List price", 'uitype' => 72,
                'typeofdata' => 'N~M', 'presence' => 1, 'block' => -4),
            array('tablename' => "vtiger_pricebookproductrel", 'columnname' => "usedcurrency",
                'fieldname' => "usedcurrency", 'fieldlabel' => "Currency", 'uitype' => 117,
                'typeofdata' => 'I~M', 'presence' => 1, 'block' => -4),
        ),
        'tab_name_index' => array('vtiger_pricebookproductrel' => 'pricebookid'),
        'table_name' => 'vtiger_pricebookproductrel',
        'table_index' => 'pricebookid',
        'blocks' => array(
            array("blockid" => -4, "blocklabel" => 'PriceBook Relation')
        )
    ),
    'CampaignCont' => array(
        'fields' => array(
            array(
                'tablename' => "vtiger_campaigncontrel",
                'columnname' => "campaignid",
                'fieldname' => "campaignid",
                'fieldlabel' => "Campaign",
                'uitype' => 58,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -2
            ),
            array(
                'tablename' => "vtiger_campaigncontrel",
                'columnname' => "contactid",
                'fieldname' => "contactname",
                'fieldlabel' => "Contact",
                'uitype' => 57,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -2
            ),
            array(
                'tablename' => "vtiger_campaigncontrel",
                'columnname' => "campaignrelstatusid",
                'fieldname' => "campaignrelstatus",
                'fieldlabel' => "Status",
                'uitype' => -24,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -2
            ),
        ),
        'tab_name_index' => array('vtiger_campaigncontrel' => 'contactid'),
        'table_name' => 'vtiger_campaigncontrel',
        'table_index' => 'contactid',
        'blocks' => array(
            array("blockid" => -2, "blocklabel" => 'Contacts')
        )
    ),
    'CampaignLead' => array(
        'fields' => array(
            array(
                'tablename' => "vtiger_campaignleadrel",
                'columnname' => "campaignid",
                'fieldname' => "campaignid",
                'fieldlabel' => "Campaign",
                'uitype' => 58,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -3
            ),
            array(
                'tablename' => "vtiger_campaignleadrel",
                'columnname' => "leadid",
                'fieldname' => "leadname",
                'fieldlabel' => "Lead",
                'uitype' => -23,
                'typeofdata' => 'N~M',
                'presence' => 1,
                'block' => -3
            ),
            array(
                'tablename' => "vtiger_campaignleadrel",
                'columnname' => "campaignrelstatusid",
                'fieldname' => "campaignrelstatus",
                'fieldlabel' => "Status",
                'uitype' => -24,
                'typeofdata' => 'V~O',
                'presence' => 1,
                'block' => -3
            ),
        ),
        'tab_name_index' => array('vtiger_campaignleadrel' => 'leadid'),
        'table_name' => 'vtiger_campaignleadrel',
        'table_index' => 'leadid',
        'blocks' => array(
            array("blockid" => -3, "blocklabel" => 'Leads')
        )
    ),
    'Roles' => array(
        'fields' => array(
            array(
                "tablename" => "vtiger_role",
                "columnname" => "roleid",
                "fieldname" => "roleid",
                "fieldlabel" => "Role ID",
                "uitype" => 15,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -6,
            ),
            array(
                "tablename" => "vtiger_role",
                "columnname" => "rolename",
                "fieldname" => "rolename",
                "fieldlabel" => "Role Name",
                "uitype" => 15,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -6,
            ),
        ),
        "tab_name_index" => array(
            "vtiger_role" => "roleid",
        ),
        "table_name" => "vtiger_role",
        "table_index" => "roleid",
        'blocks' => array(
            array(
                "blockid" => -6,
                "blocklabel" => "Roles",
            )
        )
    ),
    'Groups' => array(
        'fields' => array(
            array(
                "tablename" => "vtiger_groups",
                "columnname" => "groupid",
                "fieldname" => "groupid",
                "fieldlabel" => "Group ID",
                "uitype" => 15,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -7,
            ),
            array(
                "tablename" => "vtiger_groups",
                "columnname" => "groupname",
                "fieldname" => "groupname",
                "fieldlabel" => "Group Name",
                "uitype" => 15,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -7,
            ),
            array(
                "tablename" => "vtiger_groups",
                "columnname" => "description",
                "fieldname" => "description",
                "fieldlabel" => "Group Description",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -7,
            ),
        ),
        "tab_name_index" => array(
            "vtiger_groups" => "groupid",
        ),
        "table_name" => "vtiger_groups",
        "table_index" => "groupid",
        'blocks' => array(
            array(
                "blockid" => -7,
                "blocklabel" => "Groups",
            )
        )
    ),
    'Events' => array(
        "tab_name_index" => array(
            "vtiger_activity" => "activityid",
        ),
        "table_name" => "vtiger_activity",
        "table_index" => "activityid",
    ),
    'Document Folder' => array(
        'fields' => array(
            array(
                "tablename" => "vtiger_attachmentsfolder",
                "columnname" => "folderid",
                "fieldname" => "folderid",
                "fieldlabel" => "Folder ID",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -7,
            ),
            array(
                "tablename" => "vtiger_attachmentsfolder",
                "columnname" => "foldername",
                "fieldname" => "foldername",
                "fieldlabel" => "Folder Name",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -7,
            ),
            array(
                "tablename" => "vtiger_attachmentsfolder",
                "columnname" => "description",
                "fieldname" => "description",
                "fieldlabel" => "Folder Description",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -7,
            ),
        ),
        "tab_name_index" => array(
            "vtiger_attachmentsfolder" => "folderid",
        ),
        "table_name" => "vtiger_attachmentsfolder",
        "table_index" => "folderid",
        'blocks' => array(
            array(
                "blockid" => -7,
                "blocklabel" => "Folders",
            )
        )
    ),
    'CRMEntity' => array(
        "tab_name_index" => array(
            "vtiger_crmentity" => "crmid",
        ),
        "table_name" => "vtiger_crmentity",
        "table_index" => "crmid",
        'blocks' => array(
            array(
                "blockid" => -8,
                "blocklabel" => "CRMEntity",
            )
        ),
        'fields' => array(
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "crmid",
                "fieldname" => "crmid",
                "fieldlabel" => "crmid",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "smcreatorid",
                "fieldname" => "smcreatorid",
                "fieldlabel" => "smcreatorid",
                "uitype" => 52,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "smownerid",
                "fieldname" => "smownerid",
                "fieldlabel" => "smownerid",
                "uitype" => 53,
                "typeofdata" => "V~M",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "modifiedby",
                "fieldname" => "modifiedby",
                "fieldlabel" => "modifiedby",
                "uitype" => 52,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "setype",
                "fieldname" => "setype",
                "fieldlabel" => "setype",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "description",
                "fieldname" => "description",
                "fieldlabel" => "description",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "createdtime",
                "fieldname" => "createdtime",
                "fieldlabel" => "createdtime",
                "uitype" => 70,
                "typeofdata" => "DT~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "modifiedtime",
                "fieldname" => "modifiedtime",
                "fieldlabel" => "modifiedtime",
                "uitype" => 70,
                "typeofdata" => "DT~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "viewedtime",
                "fieldname" => "viewedtime",
                "fieldlabel" => "viewedtime",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "status",
                "fieldname" => "status",
                "fieldlabel" => "status",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "version",
                "fieldname" => "version",
                "fieldlabel" => "version",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "presence",
                "fieldname" => "presence",
                "fieldlabel" => "presence",
                "uitype" => 56,
                "typeofdata" => "C~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "deleted",
                "fieldname" => "deleted",
                "fieldlabel" => "deleted",
                "uitype" => 56,
                "typeofdata" => "C~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "smgroupid",
                "fieldname" => "smgroupid",
                "fieldlabel" => "smgroupid",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "source",
                "fieldname" => "source",
                "fieldlabel" => "source",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
            array(
                "tablename" => "vtiger_crmentity",
                "columnname" => "label",
                "fieldname" => "label",
                "fieldlabel" => "label",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -8,
            ),
        )
    ),
    'LoginHistory' => array(
        'fields' => array(
            array(
                "tablename" => "vtiger_loginhistory",
                "columnname" => "login_id",
                "fieldname" => "login_id",
                "fieldlabel" => "Login ID",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -9,
            ),
            array(
                "tablename" => "vtiger_loginhistory",
                "columnname" => "user_name",
                "fieldname" => "user_name",
                "fieldlabel" => "User Name",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -9,
            ),
            array(
                "tablename" => "vtiger_loginhistory",
                "columnname" => "user_ip",
                "fieldname" => "user_ip",
                "fieldlabel" => "User IP",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -9,
            ),
            array(
                "tablename" => "vtiger_loginhistory",
                "columnname" => "logout_time",
                "fieldname" => "logout_time",
                "fieldlabel" => "Logout Time",
                "uitype" => 70,
                "typeofdata" => "DT~O",
                "presence" => 1,
                "block" => -9,
            ),
            array(
                "tablename" => "vtiger_loginhistory",
                "columnname" => "login_time",
                "fieldname" => "login_time",
                "fieldlabel" => "Login Time",
                "uitype" => 70,
                "typeofdata" => "DT~O",
                "presence" => 1,
                "block" => -9,
            ),
            array(
                "tablename" => "vtiger_loginhistory",
                "columnname" => "status",
                "fieldname" => "status",
                "fieldlabel" => "Status",
                "uitype" => 1,
                "typeofdata" => "V~O",
                "presence" => 1,
                "block" => -9,
            ),
        ),
        "tab_name_index" => array(
            "vtiger_loginhistory" => "login_id",
        ),
        "table_name" => "vtiger_loginhistory",
        "table_index" => "login_id",
        'blocks' => array(
            array(
                "blockid" => -9,
                "blocklabel" => "Login History",
            )
        )
    ),
);
