5 * @copyright CiviCRM LLC (c) 2004-2019
7 * Generated from xml/schema/CRM/Contribute/Contribution.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
9 * (GenCodeChecksum:0972c177daa2ee48c98658f62c0f8ade)
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 * Should CiviCRM log any modifications to this table in the civicrm_log table.
29 public static $_log = TRUE;
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',
274 'table_name' => 'civicrm_contribution',
275 'entity' => 'Contribution',
276 'bao' => 'CRM_Contribute_BAO_Contribution',
279 'contribution_contact_id' => [
280 'name' => 'contact_id',
281 'type' => CRM_Utils_Type
::T_INT
,
282 'title' => ts('Contact ID'),
283 'description' => ts('FK to Contact ID'),
286 'where' => 'civicrm_contribution.contact_id',
287 'headerPattern' => '/contact(.?id)?/i',
288 'dataPattern' => '/^\d+$/',
290 'table_name' => 'civicrm_contribution',
291 'entity' => 'Contribution',
292 'bao' => 'CRM_Contribute_BAO_Contribution',
294 'FKClassName' => 'CRM_Contact_DAO_Contact',
296 'type' => 'EntityRef',
299 'financial_type_id' => [
300 'name' => 'financial_type_id',
301 'type' => CRM_Utils_Type
::T_INT
,
302 'title' => ts('Financial Type'),
303 'description' => ts('FK to Financial Type for (total_amount - non_deductible_amount).'),
304 'where' => 'civicrm_contribution.financial_type_id',
306 'table_name' => 'civicrm_contribution',
307 'entity' => 'Contribution',
308 'bao' => 'CRM_Contribute_BAO_Contribution',
310 'FKClassName' => 'CRM_Financial_DAO_FinancialType',
314 'pseudoconstant' => [
315 'table' => 'civicrm_financial_type',
317 'labelColumn' => 'name',
320 'contribution_page_id' => [
321 'name' => 'contribution_page_id',
322 'type' => CRM_Utils_Type
::T_INT
,
323 'title' => ts('Contribution Page ID'),
324 'description' => ts('The Contribution Page which triggered this contribution'),
326 'where' => 'civicrm_contribution.contribution_page_id',
328 'table_name' => 'civicrm_contribution',
329 'entity' => 'Contribution',
330 'bao' => 'CRM_Contribute_BAO_Contribution',
332 'FKClassName' => 'CRM_Contribute_DAO_ContributionPage',
336 'pseudoconstant' => [
337 'table' => 'civicrm_contribution_page',
339 'labelColumn' => 'title',
342 'payment_instrument_id' => [
343 'name' => 'payment_instrument_id',
344 'type' => CRM_Utils_Type
::T_INT
,
345 'title' => ts('Payment Method ID'),
346 'description' => ts('FK to Payment Instrument'),
347 'where' => 'civicrm_contribution.payment_instrument_id',
348 'headerPattern' => '/^payment|(p(ayment\s)?instrument)$/i',
350 'table_name' => 'civicrm_contribution',
351 'entity' => 'Contribution',
352 'bao' => 'CRM_Contribute_BAO_Contribution',
357 'pseudoconstant' => [
358 'optionGroupName' => 'payment_instrument',
359 'optionEditPath' => 'civicrm/admin/options/payment_instrument',
363 'name' => 'receive_date',
364 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
365 'title' => ts('Date Received'),
366 'description' => ts('Date contribution was received - not necessarily the creation date of the record'),
368 'where' => 'civicrm_contribution.receive_date',
369 'headerPattern' => '/receive(.?date)?/i',
370 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
372 'table_name' => 'civicrm_contribution',
373 'entity' => 'Contribution',
374 'bao' => 'CRM_Contribute_BAO_Contribution',
377 'type' => 'Select Date',
378 'formatType' => 'activityDateTime',
381 'non_deductible_amount' => [
382 'name' => 'non_deductible_amount',
383 'type' => CRM_Utils_Type
::T_MONEY
,
384 'title' => ts('Non-deductible Amount'),
385 'description' => ts('Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.'),
391 'where' => 'civicrm_contribution.non_deductible_amount',
392 'headerPattern' => '/non?.?deduct/i',
393 'dataPattern' => '/^\d+(\.\d{2})?$/',
396 'table_name' => 'civicrm_contribution',
397 'entity' => 'Contribution',
398 'bao' => 'CRM_Contribute_BAO_Contribution',
405 'name' => 'total_amount',
406 'type' => CRM_Utils_Type
::T_MONEY
,
407 'title' => ts('Total Amount'),
408 'description' => ts('Total amount of this contribution. Use market value for non-monetary gifts.'),
415 'where' => 'civicrm_contribution.total_amount',
416 'headerPattern' => '/^total|(.?^am(ou)?nt)/i',
417 'dataPattern' => '/^\d+(\.\d{2})?$/',
419 'table_name' => 'civicrm_contribution',
420 'entity' => 'Contribution',
421 'bao' => 'CRM_Contribute_BAO_Contribution',
428 'name' => 'fee_amount',
429 'type' => CRM_Utils_Type
::T_MONEY
,
430 'title' => ts('Fee Amount'),
431 'description' => ts('actual processor fee if known - may be 0.'),
437 'where' => 'civicrm_contribution.fee_amount',
438 'headerPattern' => '/fee(.?am(ou)?nt)?/i',
439 'dataPattern' => '/^\d+(\.\d{2})?$/',
441 'table_name' => 'civicrm_contribution',
442 'entity' => 'Contribution',
443 'bao' => 'CRM_Contribute_BAO_Contribution',
450 'name' => 'net_amount',
451 'type' => CRM_Utils_Type
::T_MONEY
,
452 'title' => ts('Net Amount'),
453 'description' => ts('actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.'),
459 'where' => 'civicrm_contribution.net_amount',
460 'headerPattern' => '/net(.?am(ou)?nt)?/i',
461 'dataPattern' => '/^\d+(\.\d{2})?$/',
463 'table_name' => 'civicrm_contribution',
464 'entity' => 'Contribution',
465 'bao' => 'CRM_Contribute_BAO_Contribution',
473 'type' => CRM_Utils_Type
::T_STRING
,
474 'title' => ts('Transaction ID'),
475 'description' => ts('unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method'),
477 'size' => CRM_Utils_Type
::HUGE
,
479 'where' => 'civicrm_contribution.trxn_id',
480 'headerPattern' => '/tr(ansactio|x)n(.?id)?/i',
482 'table_name' => 'civicrm_contribution',
483 'entity' => 'Contribution',
484 'bao' => 'CRM_Contribute_BAO_Contribution',
491 'name' => 'invoice_id',
492 'type' => CRM_Utils_Type
::T_STRING
,
493 'title' => ts('Invoice Reference'),
494 'description' => ts('unique invoice id, system generated or passed in'),
496 'size' => CRM_Utils_Type
::HUGE
,
498 'where' => 'civicrm_contribution.invoice_id',
499 'headerPattern' => '/invoice(.?id)?/i',
501 'table_name' => 'civicrm_contribution',
502 'entity' => 'Contribution',
503 'bao' => 'CRM_Contribute_BAO_Contribution',
509 'invoice_number' => [
510 'name' => 'invoice_number',
511 'type' => CRM_Utils_Type
::T_STRING
,
512 'title' => ts('Invoice Number'),
513 'description' => ts('Human readable invoice number'),
515 'size' => CRM_Utils_Type
::HUGE
,
517 'where' => 'civicrm_contribution.invoice_number',
518 'headerPattern' => '/invoice(.?number)?/i',
520 'table_name' => 'civicrm_contribution',
521 'entity' => 'Contribution',
522 'bao' => 'CRM_Contribute_BAO_Contribution',
529 'name' => 'currency',
530 'type' => CRM_Utils_Type
::T_STRING
,
531 'title' => ts('Currency'),
532 'description' => ts('3 character string, value from config setting or input via user.'),
534 'size' => CRM_Utils_Type
::FOUR
,
536 'where' => 'civicrm_contribution.currency',
537 'headerPattern' => '/cur(rency)?/i',
538 'dataPattern' => '/^[A-Z]{3}$/i',
541 'table_name' => 'civicrm_contribution',
542 'entity' => 'Contribution',
543 'bao' => 'CRM_Contribute_BAO_Contribution',
548 'pseudoconstant' => [
549 'table' => 'civicrm_currency',
550 'keyColumn' => 'name',
551 'labelColumn' => 'full_name',
552 'nameColumn' => 'name',
555 'contribution_cancel_date' => [
556 'name' => 'cancel_date',
557 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
558 'title' => ts('Cancelled / Refunded Date'),
559 'description' => ts('when was gift cancelled'),
561 'where' => 'civicrm_contribution.cancel_date',
562 'headerPattern' => '/cancel(.?date)?/i',
563 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
565 'table_name' => 'civicrm_contribution',
566 'entity' => 'Contribution',
567 'bao' => 'CRM_Contribute_BAO_Contribution',
570 'type' => 'Select Date',
571 'formatType' => 'activityDateTime',
575 'name' => 'cancel_reason',
576 'type' => CRM_Utils_Type
::T_TEXT
,
577 'title' => ts('Cancellation / Refund Reason'),
579 'where' => 'civicrm_contribution.cancel_reason',
580 'headerPattern' => '/(cancel.?)?reason/i',
582 'table_name' => 'civicrm_contribution',
583 'entity' => 'Contribution',
584 'bao' => 'CRM_Contribute_BAO_Contribution',
591 'name' => 'receipt_date',
592 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
593 'title' => ts('Receipt Date'),
594 'description' => ts('when (if) receipt was sent. populated automatically for online donations w/ automatic receipting'),
596 'where' => 'civicrm_contribution.receipt_date',
597 'headerPattern' => '/receipt(.?date)?/i',
598 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
600 'table_name' => 'civicrm_contribution',
601 'entity' => 'Contribution',
602 'bao' => 'CRM_Contribute_BAO_Contribution',
605 'type' => 'Select Date',
606 'formatType' => 'activityDateTime',
610 'name' => 'thankyou_date',
611 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
612 'title' => ts('Thank-you Date'),
613 'description' => ts('when (if) was donor thanked'),
615 'where' => 'civicrm_contribution.thankyou_date',
616 'headerPattern' => '/thank(s|(.?you))?(.?date)?/i',
617 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
619 'table_name' => 'civicrm_contribution',
620 'entity' => 'Contribution',
621 'bao' => 'CRM_Contribute_BAO_Contribution',
624 'type' => 'Select Date',
625 'formatType' => 'activityDateTime',
628 'contribution_source' => [
630 'type' => CRM_Utils_Type
::T_STRING
,
631 'title' => ts('Contribution Source'),
632 'description' => ts('Origin of this Contribution.'),
634 'size' => CRM_Utils_Type
::HUGE
,
636 'where' => 'civicrm_contribution.source',
637 'headerPattern' => '/source/i',
639 'table_name' => 'civicrm_contribution',
640 'entity' => 'Contribution',
641 'bao' => 'CRM_Contribute_BAO_Contribution',
648 'name' => 'amount_level',
649 'type' => CRM_Utils_Type
::T_TEXT
,
650 'title' => ts('Amount Label'),
652 'where' => 'civicrm_contribution.amount_level',
654 'table_name' => 'civicrm_contribution',
655 'entity' => 'Contribution',
656 'bao' => 'CRM_Contribute_BAO_Contribution',
662 'contribution_recur_id' => [
663 'name' => 'contribution_recur_id',
664 'type' => CRM_Utils_Type
::T_INT
,
665 'title' => ts('Recurring Contribution ID'),
666 '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.'),
667 'where' => 'civicrm_contribution.contribution_recur_id',
669 'table_name' => 'civicrm_contribution',
670 'entity' => 'Contribution',
671 'bao' => 'CRM_Contribute_BAO_Contribution',
673 'FKClassName' => 'CRM_Contribute_DAO_ContributionRecur',
677 'type' => CRM_Utils_Type
::T_BOOLEAN
,
678 'title' => ts('Test'),
680 'where' => 'civicrm_contribution.is_test',
683 'table_name' => 'civicrm_contribution',
684 'entity' => 'Contribution',
685 'bao' => 'CRM_Contribute_BAO_Contribution',
688 'type' => 'CheckBox',
692 'name' => 'is_pay_later',
693 'type' => CRM_Utils_Type
::T_BOOLEAN
,
694 'title' => ts('Is Pay Later'),
696 'where' => 'civicrm_contribution.is_pay_later',
699 'table_name' => 'civicrm_contribution',
700 'entity' => 'Contribution',
701 'bao' => 'CRM_Contribute_BAO_Contribution',
704 'type' => 'CheckBox',
707 'contribution_status_id' => [
708 'name' => 'contribution_status_id',
709 'type' => CRM_Utils_Type
::T_INT
,
710 'title' => ts('Contribution Status ID'),
712 'where' => 'civicrm_contribution.contribution_status_id',
713 'headerPattern' => '/status/i',
716 'table_name' => 'civicrm_contribution',
717 'entity' => 'Contribution',
718 'bao' => 'CRM_Contribute_BAO_Contribution',
723 'pseudoconstant' => [
724 'optionGroupName' => 'contribution_status',
725 'optionEditPath' => 'civicrm/admin/options/contribution_status',
728 'contribution_address_id' => [
729 'name' => 'address_id',
730 'type' => CRM_Utils_Type
::T_INT
,
731 'title' => ts('Contribution Address'),
732 '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.'),
733 'where' => 'civicrm_contribution.address_id',
735 'table_name' => 'civicrm_contribution',
736 'entity' => 'Contribution',
737 'bao' => 'CRM_Contribute_BAO_Contribution',
739 'FKClassName' => 'CRM_Core_DAO_Address',
741 'contribution_check_number' => [
742 'name' => 'check_number',
743 'type' => CRM_Utils_Type
::T_STRING
,
744 'title' => ts('Check Number'),
748 'where' => 'civicrm_contribution.check_number',
749 'headerPattern' => '/check(.?number)?/i',
751 'table_name' => 'civicrm_contribution',
752 'entity' => 'Contribution',
753 'bao' => 'CRM_Contribute_BAO_Contribution',
759 'contribution_campaign_id' => [
760 'name' => 'campaign_id',
761 'type' => CRM_Utils_Type
::T_INT
,
762 'title' => ts('Campaign'),
763 'description' => ts('The campaign for which this contribution has been triggered.'),
765 'where' => 'civicrm_contribution.campaign_id',
767 'table_name' => 'civicrm_contribution',
768 'entity' => 'Contribution',
769 'bao' => 'CRM_Contribute_BAO_Contribution',
771 'FKClassName' => 'CRM_Campaign_DAO_Campaign',
775 'pseudoconstant' => [
776 'table' => 'civicrm_campaign',
778 'labelColumn' => 'title',
782 'name' => 'creditnote_id',
783 'type' => CRM_Utils_Type
::T_STRING
,
784 'title' => ts('Credit Note ID'),
785 'description' => ts('unique credit note id, system generated or passed in'),
787 'size' => CRM_Utils_Type
::HUGE
,
789 'where' => 'civicrm_contribution.creditnote_id',
790 'headerPattern' => '/creditnote(.?id)?/i',
792 'table_name' => 'civicrm_contribution',
793 'entity' => 'Contribution',
794 'bao' => 'CRM_Contribute_BAO_Contribution',
801 'name' => 'tax_amount',
802 'type' => CRM_Utils_Type
::T_MONEY
,
803 'title' => ts('Tax Amount'),
804 'description' => ts('Total tax amount of this contribution.'),
810 'where' => 'civicrm_contribution.tax_amount',
811 'headerPattern' => '/tax(.?am(ou)?nt)?/i',
812 'dataPattern' => '/^\d+(\.\d{2})?$/',
814 'table_name' => 'civicrm_contribution',
815 'entity' => 'Contribution',
816 'bao' => 'CRM_Contribute_BAO_Contribution',
822 'revenue_recognition_date' => [
823 'name' => 'revenue_recognition_date',
824 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
825 'title' => ts('Revenue Recognition Date'),
826 'description' => ts('Stores the date when revenue should be recognized.'),
828 'where' => 'civicrm_contribution.revenue_recognition_date',
829 'headerPattern' => '/revenue(.?date)?/i',
830 'dataPattern' => '/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/',
832 'table_name' => 'civicrm_contribution',
833 'entity' => 'Contribution',
834 'bao' => 'CRM_Contribute_BAO_Contribution',
837 'type' => 'Select Date',
838 'formatType' => 'activityDateTime',
842 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'fields_callback', Civi
::$statics[__CLASS__
]['fields']);
844 return Civi
::$statics[__CLASS__
]['fields'];
848 * Return a mapping from field-name to the corresponding key (as used in fields()).
851 * Array(string $name => string $uniqueName).
853 public static function &fieldKeys() {
854 if (!isset(Civi
::$statics[__CLASS__
]['fieldKeys'])) {
855 Civi
::$statics[__CLASS__
]['fieldKeys'] = array_flip(CRM_Utils_Array
::collect('name', self
::fields()));
857 return Civi
::$statics[__CLASS__
]['fieldKeys'];
861 * Returns the names of this table
865 public static function getTableName() {
866 return self
::$_tableName;
870 * Returns if this table needs to be logged
874 public function getLog() {
879 * Returns the list of fields that can be imported
881 * @param bool $prefix
885 public static function &import($prefix = FALSE) {
886 $r = CRM_Core_DAO_AllCoreTables
::getImports(__CLASS__
, 'contribution', $prefix, []);
891 * Returns the list of fields that can be exported
893 * @param bool $prefix
897 public static function &export($prefix = FALSE) {
898 $r = CRM_Core_DAO_AllCoreTables
::getExports(__CLASS__
, 'contribution', $prefix, []);
903 * Returns the list of indices
905 * @param bool $localize
909 public static function indices($localize = TRUE) {
911 'UI_contrib_payment_instrument_id' => [
912 'name' => 'UI_contrib_payment_instrument_id',
914 0 => 'payment_instrument_id',
916 'localizable' => FALSE,
917 'sig' => 'civicrm_contribution::0::payment_instrument_id',
919 'index_total_amount_receive_date' => [
920 'name' => 'index_total_amount_receive_date',
925 'localizable' => FALSE,
926 'sig' => 'civicrm_contribution::0::total_amount::receive_date',
929 'name' => 'index_source',
933 'localizable' => FALSE,
934 'sig' => 'civicrm_contribution::0::source',
936 'UI_contrib_trxn_id' => [
937 'name' => 'UI_contrib_trxn_id',
941 'localizable' => FALSE,
943 'sig' => 'civicrm_contribution::1::trxn_id',
945 'UI_contrib_invoice_id' => [
946 'name' => 'UI_contrib_invoice_id',
950 'localizable' => FALSE,
952 'sig' => 'civicrm_contribution::1::invoice_id',
954 'index_contribution_status' => [
955 'name' => 'index_contribution_status',
957 0 => 'contribution_status_id',
959 'localizable' => FALSE,
960 'sig' => 'civicrm_contribution::0::contribution_status_id',
963 'name' => 'received_date',
967 'localizable' => FALSE,
968 'sig' => 'civicrm_contribution::0::receive_date',
971 'name' => 'check_number',
975 'localizable' => FALSE,
976 'sig' => 'civicrm_contribution::0::check_number',
978 'index_creditnote_id' => [
979 'name' => 'index_creditnote_id',
981 0 => 'creditnote_id',
983 'localizable' => FALSE,
984 'sig' => 'civicrm_contribution::0::creditnote_id',
987 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables
::multilingualize(__CLASS__
, $indices) : $indices;