2 package Koha::Schema::Result::Aqorder;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Aqorder
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<aqorders>
22 __PACKAGE__->table("aqorders");
41 datetime_undef_if_invalid: 1
65 datetime_undef_if_invalid: 1
86 =head2 unitprice_tax_excluded
92 =head2 unitprice_tax_included
98 =head2 quantityreceived
100 data_type: 'smallint'
110 =head2 datecancellationprinted
113 datetime_undef_if_invalid: 1
116 =head2 cancellationreason
118 data_type: 'mediumtext'
121 =head2 order_internalnote
123 data_type: 'longtext'
126 =head2 order_vendornote
128 data_type: 'longtext'
131 =head2 purchaseordernumber
133 data_type: 'longtext'
144 data_type: 'timestamp'
145 datetime_undef_if_invalid: 1
146 default_value: current_timestamp
155 =head2 rrp_tax_excluded
161 =head2 rrp_tax_included
173 =head2 ecost_tax_excluded
179 =head2 ecost_tax_included
191 =head2 tax_rate_on_ordering
197 =head2 tax_rate_on_receiving
209 =head2 tax_value_on_ordering
215 =head2 tax_value_on_receiving
236 datetime_undef_if_invalid: 1
263 =head2 uncertainprice
277 datetime_undef_if_invalid: 1
280 =head2 subscriptionid
286 =head2 parent_ordernumber
304 =head2 suppliers_reference_number
310 =head2 suppliers_reference_qualifier
316 =head2 suppliers_report
318 data_type: 'mediumtext'
323 __PACKAGE__->add_columns(
325 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
327 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
329 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
331 { data_type => "smallint", is_nullable => 1 },
333 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
335 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
337 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
339 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
341 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
343 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
344 "unitprice_tax_excluded",
345 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
346 "unitprice_tax_included",
347 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
349 { data_type => "smallint", default_value => 0, is_nullable => 0 },
351 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
352 "datecancellationprinted",
353 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
354 "cancellationreason",
355 { data_type => "mediumtext", is_nullable => 1 },
356 "order_internalnote",
357 { data_type => "longtext", is_nullable => 1 },
359 { data_type => "longtext", is_nullable => 1 },
360 "purchaseordernumber",
361 { data_type => "longtext", is_nullable => 1 },
363 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
366 data_type => "timestamp",
367 datetime_undef_if_invalid => 1,
368 default_value => \"current_timestamp",
372 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
374 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
376 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
378 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
379 "ecost_tax_excluded",
380 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
381 "ecost_tax_included",
382 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
384 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
385 "tax_rate_on_ordering",
386 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
387 "tax_rate_on_receiving",
388 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
390 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
391 "tax_value_on_ordering",
392 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
393 "tax_value_on_receiving",
394 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
396 { data_type => "float", is_nullable => 1, size => [6, 4] },
398 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
400 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
402 { data_type => "varchar", is_nullable => 1, size => 80 },
404 { data_type => "varchar", is_nullable => 1, size => 80 },
406 { data_type => "varchar", is_nullable => 1, size => 10 },
408 { data_type => "varchar", is_nullable => 1, size => 10 },
410 { data_type => "tinyint", is_nullable => 1 },
412 { data_type => "integer", default_value => 0, is_nullable => 1 },
414 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
416 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
417 "parent_ordernumber",
418 { data_type => "integer", is_nullable => 1 },
421 data_type => "varchar",
422 default_value => "new",
427 { data_type => "varchar", is_nullable => 1, size => 35 },
428 "suppliers_reference_number",
429 { data_type => "varchar", is_nullable => 1, size => 35 },
430 "suppliers_reference_qualifier",
431 { data_type => "varchar", is_nullable => 1, size => 3 },
433 { data_type => "mediumtext", is_nullable => 1 },
440 =item * L</ordernumber>
446 __PACKAGE__->set_primary_key("ordernumber");
454 Related object: L<Koha::Schema::Result::AqorderUser>
458 __PACKAGE__->has_many(
460 "Koha::Schema::Result::AqorderUser",
461 { "foreign.ordernumber" => "self.ordernumber" },
462 { cascade_copy => 0, cascade_delete => 0 },
465 =head2 aqorders_items
469 Related object: L<Koha::Schema::Result::AqordersItem>
473 __PACKAGE__->has_many(
475 "Koha::Schema::Result::AqordersItem",
476 { "foreign.ordernumber" => "self.ordernumber" },
477 { cascade_copy => 0, cascade_delete => 0 },
480 =head2 aqorders_transfers_ordernumber_from
484 Related object: L<Koha::Schema::Result::AqordersTransfer>
488 __PACKAGE__->might_have(
489 "aqorders_transfers_ordernumber_from",
490 "Koha::Schema::Result::AqordersTransfer",
491 { "foreign.ordernumber_from" => "self.ordernumber" },
492 { cascade_copy => 0, cascade_delete => 0 },
495 =head2 aqorders_transfers_ordernumber_to
499 Related object: L<Koha::Schema::Result::AqordersTransfer>
503 __PACKAGE__->might_have(
504 "aqorders_transfers_ordernumber_to",
505 "Koha::Schema::Result::AqordersTransfer",
506 { "foreign.ordernumber_to" => "self.ordernumber" },
507 { cascade_copy => 0, cascade_delete => 0 },
514 Related object: L<Koha::Schema::Result::Aqbasket>
518 __PACKAGE__->belongs_to(
520 "Koha::Schema::Result::Aqbasket",
521 { basketno => "basketno" },
525 on_delete => "CASCADE",
526 on_update => "CASCADE",
534 Related object: L<Koha::Schema::Result::Biblio>
538 __PACKAGE__->belongs_to(
540 "Koha::Schema::Result::Biblio",
541 { biblionumber => "biblionumber" },
545 on_delete => "SET NULL",
546 on_update => "CASCADE",
554 Related object: L<Koha::Schema::Result::Aqbudget>
558 __PACKAGE__->belongs_to(
560 "Koha::Schema::Result::Aqbudget",
561 { budget_id => "budget_id" },
562 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
569 Related object: L<Koha::Schema::Result::Borrower>
573 __PACKAGE__->belongs_to(
575 "Koha::Schema::Result::Borrower",
576 { borrowernumber => "created_by" },
580 on_delete => "SET NULL",
581 on_update => "CASCADE",
589 Related object: L<Koha::Schema::Result::Currency>
593 __PACKAGE__->belongs_to(
595 "Koha::Schema::Result::Currency",
596 { currency => "currency" },
600 on_delete => "SET NULL",
601 on_update => "SET NULL",
609 Related object: L<Koha::Schema::Result::Aqinvoice>
613 __PACKAGE__->belongs_to(
615 "Koha::Schema::Result::Aqinvoice",
616 { invoiceid => "invoiceid" },
620 on_delete => "SET NULL",
621 on_update => "CASCADE",
625 =head2 subscriptionid
629 Related object: L<Koha::Schema::Result::Subscription>
633 __PACKAGE__->belongs_to(
635 "Koha::Schema::Result::Subscription",
636 { subscriptionid => "subscriptionid" },
640 on_delete => "CASCADE",
641 on_update => "CASCADE",
645 =head2 borrowernumbers
649 Composing rels: L</aqorder_users> -> borrowernumber
653 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
656 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-06 14:12:40
657 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/CljC8eGYHoYM3506qYavg
660 # You can replace this text with custom code or comments, and it will be preserved on regeneration