Lines 414-419
reports received from suppliers
Link Here
|
414 |
|
414 |
|
415 |
Estimated delivery date |
415 |
Estimated delivery date |
416 |
|
416 |
|
|
|
417 |
=head2 invoice_unitprice |
418 |
|
419 |
data_type: 'decimal' |
420 |
is_nullable: 1 |
421 |
size: [28,6] |
422 |
|
423 |
the unit price in foreign currency |
424 |
|
425 |
=head2 invoice_currency |
426 |
|
427 |
data_type: 'varchar' |
428 |
is_foreign_key: 1 |
429 |
is_nullable: 1 |
430 |
size: 10 |
431 |
|
432 |
the currency of the invoice_unitprice |
433 |
|
417 |
=cut |
434 |
=cut |
418 |
|
435 |
|
419 |
__PACKAGE__->add_columns( |
436 |
__PACKAGE__->add_columns( |
Lines 527-532
__PACKAGE__->add_columns(
Link Here
|
527 |
{ data_type => "mediumtext", is_nullable => 1 }, |
544 |
{ data_type => "mediumtext", is_nullable => 1 }, |
528 |
"estimated_delivery_date", |
545 |
"estimated_delivery_date", |
529 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
546 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
|
|
547 |
"invoice_unitprice", |
548 |
{ data_type => "decimal", is_nullable => 1, size => [28, 6] }, |
549 |
"invoice_currency", |
550 |
{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, |
530 |
); |
551 |
); |
531 |
|
552 |
|
532 |
=head1 PRIMARY KEY |
553 |
=head1 PRIMARY KEY |
Lines 713-718
__PACKAGE__->belongs_to(
Link Here
|
713 |
}, |
734 |
}, |
714 |
); |
735 |
); |
715 |
|
736 |
|
|
|
737 |
=head2 invoice_currency |
738 |
|
739 |
Type: belongs_to |
740 |
|
741 |
Related object: L<Koha::Schema::Result::Currency> |
742 |
|
743 |
=cut |
744 |
|
745 |
__PACKAGE__->belongs_to( |
746 |
"invoice_currency", |
747 |
"Koha::Schema::Result::Currency", |
748 |
{ currency => "invoice_currency" }, |
749 |
{ |
750 |
is_deferrable => 1, |
751 |
join_type => "LEFT", |
752 |
on_delete => "SET NULL", |
753 |
on_update => "SET NULL", |
754 |
}, |
755 |
); |
756 |
|
716 |
=head2 invoiceid |
757 |
=head2 invoiceid |
717 |
|
758 |
|
718 |
Type: belongs_to |
759 |
Type: belongs_to |
Lines 764-771
Composing rels: L</aqorder_users> -> borrowernumber
Link Here
|
764 |
__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); |
805 |
__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); |
765 |
|
806 |
|
766 |
|
807 |
|
767 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-09-16 13:56:20 |
808 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-01-16 20:27:53 |
768 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M8HvWBKYFNGspSTakU6Qdg |
809 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j+1KthANw+mepqimVi57Ug |
769 |
|
810 |
|
770 |
__PACKAGE__->belongs_to( |
811 |
__PACKAGE__->belongs_to( |
771 |
"basket", |
812 |
"basket", |