Koha::Schema::Result::Aqbudget
aqbudgets
data_type: 'integer' is_auto_increment: 1 is_nullable: 0
primary key and unique number assigned to each fund by Koha
data_type: 'integer' is_nullable: 1
if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
data_type: 'varchar' is_nullable: 1 size: 30
code assigned to the fund by the user
data_type: 'varchar' is_nullable: 1 size: 80
name assigned to the fund by the user
data_type: 'varchar' is_nullable: 1 size: 10
branch that this fund belongs to (branches.branchcode)
data_type: 'decimal' default_value: 0.000000 is_nullable: 1 size: [28,6]
total amount for this fund
data_type: 'decimal' default_value: 0.000000 is_nullable: 1 size: [28,6]
budget warning at percentage
data_type: 'decimal' default_value: 0.000000 is_nullable: 1 size: [28,6]
budget warning at amount
data_type: 'longtext' is_nullable: 1
notes related to this fund
data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0
date and time this fund was last touched (created or modified)
data_type: 'integer' is_foreign_key: 1 is_nullable: 0
id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)
data_type: 'varchar' is_nullable: 1 size: 80
statistical category for this fund
data_type: 'varchar' is_nullable: 1 size: 80
second statistical category for this fund
data_type: 'integer' is_nullable: 1
borrowernumber of the person who owns this fund (borrowers.borrowernumber)
data_type: 'integer' default_value: 0 is_nullable: 1
level of permission for this fund (used only by the owner, only by the library, or anyone)
Type: has_many
Related object: Koha::Schema::Result::Aqbudgetborrower
Type: has_many
Related object: Koha::Schema::Result::AqbudgetsPlanning
Type: has_many
Related object: Koha::Schema::Result::AqinvoiceAdjustment
Type: has_many
Related object: Koha::Schema::Result::Aqinvoice
Type: has_many
Related object: Koha::Schema::Result::Aqorder
Type: belongs_to
Related object: Koha::Schema::Result::Aqbudgetperiod
Type: has_many
Related object: Koha::Schema::Result::MarcOrderAccount
Type: has_many
Related object: Koha::Schema::Result::Suggestion
Type: has_many
Related object: Koha::Schema::Result::VendorEdiAccount
Type: many_to_many
Composing rels: "aqbudgetborrowers" -> borrowernumber