5 * @copyright CiviCRM LLC (c) 2004-2018
7 * Generated from xml/schema/CRM/Contribute/Contribution.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
9 * (GenCodeChecksum:99cdf75ae6e6bf73bc5ff6871a3baf82)
13 * Database access object for the Contribution entity.
15 class CRM_Contribute_DAO_Contribution
extends CRM_Core_DAO
{
18 * Static instance to hold the table name.
22 static $_tableName = 'civicrm_contribution';
25 * Should CiviCRM log any modifications to this table in the civicrm_log table.
46 * FK to Financial Type for (total_amount - non_deductible_amount).
50 public $financial_type_id;
53 * The Contribution Page which triggered this contribution
57 public $contribution_page_id;
60 * FK to Payment Instrument
64 public $payment_instrument_id;
67 * Date contribution was received - not necessarily the creation date of the record
74 * Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.
78 public $non_deductible_amount;
81 * Total amount of this contribution. Use market value for non-monetary gifts.
88 * actual processor fee if known - may be 0.
95 * actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.
102 * unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method
109 * unique invoice id, system generated or passed in
116 * Human readable invoice number
120 public $invoice_number;
123 * 3 character string, value from config setting or input via user.
130 * when was gift cancelled
139 public $cancel_reason;
142 * when (if) receipt was sent. populated automatically for online donations w/ automatic receipting
146 public $receipt_date;
149 * when (if) was donor thanked
153 public $thankyou_date;
156 * Origin of this Contribution.
165 public $amount_level;
168 * 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.
172 public $contribution_recur_id;
182 public $is_pay_later;
187 public $contribution_status_id;
190 * Conditional foreign key to civicrm_address.id. We insert an address record for each contribution when we have associated billing name and address data.
199 public $check_number;
202 * The campaign for which this contribution has been triggered.
209 * unique credit note id, system generated or passed in
213 public $creditnote_id;
216 * Total tax amount of this contribution.
223 * Stores the date when revenue should be recognized.
227 public $revenue_recognition_date;
232 public function __construct() {
233 $this->__table
= 'civicrm_contribution';
234 parent
::__construct();
238 * Returns foreign keys and entity references.
241 * [CRM_Core_Reference_Interface]
243 public static function getReferenceColumns() {
244 if (!isset(Civi
::$statics[__CLASS__
]['links'])) {
245 Civi
::$statics[__CLASS__
]['links'] = static ::createReferenceColumns(__CLASS__
);
246 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'contact_id', 'civicrm_contact', 'id');
247 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'financial_type_id', 'civicrm_financial_type', 'id');
248 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'contribution_page_id', 'civicrm_contribution_page', 'id');
249 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'contribution_recur_id', 'civicrm_contribution_recur', 'id');
250 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'address_id', 'civicrm_address', 'id');
251 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
252 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'links_callback', Civi
::$statics[__CLASS__
]['links']);
254 return Civi
::$statics[__CLASS__
]['links'];
258 * Returns all the column names of this table
262 public static function &fields() {
263 if (!isset(Civi
::$statics[__CLASS__
]['fields'])) {
264 Civi
::$statics[__CLASS__
]['fields'] = [
265 'contribution_id' => [
267 'type' => CRM_Utils_Type
::T_INT
,
268 'title' => ts('Contribution ID'),
269 'description' => ts('Contribution ID'),
272 'where' => 'civicrm_contribution.id',
273 'headerPattern' => '',
276 'table_name' => 'civicrm_contribution',
277 'entity' => 'Contribution',
278 'bao' => 'CRM_Contribute_BAO_Contribution',
281 'contribution_contact_id' => [
282 'name' => 'contact_id',
283 'type' => CRM_Utils_Type
::T_INT
,
284 'title' => ts('Contact ID'),
285 'description' => ts('FK to Contact ID'),
288 'where' => 'civicrm_contribution.contact_id',
289 'headerPattern' => '/contact(.?id)?/i',
290 'dataPattern' => '/^\d+$/',
292 'table_name' => 'civicrm_contribution',
293 'entity' => 'Contribution',
294 'bao' => 'CRM_Contribute_BAO_Contribution',
296 'FKClassName' => 'CRM_Contact_DAO_Contact',
298 'type' => 'EntityRef',
301 'financial_type_id' => [
302 'name' => 'financial_type_id',
303 'type' => CRM_Utils_Type
::T_INT
,
304 'title' => ts('Financial Type'),
305 'description' => ts('FK to Financial Type for (total_amount - non_deductible_amount).'),
307 'where' => 'civicrm_contribution.financial_type_id',
308 'headerPattern' => '',
310 'table_name' => 'civicrm_contribution',
311 'entity' => 'Contribution',
312 'bao' => 'CRM_Contribute_BAO_Contribution',
314 'FKClassName' => 'CRM_Financial_DAO_FinancialType',
318 'pseudoconstant' => [
319 'table' => 'civicrm_financial_type',
321 'labelColumn' => 'name',
324 'contribution_page_id' => [
325 'name' => 'contribution_page_id',
326 'type' => CRM_Utils_Type
::T_INT
,
327 'title' => ts('Contribution Page ID'),
328 'description' => ts('The Contribution Page which triggered this contribution'),
330 'where' => 'civicrm_contribution.contribution_page_id',
331 'headerPattern' => '',
334 'table_name' => 'civicrm_contribution',
335 'entity' => 'Contribution',
336 'bao' => 'CRM_Contribute_BAO_Contribution',
338 'FKClassName' => 'CRM_Contribute_DAO_ContributionPage',
342 'pseudoconstant' => [
343 'table' => 'civicrm_contribution_page',
345 'labelColumn' => 'title',
348 'payment_instrument_id' => [
349 'name' => 'payment_instrument_id',
350 'type' => CRM_Utils_Type
::T_INT
,
351 'title' => ts('Payment Method ID'),
352 'description' => ts('FK to Payment Instrument'),
354 'where' => 'civicrm_contribution.payment_instrument_id',
355 'headerPattern' => '/^payment|(p(ayment\s)?instrument)$/i',
357 'table_name' => 'civicrm_contribution',
358 'entity' => 'Contribution',
359 'bao' => 'CRM_Contribute_BAO_Contribution',
364 'pseudoconstant' => [
365 'optionGroupName' => 'payment_instrument',
366 'optionEditPath' => 'civicrm/admin/options/payment_instrument',
370 'name' => 'receive_date',
371 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
372 'title' => ts('Date Received'),
373 'description' => ts('Date contribution was received - not necessarily the creation date of the record'),
375 'where' => 'civicrm_contribution.receive_date',
376 'headerPattern' => '/receive(.?date)?/i',
377 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
379 'table_name' => 'civicrm_contribution',
380 'entity' => 'Contribution',
381 'bao' => 'CRM_Contribute_BAO_Contribution',
384 'type' => 'Select Date',
385 'formatType' => 'activityDateTime',
388 'non_deductible_amount' => [
389 'name' => 'non_deductible_amount',
390 'type' => CRM_Utils_Type
::T_MONEY
,
391 'title' => ts('Non-deductible Amount'),
392 'description' => ts('Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.'),
398 'where' => 'civicrm_contribution.non_deductible_amount',
399 'headerPattern' => '/non?.?deduct/i',
400 'dataPattern' => '/^\d+(\.\d{2})?$/',
403 'table_name' => 'civicrm_contribution',
404 'entity' => 'Contribution',
405 'bao' => 'CRM_Contribute_BAO_Contribution',
412 'name' => 'total_amount',
413 'type' => CRM_Utils_Type
::T_MONEY
,
414 'title' => ts('Total Amount'),
415 'description' => ts('Total amount of this contribution. Use market value for non-monetary gifts.'),
422 'where' => 'civicrm_contribution.total_amount',
423 'headerPattern' => '/^total|(.?^am(ou)?nt)/i',
424 'dataPattern' => '/^\d+(\.\d{2})?$/',
426 'table_name' => 'civicrm_contribution',
427 'entity' => 'Contribution',
428 'bao' => 'CRM_Contribute_BAO_Contribution',
435 'name' => 'fee_amount',
436 'type' => CRM_Utils_Type
::T_MONEY
,
437 'title' => ts('Fee Amount'),
438 'description' => ts('actual processor fee if known - may be 0.'),
444 'where' => 'civicrm_contribution.fee_amount',
445 'headerPattern' => '/fee(.?am(ou)?nt)?/i',
446 'dataPattern' => '/^\d+(\.\d{2})?$/',
448 'table_name' => 'civicrm_contribution',
449 'entity' => 'Contribution',
450 'bao' => 'CRM_Contribute_BAO_Contribution',
457 'name' => 'net_amount',
458 'type' => CRM_Utils_Type
::T_MONEY
,
459 'title' => ts('Net Amount'),
460 'description' => ts('actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.'),
466 'where' => 'civicrm_contribution.net_amount',
467 'headerPattern' => '/net(.?am(ou)?nt)?/i',
468 'dataPattern' => '/^\d+(\.\d{2})?$/',
470 'table_name' => 'civicrm_contribution',
471 'entity' => 'Contribution',
472 'bao' => 'CRM_Contribute_BAO_Contribution',
480 'type' => CRM_Utils_Type
::T_STRING
,
481 'title' => ts('Transaction ID'),
482 'description' => ts('unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method'),
484 'size' => CRM_Utils_Type
::HUGE
,
486 'where' => 'civicrm_contribution.trxn_id',
487 'headerPattern' => '/tr(ansactio|x)n(.?id)?/i',
490 'table_name' => 'civicrm_contribution',
491 'entity' => 'Contribution',
492 'bao' => 'CRM_Contribute_BAO_Contribution',
499 'name' => 'invoice_id',
500 'type' => CRM_Utils_Type
::T_STRING
,
501 'title' => ts('Invoice Reference'),
502 'description' => ts('unique invoice id, system generated or passed in'),
504 'size' => CRM_Utils_Type
::HUGE
,
506 'where' => 'civicrm_contribution.invoice_id',
507 'headerPattern' => '/invoice(.?id)?/i',
510 'table_name' => 'civicrm_contribution',
511 'entity' => 'Contribution',
512 'bao' => 'CRM_Contribute_BAO_Contribution',
518 'invoice_number' => [
519 'name' => 'invoice_number',
520 'type' => CRM_Utils_Type
::T_STRING
,
521 'title' => ts('Invoice Number'),
522 'description' => ts('Human readable invoice number'),
524 'size' => CRM_Utils_Type
::HUGE
,
526 'where' => 'civicrm_contribution.invoice_number',
527 'headerPattern' => '/invoice(.?number)?/i',
530 'table_name' => 'civicrm_contribution',
531 'entity' => 'Contribution',
532 'bao' => 'CRM_Contribute_BAO_Contribution',
539 'name' => 'currency',
540 'type' => CRM_Utils_Type
::T_STRING
,
541 'title' => ts('Currency'),
542 'description' => ts('3 character string, value from config setting or input via user.'),
544 'size' => CRM_Utils_Type
::FOUR
,
546 'where' => 'civicrm_contribution.currency',
547 'headerPattern' => '/cur(rency)?/i',
548 'dataPattern' => '/^[A-Z]{3}$/i',
551 'table_name' => 'civicrm_contribution',
552 'entity' => 'Contribution',
553 'bao' => 'CRM_Contribute_BAO_Contribution',
558 'pseudoconstant' => [
559 'table' => 'civicrm_currency',
560 'keyColumn' => 'name',
561 'labelColumn' => 'full_name',
562 'nameColumn' => 'name',
566 'name' => 'cancel_date',
567 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
568 'title' => ts('Cancel Date'),
569 'description' => ts('when was gift cancelled'),
571 'where' => 'civicrm_contribution.cancel_date',
572 'headerPattern' => '/cancel(.?date)?/i',
573 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
575 'table_name' => 'civicrm_contribution',
576 'entity' => 'Contribution',
577 'bao' => 'CRM_Contribute_BAO_Contribution',
580 'type' => 'Select Date',
581 'formatType' => 'activityDateTime',
585 'name' => 'cancel_reason',
586 'type' => CRM_Utils_Type
::T_TEXT
,
587 'title' => ts('Cancellation / Refund Reason'),
589 'where' => 'civicrm_contribution.cancel_reason',
590 'headerPattern' => '/(cancel.?)?reason/i',
593 'table_name' => 'civicrm_contribution',
594 'entity' => 'Contribution',
595 'bao' => 'CRM_Contribute_BAO_Contribution',
602 'name' => 'receipt_date',
603 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
604 'title' => ts('Receipt Date'),
605 'description' => ts('when (if) receipt was sent. populated automatically for online donations w/ automatic receipting'),
607 'where' => 'civicrm_contribution.receipt_date',
608 'headerPattern' => '/receipt(.?date)?/i',
609 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
611 'table_name' => 'civicrm_contribution',
612 'entity' => 'Contribution',
613 'bao' => 'CRM_Contribute_BAO_Contribution',
616 'type' => 'Select Date',
617 'formatType' => 'activityDateTime',
621 'name' => 'thankyou_date',
622 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
623 'title' => ts('Thank-you Date'),
624 'description' => ts('when (if) was donor thanked'),
626 'where' => 'civicrm_contribution.thankyou_date',
627 'headerPattern' => '/thank(s|(.?you))?(.?date)?/i',
628 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
630 'table_name' => 'civicrm_contribution',
631 'entity' => 'Contribution',
632 'bao' => 'CRM_Contribute_BAO_Contribution',
635 'type' => 'Select Date',
636 'formatType' => 'activityDateTime',
639 'contribution_source' => [
641 'type' => CRM_Utils_Type
::T_STRING
,
642 'title' => ts('Contribution Source'),
643 'description' => ts('Origin of this Contribution.'),
645 'size' => CRM_Utils_Type
::HUGE
,
647 'where' => 'civicrm_contribution.source',
648 'headerPattern' => '/source/i',
651 'table_name' => 'civicrm_contribution',
652 'entity' => 'Contribution',
653 'bao' => 'CRM_Contribute_BAO_Contribution',
660 'name' => 'amount_level',
661 'type' => CRM_Utils_Type
::T_TEXT
,
662 'title' => ts('Amount Label'),
664 'where' => 'civicrm_contribution.amount_level',
665 'headerPattern' => '',
668 'table_name' => 'civicrm_contribution',
669 'entity' => 'Contribution',
670 'bao' => 'CRM_Contribute_BAO_Contribution',
676 'contribution_recur_id' => [
677 'name' => 'contribution_recur_id',
678 'type' => CRM_Utils_Type
::T_INT
,
679 'title' => ts('Recurring Contribution ID'),
680 'description' => ts('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.'),
682 'where' => 'civicrm_contribution.contribution_recur_id',
683 'headerPattern' => '',
685 'table_name' => 'civicrm_contribution',
686 'entity' => 'Contribution',
687 'bao' => 'CRM_Contribute_BAO_Contribution',
689 'FKClassName' => 'CRM_Contribute_DAO_ContributionRecur',
693 'type' => CRM_Utils_Type
::T_BOOLEAN
,
694 'title' => ts('Test'),
696 'where' => 'civicrm_contribution.is_test',
697 'headerPattern' => '',
701 'table_name' => 'civicrm_contribution',
702 'entity' => 'Contribution',
703 'bao' => 'CRM_Contribute_BAO_Contribution',
706 'type' => 'CheckBox',
710 'name' => 'is_pay_later',
711 'type' => CRM_Utils_Type
::T_BOOLEAN
,
712 'title' => ts('Is Pay Later'),
714 'where' => 'civicrm_contribution.is_pay_later',
715 'headerPattern' => '',
719 'table_name' => 'civicrm_contribution',
720 'entity' => 'Contribution',
721 'bao' => 'CRM_Contribute_BAO_Contribution',
724 'type' => 'CheckBox',
727 'contribution_status_id' => [
728 'name' => 'contribution_status_id',
729 'type' => CRM_Utils_Type
::T_INT
,
730 'title' => ts('Contribution Status ID'),
732 'where' => 'civicrm_contribution.contribution_status_id',
733 'headerPattern' => '/status/i',
737 'table_name' => 'civicrm_contribution',
738 'entity' => 'Contribution',
739 'bao' => 'CRM_Contribute_BAO_Contribution',
744 'pseudoconstant' => [
745 'optionGroupName' => 'contribution_status',
746 'optionEditPath' => 'civicrm/admin/options/contribution_status',
749 'contribution_address_id' => [
750 'name' => 'address_id',
751 'type' => CRM_Utils_Type
::T_INT
,
752 'title' => ts('Contribution Address'),
753 'description' => ts('Conditional foreign key to civicrm_address.id. We insert an address record for each contribution when we have associated billing name and address data.'),
755 'where' => 'civicrm_contribution.address_id',
756 'headerPattern' => '',
758 'table_name' => 'civicrm_contribution',
759 'entity' => 'Contribution',
760 'bao' => 'CRM_Contribute_BAO_Contribution',
762 'FKClassName' => 'CRM_Core_DAO_Address',
764 'contribution_check_number' => [
765 'name' => 'check_number',
766 'type' => CRM_Utils_Type
::T_STRING
,
767 'title' => ts('Check Number'),
771 'where' => 'civicrm_contribution.check_number',
772 'headerPattern' => '/check(.?number)?/i',
775 'table_name' => 'civicrm_contribution',
776 'entity' => 'Contribution',
777 'bao' => 'CRM_Contribute_BAO_Contribution',
783 'contribution_campaign_id' => [
784 'name' => 'campaign_id',
785 'type' => CRM_Utils_Type
::T_INT
,
786 'title' => ts('Campaign'),
787 'description' => ts('The campaign for which this contribution has been triggered.'),
789 'where' => 'civicrm_contribution.campaign_id',
790 'headerPattern' => '',
793 'table_name' => 'civicrm_contribution',
794 'entity' => 'Contribution',
795 'bao' => 'CRM_Contribute_BAO_Contribution',
797 'FKClassName' => 'CRM_Campaign_DAO_Campaign',
801 'pseudoconstant' => [
802 'table' => 'civicrm_campaign',
804 'labelColumn' => 'title',
808 'name' => 'creditnote_id',
809 'type' => CRM_Utils_Type
::T_STRING
,
810 'title' => ts('Credit Note ID'),
811 'description' => ts('unique credit note id, system generated or passed in'),
813 'size' => CRM_Utils_Type
::HUGE
,
815 'where' => 'civicrm_contribution.creditnote_id',
816 'headerPattern' => '/creditnote(.?id)?/i',
819 'table_name' => 'civicrm_contribution',
820 'entity' => 'Contribution',
821 'bao' => 'CRM_Contribute_BAO_Contribution',
828 'name' => 'tax_amount',
829 'type' => CRM_Utils_Type
::T_MONEY
,
830 'title' => ts('Tax Amount'),
831 'description' => ts('Total tax amount of this contribution.'),
837 'where' => 'civicrm_contribution.tax_amount',
838 'headerPattern' => '/tax(.?am(ou)?nt)?/i',
839 'dataPattern' => '/^\d+(\.\d{2})?$/',
841 'table_name' => 'civicrm_contribution',
842 'entity' => 'Contribution',
843 'bao' => 'CRM_Contribute_BAO_Contribution',
849 'revenue_recognition_date' => [
850 'name' => 'revenue_recognition_date',
851 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
852 'title' => ts('Revenue Recognition Date'),
853 'description' => ts('Stores the date when revenue should be recognized.'),
855 'where' => 'civicrm_contribution.revenue_recognition_date',
856 'headerPattern' => '/revenue(.?date)?/i',
857 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
859 'table_name' => 'civicrm_contribution',
860 'entity' => 'Contribution',
861 'bao' => 'CRM_Contribute_BAO_Contribution',
864 'type' => 'Select Date',
865 'formatType' => 'activityDateTime',
869 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'fields_callback', Civi
::$statics[__CLASS__
]['fields']);
871 return Civi
::$statics[__CLASS__
]['fields'];
875 * Return a mapping from field-name to the corresponding key (as used in fields()).
878 * Array(string $name => string $uniqueName).
880 public static function &fieldKeys() {
881 if (!isset(Civi
::$statics[__CLASS__
]['fieldKeys'])) {
882 Civi
::$statics[__CLASS__
]['fieldKeys'] = array_flip(CRM_Utils_Array
::collect('name', self
::fields()));
884 return Civi
::$statics[__CLASS__
]['fieldKeys'];
888 * Returns the names of this table
892 public static function getTableName() {
893 return self
::$_tableName;
897 * Returns if this table needs to be logged
901 public function getLog() {
906 * Returns the list of fields that can be imported
908 * @param bool $prefix
912 public static function &import($prefix = FALSE) {
913 $r = CRM_Core_DAO_AllCoreTables
::getImports(__CLASS__
, 'contribution', $prefix, []);
918 * Returns the list of fields that can be exported
920 * @param bool $prefix
924 public static function &export($prefix = FALSE) {
925 $r = CRM_Core_DAO_AllCoreTables
::getExports(__CLASS__
, 'contribution', $prefix, []);
930 * Returns the list of indices
932 * @param bool $localize
936 public static function indices($localize = TRUE) {
938 'UI_contrib_payment_instrument_id' => [
939 'name' => 'UI_contrib_payment_instrument_id',
941 0 => 'payment_instrument_id',
943 'localizable' => FALSE,
944 'sig' => 'civicrm_contribution::0::payment_instrument_id',
946 'index_total_amount_receive_date' => [
947 'name' => 'index_total_amount_receive_date',
952 'localizable' => FALSE,
953 'sig' => 'civicrm_contribution::0::total_amount::receive_date',
956 'name' => 'index_source',
960 'localizable' => FALSE,
961 'sig' => 'civicrm_contribution::0::source',
963 'UI_contrib_trxn_id' => [
964 'name' => 'UI_contrib_trxn_id',
968 'localizable' => FALSE,
970 'sig' => 'civicrm_contribution::1::trxn_id',
972 'UI_contrib_invoice_id' => [
973 'name' => 'UI_contrib_invoice_id',
977 'localizable' => FALSE,
979 'sig' => 'civicrm_contribution::1::invoice_id',
981 'index_contribution_status' => [
982 'name' => 'index_contribution_status',
984 0 => 'contribution_status_id',
986 'localizable' => FALSE,
987 'sig' => 'civicrm_contribution::0::contribution_status_id',
990 'name' => 'received_date',
994 'localizable' => FALSE,
995 'sig' => 'civicrm_contribution::0::receive_date',
998 'name' => 'check_number',
1000 0 => 'check_number',
1002 'localizable' => FALSE,
1003 'sig' => 'civicrm_contribution::0::check_number',
1005 'index_creditnote_id' => [
1006 'name' => 'index_creditnote_id',
1008 0 => 'creditnote_id',
1010 'localizable' => FALSE,
1011 'sig' => 'civicrm_contribution::0::creditnote_id',
1014 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables
::multilingualize(__CLASS__
, $indices) : $indices;