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
84 =head2 amountoutstanding
92 data_type: 'timestamp'
93 datetime_undef_if_invalid: 1
94 default_value: current_timestamp
99 data_type: 'mediumtext'
129 __PACKAGE__->add_columns(
131 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
133 { data_type => "integer", is_nullable => 1 },
135 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
137 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
139 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
141 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
143 { data_type => "longtext", is_nullable => 1 },
145 { data_type => "varchar", is_nullable => 1, size => 80 },
147 { data_type => "varchar", is_nullable => 1, size => 16 },
149 { data_type => "varchar", is_nullable => 1, size => 80 },
151 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
154 data_type => "timestamp",
155 datetime_undef_if_invalid => 1,
156 default_value => \"current_timestamp",
160 { data_type => "mediumtext", is_nullable => 1 },
162 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
164 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
166 { data_type => "varchar", is_nullable => 0, size => 16 },
168 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
175 =item * L</accountlines_id>
181 __PACKAGE__->set_primary_key("accountlines_id");
185 =head2 account_offsets_credits
189 Related object: L<Koha::Schema::Result::AccountOffset>
193 __PACKAGE__->has_many(
194 "account_offsets_credits",
195 "Koha::Schema::Result::AccountOffset",
196 { "foreign.credit_id" => "self.accountlines_id" },
197 { cascade_copy => 0, cascade_delete => 0 },
200 =head2 account_offsets_debits
204 Related object: L<Koha::Schema::Result::AccountOffset>
208 __PACKAGE__->has_many(
209 "account_offsets_debits",
210 "Koha::Schema::Result::AccountOffset",
211 { "foreign.debit_id" => "self.accountlines_id" },
212 { cascade_copy => 0, cascade_delete => 0 },
215 =head2 borrowernumber
219 Related object: L<Koha::Schema::Result::Borrower>
223 __PACKAGE__->belongs_to(
225 "Koha::Schema::Result::Borrower",
226 { borrowernumber => "borrowernumber" },
230 on_delete => "SET NULL",
231 on_update => "CASCADE",
239 Related object: L<Koha::Schema::Result::Branch>
243 __PACKAGE__->belongs_to(
245 "Koha::Schema::Result::Branch",
246 { branchcode => "branchcode" },
250 on_delete => "SET NULL",
251 on_update => "CASCADE",
259 Related object: L<Koha::Schema::Result::Item>
263 __PACKAGE__->belongs_to(
265 "Koha::Schema::Result::Item",
266 { itemnumber => "itemnumber" },
270 on_delete => "SET NULL",
271 on_update => "CASCADE",
279 Related object: L<Koha::Schema::Result::Borrower>
283 __PACKAGE__->belongs_to(
285 "Koha::Schema::Result::Borrower",
286 { borrowernumber => "manager_id" },
290 on_delete => "SET NULL",
291 on_update => "CASCADE",
299 Related object: L<Koha::Schema::Result::CashRegister>
303 __PACKAGE__->belongs_to(
305 "Koha::Schema::Result::CashRegister",
306 { id => "register_id" },
310 on_delete => "SET NULL",
311 on_update => "CASCADE",
316 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-09-06 12:23:55
317 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/8Qeh530PbLC6ryxC1Dw9w
319 sub koha_objects_class {
320 'Koha::Account::Lines';
322 sub koha_object_class {
323 'Koha::Account::Line';