<<

NAME

Koha::Schema::Result::Aqbudget

TABLE: aqbudgets

ACCESSORS

budget_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key and unique number assigned to each fund by Koha

budget_parent_id

  data_type: 'integer'
  is_nullable: 1

if this fund is a child of another this will include the parent id (aqbudgets.budget_id)

budget_code

  data_type: 'varchar'
  is_nullable: 1
  size: 30

code assigned to the fund by the user

budget_name

  data_type: 'varchar'
  is_nullable: 1
  size: 80

name assigned to the fund by the user

budget_branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

branch that this fund belongs to (branches.branchcode)

budget_amount

  data_type: 'decimal'
  default_value: 0.000000
  is_nullable: 1
  size: [28,6]

total amount for this fund

budget_encumb

  data_type: 'decimal'
  default_value: 0.000000
  is_nullable: 1
  size: [28,6]

budget warning at percentage

budget_expend

  data_type: 'decimal'
  default_value: 0.000000
  is_nullable: 1
  size: [28,6]

budget warning at amount

budget_notes

  data_type: 'longtext'
  is_nullable: 1

notes related to this fund

timestamp

  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)

budget_period_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)

sort1_authcat

  data_type: 'varchar'
  is_nullable: 1
  size: 80

statistical category for this fund

sort2_authcat

  data_type: 'varchar'
  is_nullable: 1
  size: 80

second statistical category for this fund

budget_owner_id

  data_type: 'integer'
  is_nullable: 1

borrowernumber of the person who owns this fund (borrowers.borrowernumber)

budget_permission

  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)

PRIMARY KEY

• "budget_id"

RELATIONS

aqbudgetborrowers

Type: has_many

Related object: Koha::Schema::Result::Aqbudgetborrower

aqbudgets_plannings

Type: has_many

Related object: Koha::Schema::Result::AqbudgetsPlanning

aqinvoice_adjustments

Type: has_many

Related object: Koha::Schema::Result::AqinvoiceAdjustment

aqinvoices

Type: has_many

Related object: Koha::Schema::Result::Aqinvoice

aqorders

Type: has_many

Related object: Koha::Schema::Result::Aqorder

budget_period

Type: belongs_to

Related object: Koha::Schema::Result::Aqbudgetperiod

suggestions

Type: has_many

Related object: Koha::Schema::Result::Suggestion

vendor_edi_accounts

Type: has_many

Related object: Koha::Schema::Result::VendorEdiAccount

borrowernumbers

Type: many_to_many

Composing rels: "aqbudgetborrowers" -> borrowernumber

<<