<<

NAME

Koha::Schema::Result::Accountline

TABLE: accountlines

ACCESSORS

accountlines_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

issue_id

  data_type: 'integer'
  is_nullable: 1

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

date

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

amount

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

description

  data_type: 'longtext'
  is_nullable: 1

credit_type_code

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 80

debit_type_code

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 80

status

  data_type: 'varchar'
  is_nullable: 1
  size: 16

payment_type

  data_type: 'varchar'
  is_nullable: 1
  size: 80

amountoutstanding

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

timestamp

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

note

  data_type: 'mediumtext'
  is_nullable: 1

manager_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

register_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

interface

  data_type: 'varchar'
  is_nullable: 0
  size: 16

branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

PRIMARY KEY

• "accountlines_id"

RELATIONS

account_offsets_credits

Type: has_many

Related object: Koha::Schema::Result::AccountOffset

account_offsets_debits

Type: has_many

Related object: Koha::Schema::Result::AccountOffset

borrowernumber

Type: belongs_to

Related object: Koha::Schema::Result::Borrower

branchcode

Type: belongs_to

Related object: Koha::Schema::Result::Branch

credit_type_code

Type: belongs_to

Related object: Koha::Schema::Result::AccountCreditType

debit_type_code

Type: belongs_to

Related object: Koha::Schema::Result::AccountDebitType

itemnumber

Type: belongs_to

Related object: Koha::Schema::Result::Item

manager

Type: belongs_to

Related object: Koha::Schema::Result::Borrower

register

Type: belongs_to

Related object: Koha::Schema::Result::CashRegister

<<