<<

NAME

Koha::Schema::Result::Aqorder

TABLE: aqorders

ACCESSORS

ordernumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

entrydate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

quantity

  data_type: 'smallint'
  is_nullable: 1

currency

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

listprice

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

datereceived

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

invoiceid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

freight

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

unitprice

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

unitprice_tax_excluded

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

unitprice_tax_included

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

quantityreceived

  data_type: 'smallint'
  default_value: 0
  is_nullable: 0

created_by

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

datecancellationprinted

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

cancellationreason

  data_type: 'mediumtext'
  is_nullable: 1

order_internalnote

  data_type: 'longtext'
  is_nullable: 1

order_vendornote

  data_type: 'longtext'
  is_nullable: 1

purchaseordernumber

  data_type: 'longtext'
  is_nullable: 1

basketno

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

timestamp

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

rrp

  data_type: 'decimal'
  is_nullable: 1
  size: [13,2]

replacementprice

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

rrp_tax_excluded

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

rrp_tax_included

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

ecost

  data_type: 'decimal'
  is_nullable: 1
  size: [13,2]

ecost_tax_excluded

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

ecost_tax_included

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

tax_rate_bak

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

tax_rate_on_ordering

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

tax_rate_on_receiving

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

tax_value_bak

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

tax_value_on_ordering

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

tax_value_on_receiving

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

discount

  data_type: 'float'
  is_nullable: 1
  size: [6,4]

budget_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

budgetdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

sort1

  data_type: 'varchar'
  is_nullable: 1
  size: 80

sort2

  data_type: 'varchar'
  is_nullable: 1
  size: 80

sort1_authcat

  data_type: 'varchar'
  is_nullable: 1
  size: 10

sort2_authcat

  data_type: 'varchar'
  is_nullable: 1
  size: 10

uncertainprice

  data_type: 'tinyint'
  is_nullable: 1

subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

parent_ordernumber

  data_type: 'integer'
  is_nullable: 1

orderstatus

  data_type: 'varchar'
  default_value: 'new'
  is_nullable: 1
  size: 16

line_item_id

  data_type: 'varchar'
  is_nullable: 1
  size: 35

suppliers_reference_number

  data_type: 'varchar'
  is_nullable: 1
  size: 35

suppliers_reference_qualifier

  data_type: 'varchar'
  is_nullable: 1
  size: 3

suppliers_report

  data_type: 'mediumtext'
  is_nullable: 1

PRIMARY KEY

• "ordernumber"

RELATIONS

aqorder_users

Type: has_many

Related object: Koha::Schema::Result::AqorderUser

aqorders_claims

Type: has_many

Related object: Koha::Schema::Result::AqordersClaim

aqorders_items

Type: has_many

Related object: Koha::Schema::Result::AqordersItem

aqorders_transfers_ordernumber_from

Type: might_have

Related object: Koha::Schema::Result::AqordersTransfer

aqorders_transfers_ordernumber_to

Type: might_have

Related object: Koha::Schema::Result::AqordersTransfer

basketno

Type: belongs_to

Related object: Koha::Schema::Result::Aqbasket

biblionumber

Type: belongs_to

Related object: Koha::Schema::Result::Biblio

budget

Type: belongs_to

Related object: Koha::Schema::Result::Aqbudget

created_by

Type: belongs_to

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

currency

Type: belongs_to

Related object: Koha::Schema::Result::Currency

invoiceid

Type: belongs_to

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

subscriptionid

Type: belongs_to

Related object: Koha::Schema::Result::Subscription

borrowernumbers

Type: many_to_many

Composing rels: "aqorder_users" -> borrowernumber

<<