<<

NAME

Koha::Schema::Result::Aqinvoice

TABLE: aqinvoices

ACCESSORS

invoiceid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

ID of the invoice, primary key

invoicenumber

  data_type: 'longtext'
  is_nullable: 0

Name of invoice

booksellerid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

foreign key to aqbooksellers

shipmentdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date of shipment

billingdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date of billing

closedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

invoice close date, NULL means the invoice is open

shipmentcost

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

shipment cost

shipmentcost_budgetid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key to aqbudgets, link the shipment cost to a budget

message_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

foreign key to edifact invoice message

PRIMARY KEY

RELATIONS

aqinvoice_adjustments

Type: has_many

Related object: Koha::Schema::Result::AqinvoiceAdjustment

aqorders

Type: has_many

Related object: Koha::Schema::Result::Aqorder

booksellerid

Type: belongs_to

Related object: Koha::Schema::Result::Aqbookseller

message

Type: belongs_to

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

shipmentcost_budgetid

Type: belongs_to

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

<<