[ Index ]

PHP Cross Reference of vtigercrm-6.1.0

title

Body

[close]

/pkg/vtiger/modules/Assets/ -> manifest.xml (source)

   1  <?xml version='1.0'?>
   2  <module>
   3      <exporttime>2010-04-15 17:28:36</exporttime>
   4      <name>Assets</name>
   5      <label>Assets</label>
   6      <parent>Inventory</parent>
   7      <version>2.0</version>
   8      <dependencies>
   9          <vtiger_version>6.0.0rc</vtiger_version>
  10          <vtiger_max_version>6.*</vtiger_max_version>
  11      </dependencies>
  12      <tables>
  13          <table>
  14              <name>vtiger_assets</name>
  15              <sql><![CDATA[CREATE TABLE `vtiger_assets` (
  16    `assetsid` int(11) NOT NULL,
  17    `asset_no` varchar(30) NOT NULL,
  18    `account` int(19),
  19    `product` int(19) NOT NULL,
  20    `serialnumber` varchar(200),
  21    `datesold` date,
  22    `dateinservice` date,
  23    `assetstatus` varchar(200) default 'In Service',
  24    `tagnumber` varchar(300) default NULL,
  25    `invoiceid` int(19) default NULL,
  26    `shippingmethod` varchar(200) default NULL,
  27    `shippingtrackingnumber` varchar(200) default NULL,
  28    `assetname` varchar(100) default NULL,
  29    PRIMARY KEY  (`assetsid`),
  30    CONSTRAINT `fk_1_vtiger_assets` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
  31  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]>
  32              </sql>
  33          </table>
  34          <table>
  35              <name>vtiger_assetscf</name>
  36              <sql><![CDATA[CREATE TABLE `vtiger_assetscf` (
  37    `assetsid` int(19) NOT NULL,
  38    PRIMARY KEY  (`assetsid`)
  39  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]>
  40              </sql>
  41          </table>
  42      </tables>
  43      <blocks>
  44          <block>
  45              <label>LBL_ASSET_INFORMATION</label>
  46              <fields>
  47                  <field>
  48                      <fieldname>asset_no</fieldname>
  49                      <uitype>4</uitype>
  50                      <columnname>asset_no</columnname>
  51                      <tablename>vtiger_assets</tablename>
  52                      <generatedtype>1</generatedtype>
  53                      <fieldlabel>Asset No</fieldlabel>
  54                      <readonly>1</readonly>
  55                      <presence>0</presence>
  56                      <defaultvalue></defaultvalue>
  57                      <sequence>2</sequence>
  58                      <maximumlength>100</maximumlength>
  59                      <typeofdata>V~O</typeofdata>
  60                      <quickcreate>3</quickcreate>
  61                      <quickcreatesequence>0</quickcreatesequence>
  62                      <displaytype>1</displaytype>
  63                      <info_type>BAS</info_type>
  64                      <helpinfo><![CDATA[]]>
  65                      </helpinfo>
  66                      <masseditable>0</masseditable>
  67                  </field>
  68                  <field>
  69                      <fieldname>product</fieldname>
  70                      <uitype>10</uitype>
  71                      <columnname>product</columnname>
  72                      <tablename>vtiger_assets</tablename>
  73                      <generatedtype>1</generatedtype>
  74                      <fieldlabel>Product Name</fieldlabel>
  75                      <readonly>1</readonly>
  76                      <presence>2</presence>
  77                      <defaultvalue></defaultvalue>
  78                      <sequence>3</sequence>
  79                      <maximumlength>100</maximumlength>
  80                      <typeofdata>V~M</typeofdata>
  81                      <quickcreate>0</quickcreate>
  82                      <quickcreatesequence>3</quickcreatesequence>
  83                      <displaytype>1</displaytype>
  84                      <info_type>BAS</info_type>
  85                      <helpinfo><![CDATA[]]>
  86                      </helpinfo>
  87                      <masseditable>1</masseditable>
  88                      <relatedmodules>
  89                          <relatedmodule>Products</relatedmodule>
  90                      </relatedmodules>
  91                  </field>
  92                  <field>
  93                      <fieldname>serialnumber</fieldname>
  94                      <uitype>2</uitype>
  95                      <columnname>serialnumber</columnname>
  96                      <tablename>vtiger_assets</tablename>
  97                      <generatedtype>1</generatedtype>
  98                      <fieldlabel>Serial Number</fieldlabel>
  99                      <readonly>1</readonly>
 100                      <presence>2</presence>
 101                      <defaultvalue></defaultvalue>
 102                      <sequence>4</sequence>
 103                      <maximumlength>100</maximumlength>
 104                      <typeofdata>V~M</typeofdata>
 105                      <quickcreate>0</quickcreate>
 106                      <quickcreatesequence>5</quickcreatesequence>
 107                      <displaytype>1</displaytype>
 108                      <info_type>BAS</info_type>
 109                      <helpinfo><![CDATA[]]>
 110                      </helpinfo>
 111                      <masseditable>1</masseditable>
 112                  </field>
 113                  <field>
 114                      <fieldname>datesold</fieldname>
 115                      <uitype>5</uitype>
 116                      <columnname>datesold</columnname>
 117                      <tablename>vtiger_assets</tablename>
 118                      <generatedtype>1</generatedtype>
 119                      <fieldlabel>Date Sold</fieldlabel>
 120                      <readonly>1</readonly>
 121                      <presence>2</presence>
 122                      <defaultvalue></defaultvalue>
 123                      <sequence>5</sequence>
 124                      <maximumlength>100</maximumlength>
 125                      <typeofdata>D~M~OTH~GE~datesold~Date Sold</typeofdata>
 126                      <quickcreate>0</quickcreate>
 127                      <quickcreatesequence>0</quickcreatesequence>
 128                      <displaytype>1</displaytype>
 129                      <info_type>BAS</info_type>
 130                      <helpinfo><![CDATA[]]>
 131                      </helpinfo>
 132                      <masseditable>1</masseditable>
 133                  </field>
 134                  <field>
 135                      <fieldname>dateinservice</fieldname>
 136                      <uitype>5</uitype>
 137                      <columnname>dateinservice</columnname>
 138                      <tablename>vtiger_assets</tablename>
 139                      <generatedtype>1</generatedtype>
 140                      <fieldlabel>Date in Service</fieldlabel>
 141                      <readonly>1</readonly>
 142                      <presence>2</presence>
 143                      <defaultvalue></defaultvalue>
 144                      <sequence>6</sequence>
 145                      <maximumlength>100</maximumlength>
 146                      <typeofdata>D~M~OTH~GE~dateinservice~Date in Service</typeofdata>
 147                      <quickcreate>0</quickcreate>
 148                      <quickcreatesequence>4</quickcreatesequence>
 149                      <displaytype>1</displaytype>
 150                      <info_type>BAS</info_type>
 151                      <helpinfo><![CDATA[]]>
 152                      </helpinfo>
 153                      <masseditable>1</masseditable>
 154                  </field>
 155                  <field>
 156                      <fieldname>assetstatus</fieldname>
 157                      <uitype>15</uitype>
 158                      <columnname>assetstatus</columnname>
 159                      <tablename>vtiger_assets</tablename>
 160                      <generatedtype>1</generatedtype>
 161                      <fieldlabel>Status</fieldlabel>
 162                      <readonly>1</readonly>
 163                      <presence>2</presence>
 164                      <defaultvalue></defaultvalue>
 165                      <sequence>7</sequence>
 166                      <maximumlength>100</maximumlength>
 167                      <typeofdata>V~M</typeofdata>
 168                      <quickcreate>0</quickcreate>
 169                      <quickcreatesequence></quickcreatesequence>
 170                      <displaytype>1</displaytype>
 171                      <info_type>BAS</info_type>
 172                      <helpinfo><![CDATA[]]>
 173                      </helpinfo>
 174                      <masseditable>1</masseditable>
 175                      <picklistvalues>
 176                          <picklistvalue>In Service</picklistvalue>
 177                          <picklistvalue>Out-of-service</picklistvalue>
 178                      </picklistvalues>
 179                  </field>
 180                  <field>
 181                      <fieldname>tagnumber</fieldname>
 182                      <uitype>2</uitype>
 183                      <columnname>tagnumber</columnname>
 184                      <tablename>vtiger_assets</tablename>
 185                      <generatedtype>1</generatedtype>
 186                      <fieldlabel>Tag Number</fieldlabel>
 187                      <readonly>1</readonly>
 188                      <presence>2</presence>
 189                      <defaultvalue></defaultvalue>
 190                      <sequence>8</sequence>
 191                      <maximumlength>100</maximumlength>
 192                      <typeofdata>V~O</typeofdata>
 193                      <quickcreate>1</quickcreate>
 194                      <quickcreatesequence></quickcreatesequence>
 195                      <displaytype>1</displaytype>
 196                      <info_type>BAS</info_type>
 197                      <helpinfo><![CDATA[]]>
 198                      </helpinfo>
 199                      <masseditable>1</masseditable>
 200                  </field>
 201                  <field>
 202                      <fieldname>invoiceid</fieldname>
 203                      <uitype>10</uitype>
 204                      <columnname>invoiceid</columnname>
 205                      <tablename>vtiger_assets</tablename>
 206                      <generatedtype>1</generatedtype>
 207                      <fieldlabel>Invoice Name</fieldlabel>
 208                      <readonly>1</readonly>
 209                      <presence>2</presence>
 210                      <defaultvalue></defaultvalue>
 211                      <sequence>9</sequence>
 212                      <maximumlength>100</maximumlength>
 213                      <typeofdata>V~O</typeofdata>
 214                      <quickcreate>1</quickcreate>
 215                      <quickcreatesequence></quickcreatesequence>
 216                      <displaytype>1</displaytype>
 217                      <info_type>BAS</info_type>
 218                      <helpinfo><![CDATA[]]>
 219                      </helpinfo>
 220                      <masseditable>1</masseditable>
 221                      <relatedmodules>
 222                          <relatedmodule>Invoice</relatedmodule>
 223                      </relatedmodules>
 224                  </field>
 225                  <field>
 226                      <fieldname>shippingmethod</fieldname>
 227                      <uitype>2</uitype>
 228                      <columnname>shippingmethod</columnname>
 229                      <tablename>vtiger_assets</tablename>
 230                      <generatedtype>1</generatedtype>
 231                      <fieldlabel>Shipping Method</fieldlabel>
 232                      <readonly>1</readonly>
 233                      <presence>2</presence>
 234                      <defaultvalue></defaultvalue>
 235                      <sequence>10</sequence>
 236                      <maximumlength>100</maximumlength>
 237                      <typeofdata>V~O</typeofdata>
 238                      <quickcreate>1</quickcreate>
 239                      <quickcreatesequence></quickcreatesequence>
 240                      <displaytype>1</displaytype>
 241                      <info_type>BAS</info_type>
 242                      <helpinfo><![CDATA[]]>
 243                      </helpinfo>
 244                      <masseditable>1</masseditable>
 245                  </field>
 246                  <field>
 247                      <fieldname>shippingtrackingnumber</fieldname>
 248                      <uitype>2</uitype>
 249                      <columnname>shippingtrackingnumber</columnname>
 250                      <tablename>vtiger_assets</tablename>
 251                      <generatedtype>1</generatedtype>
 252                      <fieldlabel>Shipping Tracking Number</fieldlabel>
 253                      <readonly>1</readonly>
 254                      <presence>2</presence>
 255                      <defaultvalue></defaultvalue>
 256                      <sequence>11</sequence>
 257                      <maximumlength>100</maximumlength>
 258                      <typeofdata>V~O</typeofdata>
 259                      <quickcreate>1</quickcreate>
 260                      <quickcreatesequence></quickcreatesequence>
 261                      <displaytype>1</displaytype>
 262                      <info_type>BAS</info_type>
 263                      <helpinfo><![CDATA[]]>
 264                      </helpinfo>
 265                      <masseditable>1</masseditable>
 266                  </field>
 267                  <field>
 268                      <fieldname>assigned_user_id</fieldname>
 269                      <uitype>53</uitype>
 270                      <columnname>smownerid</columnname>
 271                      <tablename>vtiger_crmentity</tablename>
 272                      <generatedtype>1</generatedtype>
 273                      <fieldlabel>Assigned To</fieldlabel>
 274                      <readonly>1</readonly>
 275                      <presence>2</presence>
 276                      <defaultvalue></defaultvalue>
 277                      <sequence>4</sequence>
 278                      <maximumlength>100</maximumlength>
 279                      <typeofdata>V~M</typeofdata>
 280                      <quickcreate>0</quickcreate>
 281                      <quickcreatesequence>2</quickcreatesequence>
 282                      <displaytype>1</displaytype>
 283                      <info_type>BAS</info_type>
 284                      <helpinfo><![CDATA[]]>
 285                      </helpinfo>
 286                      <masseditable>1</masseditable>
 287                  </field>
 288                  <field>
 289                      <fieldname>assetname</fieldname>
 290                      <uitype>1</uitype>
 291                      <columnname>assetname</columnname>
 292                      <tablename>vtiger_assets</tablename>
 293                      <generatedtype>1</generatedtype>
 294                      <fieldlabel>Asset Name</fieldlabel>
 295                      <readonly>1</readonly>
 296                      <presence>0</presence>
 297                      <defaultvalue></defaultvalue>
 298                      <sequence>12</sequence>
 299                      <maximumlength>100</maximumlength>
 300                      <typeofdata>V~M</typeofdata>
 301                      <quickcreate>0</quickcreate>
 302                      <quickcreatesequence>6</quickcreatesequence>
 303                      <displaytype>1</displaytype>
 304                      <info_type>BAS</info_type>
 305                      <helpinfo><![CDATA[]]>
 306                      </helpinfo>
 307                      <masseditable>1</masseditable>
 308                      <entityidentifier>
 309                          <entityidfield>assetsid</entityidfield>
 310                          <entityidcolumn>assetsid</entityidcolumn>
 311                      </entityidentifier>
 312                  </field>
 313                  <field>
 314                      <fieldname>account</fieldname>
 315                      <uitype>10</uitype>
 316                      <columnname>account</columnname>
 317                      <tablename>vtiger_assets</tablename>
 318                      <generatedtype>1</generatedtype>
 319                      <fieldlabel>Customer Name</fieldlabel>
 320                      <readonly>1</readonly>
 321                      <presence>2</presence>
 322                      <defaultvalue></defaultvalue>
 323                      <sequence>13</sequence>
 324                      <maximumlength>100</maximumlength>
 325                      <typeofdata>V~M</typeofdata>
 326                      <quickcreate>0</quickcreate>
 327                      <quickcreatesequence></quickcreatesequence>
 328                      <displaytype>1</displaytype>
 329                      <info_type>BAS</info_type>
 330                      <helpinfo><![CDATA[]]>
 331                      </helpinfo>
 332                      <masseditable>1</masseditable>
 333                      <relatedmodules>
 334                          <relatedmodule>Accounts</relatedmodule>
 335                      </relatedmodules>
 336                  </field>
 337                       <field>
 338                      <fieldname>contact</fieldname>
 339                      <uitype>10</uitype>
 340                      <columnname>contact</columnname>
 341                      <tablename>vtiger_assets</tablename>
 342                      <generatedtype>1</generatedtype>
 343                      <fieldlabel>Contact Name</fieldlabel>
 344                      <readonly>1</readonly>
 345                      <presence>2</presence>
 346                      <defaultvalue></defaultvalue>
 347                      <sequence>14</sequence>
 348                      <maximumlength>100</maximumlength>
 349                      <typeofdata>V~O</typeofdata>
 350                      <quickcreate>0</quickcreate>
 351                      <quickcreatesequence></quickcreatesequence>
 352                      <displaytype>1</displaytype>
 353                      <columntype>int(19)</columntype>        
 354                      <info_type>BAS</info_type>
 355                      <helpinfo><![CDATA[]]>
 356                      </helpinfo>
 357                      <masseditable>1</masseditable>
 358                      <relatedmodules>
 359                          <relatedmodule>Contacts</relatedmodule>
 360                      </relatedmodules>
 361                  </field>
 362                  <field>
 363                      <fieldname>createdtime</fieldname>
 364                      <uitype>70</uitype>
 365                      <columnname>createdtime</columnname>
 366                      <tablename>vtiger_crmentity</tablename>
 367                      <generatedtype>1</generatedtype>
 368                      <fieldlabel>Created Time</fieldlabel>
 369                      <readonly>1</readonly>
 370                      <presence>0</presence>
 371                      <defaultvalue></defaultvalue>
 372                      <sequence>14</sequence>
 373                      <maximumlength>100</maximumlength>
 374                      <typeofdata>DT~O</typeofdata>
 375                      <quickcreate>3</quickcreate>
 376                      <quickcreatesequence></quickcreatesequence>
 377                      <displaytype>2</displaytype>
 378                      <info_type>BAS</info_type>
 379                      <helpinfo><![CDATA[]]>
 380                      </helpinfo>
 381                      <masseditable>0</masseditable>
 382                  </field>
 383                  <field>
 384                      <fieldname>modifiedtime</fieldname>
 385                      <uitype>70</uitype>
 386                      <columnname>modifiedtime</columnname>
 387                      <tablename>vtiger_crmentity</tablename>
 388                      <generatedtype>1</generatedtype>
 389                      <fieldlabel>Modified Time</fieldlabel>
 390                      <readonly>1</readonly>
 391                      <presence>0</presence>
 392                      <defaultvalue></defaultvalue>
 393                      <sequence>15</sequence>
 394                      <maximumlength>100</maximumlength>
 395                      <typeofdata>DT~O</typeofdata>
 396                      <quickcreate>3</quickcreate>
 397                      <quickcreatesequence></quickcreatesequence>
 398                      <displaytype>2</displaytype>
 399                      <info_type>BAS</info_type>
 400                      <helpinfo><![CDATA[]]>
 401                      </helpinfo>
 402                      <masseditable>0</masseditable>
 403                  </field>
 404                  <field>
 405                      <fieldname>modifiedby</fieldname>
 406                      <uitype>52</uitype>
 407                      <columnname>modifiedby</columnname>
 408                      <tablename>vtiger_crmentity</tablename>
 409                      <generatedtype>1</generatedtype>
 410                      <fieldlabel>Last Modified By</fieldlabel>
 411                      <readonly>1</readonly>
 412                      <presence>0</presence>
 413                      <defaultvalue></defaultvalue>
 414                      <sequence>16</sequence>
 415                      <maximumlength>100</maximumlength>
 416                      <typeofdata>V~O</typeofdata>
 417                      <quickcreate>3</quickcreate>
 418                      <quickcreatesequence></quickcreatesequence>
 419                      <displaytype>3</displaytype>
 420                      <info_type>BAS</info_type>
 421                      <helpinfo><![CDATA[]]>
 422                      </helpinfo>
 423                      <masseditable>0</masseditable>
 424                  </field>
 425              </fields>
 426          </block>
 427          <block>
 428              <label>LBL_CUSTOM_INFORMATION</label>
 429          </block>
 430          <block>
 431              <label>LBL_DESCRIPTION_INFORMATION</label>
 432              <fields>
 433                  <field>
 434                      <fieldname>description</fieldname>
 435                      <uitype>19</uitype>
 436                      <columnname>description</columnname>
 437                      <tablename>vtiger_crmentity</tablename>
 438                      <generatedtype>1</generatedtype>
 439                      <fieldlabel>Notes</fieldlabel>
 440                      <readonly>1</readonly>
 441                      <presence>2</presence>
 442                      <defaultvalue></defaultvalue>
 443                      <sequence>1</sequence>
 444                      <maximumlength>100</maximumlength>
 445                      <typeofdata>V~O</typeofdata>
 446                      <quickcreate>1</quickcreate>
 447                      <quickcreatesequence></quickcreatesequence>
 448                      <displaytype>1</displaytype>
 449                      <info_type>BAS</info_type>
 450                      <helpinfo><![CDATA[]]>
 451                      </helpinfo>
 452                      <masseditable>1</masseditable>
 453                  </field>
 454              </fields>
 455          </block>
 456      </blocks>
 457      <customviews>
 458          <customview>
 459              <viewname>All</viewname>
 460              <setdefault>true</setdefault>
 461              <setmetrics>false</setmetrics>
 462              <fields>
 463                  <field>
 464                      <fieldname>asset_no</fieldname>
 465                      <columnindex>0</columnindex>
 466                  </field>
 467                  <field>
 468                      <fieldname>assetname</fieldname>
 469                      <columnindex>1</columnindex>
 470                  </field>
 471                  <field>
 472                      <fieldname>account</fieldname>
 473                      <columnindex>2</columnindex>
 474                  </field>
 475                  <field>
 476                      <fieldname>product</fieldname>
 477                      <columnindex>3</columnindex>
 478                  </field>
 479              </fields>
 480          </customview>
 481      </customviews>
 482      <sharingaccess>
 483          <default>public_readwritedelete</default>
 484      </sharingaccess>
 485      <actions>
 486          <action>
 487              <name><![CDATA[Import]]>
 488              </name>
 489              <status>enabled</status>
 490          </action>
 491          <action>
 492              <name><![CDATA[Export]]>
 493              </name>
 494              <status>enabled</status>
 495          </action>
 496          <action>
 497              <name><![CDATA[DuplicatesHandling]]>
 498              </name>
 499              <status>enabled</status>
 500          </action>
 501      </actions>
 502      <relatedlists>
 503          <relatedlist>
 504              <function>get_related_list</function>
 505              <label>HelpDesk</label>
 506              <sequence>1</sequence>
 507              <presence>0</presence>
 508              <actions>
 509                  <action>ADD</action>
 510                  <action>SELECT</action>
 511              </actions>
 512              <relatedmodule>HelpDesk</relatedmodule>
 513          </relatedlist>
 514          <relatedlist>
 515              <function>get_attachments</function>
 516              <label>Documents</label>
 517              <sequence>11</sequence>
 518              <presence>0</presence>
 519              <actions>
 520                  <action>ADD</action>
 521                  <action>SELECT</action>
 522              </actions>
 523              <relatedmodule>Documents</relatedmodule>
 524          </relatedlist>
 525      </relatedlists>
 526      <migrations>
 527          <migration version='2.0'>
 528              <tables>
 529                  <table>
 530                      <name>vtiger_assets</name>
 531                      <sql>
 532                          ![CDATA[ALTER TABLE vtiger_assets MODIFY datesold date]]
 533                      </sql>
 534                  </table>
 535                  <table>
 536                      <name>vtiger_assets</name>
 537                      <sql>![CDATA[ALTER TABLE vtiger_assets MODIFY dateinservice date]]</sql>
 538                  </table>
 539                  <table>
 540                      <name>vtiger_assets</name>
 541                      <sql>![CDATA[ALTER TABLE vtiger_assets MODIFY serialnumber  varchar(200)]]</sql>
 542                  </table>
 543                  <table>
 544                      <name>vtiger_assets</name>
 545                      <sql>![CDATA[ALTER TABLE vtiger_assets MODIFY account  int(19)]]</sql>
 546                  </table>
 547              </tables>
 548          </migration>
 549      </migrations>
 550  </module>


Generated: Fri Nov 28 20:08:37 2014 Cross-referenced by PHPXref 0.7.1