2 package Koha::Schema::Result::Accountline;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Accountline
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<accountlines>
22 __PACKAGE__->table("accountlines");
26 =head2 accountlines_id
52 datetime_undef_if_invalid: 1
91 =head2 amountoutstanding
99 data_type: 'timestamp'
100 datetime_undef_if_invalid: 1
101 default_value: current_timestamp
106 data_type: 'mediumtext'
136 __PACKAGE__->add_columns(
138 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
140 { data_type => "integer", is_nullable => 1 },
142 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
144 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
146 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
148 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
150 { data_type => "longtext", is_nullable => 1 },
152 { data_type => "varchar", is_nullable => 1, size => 80 },
154 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 16 },
156 { data_type => "varchar", is_nullable => 1, size => 16 },
158 { data_type => "varchar", is_nullable => 1, size => 80 },
160 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
163 data_type => "timestamp",
164 datetime_undef_if_invalid => 1,
165 default_value => \"current_timestamp",
169 { data_type => "mediumtext", is_nullable => 1 },
171 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
173 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
175 { data_type => "varchar", is_nullable => 0, size => 16 },
177 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
184 =item * L</accountlines_id>
190 __PACKAGE__->set_primary_key("accountlines_id");
194 =head2 account_offsets_credits
198 Related object: L<Koha::Schema::Result::AccountOffset>
202 __PACKAGE__->has_many(
203 "account_offsets_credits",
204 "Koha::Schema::Result::AccountOffset",
205 { "foreign.credit_id" => "self.accountlines_id" },
206 { cascade_copy => 0, cascade_delete => 0 },
209 =head2 account_offsets_debits
213 Related object: L<Koha::Schema::Result::AccountOffset>
217 __PACKAGE__->has_many(
218 "account_offsets_debits",
219 "Koha::Schema::Result::AccountOffset",
220 { "foreign.debit_id" => "self.accountlines_id" },
221 { cascade_copy => 0, cascade_delete => 0 },
224 =head2 borrowernumber
228 Related object: L<Koha::Schema::Result::Borrower>
232 __PACKAGE__->belongs_to(
234 "Koha::Schema::Result::Borrower",
235 { borrowernumber => "borrowernumber" },
239 on_delete => "SET NULL",
240 on_update => "CASCADE",
248 Related object: L<Koha::Schema::Result::Branch>
252 __PACKAGE__->belongs_to(
254 "Koha::Schema::Result::Branch",
255 { branchcode => "branchcode" },
259 on_delete => "SET NULL",
260 on_update => "CASCADE",
268 Related object: L<Koha::Schema::Result::AccountDebitType>
272 __PACKAGE__->belongs_to(
274 "Koha::Schema::Result::AccountDebitType",
275 { code => "debit_type" },
279 on_delete => "SET NULL",
280 on_update => "CASCADE",
288 Related object: L<Koha::Schema::Result::Item>
292 __PACKAGE__->belongs_to(
294 "Koha::Schema::Result::Item",
295 { itemnumber => "itemnumber" },
299 on_delete => "SET NULL",
300 on_update => "CASCADE",
308 Related object: L<Koha::Schema::Result::Borrower>
312 __PACKAGE__->belongs_to(
314 "Koha::Schema::Result::Borrower",
315 { borrowernumber => "manager_id" },
319 on_delete => "SET NULL",
320 on_update => "CASCADE",
328 Related object: L<Koha::Schema::Result::CashRegister>
332 __PACKAGE__->belongs_to(
334 "Koha::Schema::Result::CashRegister",
335 { id => "register_id" },
339 on_delete => "SET NULL",
340 on_update => "CASCADE",
345 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-11 10:47:58
346 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RKg4gDSu0WwJ1C9YmDv3pw
348 sub koha_objects_class {
349 'Koha::Account::Lines';
351 sub koha_object_class {
352 'Koha::Account::Line';