The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
contribution_status
id
status
What does it mean
1
Completed
2
Pending
3
Cancelled
4
Failed
5
In Progress
6
Overdue
7
Fund-to-fund-transfer
8
Paid
9
Refunded
11
Partially paid
12
Pending refund
13
Chargeback
14
Template
This comes from contribution_status in civicrm_option_group (id=11) and then the values from civicrm_option_value
contribution_recur_status
id
status
What does it mean
1
Completed
2
Pending
new default as of February 2021 and a status is not specified
3
Cancelled
4
Failed
5
In Progress
the state for active recurring charges
14
Processing
what recurring charge moves to during charge
15
Failing
This comes from contribution_recur_status in civicrm_option_group (id=139) and then the values from civicrm_option_value
civicrm_finanical_type
id
name
What does it mean
9
Cash
default for donations
civicrm_payment_processor
id
name
payment_processor_type_id
1
adyen
14
2
amazon
15
3
dlocal
16
4
globalcollect
17
5
ingenico
18
6
paypal
19
7
paypal_ec
20
braintree
21
fundraiseup
22
This isn't all the payment instruments just the ones I was looking for the ids for so far.
payment_instrument
label
value
Check
4
Bank Transfer: PayTM Wallet
236
Bank Transfer: UPI
238
Venmo
274
ACH
277
This comes from contribution_status in civicrm_option_group (id=10) and then the values from civicrm_option_value
