civicrm_batch_en_US

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 0

Unique Address ID

name VARCHAR 64 null

Variable name/programmatic handle for this batch.

created_id INT UNSIGNED 10 null

FK to Contact ID

created_date DATETIME 19 null

When was this item created

modified_id INT UNSIGNED 10 null

FK to Contact ID

modified_date DATETIME 19 null

When was this item created

saved_search_id INT UNSIGNED 10 null

FK to Saved Search ID

status_id INT UNSIGNED 10 null

fk to Batch Status options in civicrm_option_values

type_id INT UNSIGNED 10 null

fk to Batch Type options in civicrm_option_values

mode_id INT UNSIGNED 10 null

fk to Batch mode options in civicrm_option_values

total DECIMAL 20,2 null

Total amount for this batch.

item_count INT UNSIGNED 10 null

Number of items in a batch.

payment_instrument_id INT UNSIGNED 10 null

fk to Payment Instrument options in civicrm_option_values

exported_date DATETIME 19 null
data LONGTEXT 2147483647 null

cache entered data

title VARCHAR 255 null
description TEXT 65535 null

View Definition


Possibly Referenced Tables/Views