| [ Index ] |
PHP Cross Reference of vtigercrm-6.1.0 |
[Summary view] [Print] [Text view]
1 <?xml version='1.0'?> 2 <module> 3 <exporttime>2009-02-06 12:10:08</exporttime> 4 <name>Services</name> 5 <label>Services</label> 6 <parent>Inventory</parent> 7 <version>2.6</version> 8 <dependencies> 9 <vtiger_version>6.0.0rc</vtiger_version> 10 <vtiger_max_version>6.*</vtiger_max_version> 11 </dependencies> 12 <migrations> 13 <migration version='1.0'> 14 </migration> 15 </migrations> 16 <tables> 17 <table> 18 <name>vtiger_service</name> 19 <sql><![CDATA[CREATE TABLE `vtiger_service` ( 20 `serviceid` int(11) NOT NULL, 21 `service_no` varchar(100) NOT NULL, 22 `servicename` varchar(50) NOT NULL, 23 `servicecategory` varchar(200) default NULL, 24 `qty_per_unit` decimal(11,2) default '0.00', 25 `unit_price` decimal(25,2) default NULL, 26 `sales_start_date` date default NULL, 27 `sales_end_date` date default NULL, 28 `start_date` date default NULL, 29 `expiry_date` date default NULL, 30 `discontinued` int(1) NOT NULL default '0', 31 `service_usageunit` varchar(200) default NULL, 32 `website` varchar(100) default NULL, 33 `taxclass` varchar(200) default NULL, 34 `currency_id` int(19) NOT NULL default '1', 35 `commissionrate` decimal(7,3) default NULL, 36 PRIMARY KEY (`serviceid`), 37 CONSTRAINT `fk_1_vtiger_service` FOREIGN KEY (`serviceid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE 38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql> 39 </table> 40 <table> 41 <name>vtiger_servicecf</name> 42 <sql><![CDATA[CREATE TABLE `vtiger_servicecf` ( 43 `serviceid` int(19) NOT NULL default '0', 44 PRIMARY KEY (`serviceid`) 45 ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql> 46 </table> 47 </tables> 48 <blocks> 49 <block> 50 <label>LBL_SERVICE_INFORMATION</label> 51 <fields> 52 <field> 53 <fieldname>servicename</fieldname> 54 <uitype>2</uitype> 55 <columnname>servicename</columnname> 56 <tablename>vtiger_service</tablename> 57 <generatedtype>1</generatedtype> 58 <fieldlabel>Service Name</fieldlabel> 59 <readonly>1</readonly> 60 <presence>0</presence> 61 <defaultvalue></defaultvalue> 62 <sequence>1</sequence> 63 <maximumlength>100</maximumlength> 64 <typeofdata>V~M</typeofdata> 65 <quickcreate>0</quickcreate> 66 <quickcreatesequence>1</quickcreatesequence> 67 <displaytype>1</displaytype> 68 <info_type>BAS</info_type> 69 <helpinfo><![CDATA[]]></helpinfo> 70 <masseditable>1</masseditable> 71 <entityidentifier> 72 <entityidfield>serviceid</entityidfield> 73 <entityidcolumn>serviceid</entityidcolumn> 74 </entityidentifier> 75 </field> 76 <field> 77 <fieldname>service_no</fieldname> 78 <uitype>4</uitype> 79 <columnname>service_no</columnname> 80 <tablename>vtiger_service</tablename> 81 <generatedtype>1</generatedtype> 82 <fieldlabel>Service No</fieldlabel> 83 <readonly>1</readonly> 84 <presence>0</presence> 85 <defaultvalue></defaultvalue> 86 <sequence>2</sequence> 87 <maximumlength>100</maximumlength> 88 <typeofdata>V~O</typeofdata> 89 <quickcreate>3</quickcreate> 90 <quickcreatesequence></quickcreatesequence> 91 <displaytype>1</displaytype> 92 <info_type>BAS</info_type> 93 <helpinfo><![CDATA[]]></helpinfo> 94 <masseditable>0</masseditable> 95 </field> 96 <field> 97 <fieldname>discontinued</fieldname> 98 <uitype>56</uitype> 99 <columnname>discontinued</columnname> 100 <tablename>vtiger_service</tablename> 101 <generatedtype>1</generatedtype> 102 <fieldlabel>Service Active</fieldlabel> 103 <readonly>1</readonly> 104 <presence>2</presence> 105 <defaultvalue></defaultvalue> 106 <sequence>4</sequence> 107 <maximumlength>100</maximumlength> 108 <typeofdata>V~O</typeofdata> 109 <quickcreate>2</quickcreate> 110 <quickcreatesequence>3</quickcreatesequence> 111 <displaytype>1</displaytype> 112 <info_type>BAS</info_type> 113 <helpinfo><![CDATA[]]></helpinfo> 114 <masseditable>1</masseditable> 115 </field> 116 <field> 117 <fieldname>sales_start_date</fieldname> 118 <uitype>5</uitype> 119 <columnname>sales_start_date</columnname> 120 <tablename>vtiger_service</tablename> 121 <generatedtype>1</generatedtype> 122 <fieldlabel>Sales Start Date</fieldlabel> 123 <readonly>1</readonly> 124 <presence>2</presence> 125 <defaultvalue></defaultvalue> 126 <sequence>9</sequence> 127 <maximumlength>100</maximumlength> 128 <typeofdata>D~O</typeofdata> 129 <quickcreate>1</quickcreate> 130 <quickcreatesequence></quickcreatesequence> 131 <displaytype>1</displaytype> 132 <info_type>BAS</info_type> 133 <helpinfo><![CDATA[]]></helpinfo> 134 <masseditable>1</masseditable> 135 </field> 136 <field> 137 <fieldname>sales_end_date</fieldname> 138 <uitype>5</uitype> 139 <columnname>sales_end_date</columnname> 140 <tablename>vtiger_service</tablename> 141 <generatedtype>1</generatedtype> 142 <fieldlabel>Sales End Date</fieldlabel> 143 <readonly>1</readonly> 144 <presence>2</presence> 145 <defaultvalue></defaultvalue> 146 <sequence>10</sequence> 147 <maximumlength>100</maximumlength> 148 <typeofdata>D~O~OTH~GE~sales_start_date~Sales Start Date</typeofdata> 149 <quickcreate>1</quickcreate> 150 <quickcreatesequence></quickcreatesequence> 151 <displaytype>1</displaytype> 152 <info_type>BAS</info_type> 153 <helpinfo><![CDATA[]]></helpinfo> 154 <masseditable>1</masseditable> 155 </field> 156 <field> 157 <fieldname>start_date</fieldname> 158 <uitype>5</uitype> 159 <columnname>start_date</columnname> 160 <tablename>vtiger_service</tablename> 161 <generatedtype>1</generatedtype> 162 <fieldlabel>Support Start Date</fieldlabel> 163 <readonly>1</readonly> 164 <presence>2</presence> 165 <defaultvalue></defaultvalue> 166 <sequence>11</sequence> 167 <maximumlength>100</maximumlength> 168 <typeofdata>D~O</typeofdata> 169 <quickcreate>1</quickcreate> 170 <quickcreatesequence></quickcreatesequence> 171 <displaytype>1</displaytype> 172 <info_type>BAS</info_type> 173 <helpinfo><![CDATA[]]></helpinfo> 174 <masseditable>1</masseditable> 175 </field> 176 <field> 177 <fieldname>expiry_date</fieldname> 178 <uitype>5</uitype> 179 <columnname>expiry_date</columnname> 180 <tablename>vtiger_service</tablename> 181 <generatedtype>1</generatedtype> 182 <fieldlabel>Support Expiry Date</fieldlabel> 183 <readonly>1</readonly> 184 <presence>2</presence> 185 <defaultvalue></defaultvalue> 186 <sequence>12</sequence> 187 <maximumlength>100</maximumlength> 188 <typeofdata>D~O~OTH~GE~start_date~Start Date</typeofdata> 189 <quickcreate>1</quickcreate> 190 <quickcreatesequence></quickcreatesequence> 191 <displaytype>1</displaytype> 192 <info_type>BAS</info_type> 193 <helpinfo><![CDATA[]]></helpinfo> 194 <masseditable>1</masseditable> 195 </field> 196 <field> 197 <fieldname>website</fieldname> 198 <uitype>17</uitype> 199 <columnname>website</columnname> 200 <tablename>vtiger_service</tablename> 201 <generatedtype>1</generatedtype> 202 <fieldlabel>Website</fieldlabel> 203 <readonly>1</readonly> 204 <presence>2</presence> 205 <defaultvalue></defaultvalue> 206 <sequence>6</sequence> 207 <maximumlength>100</maximumlength> 208 <typeofdata>V~O</typeofdata> 209 <quickcreate>1</quickcreate> 210 <quickcreatesequence></quickcreatesequence> 211 <displaytype>1</displaytype> 212 <info_type>BAS</info_type> 213 <helpinfo><![CDATA[]]></helpinfo> 214 <masseditable>1</masseditable> 215 </field> 216 <field> 217 <fieldname>createdtime</fieldname> 218 <uitype>70</uitype> 219 <columnname>createdtime</columnname> 220 <tablename>vtiger_crmentity</tablename> 221 <generatedtype>1</generatedtype> 222 <fieldlabel>Created Time</fieldlabel> 223 <readonly>1</readonly> 224 <presence>0</presence> 225 <defaultvalue></defaultvalue> 226 <sequence>13</sequence> 227 <maximumlength>100</maximumlength> 228 <typeofdata>DT~O</typeofdata> 229 <quickcreate>3</quickcreate> 230 <quickcreatesequence></quickcreatesequence> 231 <displaytype>2</displaytype> 232 <info_type>BAS</info_type> 233 <helpinfo><![CDATA[]]></helpinfo> 234 <masseditable>0</masseditable> 235 </field> 236 <field> 237 <fieldname>modifiedtime</fieldname> 238 <uitype>70</uitype> 239 <columnname>modifiedtime</columnname> 240 <tablename>vtiger_crmentity</tablename> 241 <generatedtype>1</generatedtype> 242 <fieldlabel>Modified Time</fieldlabel> 243 <readonly>1</readonly> 244 <presence>0</presence> 245 <defaultvalue></defaultvalue> 246 <sequence>14</sequence> 247 <maximumlength>100</maximumlength> 248 <typeofdata>DT~O</typeofdata> 249 <quickcreate>3</quickcreate> 250 <quickcreatesequence></quickcreatesequence> 251 <displaytype>2</displaytype> 252 <info_type>BAS</info_type> 253 <helpinfo><![CDATA[]]></helpinfo> 254 <masseditable>0</masseditable> 255 </field> 256 <field> 257 <fieldname>modifiedby</fieldname> 258 <uitype>52</uitype> 259 <columnname>modifiedby</columnname> 260 <tablename>vtiger_crmentity</tablename> 261 <generatedtype>1</generatedtype> 262 <fieldlabel>Last Modified By</fieldlabel> 263 <readonly>1</readonly> 264 <presence>0</presence> 265 <defaultvalue></defaultvalue> 266 <sequence>16</sequence> 267 <maximumlength>100</maximumlength> 268 <typeofdata>V~O</typeofdata> 269 <quickcreate>3</quickcreate> 270 <quickcreatesequence></quickcreatesequence> 271 <displaytype>3</displaytype> 272 <info_type>BAS</info_type> 273 <helpinfo><![CDATA[]]></helpinfo> 274 <masseditable>0</masseditable> 275 </field> 276 <field> 277 <fieldname>service_usageunit</fieldname> 278 <uitype>15</uitype> 279 <columnname>service_usageunit</columnname> 280 <tablename>vtiger_service</tablename> 281 <generatedtype>1</generatedtype> 282 <fieldlabel>Usage Unit</fieldlabel> 283 <readonly>1</readonly> 284 <presence>2</presence> 285 <defaultvalue></defaultvalue> 286 <sequence>3</sequence> 287 <maximumlength>100</maximumlength> 288 <typeofdata>V~O</typeofdata> 289 <quickcreate>1</quickcreate> 290 <quickcreatesequence></quickcreatesequence> 291 <displaytype>1</displaytype> 292 <info_type>BAS</info_type> 293 <helpinfo><![CDATA[]]></helpinfo> 294 <masseditable>1</masseditable> 295 <picklistvalues> 296 <picklistvalue>Hours</picklistvalue> 297 <picklistvalue>Days</picklistvalue> 298 <picklistvalue>Incidents</picklistvalue> 299 </picklistvalues> 300 </field> 301 <field> 302 <fieldname>qty_per_unit</fieldname> 303 <uitype>1</uitype> 304 <columnname>qty_per_unit</columnname> 305 <tablename>vtiger_service</tablename> 306 <generatedtype>1</generatedtype> 307 <fieldlabel>No of Units</fieldlabel> 308 <readonly>1</readonly> 309 <presence>2</presence> 310 <defaultvalue></defaultvalue> 311 <sequence>5</sequence> 312 <maximumlength>100</maximumlength> 313 <typeofdata>N~O</typeofdata> 314 <quickcreate>1</quickcreate> 315 <quickcreatesequence></quickcreatesequence> 316 <displaytype>1</displaytype> 317 <info_type>BAS</info_type> 318 <helpinfo><![CDATA[]]></helpinfo> 319 <masseditable>1</masseditable> 320 </field> 321 <field> 322 <fieldname>assigned_user_id</fieldname> 323 <uitype>53</uitype> 324 <columnname>smownerid</columnname> 325 <tablename>vtiger_crmentity</tablename> 326 <generatedtype>1</generatedtype> 327 <fieldlabel>Owner</fieldlabel> 328 <readonly>1</readonly> 329 <presence>0</presence> 330 <defaultvalue></defaultvalue> 331 <sequence>8</sequence> 332 <maximumlength>100</maximumlength> 333 <typeofdata>I~O</typeofdata> 334 <quickcreate>1</quickcreate> 335 <quickcreatesequence></quickcreatesequence> 336 <displaytype>1</displaytype> 337 <info_type>BAS</info_type> 338 <helpinfo><![CDATA[]]></helpinfo> 339 <masseditable>1</masseditable> 340 </field> 341 <field> 342 <fieldname>servicecategory</fieldname> 343 <uitype>15</uitype> 344 <columnname>servicecategory</columnname> 345 <tablename>vtiger_service</tablename> 346 <generatedtype>1</generatedtype> 347 <fieldlabel>Service Category</fieldlabel> 348 <readonly>1</readonly> 349 <presence>2</presence> 350 <defaultvalue></defaultvalue> 351 <sequence>7</sequence> 352 <maximumlength>100</maximumlength> 353 <typeofdata>V~O</typeofdata> 354 <quickcreate>1</quickcreate> 355 <quickcreatesequence></quickcreatesequence> 356 <displaytype>1</displaytype> 357 <info_type>BAS</info_type> 358 <helpinfo><![CDATA[]]></helpinfo> 359 <masseditable>1</masseditable> 360 <picklistvalues> 361 <picklistvalue>--None--</picklistvalue> 362 <picklistvalue>Support</picklistvalue> 363 <picklistvalue>Installation</picklistvalue> 364 <picklistvalue>Migration</picklistvalue> 365 <picklistvalue>Customization</picklistvalue> 366 <picklistvalue>Training</picklistvalue> 367 </picklistvalues> 368 </field> 369 </fields> 370 </block> 371 <block> 372 <label>LBL_PRICING_INFORMATION</label> 373 <fields> 374 <field> 375 <fieldname>unit_price</fieldname> 376 <uitype>72</uitype> 377 <columnname>unit_price</columnname> 378 <tablename>vtiger_service</tablename> 379 <generatedtype>1</generatedtype> 380 <fieldlabel>Price</fieldlabel> 381 <readonly>1</readonly> 382 <presence>2</presence> 383 <defaultvalue></defaultvalue> 384 <sequence>1</sequence> 385 <maximumlength>100</maximumlength> 386 <typeofdata>N~O</typeofdata> 387 <quickcreate>2</quickcreate> 388 <quickcreatesequence>2</quickcreatesequence> 389 <displaytype>1</displaytype> 390 <info_type>BAS</info_type> 391 <helpinfo><![CDATA[]]></helpinfo> 392 <masseditable>0</masseditable> 393 </field> 394 <field> 395 <fieldname>taxclass</fieldname> 396 <uitype>83</uitype> 397 <columnname>taxclass</columnname> 398 <tablename>vtiger_service</tablename> 399 <generatedtype>1</generatedtype> 400 <fieldlabel>Tax Class</fieldlabel> 401 <readonly>1</readonly> 402 <presence>2</presence> 403 <defaultvalue></defaultvalue> 404 <sequence>4</sequence> 405 <maximumlength>100</maximumlength> 406 <typeofdata>V~O</typeofdata> 407 <quickcreate>1</quickcreate> 408 <quickcreatesequence></quickcreatesequence> 409 <displaytype>1</displaytype> 410 <info_type>BAS</info_type> 411 <helpinfo><![CDATA[]]></helpinfo> 412 <masseditable>1</masseditable> 413 </field> 414 <field> 415 <fieldname>commissionrate</fieldname> 416 <uitype>9</uitype> 417 <columnname>commissionrate</columnname> 418 <tablename>vtiger_service</tablename> 419 <generatedtype>1</generatedtype> 420 <fieldlabel>Commission Rate</fieldlabel> 421 <readonly>1</readonly> 422 <presence>2</presence> 423 <defaultvalue></defaultvalue> 424 <sequence>2</sequence> 425 <maximumlength>100</maximumlength> 426 <typeofdata>N~O</typeofdata> 427 <quickcreate>1</quickcreate> 428 <quickcreatesequence></quickcreatesequence> 429 <displaytype>1</displaytype> 430 <info_type>BAS</info_type> 431 <helpinfo><![CDATA[]]></helpinfo> 432 <masseditable>1</masseditable> 433 </field> 434 </fields> 435 </block> 436 <block> 437 <label>LBL_CUSTOM_INFORMATION</label> 438 </block> 439 <block> 440 <label>LBL_DESCRIPTION_INFORMATION</label> 441 <fields> 442 <field> 443 <fieldname>description</fieldname> 444 <uitype>19</uitype> 445 <columnname>description</columnname> 446 <tablename>vtiger_crmentity</tablename> 447 <generatedtype>1</generatedtype> 448 <fieldlabel>Description</fieldlabel> 449 <readonly>1</readonly> 450 <presence>2</presence> 451 <defaultvalue></defaultvalue> 452 <sequence>1</sequence> 453 <maximumlength>100</maximumlength> 454 <typeofdata>V~O</typeofdata> 455 <quickcreate>1</quickcreate> 456 <quickcreatesequence></quickcreatesequence> 457 <displaytype>1</displaytype> 458 <info_type>BAS</info_type> 459 <helpinfo><![CDATA[]]></helpinfo> 460 <masseditable>1</masseditable> 461 </field> 462 </fields> 463 </block> 464 </blocks> 465 <customviews> 466 <customview> 467 <viewname>All</viewname> 468 <setdefault>true</setdefault> 469 <setmetrics>false</setmetrics> 470 <fields> 471 <field> 472 <fieldname>service_no</fieldname> 473 <columnindex>0</columnindex> 474 </field> 475 <field> 476 <fieldname>servicename</fieldname> 477 <columnindex>1</columnindex> 478 </field> 479 <field> 480 <fieldname>service_usageunit</fieldname> 481 <columnindex>2</columnindex> 482 </field> 483 <field> 484 <fieldname>unit_price</fieldname> 485 <columnindex>3</columnindex> 486 </field> 487 <field> 488 <fieldname>qty_per_unit</fieldname> 489 <columnindex>4</columnindex> 490 </field> 491 <field> 492 <fieldname>servicecategory</fieldname> 493 <columnindex>5</columnindex> 494 </field> 495 <field> 496 <fieldname>assigned_user_id</fieldname> 497 <columnindex>6</columnindex> 498 </field> 499 </fields> 500 </customview> 501 </customviews> 502 <sharingaccess> 503 <default>public_readwritedelete</default> 504 </sharingaccess> 505 <actions> 506 <action> 507 <name><![CDATA[Import]]></name> 508 <status>enabled</status> 509 </action> 510 <action> 511 <name><![CDATA[Export]]></name> 512 <status>enabled</status> 513 </action> 514 <action> 515 <name><![CDATA[DuplicatesHandling]]></name> 516 <status>enabled</status> 517 </action> 518 </actions> 519 <relatedlists> 520 <relatedlist> 521 <function>get_related_list</function> 522 <label>HelpDesk</label> 523 <sequence>1</sequence> 524 <presence>0</presence> 525 <actions> 526 <action>ADD</action> 527 <action>SELECT</action> 528 </actions> 529 <relatedmodule>HelpDesk</relatedmodule> 530 </relatedlist> 531 <relatedlist> 532 <function>get_quotes</function> 533 <label>Quotes</label> 534 <sequence>2</sequence> 535 <presence>0</presence> 536 <actions> 537 <action>ADD</action> 538 </actions> 539 <relatedmodule>Quotes</relatedmodule> 540 </relatedlist> 541 <relatedlist> 542 <function>get_purchase_orders</function> 543 <label>Purchase Order</label> 544 <sequence>3</sequence> 545 <presence>0</presence> 546 <actions> 547 <action>ADD</action> 548 </actions> 549 <relatedmodule>PurchaseOrder</relatedmodule> 550 </relatedlist> 551 <relatedlist> 552 <function>get_salesorder</function> 553 <label>Sales Order</label> 554 <sequence>4</sequence> 555 <presence>0</presence> 556 <actions> 557 <action>ADD</action> 558 </actions> 559 <relatedmodule>SalesOrder</relatedmodule> 560 </relatedlist> 561 <relatedlist> 562 <function>get_invoices</function> 563 <label>Invoice</label> 564 <sequence>5</sequence> 565 <presence>0</presence> 566 <actions> 567 <action>ADD</action> 568 </actions> 569 <relatedmodule>Invoice</relatedmodule> 570 </relatedlist> 571 <relatedlist> 572 <function>get_service_pricebooks</function> 573 <label>PriceBooks</label> 574 <sequence>6</sequence> 575 <presence>0</presence> 576 <actions> 577 <action>ADD</action> 578 </actions> 579 <relatedmodule>PriceBooks</relatedmodule> 580 </relatedlist> 581 <relatedlist> 582 <function>get_related_list</function> 583 <label>Leads</label> 584 <sequence>7</sequence> 585 <presence>0</presence> 586 <actions> 587 <action>SELECT</action> 588 </actions> 589 <relatedmodule>Leads</relatedmodule> 590 </relatedlist> 591 <relatedlist> 592 <function>get_related_list</function> 593 <label>Accounts</label> 594 <sequence>8</sequence> 595 <presence>0</presence> 596 <actions> 597 <action>SELECT</action> 598 </actions> 599 <relatedmodule>Accounts</relatedmodule> 600 </relatedlist> 601 <relatedlist> 602 <function>get_related_list</function> 603 <label>Contacts</label> 604 <sequence>9</sequence> 605 <presence>0</presence> 606 <actions> 607 <action>SELECT</action> 608 </actions> 609 <relatedmodule>Contacts</relatedmodule> 610 </relatedlist> 611 <relatedlist> 612 <function>get_related_list</function> 613 <label>Potentials</label> 614 <sequence>10</sequence> 615 <presence>0</presence> 616 <actions> 617 <action>SELECT</action> 618 </actions> 619 <relatedmodule>Potentials</relatedmodule> 620 </relatedlist> 621 <relatedlist> 622 <function>get_attachments</function> 623 <label>Documents</label> 624 <sequence>11</sequence> 625 <presence>0</presence> 626 <actions> 627 <action>ADD</action> 628 <action>SELECT</action> 629 </actions> 630 <relatedmodule>Documents</relatedmodule> 631 </relatedlist> 632 </relatedlists> 633 </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 |