5 * @copyright CiviCRM LLC https://civicrm.org/licensing
7 * Generated from xml/schema/CRM/Contribute/Contribution.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
9 * (GenCodeChecksum:5e4c6a77803e361625cafbd2f6e58bbe)
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 public static $_tableName = 'civicrm_contribution';
25 * Icon associated with this entity.
29 public static $_icon = 'fa-credit-card';
32 * Should CiviCRM log any modifications to this table in the civicrm_log table.
36 public static $_log = TRUE;
53 * FK to Financial Type for (total_amount - non_deductible_amount).
57 public $financial_type_id;
60 * The Contribution Page which triggered this contribution
64 public $contribution_page_id;
67 * FK to Payment Instrument
71 public $payment_instrument_id;
74 * Date contribution was received - not necessarily the creation date of the record
81 * Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.
85 public $non_deductible_amount;
88 * Total amount of this contribution. Use market value for non-monetary gifts.
95 * actual processor fee if known - may be 0.
102 * actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.
109 * unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method
116 * unique invoice id, system generated or passed in
123 * Human readable invoice number
127 public $invoice_number;
130 * 3 character string, value from config setting or input via user.
137 * when was gift cancelled
146 public $cancel_reason;
149 * when (if) receipt was sent. populated automatically for online donations w/ automatic receipting
153 public $receipt_date;
156 * when (if) was donor thanked
160 public $thankyou_date;
163 * Origin of this Contribution.
172 public $amount_level;
175 * 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.
179 public $contribution_recur_id;
189 public $is_pay_later;
194 public $contribution_status_id;
197 * Conditional foreign key to civicrm_address.id. We insert an address record for each contribution when we have associated billing name and address data.
206 public $check_number;
209 * The campaign for which this contribution has been triggered.
216 * unique credit note id, system generated or passed in
220 public $creditnote_id;
223 * Total tax amount of this contribution.
230 * Stores the date when revenue should be recognized.
234 public $revenue_recognition_date;
237 * Shows this is a template for recurring contributions.
246 public function __construct() {
247 $this->__table
= 'civicrm_contribution';
248 parent
::__construct();
252 * Returns localized title of this entity.
254 public static function getEntityTitle() {
255 return ts('Contributions');
259 * Returns foreign keys and entity references.
262 * [CRM_Core_Reference_Interface]
264 public static function getReferenceColumns() {
265 if (!isset(Civi
::$statics[__CLASS__
]['links'])) {
266 Civi
::$statics[__CLASS__
]['links'] = static::createReferenceColumns(__CLASS__
);
267 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'contact_id', 'civicrm_contact', 'id');
268 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'financial_type_id', 'civicrm_financial_type', 'id');
269 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'contribution_page_id', 'civicrm_contribution_page', 'id');
270 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'contribution_recur_id', 'civicrm_contribution_recur', 'id');
271 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'address_id', 'civicrm_address', 'id');
272 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
273 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'links_callback', Civi
::$statics[__CLASS__
]['links']);
275 return Civi
::$statics[__CLASS__
]['links'];
279 * Returns all the column names of this table
283 public static function &fields() {
284 if (!isset(Civi
::$statics[__CLASS__
]['fields'])) {
285 Civi
::$statics[__CLASS__
]['fields'] = [
286 'contribution_id' => [
288 'type' => CRM_Utils_Type
::T_INT
,
289 'title' => ts('Contribution ID'),
290 'description' => ts('Contribution ID'),
293 'where' => 'civicrm_contribution.id',
295 'table_name' => 'civicrm_contribution',
296 'entity' => 'Contribution',
297 'bao' => 'CRM_Contribute_BAO_Contribution',
304 'contribution_contact_id' => [
305 'name' => 'contact_id',
306 'type' => CRM_Utils_Type
::T_INT
,
307 'title' => ts('Contact ID'),
308 'description' => ts('FK to Contact ID'),
311 'where' => 'civicrm_contribution.contact_id',
312 'headerPattern' => '/contact(.?id)?/i',
313 'dataPattern' => '/^\d+$/',
315 'table_name' => 'civicrm_contribution',
316 'entity' => 'Contribution',
317 'bao' => 'CRM_Contribute_BAO_Contribution',
319 'FKClassName' => 'CRM_Contact_DAO_Contact',
321 'type' => 'EntityRef',
325 'financial_type_id' => [
326 'name' => 'financial_type_id',
327 'type' => CRM_Utils_Type
::T_INT
,
328 'title' => ts('Financial Type'),
329 'description' => ts('FK to Financial Type for (total_amount - non_deductible_amount).'),
330 'where' => 'civicrm_contribution.financial_type_id',
332 'table_name' => 'civicrm_contribution',
333 'entity' => 'Contribution',
334 'bao' => 'CRM_Contribute_BAO_Contribution',
336 'FKClassName' => 'CRM_Financial_DAO_FinancialType',
340 'pseudoconstant' => [
341 'table' => 'civicrm_financial_type',
343 'labelColumn' => 'name',
347 'contribution_page_id' => [
348 'name' => 'contribution_page_id',
349 'type' => CRM_Utils_Type
::T_INT
,
350 'title' => ts('Contribution Page ID'),
351 'description' => ts('The Contribution Page which triggered this contribution'),
353 'where' => 'civicrm_contribution.contribution_page_id',
355 'table_name' => 'civicrm_contribution',
356 'entity' => 'Contribution',
357 'bao' => 'CRM_Contribute_BAO_Contribution',
359 'FKClassName' => 'CRM_Contribute_DAO_ContributionPage',
363 'pseudoconstant' => [
364 'table' => 'civicrm_contribution_page',
366 'labelColumn' => 'title',
370 'payment_instrument_id' => [
371 'name' => 'payment_instrument_id',
372 'type' => CRM_Utils_Type
::T_INT
,
373 'title' => ts('Payment Method ID'),
374 'description' => ts('FK to Payment Instrument'),
375 'where' => 'civicrm_contribution.payment_instrument_id',
376 'headerPattern' => '/^payment|(p(ayment\s)?instrument)$/i',
378 'table_name' => 'civicrm_contribution',
379 'entity' => 'Contribution',
380 'bao' => 'CRM_Contribute_BAO_Contribution',
385 'pseudoconstant' => [
386 'optionGroupName' => 'payment_instrument',
387 'optionEditPath' => 'civicrm/admin/options/payment_instrument',
392 'name' => 'receive_date',
393 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
394 'title' => ts('Date Received'),
395 'description' => ts('Date contribution was received - not necessarily the creation date of the record'),
397 'where' => 'civicrm_contribution.receive_date',
398 'headerPattern' => '/receive(.?date)?/i',
399 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
401 'table_name' => 'civicrm_contribution',
402 'entity' => 'Contribution',
403 'bao' => 'CRM_Contribute_BAO_Contribution',
406 'type' => 'Select Date',
407 'formatType' => 'activityDateTime',
411 'non_deductible_amount' => [
412 'name' => 'non_deductible_amount',
413 'type' => CRM_Utils_Type
::T_MONEY
,
414 'title' => ts('Non-deductible Amount'),
415 'description' => ts('Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.'),
421 'where' => 'civicrm_contribution.non_deductible_amount',
422 'headerPattern' => '/non?.?deduct/i',
423 'dataPattern' => '/^\d+(\.\d{2})?$/',
426 'table_name' => 'civicrm_contribution',
427 'entity' => 'Contribution',
428 'bao' => 'CRM_Contribute_BAO_Contribution',
436 'name' => 'total_amount',
437 'type' => CRM_Utils_Type
::T_MONEY
,
438 'title' => ts('Total Amount'),
439 'description' => ts('Total amount of this contribution. Use market value for non-monetary gifts.'),
446 'where' => 'civicrm_contribution.total_amount',
447 'headerPattern' => '/^total|(.?^am(ou)?nt)/i',
448 'dataPattern' => '/^\d+(\.\d{2})?$/',
450 'table_name' => 'civicrm_contribution',
451 'entity' => 'Contribution',
452 'bao' => 'CRM_Contribute_BAO_Contribution',
460 'name' => 'fee_amount',
461 'type' => CRM_Utils_Type
::T_MONEY
,
462 'title' => ts('Fee Amount'),
463 'description' => ts('actual processor fee if known - may be 0.'),
469 'where' => 'civicrm_contribution.fee_amount',
470 'headerPattern' => '/fee(.?am(ou)?nt)?/i',
471 'dataPattern' => '/^\d+(\.\d{2})?$/',
473 'table_name' => 'civicrm_contribution',
474 'entity' => 'Contribution',
475 'bao' => 'CRM_Contribute_BAO_Contribution',
483 'name' => 'net_amount',
484 'type' => CRM_Utils_Type
::T_MONEY
,
485 'title' => ts('Net Amount'),
486 'description' => ts('actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.'),
492 'where' => 'civicrm_contribution.net_amount',
493 'headerPattern' => '/net(.?am(ou)?nt)?/i',
494 'dataPattern' => '/^\d+(\.\d{2})?$/',
496 'table_name' => 'civicrm_contribution',
497 'entity' => 'Contribution',
498 'bao' => 'CRM_Contribute_BAO_Contribution',
507 'type' => CRM_Utils_Type
::T_STRING
,
508 'title' => ts('Transaction ID'),
509 'description' => ts('unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method'),
511 'size' => CRM_Utils_Type
::HUGE
,
513 'where' => 'civicrm_contribution.trxn_id',
514 'headerPattern' => '/tr(ansactio|x)n(.?id)?/i',
516 'table_name' => 'civicrm_contribution',
517 'entity' => 'Contribution',
518 'bao' => 'CRM_Contribute_BAO_Contribution',
526 'name' => 'invoice_id',
527 'type' => CRM_Utils_Type
::T_STRING
,
528 'title' => ts('Invoice Reference'),
529 'description' => ts('unique invoice id, system generated or passed in'),
531 'size' => CRM_Utils_Type
::HUGE
,
533 'where' => 'civicrm_contribution.invoice_id',
534 'headerPattern' => '/invoice(.?id)?/i',
536 'table_name' => 'civicrm_contribution',
537 'entity' => 'Contribution',
538 'bao' => 'CRM_Contribute_BAO_Contribution',
545 'invoice_number' => [
546 'name' => 'invoice_number',
547 'type' => CRM_Utils_Type
::T_STRING
,
548 'title' => ts('Invoice Number'),
549 'description' => ts('Human readable invoice number'),
551 'size' => CRM_Utils_Type
::HUGE
,
553 'where' => 'civicrm_contribution.invoice_number',
554 'headerPattern' => '/invoice(.?number)?/i',
556 'table_name' => 'civicrm_contribution',
557 'entity' => 'Contribution',
558 'bao' => 'CRM_Contribute_BAO_Contribution',
566 'name' => 'currency',
567 'type' => CRM_Utils_Type
::T_STRING
,
568 'title' => ts('Currency'),
569 'description' => ts('3 character string, value from config setting or input via user.'),
571 'size' => CRM_Utils_Type
::FOUR
,
573 'where' => 'civicrm_contribution.currency',
574 'headerPattern' => '/cur(rency)?/i',
575 'dataPattern' => '/^[A-Z]{3}$/i',
578 'table_name' => 'civicrm_contribution',
579 'entity' => 'Contribution',
580 'bao' => 'CRM_Contribute_BAO_Contribution',
585 'pseudoconstant' => [
586 'table' => 'civicrm_currency',
587 'keyColumn' => 'name',
588 'labelColumn' => 'full_name',
589 'nameColumn' => 'name',
590 'abbrColumn' => 'symbol',
594 'contribution_cancel_date' => [
595 'name' => 'cancel_date',
596 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
597 'title' => ts('Cancelled / Refunded Date'),
598 'description' => ts('when was gift cancelled'),
600 'where' => 'civicrm_contribution.cancel_date',
601 'headerPattern' => '/cancel(.?date)?/i',
602 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
604 'table_name' => 'civicrm_contribution',
605 'entity' => 'Contribution',
606 'bao' => 'CRM_Contribute_BAO_Contribution',
609 'type' => 'Select Date',
610 'formatType' => 'activityDateTime',
615 'name' => 'cancel_reason',
616 'type' => CRM_Utils_Type
::T_TEXT
,
617 'title' => ts('Cancellation / Refund Reason'),
619 'where' => 'civicrm_contribution.cancel_reason',
620 'headerPattern' => '/(cancel.?)?reason/i',
622 'table_name' => 'civicrm_contribution',
623 'entity' => 'Contribution',
624 'bao' => 'CRM_Contribute_BAO_Contribution',
632 'name' => 'receipt_date',
633 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
634 'title' => ts('Receipt Date'),
635 'description' => ts('when (if) receipt was sent. populated automatically for online donations w/ automatic receipting'),
637 'where' => 'civicrm_contribution.receipt_date',
638 'headerPattern' => '/receipt(.?date)?/i',
639 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
641 'table_name' => 'civicrm_contribution',
642 'entity' => 'Contribution',
643 'bao' => 'CRM_Contribute_BAO_Contribution',
646 'type' => 'Select Date',
647 'formatType' => 'activityDateTime',
652 'name' => 'thankyou_date',
653 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
654 'title' => ts('Thank-you Date'),
655 'description' => ts('when (if) was donor thanked'),
657 'where' => 'civicrm_contribution.thankyou_date',
658 'headerPattern' => '/thank(s|(.?you))?(.?date)?/i',
659 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
661 'table_name' => 'civicrm_contribution',
662 'entity' => 'Contribution',
663 'bao' => 'CRM_Contribute_BAO_Contribution',
666 'type' => 'Select Date',
667 'formatType' => 'activityDateTime',
671 'contribution_source' => [
673 'type' => CRM_Utils_Type
::T_STRING
,
674 'title' => ts('Contribution Source'),
675 'description' => ts('Origin of this Contribution.'),
677 'size' => CRM_Utils_Type
::HUGE
,
679 'where' => 'civicrm_contribution.source',
680 'headerPattern' => '/source/i',
682 'table_name' => 'civicrm_contribution',
683 'entity' => 'Contribution',
684 'bao' => 'CRM_Contribute_BAO_Contribution',
692 'name' => 'amount_level',
693 'type' => CRM_Utils_Type
::T_TEXT
,
694 'title' => ts('Amount Label'),
696 'where' => 'civicrm_contribution.amount_level',
698 'table_name' => 'civicrm_contribution',
699 'entity' => 'Contribution',
700 'bao' => 'CRM_Contribute_BAO_Contribution',
707 'contribution_recur_id' => [
708 'name' => 'contribution_recur_id',
709 'type' => CRM_Utils_Type
::T_INT
,
710 'title' => ts('Recurring Contribution ID'),
711 '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.'),
712 'where' => 'civicrm_contribution.contribution_recur_id',
714 'table_name' => 'civicrm_contribution',
715 'entity' => 'Contribution',
716 'bao' => 'CRM_Contribute_BAO_Contribution',
718 'FKClassName' => 'CRM_Contribute_DAO_ContributionRecur',
723 'type' => CRM_Utils_Type
::T_BOOLEAN
,
724 'title' => ts('Test'),
726 'where' => 'civicrm_contribution.is_test',
729 'table_name' => 'civicrm_contribution',
730 'entity' => 'Contribution',
731 'bao' => 'CRM_Contribute_BAO_Contribution',
734 'type' => 'CheckBox',
739 'name' => 'is_pay_later',
740 'type' => CRM_Utils_Type
::T_BOOLEAN
,
741 'title' => ts('Is Pay Later'),
743 'where' => 'civicrm_contribution.is_pay_later',
746 'table_name' => 'civicrm_contribution',
747 'entity' => 'Contribution',
748 'bao' => 'CRM_Contribute_BAO_Contribution',
751 'type' => 'CheckBox',
755 'contribution_status_id' => [
756 'name' => 'contribution_status_id',
757 'type' => CRM_Utils_Type
::T_INT
,
758 'title' => ts('Contribution Status ID'),
760 'where' => 'civicrm_contribution.contribution_status_id',
761 'headerPattern' => '/status/i',
764 'table_name' => 'civicrm_contribution',
765 'entity' => 'Contribution',
766 'bao' => 'CRM_Contribute_BAO_Contribution',
771 'pseudoconstant' => [
772 'optionGroupName' => 'contribution_status',
773 'optionEditPath' => 'civicrm/admin/options/contribution_status',
777 'contribution_address_id' => [
778 'name' => 'address_id',
779 'type' => CRM_Utils_Type
::T_INT
,
780 'title' => ts('Contribution Address'),
781 '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.'),
782 'where' => 'civicrm_contribution.address_id',
784 'table_name' => 'civicrm_contribution',
785 'entity' => 'Contribution',
786 'bao' => 'CRM_Contribute_BAO_Contribution',
788 'FKClassName' => 'CRM_Core_DAO_Address',
791 'contribution_check_number' => [
792 'name' => 'check_number',
793 'type' => CRM_Utils_Type
::T_STRING
,
794 'title' => ts('Check Number'),
798 'where' => 'civicrm_contribution.check_number',
799 'headerPattern' => '/check(.?number)?/i',
801 'table_name' => 'civicrm_contribution',
802 'entity' => 'Contribution',
803 'bao' => 'CRM_Contribute_BAO_Contribution',
810 'contribution_campaign_id' => [
811 'name' => 'campaign_id',
812 'type' => CRM_Utils_Type
::T_INT
,
813 'title' => ts('Campaign'),
814 'description' => ts('The campaign for which this contribution has been triggered.'),
816 'where' => 'civicrm_contribution.campaign_id',
818 'table_name' => 'civicrm_contribution',
819 'entity' => 'Contribution',
820 'bao' => 'CRM_Contribute_BAO_Contribution',
822 'FKClassName' => 'CRM_Campaign_DAO_Campaign',
826 'pseudoconstant' => [
827 'table' => 'civicrm_campaign',
829 'labelColumn' => 'title',
834 'name' => 'creditnote_id',
835 'type' => CRM_Utils_Type
::T_STRING
,
836 'title' => ts('Credit Note ID'),
837 'description' => ts('unique credit note id, system generated or passed in'),
839 'size' => CRM_Utils_Type
::HUGE
,
841 'where' => 'civicrm_contribution.creditnote_id',
842 'headerPattern' => '/creditnote(.?id)?/i',
844 'table_name' => 'civicrm_contribution',
845 'entity' => 'Contribution',
846 'bao' => 'CRM_Contribute_BAO_Contribution',
854 'name' => 'tax_amount',
855 'type' => CRM_Utils_Type
::T_MONEY
,
856 'title' => ts('Tax Amount'),
857 'description' => ts('Total tax amount of this contribution.'),
863 'where' => 'civicrm_contribution.tax_amount',
864 'headerPattern' => '/tax(.?am(ou)?nt)?/i',
865 'dataPattern' => '/^\d+(\.\d{2})?$/',
867 'table_name' => 'civicrm_contribution',
868 'entity' => 'Contribution',
869 'bao' => 'CRM_Contribute_BAO_Contribution',
876 'revenue_recognition_date' => [
877 'name' => 'revenue_recognition_date',
878 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
879 'title' => ts('Revenue Recognition Date'),
880 'description' => ts('Stores the date when revenue should be recognized.'),
882 'where' => 'civicrm_contribution.revenue_recognition_date',
883 'headerPattern' => '/revenue(.?date)?/i',
884 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
886 'table_name' => 'civicrm_contribution',
887 'entity' => 'Contribution',
888 'bao' => 'CRM_Contribute_BAO_Contribution',
891 'type' => 'Select Date',
892 'formatType' => 'activityDateTime',
897 'name' => 'is_template',
898 'type' => CRM_Utils_Type
::T_BOOLEAN
,
899 'title' => ts('Is a Template Contribution'),
900 'description' => ts('Shows this is a template for recurring contributions.'),
902 'where' => 'civicrm_contribution.is_template',
905 'table_name' => 'civicrm_contribution',
906 'entity' => 'Contribution',
907 'bao' => 'CRM_Contribute_BAO_Contribution',
910 'type' => 'CheckBox',
915 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'fields_callback', Civi
::$statics[__CLASS__
]['fields']);
917 return Civi
::$statics[__CLASS__
]['fields'];
921 * Return a mapping from field-name to the corresponding key (as used in fields()).
924 * Array(string $name => string $uniqueName).
926 public static function &fieldKeys() {
927 if (!isset(Civi
::$statics[__CLASS__
]['fieldKeys'])) {
928 Civi
::$statics[__CLASS__
]['fieldKeys'] = array_flip(CRM_Utils_Array
::collect('name', self
::fields()));
930 return Civi
::$statics[__CLASS__
]['fieldKeys'];
934 * Returns the names of this table
938 public static function getTableName() {
939 return self
::$_tableName;
943 * Returns if this table needs to be logged
947 public function getLog() {
952 * Returns the list of fields that can be imported
954 * @param bool $prefix
958 public static function &import($prefix = FALSE) {
959 $r = CRM_Core_DAO_AllCoreTables
::getImports(__CLASS__
, 'contribution', $prefix, []);
964 * Returns the list of fields that can be exported
966 * @param bool $prefix
970 public static function &export($prefix = FALSE) {
971 $r = CRM_Core_DAO_AllCoreTables
::getExports(__CLASS__
, 'contribution', $prefix, []);
976 * Returns the list of indices
978 * @param bool $localize
982 public static function indices($localize = TRUE) {
984 'UI_contrib_payment_instrument_id' => [
985 'name' => 'UI_contrib_payment_instrument_id',
987 0 => 'payment_instrument_id',
989 'localizable' => FALSE,
990 'sig' => 'civicrm_contribution::0::payment_instrument_id',
992 'index_total_amount_receive_date' => [
993 'name' => 'index_total_amount_receive_date',
998 'localizable' => FALSE,
999 'sig' => 'civicrm_contribution::0::total_amount::receive_date',
1002 'name' => 'index_source',
1006 'localizable' => FALSE,
1007 'sig' => 'civicrm_contribution::0::source',
1009 'UI_contrib_trxn_id' => [
1010 'name' => 'UI_contrib_trxn_id',
1014 'localizable' => FALSE,
1016 'sig' => 'civicrm_contribution::1::trxn_id',
1018 'UI_contrib_invoice_id' => [
1019 'name' => 'UI_contrib_invoice_id',
1023 'localizable' => FALSE,
1025 'sig' => 'civicrm_contribution::1::invoice_id',
1027 'index_contribution_status' => [
1028 'name' => 'index_contribution_status',
1030 0 => 'contribution_status_id',
1032 'localizable' => FALSE,
1033 'sig' => 'civicrm_contribution::0::contribution_status_id',
1035 'received_date' => [
1036 'name' => 'received_date',
1038 0 => 'receive_date',
1040 'localizable' => FALSE,
1041 'sig' => 'civicrm_contribution::0::receive_date',
1044 'name' => 'check_number',
1046 0 => 'check_number',
1048 'localizable' => FALSE,
1049 'sig' => 'civicrm_contribution::0::check_number',
1051 'index_creditnote_id' => [
1052 'name' => 'index_creditnote_id',
1054 0 => 'creditnote_id',
1056 'localizable' => FALSE,
1057 'sig' => 'civicrm_contribution::0::creditnote_id',
1060 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables
::multilingualize(__CLASS__
, $indices) : $indices;