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'
104 =head2 datecancellationprinted
107 datetime_undef_if_invalid: 1
110 =head2 cancellationreason
115 =head2 order_internalnote
117 data_type: 'mediumtext'
120 =head2 order_vendornote
122 data_type: 'mediumtext'
125 =head2 purchaseordernumber
127 data_type: 'mediumtext'
138 data_type: 'timestamp'
139 datetime_undef_if_invalid: 1
140 default_value: current_timestamp
149 =head2 rrp_tax_excluded
155 =head2 rrp_tax_included
167 =head2 ecost_tax_excluded
173 =head2 ecost_tax_included
206 datetime_undef_if_invalid: 1
233 =head2 uncertainprice
247 datetime_undef_if_invalid: 1
250 =head2 subscriptionid
256 =head2 parent_ordernumber
274 =head2 suppliers_reference_number
280 =head2 suppliers_reference_qualifier
286 =head2 suppliers_report
293 __PACKAGE__->add_columns(
295 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
297 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
299 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
301 { data_type => "smallint", is_nullable => 1 },
303 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
305 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
307 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
309 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
311 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
313 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
314 "unitprice_tax_excluded",
315 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
316 "unitprice_tax_included",
317 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
319 { data_type => "smallint", default_value => 0, is_nullable => 0 },
320 "datecancellationprinted",
321 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
322 "cancellationreason",
323 { data_type => "text", is_nullable => 1 },
324 "order_internalnote",
325 { data_type => "mediumtext", is_nullable => 1 },
327 { data_type => "mediumtext", is_nullable => 1 },
328 "purchaseordernumber",
329 { data_type => "mediumtext", is_nullable => 1 },
331 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
334 data_type => "timestamp",
335 datetime_undef_if_invalid => 1,
336 default_value => \"current_timestamp",
340 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
342 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
344 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
346 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
347 "ecost_tax_excluded",
348 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
349 "ecost_tax_included",
350 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
352 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
354 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
356 { data_type => "float", is_nullable => 1, size => [6, 4] },
358 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
360 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
362 { data_type => "varchar", is_nullable => 1, size => 80 },
364 { data_type => "varchar", is_nullable => 1, size => 80 },
366 { data_type => "varchar", is_nullable => 1, size => 10 },
368 { data_type => "varchar", is_nullable => 1, size => 10 },
370 { data_type => "tinyint", is_nullable => 1 },
372 { data_type => "integer", default_value => 0, is_nullable => 1 },
374 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
376 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
377 "parent_ordernumber",
378 { data_type => "integer", is_nullable => 1 },
381 data_type => "varchar",
382 default_value => "new",
387 { data_type => "varchar", is_nullable => 1, size => 35 },
388 "suppliers_reference_number",
389 { data_type => "varchar", is_nullable => 1, size => 35 },
390 "suppliers_reference_qualifier",
391 { data_type => "varchar", is_nullable => 1, size => 3 },
393 { data_type => "text", is_nullable => 1 },
400 =item * L</ordernumber>
406 __PACKAGE__->set_primary_key("ordernumber");
414 Related object: L<Koha::Schema::Result::AqorderUser>
418 __PACKAGE__->has_many(
420 "Koha::Schema::Result::AqorderUser",
421 { "foreign.ordernumber" => "self.ordernumber" },
422 { cascade_copy => 0, cascade_delete => 0 },
425 =head2 aqorders_items
429 Related object: L<Koha::Schema::Result::AqordersItem>
433 __PACKAGE__->has_many(
435 "Koha::Schema::Result::AqordersItem",
436 { "foreign.ordernumber" => "self.ordernumber" },
437 { cascade_copy => 0, cascade_delete => 0 },
440 =head2 aqorders_transfers_ordernumber_from
444 Related object: L<Koha::Schema::Result::AqordersTransfer>
448 __PACKAGE__->might_have(
449 "aqorders_transfers_ordernumber_from",
450 "Koha::Schema::Result::AqordersTransfer",
451 { "foreign.ordernumber_from" => "self.ordernumber" },
452 { cascade_copy => 0, cascade_delete => 0 },
455 =head2 aqorders_transfers_ordernumber_to
459 Related object: L<Koha::Schema::Result::AqordersTransfer>
463 __PACKAGE__->might_have(
464 "aqorders_transfers_ordernumber_to",
465 "Koha::Schema::Result::AqordersTransfer",
466 { "foreign.ordernumber_to" => "self.ordernumber" },
467 { cascade_copy => 0, cascade_delete => 0 },
474 Related object: L<Koha::Schema::Result::Aqbasket>
478 __PACKAGE__->belongs_to(
480 "Koha::Schema::Result::Aqbasket",
481 { basketno => "basketno" },
485 on_delete => "CASCADE",
486 on_update => "CASCADE",
494 Related object: L<Koha::Schema::Result::Biblio>
498 __PACKAGE__->belongs_to(
500 "Koha::Schema::Result::Biblio",
501 { biblionumber => "biblionumber" },
505 on_delete => "SET NULL",
506 on_update => "CASCADE",
514 Related object: L<Koha::Schema::Result::Aqbudget>
518 __PACKAGE__->belongs_to(
520 "Koha::Schema::Result::Aqbudget",
521 { budget_id => "budget_id" },
522 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
529 Related object: L<Koha::Schema::Result::Currency>
533 __PACKAGE__->belongs_to(
535 "Koha::Schema::Result::Currency",
536 { currency => "currency" },
540 on_delete => "SET NULL",
541 on_update => "SET NULL",
549 Related object: L<Koha::Schema::Result::Aqinvoice>
553 __PACKAGE__->belongs_to(
555 "Koha::Schema::Result::Aqinvoice",
556 { invoiceid => "invoiceid" },
560 on_delete => "SET NULL",
561 on_update => "CASCADE",
565 =head2 subscriptionid
569 Related object: L<Koha::Schema::Result::Subscription>
573 __PACKAGE__->belongs_to(
575 "Koha::Schema::Result::Subscription",
576 { subscriptionid => "subscriptionid" },
580 on_delete => "CASCADE",
581 on_update => "CASCADE",
585 =head2 borrowernumbers
589 Composing rels: L</aqorder_users> -> borrowernumber
593 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
596 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-09 13:43:30
597 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R2a+DkXI1AaEVnpb1YKu5Q
600 # You can replace this text with custom code or comments, and it will be preserved on regeneration