<<

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

credit_number

  data_type: 'varchar'
  is_nullable: 1
  size: 20

autogenerated number for credits

status

  data_type: 'varchar'
  is_nullable: 1
  size: 16

payment_type

  data_type: 'varchar'
  is_nullable: 1
  size: 80

optional authorised value PAYMENT_TYPE

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

the branchcode of the library where a payment was made, a manual invoice created, etc.

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

article_requests

Type: has_many

Related object: Koha::Schema::Result::ArticleRequest

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

patron

Type: belongs_to

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

library

Type: belongs_to

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

<<