xml/schema/Contribute/Contribution.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Contribute</base>
   5   <class>Contribution</class>
   6   <name>civicrm_contribution</name>
   7   <add>1.3</add>
   8   <log>true</log>
   9   <field>
  10     <name>id</name>
  11     <uniqueName>contribution_id</uniqueName>
  12     <type>int unsigned</type>
  13     <required>true</required>
  14     <import>true</import>
  15     <title>Contribution ID</title>
  16     <comment>Contribution ID</comment>
  17     <add>1.3</add>
  18   </field>
  19   <primaryKey>
  20     <name>id</name>
  21     <autoincrement>true</autoincrement>
  22   </primaryKey>
  23   <field>
  24     <name>contact_id</name>
  25     <uniqueName>contribution_contact_id</uniqueName>
  26     <title>Contact ID</title>
  27     <type>int unsigned</type>
  28     <required>true</required>
  29     <import>true</import>
  30     <headerPattern>/contact(.?id)?/i</headerPattern>
  31     <dataPattern>/^\d+$/</dataPattern>
  32     <comment>FK to Contact ID</comment>
  33     <html>
  34       <type>EntityRef</type>
  35     </html>
  36     <add>1.3</add>
  37   </field>
  38   <foreignKey>
  39     <name>contact_id</name>
  40     <table>civicrm_contact</table>
  41     <key>id</key>
  42     <add>1.3</add>
  43     <onDelete>CASCADE</onDelete>
  44   </foreignKey>
  45   <field>
  46     <name>solicitor_id</name>
  47     <title>Solicitor ID</title>
  48     <type>int unsigned</type>
  49     <comment>FK to Solicitor ID</comment>
  50     <add>1.4</add>
  51     <drop>2.2</drop>
  52   </field>
  53   <foreignKey>
  54     <name>solicitor_id</name>
  55     <table>civicrm_contact</table>
  56     <key>id</key>
  57     <add>1.4</add>
  58     <drop>2.2</drop>
  59     <onDelete>SET NULL</onDelete>
  60   </foreignKey>
  61   <field>
  62     <name>contribution_type_id</name>
  63     <title>Contribution Type</title>
  64     <export>false</export>
  65     <type>int unsigned</type>
  66     <comment>FK to Contribution Type</comment>
  67     <add>1.3</add>
  68     <drop>4.3</drop>
  69   </field>
  70   <foreignKey>
  71     <name>contribution_type_id</name>
  72     <table>civicrm_contribution_type</table>
  73     <key>id</key>
  74     <add>1.3</add>
  75     <drop>4.3</drop>
  76     <onDelete>SET NULL</onDelete>
  77   </foreignKey>
  78   <field>
  79     <name>financial_type_id</name>
  80     <title>Financial Type</title>
  81     <type>int unsigned</type>
  82     <comment>FK to Financial Type for (total_amount - non_deductible_amount).</comment>
  83     <pseudoconstant>
  84       <table>civicrm_financial_type</table>
  85       <keyColumn>id</keyColumn>
  86       <labelColumn>name</labelColumn>
  87     </pseudoconstant>
  88     <export>true</export>
  89     <html>
  90       <type>Select</type>
  91     </html>
  92     <add>4.3</add>
  93   </field>
  94   <foreignKey>
  95     <name>financial_type_id</name>
  96     <table>civicrm_financial_type</table>
  97     <key>id</key>
  98     <add>4.3</add>
  99   </foreignKey>
 100   <field>
 101     <name>contribution_page_id</name>
 102     <title>Contribution Page ID</title>
 103     <type>int unsigned</type>
 104     <import>true</import>
 105     <comment>The Contribution Page which triggered this contribution</comment>
 106     <pseudoconstant>
 107       <table>civicrm_contribution_page</table>
 108       <keyColumn>id</keyColumn>
 109       <labelColumn>title</labelColumn>
 110     </pseudoconstant>
 111     <html>
 112       <type>Select</type>
 113     </html>
 114     <add>1.5</add>
 115   </field>
 116   <foreignKey>
 117     <name>contribution_page_id</name>
 118     <table>civicrm_contribution_page</table>
 119     <key>id</key>
 120     <onDelete>SET NULL</onDelete>
 121   </foreignKey>
 122   <field>
 123     <name>payment_instrument_id</name>
 124     <uniqueName>payment_instrument_id</uniqueName>
 125     <title>Payment Method ID</title>
 126     <type>int unsigned</type>
 127     <comment>FK to Payment Instrument</comment>
 128     <export>true</export>
 129     <headerPattern>/^payment|(p(ayment\s)?instrument)$/i</headerPattern>
 130     <pseudoconstant>
 131       <optionGroupName>payment_instrument</optionGroupName>
 132     </pseudoconstant>
 133     <html>
 134       <type>Select</type>
 135     </html>
 136     <add>1.3</add>
 137   </field>
 138   <index>
 139     <name>UI_contrib_payment_instrument_id</name>
 140     <fieldName>payment_instrument_id</fieldName>
 141     <add>1.6</add>
 142   </index>
 143   <field>
 144     <name>receive_date</name>
 145     <title>Date Received</title>
 146     <type>datetime</type>
 147     <import>true</import>
 148     <headerPattern>/receive(.?date)?/i</headerPattern>
 149     <dataPattern>/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/</dataPattern>
 150     <comment>Date contribution was received - not necessarily the creation date of the record</comment>
 151     <add>1.3</add>
 152     <html>
 153      <type>Select Date</type>
 154      <formatType>activityDateTime</formatType>
 155    </html>
 156   </field>
 157   <field>
 158     <name>non_deductible_amount</name>
 159     <title>Non-deductible Amount</title>
 160     <type>decimal</type>
 161     <default>0</default>
 162     <import>true</import>
 163     <headerPattern>/non?.?deduct/i</headerPattern>
 164     <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
 165     <comment>Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.</comment>
 166     <add>1.3</add>
 167     <html>
 168      <type>Text</type>
 169    </html>
 170   </field>
 171   <field>
 172     <name>total_amount</name>
 173     <type>decimal</type>
 174     <required>true</required>
 175     <import>true</import>
 176     <headerPattern>/^total|(.?^am(ou)?nt)/i</headerPattern>
 177     <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
 178     <comment>Total amount of this contribution. Use market value for non-monetary gifts.</comment>
 179     <add>1.3</add>
 180     <html>
 181      <type>Text</type>
 182    </html>
 183   </field>
 184   <index>
 185     <name>index_total_amount_receive_date</name>
 186     <fieldName>total_amount</fieldName>
 187     <fieldName>receive_date</fieldName>
 188     <add>4.7</add>
 189   </index>
 190   <field>
 191     <name>fee_amount</name>
 192     <type>decimal</type>
 193     <import>true</import>
 194     <headerPattern>/fee(.?am(ou)?nt)?/i</headerPattern>
 195     <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
 196     <comment>actual processor fee if known - may be 0.</comment>
 197     <add>1.3</add>
 198     <html>
 199      <type>Text</type>
 200    </html>
 201   </field>
 202   <field>
 203     <name>net_amount</name>
 204     <type>decimal</type>
 205     <import>true</import>
 206     <headerPattern>/net(.?am(ou)?nt)?/i</headerPattern>
 207     <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
 208     <comment>actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.</comment>
 209     <add>1.3</add>
 210     <html>
 211      <type>Text</type>
 212    </html>
 213   </field>
 214   <field>
 215     <name>trxn_id</name>
 216     <title>Transaction ID</title>
 217     <type>varchar</type>
 218     <length>255</length>
 219     <import>true</import>
 220     <headerPattern>/tr(ansactio|x)n(.?id)?/i</headerPattern>
 221     <comment>unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method</comment>
 222     <html>
 223      <type>Text</type>
 224    </html>
 225     <add>1.3</add>
 226   </field>
 227   <field>
 228     <name>invoice_id</name>
 229     <title>Invoice Reference</title>
 230     <type>varchar</type>
 231     <length>255</length>
 232     <import>true</import>
 233     <headerPattern>/invoice(.?id)?/i</headerPattern>
 234     <comment>unique invoice id, system generated or passed in</comment>
 235     <html>
 236       <type>Text</type>
 237     </html>
 238     <add>1.3</add>
 239   </field>
 240   <field>
 241     <name>invoice_number</name>
 242     <title>Invoice Number</title>
 243     <type>varchar</type>
 244     <length>255</length>
 245     <import>true</import>
 246     <headerPattern>/invoice(.?number)?/i</headerPattern>
 247     <comment>Human readable invoice number</comment>
 248     <html>
 249       <type>Text</type>
 250     </html>
 251     <add>4.7</add>
 252   </field>
 253   <field>
 254     <name>currency</name>
 255     <type>varchar</type>
 256     <length>3</length>
 257     <default>NULL</default>
 258     <import>true</import>
 259     <headerPattern>/cur(rency)?/i</headerPattern>
 260     <dataPattern>/^[A-Z]{3}$/i</dataPattern>
 261     <comment>3 character string, value from config setting or input via user.</comment>
 262     <add>1.3</add>
 263     <pseudoconstant>
 264       <table>civicrm_currency</table>
 265       <keyColumn>name</keyColumn>
 266       <labelColumn>full_name</labelColumn>
 267       <nameColumn>name</nameColumn>
 268       <abbrColumn>symbol</abbrColumn>
 269     </pseudoconstant>
 270     <html>
 271       <type>Select</type>
 272     </html>
 273   </field>
 274   <field>
 275     <name>cancel_date</name>
 276     <title>Cancelled / Refunded Date</title>
 277     <type>datetime</type>
 278     <import>true</import>
 279     <headerPattern>/cancel(.?date)?/i</headerPattern>
 280     <dataPattern>/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/</dataPattern>
 281     <comment>when was gift cancelled</comment>
 282     <add>1.3</add>
 283     <html>
 284       <type>Select Date</type>
 285       <formatType>activityDateTime</formatType>
 286     </html>
 287     <uniqueName>contribution_cancel_date</uniqueName>
 288   </field>
 289   <field>
 290     <name>cancel_reason</name>
 291     <type>text</type>
 292     <title>Cancellation / Refund Reason</title>
 293     <import>true</import>
 294     <export>true</export>
 295     <headerPattern>/(cancel.?)?reason/i</headerPattern>
 296     <html>
 297       <type>Text</type>
 298       <size>40</size>
 299     </html>
 300     <add>1.3</add>
 301   </field>
 302   <field>
 303     <name>receipt_date</name>
 304     <type>datetime</type>
 305     <import>true</import>
 306     <headerPattern>/receipt(.?date)?/i</headerPattern>
 307     <dataPattern>/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/</dataPattern>
 308     <comment>when (if) receipt was sent. populated automatically for online donations w/ automatic receipting</comment>
 309     <html>
 310       <type>Select Date</type>
 311       <formatType>activityDateTime</formatType>
 312     </html>
 313     <add>1.3</add>
 314   </field>
 315   <field>
 316     <name>thankyou_date</name>
 317     <title>Thank-you Date</title>
 318     <type>datetime</type>
 319     <import>true</import>
 320     <headerPattern>/thank(s|(.?you))?(.?date)?/i</headerPattern>
 321     <dataPattern>/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/</dataPattern>
 322     <comment>when (if) was donor thanked</comment>
 323     <add>1.3</add>
 324     <html>
 325       <type>Select Date</type>
 326       <formatType>activityDateTime</formatType>
 327     </html>
 328   </field>
 329   <field>
 330     <name>source</name>
 331     <uniqueName>contribution_source</uniqueName>
 332     <title>Contribution Source</title>
 333     <type>varchar</type>
 334     <length>255</length>
 335     <import>true</import>
 336     <headerPattern>/source/i</headerPattern>
 337     <comment>Origin of this Contribution.</comment>
 338     <add>1.3</add>
 339     <html>
 340       <type>Text</type>
 341     </html>
 342   </field>
 343   <index>
 344     <name>index_source</name>
 345     <fieldName>source</fieldName>
 346     <add>4.7</add>
 347   </index>
 348   <field>
 349     <name>amount_level</name>
 350     <title>Amount Label</title>
 351     <type>text</type>
 352     <import>true</import>
 353     <add>1.7</add>
 354     <html>
 355       <type>Text</type>
 356     </html>
 357   </field>
 358   <field>
 359     <name>note</name>
 360     <type>text</type>
 361     <comment>Note and/or Comment.</comment>
 362     <import>true</import>
 363     <headerPattern>/Note|Comment/i</headerPattern>
 364     <dataPattern>//</dataPattern>
 365     <add>1.4</add>
 366     <drop>1.7</drop>
 367   </field>
 368   <index>
 369     <name>UI_contrib_trxn_id</name>
 370     <fieldName>trxn_id</fieldName>
 371     <unique>true</unique>
 372     <add>2.1</add>
 373   </index>
 374   <index>
 375     <name>UI_contrib_invoice_id</name>
 376     <fieldName>invoice_id</fieldName>
 377     <unique>true</unique>
 378     <add>2.1</add>
 379   </index>
 380   <field>
 381     <name>contribution_recur_id</name>
 382     <title>Recurring Contribution ID</title>
 383     <type>int unsigned</type>
 384     <comment>Conditional foreign key to civicrm_contribution_recur id. Each contribution made in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.</comment>
 385     <export>true</export>
 386     <add>1.4</add>
 387   </field>
 388   <foreignKey>
 389     <name>contribution_recur_id</name>
 390     <table>civicrm_contribution_recur</table>
 391     <key>id</key>
 392     <add>1.4</add>
 393     <onDelete>SET NULL</onDelete>
 394   </foreignKey>
 395   <field>
 396     <name>is_test</name>
 397     <title>Test</title>
 398     <type>boolean</type>
 399     <default>0</default>
 400     <import>true</import>
 401     <html>
 402       <type>CheckBox</type>
 403     </html>
 404   </field>
 405   <field>
 406     <name>is_pay_later</name>
 407     <title>Is Pay Later</title>
 408     <type>boolean</type>
 409     <default>0</default>
 410     <import>true</import>
 411     <add>2.1</add>
 412     <html>
 413       <type>CheckBox</type>
 414     </html>
 415   </field>
 416   <field>
 417     <name>contribution_status_id</name>
 418     <title>Contribution Status ID</title>
 419     <type>int unsigned</type>
 420     <default>1</default>
 421     <import>true</import>
 422     <export>true</export>
 423     <headerPattern>/status/i</headerPattern>
 424     <pseudoconstant>
 425       <optionGroupName>contribution_status</optionGroupName>
 426     </pseudoconstant>
 427     <html>
 428       <type>Select</type>
 429     </html>
 430     <add>1.6</add>
 431   </field>
 432   <index>
 433     <name>index_contribution_status</name>
 434     <fieldName>contribution_status_id</fieldName>
 435     <add>1.6</add>
 436   </index>
 437   <index>
 438     <name>received_date</name>
 439     <fieldName>receive_date</fieldName>
 440     <add>1.6</add>
 441   </index>
 442   <field>
 443     <name>address_id</name>
 444     <uniqueName>contribution_address_id</uniqueName>
 445     <title>Contribution Address</title>
 446     <type>int unsigned</type>
 447     <comment>Conditional foreign key to civicrm_address.id. We insert an address record for each contribution when we have associated billing name and address data.</comment>
 448     <add>2.2</add>
 449     <export>true</export>
 450   </field>
 451   <foreignKey>
 452     <name>address_id</name>
 453     <table>civicrm_address</table>
 454     <key>id</key>
 455     <add>2.2</add>
 456     <onDelete>SET NULL</onDelete>
 457   </foreignKey>
 458   <field>
 459     <name>check_number</name>
 460     <title>Check Number</title>
 461     <uniqueName>contribution_check_number</uniqueName>
 462     <headerPattern>/check(.?number)?/i</headerPattern>
 463     <type>varchar</type>
 464     <length>255</length>
 465     <html>
 466       <type>Text</type>
 467       <size>6</size>
 468     </html>
 469     <import>true</import>
 470     <add>2.2</add>
 471   </field>
 472   <index>
 473     <name>check_number</name>
 474     <fieldName>check_number</fieldName>
 475     <add>2.2</add>
 476   </index>
 477   <field>
 478     <name>campaign_id</name>
 479     <uniqueName>contribution_campaign_id</uniqueName>
 480     <type>int unsigned</type>
 481     <title>Campaign</title>
 482     <import>true</import>
 483     <comment>The campaign for which this contribution has been triggered.</comment>
 484     <pseudoconstant>
 485       <table>civicrm_campaign</table>
 486       <keyColumn>id</keyColumn>
 487       <labelColumn>title</labelColumn>
 488     </pseudoconstant>
 489     <add>3.4</add>
 490     <html>
 491       <type>Select</type>
 492     </html>
 493   </field>
 494   <field>
 495     <name>creditnote_id</name>
 496     <title>Credit Note ID</title>
 497     <type>varchar</type>
 498     <length>255</length>
 499     <import>true</import>
 500     <headerPattern>/creditnote(.?id)?/i</headerPattern>
 501     <comment>unique credit note id, system generated or passed in</comment>
 502     <add>4.6</add>
 503     <html>
 504       <type>Text</type>
 505     </html>
 506   </field>
 507   <index>
 508     <name>index_creditnote_id</name>
 509     <fieldName>creditnote_id</fieldName>
 510     <add>4.7</add>
 511   </index>
 512   <field>
 513     <name>tax_amount</name>
 514     <title>Tax Amount</title>
 515     <type>decimal</type>
 516     <import>true</import>
 517     <headerPattern>/tax(.?am(ou)?nt)?/i</headerPattern>
 518     <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
 519     <comment>Total tax amount of this contribution.</comment>
 520     <add>4.6</add>
 521     <html>
 522      <type>Text</type>
 523    </html>
 524   </field>
 525   <foreignKey>
 526     <name>campaign_id</name>
 527     <table>civicrm_campaign</table>
 528     <key>id</key>
 529     <onDelete>SET NULL</onDelete>
 530   </foreignKey>
 531   <field>
 532     <name>revenue_recognition_date</name>
 533     <type>datetime</type>
 534     <import>true</import>
 535     <headerPattern>/revenue(.?date)?/i</headerPattern>
 536     <dataPattern>/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/</dataPattern>
 537     <comment>Stores the date when revenue should be recognized.</comment>
 538     <html>
 539       <type>Select Date</type>
 540         <formatType>activityDateTime</formatType>
 541     </html>
 542     <add>4.7</add>
 543   </field>
 544    <field>
 545     <name>is_template</name>
 546     <title>Is a Template Contribution</title>
 547     <type>boolean</type>
 548     <default>0</default>
 549     <import>true</import>
 550     <comment>Shows this is a template for recurring contributions.</comment>
 551     <html>
 552       <type>CheckBox</type>
 553     </html>
 554     <add>5.20</add>
 555   </field>
 556 </table>