<<

NAME

Koha::Schema::Result::Aqbookseller

TABLE: aqbooksellers

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key and unique identifier assigned by Koha

name

  data_type: 'longtext'
  is_nullable: 0

vendor name

address1

  data_type: 'longtext'
  is_nullable: 1

first line of vendor physical address

address2

  data_type: 'longtext'
  is_nullable: 1

second line of vendor physical address

address3

  data_type: 'longtext'
  is_nullable: 1

third line of vendor physical address

address4

  data_type: 'longtext'
  is_nullable: 1

fourth line of vendor physical address

phone

  data_type: 'varchar'
  is_nullable: 1
  size: 30

vendor phone number

accountnumber

  data_type: 'longtext'
  is_nullable: 1

vendor account number

type

  data_type: 'varchar'
  is_nullable: 1
  size: 255

notes

  data_type: 'longtext'
  is_nullable: 1

order notes

postal

  data_type: 'longtext'
  is_nullable: 1

vendor postal address (all lines)

url

  data_type: 'varchar'
  is_nullable: 1
  size: 255

vendor web address

active

  data_type: 'tinyint'
  is_nullable: 1

is this vendor active (1 for yes, 0 for no)

listprice

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

currency code for list prices

invoiceprice

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

currency code for invoice prices

gstreg

  data_type: 'tinyint'
  is_nullable: 1

is your library charged tax (1 for yes, 0 for no)

listincgst

  data_type: 'tinyint'
  is_nullable: 1

is tax included in list prices (1 for yes, 0 for no)

invoiceincgst

  data_type: 'tinyint'
  is_nullable: 1

is tax included in invoice prices (1 for yes, 0 for no)

tax_rate

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

the tax rate the library is charged

discount

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

discount offered on all items ordered from this vendor

fax

  data_type: 'varchar'
  is_nullable: 1
  size: 50

vendor fax number

deliverytime

  data_type: 'integer'
  is_nullable: 1

vendor delivery time

external_id

  data_type: 'varchar'
  is_nullable: 1
  size: 255

external id of the vendor

PRIMARY KEY

• "id"

RELATIONS

aqbasketgroups

Type: has_many

Related object: Koha::Schema::Result::Aqbasketgroup

aqbaskets

Type: has_many

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

aqbookseller_aliases

Type: has_many

Related object: Koha::Schema::Result::AqbooksellerAlias

aqbookseller_interfaces

Type: has_many

Related object: Koha::Schema::Result::AqbooksellerInterface

aqbookseller_issues

Type: has_many

Related object: Koha::Schema::Result::AqbooksellerIssue

aqcontacts

Type: has_many

Related object: Koha::Schema::Result::Aqcontact

aqcontracts

Type: has_many

Related object: Koha::Schema::Result::Aqcontract

aqinvoices

Type: has_many

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

edifact_messages

Type: has_many

Related object: Koha::Schema::Result::EdifactMessage

erm_agreements

Type: has_many

Related object: Koha::Schema::Result::ErmAgreement

erm_eholdings_packages

Type: has_many

Related object: Koha::Schema::Result::ErmEholdingsPackage

erm_eholdings_resources

Type: has_many

Related object: Koha::Schema::Result::ErmEholdingsResource

erm_licenses

Type: has_many

Related object: Koha::Schema::Result::ErmLicense

invoiceprice

Type: belongs_to

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

listprice

Type: belongs_to

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

vendor_edi_accounts

Type: has_many

Related object: Koha::Schema::Result::VendorEdiAccount

<<