Exception: InvoiceLineItemIntegrityError

Inherits:
StandardError
  • Object
show all
Defined in:
app/models/invoice.rb

Overview

Custom exception for invoice line item integrity violations.
Raised when invoice line items don't match expected values, triggering transaction rollback.
== Schema Information

Table name: invoices
Database name: primary

id :integer not null, primary key
billing_emails :string is an Array
completion_date :date
consolidated_exchange_rate :float
currency :string(255)
discount :decimal(8, 2) default(0.0)
discount_code :string(255)
document_date :date
due_date :date
early_payment_discount :integer
early_payment_timescale :integer
exclude_fund_capture_notification :boolean default(FALSE), not null
gl_date :date
invoice_type :string(255)
jde_number :integer
line_offset :decimal(8, 2)
line_total :decimal(10, 2)
line_total_discounted :decimal(8, 2)
locked :boolean default(FALSE), not null
manual_tax_rate_goods :decimal(, )
manual_tax_rate_services :decimal(, )
manual_tax_rate_shipping :decimal(, )
old_line_total :decimal(8, 2)
old_shipping_cost :decimal(8, 2)
old_tax_total :decimal(8, 2)
old_total :decimal(8, 2)
po_number :string(255)
profit :decimal(8, 2) default(0.0)
profit_consolidated :decimal(8, 2) default(0.0)
recalculate_discounts :boolean default(FALSE), not null
reference_number :string(255) not null
remark :text
report_grouping :string(255)
revenue_consolidated :decimal(8, 2)
shipped_date :date
shipping_cost :decimal(8, 2)
shipping_coupon :decimal(8, 2)
sold_to_billing_address :integer
state :string(255)
tax_date :date
tax_exempt :boolean
tax_offset :decimal(8, 2)
tax_total :decimal(8, 2)
taxable_total :decimal(12, 2)
taxjar_state :string
terms :string(255)
total :decimal(10, 2)
transmission_state :string(255)
uploads_count :integer
created_at :datetime
updated_at :datetime
account_specialist_id :integer
billing_address_id :integer
billing_customer_id :integer
business_unit_id :integer
buying_group_id :integer
company_id :integer
creator_id :integer
customer_id :integer
delivery_id :integer
gl_offset_account_id :integer
local_sales_rep_id :integer
order_id :integer
primary_sales_rep_id :integer
profile_id :integer
resource_tax_rate_id :integer
secondary_sales_rep_id :integer
shipping_address_id :integer
source_id :integer
store_id :integer
technical_support_rep_id :integer
updater_id :integer

Indexes

idx_company_id_gl_date (company_id,gl_date)
idx_invoices_bob_report (gl_date,invoice_type,state,customer_id)
index_invoices_on_customer_id (customer_id)
index_invoices_on_delivery_id_unique (delivery_id) UNIQUE WHERE (delivery_id IS NOT NULL)
index_invoices_on_po_number (po_number)
index_invoices_on_po_number_tsearch (to_tsvector('english'::regconfig, COALESCE((po_number)::text, ''::text))) USING gin
index_invoices_on_reference_number (reference_number) UNIQUE
index_invoices_on_source_id (source_id)
index_invoices_on_state_and_transmission_state (state,transmission_state)
invoices_billing_address_id_idx (billing_address_id)
invoices_billing_customer_id_idx (billing_customer_id)
invoices_business_unit_id_idx (business_unit_id)
invoices_buying_group_id_idx (buying_group_id)
invoices_gl_offset_account_id_idx (gl_offset_account_id)
invoices_local_sales_rep_id_idx (local_sales_rep_id)
invoices_order_id_index (order_id)
invoices_primary_sales_rep_id_idx (primary_sales_rep_id)
invoices_profile_id_idx (profile_id)
invoices_secondary_sales_rep_id_idx (secondary_sales_rep_id)
invoices_shipped_date_idx (shipped_date)
invoices_shipping_address_id_idx (shipping_address_id)
invoices_store_id_idx (store_id)
invoices_technical_support_rep_id_idx (technical_support_rep_id)

Foreign Keys

fk_rails_... (technical_support_rep_id => parties.id)
invoices_billing_address_id_fk (billing_address_id => addresses.id)
invoices_billing_customer_id_fk (billing_customer_id => parties.id)
invoices_business_unit_id_fk (business_unit_id => business_units.id)
invoices_buying_group_id_fk (buying_group_id => buying_groups.id)
invoices_company_id_fk (company_id => companies.id)
invoices_customer_id_fk (customer_id => parties.id)
invoices_delivery_id_fk (delivery_id => deliveries.id)
invoices_gl_offset_account_id_fk (gl_offset_account_id => ledger_company_accounts.id)
invoices_local_sales_rep_id_fk (local_sales_rep_id => parties.id)
invoices_order_id_fk (order_id => orders.id)
invoices_primary_sales_rep_id_fk (primary_sales_rep_id => parties.id)
invoices_profile_id_fk (profile_id => profiles.id)
invoices_secondary_sales_rep_id_fk (secondary_sales_rep_id => parties.id)
invoices_shipping_address_id_fk (shipping_address_id => addresses.id)
invoices_store_id_fk (store_id => stores.id)