<<

NAME

Koha::Schema::Result::Branchtransfer

TABLE: branchtransfers

ACCESSORS

branchtransfer_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

itemnumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

the itemnumber that it is in transit (items.itemnumber)

daterequested

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

the date the transfer was requested

datesent

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the transfer was initialized

frombranch

  data_type: 'varchar'
  default_value: (empty string)
  is_foreign_key: 1
  is_nullable: 0
  size: 10

the branch the transfer is coming from

datearrived

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the transfer arrived at its destination

datecancelled

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the transfer was cancelled

tobranch

  data_type: 'varchar'
  default_value: (empty string)
  is_foreign_key: 1
  is_nullable: 0
  size: 10

the branch the transfer was going to

comments

  data_type: 'longtext'
  is_nullable: 1

any comments related to the transfer

reason

  data_type: 'enum'
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","TransferCancellation","Recall","RecallCancellation"]}
  is_nullable: 1

what triggered the transfer

cancellation_reason

  data_type: 'enum'
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","ItemLost","WrongTransfer","RecallCancellation"]}
  is_nullable: 1

what triggered the transfer cancellation

PRIMARY KEY

RELATIONS

frombranch

Type: belongs_to

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

itemnumber

Type: belongs_to

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

tobranch

Type: belongs_to

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

<<