[ Index ] |
PHP Cross Reference of vtigercrm-6.1.0 |
[Summary view] [Print] [Text view]
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>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Fri Nov 28 20:08:37 2014 | Cross-referenced by PHPXref 0.7.1 |