<<

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_nullable: 1
  size: 3

listprice

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

totalamount

  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]

quantityreceived

  data_type: 'smallint'
  default_value: 0
  is_nullable: 0

cancelledby

  data_type: 'varchar'
  is_nullable: 1
  size: 10

datecancellationprinted

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

order_internalnote

  data_type: 'mediumtext'
  is_nullable: 1

order_vendornote

  data_type: 'mediumtext'
  is_nullable: 1

supplierreference

  data_type: 'mediumtext'
  is_nullable: 1

purchaseordernumber

  data_type: 'mediumtext'
  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]

ecost

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

gstrate

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

discount

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

budget_id

  data_type: 'integer'
  is_nullable: 0

budgetgroup_id

  data_type: 'integer'
  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

claims_count

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

claimed_date

  data_type: 'date'
  datetime_undef_if_invalid: 1
  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

PRIMARY KEY

RELATIONS

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

invoiceid

Type: belongs_to

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

subscriptionid

Type: belongs_to

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

<<