<<

NAME

Koha::Schema::Result::Aqorder

TABLE: aqorders

ACCESSORS

ordernumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key and unique identifier assigned by Koha to each line

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

links the order to the biblio being ordered (biblio.biblionumber)

deleted_biblionumber

  data_type: 'integer'
  is_nullable: 1

links the order to the deleted bibliographic record (deletedbiblio.biblionumber)

entrydate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the bib was added to the basket

quantity

  data_type: 'smallint'
  is_nullable: 1

the quantity ordered

currency

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

the currency used for the purchase

listprice

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

the vendor price for this line item

datereceived

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date this order was received

invoiceid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of invoice

freight

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

shipping costs (not used)

unitprice

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

the actual cost entered when receiving this line item

unitprice_tax_excluded

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

the unit price excluding tax (on receiving)

unitprice_tax_included

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

the unit price including tax (on receiving)

quantityreceived

  data_type: 'smallint'
  default_value: 0
  is_nullable: 0

the quantity that have been received so far

created_by

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

the borrowernumber of order line's creator

datecancellationprinted

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the line item was deleted

cancellationreason

  data_type: 'mediumtext'
  is_nullable: 1

reason of cancellation

order_internalnote

  data_type: 'longtext'
  is_nullable: 1

notes related to this order line, made for staff

order_vendornote

  data_type: 'longtext'
  is_nullable: 1

notes related to this order line, made for vendor

basketno

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

links this order line to a specific basket (aqbasket.basketno)

timestamp

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

the date and time this order line was last modified

rrp

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

the retail cost for this line item

replacementprice

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

the replacement cost for this line item

rrp_tax_excluded

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

the replacement cost excluding tax

rrp_tax_included

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

the replacement cost including tax

ecost

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

the replacement cost for this line item

ecost_tax_excluded

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

the estimated cost excluding tax

ecost_tax_included

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

the estimated cost including tax

tax_rate_bak

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

the tax rate for this line item (%)

tax_rate_on_ordering

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

the tax rate on ordering for this line item (%)

tax_rate_on_receiving

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

the tax rate on receiving for this line item (%)

tax_value_bak

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

the tax value for this line item

tax_value_on_ordering

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

the tax value on ordering for this line item

tax_value_on_receiving

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

the tax value on receiving for this line item

discount

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

the discount for this line item (%)

budget_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

the fund this order goes against (aqbudgets.budget_id)

budgetdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

not used? always NULL

sort1

  data_type: 'varchar'
  is_nullable: 1
  size: 80

statistical field

sort2

  data_type: 'varchar'
  is_nullable: 1
  size: 80

second statistical field

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

was this price uncertain (1 for yes, 0 for no)

subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

links this order line to a subscription (subscription.subscriptionid)

parent_ordernumber

  data_type: 'integer'
  is_nullable: 1

ordernumber of parent order line, or same as ordernumber if no parent

orderstatus

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

the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled'

line_item_id

  data_type: 'varchar'
  is_nullable: 1
  size: 35

Supplier's article id for Edifact orderline

suppliers_reference_number

  data_type: 'varchar'
  is_nullable: 1
  size: 35

Suppliers unique edifact quote ref

suppliers_reference_qualifier

  data_type: 'varchar'
  is_nullable: 1
  size: 3

Type of number above usually 'QLI'

suppliers_report

  data_type: 'mediumtext'
  is_nullable: 1

reports received from suppliers

estimated_delivery_date

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

Estimated delivery date

invoice_unitprice

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

the unit price in foreign currency

invoice_currency

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

the currency of the invoice_unitprice

PRIMARY KEY

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

invoice_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

creator

Type: belongs_to

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

<<